dcustoms.cpp

用VC+SQL实现的物流管理系统 “RxMediaPlayer” 文件夹中存放《物流综合管理系统》中《媒体播放平台》源程序 “数据库设置”文件夹中存放《物流综合管理系统》辅助工具《数据库设置》源程

// DCustoms.cpp : implementation file
//

#include "stdafx.h"
#include "MyProject.h"
#include "DCustoms.h"
#include "ExternDllHeader.h"
#include "resource.h"
#include "DBaseQuery.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDCustoms dialog


CDCustoms::CDCustoms(int nStyle,CWnd* pParent /*=NULL*/)
	: CDialog(CDCustoms::IDD, pParent)
{
	m_nStyle=nStyle;
	//{{AFX_DATA_INIT(CDCustoms)

	//}}AFX_DATA_INIT
}


void CDCustoms::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDCustoms)
	DDX_Control(pDX, IDC_COMYWLB, m_ComYWLB);
	DDX_Control(pDX, IDC_LIST1, m_Grid);
	DDX_Control(pDX, IDC_EDTZYWBH2, m_EdtZYWBH2);
	DDX_Control(pDX, IDC_EDTZYWBH, m_EdtZYWBH);
	DDX_Control(pDX, IDC_EDTZXG, m_EdtZXG);
	DDX_Control(pDX, IDC_EDTZSBL, m_EdtZSBL);
	DDX_Control(pDX, IDC_EDTZF, m_EdtZF);
	DDX_Control(pDX, IDC_EDTZDY, m_EdtZDY);
	DDX_Control(pDX, IDC_EDTYT, m_EdtYT);
	DDX_Control(pDX, IDC_EDTYSGJ, m_EdtYSGJ);
	DDX_Control(pDX, IDC_EDTYLRBH, m_EdtYLRBH);
	DDX_Control(pDX, IDC_EDTXKZH, m_EdtXKZH);
	DDX_Control(pDX, IDC_EDTYF, m_EdtYF);
	DDX_Control(pDX, IDC_EDTTYDH, m_EdtTYDH);
	DDX_Control(pDX, IDC_EDTSHY, m_EdtSHY);
	DDX_Control(pDX, IDC_EDTSHDW, m_EdtSHDW);
	DDX_Control(pDX, IDC_EDTSFDJ, m_EdtSFDJ);
	DDX_Control(pDX, IDC_EDTQYG, m_EdtQYG);
	DDX_Control(pDX, IDC_EDTPZWH, m_EdtPZWH);
	DDX_Control(pDX, IDC_EDTMZ, m_EdtMZ);
	DDX_Control(pDX, IDC_EDTLRRBM, m_EdtLRRBM);
	DDX_Control(pDX, IDC_EDTLRR, m_EdtLRR);
	DDX_Control(pDX, IDC_EDTJZXH, m_EdtJZXH);
	DDX_Control(pDX, IDC_EDTJZ, m_EdtJZ);
	DDX_Control(pDX, IDC_EDTJYDW, m_EdtJYDW);
	DDX_Control(pDX, IDC_EDTJS, m_EdtJS);
	DDX_Control(pDX, IDC_EDTJNMDD, m_EdtJNMDD);
	DDX_Control(pDX, IDC_EDTHTXY, m_EdtHTXY);
	DDX_Control(pDX, IDC_EDTHGBH, m_EdtHGBH);
	DDX_Control(pDX, IDC_EDTCKKA, m_EdtCKKA);
	DDX_Control(pDX, IDC_EDTBGYWBH, m_EdtBGYWBH);
	DDX_Control(pDX, IDC_EDTBZ, m_EdtBZ);
	DDX_Control(pDX, IDC_EDTBGY, m_EdtBGY);
	DDX_Control(pDX, IDC_EDTBGFB, m_EdtTBGFB);
	DDX_Control(pDX, IDC_EDTBF, m_EdtTBF);
	DDX_Control(pDX, IDC_EDTBAH, m_EdtBAH);
	DDX_Control(pDX, IDC_DTSHSJ, m_DtSHSJ);
	DDX_Control(pDX, IDC_DTSBRQ, m_DtSBRQ);
	DDX_Control(pDX, IDC_DTLRSJ, m_DtLRSL);
	DDX_Control(pDX, IDC_DTJKRQ, m_DtJKRQ);
  	DDX_Control(pDX, IDC_DTDATE1, m_DtDate1);
	DDX_Control(pDX, IDC_DTDATE4, m_DtDate2);
	DDX_Control(pDX, IDC_DTFIND1, m_DtFind1);
	DDX_Control(pDX, IDC_DTFIND2, m_DtFind2);


	DDX_Control(pDX, IDC_COMZMXZ, m_ComZMXZ);
	DDX_Control(pDX, IDC_COMYSFS, m_ComYSFS);
	DDX_Control(pDX, IDC_COMMYFS, m_ComMYFS);
	DDX_Control(pDX, IDC_COMCJFS, m_ComCJFS);
	DDX_Control(pDX, IDC_COMBZZL, m_ComBzzl);
	DDX_Control(pDX, IDC_COMBZ, m_ComBZ);
	DDX_Control(pDX, IDC_COMBGLB, m_ComBGLB);
	DDX_Control(pDX, IDC_COMFIELD, m_ComField);
	DDX_Control(pDX, IDC_COMEMBLEM, m_ComEmblem);

	DDX_Control(pDX, IDC_CHKSHBZ, m_CHKSHBZ);
	DDX_Control(pDX, IDC_CHKDATE, m_ChkDate);
	DDX_Control(pDX, IDC_CHKSFJZ, m_ChkSFJZ);
	DDX_Control(pDX, IDC_BUTUNDO, m_ButUndo);
	DDX_Control(pDX, IDC_BUTSAVE, m_ButSave);
	DDX_Control(pDX, IDC_BUTNEW, m_ButNew);
	DDX_Control(pDX, IDC_BUTEXIT, m_ButExit);
	DDX_Control(pDX, IDC_BUTDELE, m_ButDele);
	DDX_Control(pDX, IDC_EDTCONDITION, m_EdtConditiom);
	DDX_Control(pDX, IDC_BUTQUERY, m_ButQuery);
	DDX_Control(pDX, IDC_BUTCHANGE, m_ButChange);
	DDX_Control(pDX, IDC_STAKA, m_StaKA);
	DDX_Control(pDX, IDC_STARQ, m_StaRQ);
	DDX_Control(pDX, IDC_STADW, m_StaDW);
	DDX_Control(pDX, IDC_STASS, m_StaSS);
	DDX_Control(pDX, IDC_STAGJ, m_StaGJ);
	DDX_Control(pDX, IDC_STAJN, m_StaJN);
	DDX_Control(pDX, IDC_STAYT, m_StaYT);
	DDX_Control(pDX, IDC_STAJZXH, m_StaJZXH);
	DDX_Control(pDX, IDC_STABZ, m_StaBZ);
	DDX_Control(pDX, IDC_STAJZXH, m_StaJZXH);
	DDX_Control(pDX, IDC_STASFDJ, m_StaSFDJ);
	DDX_Control(pDX, IDC_STAYWBH, m_StaYWBH);
	DDX_Control(pDX, IDC_STAZXG, m_StaZXG);

	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDCustoms, CDialog)
	//{{AFX_MSG_MAP(CDCustoms)
	ON_BN_CLICKED(IDC_BUTNEW, OnButnew)
	ON_CBN_KILLFOCUS(IDC_COMYSFS, OnKillfocusComysfs)
	ON_CBN_KILLFOCUS(IDC_COMMYFS, OnKillfocusCommyfs)
	ON_CBN_KILLFOCUS(IDC_COMZMXZ, OnKillfocusComzmxz)
	ON_CBN_KILLFOCUS(IDC_COMBZZL, OnKillfocusCombzzl)
	ON_CBN_KILLFOCUS(IDC_COMBZ, OnKillfocusCombz)
	ON_CBN_KILLFOCUS(IDC_COMCJFS, OnKillfocusComcjfs)
	ON_EN_KILLFOCUS(IDC_EDTBGYWBH, OnKillfocusEdtbgywbh)

	ON_EN_CHANGE(IDC_EDTZYWBH, OnChangeEdtzywbh)
	ON_BN_CLICKED(IDC_BUTCHANGE, OnButchange)
	ON_BN_CLICKED(IDC_BUTDELE, OnButdele)
	ON_BN_CLICKED(IDC_BUTSAVE, OnButsave)
	ON_BN_CLICKED(IDC_BUTUNDO, OnButundo)
	ON_BN_CLICKED(IDC_BUTEXIT, OnButexit)
	ON_BN_CLICKED(IDC_BUTEXIT, OnButexit)
	ON_BN_CLICKED(IDC_CHKDATE, OnChkdate)
	ON_BN_CLICKED(IDC_BUTQUERY, OnButQuery)
	ON_BN_CLICKED(IDC_BUTMENU, OnStabut)
	ON_COMMAND(ID_MENU_YSFS, OnMenuysfs)
	ON_COMMAND(ID_MENU_MYFS, OnMenumyfs)
	ON_COMMAND(ID_MENU_ZMXZ, OnMenuzmxz)
	ON_COMMAND(ID_MENU_CJFS, OnMenucjfs)
	ON_COMMAND(ID_MENU_BZ, OnMenubz)
	ON_COMMAND(ID_MENU_BZZL, OnMenubzzl)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	ON_CBN_SELCHANGE(IDC_COMBGLB, OnComSelChange)
	ON_CBN_EDITCHANGE(IDC_COMBGLB, OnComEdtChange)
	ON_CBN_KILLFOCUS(IDC_COMBGLB, OnKillfocusCombglb)

	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDCustoms message handlers

