private void btnOK_Click(object sender, EventArgs e)
{
try
{
for (int i = 0; i < dgvOrderedInfo.Rows.Count; i++)
{
DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)dgvOrderedInfo.Rows[i].Cells["chkSelect"];
Boolean flag = Convert.ToBoolean(checkCell.Value);
if (flag == true)
{
mOrderInfo = listOrderInfo.Where(c => c.OrderId == int.Parse(dgvOrderedInfo.Rows[i].Cells["OrderId"].Value.ToString())).First();
this.DialogResult = DialogResult.OK;
}
}
if (this.DialogResult != DialogResult.OK)
{
mOrderInfo = null;
}
this.Close();
}
catch (Exception err)
{
cmn.Show(err.Message);
}
}
/// <summary>
/// 绑定本次预定的订单信息
/// </summary>
/// <param name="mOrder"></param>
private void BindGridViewRoomInfo(OrderInfoModel mOrder)
{
dgvRoomNo.Rows.Add();
dgvRoomNo.Rows[dgvRoomNo.Rows.Count - 1].Cells["RoomType"].Value = mOrder.RoomInfo.RoomTypeDesc;
dgvRoomNo.Rows[dgvRoomNo.Rows.Count - 1].Cells["RoomNo"].Value = mOrder.RoomInfo.RoomNo;
listOrderRoomInfo.Add(mOrder);
listOrder.Add(mOrder);
}
public int UpdateOrderInfo(OrderInfoModel mOrder, ObjectControls oCtrl)
{
return dOrder.UpdateOrderInfo(mOrder, oCtrl);
}
public int InsertOrderInfo(OrderInfoModel mOrder)
{
return dOrder.InsertOrderInfo(mOrder);
}
public DataSet GetOrderInfoDs(OrderInfoModel mOrder, ObjectControls oCtrl)
{
return dOrder.GetOrderInfoDs(mOrder, oCtrl);
}
/// <summary>
/// 获取预定信息
/// </summary>
/// <param name="mOrder"></param>
/// <param name="oCtrl"></param>
/// <returns></returns>
public List<OrderInfoModel> GetOrderInfo(OrderInfoModel mOrder, ObjectControls oCtrl)
{
return dOrder.GetOrderInfo(mOrder, oCtrl);
}
public int DeleteOrder(OrderInfoModel mOrder)
{
return dOrder.DeleteOrder(mOrder);
}
private OrderInfoModel CheckOrder(OrderInfoModel mOrder)
{
lblMsg.Text = "";
if (!cmn.CheckEOF(listRoomInfo))
{
throw new Exception("无可预定房间");
}
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
throw new Exception("宾客姓名不能为空");
}
if (string.IsNullOrEmpty(txtPhone.Text.Trim()))
{
throw new Exception("联系电话不能为空");
}
if (string.IsNullOrEmpty(txtRoomRate.Text.Trim()))
{
throw new Exception("房间价格不能为空");
}
DateTime dtKeepDate = GetDateTimePickValue(dtpKeepDate, cboHourK);
DateTime dtStartDate = GetDateTimePickValue(dtpStartDate, cboHourS);
DateTime dtEndDate = GetDateTimePickValue(dtpEndDate, cboHourE);
if (dtEndDate <= dtStartDate)
{
throw new Exception("预抵时间不能小于预离时间");
}
if (dtKeepDate <= cmn.DateBaseDate)
{
throw new Exception("保留时间不能小于当前时间");
}
var query = listRoomInfo.Where(c => c.RoomId == int.Parse(cboRoomNo.SelectedValue.ToString()));
if (query.Count() > 0)
{
if (mOrder.OrderId < 0)
{
if (!hml.CheckRoomOrdered(listOrder, query.First(), dtStartDate, dtEndDate))
{
return null;
}
}
mOrder.Name = txtName.Text;
mOrder.IdCardNo = txtIDCard.Text;
mOrder.Phone = txtPhone.Text;
mOrder.Notice = txtNotice.Text;
mOrder.RoomInfo = query.First();
mOrder.OrderRoomRate = cmn.CheckIsDouble(txtRoomRate, "房间费用");
mOrder.CommonInfo = new CommonModel();
mOrder.CommonInfo.CreateUserId = UserInfo.UserId;
mOrder.CommonInfo.UpdateUserId = UserInfo.UserId;
mOrder.CommonInfo.StartDate = dtStartDate;
mOrder.CommonInfo.EndDate = dtEndDate;
mOrder.KeepDate = dtKeepDate;
mOrder.Status = 'E';
}
return mOrder;
}
private void GetOrderInfo()
{
OrderInfoModel mOrder = new OrderInfoModel();
oCtrl.Reset();
if (!string.IsNullOrEmpty(txtNPR.Text.Trim()))
{
mOrder.Name = txtNPR.Text;
oCtrl.Add(MCtrl.ByNPR);
}
else
{
if (cboStatus.SelectedValue.ToString() != "A")
{
mOrder.KeepDate = cmn.DateBaseDate;
switch (cboStatus.SelectedValue.ToString())
{
case "E"://预定中
mOrder.Status = 'E';
oCtrl.Add(MCtrl.ByKeepDateEnable);
oCtrl.Add(MCtrl.ByOrderStatus);
break;
case "D"://已过期
mOrder.Status = 'E';
oCtrl.Add(MCtrl.ByOrderStatus);
oCtrl.Add(MCtrl.ByKeepDateDisable);
break;
case "C"://已取消
mOrder.Status = 'C';
oCtrl.Add(MCtrl.ByOrderStatus);
break;
case "I"://已入住
mOrder.Status = 'I';
oCtrl.Add(MCtrl.ByOrderStatus);
break;
}
}
}
mOrder.CommonInfo = new CommonModel();
mOrder.CommonInfo.StartDate = GetDateTimePickValue(dtpStart, cboHourS);
mOrder.CommonInfo.EndDate = GetDateTimePickValue(dtpEnd, cboHourE);
oCtrl.Add(MCtrl.ByStartDateBetween);
listOrderInfo = bOrder.GetOrderInfo(mOrder, oCtrl);
BindOrderList(listOrderInfo);
}
public int DeleteOrder(OrderInfoModel mOrder)
{
string sql = "DELETE FROM ORDER_INFO WHERE ORDER_ID=" + mOrder.OrderId;
return ExcuteNonQuery(sql);
}
public int UpdateOrderInfo(OrderInfoModel mOrder, ObjectControls oCtrl)
{
string sql = " UPDATE ORDER_INFO SET CREATE_DATE=CREATE_DATE";
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetName) && oCtrl.Append(ref sql, ",NAME=" + SQL(mOrder.Name)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetIdCard) && oCtrl.Append(ref sql, ",ID_CARD=" + SQL(mOrder.IdCardNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetPhone) && oCtrl.Append(ref sql, ",PHONE=" + SQL(mOrder.Phone)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetStartDate) && oCtrl.Append(ref sql, ",START_DATE=" + SQL(mOrder.CommonInfo.StartDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetEndDate) && oCtrl.Append(ref sql, ",END_DATE=" + SQL(mOrder.CommonInfo.EndDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetKeepDate) && oCtrl.Append(ref sql, ",KEEP_DATE=" + SQL(mOrder.KeepDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetRoomId) && oCtrl.Append(ref sql, ",ROOM_ID=" + SQL(mOrder.RoomInfo.RoomId)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetRoomRate) && oCtrl.Append(ref sql, ",ROOM_RATE=" + SQL(mOrder.OrderRoomRate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetNotice) && oCtrl.Append(ref sql, ",NOTICE=" + SQL(mOrder.Notice)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetOrderStatus) && oCtrl.Append(ref sql, ",STATUS=" + SQL(mOrder.Status)));
sql += ",UPDATE_DATE=" + SQL(GetDBTime);
sql += ",UPDATE_USERID=" + SQL(mOrder.CommonInfo.UpdateUserId);
sql += " WHERE ORDER_ID=" + mOrder.OrderId;
return ExcuteNonQuery(sql);
}
public int InsertOrderInfo(OrderInfoModel mOrder)
{
ORDER_INFO oi = new ORDER_INFO();
oi.CREATE_DATE = GetDBTime;
oi.CREATE_USERID = mOrder.CommonInfo.CreateUserId;
oi.END_DATE = mOrder.CommonInfo.EndDate;
oi.ID_CARD = mOrder.IdCardNo;
oi.KEEP_DATE = mOrder.KeepDate;
oi.NAME = mOrder.Name;
oi.NOTICE = mOrder.Notice;
oi.PHONE = mOrder.Phone;
oi.STATUS = mOrder.Status;
oi.ROOM_ID = mOrder.RoomInfo.RoomId;
oi.ROOM_RATE = mOrder.OrderRoomRate;
oi.START_DATE = mOrder.CommonInfo.StartDate;
oi.UPDATE_DATE = oi.CREATE_DATE;
oi.UPDATE_USERID = mOrder.CommonInfo.UpdateUserId;
dc.ORDER_INFO.InsertOnSubmit(oi);
dc.SubmitChanges();
return oi.ORDER_ID;
}
public FormNewOrder(OrderInfoModel mOrder)
{
InitializeComponent();
mOrderInfo = mOrder;
listOrderRoomInfo.Add(mOrderInfo);
}
private void pbtnAdd_Click(object sender, EventArgs e)
{
try
{
OrderInfoModel mOrder = new OrderInfoModel();
mOrder = CheckOrder(mOrder);
if (mOrder != null)
{
BindGridViewRoomInfo(mOrder);
}
}
catch (Exception err)
{
lblMsg.Text = err.Message;
}
}
private void LoadInfo()
{
BindCodeInfo(cboPayType, "CUSTOMER_STAY_INFO", "PAY_TYPE");
BindCodeInfo(cboCustomerType, "CUSTOMER_STAY_HIS", "STAY_TYPE");
cboSex.SelectedIndex = 0;
lblRoomInfo.Text = mRoomInfo.RoomNo;
lblRoomType.Text = mRoomInfo.RoomTypeDesc;
lblRoomRate.Text = mRoomInfo.RoomRate + "元";
if (!mRoomInfo.Status.Equals('E'))
{
CustomerStayModel mCustomerStayInfo = new CustomerStayModel();
mCustomerStayInfo.RoomId = mRoomInfo.RoomId;
mCustomerStayInfo.Status = 'I';
mCustomerStayInfo.CustomerList = new List<CustomerModel>();
CustomerModel mc = new CustomerModel();
mc.CustomerStayHisInfo = new CustomerStayHisModel();
mc.CustomerStayHisInfo.HisStatus = 'E';
mCustomerStayInfo.CustomerList.Add(mc);
oCtrl = new ObjectControls();
oCtrl.Add(MCtrl.ByRoomId);
oCtrl.Add(MCtrl.ByStayStatus);
oCtrl.Add(MCtrl.ByHisStatus);
CustomerStayModel mCustomerStay =bCustomer.GetCustomerStayInfo(mCustomerStayInfo, oCtrl);
if (mCustomerStay != null)
{
this.Text = "修改登记";
listCustomerStay.Add(mCustomerStay);
txtDay.Text = (mCustomerStay.Hours / 24).ToString(); //hml.GetCustomerStayDays(mCustomerStay.CommonInfo.StartDate, mCustomerStay.CommonInfo.EndDate, listSysParameter).ToString("0.0"); //listSysParameter.Where(c => c.ParamNo == "DEFAULT_STAY_DAYS").Select(c => c.Value1).First();
txtCurrentDeposit.Text = mCustomerStay.Deposit.ToString();
txtCurrentRate.Text = mCustomerStay.RoomRate.ToString();
txtDiskonRate.Enabled = false;
//txtDiskonRate.Text = (mCustomerStay.RoomRate / mCustomerStay.RoomInfo.RoomRate).ToString("0.00");
txtCustomerNumber.Text = mCustomerStay.CustomerList.Count.ToString();
txtNotice.Text = mCustomerStay.Notice;
chkHourRoom.Checked = mCustomerStay.RoomStayType == 'H' ? true : false;
cboPayType.SelectedIndex = GetComboxIndexByKey(cboPayType, mCustomerStay.PayType);
if (cmn.FileExsit(cmn.GetImgFilePath(mCustomerStay.CustomerList[0].Picture)))
{
pbxUserImg.Image = Image.FromFile(cmn.GetImgFilePath(mCustomerStay.CustomerList[0].Picture));
}
listCustomer = mCustomerStay.CustomerList;
BindCustomer(listCustomer);
return;
}
}
this.Text = "散客开单";
List<OrderInfoModel> listOrder = hml.GetRoomOrder(mRoomInfo);
if (cmn.CheckEOF(listOrder))
{
FormSelectOrder frmSelectOrder = new FormSelectOrder(listOrder);
if (frmSelectOrder.ShowDialog() == DialogResult.OK)
{
mOrderInfo = frmSelectOrder.mOrderInfo;
if (mOrderInfo != null)
{
txtCustomerName.Text = mOrderInfo.Name;
txtPhone.Text = mOrderInfo.Phone;
txtIDCard.Text = mOrderInfo.IdCardNo;
txtCurrentRate.Text = mOrderInfo.OrderRoomRate.ToString();
txtNotice.Text = mOrderInfo.Notice;
btnAddCustomer_Click(null, new EventArgs());
}
}
}
txtDay.Text = hml.ToParameter(listSysParameter, "DEFAULT_STAY_DAYS").Value1; //listSysParameter.Where(c => c.ParamNo == "DEFAULT_STAY_DAYS").Select(c => c.Value1).First();
txtCurrentDeposit.Text = hml.ToParameter(listSysParameter, "DEFAULT_DEPOSIT").Value1;
txtCurrentRate.Text = txtCurrentRate.Text.Equals("") ? mRoomInfo.RoomRate.ToString() : txtCurrentRate.Text;
txtDiskonRate.Text = hml.ToParameter(listSysParameter, "DEFAULT_DISKON").Value1;
txtCustomerNumber.Text = hml.ToParameter(listSysParameter, "DEFAULT_CUSTOMER_NUMBER").Value1;
}
/// <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);
}
public List<OrderInfoModel> GetOrderInfo(OrderInfoModel mOrder, ObjectControls oCtrl)
{
string sql = @"SELECT D.ORDER_ID,D.NAME,D.PHONE,D.ID_CARD,D.ROOM_RATE AS ORDER_RATE,D.STATUS AS ORDER_STATUS,D.START_DATE,D.END_DATE,D.KEEP_DATE,D.NOTICE,
D.CREATE_DATE,D.CREATE_USERID,D.UPDATE_DATE,D.UPDATE_USERID,
A.ROOM_ID, A.ROOM_NO, A.ROOM_TYPE,C.CODE_DESC AS ROOM_TYPE_DESC, A.ROOM_RATES, A.STATUS AS ROOM_STATUS,
A.ROOM_PHONE,B.FLOOR_ID, B.FLOOR_NAME, B.STATUS AS FLOOR_STATUS
FROM ORDER_INFO D INNER JOIN
BAS_ROOM_INFO AS A ON D.ROOM_ID=A.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=" + mOrder.RoomInfo.RoomId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomNo) && oCtrl.Append(ref sql, " AND A.ROOM_NO=" + SQL(mOrder.RoomInfo.RoomNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomStatus) && oCtrl.Append(ref sql, " AND A.STATUS=" + SQL(mOrder.RoomInfo.Status)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomStatusGroup) && oCtrl.Append(ref sql, " AND A.STATUS IN (" + mOrder.RoomInfo.StatusGroup + ")"));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomType) && oCtrl.Append(ref sql, " AND A.ROOM_TYPE=" + SQL(mOrder.RoomInfo.RoomType)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByFloorId) && oCtrl.Append(ref sql, " AND B.FLOOR_ID=" + mOrder.RoomInfo.FloorInfo.FloorId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByFloorName) && oCtrl.Append(ref sql, " AND B.FLOOR_NAME=" + SQL(mOrder.RoomInfo.FloorInfo.FloorName)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStartDateBetween) && oCtrl.Append(ref sql, " AND D.START_DATE BETWEEN " + SQL(mOrder.CommonInfo.StartDate) + " AND " + SQL(mOrder.CommonInfo.EndDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByEndDateBetween) && oCtrl.Append(ref sql, " AND D.END_DATE BETWEEN " + SQL(mOrder.CommonInfo.StartDate) + " AND " + SQL(mOrder.CommonInfo.EndDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByKeepDateEnable) && oCtrl.Append(ref sql, " AND D.KEEP_DATE >= " + SQL(mOrder.KeepDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByKeepDateDisable) && oCtrl.Append(ref sql, " AND D.KEEP_DATE < " + SQL(mOrder.KeepDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByOrderStatus) && oCtrl.Append(ref sql, " AND D.STATUS=" + SQL(mOrder.Status)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByIdCard) && oCtrl.Append(ref sql, " AND D.ID_CARD=" + SQL(mOrder.IdCardNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByName) && oCtrl.Append(ref sql, " AND D.NAME=" + SQL(mOrder.Name)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByPhone) && oCtrl.Append(ref sql, " AND D.PHONE=" + SQL(mOrder.Phone)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByNPR) && oCtrl.Append(ref sql, " AND (D.NAME LIKE " + SQLL(mOrder.Name) + " OR D.PHONE LIKE " + SQLL(mOrder.Name) + " OR A.ROOM_NO LIKE " + SQLL(mOrder.Name)+")"));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByOrderId) && oCtrl.Append(ref sql, " AND D.ORDER_ID=" + mOrder.OrderId));
sql += " ORDER BY D.CREATE_DATE DESC";
sdr = ExecuteReader(sql);
List<OrderInfoModel> listOrderInfo = new List<OrderInfoModel>();
using (sdr)
{
while (sdr.Read())
{
OrderInfoModel mOrderInfo = new OrderInfoModel();
mOrderInfo.OrderId = ToInt32(sdr["ORDER_ID"]);
mOrderInfo.Name = ToString(sdr["NAME"]);
mOrderInfo.Phone = ToString(sdr["PHONE"]);
mOrderInfo.IdCardNo = ToString(sdr["ID_CARD"]);
mOrderInfo.OrderRoomRate = ToDouble(sdr["ORDER_RATE"]);
mOrderInfo.CommonInfo = new CommonModel();
mOrderInfo.CommonInfo.StartDate = ToDateTime(sdr["START_DATE"]);
mOrderInfo.CommonInfo.EndDate = ToDateTime(sdr["END_DATE"]);
mOrderInfo.KeepDate = ToDateTime(sdr["KEEP_DATE"]);
mOrderInfo.Notice = ToString(sdr["NOTICE"]);
mOrderInfo.Status = ToChar(sdr["ORDER_STATUS"]);
mOrderInfo.CommonInfo.CreateDate = ToDateTime(sdr["CREATE_DATE"]);
mOrderInfo.CommonInfo.CreateUserId = ToInt32(sdr["CREATE_USERID"]);
mOrderInfo.CommonInfo.UpdateDate = ToDateTime(sdr["UPDATE_DATE"]);
mOrderInfo.CommonInfo.UpdateUserId = ToInt32(sdr["UPDATE_USERID"]);
mOrderInfo.RoomInfo.RoomId = ToInt32(sdr["ROOM_ID"]);
mOrderInfo.RoomInfo.RoomNo = ToString(sdr["ROOM_NO"]);
mOrderInfo.RoomInfo.RoomPhone = ToString(sdr["ROOM_PHONE"]);
mOrderInfo.RoomInfo.RoomRate = ToDouble(sdr["ROOM_RATES"]);
mOrderInfo.RoomInfo.RoomType = ToChar(sdr["ROOM_TYPE"]);
mOrderInfo.RoomInfo.RoomTypeDesc = ToString(sdr["ROOM_TYPE_DESC"]);
mOrderInfo.RoomInfo.Status = ToChar(sdr["ROOM_STATUS"]);
mOrderInfo.RoomInfo.FloorInfo = new BasFloorModel();
mOrderInfo.RoomInfo.FloorInfo.FloorId = ToInt32(sdr["FLOOR_ID"]);
mOrderInfo.RoomInfo.FloorInfo.FloorName = ToString(sdr["FLOOR_NAME"]);
mOrderInfo.RoomInfo.FloorInfo.Status = ToChar(sdr["FLOOR_STATUS"]);
listOrderInfo.Add(mOrderInfo);
}
}
return listOrderInfo;
}
public DataSet GetOrderInfoDs(OrderInfoModel mOrder, ObjectControls oCtrl)
{
string sql = @"SELECT D.ORDER_ID,D.NAME,D.PHONE,D.ID_CARD,D.ROOM_RATE AS ORDER_RATE,D.STATUS AS ORDER_STATUS,D.START_DATE,D.END_DATE,D.KEEP_DATE,D.NOTICE,
D.CREATE_DATE,D.CREATE_USERID,D.UPDATE_DATE,D.UPDATE_USERID,
A.ROOM_ID, A.ROOM_NO, A.ROOM_TYPE,C.CODE_DESC AS ROOM_TYPE_DESC, A.ROOM_RATES, A.STATUS AS ROOM_STATUS,
A.ROOM_PHONE,B.FLOOR_ID, B.FLOOR_NAME, B.STATUS AS FLOOR_STATUS
FROM ORDER_INFO D INNER JOIN
BAS_ROOM_INFO AS A ON D.ROOM_ID=A.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=" + mOrder.RoomInfo.RoomId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomNo) && oCtrl.Append(ref sql, " AND A.ROOM_NO=" + SQL(mOrder.RoomInfo.RoomNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomStatus) && oCtrl.Append(ref sql, " AND A.STATUS=" + SQL(mOrder.RoomInfo.Status)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomStatusGroup) && oCtrl.Append(ref sql, " AND A.STATUS IN (" + mOrder.RoomInfo.StatusGroup + ")"));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomType) && oCtrl.Append(ref sql, " AND A.ROOM_TYPE=" + SQL(mOrder.RoomInfo.RoomType)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByFloorId) && oCtrl.Append(ref sql, " AND B.FLOOR_ID=" + mOrder.RoomInfo.FloorInfo.FloorId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByFloorName) && oCtrl.Append(ref sql, " AND B.FLOOR_NAME=" + SQL(mOrder.RoomInfo.FloorInfo.FloorName)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStartDateBetween) && oCtrl.Append(ref sql, " AND D.START_DATE BETWEEN " + SQL(mOrder.CommonInfo.StartDate) + " AND " + SQL(mOrder.CommonInfo.EndDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByEndDateBetween) && oCtrl.Append(ref sql, " AND D.END_DATE BETWEEN " + SQL(mOrder.CommonInfo.StartDate) + " AND " + SQL(mOrder.CommonInfo.EndDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByKeepDateEnable) && oCtrl.Append(ref sql, " AND D.KEEP_DATE >= " + SQL(mOrder.KeepDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByKeepDateDisable) && oCtrl.Append(ref sql, " AND D.KEEP_DATE < " + SQL(mOrder.KeepDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByOrderStatus) && oCtrl.Append(ref sql, " AND D.STATUS=" + SQL(mOrder.Status)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByIdCard) && oCtrl.Append(ref sql, " AND D.ID_CARD=" + SQL(mOrder.IdCardNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByName) && oCtrl.Append(ref sql, " AND D.NAME=" + SQL(mOrder.Name)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByPhone) && oCtrl.Append(ref sql, " AND D.PHONE=" + SQL(mOrder.Phone)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByNPR) && oCtrl.Append(ref sql, " AND (D.NAME LIKE " + SQLL(mOrder.Name) + " OR D.PHONE LIKE " + SQLL(mOrder.Name) + " OR A.ROOM_NO LIKE " + SQLL(mOrder.Name) + ")"));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByOrderId) && oCtrl.Append(ref sql, " AND D.ORDER_ID=" + mOrder.OrderId));
sql += " ORDER BY D.CREATE_DATE DESC";
return ExecuteDataSet(sql);
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
if (cmn.CheckEOF(listOrderRoomInfo))
{
if (mOrderInfo.OrderId < 0)
{
foreach (OrderInfoModel mOrder in listOrderRoomInfo)
{
bOrder.InsertOrderInfo(mOrder);
if (mOrder.RoomInfo.Status != 'I' && mOrder.RoomInfo.Status != 'T')
{
mOrder.RoomInfo.Status = 'O';
hml.UpdateRoomStatusByRoomId(mOrder.RoomInfo,UserInfo);
}
}
}
else
{
mOrderInfo = CheckOrder(mOrderInfo);
oCtrl.Reset();
oCtrl.Add(MCtrl.SetName);
oCtrl.Add(MCtrl.SetPhone);
oCtrl.Add(MCtrl.SetIdCard);
oCtrl.Add(MCtrl.SetStartDate);
oCtrl.Add(MCtrl.SetEndDate);
oCtrl.Add(MCtrl.SetKeepDate);
oCtrl.Add(MCtrl.SetRoomId);
oCtrl.Add(MCtrl.SetRoomRate);
oCtrl.Add(MCtrl.SetNotice);
oCtrl.Add(MCtrl.SetOrderStatus);
bOrder.UpdateOrderInfo(mOrderInfo, oCtrl);
}
}
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception err)
{
lblMsg.Text = err.Message;
}
}
