/// <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();
}
