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

📄 new3dlg.cpp

📁 用数据库ACCESS和VISUAL C++编程
💻 CPP
📖 第 1 页 / 共 4 页
字号:
		int n = m_list.GetNextSelectedItem(pos);
        editdlg.m_editbmname=m_list.GetItemText(n,2);
		editdlg.m_zhigongid=m_list.GetItemText(n,3); 
		editdlg.m_zhigongname=m_list.GetItemText(n,4) ; 

		editdlg.m_editjbgongzi=(float)atof(m_list.GetItemText(n,6)); 
		editdlg.m_editglgongzi=(float)atof(m_list.GetItemText(n,7)); 
		editdlg.m_editfsbutie=(float)atof(m_list.GetItemText(n,8));
		editdlg.m_editmlbutie=(float)atof(m_list.GetItemText(n,9)); 
		editdlg.m_editjtbutie=(float)atof(m_list.GetItemText(n,10)); 
		editdlg.m_editbutie1=(float)atof(m_list.GetItemText(n,11)); 
		editdlg.m_editbutie2=(float)atof(m_list.GetItemText(n,12)); 

		editdlg.m_editfangfei=(float)atof(m_list.GetItemText(n,15));
		editdlg.m_editsdfei=(float)atof(m_list.GetItemText(n,16) ); 
		editdlg.m_edittuoerfei=(float)atof(m_list.GetItemText(n,17) ); 
		editdlg.m_editjzkoukuan=(float)atof(m_list.GetItemText(n,18) ); 
		editdlg.m_editqtkoukuan=(float)atof(m_list.GetItemText(n,19) ); 
		if(editdlg.DoModal()==IDOK)
		{
			while(!editset.IsEOF())
			{
				if(editset.m_zhigongID==editdlg.m_zhigongid)
					if(editset.m_flag==0)
					{
                         editset.Edit(); 
						 editset.m_bumenname=editdlg.m_editbmname;
						 editset.m_zhigongID=editdlg.m_zhigongid;
						 editset.m_zhigongname=editdlg.m_zhigongname;
						 editset.m_jibengongzi=editdlg.m_editjbgongzi;
						 editset.m_gonglinggongzi=editdlg.m_editglgongzi;
						 editset.m_fushibutie=editdlg.m_editfsbutie;
						 editset.m_meiliangbutie=editdlg.m_editmlbutie;
						 editset.m_jiaotongbutie=editdlg.m_editjtbutie;
						 editset.m_butie1=editdlg.m_editbutie1;
						 editset.m_butie2=editdlg.m_editbutie2;
						 editset.m_fangfei=editdlg.m_editfangfei;
						 editset.m_shuidianfei=editdlg.m_editsdfei;
						 editset.m_tuoerfei=editdlg.m_edittuoerfei;
						 editset.m_jiezhikoukuang=editdlg.m_editjzkoukuan;
						 editset.m_qitakoukuang=editdlg.m_editqtkoukuan;
						 editset.m_butieheji=editdlg.m_editfsbutie+editdlg.m_editmlbutie+editdlg.m_editjtbutie+editdlg.m_editbutie1+editdlg.m_editbutie2; 
						 editset.m_koukuangheji=editdlg.m_editfangfei+editdlg.m_editsdfei+editdlg.m_edittuoerfei+editdlg.m_editjzkoukuan+editdlg.m_editqtkoukuan; 
						 editset.m_yingfagongzi=editdlg.m_editjbgongzi+editdlg.m_editglgongzi+editset.m_butieheji; 
						 editset.m_shifagongzi=editset.m_yingfagongzi-editset.m_koukuangheji; 
						 editset.Update(); 
					}
			  editset.MoveNext(); 
			}
			 MessageBox("修改成功!");
		}
		//CString s;
		//s.Format("学号:%s 姓名:%s",m_list.GetItemText(n,1),m_list.GetItemText(n,2));
	
		//GetDlgItem(IDC_STATIC2)->SetWindowText(s);
		
		}
