jobinfo.cpp

一个空调安装工工资计算

	{
	
       str.Format("%d",Item+1);
	   id.Format("%d",i+1);
       int iPos=m_job.InsertItem(Item,str);
       m_job.SetItemText(iPos,0,id);
	   m_job.SetItemText(iPos,1,GetFieldValue("安装工1"));
       m_job.SetItemText(iPos,2,GetFieldValue("安装工2"));
       m_job.SetItemText(iPos,3,GetFieldValue("发票号"));
       m_job.SetItemText(iPos,4,GetFieldValue("空调品牌"));
       m_job.SetItemText(iPos,5,GetFieldValue("空调匹次"));
       m_job.SetItemText(iPos,6,GetFieldValue("所属商场"));
       m_job.SetItemText(iPos,7,GetFieldValue("安装日期"));
	   Item++;
	   rst->MoveNext();
	}

	str.Format("【本系统现有业务记录共 %d 条】\n【当前显示条第 %d 条至 第 %d 条记录】",theApp.GetRecordCount(rst),adress+1,i);
	m_tongji=str;
	UpdateData(FALSE);

    GetDlgItem(IDC_NEXT_BUT)->EnableWindow(TRUE);
	GetDlgItem(IDC_LAST_BUT)->EnableWindow(TRUE);
	if(nowpage==1)
	{
        GetDlgItem(IDC_FIRST_BUT)->EnableWindow(FALSE);
	    GetDlgItem(IDC_PREVIOUS_BUT)->EnableWindow(FALSE);
	}
}

void CJobinfo::OnLastBut() 
{
	nowpage=page;
	CString str,id;
	m_job.DeleteAllItems();
	rst.CreateInstance(__uuidof(Recordset));
    rst=cnn->Execute("员工业务表",NULL,adCmdTable);
	int adress=(nowpage-1)*20;
	int Item=0;
	rst->Move(adress);
    for(int i=adress;!rst->_EOF;i++)
	{
	
       str.Format("%d",Item+1);
	   id.Format("%d",i+1);
       int iPos=m_job.InsertItem(Item,str);
	   m_job.SetItemText(iPos,0,id);      
	   m_job.SetItemText(iPos,1,GetFieldValue("安装工1"));
       m_job.SetItemText(iPos,2,GetFieldValue("安装工2"));
       m_job.SetItemText(iPos,3,GetFieldValue("发票号"));
       m_job.SetItemText(iPos,4,GetFieldValue("空调品牌"));
       m_job.SetItemText(iPos,5,GetFieldValue("空调匹次"));
       m_job.SetItemText(iPos,6,GetFieldValue("所属商场"));
       m_job.SetItemText(iPos,7,GetFieldValue("安装日期"));
	   Item++;
	   rst->MoveNext();
	}

	str.Format("【本系统现有业务记录共 %d 条】\n【当前显示条第 %d 条至 第 %d 条记录】",theApp.GetRecordCount(rst),adress+1,i);
	m_tongji=str;
	UpdateData(FALSE);

    GetDlgItem(IDC_NEXT_BUT)->EnableWindow(FALSE);
	GetDlgItem(IDC_LAST_BUT)->EnableWindow(FALSE);
    GetDlgItem(IDC_FIRST_BUT)->EnableWindow(TRUE);
	GetDlgItem(IDC_PREVIOUS_BUT)->EnableWindow(TRUE);

}

