?? orderdlg.cpp
字號:
// OrderDlg.cpp : implementation file
//
#include "stdafx.h"
#include "HotelManageSys.h"
#include "OrderDlg.h"
#include "Columns.h"
#include "Column.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// COrderDlg dialog
extern CHotelManageSysApp theApp;
COrderDlg::COrderDlg(CWnd* pParent /*=NULL*/)
: CDialog(COrderDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(COrderDlg)
m_strOrderDinner = _T("");
m_strOrderType = _T("");
m_timeOrderD = 0;
m_timeOrderT = 0;
m_strOrderId = _T("");
m_strOrderName = _T("");
m_strOrderNums = _T("");
m_nOrderPeople = 0;
m_nOrderYajin = 0;
//}}AFX_DATA_INIT
}
void COrderDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(COrderDlg)
DDX_Control(pDX, IDC_DATETIMEPICKER_TIME, m_timectrlOrderT);
DDX_Control(pDX, IDC_DATETIMEPICKER_DAY, m_timectrlOrderD);
DDX_CBString(pDX, IDC_COMBO_DINNER, m_strOrderDinner);
DDX_CBString(pDX, IDC_COMBO_ORDER_TYPE, m_strOrderType);
DDX_Control(pDX, IDC_DATAGRID_ORDER, m_dgOrder);
DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_DAY, m_timeOrderD);
DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_TIME, m_timeOrderT);
DDX_Text(pDX, IDC_EDIT_ORDER_ID, m_strOrderId);
DDX_Text(pDX, IDC_EDIT_ORDER_NAME, m_strOrderName);
DDX_Text(pDX, IDC_EDIT_ORDER_NUM, m_strOrderNums);
DDX_Text(pDX, IDC_EDIT_ORDER_PEOPLE, m_nOrderPeople);
DDX_Text(pDX, IDC_EDIT_ORDER_YAJIN, m_nOrderYajin);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(COrderDlg, CDialog)
//{{AFX_MSG_MAP(COrderDlg)
ON_EN_CHANGE(IDC_EDIT_ORDER_ID, OnChangeEditOrderId)
ON_BN_CLICKED(IDC_ORDER_BTN, OnOrderBtn)
ON_BN_CLICKED(IDC_DEL_ORDER_BTN, OnDelOrderBtn)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// COrderDlg message handlers
BOOL COrderDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
m_strOrderDinner = _T("100");
m_strOrderType = _T("會員");
m_timeOrderD = 0;
m_timeOrderT = 0;
m_strOrderId = _T("0");
m_strOrderName = _T("0");
m_strOrderNums = _T("1");
m_nOrderPeople = 0;
m_nOrderYajin = 0;
m_timeOrderD = CTime::GetCurrentTime();
m_timeOrderT = CTime::GetCurrentTime();
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM OrderInfo",_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
m_dgOrder.SetRefDataSource(NULL);
m_dgOrder.SetRefDataSource((LPUNKNOWN)m_pRecordset);
m_dgOrder.SetColumnHeaders(2) ;
_variant_t var;
var = long(0);
m_dgOrder.GetColumns().GetItem(var).SetCaption("編號");
m_dgOrder.GetColumns().GetItem(var).SetWidth(40);
var = long(1);
m_dgOrder.GetColumns().GetItem(var).SetCaption("類型");
m_dgOrder.GetColumns().GetItem(var).SetWidth(40);
var = long(2);
m_dgOrder.GetColumns().GetItem(var).SetCaption("登記人");
m_dgOrder.GetColumns().GetItem(var).SetWidth(40);
var = long(3);
m_dgOrder.GetColumns().GetItem(var).SetCaption("證件號");
m_dgOrder.GetColumns().GetItem(var).SetWidth(50);
var = long(4);
m_dgOrder.GetColumns().GetItem(var).SetCaption("人數");
m_dgOrder.GetColumns().GetItem(var).SetWidth(30);
var = long(5);
m_dgOrder.GetColumns().GetItem(var).SetCaption("入住日期");
m_dgOrder.GetColumns().GetItem(var).SetWidth(50);
var = long(6);
m_dgOrder.GetColumns().GetItem(var).SetCaption("入住時間");
m_dgOrder.GetColumns().GetItem(var).SetWidth(50);
var = long(7);
m_dgOrder.GetColumns().GetItem(var).SetCaption("訂餐");
m_dgOrder.GetColumns().GetItem(var).SetWidth(30);
var = long(8);
m_dgOrder.GetColumns().GetItem(var).SetCaption("押金");
m_dgOrder.GetColumns().GetItem(var).SetWidth(30);
m_dgOrder.Refresh();
UpdateData(FALSE);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void COrderDlg::OnChangeEditOrderId()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
CString sql,str;
sql = "select * from OrderInfo where ID = '"+m_strOrderId+"'";
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if(m_pRecordset->GetRecordCount()!= 0)
{
m_strOrderType = m_pRecordset->GetCollect("OrderType").bstrVal;
m_strOrderName = m_pRecordset->GetCollect("OrderName").bstrVal;
m_strOrderNums = m_pRecordset->GetCollect("OrderPaper").bstrVal;
m_nOrderPeople = m_pRecordset->GetCollect("OrderAcount").lVal;
str = m_pRecordset->GetCollect("StartDay").bstrVal;
m_timectrlOrderD.SetFormat(str);
str = m_pRecordset->GetCollect("StartTime").bstrVal;
m_timectrlOrderT.SetFormat(str);
int dinner = m_pRecordset->GetCollect("Dinner").lVal;
m_strOrderDinner.Format("%d",dinner);
m_nOrderYajin= m_pRecordset->GetCollect("Deposit").lVal;
}
else
{
m_strOrderDinner = _T("");
m_strOrderType = _T("");
m_timeOrderD = 0;
m_timeOrderT = 0;
m_strOrderName = _T("");
m_strOrderNums = _T("");
m_nOrderPeople = 0;
m_nOrderYajin = 0;
}
m_pRecordset->Close();
UpdateData(FALSE);
}
void COrderDlg::OnOrderBtn()
{
// TODO: Add your control notification handler code here
if( theApp.m_level%2 == 0)//取余
{
AfxMessageBox("您不具有添加訂房信息的權限");
return;
}
UpdateData(TRUE);
CString sql,str;
//將房間狀態設置為“已滿”
_RecordsetPtr m_pRecordset_room;
sql = "select * from RoomInformation where ID = '"+m_strOrderId+"'";
m_pRecordset_room.CreateInstance("ADODB.Recordset");
m_pRecordset_room->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if(m_pRecordset_room->GetRecordCount()!=0)
{
CString str;
str=m_pRecordset_room->GetCollect("Status").bstrVal;
if(str.CompareNoCase("已滿")==0)
{
AfxMessageBox("該客房已滿，請換個房間");
return;
}
//
//添加訂房信息
sql = "select * from OrderInfo ";
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if( m_strOrderDinner == _T("")||m_strOrderType == _T("")||m_strOrderId ==_T("")||m_strOrderName == _T("")|| m_strOrderNums == _T(""))
{
AfxMessageBox("請輸入完整信息");
return;
}
m_pRecordset->AddNew();
m_pRecordset->PutCollect("ID",(_variant_t)m_strOrderId);
m_pRecordset->PutCollect("OrderType",(_variant_t)m_strOrderType);
m_pRecordset->PutCollect("OrderName",(_variant_t)m_strOrderName);
m_pRecordset->PutCollect("OrderPaper",(_variant_t)m_strOrderNums);
str.Format("%d",m_nOrderPeople);
m_pRecordset->PutCollect("OrderAcount",(_variant_t)str);
m_timeOrderD = CTime::GetCurrentTime();
str.Format("%d-%d-%d",m_timeOrderD.GetYear(),m_timeOrderD.GetMonth(),m_timeOrderD.GetDay());
m_pRecordset->PutCollect("StartDay",(_variant_t)str);
m_timeOrderT = CTime::GetCurrentTime();
str.Format("%d:%d:%d",m_timeOrderT.GetHour(),m_timeOrderT.GetMinute(),m_timeOrderT.GetSecond());
m_pRecordset->PutCollect("StartTime",(_variant_t)str);
m_pRecordset->PutCollect("Dinner",(_variant_t)m_strOrderDinner);
str.Format("%d",m_nOrderYajin);
m_pRecordset->PutCollect("Deposit",(_variant_t)str);
m_pRecordset->Update();
m_pRecordset->Close();
//
m_pRecordset_room->PutCollect("Status",(_variant_t)"已滿");
m_pRecordset_room->Update();
}
else
{
AfxMessageBox("該客房不存在，訂房失敗！");
return;
}
m_pRecordset_room->Close();
UpdateList();
UpdateData(FALSE);
}
void COrderDlg::OnDelOrderBtn()
{
// TODO: Add your control notification handler code here
if((!(theApp.m_level >=4 && theApp.m_level <= 7)) && (!(theApp.m_level >=12 && theApp.m_level <= 15)) )
{
AfxMessageBox("您不具有刪除訂房信息的權限");
return;
}
UpdateData(TRUE);
CString sql,str;
//將房間狀態設置為“空閑”
_RecordsetPtr m_pRecordset_room;
sql = "select * from RoomInformation where ID = '"+m_strOrderId+"'";
m_pRecordset_room.CreateInstance("ADODB.Recordset");
m_pRecordset_room->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if(m_pRecordset_room->GetRecordCount()>0)
{
m_pRecordset_room->PutCollect("Status",(_variant_t)"空閑");
m_pRecordset_room->Update();
}
else
{
AfxMessageBox("沒有該客房的信息，刪除失敗！");
return;
}
m_pRecordset_room->Close();
//
sql = "select * from OrderInfo where ID='"+m_strOrderId+"'";
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if(m_pRecordset->GetRecordCount()!=0)
m_pRecordset->Delete(adAffectCurrent);
else
{
AfxMessageBox("沒有該客房的訂房信息，刪除失敗！");
return;
}
m_pRecordset->Update();
m_pRecordset->Close();
UpdateList();
UpdateData(FALSE);
}
void COrderDlg::UpdateList()
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM OrderInfo",_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
m_dgOrder.SetRefDataSource(NULL);
m_dgOrder.SetRefDataSource((LPUNKNOWN)m_pRecordset);
m_dgOrder.SetColumnHeaders(2) ;
_variant_t var;
var = long(0);
m_dgOrder.GetColumns().GetItem(var).SetCaption("編號");
m_dgOrder.GetColumns().GetItem(var).SetWidth(40);
var = long(1);
m_dgOrder.GetColumns().GetItem(var).SetCaption("類型");
m_dgOrder.GetColumns().GetItem(var).SetWidth(40);
var = long(2);
m_dgOrder.GetColumns().GetItem(var).SetCaption("登記人");
m_dgOrder.GetColumns().GetItem(var).SetWidth(40);
var = long(3);
m_dgOrder.GetColumns().GetItem(var).SetCaption("證件號");
m_dgOrder.GetColumns().GetItem(var).SetWidth(50);
var = long(4);
m_dgOrder.GetColumns().GetItem(var).SetCaption("人數");
m_dgOrder.GetColumns().GetItem(var).SetWidth(30);
var = long(5);
m_dgOrder.GetColumns().GetItem(var).SetCaption("入住日期");
m_dgOrder.GetColumns().GetItem(var).SetWidth(50);
var = long(6);
m_dgOrder.GetColumns().GetItem(var).SetCaption("入住時間");
m_dgOrder.GetColumns().GetItem(var).SetWidth(50);
var = long(7);
m_dgOrder.GetColumns().GetItem(var).SetCaption("訂餐");
m_dgOrder.GetColumns().GetItem(var).SetWidth(30);
var = long(8);
m_dgOrder.GetColumns().GetItem(var).SetCaption("押金");
m_dgOrder.GetColumns().GetItem(var).SetWidth(30);
m_dgOrder.Refresh();
UpdateData(FALSE);
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -