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

📄 new3dlg.cpp

📁 用数据库ACCESS和VISUAL C++编程
💻 CPP
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
	CCgongziset set1;
	CCzgtable set2;
	set2.Open();
	set2.MoveFirst(); 
	set1.Open();
	set1.MoveFirst();
	while(!set1.IsEOF())
	{
         if(set1.m_flag==0)
		 {
			 set1.Edit();
			 set1.m_flag=1;
			 set1.Update(); 
		 }
		 set1.MoveNext(); 
	}
    if(m==12)
	{
		  m=1;
		  y=y+1;
		  }
	else m=m+1;
	while(!set2.IsEOF())
	{
		
		if((check(set2.m_kashitimey,set2.m_kashitimem)==1)&&(check1(set2.m_tifatimey,set2.m_tifatimem)==1))
		{
		set1.CanAppend(); 
         set1.AddNew();
		 set1.m_bumenID=set2.m_bumenID;
		 set1.m_bumenname=set2.m_bumenname;
		 set1.m_zhigongID=set2.m_zhigongID;
		 set1.m_zhigongname=set2.m_zhigongname;
		 set1.m_sex=set2.m_sex;  
		 set1.m_jibengongzi=set2.m_jibengongzi;
		 set1.m_gonglinggongzi=set2.m_gonglinggongzi;
		 set1.m_timey=y;
		 set1.m_timem=m; 
		 set1.Update();} 
		 set2.MoveNext(); 
	}
	set2.Requery(); 
	set1.Close();
	set2.Close();
	m_static1.Format("你正在处理的是===%d年%d月的工资情况===",y ,m); 
   //loadlist();
	UpdateData(false);
	//CNew3Dlg::OnInitDialog(); 
}

void CNew3Dlg::OnYes1()
 
{
	// TODO: Add your control notification handler code here
	CCgongziset sss;
		char szBuffer1 [ 256 ];
   int k=0;
   //CTime ti;
   CString str1,strmySql,ss,sex1;
	UpdateData(true);
	if(m_butieid.IsEmpty())
	{
		MessageBox("职工ID不能为空!");
		return;
	}
	if((m_fsbt<0)||(m_jtbt<0)||(m_mlbt<0)||(m_betie22<0)||(m_butie11<0))
	{
		MessageBox("不可以有负数");
		return;
	}
	CString str;
	int q=0;
	sss.Open();
	sss.MoveFirst();
	while(!sss.IsEOF())
	{
		if(sss.m_zhigongID==m_butieid)
			if(sss.m_flag==0)
		{
			sss.Edit();
			sss.m_fushibutie=m_fsbt;
			sss.m_meiliangbutie=m_mlbt;
			sss.m_jiaotongbutie=m_jtbt;
			sss.m_butie1=m_butie11;
			sss.m_butie2=m_betie22;
			sss.m_butieheji=m_fsbt+m_mlbt+m_jtbt+m_butie11+m_betie22; 
			sss.m_yingfagongzi=sss.m_jibengongzi+sss.m_gonglinggongzi+m_fsbt+m_mlbt+m_jtbt+m_butie11+m_betie22;   
			sss.m_shifagongzi=sss.m_yingfagongzi-sss.m_koukuangheji;
			sss.Update(); 
			q++;
		}
     sss.MoveNext(); 
	}
	if(q==0)
	{
		MessageBox("该职工不存在!");
		return;
	}
	sss.Requery(); 
	m_list.DeleteAllItems(); 

   //m_list.DeleteAllItems(); 
   
  // gz_set.Open();
   sss.MoveFirst();
   int i=0;	
  
   while(!sss.IsEOF())
   {
	   if(sss.m_flag==0)
	   {
		
	   m_list.InsertItem (i, LPCTSTR ( ltoa (sss.m_column1, szBuffer1, 10 )), 0 );
	   m_list.SetItemText(i,1,LPCTSTR(sss.m_bumenID));
	   m_list.SetItemText(i,2,LPCTSTR(sss.m_bumenname ));
	   m_list.SetItemText(i,3,LPCTSTR(sss.m_zhigongID ));
	   m_list.SetItemText(i,4,LPCTSTR(sss.m_zhigongname ));
	   //if(sss.m_sex=="m")
        m_list.SetItemText(i,5,LPCTSTR(sss.m_sex));            
	   str1.Format("%.3f",sss.m_jibengongzi); 
	   m_list.SetItemText(i,6,LPCTSTR(str1 ));
	   str1.Format("%.3f",sss.m_gonglinggongzi);
	   m_list.SetItemText(i,7,LPCTSTR(str1));

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

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

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

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

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

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

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

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

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

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

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

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

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

	   m_list.SetItemText(i,22,LPCTSTR(sss.m_beizhu ));
	   i=i+1;
	   }
	   sss.MoveNext();
	   
   }
	//loadlist();	
	UpdateData(false);
	
}