void CJobinfo::OnFindBut() 
{
    GetDlgItem(IDC_NEXT_BUT)->ShowWindow(FALSE);
	GetDlgItem(IDC_LAST_BUT)->ShowWindow(FALSE);
    GetDlgItem(IDC_FIRST_BUT)->ShowWindow(FALSE);
	GetDlgItem(IDC_PREVIOUS_BUT)->ShowWindow(FALSE);

    GetDlgItem(IDC_NEXT_BUT2)->ShowWindow(TRUE);
	GetDlgItem(IDC_LAST_BUT2)->ShowWindow(TRUE);
    GetDlgItem(IDC_FIRST_BUT2)->ShowWindow(TRUE);
	GetDlgItem(IDC_PREVIOUS_BUT2)->ShowWindow(TRUE);

   	m_job.DeleteAllItems();
	CString sSQL,CellText,str;
	rst.CreateInstance(__uuidof(Recordset));
    rst=cnn->Execute("员工业务表",NULL,adCmdTable);
	UpdateData(TRUE);
	if(m_tiaojian==-1)
	{
		AfxMessageBox("请选择查询条件!");
		return;
	}
	if(m_neirong=="")
	{
		AfxMessageBox("请输入查询内容!");
		return;
	}
	switch(m_tiaojian)
	{
	     case 0:
               sSQL.Format("SELECT * from 员工业务表 WHERE 安装工1 LIKE '%s%%' or 安装工2 LIKE '%s%%'",m_neirong,m_neirong);
              break;
		 case 1:
                sSQL.Format("SELECT * from 员工业务表 WHERE 发票号 LIKE '%s%%'",m_neirong);
			 break;
		 case 2:
                sSQL.Format("SELECT * from 员工业务表 WHERE 所属商场 LIKE '%s%%'",m_neirong);
			 break;
		 case 3:
                sSQL.Format("SELECT * from 员工业务表 WHERE 安装日期 LIKE '%s%%'",m_neirong);
             break;
			
	}
	rst=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
	int nCount=cx_jieguo=theApp.GetRecordCount(rst);


	int nPage;
	nPage=nCount/20;
	if(nCount>20)
	{
         if(nPage==0)
	     	cx_page=1;
         if(nCount%20!=0)
	        cx_page=nPage+1;
	}
	else
		cx_page=1;


    cx_nowpage=1;
  if(cx_page==1)
  {
    GetDlgItem(IDC_FIRST_BUT2)->EnableWindow(FALSE);
	GetDlgItem(IDC_PREVIOUS_BUT2)->EnableWindow(FALSE);
	GetDlgItem(IDC_NEXT_BUT2)->EnableWindow(FALSE);
	GetDlgItem(IDC_LAST_BUT2)->EnableWindow(FALSE);
  }
  else
  {
	 GetDlgItem(IDC_FIRST_BUT2)->EnableWindow(FALSE);
	GetDlgItem(IDC_PREVIOUS_BUT2)->EnableWindow(FALSE);
	GetDlgItem(IDC_NEXT_BUT2)->EnableWindow(TRUE);
	GetDlgItem(IDC_LAST_BUT2)->EnableWindow(TRUE);
  }
 

	for(int i=0;i<nCount;i++)
	{
		rst->MoveFirst();
		rst->Move(i);
		if(i==20)
			goto End;
       str.Format("%d",i+1);
       int iPos=m_job.InsertItem(i,str);
	   m_job.SetItemText(iPos,0,str);
	   m_job.SetItemText(iPos,1,GetFieldValue("安装工1"));
       m_job.SetItemText(iPos,2,GetFieldValue("安装工2"));
       m_job.SetItemText(iPos,3,GetFieldValue("发票号"));
       m_job.SetItemText(iPos,4,GetFieldValue("空调品牌"));
       m_job.SetItemText(iPos,5,GetFieldValue("空调匹次"));
       m_job.SetItemText(iPos,6,GetFieldValue("所属商场"));
       m_job.SetItemText(iPos,7,GetFieldValue("安装日期"));
	}
End:
	str.Format("【符合条件的记录有 %d 条】\n【当前显示第 1 条至第 %d 条记录】",nCount,i);
	 m_tongji=str;
	 UpdateData(FALSE);
}

void CJobinfo::OnFirstBut2() 
{
   m_job.DeleteAllItems();
   cx_nowpage=1;
   CString str,CellText;
   rst->MoveFirst();
   for(int i=0;!rst->_EOF;i++)
	{
		if(i==20)
			goto End;
	   rst->MoveFirst();
	   rst->Move(i);
       str.Format("%d",i+1);
       int iPos=m_job.InsertItem(i,str);
       m_job.SetItemText(iPos,0,str);
	   m_job.SetItemText(iPos,1,GetFieldValue("安装工1"));
       m_job.SetItemText(iPos,2,GetFieldValue("安装工2"));
       m_job.SetItemText(iPos,3,GetFieldValue("发票号"));
       m_job.SetItemText(iPos,4,GetFieldValue("空调品牌"));
       m_job.SetItemText(iPos,5,GetFieldValue("空调匹次"));
       m_job.SetItemText(iPos,6,GetFieldValue("所属商场"));
       m_job.SetItemText(iPos,7,GetFieldValue("安装日期"));
	   rst->MoveNext();
	}


End:
	str.Format("【符合条件的记录有 %d 条】\n【当前显示第 1 条至第 %d 条记录】",cx_jieguo,i);
    m_tongji=str;
    UpdateData(FALSE);
    GetDlgItem(IDC_FIRST_BUT2)->EnableWindow(FALSE);
	GetDlgItem(IDC_PREVIOUS_BUT2)->EnableWindow(FALSE);
	GetDlgItem(IDC_NEXT_BUT2)->EnableWindow(TRUE);
	GetDlgItem(IDC_LAST_BUT2)->EnableWindow(TRUE);
}

