cincentiveinfo.cpp

一个有关人事系统的所有代码和有关文件包括里面小量数据库。

		MessageBox("您输入的用户名不存在！请重新输入！","系统提示",MB_OK|MB_ICONSTOP);
		m_EdtSname.SetWindowText("");
		m_EdtSname.SetFocus();
		return;
	}

	text1=namest.GetFieldValue("Staff_ID");
	if(text1!=SID)
	{
		MessageBox("您输入的用户名与用户编号不匹配！请重新输入！","系统提示",MB_OK|MB_ICONSTOP);
		m_EdtSID.SetWindowText("");
		m_EdtSID.SetFocus();
		return;
	}
	man=manst.GetFieldValue("Staff_name");
	if(passName!=man)
	{
		MessageBox("您输入的批准人不存在或者批准人的职务必须是批准部门主管以上职务！请重新输入！","系统提示",MB_OK|MB_ICONSTOP);
		m_EdtpassName.SetWindowText("");
		m_EdtpassName.SetFocus();
		return;
	}

	CString sSQL;
	if(AddOrChange==1)//添加操作
		sSQL.Format("Insert Into IncentiveInfo Values('%s','%s','%s','%s','%s','%s','%s',%s,%s,'%s','%s','%s','%s','%s','%s')",JCID,Sname,SID,Ctype,JCitem,Clevel,reason,money,CFmoney,timeJC,Dateyear,Datemonth,passDept,passName,remark);
	else
		sSQL.Format("Update IncentiveInfo set Staff_name='%s',Staff_ID='%s',\
		Incentive_type='%s',Incentive_Item='%s',Incentive_level='%s',Incentive_cause='%s',\
		Incentive_money=%s,Incentive_mulct=%s,Incentive_date='%s',Incentive_year='%s',Incentive_month='%s',Approval_dep='%s',\
		Approval_man='%s',Remarks='%s' WHERE Incentive_ID='%s'",Sname,SID,Ctype,JCitem,\
		Clevel,reason,money,CFmoney,timeJC,Dateyear,Datemonth,passDept,passName,remark,JCID);
	RxRecordset arst;
	arst.Open(sSQL,adCmdText);
	this->ButtonEnabled(false);
	this->m_add.SetFocus();
}

