📄 roomsaledlg.cpp
字号:
m_mend_money = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,12,m_mend_money.GetBuffer(50));
//读取数据表中金额总计字段数据
var = m_pRecordset->GetCollect("金额总计");
if(var.vt != VT_NULL)
m_realmoney = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,13,m_realmoney.GetBuffer(50));
//读取数据表中预收宿费字段数据
var = m_pRecordset->GetCollect("预收宿费");
if(var.vt != VT_NULL)
m_pre_handinmoney = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,14,m_pre_handinmoney.GetBuffer(50));
//读取数据表中退还宿费字段数据
var = m_pRecordset->GetCollect("退还宿费");
if(var.vt != VT_NULL)
m_reback_money = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,15,m_reback_money.GetBuffer(50));
i++;
m_pRecordset->MoveNext();//记录集指针下移一条记录
}
//
}
catch(_com_error *e)//抛出异常情况，提示用户
{
AfxMessageBox(e->ErrorMessage());
}
// 关闭记录集
m_pRecordset->Close();
m_pRecordset = NULL;
//变量赋值
m_show_meetingmoney=0;
m_show_backroommoney=0;
m_show_mendmoney=0;
m_show_mixmoney=0;
m_show_parkmoney=0;
m_show_pregetroommoney=0;
m_show_shouldgetmoney=0;
m_show_sumgetmoney=0;
m_show_telmoney=0;
m_showuser=loguserid;
UpdateData(false);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CRoomsaledlg::OnOK()
{
// TODO: Add extra validation here
UpdateData(true);
m_pRecordset.CreateInstance(__uuidof(Recordset));
_variant_t var;
m_roomsale_list.DeleteAllItems();
int i=0;
// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
//
try
{//打开数据表
m_pRecordset->Open("SELECT * FROM checkoutregtable", // 查询表中所有字段
theApp.m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch(_com_error *e)//抛出异常
{
AfxMessageBox(e->ErrorMessage());
}
try
{//判断指针是否在数据集最后
if(!m_pRecordset->BOF)
m_pRecordset->MoveFirst();
else
{
MessageBox("表内数据为空","客房管理系统");
return;
}
// read data from the database table
while(!m_pRecordset->adoEOF)
{
//循环读取数据
var = m_pRecordset->GetCollect("退房日期");
if(var.vt != VT_NULL)
m_checkoutdate = (LPCSTR)_bstr_t(var);
CString outyear,outmonth,outday;
outyear=m_checkoutdate.Mid(0,4);
outmonth=m_checkoutdate.Mid(5,m_checkoutdate.Find('-',6)-5);
outday=m_checkoutdate.Mid(m_checkoutdate.ReverseFind('-')+1,m_checkoutdate.GetLength()-m_checkoutdate.ReverseFind('-'));
//构造时间对象
CTime outtime(atoi(outyear),atoi(outmonth),atoi(outday),m_roomsalebegintime.GetHour(),m_roomsalebegintime.GetMinute(),m_roomsalebegintime.GetSecond());
//构造时间对象
CTime begintime(m_roomsalebegindate.GetYear(),m_roomsalebegindate.GetMonth(),m_roomsalebegindate.GetDay(),m_roomsalebegintime.GetHour(),m_roomsalebegintime.GetMinute(),m_roomsalebegintime.GetSecond());
//构造时间对象
CTime endtime(m_roomsaleenddate.GetYear(),m_roomsaleenddate.GetMonth(),m_roomsaleenddate.GetDay(),m_roomsaleendtime.GetHour(),m_roomsaleendtime.GetMinute(),m_roomsaleendtime.GetSecond());
if((outtime<endtime)&&(outtime>begintime))
{//满足条件的数据被读取，并在列表框内显示
//读取数据表中凭证号码字段数据
var = m_pRecordset->GetCollect("凭证号码");
if(var.vt != VT_NULL)
m_regnumber = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.InsertItem(i,m_regnumber.GetBuffer(50));
//读取数据表中姓名字段数据
var = m_pRecordset->GetCollect("姓名");
if(var.vt != VT_NULL)
m_gustname = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,1,m_gustname.GetBuffer(50));
//读取数据表中房间号字段数据
var = m_pRecordset->GetCollect("房间号");
if(var.vt != VT_NULL)
m_roomnumber = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,2,m_roomnumber.GetBuffer(50));
//读取数据表中客房价格字段数据
var = m_pRecordset->GetCollect("客房价格");
if(var.vt != VT_NULL)
m_room_money = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,3,m_room_money.GetBuffer(50));
//读取数据表中住宿天数字段数据
var = m_pRecordset->GetCollect("住宿天数");
if(var.vt != VT_NULL)
m_checkdays = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,4,m_checkdays.GetBuffer(50));
//读取数据表中折扣或招待字段数据
var = m_pRecordset->GetCollect("折扣或招待");
if(var.vt != VT_NULL)
m_discount_kind = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,5,m_discount_kind.GetBuffer(50));
//读取数据表中折扣字段数据
var = m_pRecordset->GetCollect("折扣");
if(var.vt != VT_NULL)
m_discountnumber = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,6,m_discountnumber.GetBuffer(50));
//读取数据表中应收宿费字段数据
var = m_pRecordset->GetCollect("应收宿费");
if(var.vt != VT_NULL)
m_pre_discount = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,7,m_pre_discount.GetBuffer(50));
m_show_shouldgetmoney=m_show_shouldgetmoney+atof(m_pre_discount);
//读取数据表中杂费字段数据
var = m_pRecordset->GetCollect("杂费");
if(var.vt != VT_NULL)
m_mix_money = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,8,m_mix_money.GetBuffer(50));
m_show_mixmoney=m_show_mixmoney+atof(m_mix_money);
//读取数据表中电话费字段数据
var = m_pRecordset->GetCollect("电话费");
if(var.vt != VT_NULL)
m_tel_money = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,9,m_tel_money.GetBuffer(50));
m_show_telmoney=m_show_telmoney+atof(m_tel_money);
//读取数据表中会议费字段数据
var = m_pRecordset->GetCollect("会议费");
if(var.vt != VT_NULL)
m_meeting_money = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,10,m_meeting_money.GetBuffer(50));
m_show_meetingmoney=m_show_meetingmoney+atof(m_meeting_money);
//读取数据表中存车费字段数据
var = m_pRecordset->GetCollect("存车费");
if(var.vt != VT_NULL)
m_park_money = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,11,m_park_money.GetBuffer(50));
m_show_parkmoney=m_show_parkmoney+atof(m_park_money);
//读取数据表中赔偿费字段数据
var = m_pRecordset->GetCollect("赔偿费");
if(var.vt != VT_NULL)
m_mend_money = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,12,m_mend_money.GetBuffer(50));
m_show_mendmoney=m_show_mendmoney+atof(m_mend_money);
//读取数据表中金额总计字段数据
var = m_pRecordset->GetCollect("金额总计");
if(var.vt != VT_NULL)
m_realmoney = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,13,m_realmoney.GetBuffer(50));
m_show_sumgetmoney=m_show_sumgetmoney+atof(m_realmoney);
//读取数据表中预收宿费字段数据
var = m_pRecordset->GetCollect("预收宿费");
if(var.vt != VT_NULL)
m_pre_handinmoney = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,14,m_pre_handinmoney.GetBuffer(50));
m_show_pregetroommoney=m_show_pregetroommoney+atof(m_pre_handinmoney);
//读取数据表中退还宿费字段数据
var = m_pRecordset->GetCollect("退还宿费");
if(var.vt != VT_NULL)
m_reback_money = (LPCSTR)_bstr_t(var);
//在列表框内显示该字段内容
m_roomsale_list.SetItemText(i,15,m_reback_money.GetBuffer(50));
m_show_backroommoney=m_show_backroommoney+atof(m_reback_money);
i++;//移动记录集指针到下一条记录
m_pRecordset->MoveNext();
}
else//如果不满足条件就直接跳过此记录
{
m_pRecordset->MoveNext();
continue;
}
}
//
}
catch(_com_error *e)//捕获异常
{
AfxMessageBox(e->ErrorMessage());
}
// 关闭记录集
m_pRecordset->Close();
m_pRecordset = NULL;
// m_show_pregetmoney = sum_pregetmoney;
// m_show_shouldgetmoney=sum_realmoney;
UpdateData(false);
// CDialog::OnOK();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -