/// <summary>
/// 检测房间在这段时间内被预定或者处于不可预定状态.不可预定状态一般为RoomStatus为D
/// </summary>
/// <param name="listOrderedInfo">已预定的信息</param>
/// <param name="mRoom">预定的房间</param>
/// <param name="dtStartTime">预抵时间</param>
/// <param name="dtEndTime">预离时间</param>
/// <returns>如果验证通过返回True,反之返回False</returns>
public bool CheckRoomOrdered(List <OrderInfoModel> listOrderedInfo, BasRoomModel mRoom, DateTime dtStartTime, DateTime dtEndTime)
{
if (Cmn.CheckEOF(listOrderedInfo))
{
var qOrder = listOrderedInfo.Where(c => c.RoomInfo.RoomId == mRoom.RoomId);
if (qOrder.Count() > 0 && (qOrder.First().RoomInfo.Status != 'E' ||
(qOrder.First().CommonInfo.StartDate < dtStartTime && qOrder.First().CommonInfo.EndDate > dtStartTime) ||
(qOrder.First().CommonInfo.StartDate < dtEndTime && qOrder.First().CommonInfo.EndDate > dtEndTime)
))
{
if (!Cmn.Confirm("该房间目前处于非可用状态或者已经被预定,是否继续?"))
{
return(false);
}
}
}
else if (mRoom.Status != 'E')
{
if (!Cmn.Confirm("该房间目前处于非可用状态,是否继续?"))
{
return(false);
}
}
return(true);
}
private void UpdateRoomStatus(string sRoomNo, int nRoomId, char cStatus)
{
string sChangeType = "";
switch (cStatus)
{
case 'E':
sChangeType = "可用";
break;
case 'D':
sChangeType = "停用";
break;
case 'C':
sChangeType = "清理";
break;
}
if (!cmn.Confirm(string.Format("确定更改房间{0}为{1}状态?", sRoomNo, sChangeType)))
{
return;
}
BasRoomModel mRoom = new BasRoomModel(nRoomId);
mRoom.Status = cStatus;
hml.UpdateRoomStatusByRoomId(mRoom, UserInfo);
GetRoomByStatus(cboRoomStatus.SelectedValue.ToString());
}
/// <summary>
/// 新增房间信息
/// </summary>
/// <param name="mRoomInfo"></param>
/// <returns></returns>
public bool InsertRoomInfo(BasRoomModel mRoomInfo)
{
try
{
BAS_ROOM_INFO bri = new BAS_ROOM_INFO();
bri.ROOM_NO = mRoomInfo.RoomNo;
bri.ROOM_TYPE = mRoomInfo.RoomType;
bri.ROOM_RATES = mRoomInfo.RoomRate;
bri.ROOM_PHONE = mRoomInfo.RoomPhone;
bri.STATUS = mRoomInfo.Status;
bri.FLOOR_ID = mRoomInfo.FloorInfo.FloorId;
bri.ROOM_NOTICE = mRoomInfo.RoomNotice;
bri.CREATE_DATE = GetDBTime;
bri.CREATE_USERID = mRoomInfo.CommonInfo.CreateUserId;
bri.UPDATE_DATE = bri.CREATE_DATE;
bri.UPDATE_USERID = bri.CREATE_USERID;
dc.BAS_ROOM_INFO.InsertOnSubmit(bri);
dc.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
private void LoadUIInfo()
{
try
{
dtpStartDate.Format = DateTimePickerFormat.Custom;
dtpEndDate.Format = DateTimePickerFormat.Custom;
dtpKeepDate.Format = DateTimePickerFormat.Custom;
dtpStartDate.CustomFormat = "yyyy-MM-dd";
dtpEndDate.CustomFormat = "yyyy-MM-dd";
dtpKeepDate.CustomFormat = "yyyy-MM-dd";
dtpEndDate.Value = cmn.DateBaseDate.AddDays(1);
dtpKeepDate.Value = dtpEndDate.Value;
BindCodeInfo(cboRoomType, "BAS_ROOM_INFO", "ROOM_TYPE");
BasRoomModel mRoomTmp = mOrderInfo.OrderId > 0 ? mOrderInfo.RoomInfo : mRoomInfo;
cboRoomType.SelectedIndex = GetComboxIndexByKey(cboRoomType, mRoomTmp.RoomType);
string sRoomNo = mRoomTmp.RoomId > 0 ? mRoomTmp.RoomNo : "";
gbOrdered.Text = string.Format("已预定{0}的宾客", sRoomNo);
BindRoomInfo();
BindHour();
if (mRoomTmp.RoomId > 0)
{
for (int i = 0; i < cboRoomNo.Items.Count; i++)
{
if (((BasRoomModel)cboRoomNo.Items[i]).RoomId == mRoomTmp.RoomId)
{
cboRoomNo.SelectedIndex = i;
break;
}
}
}
if (mOrderInfo.OrderId > 0)
{
txtName.Text = mOrderInfo.Name;
txtPhone.Text = mOrderInfo.Phone;
txtIDCard.Text = mOrderInfo.IdCardNo;
txtRoomRate.Text = mOrderInfo.OrderRoomRate.ToString();
txtNotice.Text = mOrderInfo.Notice;
dtpStartDate.Value = mOrderInfo.CommonInfo.StartDate.Date;
cboHourS.SelectedItem = mOrderInfo.CommonInfo.StartDate.Hour;
dtpEndDate.Value = mOrderInfo.CommonInfo.EndDate.Date;
cboHourE.SelectedItem = mOrderInfo.CommonInfo.EndDate.Hour;
dtpKeepDate.Value = mOrderInfo.KeepDate.Date;
cboHourK.SelectedItem = mOrderInfo.KeepDate.Hour;
pbtnAdd.Enabled = false;
}
}
catch (Exception err)
{
cmn.Show(err.Message);
}
}
private void tsChangeRoom_Click(object sender, EventArgs e)
{
BasRoomModel mRoomNo = GetKeyRoomNo();
if (mRoomNo != null)
{
FormChangeRoom frmChangeRoom = new FormChangeRoom(mRoomNo);
frmChangeRoom.Show();
}
}
/// <summary>
/// 仅获取宾客入住信息
/// </summary>
/// <param name="mRoom"></param>
/// <param name="cStayStatus"></param>
/// <returns></returns>
public CustomerStayModel GetCustomerStayInfoByRoom(BasRoomModel mRoom, char cStayStatus)
{
CustomerStayModel mStayInfo = new CustomerStayModel();
ObjectControls oCtrl = new ObjectControls();
mStayInfo.RoomId = mRoom.RoomId;
mStayInfo.Status = cStayStatus;
oCtrl.Add(MCtrl.ByRoomId);
oCtrl.Add(MCtrl.ByStayStatus);
return(bCustomerStay.GetCustomerStayInfo(mStayInfo, oCtrl));
}
private void tsModifyRoomState_Click(object sender, EventArgs e)
{
BasRoomModel mRoomNo = GetKeyRoomNo();
if (mRoomNo != null)
{
FormModifyRoomState frmModifyState = new FormModifyRoomState(mRoomNo);
if (frmModifyState.ShowDialog() == DialogResult.OK)
{
ShowRoom(mRoomNo.FloorInfo.FloorId);
}
}
}
private void LoadUIInfo()
{
oCtrl.Reset();
oCtrl.Add(MCtrl.ByRoomStatus);
BasRoomModel mRoom = new BasRoomModel();
mRoom.Status = 'E';
listRoomInfo = bRoom.GetRoomInfo(mRoom, oCtrl);
BindEnabledRoomTree(listRoomInfo);
BindCodeInfo(cboPayType, "CUSTOMER_STAY_INFO", "PAY_TYPE");
cboSex.SelectedIndex = 0;
dDiskon = double.Parse(hml.ToParameter(listSysParameter, "DEFAULT_DISKON").Value1);
}
private void tsmOneOpenRoom_Click(object sender, EventArgs e)
{
BasRoomModel mRoomNo = GetSelectRoomNo(GetSelectPBX(ptcts));
if (mRoomNo != null && hml.OpenRoomCheck(mRoomNo))
{
FormOneCustomer frmOne = new FormOneCustomer(mRoomNo);
if (frmOne.ShowDialog() == DialogResult.OK)
{
ShowRoom(mRoomNo.FloorInfo.FloorId);
}
}
}
private void tsmChangeRoomState_Click(object sender, EventArgs e)
{
BasRoomModel mRoomNo = GetSelectRoomNo(GetSelectPBX(ptcts));
if (mRoomNo != null)
{
FormModifyRoomState frmModifyRoom = new FormModifyRoomState(mRoomNo);
if (frmModifyRoom.ShowDialog() == DialogResult.OK)
{
ShowRoom(mRoomNo.FloorInfo.FloorId);
}
}
}
private void tsOneCustomer_Click(object sender, EventArgs e)
{
BasRoomModel mRoomNo = GetKeyRoomNo();
if (mRoomNo != null && hml.OpenRoomCheck(mRoomNo))
{
FormOneCustomer frmOneCustomer = new FormOneCustomer(mRoomNo);
if (frmOneCustomer.ShowDialog() == DialogResult.OK)
{
ShowRoom(mRoomNo.FloorInfo.FloorId);
}
}
}
private void tsmPayMoney_Click(object sender, EventArgs e)
{
BasRoomModel mRoomNo = GetSelectRoomNo(GetSelectPBX(ptcts));
if (mRoomNo != null)
{
FormPayMoney frmPayMoney = new FormPayMoney(mRoomNo);
if (frmPayMoney.ShowDialog() == DialogResult.OK)
{
ShowRoom(mRoomNo.FloorInfo.FloorId);
}
}
}
private void tsmCustomerOrder_Click(object sender, EventArgs e)
{
BasRoomModel mRoomNo = GetSelectRoomNo(GetSelectPBX(ptcts));
if (mRoomNo != null)
{
FormNewOrder frmNewOrder = new FormNewOrder(mRoomNo);
if (frmNewOrder.ShowDialog() == DialogResult.OK)
{
ShowRoom(mRoomNo.FloorInfo.FloorId);
}
}
}
public List <BasRoomModel> GetTeamRoomList(CustomerStayModel mCustomerStay, ObjectControls oCtrl)
{
string sql = @"SELECT A.ROOM_ID,D.MAIN_ROOM_ID, A.ROOM_NO, A.ROOM_TYPE,C.CODE_DESC AS ROOM_TYPE_DESC, A.ROOM_RATES, A.STATUS,
A.CREATE_DATE, A.CREATE_USERID, A.ROOM_PHONE,A.ROOM_NOTICE, A.UPDATE_DATE,A.UPDATE_USERID,
B.FLOOR_ID, B.FLOOR_NAME, B.STATUS AS FLOOR_STATUS
FROM BAS_ROOM_INFO AS A INNER JOIN
CUSTOMER_STAY_INFO AS D ON A.ROOM_ID=D.ROOM_ID INNER JOIN
BAS_FLOOR_INFO AS B ON A.FLOOR_ID = B.FLOOR_ID
INNER JOIN SYS_LOOKUP_CODE AS C ON A.ROOM_TYPE=C.CODE_NO AND C.TABLE_NAME='BAS_ROOM_INFO'
AND C.COLUMN_NAME='ROOM_TYPE' ";
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomId) && oCtrl.Append(ref sql, " AND A.ROOM_ID=" + mCustomerStay.RoomId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByMainRoomId) && oCtrl.Append(ref sql, " AND D.MAIN_ROOM_ID=" + mCustomerStay.MainRoomId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStayStatus) && oCtrl.Append(ref sql, " AND D.STATUS=" + SQL(mCustomerStay.Status)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomNo) && oCtrl.Append(ref sql, " AND A.ROOM_NO=" + SQL(mCustomerStay.RoomInfo.RoomNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomStatus) && oCtrl.Append(ref sql, " AND A.STATUS=" + SQL(mCustomerStay.RoomInfo.Status)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomStatusGroup) && oCtrl.Append(ref sql, " AND A.STATUS IN (" + mCustomerStay.RoomInfo.StatusGroup + ")"));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomType) && oCtrl.Append(ref sql, " AND A.ROOM_TYPE=" + SQL(mCustomerStay.RoomInfo.RoomType)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByFloorId) && oCtrl.Append(ref sql, " AND B.FLOOR_ID=" + mCustomerStay.RoomInfo.FloorInfo.FloorId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByFloorName) && oCtrl.Append(ref sql, " AND B.FLOOR_NAME=" + SQL(mCustomerStay.RoomInfo.FloorInfo.FloorName)));
sdr = ExecuteReader(sql);
List <BasRoomModel> listRoomInfo = new List <BasRoomModel>();
using (sdr)
{
while (sdr.Read())
{
BasRoomModel mBasRoomInfo = new BasRoomModel();
mBasRoomInfo.RoomId = ToInt32(sdr["ROOM_ID"]);
mBasRoomInfo.MainRoomId = ToInt32(sdr["MAIN_ROOM_ID"]);
mBasRoomInfo.RoomNo = ToString(sdr["ROOM_NO"]);
mBasRoomInfo.RoomPhone = ToString(sdr["ROOM_PHONE"]);
mBasRoomInfo.RoomRate = ToDouble(sdr["ROOM_RATES"]);
mBasRoomInfo.RoomType = ToChar(sdr["ROOM_TYPE"]);
mBasRoomInfo.RoomTypeDesc = ToString(sdr["ROOM_TYPE_DESC"]);
mBasRoomInfo.RoomNotice = ToString(sdr["ROOM_NOTICE"]);
mBasRoomInfo.Status = ToChar(sdr["STATUS"]);
mBasRoomInfo.CommonInfo = new CommonModel();
mBasRoomInfo.CommonInfo.CreateDate = ToDateTime(sdr["CREATE_DATE"]);
mBasRoomInfo.CommonInfo.CreateUserId = ToInt32(sdr["CREATE_USERID"]);
mBasRoomInfo.CommonInfo.UpdateDate = ToDateTime(sdr["UPDATE_DATE"]);
mBasRoomInfo.CommonInfo.UpdateUserId = ToInt32(sdr["UPDATE_USERID"]);
mBasRoomInfo.FloorInfo = new BasFloorModel();
mBasRoomInfo.FloorInfo.FloorId = ToInt32(sdr["FLOOR_ID"]);
mBasRoomInfo.FloorInfo.FloorName = ToString(sdr["FLOOR_NAME"]);
mBasRoomInfo.FloorInfo.Status = ToChar(sdr["FLOOR_STATUS"]);
listRoomInfo.Add(mBasRoomInfo);
}
}
return(listRoomInfo);
}
/// <summary>
/// 删除房间
/// </summary>
/// <param name="mRoomInf"></param>
/// <returns></returns>
public bool DeleteRoomInfo(BasRoomModel mRoomInfo)
{
try
{
BAS_ROOM_INFO bri = dc.BAS_ROOM_INFO.First(c => c.ROOM_ID == mRoomInfo.RoomId);
dc.BAS_ROOM_INFO.DeleteOnSubmit(bri);
dc.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
private void tvEnableRoom_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
{
if (e.Node != null && e.Node.Level > 0)
{
BasRoomModel mSelectedRoom = new BasRoomModel();
var query = listRoomInfo.Where(c => c.RoomNo == e.Node.Text).First();
mSelectedRoom = query;
listSelectedRoom.Add(mSelectedRoom);
listRoomInfo.Remove(query);
tvEnableRoom.Nodes.Remove(e.Node);
BindSelectedRoomDgv(listSelectedRoom);
BindMainRoom(listSelectedRoom);
}
}
private void BindRoomInfo()
{
BasRoomModel mRoom = new BasRoomModel();
mRoom.RoomType = cmn.ToChar(cboRoomType.SelectedValue);
// mRoom.StatusGroup = "'E','C','I','T'";
oCtrl.Reset();
oCtrl.Add(MCtrl.ByRoomType);
//oCtrl.Add(MCtrl.ByRoomStatusGroup);
listRoomInfo = bRoom.GetRoomInfo(mRoom, oCtrl);
cboRoomNo.DataSource = listRoomInfo;
cboRoomNo.DisplayMember = "RoomNo";
cboRoomNo.ValueMember = "RoomId";
}
private void dgvSelectedRoom_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e != null)
{
BasRoomModel mSelectedRoom = new BasRoomModel();
var query = listSelectedRoom.Where(c => c.RoomNo == dgvSelectedRoom.Rows[e.RowIndex].Cells["RoomNo"].Value.ToString()).First();
mSelectedRoom = query;
listRoomInfo.Add(mSelectedRoom);
listSelectedRoom.Remove(query);
AddTvNode(mSelectedRoom);
BindSelectedRoomDgv(listSelectedRoom);
BindMainRoom(listSelectedRoom);
}
}
/// <summary>
/// 获取房间有效的预定
/// </summary>
/// <param name="mRoom"></param>
/// <returns></returns>
public List <OrderInfoModel> GetRoomOrder(BasRoomModel mRoom)
{
OrderInfoModel mOrder = new OrderInfoModel();
mOrder.RoomInfo = mRoom;
mOrder.KeepDate = Cmn.DateBaseDate;
mOrder.Status = 'E';
ObjectControls oCtrl = new ObjectControls();
oCtrl.Reset();
oCtrl.Add(MCtrl.ByRoomId);
oCtrl.Add(MCtrl.ByKeepDateEnable);
oCtrl.Add(MCtrl.ByOrderStatus);
return(bOrder.GetOrderInfo(mOrder, oCtrl));
}
private void GetRoomByFloor(int nFloorId)
{
if (tbcRoomInfo.TabCount > 0)
{
tbcRoomInfo.TabPages[nFloorId.ToString()].Controls.Clear();
}
BasRoomModel mRoomInfo = new BasRoomModel();
mRoomInfo.FloorInfo = new BasFloorModel();
mRoomInfo.FloorInfo.FloorId = nFloorId;
oCtrl.Reset();
oCtrl.Add(MCtrl.ByFloorId);
List <BasRoomModel> listRoomInfo = bRoomInfo.GetRoomInfo(mRoomInfo, oCtrl);
if (IsConnectDigiLock)
{
DigiRoomList = bDigiLock.GetPhoneDetail();
}
double dCleanTime = double.Parse(hml.ToParameter(listSysParameter, "DEFAULT_CLEAN_TIME").Value1);//退房后一段时间内默认为清理时间.单位为分钟
for (int i = 0; i < listRoomInfo.Count; i++)
{
PictureBox pc = new PictureBox();
//如果超过清理时间,则将房间状态更新为E (listRoomInfo[i].Status == 'O' && !cmn.CheckEOF(hml.GetRoomOrder(listRoomInfo[i])
if ((listRoomInfo[i].Status == 'C' && dCleanTime > 0 &&
cmn.DateBaseDate.Subtract(listRoomInfo[i].CommonInfo.UpdateDate).TotalMinutes
>= dCleanTime))// && hml.GetCustomerStayInfoByRoom(listRoomInfo[i], 'I') == null
{
listRoomInfo[i].Status = 'E';
hml.UpdateRoomStatusByRoomId(listRoomInfo[i], UserInfo);
}
pc.BackgroundImage = SelectRoomImage(listRoomInfo[i].Status);
pc.AccessibleDescription = listRoomInfo[i].Status.ToString();
pc.BackgroundImageLayout = ImageLayout.Zoom;
pc.Tag = listRoomInfo[i].RoomId.ToString();
pc.Name = listRoomInfo[i].RoomNo;
pc.Size = new Size(32, 64);
pc.Cursor = Cursors.Hand;
pc.ContextMenuStrip = ctmsFunction;
pc.Paint += new PaintEventHandler(peh);
pc.MouseEnter += new EventHandler(pbMouseEnter);
pc.MouseLeave += new EventHandler(pbMouseLeave);
pc.Click += new EventHandler(pbClick);
pc.Location = new Point(tbcRoomInfo.Location.X + (i % 19) * (pc.Size.Width + 10), tbcRoomInfo.Location.Y + Convert.ToInt32(i / 19) * (pc.Size.Height + 5));
tbcRoomInfo.TabPages[nFloorId.ToString()].Controls.Add(pc);
}
}
private void pbtnAdd_Click(object sender, EventArgs e)
{
TreeNode tn = tvEnableRoom.SelectedNode;
if (tn != null && tn.Level > 0)
{
BasRoomModel mSelectedRoom = new BasRoomModel();
var query = listRoomInfo.Where(c => c.RoomNo == tn.Text).First();
mSelectedRoom = query;
listSelectedRoom.Add(mSelectedRoom);
listRoomInfo.Remove(query);
tvEnableRoom.Nodes.Remove(tn);
BindSelectedRoomDgv(listSelectedRoom);
BindMainRoom(listSelectedRoom);
}
}
private void pbtnRemove_Click(object sender, EventArgs e)
{
if (dgvSelectedRoom.SelectedRows.Count > 0)
{
DataGridViewRow dgvr = dgvSelectedRoom.SelectedRows[0];
if (dgvr != null)
{
BasRoomModel mSelectedRoom = new BasRoomModel();
var query = listSelectedRoom.Where(c => c.RoomNo == dgvr.Cells["RoomNo"].Value.ToString()).First();
mSelectedRoom = query;
listRoomInfo.Add(mSelectedRoom);
listSelectedRoom.Remove(query);
AddTvNode(mSelectedRoom);
BindSelectedRoomDgv(listSelectedRoom);
BindMainRoom(listSelectedRoom);
}
}
}
private void AddTvNode(BasRoomModel mRoom)
{
TreeNode tn = new TreeNode();
tn.Text = mRoom.RoomNo;
tn.Name = mRoom.RoomId.ToString();
TreeNode[] tnl = tvEnableRoom.Nodes.Find(mRoom.RoomType.ToString(), false);
if (tnl.Length > 0)
{
tnl[0].Nodes.Add(tn);
}
else
{
TreeNode tnN = new TreeNode();
tnN.Text = mRoom.RoomTypeDesc;
tnN.Name = mRoom.RoomType.ToString();
tnN.Nodes.Add(tn);
tvEnableRoom.Nodes.Add(tnN);
}
}
private void tsPayMoney_Click(object sender, EventArgs e)
{
BasRoomModel mRoomNo = GetKeyRoomNo();
if (mRoomNo != null)
{
CustomerStayModel mCustomerStay = hml.GetStayInRoomInfo(mRoomNo, 'I', "M");
if (mCustomerStay != null)
{
FormPayMoney frmPayMoney = new FormPayMoney(mRoomNo);
if (frmPayMoney.ShowDialog() == DialogResult.OK)
{
ShowRoom(mRoomNo.FloorInfo.FloorId);
}
}
else
{
cmn.Show("非占用房间无法使用本功能.");
}
}
}
private void tsmModifyRegister_Click(object sender, EventArgs e)
{
BasRoomModel mRoomNo = GetSelectRoomNo(GetSelectPBX(ptcts));
if (mRoomNo != null)
{
CustomerStayModel mCustomerStay = hml.GetStayInRoomInfo(mRoomNo, 'I', "M");
if (mCustomerStay != null)
{
FormOneCustomer frmOne = new FormOneCustomer(mRoomNo);
if (frmOne.ShowDialog() == DialogResult.OK)
{
ShowRoom(mRoomNo.FloorInfo.FloorId);
}
}
else
{
cmn.Show("非占用房间无法使用本功能.");
}
}
}
/// <summary>
/// 开房前检测房间是否可用
/// </summary>
/// <param name="mRoom"></param>
/// <returns></returns>
public bool OpenRoomCheck(BasRoomModel mRoom)
{
if (mRoom.RoomId > 0)
{
if (mRoom.Status == 'I' || mRoom.Status == 'T')
{
Cmn.Show("房间已被占用,无法开单.");
return(false);
}
else if (mRoom.Status == 'C' || mRoom.Status == 'D')
{
string sRoomStatus = mRoom.Status == 'C' ? "清理" : "停用";
if (!Cmn.Confirm(string.Format("房间{0}处于{1}状态,继续开单?", mRoom.RoomNo, sRoomStatus)))
{
return(false);
}
}
return(true);
}
return(false);
}
/// <summary>
/// 修改房间信息
/// </summary>
/// <param name="mRoomInfo"></param>
/// <param name="oCtrl"></param>
/// <returns></returns>
public int UpdateRoomInfo(BasRoomModel mRoomInfo, ObjectControls oCtrl)
{
try
{
string sql = "UPDATE BAS_ROOM_INFO SET CREATE_DATE=CREATE_DATE";
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetRoomNo) && oCtrl.Append(ref sql, ",ROOM_NO=" + SQL(mRoomInfo.RoomNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetRoomStatus) && oCtrl.Append(ref sql, ",STATUS=" + SQL(mRoomInfo.Status)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetRoomRate) && oCtrl.Append(ref sql, ",ROOM_RATES=" + SQL(mRoomInfo.RoomRate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetPhone) && oCtrl.Append(ref sql, ",ROOM_PHONE=" + SQL(mRoomInfo.RoomPhone)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetRoomType) && oCtrl.Append(ref sql, ",ROOM_TYPE=" + SQL(mRoomInfo.RoomType)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetFloorId) && oCtrl.Append(ref sql, ",FLOOR_ID=" + SQL(mRoomInfo.FloorInfo.FloorId)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetNotice) && oCtrl.Append(ref sql, ",ROOM_NOTICE=" + SQL(mRoomInfo.RoomNotice)));
sql += ",UPDATE_DATE=" + SQL(GetDBTime);
sql += ",UPDATE_USERID=" + SQL(mRoomInfo.CommonInfo.UpdateUserId);
sql += " WHERE ROOM_ID=" + mRoomInfo.RoomId;
return(ExcuteNonQuery(sql));
}
catch (Exception err)
{
throw err;
}
}
/// <summary>
/// 获取宾客入住信息,消费明细
/// </summary>
/// <param name="mRoom">房间信息</param>
/// <param name="cStayStatus">入住状态 I In / O off</param>
/// <param name="sStayType">入住类型,主客M从客S,如包含主从则为""</param>
/// <returns></returns>
public CustomerStayModel GetStayInRoomInfo(BasRoomModel mRoom, char cStayStatus, string sStayType)
{
CustomerStayModel mStayInfo = new CustomerStayModel();
ObjectControls oCtrl = new ObjectControls();
mStayInfo.RoomId = mRoom.RoomId;
mStayInfo.Status = cStayStatus;
mStayInfo.CustomerList = new List <CustomerModel>();
CustomerModel mc = new CustomerModel();
mc.CustomerStayHisInfo = new CustomerStayHisModel();
if (!string.IsNullOrEmpty(sStayType))
{
mc.CustomerStayHisInfo.StayType = Cmn.ToChar(sStayType);
oCtrl.Add(MCtrl.ByStayType);
}
mc.CustomerStayHisInfo.HisStatus = cStayStatus == 'I' ? 'E' : 'O';
mStayInfo.CustomerList.Add(mc);
oCtrl.Add(MCtrl.ByRoomId);
oCtrl.Add(MCtrl.ByStayStatus);
oCtrl.Add(MCtrl.ByHisStatus);
CustomerStayModel mCustomerStay = bCustomerStay.GetCustomerStayInfo(mStayInfo, oCtrl);
if (mCustomerStay != null)
{
List <ConsumeDetailModel> listGetConsumeDetail = new List <ConsumeDetailModel>();
ConsumeDetailModel mConsume = new ConsumeDetailModel();
mConsume.StayId = mCustomerStay.StayId;
oCtrl.Reset();
oCtrl.Add(MCtrl.ByStayId);
listGetConsumeDetail = bConsume.GetConsumeList(mConsume, oCtrl);
if (Cmn.CheckEOF(listGetConsumeDetail))
{
mCustomerStay.ConSumeDetailList = listGetConsumeDetail;
}
}
return(mCustomerStay);
}
/// <summary>
/// 保存备注信息.如房间已近入住,则备注保存于CUSTOMER_STAY_INFO 的notice,否则保存到BAS_ROOM_INFO 的ROOM_NOTICE栏位
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void pbtnSaveNotice_Click(object sender, EventArgs e)
{
if (txtNotice.Tag != null && cmn.Confirm("保存备注?"))
{
if (txtNotice.Tag.ToString() == "E")
{
BasRoomModel mr = new BasRoomModel();
mr.RoomId = int.Parse(txtNotice.AccessibleName);
mr.RoomNotice = txtNotice.Text;
mr.CommonInfo.UpdateUserId = UserInfo.UserId;
bRoomInfo.UpdateRoomInfo(mr, new ObjectControls(MCtrl.SetNotice));
}
else
{
CustomerStayModel mcs = new CustomerStayModel();
mcs.StayId = int.Parse(txtNotice.Tag.ToString());
mcs.Notice = txtNotice.Text;
mcs.CommonInfo.UpdateUserId = UserInfo.UserId;
bStay.UpdateCustomerStay(mcs, new ObjectControls(MCtrl.SetNotice));
}
cmn.Show("保存完毕!");
ShowRoom(int.Parse(tbcRoomInfo.SelectedTab.Name));
}
}
/// <summary>
/// 根据一个RoomId获取团队所有房间
/// </summary>
/// <param name="mRoom"></param>
/// <returns></returns>
public List <BasRoomModel> GetTeamRoomListByRoomId(BasRoomModel mRoom, char cStayStatus)
{
CustomerStayModel mCustomerStay = new CustomerStayModel();
mCustomerStay.RoomId = mRoom.RoomId;
mCustomerStay.Status = cStayStatus;
ObjectControls oCtrl = new ObjectControls();
oCtrl.Add(MCtrl.ByStayStatus);
oCtrl.Add(MCtrl.ByRoomId);
CustomerStayModel mC = bCustomerStay.GetCustomerStayInfo(mCustomerStay, oCtrl);
if (mC.MainRoomId > 0)
{
oCtrl.Reset();
oCtrl.Add(MCtrl.ByStayStatus);
oCtrl.Add(MCtrl.ByMainRoomId);
return(bRoom.GetTeamRoomList(mC, oCtrl));
}
else
{
return(new List <BasRoomModel>());
}
}
