dlgcs.cpp

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

				connection->BeginTrans();
				tabcs.CSBMBM.strValue = strCSBMBM;
				tabcs.CSZDMC.strValue = strCSZDMC;
				tabcs.CSZDMS.strValue = strCSZDMS;
				tabcs.CSZDXH.strValue = strCSZDXH;
				tabcs.CSQZFS.strValue = strCSQZFS;
				tabcs.CSZFQZ.strValue = strCSZFQZ;
				tabcs.CSSZQZ.strValue = strCSSZQZ;
				tabcs.CSQZMS.strValue = strCSQZMS;
				tabcs.CSJLZT.strValue = strCSJLZT;
				tabcs.CSBZXX.strValue = strCSBZXX;
				tabcs.AppendRecord();

				connection->CommitTrans();
				bRet = TRUE;
			}
			catch( _com_error &e )
			{
				AfxMessageBox( e.ErrorMessage() );
				bRet = FALSE;
				return;
			}
			bRet = TRUE;
			break;
		case 4:		//产品计量单位
			nCount = GetNextSN( "SP", "SPJLDW" );
			if( nCount <= 0 )
			{
				bRet = FALSE;
				AfxMessageBox( "系统错误！" );
				return;
			}

			strCSBMBM = "SP";
			strCSZDMC = "SPJLDW";
			m_ed_cszdms.GetWindowText( strCSZDMS );
			strCSZDXH.Format( "%ld", nCount );
			strCSQZFS = "1";
			strCSZFQZ.Format( "%ld", nCount );
			strCSSZQZ.Format( "%ld", nCount );
			m_ed_csqzms.GetWindowText( strCSQZMS );
			strCSJLZT = "1";
			strCSBZXX = " ";

			try
			{
				connection->BeginTrans();
				tabcs.CSBMBM.strValue = strCSBMBM;
				tabcs.CSZDMC.strValue = strCSZDMC;
				tabcs.CSZDMS.strValue = strCSZDMS;
				tabcs.CSZDXH.strValue = strCSZDXH;
				tabcs.CSQZFS.strValue = strCSQZFS;
				tabcs.CSZFQZ.strValue = strCSZFQZ;
				tabcs.CSSZQZ.strValue = strCSSZQZ;
				tabcs.CSQZMS.strValue = strCSQZMS;
				tabcs.CSJLZT.strValue = strCSJLZT;
				tabcs.CSBZXX.strValue = strCSBZXX;
				tabcs.AppendRecord();
				
				connection->CommitTrans();
				bRet = TRUE;
			}
			catch( _com_error &e )
			{
				bRet = FALSE;
				AfxMessageBox( e.ErrorMessage() );
			}

			bRet = TRUE;
			break;
		case 5:		//推广奖励最后结算日期
			bRet = FALSE;
			break;
		case 6:		//开户银行
			m_sta_cszdms.SetWindowText( "参数名称" );
			m_sta_cszfqz.SetWindowText( "字符取值" );
			m_sta_csqzms.SetWindowText( "银行名称" );
			m_sta_csszqz.SetWindowText( "数字取值" );
			m_ed_cszdms.SetWindowText( "开户银行" );
			m_ed_cszdms.EnableWindow( FALSE );
			m_ed_cszfqz.EnableWindow( FALSE );
			m_ed_csszqz.EnableWindow( FALSE );
			
			nCount = GetNextSN( "XC", "XCKHYH" );
			if( nCount <= 0 )
			{
				bRet = FALSE;
				AfxMessageBox( "系统错误！" );
				return;
			}

			strCSBMBM = "XC";
			strCSZDMC = "XCKHYH";
			m_ed_cszdms.GetWindowText( strCSZDMS );
			strCSZDXH.Format( "%ld", nCount );
			strCSQZFS = "1";
			strCSZFQZ.Format( "%ld", nCount );
			strCSSZQZ.Format( "%ld", nCount );
			m_ed_csqzms.GetWindowText( strCSQZMS );
			strCSJLZT = "1";
			strCSBZXX = " ";

			try
			{
				connection->BeginTrans();
				tabcs.CSBMBM.strValue = strCSBMBM;
				tabcs.CSZDMC.strValue = strCSZDMC;
				tabcs.CSZDMS.strValue = strCSZDMS;
				tabcs.CSZDXH.strValue = strCSZDXH;
				tabcs.CSQZFS.strValue = strCSQZFS;
				tabcs.CSZFQZ.strValue = strCSZFQZ;
				tabcs.CSSZQZ.strValue = strCSSZQZ;
				tabcs.CSQZMS.strValue = strCSQZMS;
				tabcs.CSJLZT.strValue = strCSJLZT;
				tabcs.CSBZXX.strValue = strCSBZXX;
				tabcs.AppendRecord();
				
				connection->CommitTrans();
				bRet = TRUE;
			}
			catch( _com_error &e )
			{
				bRet = FALSE;
				AfxMessageBox( e.ErrorMessage() );
			}
			bRet = TRUE;
			break;
		case 7:		//投资卡号
			/*
			m_sta_cszdms.SetWindowText( "参数名称" );
			m_sta_cszfqz.SetWindowText( "字符取值" );
			m_sta_csqzms.SetWindowText( "投资卡名" );
			m_sta_csszqz.SetWindowText( "数字取值" );
			m_ed_cszdms.SetWindowText( "投资卡号" );
			m_ed_cszdms.EnableWindow( FALSE );
			m_ed_cszfqz.EnableWindow( FALSE );
			m_ed_csszqz.EnableWindow( FALSE );
			m_ed_csqzms.EnableWindow( TRUE );
			GetDlgItem( IDOK )->EnableWindow( TRUE );
			*/
			bRet = FALSE;
			break;
		}
	}
	if( bRet ) CDialog::OnOK();
		else return;
}

