new3dlg.cpp

用数据库ACCESS和VISUAL C++编程

	   str00.Format("%.3f",rf_set.m_shuidianfei );
	   m_list.SetItemText(i,16,LPCTSTR(str00));

	   str00.Format("%.3f",rf_set.m_tuoerfei );
	   m_list.SetItemText(i,17,LPCTSTR(str00));

	   str00.Format("%.3f",rf_set.m_jiezhikoukuang );
	   m_list.SetItemText(i,18,LPCTSTR(str00));

	   str00.Format("%.3f",rf_set.m_qitakoukuang );
	   m_list.SetItemText(i,19,LPCTSTR(str00));

	   str00.Format("%.3f",rf_set.m_koukuangheji );
	   m_list.SetItemText(i,20,LPCTSTR(str00));

	   str00.Format("%.3f",rf_set.m_shifagongzi );
	   m_list.SetItemText(i,21,LPCTSTR(str00));

	   m_list.SetItemText(i,22,LPCTSTR(rf_set.m_beizhu ));
	   i=i+1;
	   }
	   rf_set.MoveNext();
	   
   }
}

void CNew3Dlg::OnColumnclickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	switch(pNMListView->iSubItem)
	{
	case 1:
		allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="bumenID";
		  allset.Requery();
		  loadsortlist();
		  break;
    case 2:
		allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="bumenname";
		  allset.Requery();
		  loadsortlist();
		  break;
	case 3:
		allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="zhigongID";
		  allset.Requery();
		  loadsortlist();
		  break;
  case 4:
			  allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="zhigongname";
		  allset.Requery();
		  loadsortlist();
		  break;
  case 5:
	  allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="sex";
		  allset.Requery();
		  loadsortlist();
		  break;
case 6:
	  allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="jibengongzi";
		  allset.Requery();
		  loadsortlist();
		  break;
case 7:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="gonglinggongzhi";
		  allset.Requery();
		  loadsortlist();
		  break;
case 8:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="fushibutie";
		  allset.Requery();
		  loadsortlist();
		  break;
case 9:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="meiliangbutie";
		  allset.Requery();
		  loadsortlist();
		  break;
case 10:
		  allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="jiaotongbutie";
		  allset.Requery();
		  loadsortlist();
		  break;
case 11:
	  allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="butie1";
		  allset.Requery();
		  loadsortlist();
		  break;
case 12:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="butie2";
		  allset.Requery();
		  loadsortlist();
		  break;
case 13:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="butieheji";
		  allset.Requery();
		  loadsortlist();
		  break;
case 14:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="yingfagongzi";
		  allset.Requery();
		  loadsortlist();
		  break;
case 15:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="fangfei";
		  allset.Requery();
		  loadsortlist();
		  break;
case 16:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="shuidianfei";
		  allset.Requery();
		  loadsortlist();
		  break;
case 17:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="tuoerfei";
		  allset.Requery();
		  loadsortlist();
		  break;
case 18:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="jiezhikoukuang";
		  allset.Requery();
		  loadsortlist();
		  break;
case 19:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="qitakoukuang";
		  allset.Requery();
		  loadsortlist();
		  break;
case 20:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="koukuangheji";
		  allset.Requery();
		  loadsortlist();
		  break;
case 21:
	allset.Open();
		//gz_set.Open(); 
          allset.m_strSort="shifagongzi";
		  allset.Requery();
		  loadsortlist();
		  break;
	}
	*pResult = 0;
}