BOOL CCIncentiveInfo::OnInitDialog() //窗口初始化081004XLW
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CDBaseQuery* ParentWnd=(CDBaseQuery*)FindWindow(NULL,"员工奖惩基本信息");
	m_sID=ParentWnd->m_Grid.GetItemText(ParentWnd->m_Grid.GetRow(),0);
	RxRecordset rs,ts;
	rs.Open("部门视图");
    m_Comdept.SetRecordset(rs,"部门名称");
	m_ComPassdept.SetRecordset(rs,"部门名称");
	m_Comstaffdep.SetRecordset(rs,"部门名称");
	ts.Open("select 部门名称 from 部门视图");
	m_Comdept.SetFieldset(ts);
	m_ComPassdept.SetFieldset(ts);
	m_Comstaffdep.SetFieldset(ts);
	m_Comstaffdep.SelectString(0,"所有部门");

	m_Sql_Grid.ReadOnly(true);
	m_Sql_Grid.SetDataBase("员工查询视图",adCmdTable);
	this->m_Comdept.m_CurrentFieldType="字符型";
	this->m_ComPassdept.m_CurrentFieldType="字符型";
	this->DisPlayInfo(m_sID);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCIncentiveInfo::DisPlayInfo(CString sID)//窗口初始化081004XLW
{
	RxRecordset drxt;
 	CString sSQL;
 	if(sID.IsEmpty())
 		return;
 	sSQL.Format("SELECT * FROM 员工奖惩视图 WHERE 奖惩编号 ='%s'",sID);
 	drxt.Open(sSQL,adCmdText);
	//////////////////////
	CString JCID,JCitem,SID,Dyear,Dmonth,Datetime,Sname,reason,remark,money,CFmoney,dept,Clevel,Ctype,passDept,passName,timeJC;
	JCID=drxt.GetFieldValue("奖惩编号");//
	JCitem=drxt.GetFieldValue("奖惩项目");//
	SID=drxt.GetFieldValue("员工编号");//
	Sname=drxt.GetFieldValue("员工姓名");//
	reason=drxt.GetFieldValue("奖惩原因");//
	remark=drxt.GetFieldValue("备注");//
	money=drxt.GetFieldValue("奖励金额");//
	CFmoney=drxt.GetFieldValue("处罚金额");//
	dept=drxt.GetFieldValue("部门");//
	Clevel=drxt.GetFieldValue("奖惩级别");//
	Ctype=drxt.GetFieldValue("奖惩类型");//
	passDept=drxt.GetFieldValue("批准部门");//
	passName=drxt.GetFieldValue("批准人");//
	timeJC=drxt.GetFieldValue("奖惩日期");//
	Dyear=drxt.GetFieldValue("奖惩年份");
	Dmonth=drxt.GetFieldValue("奖惩月份");
	Datetime=Dyear+'-'+Dmonth+"-27";
	CTime Itime;
	Itime=CStringTOCTime(Datetime);
	m_DateInc.SetTime(&Itime);
	//////////////////
	m_EdtJCID.SetWindowText(JCID);
	m_EdtJCitem.SetWindowText(JCitem);
	m_EdtSID.SetWindowText(SID);
	m_EdtSname.SetWindowText(Sname);
	m_Comdept.SetWindowText(dept);
	m_ComPassdept.SetWindowText(passDept);
	m_EdtpassName.SetWindowText(passName);
	m_Edtreason.SetWindowText(reason);
	m_Edtmoney.SetWindowText(money);
	m_EdtCFmoney.SetWindowText(CFmoney);
	m_Edtremark.SetWindowText(remark);
	////////////////////
	CTime time;
	time=CStringTOCTime(timeJC);
	m_TimeJC.SetTime(&time);
	/////////////////////
    m_ComboLevel.SetWindowText(Clevel);
	m_ComboType.SetWindowText(Ctype);

	m_EdtJCID.SetColour(RGB(0,0,0));//设置编辑框边框颜色
	m_EdtJCitem.SetColour(RGB(0,0,0));
	m_EdtSID.SetColour(RGB(0,0,0));
	m_EdtSname.SetColour(RGB(0,0,0));

	m_EdtpassName.SetColour(RGB(0,0,0));
	m_Edtreason.SetColour(RGB(0,0,0));
	m_Edtmoney.SetColour(RGB(0,0,0));
	m_EdtCFmoney.SetColour(RGB(0,0,0));
	m_Edtremark.SetColour(RGB(0,0,0));

}

void CCIncentiveInfo::ClearEdit()//清空文本内容
{

	m_EdtJCitem.SetWindowText("");
	m_EdtSID.SetWindowText("");
	m_EdtSname.SetWindowText("");
	m_EdtpassName.SetWindowText("");
	m_Edtreason.SetWindowText("");
	m_Edtmoney.SetWindowText("");
	m_EdtCFmoney.SetWindowText("");
	m_Edtremark.SetWindowText("");

}

void CCIncentiveInfo::OnPaint() 
{
	CPaintDC dc(this); // device context for painting
	
	// TODO: Add your message handler code here
	CRect rect;
		CBitmap bit;
		CDC memDC;
		this->GetClientRect(&rect);
		bit.LoadBitmap(IDB_BIT_BJ);
		memDC.CreateCompatibleDC(&dc);
		memDC.SelectObject(&bit);
		dc.BitBlt(0,0,rect.Width(),rect.Height(),&memDC,0,0,SRCCOPY);
		memDC.DeleteDC();
		::DeleteObject(&bit);	
		CDialog::OnPaint();
	// Do not call CDialog::OnPaint() for painting messages
}

HBRUSH CCIncentiveInfo::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) //界面颜色设置函数
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
	// TODO: Change any attributes of the DC here
		if(nCtlColor==CTLCOLOR_STATIC)
	{
		pDC->SetBkColor(RGB(255,255,255));
		pDC->SetTextColor(RGB(0,0,0));

	}
	// TODO: Return a different brush if the default is not desired
	return hbr;
}