void CDlgCS::OnSelchangeCbCsmc() 
{
	int nIndex = 0;

	nIndex = m_cb_csmc.GetItemData( m_cb_csmc.GetCurSel() );

	switch( nIndex )
	{
	case 0:
		break;
	case 1:		//督导奖励最后结算日期
		m_sta_cszdms.SetWindowText( "最后结算日期" );
		m_sta_cszfqz.SetWindowText( "最后日期" );
		m_sta_csqzms.SetWindowText( "取值描述" );
		m_sta_csszqz.SetWindowText( "数字取值" );
		m_ed_cszdms.EnableWindow( FALSE );
		m_ed_csqzms.EnableWindow( FALSE );
		m_ed_csszqz.EnableWindow( FALSE );
		m_ed_cszdms.SetWindowText( "督导奖励最后结算日期" );
		GetDlgItem( IDOK )->EnableWindow( FALSE );
		break;
	case 2:		//代理级别
		m_sta_cszdms.SetWindowText( "参数名称" );
		m_sta_cszfqz.SetWindowText( "字符取值" );
		m_sta_csqzms.SetWindowText( "级别名称" );
		m_sta_csszqz.SetWindowText( "数字取值" );
		m_ed_cszdms.SetWindowText( "代理级别" );
		m_ed_cszdms.EnableWindow( FALSE );
		m_ed_cszfqz.EnableWindow( FALSE );
		m_ed_csszqz.EnableWindow( FALSE );
		m_ed_csqzms.EnableWindow( TRUE );
		GetDlgItem( IDOK )->EnableWindow( TRUE );
		break;
	case 3:		//产品规格
		m_sta_cszdms.SetWindowText( "字段描述3" );
		m_sta_cszfqz.SetWindowText( "字符取值" );
		m_sta_csqzms.SetWindowText( "规格名称" );
		m_sta_csszqz.SetWindowText( "数字取值" );
		m_ed_cszdms.SetWindowText( "产品规格" );
		m_ed_cszdms.EnableWindow( FALSE );
		m_ed_cszfqz.EnableWindow( FALSE );
		m_ed_csszqz.EnableWindow( FALSE );
		m_ed_csqzms.EnableWindow( TRUE );
		GetDlgItem( IDOK )->EnableWindow( TRUE );
		break;
	case 4:		//产品计量单位
		m_sta_cszdms.SetWindowText( "参数名称" );
		m_sta_cszfqz.SetWindowText( "字符取值" );
		m_sta_csqzms.SetWindowText( "单位名称" );
		m_sta_csszqz.SetWindowText( "数字取值" );
		m_ed_cszdms.SetWindowText( "产品计量单位" );
		m_ed_cszdms.EnableWindow( FALSE );
		m_ed_cszfqz.EnableWindow( FALSE );
		m_ed_csszqz.EnableWindow( FALSE );
		m_ed_csqzms.EnableWindow( TRUE );
		GetDlgItem( IDOK )->EnableWindow( TRUE );
		break;
	case 5:		//推广奖励最后结算日期
		m_sta_cszdms.SetWindowText( "参数名称" );
		m_sta_cszfqz.SetWindowText( "字符取值" );
		m_sta_csqzms.SetWindowText( "取值描述" );
		m_sta_csszqz.SetWindowText( "数字取值" );
		m_ed_cszdms.SetWindowText( "推广奖励最后结算日期" );
		m_ed_cszdms.EnableWindow( FALSE );
		m_ed_cszfqz.EnableWindow( FALSE );
		m_ed_csszqz.EnableWindow( FALSE );
		GetDlgItem( IDOK )->EnableWindow( FALSE );
		break;
	case 6:		//开户银行
		m_sta_cszdms.SetWindowText( "参数名称" );
		m_sta_cszfqz.SetWindowText( "字符取值" );
		m_sta_csqzms.SetWindowText( "银行名称" );
		m_sta_csszqz.SetWindowText( "数字取值" );
		m_ed_cszdms.SetWindowText( "开户银行" );
		m_ed_cszdms.EnableWindow( FALSE );
		m_ed_cszfqz.EnableWindow( FALSE );
		m_ed_csszqz.EnableWindow( FALSE );
		m_ed_csqzms.EnableWindow( TRUE );
		GetDlgItem( IDOK )->EnableWindow( TRUE );
		break;
	case 7:		//投资卡号
		m_sta_cszdms.SetWindowText( "参数名称" );
		m_sta_cszfqz.SetWindowText( "字符取值" );
		m_sta_csqzms.SetWindowText( "投资卡名" );
		m_sta_csszqz.SetWindowText( "数字取值" );
		m_ed_cszdms.SetWindowText( "投资卡号" );
		m_ed_cszdms.EnableWindow( FALSE );
		m_ed_cszfqz.EnableWindow( FALSE );
		m_ed_csszqz.EnableWindow( FALSE );
		m_ed_csqzms.EnableWindow( TRUE );
		m_ed_csqzms.EnableWindow( TRUE );
		GetDlgItem( IDOK )->EnableWindow( TRUE ); 
		break;
	}
}

int CDlgCS::GetNextSN( char *pszTabName, char *pszColName )
{
	CTabCS tabcs;
	int nRet = 0;
	CString strSQL;

	try
	{
		strSQL.Format( "WHERE CSBMBM = '%s' AND CSZDMC = '%s'", pszTabName, pszColName );
		tabcs.Open( strSQL );
		while( tabcs.IsOpen() && !tabcs.IsEOF() )
		{
			nRet ++;
			tabcs.MoveNext();
		}
		nRet += 1;
	}
	catch ( _com_error &e )
	{
		AfxMessageBox( e.ErrorMessage() );
		nRet = 0;
	}
	catch ( ... )
	{
		AfxMessageBox( "未知错误！" );
		nRet = 0;
	}
	return nRet;
}