void CNew3Dlg::loadsortlist()
{
     char szBuffer5 [ 256 ];
   int k=0;
   CTime ti;
   CString str,strmySql,ss,sex1;
   m_list.DeleteAllItems(); 
    int i=0;	
	//;MessageBox("11111");
	allset.MoveFirst(); 
	
    while(!allset.IsEOF() )
   {
	   if(allset.m_flag==0)
	   {
		  m_list.InsertItem (i, LPCTSTR ( ltoa (i+1, szBuffer5, 10 )), 0 );
	   m_list.SetItemText(i,1,LPCTSTR(allset.m_bumenID));
	   m_list.SetItemText(i,2,LPCTSTR(allset.m_bumenname ));
	   m_list.SetItemText(i,3,LPCTSTR(allset.m_zhigongID ));
	   m_list.SetItemText(i,4,LPCTSTR(allset.m_zhigongname ));
	   //if(allset.m_sex=="m")
        m_list.SetItemText(i,5,LPCTSTR(allset.m_sex));            
	   str.Format("%.2f",allset.m_jibengongzi); 
	   m_list.SetItemText(i,6,LPCTSTR(str ));
	   str.Format("%.3f",allset.m_gonglinggongzi);
	   m_list.SetItemText(i,7,LPCTSTR(str));

	   str.Format("%.3f",allset.m_fushibutie );
	   m_list.SetItemText(i,8,LPCTSTR(str));
       
	   str.Format("%.3f",allset.m_meiliangbutie );
	   m_list.SetItemText(i,9,LPCTSTR(str));

	   str.Format("%.3f",allset.m_jiaotongbutie);
	   m_list.SetItemText(i,10,LPCTSTR(str));

	   str.Format("%.3f",allset.m_butie1 );
	   m_list.SetItemText(i,11,LPCTSTR(str));

	   str.Format("%.3f",allset.m_butie2);
	   m_list.SetItemText(i,12,LPCTSTR(str));

	   str.Format("%.3f",allset.m_butieheji );
	   m_list.SetItemText(i,13,LPCTSTR(str));

	   str.Format("%.3f",allset.m_yingfagongzi);
	   m_list.SetItemText(i,14,LPCTSTR(str));

	   str.Format("%.3f",allset.m_fangfei );
	   m_list.SetItemText(i,15,LPCTSTR(str));

	   str.Format("%.3f",allset.m_shuidianfei );
	   m_list.SetItemText(i,16,LPCTSTR(str));

	   str.Format("%.3f",allset.m_tuoerfei );
	   m_list.SetItemText(i,17,LPCTSTR(str));

	   str.Format("%.3f",allset.m_jiezhikoukuang );
	   m_list.SetItemText(i,18,LPCTSTR(str));

	   str.Format("%.3f",allset.m_qitakoukuang );
	   m_list.SetItemText(i,19,LPCTSTR(str));

	   str.Format("%.3f",allset.m_koukuangheji );
	   m_list.SetItemText(i,20,LPCTSTR(str));

	   str.Format("%.3f",allset.m_shifagongzi );
	   m_list.SetItemText(i,21,LPCTSTR(str));

	   m_list.SetItemText(i,22,LPCTSTR(allset.m_beizhu ));
	   i=i+1;
	   }
	   allset.MoveNext();
	   
   }  
	allset.Close(); 
}

