findrepaired.cpp

一个用vc++做的数据库系统

			}
			var = m_pRecordset->GetFieldValue(12);
			if(CCrack::strVARIANT(var)=="FALSE") 
			{   
				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)
				{
				    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 CFindRepaired::OnFdrdCksddate() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKSDDate)
    {
		m_SDDate1=CTime::GetCurrentTime();
        m_SDDate2=CTime::GetCurrentTime();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDRD_SDDATE1)->EnableWindow(0);
		(CComboBox*)GetDlgItem(IDC_FDRD_SDDATE2)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDRD_SDDATE1)->EnableWindow(1);
		(CComboBox*)GetDlgItem(IDC_FDRD_SDDATE2)->EnableWindow(1);
	}
}

void CFindRepaired::OnFdrdCkrddate() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKRDDate)
    {
		m_RDDate1=CTime::GetCurrentTime();
        m_RDDate2=CTime::GetCurrentTime();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDRD_RDDATE1)->EnableWindow(0);
		(CComboBox*)GetDlgItem(IDC_FDRD_RDDATE2)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDRD_RDDATE1)->EnableWindow(1);
		(CComboBox*)GetDlgItem(IDC_FDRD_RDDATE2)->EnableWindow(1);
	}
}

void CFindRepaired::OnFdrdCksum() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKSum)
    {
		(CComboBox*)GetDlgItem(IDC_FDRD_SUM1)->EnableWindow(0);
		(CComboBox*)GetDlgItem(IDC_FDRD_SUM2)->EnableWindow(0);
		m_dSum1=0;
		m_dSum2=0;
		UpdateData(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDRD_SUM1)->EnableWindow(1);
		(CComboBox*)GetDlgItem(IDC_FDRD_SUM2)->EnableWindow(1);
	}
}

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

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

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

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

void CFindRepaired::OnFdrdCkrepairer() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKRepairer)
    {
		m_strRepairer.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDRD_REPAIRER)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDRD_REPAIRER)->EnableWindow(1);	
	}
}

void CFindRepaired::OnFdrdCksender() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKSender)
    {
		m_strSender.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDRD_SENDER)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDRD_SENDER)->EnableWindow(1);	
	}
}

void CFindRepaired::OnFdrdCkposition() 
{
	// TODO: Add your control notification handler code here
	UpdateData(1);
	if(!m_CKPosition)
    {
		m_strPosition.Empty();
        UpdateData(0);
        (CComboBox*)GetDlgItem(IDC_FDRD_POSITION)->EnableWindow(0);
	}
	else
	{
	    (CComboBox*)GetDlgItem(IDC_FDRD_POSITION)->EnableWindow(1);	
	}
}

void CFindRepaired::OnChangeFdrdSum1() 
{
   UpdateData(1);
	
}

void CFindRepaired::OnChangeFdrdSum2() 
{
	UpdateData(1);
}

void CFindRepaired::OnFdrdFind() 
{
    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_CKSender)
	{
	   if(m_strSender.IsEmpty()==0)
	   {
	      sql.Format(" where 送修人 like '%s'",m_strSender);
          strSql+=sql;
		  flag1=1;
	   }
	}
	if(m_CKRepairer)
	{
	   if(m_strRepairer.IsEmpty()==0)
	   {
	      if(flag1) 
             sql.Format(" and 维修人 like '%s'",m_strRepairer);
		  else
		     sql.Format(" where 维修人 like '%s'",m_strRepairer);
          strSql+=sql;
		  flag1=1;
	   }
	}
	if(m_CKPosition)
	{
	   if(m_strPosition.IsEmpty()==0)
	   {
	      if(flag1)
		     sql.Format("  and 维修地点 like '%s'",m_strPosition);
		  else
             sql.Format(" where 维修地点 like '%s'",m_strPosition);
          strSql+=sql;
		  flag1=1;
	   }
	}
	if(m_CKSum)
	{
	   if(m_dSum1>m_dSum2)
	   {
	      double temp;
		  temp=m_dSum1;m_dSum1=m_dSum2;m_dSum2=temp;
	   }
	   if(flag1)
          sql.Format(" and 金额 between %f and %f",m_dSum1,m_dSum2);
	   else
	      sql.Format(" where 金额 between %f and %f",m_dSum1,m_dSum2);
        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);	
}