dlgxc.cpp

我自己整理的一些VC源代码

			sprintf( szSQL, "where xcygid = %s", strxcygid );
			if( tabxc.Open( szSQL ) )
			{
				
				if( m_ck_supplier )
				{
					sprintf( szSQL, "where dldlid = '%s'", strdldlid );
					if( tabdl.Open( szSQL ) )
					{
						//strdldlid.Format( "%ld", tabdl.GetNextID( "DLDLID" ) );
						//tabdl.DLDLID.strValue = strdldlid;
						//tabdl.DLDLBH.strValue = strxcdlbh;
						tabdl.DLDLMC.strValue = strdldlmc;
						tabdl.DLDLDH.strValue = strxcygdh;
						tabdl.DLKHYH.strValue = strxckhyh;
						tabdl.DLYHZH.strValue = strxcyhzh;
						tabdl.DLJRRQ.strValue = strxcjrrq;
						tabdl.DLFZRM.strValue = strxcygmc;
						strTmp.Format( "%ld", (long)m_cb_xcdljb.GetItemData( m_cb_xcdljb.GetCurSel() ) );
						tabdl.DLDLJB.strValue = strTmp;
						strTmp.Format( "%.f", atof( strdljhje.GetBuffer( 0 ) )*100 );
						tabdl.DLJHJE.strValue = strTmp;
						tabdl.DLDLZT.strValue = "1";
						strTmp.Format( "%ld", (long)m_cb_xcygzg.GetItemData( m_cb_xcygzg.GetCurSel( ) ) );
						tabdl.DLDLZG.strValue = strTmp;
						strTmp.Format( "%ld", (long)m_cb_xctjrh.GetItemData( m_cb_xctjrh.GetCurSel() ) );
						tabdl.DLTJRH.strValue = strTmp;
						strTmp.Format( "%ld", (long)m_cb_xcsjdl.GetItemData( m_cb_xcsjdl.GetCurSel() ) );
						tabdl.DLSJDL.strValue = strTmp;
						strTmp.Format( "%ld", (long)m_cb_xcdlch.GetItemData( m_cb_xcdlch.GetCurSel() ) );
						tabdl.DLDLCH.strValue = strTmp;
						tabdl.DLJLZT.strValue = "1";
						tabdl.DLBZXX.strValue = strxcbzxx;
						tabdl.UpdateRecord();
					}
					else
					{
						strdldlid.Format( "%ld", tabdl.GetNextID( "DLDLID" ) );
						tabdl.DLDLID.strValue = strdldlid;
						tabdl.DLDLBH.strValue = strxcdlbh;
						tabdl.DLDLMC.strValue = strdldlmc;
						tabdl.DLDLDH.strValue = strxcygdh;
						tabdl.DLKHYH.strValue = strxckhyh;
						tabdl.DLYHZH.strValue = strxcyhzh;
						tabdl.DLJRRQ.strValue = strxcjrrq;
						tabdl.DLFZRM.strValue = strxcygmc;
						strTmp.Format( "%ld", (long)m_cb_xcdljb.GetItemData( m_cb_xcdljb.GetCurSel() ) );
						tabdl.DLDLJB.strValue = strTmp;
						strTmp.Format( "%.f", atof( strdljhje.GetBuffer( 0 ) )*100 );
						tabdl.DLJHJE.strValue = strTmp;
						//tabdl.DLJHJE.strValue = strdljhje;
						tabdl.DLDLZT.strValue = "1";
						strTmp.Format( "%ld", (long)m_cb_xcygzg.GetItemData( m_cb_xcygzg.GetCurSel( ) ) );
						tabdl.DLDLZG.strValue = strTmp;
						strTmp.Format( "%ld", (long)m_cb_xctjrh.GetItemData( m_cb_xctjrh.GetCurSel() ) );
						tabdl.DLTJRH.strValue = strTmp;
						strTmp.Format( "%ld", (long)m_cb_xcsjdl.GetItemData( m_cb_xcsjdl.GetCurSel() ) );
						tabdl.DLSJDL.strValue = strTmp;
						strTmp.Format( "%ld", (long)m_cb_xcdlch.GetItemData( m_cb_xcdlch.GetCurSel() ) );
						tabdl.DLDLCH.strValue = strTmp;
						tabdl.DLJLZT.strValue = "1";
						tabdl.DLBZXX.strValue = strxcbzxx;
						tabdl.AppendRecord();
					}
				}

				//strxcygid.Format( "%ld", tabxc.GetNextID( "XCYGID" ) );
				//tabxc.XCYGID.strValue = strxcygid;
				tabxc.XCYGBH.strValue = strxcygbh;
				tabxc.XCYGMC.strValue = strxcygmc;
				tabxc.XCYGDH.strValue = strxcygdh;
				strTmp.Format( "%ld", (long)m_cb_xckhyh.GetItemData( m_cb_xckhyh.GetCurSel() ) );
				tabxc.XCKHYH.strValue = strTmp;
				tabxc.XCYHZH.strValue = strxcyhzh;
				strTmp.Format( "%ld", (long)m_cb_xctzkh.GetItemData( m_cb_xctzkh.GetCurSel() ) );
				tabxc.XCTZKH.strValue = strTmp;
				tabxc.XCJRRQ.strValue = strxcjrrq;
				//strTmp.Format( "%ld", (long)m_cb_xcdlmc.GetItemData( m_cb_xcdlmc.GetCurSel() ) );
				if ( m_ck_supplier ) tabxc.XCDLMC.strValue = strdldlid;
				else tabxc.XCDLMC.strValue = "0";
				strTmp.Format( "%ld", (long)m_cb_xcdlch.GetItemData( m_cb_xcdlch.GetCurSel() ) );
				tabxc.XCDLCH.strValue = strTmp;
				tabxc.XCYGZT.strValue = "1";
				tabxc.XCYBYE.strValue = "0";
				tabxc.XCEBYE.strValue = "0";
				tabxc.XCJSRQ.strValue = "19700101";
				strTmp.Format( "%ld", (long)m_cb_xcygzg.GetItemData( m_cb_xcygzg.GetCurSel() ) );
				tabxc.XCYGZG.strValue = strTmp;
				strTmp.Format( "%ld", (long)m_cb_xctjrh.GetItemData( m_cb_xctjrh.GetCurSel() ) );
				tabxc.XCTJRH.strValue = strTmp;
				tabxc.XCJSBZ.strValue = "0";
				tabxc.XCJLZT.strValue = "1";
				tabxc.XCBZXX.strValue = strxcbzxx;
				tabxc.UpdateRecord();
				bRet = TRUE;
			}
		}
		else
		{
		//	connection->BeginTrans();
			if ( CheckValue(1) ) return;
			if( m_ck_supplier )
			{
				
				sprintf( szSQL, "where dldlbh = '%s'", strxcdlbh );
				if( !tabdl.Open( szSQL ) )
				{
					strdldlid.Format( "%ld", tabdl.GetNextID( "DLDLID" ) );
					tabdl.DLDLID.strValue = strdldlid;
					tabdl.DLDLBH.strValue = strxcdlbh;
					tabdl.DLDLMC.strValue = strdldlmc;
					tabdl.DLDLDH.strValue = strxcygdh;
					tabdl.DLKHYH.strValue = strxckhyh;
					tabdl.DLYHZH.strValue = strxcyhzh;
					tabdl.DLJRRQ.strValue = strxcjrrq;
					tabdl.DLFZRM.strValue = strxcygmc;
					strTmp.Format( "%ld", (long)m_cb_xcdljb.GetItemData( m_cb_xcdljb.GetCurSel() ) );
					tabdl.DLDLJB.strValue = strTmp;
					strTmp.Format( "%.f", atof( strdljhje.GetBuffer( 0 ) )*100 );
					tabdl.DLJHJE.strValue = strTmp;
					//tabdl.DLJHJE.strValue = strdljhje;
					tabdl.DLDLZT.strValue = "1";
					strTmp.Format( "%ld", (long)m_cb_xcygzg.GetItemData( m_cb_xcygzg.GetCurSel( ) ) );
					tabdl.DLDLZG.strValue = strTmp;
					strTmp.Format( "%ld", (long)m_cb_xctjrh.GetItemData( m_cb_xctjrh.GetCurSel() ) );
					tabdl.DLTJRH.strValue = strTmp;
					strTmp.Format( "%ld", (long)m_cb_xcsjdl.GetItemData( m_cb_xcsjdl.GetCurSel() ) );
					tabdl.DLSJDL.strValue = strTmp;
					strTmp.Format( "%ld", (long)m_cb_xcdlch.GetItemData( m_cb_xcdlch.GetCurSel() ) );
					tabdl.DLDLCH.strValue = strTmp;
					tabdl.DLJLZT.strValue = "1";
					tabdl.DLBZXX.strValue = strxcbzxx;
					tabdl.AppendRecord();
				}
				else return;
			}

			sprintf( szSQL, "where xcygbh = '%s'", strxcygbh );
			if( !tabxc.Open( szSQL ) )
			{
				strxcygid.Format( "%ld", tabxc.GetNextID( "XCYGID" ) );
				tabxc.XCYGID.strValue = strxcygid;
				tabxc.XCYGBH.strValue = strxcygbh;
				tabxc.XCYGMC.strValue = strxcygmc;
				tabxc.XCYGDH.strValue = strxcygdh;
				strTmp.Format( "%ld", (long)m_cb_xckhyh.GetItemData( m_cb_xckhyh.GetCurSel() ) );
				tabxc.XCKHYH.strValue = strTmp;
				tabxc.XCYHZH.strValue = strxcyhzh;
				strTmp.Format( "%ld", (long)m_cb_xctzkh.GetItemData( m_cb_xctzkh.GetCurSel() ) );
				tabxc.XCTZKH.strValue = strTmp;
				tabxc.XCJRRQ.strValue = strxcjrrq;
				//strTmp.Format( "%ld", (long)m_cb_xcdlmc.GetItemData( m_cb_xcdlmc.GetCurSel() ) );
				if ( m_ck_supplier ) tabxc.XCDLMC.strValue = strdldlid;
				else tabxc.XCDLMC.strValue = "0";
				strTmp.Format( "%ld", (long)m_cb_xcdlch.GetItemData( m_cb_xcdlch.GetCurSel() ) );
				tabxc.XCDLCH.strValue = strTmp;
				tabxc.XCYGZT.strValue = "1";
				tabxc.XCYBYE.strValue = "0";
				tabxc.XCEBYE.strValue = "0";
				tabxc.XCJSRQ.strValue = "19700101";
				strTmp.Format( "%ld", (long)m_cb_xcygzg.GetItemData( m_cb_xcygzg.GetCurSel() ) );
				tabxc.XCYGZG.strValue = strTmp;
				strTmp.Format( "%ld", (long)m_cb_xctjrh.GetItemData( m_cb_xctjrh.GetCurSel() ) );
				tabxc.XCTJRH.strValue = strTmp;
				tabxc.XCJSBZ.strValue = "0";
				tabxc.XCJLZT.strValue = "1";
				tabxc.XCBZXX.strValue = strxcbzxx;
				tabxc.AppendRecord();
				bRet = TRUE;
			}
		}
		connection->CommitTrans();
	}
	catch( _com_error &e )
	{
		connection->RollbackTrans();
		AfxMessageBox( e.ErrorMessage() );
	}
	catch( ... )
	{
		connection->RollbackTrans();
	}
	
	if( bRet ) CDialog::OnOK();
}