void CJobinfo::OnPreviousBut2() 
{
    CString str,id;
	m_job.DeleteAllItems();
	int Item=0;
	cx_nowpage--;
	rst->MoveFirst();
    for(int i=(cx_nowpage-1)*20;!rst->_EOF;i++)
	{
	   if(Item==20)
		   goto End;
	   rst->MoveFirst();
	   rst->Move(i);
       str.Format("%d",Item+1);
	   id.Format("%d",i+1);
       int iPos=m_job.InsertItem(Item,str);
	   m_job.SetItemText(iPos,0,id);
	   m_job.SetItemText(iPos,1,GetFieldValue("安装工1"));
       m_job.SetItemText(iPos,2,GetFieldValue("安装工2"));
       m_job.SetItemText(iPos,3,GetFieldValue("发票号"));
       m_job.SetItemText(iPos,4,GetFieldValue("空调品牌"));
       m_job.SetItemText(iPos,5,GetFieldValue("空调匹次"));
       m_job.SetItemText(iPos,6,GetFieldValue("所属商场"));
       m_job.SetItemText(iPos,7,GetFieldValue("安装日期"));
	   Item++;
	   rst->MoveNext();
	}
End:
	str.Format("【符合条件的记录共 %d 条】\n【当前显示条第 %d 条至 第 %d 条记录】",cx_jieguo,(cx_nowpage-1)*20+1,i);
    m_tongji=str;
	UpdateData(FALSE);
	if(cx_nowpage==1)
	{
	   GetDlgItem(IDC_FIRST_BUT2)->EnableWindow(FALSE);
	   GetDlgItem(IDC_PREVIOUS_BUT2)->EnableWindow(FALSE);

	}
	GetDlgItem(IDC_NEXT_BUT2)->EnableWindow(TRUE);
	GetDlgItem(IDC_LAST_BUT2)->EnableWindow(TRUE);
	
}

void CJobinfo::OnNextBut2() 
{
    CString str,id;
	m_job.DeleteAllItems();
	int Item=0;
	rst->MoveFirst();
    for(int i=cx_nowpage*20;!rst->_EOF;i++)
	{
	   if(Item==20)
		   goto End;
	   rst->MoveFirst();
	   rst->Move(i);
       str.Format("%d",Item+1);
	   id.Format("%d",i+1);
       int iPos=m_job.InsertItem(Item,str);
	   m_job.SetItemText(iPos,0,id);
	   m_job.SetItemText(iPos,1,GetFieldValue("安装工1"));
       m_job.SetItemText(iPos,2,GetFieldValue("安装工2"));
       m_job.SetItemText(iPos,3,GetFieldValue("发票号"));
       m_job.SetItemText(iPos,4,GetFieldValue("空调品牌"));
       m_job.SetItemText(iPos,5,GetFieldValue("空调匹次"));
       m_job.SetItemText(iPos,6,GetFieldValue("所属商场"));
       m_job.SetItemText(iPos,7,GetFieldValue("安装日期"));
	   Item++;
	   rst->MoveNext();
	}
End:
	str.Format("【符合条件的记录共 %d 条】\n【当前显示条第 %d 条至 第 %d 条记录】",cx_jieguo,cx_nowpage*20+1,i);
    m_tongji=str;
	UpdateData(FALSE);
	cx_nowpage++;
	if(cx_nowpage==cx_page)
	{
	   GetDlgItem(IDC_FIRST_BUT2)->EnableWindow(TRUE);
	   GetDlgItem(IDC_PREVIOUS_BUT2)->EnableWindow(TRUE);
	   GetDlgItem(IDC_NEXT_BUT2)->EnableWindow(FALSE);
	   GetDlgItem(IDC_LAST_BUT2)->EnableWindow(FALSE);
	}
}

