dsupervisory.cpp

物流管理系统包括基本信息管理、仓库管理、销售管理、配送管理、运输管理、报关管理、决策管理等模块

// DSuperVisory.cpp : implementation file
//

#include "stdafx.h"
#include "MyProject.h"
#include "DSuperVisory.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDSuperVisory dialog


CDSuperVisory::CDSuperVisory(CWnd* pParent /*=NULL*/)
	: CDialog(CDSuperVisory::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDSuperVisory)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CDSuperVisory::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDSuperVisory)
	DDX_Control(pDX, ID_STAZD, m_StaZD);
	DDX_Control(pDX, ID_STATG, m_StaTG);
	DDX_Control(pDX, ID_STASJ, m_StaSJ);
	DDX_Control(pDX, ID_STASD, m_StaSD);
	DDX_Control(pDX, ID_STACY, m_StaCY);
	DDX_Control(pDX, ID_STABA, m_StaBA);
	DDX_Control(pDX, IDC_CHKZD, m_ChkZD);
	DDX_Control(pDX, IDC_CHKTG, m_ChkTG);
	DDX_Control(pDX, IDC_CHKSJ, m_ChkSJ);
	DDX_Control(pDX, IDC_CHKSD, m_ChkSD);
	DDX_Control(pDX, IDC_CHKCY, m_ChkCY);
	DDX_Control(pDX, IDC_CHKBA, m_ChkBA);
	DDX_Control(pDX, IDC_LIST1, m_List);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDSuperVisory, CDialog)
	//{{AFX_MSG_MAP(CDSuperVisory)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDSuperVisory message handlers

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

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

BOOL CDSuperVisory::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	RxRecordset rst;
	rst.Open(" SELECT * FROM 报关单表 WHERE 报关单类别 NOT LIKE '%%备案%%'",adCmdText);
	for(int i=0;i<rst.GetRecordCount();i++)
	{
		rst.Move(i);
		this->m_List.AddString(rst.GetFieldValue("报关业务编号"));
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDSuperVisory::OnButton1() 
{
	RxRecordset rst;
	CString sSQL;
	CString sText;
	this->m_List.GetText(m_List.GetCurSel(),sText);
	this->m_ChkZD.SetCheck(1);
	sSQL.Format("SELECT * FROM 报关单表 WHERE 报关业务编号='%s'",sText);
	rst.Open(sSQL,adCmdText);
	this->m_StaZD.SetWindowText(rst.GetFieldValue("录入时间"));
	//处理审单
	this->m_ChkSD.SetCheck(atoi(rst.GetFieldValue("审核标志")));
	if(this->m_ChkSD.GetCheck()==1)
		this->m_StaSD.SetWindowText(rst.GetFieldValue("审核时间"));
	//处理备案清单
	sSQL.Format("SELECT * FROM 报关单表 WHERE 报关业务编号='%s'",rst.GetFieldValue("备案号"));
	rst.Open(sSQL,adCmdText);
	if(rst.GetRecordCount()<1)
		this->m_ChkBA.SetCheck(0);
	else
	{
		this->m_ChkBA.SetCheck(1);
		CString bb=rst.GetFieldValue("进口日期");
		this->m_StaBA.SetWindowText(bb);
	}
	//处理三检
	sSQL.Format("SELECT * FROM 三检表 WHERE 报关业务编号='%s'",sText);
	rst.Open(sSQL,adCmdText);
	if(rst.GetRecordCount()<1)
		this->m_ChkSJ.SetCheck(0);
	else	
	{
		this->m_ChkSJ.SetCheck(atoi(rst.GetFieldValue("结束标志")));
		if(m_ChkSJ.GetCheck()==1)
			this->m_StaSJ.SetWindowText(rst.GetFieldValue("结束时间"));
	}
	//处理查验
	sSQL.Format("SELECT * FROM 查验表 WHERE 报关业务编号='%s'",sText);
	rst.Open(sSQL,adCmdText);
	if(rst.GetRecordCount()<1)
		this->m_ChkCY.SetCheck(0);
	else	
	{
		this->m_ChkCY.SetCheck(atoi(rst.GetFieldValue("结束标志")));
		if(m_ChkCY.GetCheck()==1)
			this->m_StaCY.SetWindowText(rst.GetFieldValue("结束时间"));
	}
	//处理通关
	sSQL.Format("SELECT * FROM 通关表 WHERE 报关业务编号='%s'",sText);
	rst.Open(sSQL,adCmdText);
	if(rst.GetRecordCount()<1)
		this->m_ChkTG.SetCheck(0);
	else	
	{
		this->m_ChkTG.SetCheck(atoi(rst.GetFieldValue("现场放行标志")));
		if(m_ChkTG.GetCheck()==1)
			this->m_StaTG.SetWindowText(rst.GetFieldValue("现场放行时间"));
	}
		

	//

}