dlgorderdel.cpp

用VC编写的立体仓库的管理软件源程序和设计说明书。

// DlgOrderDel.cpp : implementation file
//

#include "stdafx.h"
#include "manage_wh.h"
#include "DlgOrderDel.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgOrderDel dialog


CDlgOrderDel::CDlgOrderDel(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgOrderDel::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgOrderDel)
	m_order = _T("");
	//}}AFX_DATA_INIT
}


void CDlgOrderDel::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgOrderDel)
	DDX_Text(pDX, IDC_ORDER, m_order);
	DDV_MaxChars(pDX, m_order, 13);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgOrderDel, CDialog)
	//{{AFX_MSG_MAP(CDlgOrderDel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgOrderDel message handlers

BOOL CDlgOrderDel::PreTranslateMessage(MSG* pMsg) 
{
	if (pMsg->message==WM_KEYDOWN && (pMsg->wParam==13 || pMsg->wParam==27))
		return TRUE;
	return CDialog::PreTranslateMessage(pMsg);
}

void CDlgOrderDel::OnOK() 
{
	UpdateData(TRUE);
	if (m_order.IsEmpty())
	{
		MessageBox("请输入要删除的订单编号！","系统提示",MB_ICONSTOP|MB_OK);
		return;
	}

	if (MessageBox("请确定是否删除订单[<"+m_order+">]","系统提示",MB_ICONWARNING|MB_YESNO)==IDNO)
		return;

	int bz=0,iTaskKind(0);
	CString sBeginSite;
	CAdoConnection cn;
	CAdoRecordSet  rs;
	cn.OpenUDLFile(gstrConSQLSer);
	rs.SetAdoConnection(&cn);
	rs.Open("select * from T_Manager_Task where F_OrderIndex='"+m_order+"'",adCmdText);
	if (rs.GetRecordCount() == 0)
		bz = 1;
	else
	{
		rs.MoveFirst();
		rs.GetCollect("F_TaskKind",iTaskKind);
		rs.GetCollect("F_StartPoint",sBeginSite);
	}
	rs.Close();
	if (bz == 1)
	{
		MessageBox("无效的订单号，任务列表中不存在[<"+m_order+">]","系统提示",MB_ICONSTOP|MB_OK);
		cn.Close();
		return;
	}
	cn.Execute("DELETE FROM T_Manager_Task WHERE F_OrderIndex='"+m_order+"'",adCmdText);
	cn.Execute("DELETE FROM T_Order_History WHERE F_OrderIndex='"+m_order+"'",adCmdText);
	if (iTaskKind == 2)
	{
		cn.Execute("UPDATE T_Goods_Site_Manage SET F_SiteState=1 WHERE F_SiteIndex='"+sBeginSite+"'",adCmdText);
	}
	cn.Close();
	AddLog("删除订单[<"+m_order+">]");
	CDialog::OnOK();
}