/// <summary> /// 订单信息 /// </summary> /// <param name="oid">订单id</param> /// <returns></returns> public ActionResult OrderInfo(int oid = -1) { OrderInfo orderInfo = AdminOrders.GetOrderByOid(oid); if (orderInfo == null) { return(PromptView("订单不存在")); } if (orderInfo.StoreId != WorkContext.StoreId) { return(PromptView("不能操作其它店铺的订单")); } OrderInfoModel model = new OrderInfoModel(); model.OrderInfo = orderInfo; model.RegionInfo = Regions.GetRegionById(orderInfo.RegionId); model.UserInfo = Users.GetUserById(orderInfo.Uid); model.UserRankInfo = AdminUserRanks.GetUserRankById(model.UserInfo.UserRid); model.OrderProductList = AdminOrders.GetOrderProductList(oid); model.OrderActionList = OrderActions.GetOrderActionList(oid); ViewData["referer"] = MallUtils.GetStoreAdminRefererCookie(); return(View(model)); }
public async Task <Operate> AddOrder(OrderInfoModel model) { var userName = User.Identity.Name; var rootUrl = Request.RequestUri.GetLeftPart(UriPartial.Authority); return(await _orderService.AddOrder(model, userName, rootUrl)); }
/// <summary> /// 订单信息 /// </summary> /// <param name="oid">订单id</param> /// <returns></returns> public ActionResult OrderInfo(int oid = -1) { OrderInfo orderInfo = AdminOrders.GetOrderByOid(oid); if (orderInfo == null) { return(PromptView("订单不存在")); } if (orderInfo.StoreId != WorkContext.StoreId) { return(PromptView("不能操作其它店铺的订单")); } OrderInfoModel model = new OrderInfoModel(); model.OrderInfo = orderInfo; model.RegionInfo = Regions.GetRegionById(orderInfo.RegionId); model.UserInfo = Users.GetUserById(orderInfo.Uid); model.UserRankInfo = AdminUserRanks.GetUserRankById(model.UserInfo.UserRid); model.OrderProductList = AdminOrders.GetOrderProductList(oid); model.OrderActionList = OrderActions.GetOrderActionList(oid); string[] sizeList = StringHelper.SplitString(WorkContext.MallConfig.ProductShowThumbSize); ViewData["size"] = sizeList[sizeList.Length / 2]; ViewData["referer"] = MallUtils.GetStoreAdminRefererCookie(); return(View(model)); }
public async Task <Operate> AddQuoteToOrder([FromUri] int id, [FromBody] OrderInfoModel model) { var userName = User.Identity.Name; var rootUrl = Request.RequestUri.GetLeftPart(UriPartial.Authority); return(await _orderService.AddQuoteToOrder(id, model, userName, rootUrl)); }
private void pbtnCancel_Click(object sender, EventArgs e) { OrderInfoModel mOrder = GetSelectedOrder(); if (mOrder != null) { if (mOrder.Status == 'I') { cmn.Show("宾客已入住,不能取消"); return; } if (cmn.Confirm(string.Format("确定取消宾客{0}在房间{1}的预定?", mOrder.Name, mOrder.RoomInfo.RoomNo))) { mOrder.Status = 'C'; oCtrl.Reset(); oCtrl.Add(MCtrl.SetOrderStatus); bOrder.UpdateOrderInfo(mOrder, oCtrl); if (mOrder.RoomInfo.Status != 'I' && mOrder.RoomInfo.Status != 'T') { mOrder.RoomInfo.Status = 'E'; hml.UpdateRoomStatusByRoomId(mOrder.RoomInfo, UserInfo); } GetOrderInfo(); } } }
private void LoadInfo(string st) { OrderInfoModel om = new OrderInfoModel(); om.OrderID = Convert.ToInt32(st); oh = new OrderPayBLL().LoadInfo(om); }
public OrderShow LoadInfo(OrderInfoModel om) { string str = "select oi.MovieName,oi.OrderID,oi.OrderTime,oi.PayTime,oi.OrderSumMoney,ci.CinemaName,ofi.OfficeName,od.SeatID,oi.ChipInfoID,ofi.NullColOne,ofi.NullColTwo from[dbo].[OrderInfo] oi,[dbo].[OrderDetails] od ,[dbo].[CinemaInfo] ci,[dbo].[OfficeInfo] ofi where oi.OrderID=od.OrderID and oi.CinemaAddress=ci.CinemaAddress and oi.OfficeID=ofi.OfficeID and oi.OrderID=@OrderID and oi.IsPay=0"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("@OrderID", System.Data.SqlDbType.Int) { Value = om.OrderID } }; SqlDataReader reader = SqlHelper.ExecuteReader(str, System.Data.CommandType.Text, sqlParameters); List <OrderShow> ls = new List <OrderShow>(); while (reader.Read()) { ls.Add(new OrderShow(reader)); } reader.Close(); ls[0].SeatSum = new string[ls.Count]; for (int i = 0; i < ls.Count; i++) { ls[0].SeatSum[i] = ls[i].SeatID; } return(ls[0]); }
/// <summary> /// 创建订单 /// </summary> /// <param name="order"></param> /// <returns></returns> public Tbl_Order AddOrderForNoPay(OrderInfoModel order) { //创建订单号 string orderNo = OrderHelper.GenerateOrderNo(); //订单 Tbl_Order list = new Tbl_Order { OrderNo = orderNo, TicketSource = order.TicketSource, PayType = order.PayType, PayAccount = "", PayTradeNo = "", SellerId = 0, Price = 0, Linkman = order.Linkman, Mobile = order.Mobile, OrderStatus = (int)OrderDataStatus.NoPay, CreateTime = DateTime.Now, ValidityDateStart = order.ValidityDate, ValidityDateEnd = order.ValidityDate, UsedQuantity = 0, Remark = "TVM购票", IDCard = "", CreateUserId = 0, OrderType = 0, OTABusinessName = "", GroupWay = 0 }; return(list); }
public OrderShow LoadInfo(OrderInfoModel om) { OrderShow oh = new OrderPayDAL().LoadInfo(om); oh = Change(oh); return(oh); }
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 { 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); } }
public object getOrderContain(Dictionary <string, object> dicParas) { string errMsg = string.Empty; string orderFlwId = dicParas.ContainsKey("orderFlwId") ? dicParas["orderFlwId"].ToString() : string.Empty; XCCloudUserTokenModel userTokenModel = (XCCloudUserTokenModel)(dicParas[Constant.XCCloudUserTokenModel]); StoreIDDataModel userTokenDataModel = (StoreIDDataModel)(userTokenModel.DataModel); if (string.IsNullOrEmpty(orderFlwId)) { return(new ResponseModel(Return_Code.T, "", Result_Code.F, "订单Id参数无效")); } string storedProcedure = "GetOrderContainById"; SqlParameter[] sqlParameter = new SqlParameter[2]; sqlParameter[0] = new SqlParameter("@StoreId", SqlDbType.VarChar); sqlParameter[0].Value = userTokenDataModel.StoreId; sqlParameter[1] = new SqlParameter("@OrderFlwId", SqlDbType.Int); sqlParameter[1].Value = orderFlwId; System.Data.DataSet ds = XCCloudBLL.GetStoredProcedureSentence(storedProcedure, sqlParameter); if (ds != null && ds.Tables.Count == 2 && ds.Tables[0].Rows.Count > 0) { OrderMainModel main = Utils.GetModelList <OrderMainModel>(ds.Tables[0]).ToList()[0]; List <OrderDetailModel> detail = Utils.GetModelList <OrderDetailModel>(ds.Tables[1]).ToList(); OrderInfoModel model = new OrderInfoModel(main, detail); return(ResponseModelFactory.CreateSuccessModel <OrderInfoModel>(isSignKeyReturn, model)); } else { return(new ResponseModel(Return_Code.T, "", Result_Code.F, "订单信息不存在")); } }
public async Task <IActionResult> AddOrder([FromBody] OrderInfoModel model) { var order = this._mapper.Map <Order>(model); var result = await this._orderService.CreateOrderAsync(order, User.Identity.Name); return(Ok(new { message = $"Order with ID:{result.Id} was added to user: ${User.Identity.Name}", id = result.Id })); }
/// <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); }
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); }
public ActionResult AjaxUpdateAddress(OrderInfoModel model) { if (UserSession.CurrentUser == null) { return(Content("{\"success\":false,\"message\":\"请先登录\"}")); } if (!ModelState.IsValid) { return(Content("{\"success\":false,\"message\":\"收货人信息有误,麻烦检查下\"}")); } Inpinke_User_Address address = new Inpinke_User_Address() { Address = model.Address, AreaID = model.AreaID, ProvID = model.ProvID, CityID = model.CityID, Mobile = model.Mobile, UserID = UserSession.CurrentUser.ID, UserName = model.Consignee }; BaseResponse br = new BaseResponse(); string result = ""; if (model.AddressID != 0) { address = DBAddressBLL.GetAddressByID(model.AddressID); address.Address = model.Address; address.AreaID = model.AreaID; address.ProvID = model.ProvID; address.CityID = model.CityID; address.Mobile = model.Mobile; address.UserID = UserSession.CurrentUser.ID; address.UserName = model.Consignee; if (address == null) { return(Content("{\"success\":false,\"message\":\"更新收货人信息失败\"}")); } br = DBAddressBLL.UpdateUserAddress(address); } else { br = DBAddressBLL.AddUserAddress(address); } if (br.IsSuccess) { result = "{\"success\":true,\"id\":" + address.ID + ",\"consignee\":\"" + address.UserName + "\",\"mobile\":\"" + address.Mobile + "\",\"provid\":" + address.ProvID + ",\"cityid\":" + address.CityID + ",\"areaid\":" + address.AreaID + ",\"address\":\"" + address.Address + "\",\"provname\":\"" + address.ProvName + "\",\"cityname\":\"" + address.CityName + "\",\"areaname\":\"" + address.AreaName + "\"}"; } else { result = "{\"success\":false,\"message\":\"" + br.Message + "\"}"; } return(Content(result)); }
public ActionResult NganLuong(OrderInfoModel data) { Session["CustomerName"] = data.CustomerName; Session["CustomerEmail"] = data.CustomerEmail; Session["CustomerAddress"] = data.CustomerAddress; Session["CustomerPhone"] = data.CustomerPhone; Session["CustomerComment"] = data.CustomerComment; Session["Total"] = data.Total; // Session["Giftcode"] = data.Giftcode; return(Content("nganluong/index")); }
public SendOrderToWMSModel SendOrderDataToWMS(OrderFormModel orderFormModel, Guid bookId) { SendOrderToWMSModel sendOrderToWms = new SendOrderToWMSModel(); OrderInfoModel orderInfo = new OrderInfoModel(); sendOrderToWms.BookingId = bookId; sendOrderToWms.CompletionDate = orderFormModel.CompletionDate; sendOrderToWms.CompletionTime = orderFormModel.CompletionTime; orderInfo.Remarks = orderFormModel.Remarks; orderInfo.OrderItems = orderFormModel.orderItems; sendOrderToWms.OrderInfo = orderInfo; return(sendOrderToWms); }
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); }
/// <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 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; } }
public int PostOrder(OrderInfoModel model) { try { string sql = $"insert into orderinfo VALUES(DEFAULT(orderinfo.OId),'{model.OrderBH}',{model.GoodsId},{model.OrderNum},NOW(),{model.OrderState},{model.ExpressId},{model.ProfileeId},{model.UserId})"; int n = DBHelper.ExecuteNonQuery(sql); string ordera = $"OrderInfoController 进行添加添加数据为{JsonConvert.SerializeObject(model)} 添加了{n}条数据"; LogHelper.Logger.Info(ordera); return(n); } catch (Exception ex) { LogHelper.Logger.Error($"错误OrderInfoController Post方法 数据为{model.ToString()}", ex); throw; } }
/// <summary> /// 订单信息 /// </summary> public ActionResult OrderInfo() { int oid = WebHelper.GetQueryInt("oid"); OrderInfo orderInfo = Orders.GetOrderByOid(oid); if (orderInfo == null || orderInfo.Uid != WorkContext.Uid) { return(PromptView("订单不存在")); } OrderInfoModel model = new OrderInfoModel(); model.OrderInfo = orderInfo; model.RegionInfo = Regions.GetRegionById(orderInfo.RegionId); model.OrderProductList = AdminOrders.GetOrderProductList(oid); return(View(model)); }
private void pbtnEditOrder_Click(object sender, EventArgs e) { OrderInfoModel mOrder = GetSelectedOrder(); if (mOrder != null) { if (mOrder.Status == 'I') { cmn.Show("宾客已入住,不能编辑"); return; } FormNewOrder frmNewOrder = new FormNewOrder(mOrder); if (frmNewOrder.ShowDialog() == DialogResult.OK) { GetOrderInfo(); } } }
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; } }
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 async Task <ResponseModel <IEnumerable <object> > > Handle(GetOrdersQuery getOrdersQuery, CancellationToken cancellationToken) { var builder = new SqlBuilder(); var sql = builder.AddTemplate(@"select * from Orders /**where**/ /**orderby**/ LIMIT @Next OFFSET @Offset", new { Offset = getOrdersQuery.OrderFilterModel.PageNumber - 1, Next = getOrdersQuery.OrderFilterModel.PageSize }); if (!string.IsNullOrEmpty(getOrdersQuery.OrderFilterModel.SearchText)) { builder.Where("StoreName || CustomerName like @SearchText", new { SearchText = "%" + getOrdersQuery.OrderFilterModel.SearchText + "%" }); } if (getOrdersQuery.OrderFilterModel.StartDate.HasValue && getOrdersQuery.OrderFilterModel.EndDate.HasValue) { builder.Where("CreatedOn >= @StartDate AND CreatedOn <= @EndDate", new { StartDate = getOrdersQuery.OrderFilterModel.StartDate.Value, EndDate = getOrdersQuery.OrderFilterModel.EndDate.Value }); } if (getOrdersQuery.OrderFilterModel.Statuses.ContainItem()) { builder.Where("Status in (@Statuses)", new { getOrdersQuery.OrderFilterModel.Statuses }); } if (!string.IsNullOrEmpty(getOrdersQuery.OrderFilterModel.SortBy)) { var sortColumns = OrderInfoModel.GetMatchOrderByFields(getOrdersQuery.OrderFilterModel.SortBy); if (sortColumns.ContainItem()) { builder.OrderBy($"{string.Join(",", sortColumns)}"); } } using var connection = _dbConnectionFactory.CreateConnection(); var result = await connection.QueryAsync <object>(sql.RawSql, sql.Parameters); return(ResponseModel.Ok(result)); }
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); }
private void pbtnOpenOrder_Click(object sender, EventArgs e) { try { OrderInfoModel mOrder = GetSelectedOrder(); if (mOrder != null) { if (!hml.OpenRoomCheck(mOrder.RoomInfo)) { return; } FormOneCustomer frmOneCustomer = new FormOneCustomer(mOrder.RoomInfo); if (frmOneCustomer.ShowDialog() == DialogResult.OK) { GetOrderInfo(); } } } catch (Exception err) { cmn.Show(err.Message); } }
private void pbtnDeleteOrder_Click(object sender, EventArgs e) { OrderInfoModel mOrder = GetSelectedOrder(); if (mOrder != null) { if (mOrder.Status == 'I') { cmn.Show("宾客已入住,不能删除"); return; } if (cmn.Confirm(string.Format("确定删除宾客{0}在房间{1}的预定?", mOrder.Name, mOrder.RoomInfo.RoomNo))) { bOrder.DeleteOrder(mOrder); if (mOrder.RoomInfo.Status != 'I' && mOrder.RoomInfo.Status != 'T') { mOrder.RoomInfo.Status = 'E'; hml.UpdateRoomStatusByRoomId(mOrder.RoomInfo, UserInfo); } GetOrderInfo(); } } }
protected OrderModelBase() { OrderInfo = new OrderInfoModel(); }