void CNew3Dlg::OnYes2() 
{
	// TODO: Add your control notification handler code here
	CCgongziset sss2;
	int w=0;
	UpdateData(true);
	if(m_kkzgid.IsEmpty() )
	{
		MessageBox("职工ID不能为空!");
		return;
	}
	if((m_ff<0)||(m_jzkk<0)||(m_qtkk<0)||(m_terf<0)||(m_sdf<0))
	{
          MessageBox("不可以有负数");
		return;
	}
		sss2.Open();
	sss2.MoveFirst();
		while(!sss2.IsEOF())
	{
			if(sss2.m_zhigongID==m_kkzgid)
			if(sss2.m_flag==0)
		{
			sss2.Edit();
			sss2.m_fangfei=m_ff;
			sss2.m_shuidianfei=m_sdf;
			sss2.m_tuoerfei=m_terf;
			sss2.m_jiezhikoukuang=m_jzkk;
			sss2.m_qitakoukuang=m_qtkk;
			sss2.m_koukuangheji=m_ff+m_sdf+m_terf+m_jzkk+m_qtkk; 
			sss2.m_shifagongzi=sss2.m_yingfagongzi-sss2.m_koukuangheji;   
			//sss.m_shifagongzi=sss.m_yingfagongzi-sss.m_koukuangheji;
			sss2.Update(); 
			w++;
		}
     sss2.MoveNext(); 
	} 
		if(w==0)
		{
			MessageBox("该职工不存在!");
			return;
		}
			char szBuffer2[ 256 ];
   int k=0;
   //CTime ti;
   CString str2,strmySql,ss,sex1;
   m_list.DeleteAllItems(); 
   
  // gz_set.Open();
   sss2.MoveFirst();
   int i=0;	
  
   while(!sss2.IsEOF())
   {
	   if(sss2.m_flag==0)
	   {
		
	   m_list.InsertItem (i, LPCTSTR ( ltoa (sss2.m_column1, szBuffer2, 10 )), 0 );
	   m_list.SetItemText(i,1,LPCTSTR(sss2.m_bumenID));
	   m_list.SetItemText(i,2,LPCTSTR(sss2.m_bumenname ));
	   m_list.SetItemText(i,3,LPCTSTR(sss2.m_zhigongID ));
	   m_list.SetItemText(i,4,LPCTSTR(sss2.m_zhigongname ));
	   //if(sss.m_sex=="m")
        m_list.SetItemText(i,5,LPCTSTR(sss2.m_sex));            
	   str2.Format("%.3f",sss2.m_jibengongzi); 
	   m_list.SetItemText(i,6,LPCTSTR(str2 ));
	   str2.Format("%.3f",sss2.m_gonglinggongzi);
	   m_list.SetItemText(i,7,LPCTSTR(str2));

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

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

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

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

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

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

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

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

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

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

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

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

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

	   m_list.SetItemText(i,22,LPCTSTR(sss2.m_beizhu ));
	   i=i+1;
	   }
	   sss2.MoveNext();
	   
   }
   UpdateData(false);
	//loadlist();
}

void CNew3Dlg::OnReset1() 
{
	// TODO: Add your control notification handler code here
	m_butieid="";
	m_butie11=0;
	m_betie22=0;
	m_fsbt=0;
	m_mlbt=0;
	m_jtbt=0;
	UpdateData(false);
	
}

void CNew3Dlg::OnReset2() 
{
	// TODO: Add your control notification handler code here
	m_kkzgid="";
	m_ff=0;
	m_sdf=0;
	m_terf=0;
	m_jzkk=0;
	m_qtkk=0;
	UpdateData(false);
	
}

void CNew3Dlg::OnXndiaodong() 
{
	// TODO: Add your control notification handler code here
	CCxndiaodong dlg;
	
	dlg.DoModal(); 
	

}

void CNew3Dlg::OnRydiaoli() 
{
	// TODO: Add your control notification handler code here
	CCgzdiaoli dlg;
	//SetDialogBkColor(RGB(109,139,241),RGB(0,0,0));
	dlg.DoModal(); 
}

int CNew3Dlg::check(int yy, int mm)
{
    CTime time; 
	int ye,mo;
	 ye=y;mo=m;
     if((yy==0)&&(mm==0))
		 return 1;
	 if(((y-time.GetCurrentTime().GetYear())*12+m)<(yy-time.GetCurrentTime().GetYear()*12+mm))
		 return 0;
	 return 1;
	 
}

int CNew3Dlg::check1(int tf, int tm)
{
   CTime time1;
   int yy1,mm1;
   yy1=y;mm1=m;
   if((tf==0)&&(tm==0))
	   return 1;
   if(((y-time1.GetCurrentTime().GetYear())*12+m)>=(tf-time1.GetCurrentTime().GetYear()*12+tm))
	   return 0;
   else return 1;
   
}

void CNew3Dlg::OnXwdiaoru() 
{
	// TODO: Add your control notification handler code here
	CCxwdiaoru dlg;
	
	dlg.DoModal(); 
}

void CNew3Dlg::OnQuanniangz() 
{
	// TODO: Add your control notification handler code here
	CCzgqndlg qn_dlg;
	qn_dlg.DoModal(); 
}



void CNew3Dlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	CCeditdlg editdlg;
   CCgongziset editset;
   //m_list.DeleteItem(1);
  // if((editdlg.m_editbutie1<0)||(editdlg.m_editbutie2<0)||(editdlg.m_editfangfei<0)||(editdlg.m_editfsbutie<0)||(editdlg.m_editglgongzi<0)||(editdlg.m_editjbgongzi)||(editdlg.m_editjtbutie<0)||(editdlg.m_editjzkoukuan<0)||(editdlg.m_editmlbutie<0)||(editdlg.m_editqtkoukuan<0)||(editdlg.m_editsdfei<0)||(editdlg.m_edittuoerfei<0))
   //{
	 //  MessageBox("不能为负数!");
	  // return;
   //}
   editset.Open();
   editset.MoveFirst(); 
	// TODO: Add your control notification handler code here
		POSITION pos =m_list.GetFirstSelectedItemPosition();
		//m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	if(pos)
	{
1234

⌨️ 快捷键说明

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