void CNew3Dlg::OnPrint() 
{
CCgongziset printset;
int wide=39;
CString pstr;
printset.Open();
printset.MoveFirst();
	// TODO: Add your control notification handler code here
	char szprinter[80]; 
char *szDevice,*szDriver,*szOutput; 
HDC hdcprint; // 定义一个设备环境句柄 

static DOCINFO di={sizeof(DOCINFO),"printer",NULL}; 

GetProfileString("windows","device",",,,",szprinter,80); 
// 将设备字符串分解 
if(NULL!=(szDevice=strtok(szprinter,","))&& 
NULL!=(szDriver=strtok(NULL,","))&& 
NULL!=(szOutput=strtok(NULL,","))) 
// 创建一个打印机设备句柄 
if((hdcprint=CreateDC(szDriver,szDevice,szOutput,NULL))!=0) 
{ 
if(StartDoc(hdcprint,&di)>0) //开始执行一个打印作业 
{ 
StartPage(hdcprint); //打印机走纸,开始打印
SaveDC(hdcprint); //保存打印机设备句柄 
// 输出一行文字
 TextOut(hdcprint,350,1,"全校职工工资表",14); 
 TextOut(hdcprint,1,20,"部门ID",6);
 TextOut(hdcprint,51,20,"部门名",6);
 TextOut(hdcprint,101,20,"职工ID",6);
 TextOut(hdcprint,151,20,"职工名",6);
 TextOut(hdcprint,201,20,"性别",4);
 TextOut(hdcprint,251,20,"基本工资",8);
 TextOut(hdcprint,301,20,"工龄工资",8);
 TextOut(hdcprint,351,20,"副食补贴",8);
 TextOut(hdcprint,401,20,"煤粮补贴",8);
 TextOut(hdcprint,451,20,"交通补贴",8);
 TextOut(hdcprint,501,20,"补贴1",5);
 TextOut(hdcprint,551,20,"补贴2",5);
 TextOut(hdcprint,601,20,"补贴合计",8);
 TextOut(hdcprint,651,20,"应发工资",8);
 TextOut(hdcprint,701,20,"房费",4);
 TextOut(hdcprint,751,20,"水电费",6);
 TextOut(hdcprint,801,20,"托儿费",6);

TextOut(hdcprint,851,20,"借支扣款",8);
 TextOut(hdcprint,901,20,"其它扣款",8);
 TextOut(hdcprint,951,20,"扣款合计",8);
 TextOut(hdcprint,1001,20,"实发工资",8);
TextOut(hdcprint,1051,20,"备注",4);
while(!printset.IsEOF())
{
	if(printset.m_flag==0)
	{
         TextOut(hdcprint,1,wide,printset.m_bumenID,strlen(printset.m_bumenID ));
         TextOut(hdcprint,51,wide,printset.m_bumenname,strlen(printset.m_bumenname));
         TextOut(hdcprint,101,wide,printset.m_zhigongID,strlen(printset.m_zhigongID));
         TextOut(hdcprint,151,wide,printset.m_zhigongname,strlen(printset.m_zhigongname));
         TextOut(hdcprint,201,wide,printset.m_sex,strlen(printset.m_sex));
         pstr.Format("%f",printset.m_jibengongzi); 
         TextOut(hdcprint,251,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_gonglinggongzi ); 
         TextOut(hdcprint,301,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_fushibutie); 
         TextOut(hdcprint,351,20,pstr,strlen(pstr));

         pstr.Format("%f",printset.m_meiliangbutie); 
         TextOut(hdcprint,401,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_jiaotongbutie); 
         TextOut(hdcprint,451,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_butie1); 
         TextOut(hdcprint,501,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_butie2); 
         TextOut(hdcprint,551,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_butieheji); 
         TextOut(hdcprint,601,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_yingfagongzi); 
         TextOut(hdcprint,651,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_fangfei); 
         TextOut(hdcprint,701,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_shuidianfei); 
         TextOut(hdcprint,751,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_tuoerfei); 
         TextOut(hdcprint,801,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_jiezhikoukuang); 
         TextOut(hdcprint,851,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_qitakoukuang); 
         TextOut(hdcprint,901,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_koukuangheji); 
         TextOut(hdcprint,951,20,pstr,strlen(pstr));

		 pstr.Format("%f",printset.m_shifagongzi); 
         TextOut(hdcprint,1001,20,pstr,strlen(pstr));
         TextOut(hdcprint,1051,20,printset.m_beizhu,strlen(printset.m_beizhu));
	}
	wide+=19;
printset.MoveNext(); 	

}
// 输出一条直线 
MoveToEx(hdcprint,20,20,NULL); 
LineTo(hdcprint,120,120); 
RestoreDC(hdcprint,-1); //恢复打印机设备句柄 
EndPage(hdcprint); //打印机停纸,停止打印 
EndDoc(hdcprint); //结束一个打印作业 
//MessageBox("打印完毕!","提示",MB_ICONINFORMATION); 
} 
// 用API函数DeleteDC销毁一个打印机设备句柄 
DeleteDC(hdcprint); 

} 
else 
{ 
MessageBox("没有默认打印机,或者没有安装打印机!"); 
return; 
} 
}

void CNew3Dlg::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
	//AnimateWindow(GetSafeHwnd(),1000,AW_HIDE|AW_BLEND);
	CDialog::OnClose();
	//CDialog::OnClose();
}