📄 findcheckindlg.cpp
字号:
var = m_pRecordset->GetCollect("凭证号码");
if(var.vt != VT_NULL)
m_regnumber = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.InsertItem(i,m_regnumber.GetBuffer(50));
//读取数据表中姓名字段数据
var = m_pRecordset->GetCollect("姓名");
if(var.vt != VT_NULL)
m_gustname = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,1,m_gustname.GetBuffer(50));
//读取数据表中证件名称字段数据
var = m_pRecordset->GetCollect("证件名称");
if(var.vt != VT_NULL)
m_zhengjian = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,2,m_zhengjian.GetBuffer(50));
//读取数据表中证件号码字段数据
var = m_pRecordset->GetCollect("证件号码");
if(var.vt != VT_NULL)
m_zhengjian_number = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,3,m_zhengjian_number.GetBuffer(50));
//读取数据表中详细地址字段数据
var = m_pRecordset->GetCollect("详细地址");
if(var.vt != VT_NULL)
m_gustaddr = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,4,m_gustaddr.GetBuffer(50));
//读取数据表中出差事由字段数据
var = m_pRecordset->GetCollect("出差事由");
if(var.vt != VT_NULL)
m_checkinreg_reason = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,5,m_checkinreg_reason.GetBuffer(50));
//读取数据表中房间号字段数据
var = m_pRecordset->GetCollect("房间号");
if(var.vt != VT_NULL)
m_roomnumber = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,6,m_roomnumber.GetBuffer(50));
//读取数据表中客房类型字段数据
var = m_pRecordset->GetCollect("客房类型");
if(var.vt != VT_NULL)
m_roomlevel = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,7,m_roomlevel.GetBuffer(50));
//读取数据表中客房价格字段数据
var = m_pRecordset->GetCollect("客房价格");
if(var.vt != VT_NULL)
m_room_money = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,8,m_room_money.GetBuffer(50));
//读取数据表中住宿日期字段数据
var = m_pRecordset->GetCollect("住宿日期");
if(var.vt != VT_NULL)
m_checkindate = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,9,m_checkindate.GetBuffer(50));
//读取数据表中住宿时间字段数据
var = m_pRecordset->GetCollect("住宿时间");
if(var.vt != VT_NULL)
m_checkintime = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,10,m_checkintime.GetBuffer(50));
//读取数据表中住宿天数字段数据
var = m_pRecordset->GetCollect("住宿天数");
if(var.vt != VT_NULL)
m_checkdays = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,11,m_checkdays.GetBuffer(50));
//读取数据表中宿费字段数据
var = m_pRecordset->GetCollect("宿费");
if(var.vt != VT_NULL)
m_pre_discount = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,12,m_gustname.GetBuffer(50));
//读取数据表中折扣字段数据
var = m_pRecordset->GetCollect("折扣");
if(var.vt != VT_NULL)
m_discountnumber = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,13,m_discountnumber.GetBuffer(50));
//读取数据表中应收宿费字段数据
var = m_pRecordset->GetCollect("应收宿费");
if(var.vt != VT_NULL)
m_realmoney = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,14,m_realmoney.GetBuffer(50));
//读取数据表中预收金额字段数据
var = m_pRecordset->GetCollect("预收金额");
if(var.vt != VT_NULL)
m_pre_handinmoney = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,15,m_pre_handinmoney.GetBuffer(50));
//读取数据表中提醒日期字段数据
var = m_pRecordset->GetCollect("提醒日期");
if(var.vt != VT_NULL)
m_alarmdate = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,16,m_alarmdate.GetBuffer(50));
//读取数据表中退宿日期字段数据
var = m_pRecordset->GetCollect("退宿日期");
if(var.vt != VT_NULL)
m_checkoutdate = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,17,m_checkoutdate.GetBuffer(50));
//读取数据表中备注字段数据
var = m_pRecordset->GetCollect("备注");
if(var.vt != VT_NULL)
m_beizhu = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,18,m_beizhu.GetBuffer(50));
//读取数据表中结款方式字段数据
var = m_pRecordset->GetCollect("结款方式");
if(var.vt != VT_NULL)
m_discount_kind = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,19,m_discount_kind.GetBuffer(50));
//读取数据表中退宿时间字段数据
var = m_pRecordset->GetCollect("退宿时间");
if(var.vt != VT_NULL)
m_checkouttime = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,20,m_checkouttime.GetBuffer(50));
//读取数据表中提醒时间字段数据
var = m_pRecordset->GetCollect("提醒时间");
if(var.vt != VT_NULL)
m_alarmtime = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,21,m_alarmtime.GetBuffer(50));
i++;
m_pRecordset->MoveNext();//移动到下一条记录
}
//
}
catch(_com_error *e)//捕获异常
{
AfxMessageBox(e->ErrorMessage());
}
// 关闭记录集
m_pRecordset->Close();
m_pRecordset = NULL;
}
else
{
Onfindroom();
}
//更新显示
UpdateData(false);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CFindcheckindlg::Onfindroom()
{
// TODO: Add your control notification handler code here
_variant_t var;
// 使用ADO创建数据库记录集
m_pRecordsetfind.CreateInstance(__uuidof(Recordset));
// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
//
int i=0;
//列表框内容删除
m_findcheckin_list.DeleteAllItems();
CString strsqlfind;
CString findroomnumber=sendfindroomnumber;
strsqlfind.Format("SELECT * FROM checkinregtable where 房间号='%s'",findroomnumber);
try
{//打开数据库
m_pRecordsetfind->Open((_variant_t)(strsqlfind), // 查询 表中所有字段
theApp.m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch(_com_error *e)//捕获异常
{
AfxMessageBox(e->ErrorMessage());
}
try
{
if(!m_pRecordsetfind->BOF)//判断指针是否在数据集最后
m_pRecordsetfind->MoveFirst();
else
{
AfxMessageBox("此房间没人入住！");
return ;
}
//循环读入数据，并在列表框内显示
while(!m_pRecordsetfind->adoEOF)
{ //读取数据表中凭证号码字段数据
var = m_pRecordsetfind->GetCollect("凭证号码");
if(var.vt != VT_NULL)
m_regnumber = (LPCSTR)_bstr_t(var);//AfxMessageBox("readlllllllllld");
//在列表框内显示
m_findcheckin_list.InsertItem(i,m_regnumber.GetBuffer(50));
//读取数据表中姓名字段数据
var = m_pRecordsetfind->GetCollect("姓名");
if(var.vt != VT_NULL)
m_gustname = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,1,m_gustname.GetBuffer(50));
//读取数据表中证件名称字段数据
var = m_pRecordsetfind->GetCollect("证件名称");
if(var.vt != VT_NULL)
m_zhengjian = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,2,m_zhengjian.GetBuffer(50));
//读取数据表中证件号码字段数据
var = m_pRecordsetfind->GetCollect("证件号码");
if(var.vt != VT_NULL)
m_zhengjian_number = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,3,m_zhengjian_number.GetBuffer(50));
//读取数据表中详细地址字段数据
var = m_pRecordsetfind->GetCollect("详细地址");
if(var.vt != VT_NULL)
m_gustaddr = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,4,m_gustaddr.GetBuffer(50));
//读取数据表中出差事由字段数据
var = m_pRecordsetfind->GetCollect("出差事由");
if(var.vt != VT_NULL)
m_checkinreg_reason = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,5,m_checkinreg_reason.GetBuffer(50));
//读取数据表中房间号字段数据
var = m_pRecordsetfind->GetCollect("房间号");
if(var.vt != VT_NULL)
m_roomnumber = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,6,m_roomnumber.GetBuffer(50));
//读取数据表中提醒时间字段数据
var = m_pRecordsetfind->GetCollect("客房类型");
if(var.vt != VT_NULL)
m_roomlevel = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,7,m_roomlevel.GetBuffer(50));
//读取数据表中客房价格字段数据
var = m_pRecordsetfind->GetCollect("客房价格");
if(var.vt != VT_NULL)
m_room_money = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,8,m_room_money.GetBuffer(50));
//读取数据表中住宿日期字段数据
var = m_pRecordsetfind->GetCollect("住宿日期");
if(var.vt != VT_NULL)
m_checkindate = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,9,m_checkindate.GetBuffer(50));
//读取数据表中住宿时间字段数据
var = m_pRecordsetfind->GetCollect("住宿时间");
if(var.vt != VT_NULL)
m_checkintime = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,10,m_checkintime.GetBuffer(50));
//读取数据表中住宿天数字段数据
var = m_pRecordsetfind->GetCollect("住宿天数");
if(var.vt != VT_NULL)
m_checkdays = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,11,m_checkdays.GetBuffer(50));
//读取数据表中宿费字段数据
var = m_pRecordsetfind->GetCollect("宿费");
if(var.vt != VT_NULL)
m_pre_discount = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,12,m_gustname.GetBuffer(50));
//读取数据表中折扣字段数据
var = m_pRecordsetfind->GetCollect("折扣");
if(var.vt != VT_NULL)
m_discountnumber = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,13,m_discountnumber.GetBuffer(50));
//读取数据表中应收宿费字段数据
var = m_pRecordsetfind->GetCollect("应收宿费");
if(var.vt != VT_NULL)
m_realmoney = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,14,m_realmoney.GetBuffer(50));
//读取数据表中预收金额字段数据
var = m_pRecordsetfind->GetCollect("预收金额");
if(var.vt != VT_NULL)
m_pre_handinmoney = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,15,m_pre_handinmoney.GetBuffer(50));
//读取数据表中提醒日期字段数据
var = m_pRecordsetfind->GetCollect("提醒日期");
if(var.vt != VT_NULL)
m_alarmdate = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,16,m_alarmdate.GetBuffer(50));
//读取数据表中退宿日期字段数据
var = m_pRecordsetfind->GetCollect("退宿日期");
if(var.vt != VT_NULL)
m_checkoutdate = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,17,m_checkoutdate.GetBuffer(50));
//读取数据表中备注字段数据
var = m_pRecordsetfind->GetCollect("备注");
if(var.vt != VT_NULL)
m_beizhu = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,18,m_beizhu.GetBuffer(50));
//读取数据表中结款方式字段数据
var = m_pRecordsetfind->GetCollect("结款方式");
if(var.vt != VT_NULL)
m_discount_kind = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,19,m_discount_kind.GetBuffer(50));
//读取数据表中退宿时间字段数据
var = m_pRecordsetfind->GetCollect("退宿时间");
if(var.vt != VT_NULL)
m_checkouttime = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,20,m_checkouttime.GetBuffer(50));
//读取数据表中提醒时间字段数据
var = m_pRecordsetfind->GetCollect("提醒时间");
if(var.vt != VT_NULL)
m_alarmtime = (LPCSTR)_bstr_t(var);
//在列表框内显示
m_findcheckin_list.SetItemText(i,21,m_alarmtime.GetBuffer(50));
i++;
m_pRecordsetfind->MoveNext();//移动到下一条记录
}
//
}
catch(_com_error *e)//捕获异常
{
AfxMessageBox(e->ErrorMessage());
}
// 关闭记录集
m_pRecordsetfind->Close();
m_pRecordsetfind = NULL;
// 更新显示
UpdateData(false);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -