dformat.cpp

物流综合管理系统

// DFormat.cpp : implementation file
//

#include "stdafx.h"
#include "MyProject.h"
#include "DFormat.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDFormat dialog


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


void CDFormat::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDFormat)
	DDX_Control(pDX, IDC_STATITLE, m_StaTitle);
	DDX_Control(pDX, IDC_STATEXT, m_StaText);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDFormat, CDialog)
	//{{AFX_MSG_MAP(CDFormat)
	ON_BN_CLICKED(IDC_BUTEXIT, OnButexit)
	ON_BN_CLICKED(IDC_BUTFORMAT, OnButformat)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDFormat message handlers

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

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

void CDFormat::OnButexit() 
{
	this->OnCancel();	
}

void CDFormat::OnButformat() 
{
	if(MessageBox("确定要执行初始化操作吗？","系统提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
		return;	
	CString sTableName[]={"备案清单表","仓库信息表","操作员信息表","车辆信息表","出口报关单表","出库记录表","出库明细表","出库审核表","公司设置表","驾驶员信息表","进口报关表","库存信息表","派车回厂确认表","盘点记录表","盘点明细表","配送反馈信息表","配送申请表","配送审核表","入库记录表","入库明细表","入库审核表","三检查验表","商品信息表","往来单位信息表","销售挂帐表","销售记录表","销售结款表","销售明细表","员工信息表","在途反馈表"};	
	CString sSQL;
	RxRecordset rst;
	for(int i=0;i<30;i++)
	{
		m_StaText.SetWindowText("正在初始化"+sTableName[i]+"请稍后...");
		sSQL.Format("DELETE FROM %s",sTableName[i]);
		rst.Open(sSQL,adCmdText);
	}
	m_StaText.SetWindowText("");
	MessageBox("初始化工作完成!","系统提示",MB_OK|MB_ICONEXCLAMATION);
}