⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 dwagecollect.cpp

📁 一个有关人事系统的所有代码和有关文件包括里面小量数据库。
💻 CPP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
	{
		this->m_DepYear_Comfield.GetWindowText(sField);
		//判断查询字段的类型  
	if(m_DepYear_Comfield.m_CurrentFieldType=="数值型")
	{
		if(sEmblem=="LIKE"&&(sField.Find("本")>=0||sField.Find("发")>=0||sField.Find("费")>=0||sField.Find("扣除")>=0||sField.Find("贴")>=0||sField.Find("金额")>=0||sField.Find("税后")>=0||sField.Find("本")>=0))
		{
			MessageBox("相关费用不能用LIKE形式查询，请重新选择查询方式");
			return;
		}
		sSQL.Format("SELECT * FROM 部门工资年度汇总 WHERE %s %s %s",sField,sEmblem,sCondition);	
	}
	else
		if(m_DepYear_Comfield.m_CurrentFieldType=="字符型")
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 部门工资年度汇总 WHERE %s %s '%s'",sField,sEmblem,sCondition);	
			else
				sSQL.Format("SELECT * FROM 部门工资年度汇总 WHERE %s %s '%%%s%%'",sField,sEmblem,sCondition);	
		}
		else//日期
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 部门工资年度汇总 WHERE %s %s '%s'",sField,sEmblem,sCondition);
			else
				sSQL.Format("SELECT * FROM 部门工资年度汇总 WHERE %s %s '%%%s%%'",sField,sEmblem,sCondition);	
		
		}
		if(m_DepYear_Comfield.m_CurrentFieldType=="备注型")
			sSQL.Format("SELECT * FROM 部门工资年度汇总 WHERE %s LIKE '%%%s%%'",sField,sCondition);	

	rst.Open(sSQL,adCmdText);
	m_DepYear_Grid.AddCellValue(rst);
	}

	if(m_Text=="部门工资汇总")
	{
		this->m_Dep_Comfield.GetWindowText(sField);
		this->m_DateStart.GetTime(Starttime);
		this->m_DateEnd.GetTime(Endtime);
		stime=CTimeToCString(Starttime);
		syear=stime.Mid(0,4);
		smonth=stime.Mid(5,2);
		if(smonth.Find("-")>=0)
			smonth=stime.Mid(5,1);

		etime=CTimeToCString(Endtime);
		eyear=etime.Mid(0,4);
		emonth=etime.Mid(5,2);
		if(emonth.Find("-")>=0)
			emonth=etime.Mid(5,1);
		//判断查询字段的类型  
	if(m_Dep_Comfield.m_CurrentFieldType=="数值型")
	{
		if(sEmblem=="LIKE"&&(sField.Find("本")>=0||sField.Find("发")>=0||sField.Find("费")>=0||sField.Find("扣除")>=0||sField.Find("贴")>=0||sField.Find("金额")>=0||sField.Find("税后")>=0||sField.Find("本")>=0))
		{
			MessageBox("相关费用不能用LIKE形式查询，请重新选择查询方式");
			return;
		}
		sSQL.Format("SELECT * FROM 部门工资明细汇总 WHERE %s %s %s AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
	}
	else
		if(m_Dep_Comfield.m_CurrentFieldType=="字符型")
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 部门工资明细汇总 WHERE %s %s '%s' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
			else
				sSQL.Format("SELECT * FROM 部门工资明细汇总 WHERE %s %s '%%%s%%'  AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
		}
		else//日期
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 部门工资明细汇总 WHERE %s %s '%s' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);
			else
				sSQL.Format("SELECT * FROM 部门工资明细汇总 WHERE %s %s '%%%s%%' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
		
		}
		if(m_Dep_Comfield.m_CurrentFieldType=="备注型")
			sSQL.Format("SELECT * FROM 部门工资明细汇总 WHERE %s LIKE '%%%s%%' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sCondition,syear,eyear,smonth,emonth);	

	rst.Open(sSQL,adCmdText);
	m_Dep_Grid.AddCellValue(rst);
	}

	if(m_Text=="员工工资年度汇总")
	{
		this->m_StaffYear_Comfield.GetWindowText(sField);
		//判断查询字段的类型  
	if(m_StaffYear_Comfield.m_CurrentFieldType=="数值型")
	{
		if(sEmblem=="LIKE"&&(sField.Find("本")>=0||sField.Find("发")>=0||sField.Find("费")>=0||sField.Find("扣除")>=0||sField.Find("贴")>=0||sField.Find("金额")>=0||sField.Find("税后")>=0||sField.Find("本")>=0))
		{
			MessageBox("相关费用不能用LIKE形式查询，请重新选择查询方式");
			return;
		}
		sSQL.Format("SELECT * FROM 员工年度工资汇总 WHERE %s %s %s",sField,sEmblem,sCondition);	
	}
	else
		if(m_StaffYear_Comfield.m_CurrentFieldType=="字符型")
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 员工年度工资汇总 WHERE %s %s '%s'",sField,sEmblem,sCondition);	
			else
				sSQL.Format("SELECT * FROM 员工年度工资汇总 WHERE %s %s '%%%s%%'",sField,sEmblem,sCondition);	
		}
		else//日期
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 员工年度工资汇总 WHERE %s %s '%s'",sField,sEmblem,sCondition);
			else
				sSQL.Format("SELECT * FROM 员工年度工资汇总 WHERE %s %s '%%%s%%'",sField,sEmblem,sCondition);	
		
		}
		if(m_StaffYear_Comfield.m_CurrentFieldType=="备注型")
			sSQL.Format("SELECT * FROM 员工年度工资汇总 WHERE %s LIKE '%%%s%%'",sField,sCondition);	

	rst.Open(sSQL,adCmdText);
	m_StaffYear_Grid.AddCellValue(rst);
	}

	if(m_Text=="员工工资汇总")
	{
		this->m_DateStart.GetTime(Starttime);
		this->m_DateEnd.GetTime(Endtime);
		stime=CTimeToCString(Starttime);
		syear=stime.Mid(0,4);
		smonth=stime.Mid(5,2);
		if(smonth.Find("-")>=0)
			smonth=stime.Mid(5,1);

		etime=CTimeToCString(Endtime);
		eyear=etime.Mid(0,4);
		emonth=etime.Mid(5,2);
		if(emonth.Find("-")>=0)
			emonth=etime.Mid(5,1);
		this->m_Staff_Comfield.GetWindowText(sField);
		//判断查询字段的类型  
	if(m_Staff_Comfield.m_CurrentFieldType=="数值型")
	{
		if(sEmblem=="LIKE"&&(sField.Find("本")>=0||sField.Find("发")>=0||sField.Find("费")>=0||sField.Find("扣除")>=0||sField.Find("贴")>=0||sField.Find("金额")>=0||sField.Find("税后")>=0||sField.Find("本")>=0))
		{
			MessageBox("相关费用不能用LIKE形式查询，请重新选择查询方式");
			return;
		}
		sSQL.Format("SELECT * FROM 员工工资明细汇总 WHERE %s %s %s AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
	}
	else
		if(m_Staff_Comfield.m_CurrentFieldType=="字符型")
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 员工工资明细汇总 WHERE %s %s '%s' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
			else
				sSQL.Format("SELECT * FROM 员工工资明细汇总 WHERE %s %s '%%%s%%' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
		}
		else//日期
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 员工工资明细汇总 WHERE %s %s '%s' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);
			else
				sSQL.Format("SELECT * FROM 员工工资明细汇总 WHERE %s %s '%%%s%%' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
		
		}
		if(m_Staff_Comfield.m_CurrentFieldType=="备注型")
			sSQL.Format("SELECT * FROM 员工工资明细汇总 WHERE %s LIKE '%%%s%%' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 工资所属月份 BETWEEN '%s' AND '%s'",sField,sCondition,syear,eyear,smonth,emonth);	

	rst.Open(sSQL,adCmdText);
	m_Staff_Grid.AddCellValue(rst);
	}

	if(m_Text=="员工考勤信息汇总")
	{
		this->m_DateStart.GetTime(Starttime);
		this->m_DateEnd.GetTime(Endtime);
		stime=CTimeToCString(Starttime);
		syear=stime.Mid(0,4);
		smonth=stime.Mid(5,2);
		if(smonth.Find("-")>=0)
			smonth=stime.Mid(5,1);

		etime=CTimeToCString(Endtime);
		eyear=etime.Mid(0,4);
		emonth=etime.Mid(5,2);
		if(emonth.Find("-")>=0)
			emonth=etime.Mid(5,1);
		this->m_Attend_Comfield.GetWindowText(sField);
		//判断查询字段的类型  
	if(m_Attend_Comfield.m_CurrentFieldType=="数值型")
	{
		if(sEmblem=="LIKE"&&(sField.Find("本")>=0||sField.Find("发")>=0||sField.Find("费")>=0||sField.Find("扣除")>=0||sField.Find("贴")>=0||sField.Find("金额")>=0||sField.Find("税后")>=0||sField.Find("本")>=0))
		{
			MessageBox("相关费用不能用LIKE形式查询，请重新选择查询方式");
			return;
		}
		sSQL.Format("SELECT * FROM 员工考勤视图 WHERE %s %s %s AND 考勤年份 BETWEEN '%s' AND '%s' AND 考勤月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
	}
	else
		if(m_Attend_Comfield.m_CurrentFieldType=="字符型")
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 员工考勤视图 WHERE %s %s '%s' AND 考勤年份 BETWEEN '%s' AND '%s' AND 考勤月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
			else
				sSQL.Format("SELECT * FROM 员工考勤视图 WHERE %s %s '%%%s%%' AND 考勤年份 BETWEEN '%s' AND '%s' AND 考勤月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
		}
		else//日期
		{
			if(sEmblem!="LIKE")
				sSQL.Format("SELECT * FROM 员工考勤视图 WHERE %s %s '%s' AND 考勤年份 BETWEEN '%s' AND '%s' AND 考勤月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);
			else
				sSQL.Format("SELECT * FROM 员工考勤视图 WHERE %s %s '%%%s%%' AND 考勤年份 BETWEEN '%s' AND '%s' AND 考勤月份 BETWEEN '%s' AND '%s'",sField,sEmblem,sCondition,syear,eyear,smonth,emonth);	
		
		}
		if(m_Attend_Comfield.m_CurrentFieldType=="备注型")
			sSQL.Format("SELECT * FROM 员工考勤视图 WHERE %s LIKE '%%%s%%' AND 工资所属年份 BETWEEN '%s' AND '%s' AND 考勤月份 BETWEEN '%s' AND '%s'",sField,sCondition,syear,eyear,smonth,emonth);	

	rst.Open(sSQL,adCmdText);
	m_Attend_Grid.AddCellValue(rst);
	}
}

void CDWagecollect::OnBtnPrint() 
{
	// TODO: Add your control notification handler code here
	CString sCount;
	m_ps.MainCaptionFontSize=400;
	m_ps.DeckCaptionFontSize=180;
	if(m_Text.IsEmpty())
		m_Text="部门工资年度汇总";
	if(m_Text=="部门工资年度汇总")
	{
		RxRecordset brst;
		CString sName,stime;
		CTime ttime;
		brst.Open("部门工资年度汇总");
		sName="部门工资年度汇总";
		
		ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.MainCaption=sName;
		m_ps.DeckCaptionNumber=2;
		ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.DeckCaptionFontSize=180;
		m_ps.MainCaptionFontSize=400;
		m_ps.DeckCaptions[0]="日期："+stime;
		m_ps.DeckCaptions[1]="操作员:"+OP;

		sCount.Format("%d",brst.GetRecordCount());
		m_ps.MainCaption=m_Text;
		m_ps.TotalNumber=1;
		m_ps.Totals[0]="共计 "+sCount+" 条记录";
		m_ps.Totals[1]="";
		m_ps.Grid=&m_DepYear_Grid;
	}

	if(m_Text=="部门工资汇总")
	{
		RxRecordset brst;
		CString sName,stime;
		CTime ttime;
		brst.Open("部门工资明细汇总");
		sName="部门工资明细汇总";
			
			ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.MainCaption=sName;
		m_ps.DeckCaptionNumber=2;
		ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.DeckCaptionFontSize=180;
		m_ps.MainCaptionFontSize=400;
		m_ps.DeckCaptions[0]="日期："+stime;
		m_ps.DeckCaptions[1]="操作员:"+OP;

		sCount.Format("%d",brst.GetRecordCount());
		m_ps.MainCaption=m_Text;
		m_ps.TotalNumber=1;
		m_ps.Totals[0]="共计 "+sCount+" 条记录";
		m_ps.Totals[1]="";
		m_ps.Grid=&m_Dep_Grid;
	}

	if(m_Text=="员工工资年度汇总")
	{
			RxRecordset brst;
		CString sName,stime;
		CTime ttime;
		brst.Open("员工年度工资汇总");
		sName="员工年度工资汇总";
		
		ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.MainCaption=sName;
		m_ps.DeckCaptionNumber=2;
		ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.DeckCaptionFontSize=180;
		m_ps.MainCaptionFontSize=400;
		m_ps.DeckCaptions[0]="日期："+stime;
		m_ps.DeckCaptions[1]="操作员:"+OP;

		sCount.Format("%d",brst.GetRecordCount());
		m_ps.MainCaption=m_Text;
		m_ps.TotalNumber=1;
		m_ps.Totals[0]="共计 "+sCount+" 条记录";
		m_ps.Totals[1]="";
		m_ps.Grid=&m_StaffYear_Grid;
	}

	if(m_Text=="员工工资汇总")
	{
			RxRecordset brst;
		CString sName,stime;
		CTime ttime;
		brst.Open("员工工资明细汇总");
		sName="员工工资明细汇总";
		
		ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.MainCaption=sName;
		m_ps.DeckCaptionNumber=2;
		ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.DeckCaptionFontSize=180;
		m_ps.MainCaptionFontSize=400;
		m_ps.DeckCaptions[0]="日期："+stime;
		m_ps.DeckCaptions[1]="操作员:"+OP;

		sCount.Format("%d",brst.GetRecordCount());
		m_ps.MainCaption=m_Text;
		m_ps.TotalNumber=1;
		m_ps.Totals[0]="共计 "+sCount+" 条记录";
		m_ps.Totals[1]="";
		m_ps.Grid=&m_Staff_Grid;
	}

	if(m_Text=="员工考勤信息汇总")
	{
		RxRecordset brst;
		CString sName,stime;
		CTime ttime;
		brst.Open("员工考勤视图");
		sName="员工考勤视图";
		
		ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.MainCaption=sName;
		m_ps.DeckCaptionNumber=2;
		ttime=ttime.GetCurrentTime();
		stime=CTimeToCString(ttime);
		m_ps.DeckCaptionFontSize=180;
		m_ps.MainCaptionFontSize=400;
		m_ps.DeckCaptions[0]="日期："+stime;
		m_ps.DeckCaptions[1]="操作员:"+OP;

		sCount.Format("%d",brst.GetRecordCount());
		m_ps.MainCaption=m_Text;
		m_ps.TotalNumber=1;
		m_ps.Totals[0]="共计 "+sCount+" 条记录";
		m_ps.Totals[1]="";
		m_ps.Grid=&m_Attend_Grid;
	}
	
	theApp.Print();	
}

void CDWagecollect::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 CDWagecollect::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;
}
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -