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; } }