/************************************************************************************/
	editset.MoveFirst();
   int i=0;	
   char szBuffer1[1024];
   CString str1;
  m_list.DeleteAllItems ();
   while(!editset.IsEOF())
   {
	   if(editset.m_flag==0)
	   {
		
	   m_list.InsertItem (i, LPCTSTR ( ltoa (editset.m_column1, szBuffer1, 10 )), 0 );
	   m_list.SetItemText(i,1,LPCTSTR(editset.m_bumenID));
	   m_list.SetItemText(i,2,LPCTSTR(editset.m_bumenname ));
	   m_list.SetItemText(i,3,LPCTSTR(editset.m_zhigongID ));
	   m_list.SetItemText(i,4,LPCTSTR(editset.m_zhigongname ));
	   //if(editset.m_sex=="m")
        m_list.SetItemText(i,5,LPCTSTR(editset.m_sex));            
	   str1.Format("%.3f",editset.m_jibengongzi); 
	   m_list.SetItemText(i,6,LPCTSTR(str1 ));
	   str1.Format("%.3f",editset.m_gonglinggongzi);
	   m_list.SetItemText(i,7,LPCTSTR(str1));

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

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

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

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

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

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

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

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

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

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

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

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

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

	   m_list.SetItemText(i,22,LPCTSTR(editset.m_beizhu ));
	   i=i+1;
	   }
	   editset.MoveNext();
	   
   }
	//loadlist();	
	UpdateData(false);
/***************************************************************************************/
	editset.Close(); 
  
	*pResult = 0;
}

BOOL CNew3Dlg::DestroyWindow() 
{
	// TODO: Add your specialized code here and/or call the base class
buttonBMP.DeleteObject(); 
buttonBMP1.DeleteObject(); 
buttonBMP2.DeleteObject(); 
buttonBMP3.DeleteObject(); 

buttonBMP4.DeleteObject(); 
buttonBMP5.DeleteObject(); 
buttonBMP6.DeleteObject(); 
buttonBMP7.DeleteObject(); 
buttonBMP8.DeleteObject(); 
buttonBMP9.DeleteObject(); 

buttonBMP10.DeleteObject(); 
buttonBMP11.DeleteObject();


	return CDialog::DestroyWindow();
}

void CNew3Dlg::OnChangeBtzgid() 
{
	// TODO: If this is a RICHEDIT control, the control will not
	// send this notification unless you override the CDialog::OnInitDialog()
	// function and call CRichEditCtrl().SetEventMask()
	// with the ENM_CHANGE flag ORed into the mask.
	GetDlgItem(IDC_YES1)->EnableWindow(true);
	GetDlgItem(IDC_RESET1)->EnableWindow(true);
	// TODO: Add your control notification handler code here
	
}

void CNew3Dlg::OnChangeKkzgid() 
{
	// TODO: If this is a RICHEDIT control, the control will not
	// send this notification unless you override the CDialog::OnInitDialog()
	// function and call CRichEditCtrl().SetEventMask()
	// with the ENM_CHANGE flag ORed into the mask.
	GetDlgItem(IDC_YES2)->EnableWindow(true);
	GetDlgItem(IDC_RESET2)->EnableWindow(true);
	// TODO: Add your control notification handler code here
	
}

void CNew3Dlg::OnZigongchaxun() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	char szBuffer2[ 256 ];
	CString str3;
  CCgongziset chaxun_set;
  
  chaxun_set.Open(); 
	chaxun_set.MoveFirst();
   int i=0;	
  
   while(!chaxun_set.IsEOF())
   {
	   if(chaxun_set.m_flag==0)
		   if(chaxun_set.m_zhigongID==m_zhigongidchaxun)
	   {
		m_list.DeleteAllItems(); 
	   m_list.InsertItem (i, LPCTSTR ( ltoa (i+1, szBuffer2, 10 )), 0 );
	   m_list.SetItemText(i,1,LPCTSTR(chaxun_set.m_bumenID));
	   m_list.SetItemText(i,2,LPCTSTR(chaxun_set.m_bumenname ));
	   m_list.SetItemText(i,3,LPCTSTR(chaxun_set.m_zhigongID ));
	   m_list.SetItemText(i,4,LPCTSTR(chaxun_set.m_zhigongname ));
	   //if(chaxun_set.m_sex=="m")
        m_list.SetItemText(i,5,LPCTSTR(chaxun_set.m_sex));            
	   str3.Format("%.3f",chaxun_set.m_jibengongzi); 
	   m_list.SetItemText(i,6,LPCTSTR(str3 ));
	   str3.Format("%.3f",chaxun_set.m_gonglinggongzi);
	   m_list.SetItemText(i,7,LPCTSTR(str3));

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

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

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

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

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

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

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

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

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

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

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

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

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

	   m_list.SetItemText(i,22,LPCTSTR(chaxun_set.m_beizhu ));
	   i=i+1;
	   }
	   chaxun_set.MoveNext();
	   
   }
   if(i==0)
   {
	   MessageBox("找不到该职工ID");
	   return;
   }
}

