public bool Update(OrderDinnerEntity obj) { try { Update("OrderDinnerMap.Update", obj); return(true); } catch { return(false); } }
public bool Save(OrderDinnerEntity obj) { try { Insert("OrderDinnerMap.Insert", obj); return(true); } catch { return(false); } }
public ActionResult setOrder(string userid, DateTime orderDate, int orderNumber, string footTime) { try { JsonResult result = new JsonResult(); UserInfoEntity user = userLogic.Load(userid); Random rad = new Random(); if (user != null) { string Condition = " and (CancUser is null or CancUser = '') and userid='" + userid + "' and orderdate between '" + orderDate.ToString("yyyy-MM-dd 00:00:00") + "' and '" + orderDate.ToString("yyyy-MM-dd 23:59:59") + "' and typecode=" + footTime; int rowCount = dinnerlogic.Count(Condition); if (rowCount > 0) { result.Data = new { status = 200, msg = "此期间,订餐您已经预定!" }; return(Json(result, JsonRequestBehavior.AllowGet)); } OrderDinnerEntity ordDinner = new OrderDinnerEntity(); ordDinner.OrdId = userid + "-" + DateTime.Now.ToString("yyMMddHHmmss") + rad.Next(10, 99); ordDinner.OrdName = userid + "-预定餐饮"; ordDinner.UserId = userid; ordDinner.OrderDate = orderDate; ordDinner.TypeCode = footTime; ordDinner.Quantity = orderNumber; ordDinner.OrdStatus = "0"; ordDinner.CreateUser = userid; ordDinner.CreateDate = DateTime.Now; bool isok = dinnerlogic.Save(ordDinner); if (isok) { result.Data = new { status = 100, msg = "success" }; } else { result.Data = new { status = 200, msg = "订餐失败" }; } return(Json(result, JsonRequestBehavior.AllowGet)); } else { result.Data = new { status = 200, msg = "用户不存在", userid = "" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { JsonResult result = new JsonResult(); result.Data = new { status = 200, msg = ex.Message, userid = "" }; return(Json(result, JsonRequestBehavior.AllowGet)); } }
public Task <bool> SaveAsync(OrderDinnerEntity obj) { try { Insert("OrderDinnerMap.Insert", obj); //return new Task<bool>(() => true); return(Task.FromResult(true)); } catch { return(Task.FromResult(false)); //return new Task<bool>(() => false); } }
public OrderDinnerEntity Load(string code) { try { if (!string.IsNullOrEmpty(code)) { OrderDinnerEntity dinner = QueryForObject <OrderDinnerEntity>("OrderDinnerMap.Load", code); return(dinner); } else { return(null); } } catch (Exception) { throw; } }
public ActionResult cancelOrderByIds(string[] cancelOrderIds) { try { JsonResult result = new JsonResult(); if (cancelOrderIds.Length == 0) { result.Data = new { status = 200, msg = "没有需要取消的点餐数据!", orders = "" }; return(Json(result, JsonRequestBehavior.AllowGet)); } foreach (var item in cancelOrderIds) { if (item != "") { OrderDinnerEntity dinner = dinnerlogic.Load(item); DateTime orderTimeEnd = DateTime.Parse(dinner.OrderDate.ToString("yyyy-MM-dd 23:59:59")); if (DateTime.Now.CompareTo(orderTimeEnd) > 0) { result.Data = new { status = 200, msg = "此预定不允许取消,只能当天取消!", orders = "" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } } bool isok = dinnerlogic.CancelOrderDinner(cancelOrderIds); if (isok) { result.Data = new { status = 100, msg = "success", orders = "" }; return(Json(result, JsonRequestBehavior.AllowGet)); } else { result.Data = new { status = 200, msg = "取消失败!", orders = "" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { JsonResult result = new JsonResult(); result.Data = new { status = 200, msg = ex.Message, orders = "" }; return(Json(result, JsonRequestBehavior.AllowGet)); } }
public bool CancelOrderDinner(string[] cancelOrderIds) { using (TransactionScope trans = new TransactionScope()) { try { bool isok = true; foreach (var itemstring in cancelOrderIds) { OrderDinnerEntity dinner = access.Load(itemstring); if (dinner != null) { dinner.CancDate = DateTime.Now; dinner.CancUser = dinner.CreateUser; isok = access.Update(dinner); if (isok == false) { return(false); } } } if (isok == true) { trans.Complete(); return(true); } else { return(false); } } catch (Exception ex) { return(false); } } }
public ActionResult setOrderBySurvey(string orderid, string survey) { JsonResult result = new JsonResult(); OrderDinnerEntity orderEnty = dinnerlogic.Load(orderid); if (orderEnty != null) { SatisfactionEntity model = new SatisfactionEntity(); model.SatisId = orderid + "-" + DateTime.Now.ToString("yyMMddHHmmss"); model.OrderId = orderid; model.SatisResult = survey; model.CreateDate = DateTime.Now; bool isok = Satislogic.Save(model); result.Data = new { status = 100, msg = "成功!" }; return(Json(result, JsonRequestBehavior.AllowGet)); } else { result.Data = new { status = 200, msg = "此订单不存在!" }; return(Json(result, JsonRequestBehavior.AllowGet)); } //return Json(result, JsonRequestBehavior.AllowGet); }
public bool Update(OrderDinnerEntity obj) { return(access.Update(obj)); }
public bool Save(OrderDinnerEntity obj) { return(access.Save(obj)); }
public async Task <ActionResult> setBatchOrder(string userid, DateTime startDate, DateTime endDate, int orderNumber, string footTime) { try { JsonResult result = new JsonResult(); UserInfoEntity user = userLogic.Load(userid); Random rad = new Random(); if (user != null) { if ((startDate.CompareTo(DateTime.Now) < 0) || (endDate.CompareTo(DateTime.Now) < 0)) { result.Data = new { status = 200, msg = "开始日期或结束日期不能早于或者等于当前日期" }; return(Json(result, JsonRequestBehavior.AllowGet)); } // 取消不算 string Condition = " and (CancUser is null or CancUser = '') and userid='" + userid + "' and orderdate between '" + startDate.ToString("yyyy-MM-dd 00:00:00") + "' and '" + endDate.ToString("yyyy-MM-dd 23:59:59") + "' and typecode=" + footTime; int rowCount = dinnerlogic.Count(Condition); if (rowCount > 0) { result.Data = new { status = 200, msg = "此期间,您已经预定!" }; return(Json(result, JsonRequestBehavior.AllowGet)); } TimeSpan tsCha = endDate - startDate; int daysCha = tsCha.Days; // 相差几天 IList <OrderDinnerEntity> dinnerList = new List <OrderDinnerEntity>(); for (int row = 0; row <= daysCha; row++) { DateTime dtOrderDate = startDate.AddDays(row); OrderDinnerEntity ordDinner = new OrderDinnerEntity(); ordDinner.OrdId = userid + "-" + DateTime.Now.ToString("yyMMddHHmmss") + rad.Next(10, 99); ordDinner.OrdName = userid + "-预定餐饮"; ordDinner.UserId = userid; ordDinner.OrderDate = dtOrderDate; ordDinner.TypeCode = footTime; ordDinner.Quantity = orderNumber; ordDinner.OrdStatus = "0"; ordDinner.CreateUser = userid; ordDinner.CreateDate = DateTime.Now; dinnerList.Add(ordDinner); } var taskResult = await Task.FromResult(dinnerlogic.setBatchOrder(dinnerList)); Task <bool> isok = taskResult; if (isok.Result == true) { result.Data = new { status = 100, msg = "success" }; } else { result.Data = new { status = 200, msg = "订餐失败" }; } return(Json(result, JsonRequestBehavior.AllowGet)); } else { result.Data = new { status = 200, msg = "用户不存在" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { JsonResult result = new JsonResult(); result.Data = new { status = 200, msg = ex.Message, userid = "" }; return(Json(result, JsonRequestBehavior.AllowGet)); } }