// SetSalary.cpp : implementation file
//

#include "stdafx.h"
#include "ylgl.h"
#include "SetSalary.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// SetSalary dialog
SetSalary::SetSalary(CWnd* pParent /*=NULL*/)
	: CDialog(SetSalary::IDD, pParent)
{
	//{{AFX_DATA_INIT(SetSalary)
	m_money = _T("");
	//}}AFX_DATA_INIT
}	

void SetSalary::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(SetSalary)
	DDX_Control(pDX, IDC_EDIT1, m_editnum);
	DDX_Text(pDX, IDC_EDIT1, m_money);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(SetSalary, CDialog)
	//{{AFX_MSG_MAP(SetSalary)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// SetSalary message handlers

BOOL SetSalary::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CString str;
	str.Format ("%s %d年-%d月 提成总额", name, year, month);
	SetDlgItemText(IDC_STATIC1, str);
	
	g_sendhead.bsql=0;
	g_sendhead.code[0]=85;
	g_sendhead.tabcount=1;
	CString filter;
	filter.Format ("[name]='%s' and [year]='%d' and [month]='%d'", name, year, month);
	g_pMainWnd->ProcessChatMessageRequest2(filter);
	if(g_bSendOK)
	{
		CArray<CStringArray, CStringArray>array;
		DataToArray(&array);
		if(array.GetSize ())
		{
			m_money=array.ElementAt (0).ElementAt (1);
			UpdateData(false);
		}
	}
	CenterWindow();
	return false;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void SetSalary::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	CString sql,temp;
	sql.Format("delete from salary where [name]='"+name+"' and [year]='%d' and [month]='%d'", year, month);
	temp.Format ("***insert into salary([name],[year],[month],[money])values('"+name+"','%d','%d','"+m_money+"')", year, month);
    sql+=temp;
	for(int i=0; i<pArray->GetSize (); i++)
	{
		if(selpos==1)
		   temp.Format ("***update dindan set [tichenren1]='%s/%d-%02d' where [id]='"+pArray->ElementAt (i)+"'", name, year, month);
		else if(selpos==2)
		   temp.Format ("***update dindan set [tichenren2]='%s/%d-%02d' where [id]='"+pArray->ElementAt (i)+"'", name, year, month);
		else if(selpos==3)
		   temp.Format ("***update dindan set [tichenren3]='%s/%d-%02d' where [id]='"+pArray->ElementAt (i)+"'", name, year, month);
		else if(selpos==4)
		   temp.Format ("***update dindan set [tichenren4]='%s/%d-%02d' where [id]='"+pArray->ElementAt (i)+"'", name, year, month);
		else if(selpos==5)
		   temp.Format ("***update dindan set [tichenren5]='%s/%d-%02d' where [id]='"+pArray->ElementAt (i)+"'", name, year, month);
		sql+=temp;
	}
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
	AfxMessageBox("保存成功!");
	CDialog::OnOK();
}