findgiveback.cpp

关于固定资产管理系统的源码

			   str=CCrack::strVARIANT(var);
			   if(str.GetAt(6)=='0') 
			      year.Format("20%c%c",str.GetAt(6),str.GetAt(7));
		       else
			      year.Format("19%c%c",str.GetAt(6),str.GetAt(7));
		       month.Format("%c%c",str.GetAt(0),str.GetAt(1));
		       day.Format("%c%c",str.GetAt(3),str.GetAt(4));
		       CTime time(atoi(year),atoi(month),atoi(day),m_LNDate1.GetHour(),m_LNDate1.GetMinute(),m_LNDate1.GetSecond());
			   if(time<m_LNDate1||time>m_LNDate2) 
			   {
			      m_pRecordset->MoveNext();
			      continue;
			   }
			}
			

			var = m_pRecordset->GetFieldValue(0);
			m_CtrlList.InsertItem(nItem,CCrack::strVARIANT(var));
			for (i=0; i < nFields; i++)
			{
				var = m_pRecordset->GetFieldValue(i);
				if(i>=2)
				{
				    if(i==5)  
					{ 
				        int j;
                        for(j=0;j<m_uaDepartment.GetSize();j++)
						{ 
                           if(m_uaDepartment[j]==unsigned(atoi(CCrack::strVARIANT(var)))) break;
						}
	                    m_CtrlList.SetItemText( nItem,i+2,m_saDepartment[j]);
					    continue;
					} 
				    m_CtrlList.SetItemText( nItem,i+2,CCrack::strVARIANT(var));
				}
				if(i==1)
                    m_CtrlList.SetItemText( nItem,i,CCrack::strVARIANT(var));
			}
            CDaoRecordset *m_pSet;
			m_pSet=new CDaoRecordset(m_pDatabase);
			var = m_pRecordset->GetFieldValue(1);
			select.Format("select 资产编号,资产名称 from 资产信息 where 资产ID=%d",atoi(CCrack::strVARIANT(var)));
		try{   
			m_pSet->Open(dbOpenDynaset,select);
			var = m_pSet->GetFieldValue(0);
            m_CtrlList.SetItemText( nItem,2,CCrack::strVARIANT(var));
			var = m_pSet->GetFieldValue(1);
            m_CtrlList.SetItemText( nItem,3,CCrack::strVARIANT(var));
            m_pSet->Close();
			}  
	       catch(CDaoException* e){
		       m_CtrlList.SetItemText( nItem,2,"该项已删除");
			   m_CtrlList.SetItemText( nItem,3,"该项已删除");
		       e->Delete();}
			m_pRecordset->MoveNext();
			nItem++;
		}
	} 
	catch (CDaoException* e)
	{
		e->ReportError(); 
		e->Delete();
		return;
	}


} 

void CFindGiveback::OnFdgbCkreciever() 
{
    UpdateData(1);
	if(!m_CKReciever)
    {
		m_strReciever.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_RECIEVER)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_RECIEVER)->EnableWindow(1);	
	}	
}

void CFindGiveback::OnFdgbCklender() 
{
    UpdateData(1);
	if(!m_CKLender)
    {
		m_strLender.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_LENDER)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_LENDER)->EnableWindow(1);	
	}	
}

void CFindGiveback::OnFdgbCkborrower() 
{
   	UpdateData(1);
	if(!m_CKBorrower)
    {
		m_strBorrower.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_BORROWER)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_BORROWER)->EnableWindow(1);	
	}
}

void CFindGiveback::OnFdgbCkdepartment() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKDepartment)
    {
		m_CtrlCBDepartment.SetCurSel(-1);
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_DEPARTMENT)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_DEPARTMENT)->EnableWindow(1);	
	}	
}

void CFindGiveback::OnFdgbCkratifier() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKRatifier)
    {
		m_strRatifier.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_RATIFIER)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_RATIFIER)->EnableWindow(1);	
	}	
}

void CFindGiveback::OnFdgbCkassetid() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKAssetID)
    {
		m_strAssetID.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_ASSETID)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_ASSETID)->EnableWindow(1);	
	}
}

void CFindGiveback::OnFdgbCktype() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKType)
    {
		m_strType.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_TYPE)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_TYPE)->EnableWindow(1);	
	}
}

void CFindGiveback::OnFdgbCksort() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKSort)
    {
		m_CtrlCBSort.SetCurSel(-1);
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_SORT)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_SORT)->EnableWindow(1);	
	}
}

void CFindGiveback::OnFdgbCkname() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKName)
    {
		m_strName.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_NAME)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_NAME)->EnableWindow(1);	
	}
}