void CJobinfo::OnLastBut2() 
{
	cx_nowpage=cx_page;
    CString str,id;
	m_job.DeleteAllItems();
	int Item=0;
	rst->MoveFirst();
    for(int i=(cx_nowpage-1)*20;!rst->_EOF;i++)
	{
	   if(Item==20)
		   goto End;
	   rst->MoveFirst();
	   rst->Move(i);
       str.Format("%d",Item+1);
	   id.Format("%d",i+1);
       int iPos=m_job.InsertItem(Item,str);
	   m_job.SetItemText(iPos,0,id);
	   m_job.SetItemText(iPos,1,GetFieldValue("安装工1"));
       m_job.SetItemText(iPos,2,GetFieldValue("安装工2"));
       m_job.SetItemText(iPos,3,GetFieldValue("发票号"));
       m_job.SetItemText(iPos,4,GetFieldValue("空调品牌"));
       m_job.SetItemText(iPos,5,GetFieldValue("空调匹次"));
       m_job.SetItemText(iPos,6,GetFieldValue("所属商场"));
       m_job.SetItemText(iPos,7,GetFieldValue("安装日期"));
	   Item++;
	   rst->MoveNext();
	}
End:
	str.Format("【符合条件的记录共 %d 条】\n【当前显示条第 %d 条至 第 %d 条记录】",cx_jieguo,cx_nowpage*20+1,i);
    m_tongji=str;
	UpdateData(FALSE);

	GetDlgItem(IDC_FIRST_BUT2)->EnableWindow(TRUE);
	GetDlgItem(IDC_PREVIOUS_BUT2)->EnableWindow(TRUE);
	GetDlgItem(IDC_NEXT_BUT2)->EnableWindow(FALSE);
	GetDlgItem(IDC_LAST_BUT2)->EnableWindow(FALSE);
}

void CJobinfo::OnDelete() 
{

	if(MessageBox("您确定删除该条记录？","删除确认",MB_ICONQUESTION|MB_OKCANCEL)==1)
	{
       int Row;
	   Row=m_job.GetSelectionMark();
	   CString sSQL,sName;
       sName=m_job.GetItemText(Row,3);
	   m_job.DeleteItem(Row);
       sSQL.Format("DELETE FROM 员工业务表 WHERE 发票号='%s'",sName);
       rst=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
	}
	else
		return;
	
}

void CJobinfo::OnUpdate() 
{
    CEditJob dlg;
	CString sSQL;
	int Row;
	Row=m_job.GetSelectionMark();
	dlg.m_name1=m_job.GetItemText(Row,1);
	dlg.m_name2=m_job.GetItemText(Row,2);
	dlg.m_fapiao=m_job.GetItemText(Row,3);

	dlg.m_pinpai=m_job.GetItemText(Row,4);
	dlg.m_pici=m_job.GetItemText(Row,5);
	if(m_job.GetItemText(Row,6)=="浙北")
		dlg.m_shop=0;
    if(m_job.GetItemText(Row,6)=="国美")
		dlg.m_shop=1;
	if(m_job.GetItemText(Row,6)=="五星")
		dlg.m_shop=2;
	dlg.m_date=CStringToCTime(m_job.GetItemText(Row,7));
    dlg.Enable=1;
	UpdateData(FALSE);
	dlg.DoModal();

}

CTime CJobinfo::CStringToCTime(CString cDate)
{
	int nYear,nMonth,nDay,iFChar,iSChar;
	CString cYear,cMonth,cDay;
	CTime tDate;
	iFChar=cDate.Find("-",0);
	iSChar=cDate.Find("-",iFChar+1);
	cYear=cDate.Left(4);
    cMonth=cDate.Mid(iFChar+1,iSChar-(iFChar+1));
	cDay=cDate.Mid(iSChar+1);
	nYear=atoi(cYear);
	nMonth=atoi(cMonth);
	nDay=atoi(cDay);
	tDate=CTime::CTime(nYear,nMonth,nDay,0,0,0);
	return tDate;
}