void CDlgXC::OnBtNext() 
{
	NextDlgCtrl();
}

void CDlgXC::OnCkSupplier() 
{
	UpdateData();

	if( m_ck_supplier )
	{
		m_ed_xcdlmc.EnableWindow( TRUE );
		m_ed_xcdlbh.EnableWindow( TRUE );
		m_ed_dljhje.EnableWindow( TRUE );
		m_cb_xcdljb.EnableWindow( TRUE );
		m_cb_xcsjdl.EnableWindow( TRUE );
	}
	else
	{
		m_ed_xcdlmc.EnableWindow( FALSE );
		m_ed_xcdlbh.EnableWindow( FALSE );
		m_ed_dljhje.EnableWindow( FALSE );
		m_cb_xcdljb.EnableWindow( FALSE );
		m_cb_xcsjdl.EnableWindow( FALSE );
	}
}

BOOL CDlgXC::CheckValue( int nmodify )
{
	CAdoSet		adoset;
	CMyField	field;
	int			nzgid, nzgnum = 0;
	char		szSQL[250];

	nzgid = m_cb_xcygzg.GetItemData( m_cb_xcygzg.GetCurSel() );
	memset( szSQL, 0, 250 );
	sprintf( szSQL, "SELECT COUNT(*) FROM XC WHERE XCYGZG = %d AND XCDLMC <= 0", nzgid );
	adoset.Query( szSQL, &field, 1 );
	if ( adoset.IsOpen() ) nzgnum = atoi( field.GetValue().GetBuffer( 0 ) );
	
	memset( szSQL, 0, 250 );
	sprintf( szSQL, "SELECT COUNT(*) FROM DL WHERE DLDLZG = %d", nzgid );
	adoset.Query( szSQL, &field, 1 );
	if ( adoset.IsOpen() ) nzgnum = nzgnum + atoi( field.GetValue().GetBuffer( 0 ) );

	if ( nzgnum <= nmodify ) 
		return false;
	else
	{
		AfxMessageBox( "该主管已经出现两个" );
		return true;
	}
	
}



void CDlgXC::InitCtrol()
{
	 strxcygid = "";
	 strxcygbh = " ";
	 strxcygmc = " ";
	 strxcygdh = " ";
	 strxckhyh = " ";
	 strxcyhzh = " ";
	 strxctzkh = " ";
	 strxcjrrq = " ";
	 strxcdlmc = " ";
	 strxcdlch = " ";
	 strxcygzt = " ";
	 strxcybye = " ";
	 strxcebye = " ";
	 strxcjsrq = " ";
	 strxcygzg = " ";
	 strxctjrh = " ";
	 strxcjsbz = " ";
	 strxcjlzt = " ";
	 strxcbzxx = " ";

	 strxcdlbh = " ";
	 strdljhje = " ";
	 strdldlmc = " ";
	 strdldljb = " ";
	 strdlsjdl = " ";
	 strdldlid = " ";

	 strxcdljb = " ";
	 strxcsjdl = " ";
}