void CCIncentiveInfo::ButtonEnabled(bool bEnabled)
{
	m_DateInc.EnableWindow(bEnabled);
	m_EdtJCitem.EnableWindow(bEnabled);
	m_EdtSID.EnableWindow(bEnabled);
	m_EdtSname.EnableWindow(bEnabled);
	m_Comdept.EnableWindow(bEnabled);
	m_ComPassdept.EnableWindow(bEnabled);
	m_EdtpassName.EnableWindow(bEnabled);
	m_Edtreason.EnableWindow(bEnabled);
	m_Edtmoney.EnableWindow(bEnabled);
	m_EdtCFmoney.EnableWindow(bEnabled);
	m_Edtremark.EnableWindow(bEnabled);
	m_ComboLevel.EnableWindow(bEnabled);
	m_ComboType.EnableWindow(bEnabled);
	m_TimeJC.EnableWindow(bEnabled);
	m_EdtstaffID.EnableWindow(bEnabled);
	m_Edtstaffname.EnableWindow(bEnabled);
	m_Comstaffdep.EnableWindow(bEnabled);
	m_Sql_Grid.EnableWindow(bEnabled);

	m_add.EnableWindow(!bEnabled);
	m_change.EnableWindow(!bEnabled);
	m_delete.EnableWindow(!bEnabled);
	m_exit.EnableWindow(!bEnabled);
	m_save.EnableWindow(bEnabled);
	m_undo.EnableWindow(bEnabled);

}

void CCIncentiveInfo::OnBtnsel() 
{
	// TODO: Add your control notification handler code here
	CString sSQL,sName,sSID,sSdep;
	this->m_Edtstaffname.GetWindowText(sName);
	this->m_EdtstaffID.GetWindowText(sSID);
	this->m_Comstaffdep.GetWindowText(sSdep);
	if(sSdep=="所有部门")
	{
	if(sName.IsEmpty() && sSID.IsEmpty())
			sSQL.Format("SELECT * FROM 员工查询视图");

	    if(!sName.IsEmpty())
		{
			if(sSID.IsEmpty())
			sSQL.Format("SELECT * FROM 员工查询视图 where 姓名 LIKE '%%%s%%'",sName);
			else
				sSQL.Format("SELECT * FROM 员工查询视图 where 编号 LIKE '%%%s%%' OR 姓名 LIKE '%%%s%%'",sSID,sName);
		}
		else
		{
			if(!sSID.IsEmpty())
				sSQL.Format("SELECT * FROM 员工查询视图 where 编号 LIKE '%%%s%%'",sSID);
		}
	}
	
	if(sSdep!="所有部门")
	{
		if(sName.IsEmpty() && sSID.IsEmpty())
			sSQL.Format("SELECT * FROM 员工查询视图 where 部门='%s'",sSdep);
		if(!sName.IsEmpty())
		{
			if(sSID.IsEmpty())
			sSQL.Format("SELECT * FROM 员工查询视图 where 姓名 LIKE '%%%s%%' AND 部门='%s'",sName,sSdep);
			else
				sSQL.Format("SELECT * FROM 员工查询视图 where 编号 LIKE '%%%s%%' OR 姓名 LIKE '%%%s%%' AND 部门='%s'",sSID,sName,sSdep);
		}
		else
		{
			if(!sSID.IsEmpty())
				sSQL.Format("SELECT * FROM 员工查询视图 where 编号 LIKE '%%%s%%' AND 部门='%s'",sSID,sSdep);
		}
	}
	RxRecordset rRst;
	rRst.Open(sSQL,adCmdText);
	m_Sql_Grid.AddCellValue(rRst);
}

void CCIncentiveInfo::OnDblclkListGrid(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	RxRecordset rRst;
	CString sSql,sname,sID,sdep;
	if(m_Sql_Grid.GetHotItem()<0)
		return;
	m_tID=this->m_Sql_Grid.GetItemText(m_Sql_Grid.GetHotItem(),0);
	sSql.Format("SELECT * FROM 员工查询视图 WHERE 编号='%s'",m_tID);
	rRst.Open(sSql,adCmdText);
	sID=rRst.GetFieldValue("编号");
	sname=rRst.GetFieldValue("姓名");
	sdep=rRst.GetFieldValue("部门");
	
	m_EdtSID.SetWindowText(sID);
	m_EdtSname.SetWindowText(sname);
	m_Comdept.SetWindowText(sdep);

	*pResult = 0;
}