void CNew3Dlg::OnBumenchaxun() 
{
	// TODO: Add your control notification handler code here
		UpdateData();
	char szBuffer3[ 256 ];
	CString str3;
  CCgongziset chaxun_set1;
  
  chaxun_set1.Open(); 
	chaxun_set1.MoveFirst();
   int i=0;	
  
   while(!chaxun_set1.IsEOF())
   {
	   if(chaxun_set1.m_flag==0)
		   if(chaxun_set1.m_bumenID==m_bumennamecheck)
	   {
		m_list.DeleteAllItems(); 
	   m_list.InsertItem (i, LPCTSTR ( ltoa (i+1, szBuffer3, 10 )), 0 );
	   m_list.SetItemText(i,1,LPCTSTR(chaxun_set1.m_bumenID));
	   m_list.SetItemText(i,2,LPCTSTR(chaxun_set1.m_bumenname ));
	   m_list.SetItemText(i,3,LPCTSTR(chaxun_set1.m_zhigongID ));
	   m_list.SetItemText(i,4,LPCTSTR(chaxun_set1.m_zhigongname ));
	   //if(chaxun_set1.m_sex=="m")
        m_list.SetItemText(i,5,LPCTSTR(chaxun_set1.m_sex));            
	   str3.Format("%.3f",chaxun_set1.m_jibengongzi); 
	   m_list.SetItemText(i,6,LPCTSTR(str3 ));
	   str3.Format("%.3f",chaxun_set1.m_gonglinggongzi);
	   m_list.SetItemText(i,7,LPCTSTR(str3));

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

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

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

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

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

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

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

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

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

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

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

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

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

	   m_list.SetItemText(i,22,LPCTSTR(chaxun_set1.m_beizhu ));
	   i=i+1;
	   }
	   chaxun_set1.MoveNext();
	   
   }
   if(i==0)
   {
	   MessageBox("不存在该部门ID");
	   return;
   }
}

void CNew3Dlg::OnReflesh() 
{
     CCgongziset rf_set;
	 char szBuffer00[256];
	 CString str00;
	 m_list.DeleteAllItems(); 
	 rf_set.Open();
	 rf_set.MoveFirst(); 
	 int i=0;
	// TODO: Add your control notification handler code here
	 while(!rf_set.IsEOF() )
   {
	   if(rf_set.m_flag==0)
	   {
		y=rf_set.m_timey;
		m=rf_set.m_timem; 
	   m_list.InsertItem (i, LPCTSTR ( ltoa (i+1, szBuffer00, 10 )), 0 );
	   m_list.SetItemText(i,1,LPCTSTR(rf_set.m_bumenID));
	   m_list.SetItemText(i,2,LPCTSTR(rf_set.m_bumenname ));
	   m_list.SetItemText(i,3,LPCTSTR(rf_set.m_zhigongID ));
	   m_list.SetItemText(i,4,LPCTSTR(rf_set.m_zhigongname ));
	   //if(rf_set.m_sex=="m")
        m_list.SetItemText(i,5,LPCTSTR(rf_set.m_sex));            
	   str00.Format("%.2f",rf_set.m_jibengongzi); 
	   m_list.SetItemText(i,6,LPCTSTR(str00 ));
	   str00.Format("%.3f",rf_set.m_gonglinggongzi);
	   m_list.SetItemText(i,7,LPCTSTR(str00));

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

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

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

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

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

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

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

⌨️ 快捷键说明

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