void CDCustoms::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CDCustoms::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

BOOL CDCustoms::OnInitDialog() 
{
	CDialog::OnInitDialog();
	this->m_EdtYF.IsMoneyOnly(true);
	this->m_EdtZF.IsMoneyOnly(true);
	this->m_EdtTBF.IsMoneyOnly(true);
	this->m_EdtMZ.IsMoneyOnly(true);
	this->m_EdtJZ.IsMoneyOnly(true);
	this->m_EdtJS.IsMoneyOnly(true);
	if(m_nStyle==1)
	{
		this->SetWindowText("报关单管理");
		this->m_ComBGLB.AddString("出口报关单");
		this->m_ComBGLB.AddString("进口报关单");
	}
	else
	{
		this->SetWindowText("备案清单管理");
		this->m_ComBGLB.AddString("进境备案清单");
		this->m_ComBGLB.AddString("出境备案清单");
	}
	this->m_EdtCKKA.GetWindowRect(&m_rcBak);
	this->m_EdtBZ.GetWindowRect(&m_rcMemBZ);
	this->ShowWindow(SW_SHOWMAXIMIZED);	
	RxRecordset rst;
	rst.Open("运输方式表");
	m_ComYSFS.SetRecordset(rst,"运输方式");

	rst.Open("贸易方式表");
	m_ComMYFS.SetRecordset(rst,"贸易方式");
	
	rst.Open("征免性质表");
	m_ComZMXZ.SetRecordset(rst,"征免性质");

	rst.Open("包装种类表");
	m_ComBzzl.SetRecordset(rst,"包装种类");

	rst.Open("成交方式表");
	m_ComCJFS.SetRecordset(rst,"成交方式");
	
	rst.Open("币种表");
	m_ComBZ.SetRecordset(rst,"币种");
	CString sSQL;
	if(m_nStyle==1)
		sSQL.Format("SELECT * FROM 报关单表 WHERE 报关单类别 NOT LIKE '%%备案%%'");
	else
		sSQL.Format("SELECT * FROM 报关单表 WHERE 报关单类别 LIKE '%%备案%%'");

	rst.Open(sSQL,adCmdText);
	m_Grid.SetDataBase(rst);
	m_sID=this->m_Grid.GetItemText(0,0);
	m_Grid.m_bReadOnly=true;
	if(m_sID.IsEmpty())
		return true;
	Display(m_sID);
	m_ComField.SetRecordset(rst);
	rst.Close();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDCustoms::Enabled(bool bEnabled)
{	
	CString sText;
	this->m_ComBGLB.GetWindowText(sText);
	if(sText.Find("备案")==-1)
	{
		m_EdtBAH.EnableWindow(bEnabled);
		m_EdtSFDJ.EnableWindow(bEnabled);
		m_EdtJZXH.EnableWindow(bEnabled);
		m_EdtYT.EnableWindow(bEnabled);
	}
	m_Grid.EnableWindow(!bEnabled);
	m_EdtZXG.EnableWindow(bEnabled);
	m_EdtZSBL.EnableWindow(bEnabled);
	m_EdtZF.EnableWindow(bEnabled);
	m_EdtZDY.EnableWindow(bEnabled);
	m_EdtYSGJ.EnableWindow(bEnabled);
	m_EdtYLRBH.EnableWindow(bEnabled);
	m_EdtXKZH.EnableWindow(bEnabled);
	m_EdtYF.EnableWindow(bEnabled);
	m_EdtTYDH.EnableWindow(bEnabled);
	m_EdtSHY.EnableWindow(bEnabled);
	m_EdtSHDW.EnableWindow(bEnabled);

	m_EdtQYG.EnableWindow(bEnabled);
	m_EdtPZWH.EnableWindow(bEnabled);
	m_EdtMZ.EnableWindow(bEnabled);
	m_EdtLRRBM.EnableWindow(bEnabled);
	m_EdtLRR.EnableWindow(bEnabled);
	m_EdtJZ.EnableWindow(bEnabled);
	m_EdtJYDW.EnableWindow(bEnabled);
	m_EdtJS.EnableWindow(bEnabled);
	m_EdtJNMDD.EnableWindow(bEnabled);
	m_EdtHTXY.EnableWindow(bEnabled);
	m_EdtHGBH.EnableWindow(bEnabled);
	m_EdtCKKA.EnableWindow(bEnabled);
	m_EdtBGYWBH.EnableWindow(bEnabled);
	m_EdtBZ.EnableWindow(bEnabled);
	m_EdtBGY.EnableWindow(bEnabled);
	m_EdtTBGFB.EnableWindow(bEnabled);
	m_EdtTBF.EnableWindow(bEnabled);
	//m_DtSHSJ.EnableWindow(bEnabled);
	m_DtSBRQ.EnableWindow(bEnabled);
	m_DtLRSL.EnableWindow(bEnabled);
	m_DtJKRQ.EnableWindow(bEnabled);
	m_DtDate2.EnableWindow(bEnabled);
	m_DtDate1.EnableWindow(bEnabled);
	m_ComZMXZ.EnableWindow(bEnabled);
	m_ComYSFS.EnableWindow(bEnabled);
	m_ComMYFS.EnableWindow(bEnabled);
	m_ComCJFS.EnableWindow(bEnabled);
	m_ComBzzl.EnableWindow(bEnabled);
	m_ComBZ.EnableWindow(bEnabled);
	m_ComYWLB.EnableWindow(bEnabled);
	m_ComBGLB.EnableWindow(bEnabled);
	//m_CHKSHBZ.EnableWindow(bEnabled);
	m_ChkSFJZ.EnableWindow(bEnabled);

	m_ButUndo.EnableWindow(bEnabled);
	m_ButSave.EnableWindow(bEnabled);
	m_ButNew.EnableWindow(!bEnabled);
	m_ButExit.EnableWindow(!bEnabled);
	m_ButDele.EnableWindow(!bEnabled);
	m_ButChange.EnableWindow(!bEnabled);
}

void CDCustoms::OnButnew() 
{
	CString sNewID;
	sNewID=ado.AutoNumber("报关单表","总业务编号","YW",3);
	this->m_EdtZYWBH.SetWindowText(sNewID);
	this->m_EdtZYWBH2.SetWindowText(sNewID);
	m_IsAdd=true;
	Clear();
	Enabled	(true);
	this->m_DtDate1.SetFocus();
}

void CDCustoms::OnKillfocusComysfs() 
{
	Add(&m_ComYSFS,"运输方式");	
}

void CDCustoms::OnKillfocusCommyfs() 
{
	Add(&m_ComMYFS,"贸易方式");	
}

void CDCustoms::OnKillfocusComzmxz() 
{
	Add(&m_ComZMXZ,"征免性质");
}

void CDCustoms::OnKillfocusCombzzl() 
{
	Add(&m_ComBzzl,"包装种类");
}

void CDCustoms::OnKillfocusCombz() 
{
	Add(&m_ComBZ,"币种");
}

void CDCustoms::OnKillfocusComcjfs() 
{
	Add(&m_ComCJFS,"成交方式");
}

void CDCustoms::OnStabut() 
{
	CPoint	point;
	::GetCursorPos(&point);
	if (point.x == -1 && point.y == -1)
	{
		CRect rect;
		GetClientRect(rect);
		ClientToScreen(rect);

		point = rect.TopLeft();
		point.Offset(5, 5);
	}
	CMenu menu;
	VERIFY(menu.LoadMenu(IDR_POPMENU1));

	CMenu* pPopup = menu.GetSubMenu(0);
	ASSERT(pPopup != NULL);
	CWnd* pWndPopupOwner = this;

	while (pWndPopupOwner->GetStyle() & WS_CHILD)
		pWndPopupOwner = pWndPopupOwner->GetParent();

	pPopup->TrackPopupMenu(TPM_LEFTALIGN | TPM_RIGHTBUTTON, point.x, point.y,
		pWndPopupOwner);
}

void CDCustoms::Display(CString sID)
{
	CString sSQL;
	sSQL.Format("SELECT * FROM 报关单表 WHERE 总业务编号='%s'",sID);
	RxRecordset rst;
	rst.Open(sSQL,adCmdText);
	if(rst.GetRecordCount()<1)
		return;
	//取出字段的值并显示
	CTime Date1,Date2,JKRQ,SBRQ,LRSJ,SHSJ;
	CString sDate1,sDate2,sJKRQ,sSBRQ,sLRSJ,sSHSJ;
	sDate1=rst.GetFieldValue("录入日期");
	sDate2=rst.GetFieldValue("录入日期2");
	sJKRQ=rst.GetFieldValue("进口日期");
	sSBRQ=rst.GetFieldValue("申报日期");
	sLRSJ=rst.GetFieldValue("录入时间");
	sSHSJ=rst.GetFieldValue("审核时间");

	Date1=CStringTOCTime(sDate1);
	Date2=CStringTOCTime(sDate2);
	JKRQ=CStringTOCTime(sJKRQ);
	SBRQ=CStringTOCTime(sSBRQ);
	LRSJ=CStringTOCTime(sLRSJ);
	SHSJ=CStringTOCTime(sSHSJ);

	this->m_DtDate1.SetTime(&Date1);
	this->m_DtDate2.SetTime(&Date2);
	this->m_ComYWLB.SetWindowText(rst.GetFieldValue("业务类别"));

	this->m_EdtZYWBH.SetWindowText(rst.GetFieldValue("总业务编号"));
	
	this->m_EdtZYWBH2.SetWindowText(rst.GetFieldValue("总业务编号"));
	this->m_EdtBGYWBH.SetWindowText(rst.GetFieldValue("报关业务编号"));
	this->m_ComBGLB.SetWindowText(rst.GetFieldValue("报关单类别"));
	this->OnComSelChange();
	this->m_EdtTBGFB.SetWindowText(rst.GetFieldValue("报关分部"));

	this->m_EdtYLRBH.SetWindowText(rst.GetFieldValue("预录入编号"));
	this->m_EdtHGBH.SetWindowText(rst.GetFieldValue("海关编号"));
	this->m_ChkSFJZ.SetCheck(atoi(rst.GetFieldValue("是否接转")));
	this->m_EdtCKKA.SetWindowText(rst.GetFieldValue("进口口案"));
	this->m_EdtBAH.SetWindowText(rst.GetFieldValue("备案号"));	
	this->m_DtJKRQ.SetTime(&JKRQ);
	this->m_DtSBRQ.SetTime(&SBRQ);
	this->m_EdtJYDW.SetWindowText(rst.GetFieldValue("经营单位"));
	this->m_ComYSFS.SetWindowText(rst.GetFieldValue("运输方式"));
	this->m_EdtYSGJ.SetWindowText(rst.GetFieldValue("运输工具"));
	this->m_EdtTYDH.SetWindowText(rst.GetFieldValue("提运单号"));
	this->m_EdtSHDW.SetWindowText(rst.GetFieldValue("收货单位"));
	this->m_ComMYFS.SetWindowText(rst.GetFieldValue("贸易方式"));
	this->m_ComZMXZ.SetWindowText(rst.GetFieldValue("征免性质"));
	this->m_EdtZSBL.SetWindowText(rst.GetFieldValue("征税比率"));
	this->m_EdtXKZH.SetWindowText(rst.GetFieldValue("许可证号"));
	this->m_EdtQYG.SetWindowText(rst.GetFieldValue("起运国"));
	this->m_EdtZXG.SetWindowText(rst.GetFieldValue("装卸港"));
	this->m_EdtJNMDD.SetWindowText(rst.GetFieldValue("境内目的地"));
	this->m_EdtPZWH.SetWindowText(rst.GetFieldValue("批准文号"));
	this->m_ComCJFS.SetWindowText(rst.GetFieldValue("成交方式"));
	this->m_EdtYF.SetWindowText(rst.GetFieldValue("运费"));
	this->m_EdtTBF.SetWindowText(rst.GetFieldValue("保费"));
	this->m_EdtZF.SetWindowText(rst.GetFieldValue("杂费"));
	this->m_ComBZ.SetWindowText(rst.GetFieldValue("币种"));
	this->m_EdtHTXY.SetWindowText(rst.GetFieldValue("合同协议号"));
	this->m_EdtJS.SetWindowText(rst.GetFieldValue("件数"));
	this->m_ComBzzl.SetWindowText(rst.GetFieldValue("包装种类"));
	this->m_EdtMZ.SetWindowText(rst.GetFieldValue("毛重"));
	this->m_EdtJZ.SetWindowText(rst.GetFieldValue("净重"));
	this->m_EdtJZXH.SetWindowText(rst.GetFieldValue("集装箱号"));