lyfz_repos/经典版源码/document/其他文档/工资计算试.cpp

1、原工资计算方式：
CString strSQL;
CString strStaff;		// 职工;
CString strStartDate;	// 开始日期;
CString strEndofDate;	// 结束日期;

strStaff = _T("张三");
strStartDate = _T("2015-11-10");
strEndofDate = _T("2015-12-10");

case 34: 	renyuan;
	// 查找出该姓名的在职职员;
	strSQL.Format(_T("select * from renyuan where name = '%s' and dimission = '在职'"), strStaff);
case 59: 	dindanbukuanview;
	// 查找出指定日期内的所有补款;
	strSQL.Format(_T("select * from dindanbukuanview where [date] >= '%s' and [date] <= '%s' "), strStartDate, strEndofDate);
case 60: 	dindan;
	// 获取全部订单信息,以便从中筛选出该职员的工作;
	strSQL = T("select * from dindan"));
case 198:	singleincomemeneyview;
	// 获取该职员的其他收入;
	strSQL.Format(_T("select * from singleincomemeneyview where [date] >= '%s' and [date] <= '%s' and renyuan3 = '%s'"), strStartDate, strEndofDate, strStaff);
case 61:	dindan && dindanbukuan;
	// 获取指定拍照OK日期的订单;
	strSQL.Format(_T("select * from dindan where time2 >= '%s' and time2 = '%s' and status = 'OK'"), strStartDate, strEndofDate);
	// 获取补款小于开始日期的全部补款;
	strSQL.Format(_T("select * from dindanbukuan where [date] < '%s'"), strStartDate);
case 142:	dindan && mywork;
	// 获取职员在指定工作安排日期的全部订单信息;
	strSQL.Format(_T("select * from dindan where datetime >= '%s' and datetime <= '%s' and name = '%s'"), strStartDate, strEndofDate, strStaff);
	// 获取职员的全部工作信息;
	strSQL.Format(_T("select * from mywork where datetime >= '%s' and datetime <= '%s' and name = '%s'"), strStartDate, strEndofDate, strStaff);
case 192:	dindan && dindanjd;
	// 获取拍照OK的全部订单信息;
	strSQL.Format(_T("select * from dindan where [date] >= '%s' and [date] <= '%s' and status = 'OK' and (waiter1 = '%s' or waiter12 = '%s' or waiter2 = '%s' or waiter22 = '%s')"), 
				  strStartDate, strEndofDate, strStaff, strStaff, strStaff, strStaff);
	strSQL.Format(_T("select * from dindanjd where [date] >= '%s' and [date] <= '%s' and status = 'OK' and (waiter1 = '%s' or waiter12 = '%s' or waiter2 = '%s' or waiter22 = '%s')"), 
				  strStartDate, strEndofDate, strStaff, strStaff, strStaff, strStaff);
case 193:	digitalview;
	// 获取数码工作信息;
	strSQL.Format(_T("select * from digitalview where (time8 >= '%s' and time8 <= '%s' and status4 = 'OK' and waiter5 = '%s') or\
					(time9 >= '%s' and time9 <= '%s' and status6 = 'OK' and waiter7 = '%s') or \
					(time10 >= '%s' and time10 <= '%s' and status5 = 'OK' and waiter4 = '%s')"),
					strStartDate, strEndofDate, strStaff, strStartDate, strEndofDate, strStaff, strStartDate, strEndofDate, strStaff);

					


2、工资计算函数;
/************************************************************************/
/* 
	函数：GetStaffWage
	描述：获取职员指定时间内的工资;
	参数： 
	    [IN]	lpStaff 职员;
		[IN]	lpStartDate 计算工资的开始日期;
		[IN]	lpEndofDate 计算工资的结束日期;
	返回：空
*/
/************************************************************************/
VOID GetStaffWage(IN LPCTSTR lpStaff, IN LPCTSTR lpStartDate, IN LPCTSTR lpEndofDate)
{
	
}