void CFindGiveback::OnFdgbCklndate() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKLNDate)
    {
		m_LNDate1=CTime::GetCurrentTime();
        m_LNDate2=CTime::GetCurrentTime();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_LNDATE1)->EnableWindow(0);
		(CComboBox*)GetDlgItem(IDC_FDGB_LNDATE2)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_LNDATE1)->EnableWindow(1);
		(CComboBox*)GetDlgItem(IDC_FDGB_LNDATE2)->EnableWindow(1);
	}
}

void CFindGiveback::OnFdgbCkgbdate() 
{
    UpdateData(1);
	if(!m_CKGBDate)
    {
		m_GBDate1=CTime::GetCurrentTime();
        m_GBDate2=CTime::GetCurrentTime();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDGB_GBDATE1)->EnableWindow(0);
		(CComboBox*)GetDlgItem(IDC_FDGB_GBDATE2)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDGB_GBDATE1)->EnableWindow(1);
		(CComboBox*)GetDlgItem(IDC_FDGB_GBDATE2)->EnableWindow(1);
	}	
}

void CFindGiveback::OnFdgbFind() 
{
    UpdateData(1);
	if(!m_pDatabase->IsOpen()) return;
	if(!m_pRecordset) return;
	if(m_pRecordset->IsOpen()) m_pRecordset->Close();
	CString sql,strSql="select * from 借出还入资产";
	if(m_CKLender)
	{
	   if(m_strLender.IsEmpty()==0)
	   {
	      sql.Format(" where 出借人 like '%s'",m_strLender);
          strSql+=sql;
		  flag1=1;
	   }
	}
	if(m_CKBorrower)
	{
	   if(m_strBorrower.IsEmpty()==0)
	   {
	      if(flag1)
              sql.Format(" and 借用人 like '%s'",m_strBorrower);
		  else 
		      sql.Format(" where 借用人 like '%s'",m_strBorrower);
          strSql+=sql;
		  flag1=1;
	   }
	}
    if(m_CKRatifier)
	{
	   if(m_strRatifier.IsEmpty()==0)
	   {
	      if(flag1)
              sql.Format(" and 批复人 like '%s'",m_strRatifier);
		  else 
		      sql.Format(" where 批复人  like '%s'",m_strRatifier);
          strSql+=sql;
		  flag1=1;
	   }
	}
	if(m_CKReciever)
	{
	   if(m_strReciever.IsEmpty()==0)
	   {
	      if(flag1)
              sql.Format(" and 接收人 like '%s'",m_strReciever);
		  else 
		      sql.Format(" where 接收人  like '%s'",m_strReciever);
          strSql+=sql;
		  flag1=1;
	   }
	}
	if(m_CKDepartment)
	{
	   if(m_CtrlCBDepartment.GetCurSel()!=-1)
	   {
	      if(flag1)
              sql.Format(" and 借用部门ID like %d",m_CtrlCBDepartment.GetItemData(m_CtrlCBDepartment.GetCurSel()));
		  else 
		      sql.Format(" where 借用部门ID  like %d",m_CtrlCBDepartment.GetItemData(m_CtrlCBDepartment.GetCurSel()));
          strSql+=sql;
		  flag1=1;
	   }
	}

	if(m_CKName||m_CKSort||m_CKType||m_CKAssetID)
	{
	   if(flag1)
         sql.Format(" and 资产ID in (select 资产ID from 资产信息");
	   else 
	     sql.Format(" where 资产ID in (select 资产ID from 资产信息");
       strSql+=sql;
	   if(m_CKName)
	   {  
           if(m_strName.IsEmpty()==0)
		   {
			   sql.Format( " where 资产名称= '%s'",m_strName );
			   flag2=1;
               strSql+=sql;
		   }

	   }
	   if(m_CKAssetID)
	   {
	       if(m_strAssetID.IsEmpty()==0)
		   {
		      if(flag2)
			    sql.Format( " and 资产编号 ='%s'",m_strAssetID );
			  else
                sql.Format( " where 资产编号= '%s'",m_strAssetID );
			  flag2=1;
              strSql+=sql;
		   }
	   }
	   if(m_CKType)
	   {
	       if(m_strType.IsEmpty()==0)
		   {
		      if(flag2)
			    sql.Format( " and 型号 = '%s'",m_strType );
			  else
                sql.Format( " where 型号= '%s'",m_strType );
			  flag2=1;
              strSql+=sql;
		   }
	   }
       if(m_CKSort)
	   {
	       if(m_CtrlCBSort.GetCurSel()!=-1)
		   {
		      if(flag2)
			    sql.Format( " and 资产类别ID=%d",m_CtrlCBSort.GetItemData(m_CtrlCBSort.GetCurSel()) );
			  else
                sql.Format( " where 资产类别ID=%d",m_CtrlCBSort.GetItemData(m_CtrlCBSort.GetCurSel()) );
			  flag2=1;
              strSql+=sql;
		   }
	   }
	   sql=")";
       strSql+=sql;
	}
	flag1=0;
	flag2=0;
	Refresh(strSql);	
}