dlgxc.cpp

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

// DlgXC.cpp : implementation file
//

#include "stdafx.h"
#include "SellMan.h"
#include "DlgXC.h"

#include "TabXC.h"
#include "TabDL.h"
#include "TabSJ.h"
#include "TabCS.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDlgXC dialog

extern _ConnectionPtr connection;
extern BOOL bConnected;

CDlgXC::CDlgXC(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgXC::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgXC)
	m_ck_supplier = FALSE;
	//}}AFX_DATA_INIT
	InitCtrol();
	m_nOperType = MODE_APPEND;
}


void CDlgXC::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgXC)
	DDX_Control(pDX, IDC_CB_XCSJDL, m_cb_xcsjdl);
	DDX_Control(pDX, IDC_CB_XCDLJB, m_cb_xcdljb);
	DDX_Control(pDX, IDC_ED_XCDLMC, m_ed_xcdlmc);
	DDX_Control(pDX, IDC_ED_XCDLBH, m_ed_xcdlbh);
	DDX_Control(pDX, IDC_ED_DLJHJE, m_ed_dljhje);
	DDX_Control(pDX, IDC_ED_XCYHZH, m_ed_xcyhzh);
	DDX_Control(pDX, IDC_ED_XCYGMC, m_ed_xcygmc);
	DDX_Control(pDX, IDC_ED_XCYGDH, m_ed_xcygdh);
	DDX_Control(pDX, IDC_ED_XCYGBH, m_ed_xcygbh);
	DDX_Control(pDX, IDC_ED_XCBZXX, m_ed_xcbzxx);
	DDX_Control(pDX, IDC_DT_XCJRRQ, m_dt_xcjrrq);
	DDX_Control(pDX, IDC_CB_XCYGZG, m_cb_xcygzg);
	DDX_Control(pDX, IDC_CB_XCTZKH, m_cb_xctzkh);
	DDX_Control(pDX, IDC_CB_XCTJRH, m_cb_xctjrh);
	DDX_Control(pDX, IDC_CB_XCKHYH, m_cb_xckhyh);
	DDX_Control(pDX, IDC_CB_XCDLCH, m_cb_xcdlch);
	DDX_Check(pDX, IDC_CK_SUPPLIER, m_ck_supplier);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgXC, CDialog)
	//{{AFX_MSG_MAP(CDlgXC)
	ON_BN_CLICKED(IDC_BT_NEXT, OnBtNext)
	ON_BN_CLICKED(IDC_CK_SUPPLIER, OnCkSupplier)

	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgXC message handlers

