public ActionResult Order(int page, int limit, Order t) { OrderBll bll = new OrderBll(); var List = bll.SelectList() .Where(i => isTrue(i.BarCode, t.BarCode) && IsTrue(i.OrderTime, t.OrderTime) && isTrue(i.address, t.address) && isTrue(i.Remarks, t.Remarks) ) .Select(i => new { i.BarCode, i.address, i.OrderId, OrderTime = i.OrderTime.ToString(), i.Remarks }); var ListJson = new { code = 0, msg = "", count = List.Count(), data = List.Skip((page - 1) * limit).Take(limit).ToList() }; return(Json(ListJson, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 我的订单分布视图 /// </summary> /// <returns></returns> public ActionResult MyOrder(string num = "0") { List <OrderTable> list = OrderBll.SelectUserOrder(Convert.ToInt32(Session["userid"])); if (num == "1") { list = list.OrderBy(p => p.GetTime).ToList(); } else if (num == "2") { list = list.OrderByDescending(p => p.OrderAmount).ToList(); } else if (num == "3") { list = list.Where(p => p.IsReceiving == 0).ToList(); } else if (num == "4") { list = list.Where(p => p.IsComment == 0).ToList(); } else if (num == "5") { list = list.Where(p => p.IsReceiving == 1).ToList(); } else if (num == "6") { list = list.Where(p => p.IsComment == 1).ToList(); } Session["userorder"] = list; ViewBag.index = Convert.ToInt32(num); return(PartialView("MyOrder")); }
protected void btnOK_OnClick(object sender, EventArgs e) { byte byteDeliveryStar = 1; byte byteEatingStar = 1; byte.TryParse(hfDeliveryStar.Value, out byteDeliveryStar); byte.TryParse(hfEatingStar.Value, out byteEatingStar); if (OrderBll.AddOrderResult(new Ye_OrderResult() { OrderID = Convert.ToInt32(Request.QueryString["orderId"]), ShopID = ShopId, UserID = YeUser.UserID, EvaluationContent = tbxContent.Text, DeliveryStar = byteDeliveryStar, //待修改 EatingStar = byteEatingStar, //待修改 CreateTime = DateTime.Now })) { WebUtil.AlertAndRedirect("感谢您的支持!", "UserOrders.aspx"); } else { WebUtil.AlertAndRedirect("用餐评价失败!", "UserOrders.aspx"); } }
private void BindData() { pager1.DataItemCount = OrderBll.GetOrders().Count(); using (var entities = new YellEatEntities()) { var query = from order in entities.Ye_Order join user in entities.Ye_User on order.UserID equals user.UserID join shop in entities.Ye_Shop on order.ShopID equals shop.ShopID select new { order.OrderSN, order.UserID, order.OrderStatus, order.OrderCreateTime, order.Tax, order.UnitCouponCost, order.TotalPrice, shop.ShopName, user.UserName, order.OrderID }; rpt.DataSource = query.OrderByDescending(p => p.OrderCreateTime) .Skip(pager1.CurrentPagerIndex * pager1.PageSize) .Take(pager1.PageSize) .ToArray(); rpt.DataBind(); } pager1.SetPagerControlState(); }
public string Submit([FromBody] QueryCreateOrder query) { query.Ssid = query.Ssid.Substring(1, query.Ssid.Length - 2); var json = new OrderBll().SubimtOrder(query); return(JsonConvert.SerializeObject(json)); }
/// <summary> /// 立即购买 /// </summary> /// <param name="GoodsId">商品id</param> /// <param name="ShoppingNum">购买数量</param> /// <param name="OrderAmount">小计</param> /// <returns></returns> public JsonResult AddOrder(string GoodsId, string ShoppingNum, string OrderAmount) { UserInfo user = Session["user"] as UserInfo; //判断收货地址是否为空 if (user.ReceivingAddress == "") { return(Json(3, JsonRequestBehavior.AllowGet)); } //余额是否满足 if (user.UserWallet < Convert.ToDecimal(OrderAmount)) { return(Json(2, JsonRequestBehavior.AllowGet)); } OrderTable ord = new OrderTable() { GoodsID = Convert.ToInt32(GoodsId), UserID = Convert.ToInt32(Session["userid"]), GoodsNum = Convert.ToInt32(ShoppingNum), GetTime = DateTime.Now, OrderAmount = Convert.ToDecimal(OrderAmount), IsComment = 0, IsReceiving = 0 }; if (OrderBll.AddOrder(ord)) { return(Json(1, JsonRequestBehavior.AllowGet)); } return(Json(0, JsonRequestBehavior.AllowGet)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var ltl = this.Master.FindControl("ltlSiteMapPath") as Literal; ltl.Text = WebUtil.CreateBreadcrumbs(new List <Tuple <string, string> >() { new Tuple <string, string>("YellEat 后台管理系统", ""), new Tuple <string, string>("餐馆管理首页", ""), new Tuple <string, string>("订单管理", ""), new Tuple <string, string>("订单详情", "") }); var id = Convert.ToInt32(Request.QueryString["id"]); var units = ProductBll.GetUnits().ToArray(); var orderDetails = OrderBll.GetOrderDetailsByOrderID(id).ToArray(); var details = from detail in orderDetails join product in ProductBll.GetProducts() on detail.ProductID equals product.ProductID join unit in units on product.UnitId equals unit.UnitID select new { detail.Quantity, detail.UnitCost, unit.UnitPoint, product.ProductName, product.ProductID }; Order = OrderBll.GetOrders().SingleOrDefault(p => p.OrderID == id); OrderResult = OrderBll.GetOrderResultByOrderID(id); rptOrderDetail.DataSource = details.ToArray(); rptOrderDetail.DataBind(); } }
private void BindList(int n) { OrderBll bll = new OrderBll(); this.orderlist.DataSource = bll.GetOrderList(n, 50); this.orderlist.DataBind(); }
/// <summary> /// 新增多个或单个订单 /// </summary> /// <param name="OrderList">订单集合/对象</param> /// <returns></returns> public JsonResult AddOrder(string OrderList) { UserInfo user = Session["user"] as UserInfo; //判断收货地址是否为空 if (user.ReceivingAddress == "") { return(Json(3, JsonRequestBehavior.AllowGet)); } JavaScriptSerializer js = new JavaScriptSerializer(); List <OrderTable> list = js.Deserialize <List <OrderTable> >(OrderList); //计算总金额 decimal price = 0; list.ToList().ForEach(p => price += p.OrderAmount ?? 0); if (user.UserWallet < price) { return(Json(2, JsonRequestBehavior.AllowGet)); } if (OrderBll.AddOrders(list, Convert.ToInt32(Session["userid"]), price)) { //修改购物车数量 Session["carcount"] = Convert.ToInt32(Session["carcount"]) - list.Count(); return(Json(1, JsonRequestBehavior.AllowGet)); } return(Json(0, JsonRequestBehavior.AllowGet)); }
public FrmMain() { userInfoBll = new UserInfoBll(); orderBll = new OrderBll(); userInfos = new List <UserInfo>(); InitializeComponent(); }
/// <summary> /// 直采订单取消 /// </summary> /// <param name="orderid"></param> /// <returns></returns> public DataResult OrderCancel(string orderid) { var result = new DataResult(); var orderquery = new XiWanOrderQueryRequest { OrderNo = orderid }; //日志 var logmodel = new HO_HotelOrderLogModel { HOLOrderId = orderid, HOLLogType = 1,//订单日志 HOLAddId = 0, HOLRemark = "直采订单取消", HOLAddName = "系统", HOLAddDepartId = 0, HOLAddDepartName = "系统", HOLAddTime = DateTime.Now, }; OrderLogBll.AddOrderModel(logmodel); var rtn = OrderBll.SetOrder(orderid, 3); if (rtn.IsSuccess == 1) { result.Code = DataResultType.Sucess; } else { result.Code = DataResultType.Fail; result.Message = rtn?.Msg; } return(result); }
/// <summary> /// 喜玩操作订单 /// </summary> /// <returns></returns> public DataResult XiWanCancelOrder(string orderid) { var result = new DataResult(); var orderquery = new XiWanOrderQueryRequest { OrderNo = orderid }; //日志 var logmodel = new HO_HotelOrderLogModel { HOLOrderId = orderid, HOLLogType = 1,//订单日志 HOLAddId = 0, HOLAddName = "系统", HOLAddDepartId = 0, HOLAddDepartName = "系统", HOLAddTime = DateTime.Now, }; var rtn = XiWanAPI.XiWanPost <XiWanCancelOrderResponse, XiWanOrderQueryRequest>(orderquery, HotelCancelOrderUrl); logmodel.HOLRemark = "喜玩取消请求:" + JsonConvert.SerializeObject(orderquery) + "||喜玩取消接口返回:" + JsonConvert.SerializeObject(rtn); OrderLogBll.AddOrderModel(logmodel); var order = rtn?.Result; if (rtn.Code == "0") { result.Code = DataResultType.Sucess; OrderBll.UpdatesSataus(orderid, 6); } else { result.Code = DataResultType.Fail; result.Message = rtn?.Msg; } return(result); }
/// <summary> /// 全部订单 /// </summary> /// <returns></returns> public ActionResult OrderList() { var user = GetCurrentUser(); ViewBag.WaitOrder = OrderBll.LoadEntities(o => o.state == "0" && o.UserId == user.Id).Select(o => o.Id).Count(); //待发货的个数 ViewBag.WaitAcceptOrder = OrderBll.LoadEntities(o => o.state == "1 " && o.UserId == user.Id).Select(o => o.Id).Count(); return(View()); }
/// <summary> /// 查询商品订单信息 /// </summary> /// <param name="OrderId">订单id</param> /// <returns></returns> public JsonResult AjaxSelect(string OrderId) { OrderTable ord = OrderBll.SelectOneOrder(Convert.ToInt32(OrderId)); //获取图片路径 string filename = GoodsPhotoBll.SelectAllGoodsPhoto().FirstOrDefault(p => p.GoodsID == ord.GoodsID).PhotoPath; return(Json(new { oid = OrderId, gid = ord.GoodsID, gname = ord.GoodsTable.GoodsName, gimg = filename }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetOrderList(int?pageIndex, int?pageSize, string HyName) { OrderBll bll = new OrderBll(); int recordCounts = 0; var result = bll.GetOrderDtoList(pageIndex, pageSize, HyName, ref recordCounts); return(Json(new { messCode = 200, recordCount = recordCounts, data = result })); }
/// <summary> /// 删除订单 /// </summary> /// <param name="OrderId">订单id</param> /// <returns></returns> public JsonResult OrderDel(string OrderId) { if (OrderBll.OrderDel(Convert.ToInt32(OrderId))) { return(Json(1, JsonRequestBehavior.AllowGet)); } return(Json(0, JsonRequestBehavior.AllowGet)); }
public string AddOrder(int userid, int productid, int pronum) { string result = "1"; Order order = new Order(); OrderBll orderbll = new OrderBll(); OrderList orderlist = new OrderList(); OrderListBll orderlistbll = new OrderListBll(); ProductBll pbll = new ProductBll(); UsersBll ubll = new UsersBll(); try { //检查 当前用户是否有末完成的订单 有不能 //if (orderbll.GetAll("*", " [status]=1 and userid=" + userid, null, "id").Entity.Count <= 0) //{ var p = pbll.GetByPrimaryKey(productid).Entity; var u = ubll.GetByPrimaryKey(userid).Entity; order.UserId = userid; order.ReciverName = u.UserName; order.PayMentTypeId = 1;//货到付款 order.RevicerAddress = u.Address; order.RevicerTel = u.Mobile; order.Status = 1;// order.RealPrice = pronum * p.OemPrice; order.TotalPrice = pronum * p.OemPrice; order.Count = 1; order.OrderTime = DateTime.Now; order.OrderNo = OrderHelper.GetProNo(); //添加订单 int orderaddid = orderbll.AddAndReturn(order); //添加订单详情 orderlist.Count = order.Count; orderlist.Productid = productid; orderlist.Orderid = orderaddid; orderlist.OemPrice = p.OemPrice; orderlist.MarketPrice = p.MarketPrice; orderlistbll.Add(orderlist); //} //else //{ // result = "-2"; //} } catch { result = "-1"; } return(result); }
protected void Button2_Click(object sender, EventArgs e) { string strkey = txtword.Text; //this.datalist.Visible = true; OrderBll bll = new OrderBll(); this.orderlist.DataSource = bll.GetOrderList(strkey); this.orderlist.DataBind(); }
public void Bind(string ordercode) { List <T_OrderDetail> list = new List <T_OrderDetail>(); OrderBll bll = new OrderBll(); list = bll.GetOrderDetailList(ordercode); dllist.DataSource = list; dllist.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var orderId = Convert.ToInt32(Request.QueryString["orderId"]); var order = OrderBll.GetOrderByID(Convert.ToInt32(orderId)); Shop = ShopBll.GetShopById(order.ShopID); ShopId = Shop.ShopID; } }
private void GetOrder() { string ordercode = ""; if (Request["code"] != null) { ordercode = Request["code"].ToString(); } if (ordercode != "") { T_Order model = new T_Order(); T_OrderDetail detail = new T_OrderDetail(); OrderBll bll = new OrderBll(); model = bll.GetOrder(ordercode); detail = bll.GetOrderDetailByCode(ordercode); if (model != null) { //商户订单号,商户网站订单系统中唯一订单号,必填 out_trade_no = model.OrderCode; //订单名称,必填 subject = detail.ProductName.Trim(); //付款金额,必填 total_fee = model.OrderPrice.ToString(); //收银台页面上,商品展示的超链接,必填 show_url = "http://m.makacake.com/productdetail.aspx?wd=" + detail.ProductId; //商品描述,可空 body = detail.ProductName; //把请求参数打包成数组 Config config = new Config(); SortedDictionary <string, string> sParaTemp = new SortedDictionary <string, string>(); sParaTemp.Add("partner", config.partner); sParaTemp.Add("seller_id", config.seller_id); sParaTemp.Add("_input_charset", config.input_charset.ToLower()); sParaTemp.Add("service", config.service); sParaTemp.Add("payment_type", config.payment_type); sParaTemp.Add("notify_url", config.notify_url); sParaTemp.Add("return_url", config.return_url); sParaTemp.Add("out_trade_no", out_trade_no); sParaTemp.Add("subject", subject); sParaTemp.Add("total_fee", total_fee); sParaTemp.Add("show_url", show_url); sParaTemp.Add("body", body); //其他业务参数根据在线开发文档,添加参数.文档地址:https://doc.open.alipay.com/doc2/detail.htm?spm=a219a.7629140.0.0.2Z6TSk&treeId=60&articleId=103693&docType=1 //如sParaTemp.Add("参数名","参数值"); //建立请求 string sHtmlText = Submit.BuildRequest(sParaTemp, "get", "确认"); Response.Write(sHtmlText); } } }
public ActionResult Welcome() { ViewBag.todayAllLeaveMsg = LeaveMsgBll.LoadEntities(m => true).Where(m => DbFunctions.DiffDays(m.InTime, DateTime.Now) == 0).Count(); ViewBag.todayAllOrder = OrderBll.LoadEntities(r => true).Where(r => DbFunctions.DiffDays(r.InTime, DateTime.Now) == 0).Count(); ViewBag.todayYj = FeedbackBll.LoadEntities(f => true).Where(f => DbFunctions.DiffDays(f.InTime, DateTime.Now) == 0).Count(); ViewBag.total = HttpContext.Application["total"]; ViewBag.onLine = HttpContext.Application["onLine"]; return(View()); }
private void BindData() { pager1.DataItemCount = OrderBll.GetOrdersByShopId(YeShopId).Count(p => p.IsShopDeleted == false); rpt.DataSource = OrderBll.GetOrdersByShopId(YeShopId). Where(p => p.IsShopDeleted == false) .OrderBy(m => m.OrderCreateTime) .Skip(pager1.PageSize * pager1.CurrentPagerIndex) .Take(pager1.PageSize).ToArray(); rpt.DataBind(); pager1.SetPagerControlState(); }
public string AddOrder(int userid, string data, int price, string pno, string payMentType, int bananaCount) { string result = "0"; Order order = new Order(); OrderBll orderbll = new OrderBll(); UsersBll ubll = new UsersBll(); var u = ubll.GetByPrimaryKey(userid).Entity; try { order.UserId = userid; order.ReciverName = u.UserName; order.PayMentTypeId = (byte?)(payMentType == "货到付款" ? 1 : 2);//货到付款 order.RevicerAddress = u.Address; order.RevicerTel = u.Mobile; order.Status = 0;//等待确认 order.RealPrice = price; order.TotalPrice = price; order.Count = 1; order.OrderTime = DateTime.Now; order.OrderNo = OrderHelper.GetProNo(); order.Pno = pno == "" ? null : pno; order.BananaCount = bananaCount; //添加订单 int orderaddid = orderbll.AddAndReturn(order); sendYzm("18758177964", "26871", new string[] { u.UserName + u.Mobile, DateTime.Now.ToString() }); string[] dataArr = data.Split(','); if (dataArr.Length > 0) { for (int d = 0; d < dataArr.Length; d++) { if (!string.IsNullOrEmpty(dataArr[d])) { if (dataArr[d].IndexOf("|") > -1) { string[] arr = dataArr[d].Split('|'); AddOrderList(u, Convert.ToInt32(arr[0]), Convert.ToInt32(arr[1]), orderaddid); result = orderaddid.ToString(); } } } } } catch { result = "-1"; } return(result); }
protected void Page_Load(object sender, EventArgs e) { OrderBll bll = new OrderBll(); List <T_Order> list = new List <T_Order>(); list = bll.GetOrderByUserId(); if (list != null) { dllist.DataSource = list; dllist.DataBind(); } }
protected void rpt_OnItemCommand(object source, RepeaterCommandEventArgs e) { var id = Convert.ToInt32(e.CommandArgument.ToString()); switch (e.CommandName) { case "del": { if (ProductBll.CheckProduct(id)) //菜单出现在订单中 { List <int> lisOrderId = OrderBll.GetOrderIDsByProductId(id); foreach (int orderId in lisOrderId) { OrderBll.ShopDeleteOrder(orderId); } //ProductBll.DeleteProduct(id); WebUtil.Alert("菜单删除成功!", this); pager1.CurrentPagerIndex = 0; BindData(); } else { if (ProductBll.DeleteProduct(id)) { WebUtil.Alert("菜单成功删除!", this); pager1.CurrentPagerIndex = 0; BindData(); } else { WebUtil.Alert("菜单删除失败!", this); } } break; } case "sj": { if (ProductBll.SetProductSaleState(id, true)) { WebUtil.Alert("菜单上架成功!", this); pager1.CurrentPagerIndex = 0; BindData(); } else { WebUtil.Alert("菜单上架失败!", this); } break; } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Response.Write("Hello World"); int id = context.Request.QueryString["id"].ToInt(); var falg = 0; if (id > 0) { falg = new OrderBll().DeleteList("id=" + id).ResultStatus.Code; } context.Response.Write(falg); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["wd"] != null && Request.QueryString["wd"].ToString() != "") { OrderBll bll = new OrderBll(); T_Order order = new T_Order(); order = bll.GetOrderByUserId(Request.QueryString["wd"].ToString()); if (order != null) { ordercode = order.OrderCode; } } }
//数据绑定 private void BindData() { pager1.DataItemCount = OrderBll.GetOrdersByShopId(YeShopId).Count(o => o.IsShopDeleted == false && o.OrderStatus == 1); var orders = OrderBll.GetOrdersByShopId(YeShopId).Where(o => o.IsShopDeleted == false).OrderBy(o => o.OrderCreateTime).Skip(pager1.PageSize * pager1.CurrentPagerIndex).Take(pager1.PageSize); OrderDetails = (from detail in OrderBll.GetOrderDetails() join order in OrderBll.GetOrders() on detail.OrderID equals order.OrderID where order.ShopID == YeShopId select detail).ToList(); rpt.DataSource = orders.ToArray(); rpt.DataBind(); pager1.SetPagerControlState(); }
private void BindList() { string id = Request["id"]; OrderBll bll = new OrderBll(); T_Order order = new T_Order(); order = bll.GetOrder(id); if (order != null) { this.txtordercode.Value = id; this.txtmobile.Value = order.Mobile; this.txtaddress.Value = order.Adress; } this.orderlist.DataSource = bll.GetOrderDetailList(id); this.orderlist.DataBind(); }