BOOL CDlgXC::OnInitDialog() 
{
	CDialog::OnInitDialog();

	CTabCS tabcs;
	CTabXC tabxc;
	CTabSJ tabsj;
	CTabDL tabdl;
	SYSTEMTIME sysTime;
	
	try
	{
		tabcs.Open( "where csbmbm = 'XC' and cszdmc = 'XCTZKH'" );
		while( tabcs.IsOpen() && !tabcs.IsEOF() )
		{
			m_cb_xctzkh.SetItemData( m_cb_xctzkh.AddString( tabcs.CSQZMS.GetValue() ), (DWORD)atol( tabcs.CSZFQZ.GetValue() ) );
			tabcs.MoveNext();
		}

		tabcs.Open( "where csbmbm = 'XC' and cszdmc = 'XCKHYH'" );
		while( tabcs.IsOpen() && !tabcs.IsEOF() )
		{
			m_cb_xckhyh.SetItemData( m_cb_xckhyh.AddString( tabcs.CSQZMS.GetValue() ), (DWORD)atol( tabcs.CSZFQZ.GetValue() ) );
			tabcs.MoveNext();
		}

		tabxc.Open();
		while( tabxc.IsOpen() && !tabxc.IsEOF() )
		{
			m_cb_xcygzg.SetItemData( m_cb_xcygzg.AddString( tabxc.XCYGID.GetValue() + " " + tabxc.XCYGMC.GetValue() ), atol( tabxc.XCYGID.GetValue() ) );
			m_cb_xctjrh.SetItemData( m_cb_xctjrh.AddString( tabxc.XCYGID.GetValue() + " " + tabxc.XCYGMC.GetValue() ), atol( tabxc.XCYGID.GetValue() ) );
			tabxc.MoveNext();
		}

		tabsj.Open();
		while( tabsj.IsOpen() && !tabsj.IsEOF() )
		{
			m_cb_xcdlch.SetItemData( m_cb_xcdlch.AddString( tabsj.SJDLCM.GetValue() ), atol( tabsj.SJDLCH.GetValue() ) );
			tabsj.MoveNext();
		}

		tabcs.Open( "where csbmbm = 'DL' and cszdmc = 'DLDLJB'" );
		while( tabcs.IsOpen() && !tabcs.IsEOF() )
		{
			m_cb_xcdljb.SetItemData( m_cb_xcdljb.AddString( tabcs.CSQZMS.GetValue() ), (DWORD)atol( tabcs.CSZFQZ.GetValue() ) );
			tabcs.MoveNext();
		}

		tabdl.Open( "where dljlzt <> 0" );
		while( tabdl.IsOpen() && !tabdl.IsEOF() )
		{
			m_cb_xcsjdl.SetItemData( m_cb_xcsjdl.AddString( tabdl.DLDLMC.GetValue() ), atol( tabdl.DLDLID.GetValue() ) );
			tabdl.MoveNext();
		}

		if( m_nOperType == MODE_MODIFY )
		{
			m_ed_xcyhzh.SetWindowText( strxcyhzh );
			m_ed_xcygmc.SetWindowText( strxcygmc );
			m_ed_xcygdh.SetWindowText( strxcygdh );
			m_ed_xcygbh.SetWindowText( strxcygbh );
			m_ed_xcbzxx.SetWindowText( strxcbzxx );
			memset( &sysTime, 0, sizeof( SYSTEMTIME ) );
			sysTime.wYear  = atoi( strxcjrrq.Left( 4 ) );
			sysTime.wMonth = atoi( strxcjrrq.Left( 6 ).Right( 2 ) );
			sysTime.wDay   = atoi( strxcjrrq.Left( 8 ).Right( 2 ) );
			m_dt_xcjrrq.SetTime( &sysTime );
			m_cb_xcygzg.SelectString( -1, strxcygzg );
			m_cb_xctzkh.SelectString( -1, strxctzkh );
			m_cb_xctjrh.SelectString( -1, strxctjrh );
			m_cb_xckhyh.SelectString( -1, strxckhyh );
			m_cb_xcdlch.SelectString( -1, strxcdlch );
			m_ed_xcygbh.EnableWindow( FALSE );
			//if( atoi( strxcdlmc ) ) m_ck_supplier = TRUE;
			if ( m_ck_supplier )
			{
				m_ed_xcdlbh.SetWindowText( strxcdlbh.GetBuffer( 0 ) );
				m_ed_xcdlmc.SetWindowText( strxcdlmc.GetBuffer( 0 ) );
				m_ed_dljhje.SetWindowText( strdljhje.GetBuffer( 0 ) );

				m_cb_xcdljb.SetCurSel( atoi( strxcdljb )  );
				m_cb_xcsjdl.SetCurSel( atoi( strxcsjdl ) );
				m_ed_xcdlmc.EnableWindow( TRUE );
				m_ed_xcdlbh.EnableWindow( FALSE );
				m_ed_dljhje.EnableWindow( TRUE );
				m_cb_xcdljb.EnableWindow( TRUE );
				m_cb_xcsjdl.EnableWindow( TRUE );
				GetDlgItem( IDC_CK_SUPPLIER )->EnableWindow( FALSE );
			}
			UpdateData( FALSE );
		}
		else
		{
			m_cb_xctzkh.SetCurSel( 0 );
			m_cb_xckhyh.SetCurSel( 0 );
			m_cb_xcygzg.SetCurSel( 0 );
			m_cb_xctjrh.SetCurSel( 0 );
			m_cb_xcdlch.SetCurSel( 0 );
			m_cb_xcdljb.SetCurSel( 0 );
			m_cb_xcsjdl.SetCurSel( 0 );
		}
	}
	
	catch( _com_error &e )
	{
		AfxMessageBox( e.ErrorMessage() );
	}
	catch( ... )
	{
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgXC::OnOK() 
{
	BOOL bRet = FALSE;
	char szSQL[ 255 ];
	CTabXC tabxc;
	CTabDL tabdl;
	SYSTEMTIME sysTime;
	CString strTmp;
	UpdateData();
	
	m_ed_xcyhzh.GetWindowText( strxcyhzh );
	m_ed_xcygmc.GetWindowText( strxcygmc );
	m_ed_xcygdh.GetWindowText( strxcygdh );
	m_ed_xcygbh.GetWindowText( strxcygbh );
	m_ed_xcbzxx.GetWindowText( strxcbzxx );
	//m_cb_xcygzg.GetWindowText( strxcygzg );
	strxcygzg.Format( "%d", (long)m_cb_xcygzg.GetItemData( m_cb_xcygzg.GetCurSel() ) );
	strxctzkh.Format( "%d", (long)m_cb_xctzkh.GetItemData( m_cb_xctzkh.GetCurSel() ) );
//	m_cb_xctzkh.GetWindowText( strxctzkh );
	//m_cb_xctjrh.GetWindowText( strxctjrh );
	strxctjrh.Format( "%d", (long)m_cb_xctjrh.GetItemData( m_cb_xctjrh.GetCurSel() ) );
	strxckhyh.Format( "%d", (long)m_cb_xckhyh.GetItemData( m_cb_xckhyh.GetCurSel() ) );
//	m_cb_xckhyh.GetWindowText( strxckhyh );
	m_cb_xcdlch.GetWindowText( strxcdlch );
	strxcdlch.Format( "%d", (long)m_cb_xcdlch.GetItemData( m_cb_xcdlch.GetCurSel() ) );
	m_ed_xcdlmc.GetWindowText( strdldlmc );
	m_ed_xcdlbh.GetWindowText( strxcdlbh );
	m_ed_dljhje.GetWindowText( strdljhje );
	//m_cb_xcdljb.GetWindowText( strxcdljb );
	//m_cb_xcsjdl.GetWindowText( strxcsjdl );
	strxcsjdl.Format( "%d", (long)m_cb_xcsjdl.GetItemData( m_cb_xcsjdl.GetCurSel() ) );
	strxcdljb.Format( "%d", (long)m_cb_xcdljb.GetItemData( m_cb_xcdljb.GetCurSel() ) );
	memset( &sysTime, 0, sizeof( SYSTEMTIME ) );
	m_dt_xcjrrq.GetTime( &sysTime );
	strxcjrrq.Format( "%04d%02d%02d", sysTime.wYear, sysTime.wMonth, sysTime.wDay );

	strxcygbh.TrimLeft();
	strxcygbh.TrimRight();
	strxcygmc.TrimLeft();
	strxcygmc.TrimRight();

	if( strxcygbh.IsEmpty() )
	{
		AfxMessageBox( "员工编号不能为空！" );
		return;
	}

	if( strxcygmc.IsEmpty() )
	{
		AfxMessageBox( "员工名称不能为空！" );
		return;
	}

	if( m_ck_supplier )
	{
		strxcdlbh.TrimLeft();
		strxcdlbh.TrimRight();
		strdldlmc.TrimLeft();
		strdldlmc.TrimRight();
		strdljhje.TrimLeft();
		strdljhje.TrimRight();

		if( strxcdlbh.IsEmpty() )
		{
			AfxMessageBox( "代理商编号不能为空！" );
			return;
		}

		if( strdldlmc.IsEmpty() )
		{
			AfxMessageBox( "代理商名称不能为空！" );
			return;
		}

		if( strdljhje.IsEmpty() )
		{
			AfxMessageBox( "代理商首次进货金额不能为空！" );
			return;
		}
	}

	try
	{
		connection->BeginTrans();
		if( m_nOperType == MODE_MODIFY )
		{
			if ( CheckValue(2) )
			{
				connection->CommitTrans();
				return;
			}