//保存 protected void btn_Click(object sender, EventArgs e) { int id = DataConverter.CLng(hforderid.Value); M_OrderList orderinfo = orderBll.GetOrderListByid(id);//GetCartProOrderID B_CartPro cartproBll = new B_CartPro(); DataTable dts = cartproBll.GetCartProOrderID(id); }
protected void BatDel_Btn_Click(object sender, EventArgs e) { string CID = Request.Form["idchk"];//订单ID列表 if (!String.IsNullOrEmpty(CID)) { DataTable Ode = orderBll.GetOrderbyOrderlist(CID);//获得订单列表 int odcount = Ode.Rows.Count; for (int p = 0; p < odcount; p++) { int CartproOrderid = DataConverter.CLng(Ode.Rows[p]["id"]); //订单ID //历遍清单所有商品数量,查找库存/////////////////// DataTable Unew = Cll.GetCartProOrderID(CartproOrderid); //获得详细清单列表 for (int s = 0; s < Unew.Rows.Count; s++) { int Onum = DataConverter.CLng(Unew.Rows[s]["Pronum"]); int Opid = DataConverter.CLng(Unew.Rows[s]["ProID"]); M_Product pdin = Pll.GetproductByid(Opid);//获得商品信息 if (pdin.JisuanFs == 1) { int pstock = pdin.Stock + Onum;//库存结果,返回的商品数量 Pll.ProUpStock(Opid, pstock); } } ////////////////////////////////////////////////////// } orderBll.Delorderlist(CID); function.WriteSuccessMsg("删除成功", "OrderList.aspx"); } }
public void BindOrder() { int id = DataConverter.CLng(Request["id"]); DataTable cplist = cpl.GetCartProOrderID(id); procart.DataSource = cplist; procart.DataBind(); }
public void fahuo(int id, String Email) { B_CartPro cpl = new B_CartPro(); B_OrderList oll = new B_OrderList(); B_Product pll = new B_Product(); B_Stock Sll = new B_Stock(); //历遍清单所有商品数量,查找库存/////////////////// DataTable Unew = cpl.GetCartProOrderID(id); //获得详细清单列表 M_OrderList orlist = oll.GetOrderListByid(id); for (int s = 0; s < Unew.Rows.Count; s++) { int Onum = ZoomLa.Common.DataConverter.CLng(Unew.Rows[s]["Pronum"]); int Opid = ZoomLa.Common.DataConverter.CLng(Unew.Rows[s]["ProID"]); M_Product pdin = pll.GetproductByid(Opid);//获得商品信息 if (pdin.JisuanFs == 0) { int pstock = pdin.Stock - Onum;//库存结果,返回的商品数量 pll.ProUpStock(Opid, pstock); } M_Stock SData = new M_Stock(); SData.id = 0; SData.proid = Opid; SData.stocktype = 1; SData.proname = pdin.Proname; SData.danju = "CK" + orlist.OrderNo.ToString(); SData.adduser = orlist.Reuser.ToString(); SData.addtime = DateTime.Now; SData.content = "订单:" + orlist.Reuser.ToString() + "发货"; SData.Pronum = ZoomLa.Common.DataConverter.CLng(Unew.Rows[0]["Pronum"]); Sll.AddStock(SData); } string str = "StateLogistics=1"; if (!string.IsNullOrEmpty(Email)) { str += ",ExpressDelivery='" + Email + "'"; } oll.UpOrderinfo(str, id); PromotionComfirm(orlist); }
protected void Button1_Click1(object sender, EventArgs e) { string CID = Request.Form["idchk"];//订单ID列表 if (!String.IsNullOrEmpty(CID)) { DataTable Ode = bll.GetOrderbyOrderlist(CID);//获得订单列表 int odcount = Ode.Rows.Count; for (int p = 0; p < odcount; p++) { int CartproOrderid = DataConverter.CLng(Ode.Rows[p]["id"]); //订单ID //历遍清单所有商品数量,查找库存/////////////////// DataTable Unew = Cll.GetCartProOrderID(CartproOrderid); //获得详细清单列表 for (int s = 0; s < Unew.Rows.Count; s++) { int Onum = DataConverter.CLng(Unew.Rows[s]["Pronum"]); int Opid = DataConverter.CLng(Unew.Rows[s]["ProID"]); M_Product pdin = Pll.GetproductByid(Opid);//获得商品信息 if (pdin.JisuanFs == 1) { int pstock = pdin.Stock + Onum;//库存结果,返回的商品数量 Pll.ProUpStock(Opid, pstock); } } } bll.DelByIDS(CID); Response.Write("<script language=javascript>alert('删除成功!');location.href='TravelOrder_Manager.aspx'</script>"); } else { Response.Write("<script language=javascript>alert('删除失败!');location.href='TravelOrder_Manager.aspx'</script>"); } }
/// <summary> /// 如果是推广商品就添加推广信息 /// </summary> /// <param name="orlist"></param> public void PromotionComfirm(M_OrderList orlist) { B_ArticlePromotion bap = new B_ArticlePromotion(); B_CartPro cpl = new B_CartPro(); DataTable mcp; mcp = cpl.GetCartProOrderID(orlist.id); if (mcp != null && mcp.Rows.Count > 0) { if (orlist.Settle == 1) { for (int i = 0; i < mcp.Rows.Count; i++) { Response.Write(mcp.Rows[i]["id"].ToString()); M_ArticlePromotion map = bap.GetSelectBySqlParams("select * from ZL_ArticlePromotion where cartproid=" + mcp.Rows[i]["id"].ToString(), null); if (map.Id > 0) { map.IsEnable = true; bap.GetUpdate(map); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!B_ARoleAuth.Check(ZLEnum.Auth.shop, "OrderList")) { function.WriteErrMsg("没有权限进行此项操作"); } if (Mid < 1 && string.IsNullOrEmpty(OrderNO)) { function.WriteErrMsg("未指定订单"); } if (!IsPostBack) { if (Mid > 0) { orderinfo = oll.GetOrderListByid(Mid); } else if (!string.IsNullOrEmpty(Request["OrderNo"])) { orderinfo = oll.GetByOrder(Request["OrderNo"], "0"); } if (orderinfo == null || orderinfo.id < 1) { function.WriteErrMsg("订单不存在"); } OrderNO = orderinfo.OrderNo; //---------------------------------------------------------- M_UserInfo mu = buser.SelReturnModel(orderinfo.Userid); HeadTitle_L.Text = "订 单 信 息(订单编号:" + orderinfo.OrderNo + ")"; string giveurl = customPath2 + "User/Userexp.aspx?UserID=" + orderinfo.Userid + "&orderid=" + orderinfo.id; give_score_a.HRef = giveurl + "&type=" + (int)M_UserExpHis.SType.Point; give_purse_a.HRef = giveurl + "&type=" + (int)M_UserExpHis.SType.Purse; OrderNo_L.Text = orderinfo.OrderNo; Orderamounts_L.Text = orderinfo.Ordersamount.ToString("f2"); isCheckRe_L.Text = orderinfo.Guojia; Cdate_L.Text = orderinfo.AddTime.ToString("yyyy年MM月dd日 HH:mm"); Reuser.Text = StringHelper.SubStr(orderinfo.Reuser, 12); UName_L.Text = "<a href='javascript:;' onclick='showuinfo(" + mu.UserID + ");' title='查看用户'>" + mu.UserName + "</a>"; if (orderinfo.StateLogistics != 0) { Exp_Send_Btn.Enabled = false; } if (orderinfo.StateLogistics == 1) { Exp_ClientSign_Btn.Enabled = true; } if (orderinfo.StateLogistics == 0) { function.Script(this, "hiddLogistics();"); } if (orderinfo.Paymentstatus >= (int)M_OrderList.PayEnum.HasPayed) { Paymentstatus.Text = "<span style='color:green';>已经汇款</span>"; Pay_Has_Btn.Disabled = true; } else { Paymentstatus.Text = "<span style='color:red;'>等待汇款</span>"; Pay_Has_Btn.Disabled = false; Exp_Send_Btn.Enabled = false; } switch ((M_OrderList.StatusEnum)orderinfo.OrderStatus) { case M_OrderList.StatusEnum.Normal: OS_Sure_Btn.Enabled = true; break; case M_OrderList.StatusEnum.DrawBack: OS_Sure_Btn.Enabled = false; OS_NoSure_Btn.Enabled = false; CheckReturn.Enabled = true; UnCheckRetrun.Enabled = true; Exp_Send_Btn.Enabled = false; CompleteOrder_Btn.Enabled = false; break; case M_OrderList.StatusEnum.UnDrawBack: case M_OrderList.StatusEnum.CheckDrawBack: OS_Invoice_Btn.Enabled = false; OS_Sure_Btn.Enabled = false; OS_NoSure_Btn.Enabled = false; Exp_Send_Btn.Enabled = false; CompleteOrder_Btn.Enabled = false; break; case M_OrderList.StatusEnum.OrderFinish: case M_OrderList.StatusEnum.UnitFinish: CompleteOrder_Btn.Enabled = false; break; default: break; } #region 物流信息 ExpStatus_L.Text = OrderHelper.GetExpStatus(orderinfo.StateLogistics); M_Order_Exp expMod = expBll.SelReturnModel(DataConverter.CLng(orderinfo.ExpressNum)); if (expMod != null) { ExpName_L.Text = expMod.ExpComp; ExpCode_L.Text = expMod.ExpNo; ExpStatus_L.Text += "(公司:" + expMod.ExpComp + "/单号:" + expMod.ExpNo + ")"; } switch ((M_OrderList.ExpEnum)orderinfo.StateLogistics) { case M_OrderList.ExpEnum.NoSend: Exp_Cancel_Btn.Enabled = false; ExpPrint_B.Disabled = true; break; case M_OrderList.ExpEnum.HasSend: Exp_ClientSign_Btn.Enabled = true; break; case M_OrderList.ExpEnum.HasReceived: Exp_Send_Btn.Enabled = false; break; } DrawBackStr.Text = orderinfo.Merchandiser; Deliverytime.Text = orderinfo.Deliverytime.ToString();//送货时间 switch (orderinfo.Deliverytime) { case 1: Deliverytime.Text = "对送货时间没有特殊要求"; break; case 2: Deliverytime.Text = "双休日或者周一至周五的晚上送达"; break; case 3: Deliverytime.Text = "周一至周五的白天送达"; break; default: break; } Phone.Text = orderinfo.Phone.ToString(); //联系电话 ZipCode.Text = orderinfo.ZipCode.ToString(); //邮政编码 Mobile.Text = orderinfo.MobileNum; //手机 Reusers.Text = orderinfo.Reuser.ToString(); //订货人 Jiedao.Text = orderinfo.Shengfen + " " + orderinfo.Jiedao; //地址 #endregion OrderStatus.Text = OrderHelper.GetOrderStatus(orderinfo.OrderStatus); adddate.Text = orderinfo.AddTime.ToShortDateString(); OrderType_L.Text = orderinfo.AddTime.ToString(); Invoiceneeds.Text = orderinfo.Invoiceneeds == 1 ? ComRE.Icon_OK : ComRE.Icon_Error; Developedvotes.Text = orderinfo.Developedvotes == 1 ? ComRE.Icon_OK : ComRE.Icon_Error; //如果已支付 if (orderinfo.Integral > 0 && orderinfo.Paymentstatus >= (int)M_OrderList.PayEnum.HasPayed) { if (orderinfo.SendPointStatus == 1) { ISsend.Text = "已送出"; } } Pay_Has_Btn.Disabled = orderinfo.Paymentstatus == 1 ? true : false; //更改状态,已支付 OS_Freeze_Btn.Enabled = orderinfo.Settle == 1 ? false : true; //冻结 OS_Pause_Btn.Enabled = orderinfo.Suspended == 1 ? false : true; //暂停 if (orderinfo.Aside == 1) //已作废 { Pay_Has_Btn.Disabled = true; //ShowSend_Btn.Enabled = false; OS_Sure_Btn.Enabled = false; OS_NoSure_Btn.Enabled = false; CompleteOrder_Btn.Enabled = false; Exp_ClientSign_Btn.Enabled = false; OS_Freeze_Btn.Enabled = false; OS_Invoice_Btn.Enabled = false; OS_Pause_Btn.Enabled = false; OS_Aside_Btn.Enabled = false; Pay_Cancel_Btn.Enabled = false; Refund_B.Attributes["disabled"] = "disabled"; } else { OS_Aside_Btn.Enabled = true; } if (orderinfo.Settle == 1)//结清 { Pay_Has_Btn.Disabled = true; //ShowSend_Btn.Enabled = false; OS_Sure_Btn.Enabled = false; OS_NoSure_Btn.Enabled = false; OS_Aside_Btn.Enabled = false; Exp_ClientSign_Btn.Enabled = false; OS_Invoice_Btn.Enabled = false; OS_Pause_Btn.Enabled = false; } if (!string.IsNullOrEmpty(orderinfo.PaymentNo))//支付后才有值 { M_Payment payMod = payBll.SelModelByPayNo(orderinfo.PaymentNo); if (payMod.PayPlatID == 0) { Payment.Text = "虚拟币支付"; } else { M_PayPlat payPlatMod = platBll.GetPayPlatByid(payMod.PayPlatID); Payment.Text = payPlatMod.PayPlatName.ToString(); } } Email.Text = orderinfo.Email.ToString(); //电子信 Invoice.Text = orderinfo.Invoice.ToString(); //发票信息 if (orderinfo.Outstock == 1) { Outstock.Text = "缺货时,取消此订单"; } else { Outstock.Text = "缺货时,将有货的商品发出,取消无货商品的订购"; } AddUser.Text = orderinfo.AddUser.ToString(); //负责跟单人员 Internalrecords_T.Text = orderinfo.Internalrecords.ToString(); //内部记录 Ordermessage_T.Text = orderinfo.Ordermessage; //订货留言 LabScore.Text = orderinfo.Integral.ToString(); //积分 //-------购物车 DataTable cplist = cartProBll.GetCartProOrderID(Mid); Procart_RPT.DataSource = cplist; Procart_RPT.DataBind(); if (cplist.Rows.Count > 0 && !string.IsNullOrEmpty(cplist.Rows[0]["Additional"].ToString())) { M_Cart_Travel model = JsonConvert.DeserializeObject <M_Cart_Travel>(cplist.Rows[0]["Additional"].ToString()); List <M_Cart_Contract> modelList = new List <M_Cart_Contract>(); modelList.AddRange(model.Guest); modelList.AddRange(model.Contract); UserRPT.DataSource = modelList; UserRPT.DataBind(); } DataTable newtable = cplist.DefaultView.ToTable(false, "Shijia", "Pronum"); double allmoney = 0; for (int i = 0; i < newtable.Rows.Count; i++) { allmoney = allmoney + DataConverter.CDouble(cplist.Rows[i]["Allmoney"]); } //------- Label2.Text = orderinfo.Ordersamount.ToString(); Label29.Text = orderinfo.Ordersamount.ToString("f2"); Label31.Text = (orderinfo.Ordersamount).ToString("f2") + "元"; ReceMoney_L.Text = orderinfo.Receivablesamount.ToString("f2") + "元"; //判断订单所处状态 { if (orderinfo.OrderStatus < (int)M_OrderList.StatusEnum.Normal || orderinfo.Aside == 1) { prog_order_div.InnerHtml = OrderHelper.GetOrderStatus(orderinfo.OrderStatus, orderinfo.Aside, orderinfo.StateLogistics); } else { int current = 2; if (orderinfo.OrderStatus >= (int)M_OrderList.StatusEnum.OrderFinish) { current = 5; } else if (orderinfo.Paymentstatus >= (int)M_OrderList.PayEnum.HasPayed) { current++; switch (orderinfo.StateLogistics) { case (int)M_OrderList.ExpEnum.HasSend: current++; break; case (int)M_OrderList.ExpEnum.HasReceived: current += 2; break; } } function.Script(this, "$('#prog_order_div').ZLSteps('订单生成,等待用户支付,等待商户发货,等待用户签收,订单完结'," + current + ")"); } } Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "Main.aspx'>工作台</a></li><li><a href='ProductManage.aspx'>商城管理</a></li><li><a href='OrderList.aspx'>订单管理</a></li><li class='active'><a href='" + Request.RawUrl + "'>订单详情</a></li>"); } }
//确定,生成信息写入ZL_Payment protected void BtnSubmit_Click(object sender, EventArgs e) { int platid = DataConverter.CLng(Request.Form["payplat_rad"]); M_UserInfo mu = buser.GetLogin(false); M_Payment pinfo = new M_Payment(); M_OrderList orderMod = new M_OrderList(); if (!string.IsNullOrEmpty(PayNo))//支付单付款 { pinfo = payBll.SelModelByPayNo(PayNo); if (pinfo.Status != (int)M_Payment.PayStatus.NoPay) { function.WriteErrMsg("该支付单已付款,请勿重复支付"); return; } } else { //传入订单,或直接充值 if (Money > 0)//直接充值 { orderMod.OrderNo = B_OrderList.CreateOrderNo(M_OrderList.OrderEnum.Purse); orderMod.Ordertype = (int)M_OrderList.OrderEnum.Purse;//Purse等充值 orderMod.Userid = mu.UserID; orderMod.Rename = mu.UserName; orderMod.AddUser = mu.UserName; orderMod.Ordersamount = Money; if (orderMod.Ordersamount < 0.01) { function.WriteErrMsg("错误,金额过小"); } orderBll.Add(orderMod); pinfo.PaymentNum = orderMod.OrderNo; pinfo.MoneyPay = orderMod.Ordersamount; pinfo.Remark = "用户充值"; } else { DataTable orderDT = orderBll.GetOrderbyOrderNo(OrderNo); GetTotal(orderDT, ref price, ref fare, ref allamount); if (allamount < 0.01) { function.WriteErrMsg("每次划款金额不能低于0.01元"); } if (orderDT != null && orderDT.Rows.Count > 0) { orderMod = orderBll.GetOrderListByid(DataConverter.CLng(orderDT.Rows[0]["id"])); orderBll.Update(orderMod); } pinfo.PaymentNum = OrderNo; pinfo.MoneyPay = allamount; DataTable cartDT = new DataTable(); if (orderMod.id > 0) { cartDT = bcart.GetCartProOrderID(orderMod.id); pinfo.Remark = cartDT.Rows.Count > 1 ? "[" + cartDT.Rows[0]["ProName"] as string + "]等" : cartDT.Rows[0]["ProName"] as string; } else { pinfo.Remark = "没有对应订单"; } } } pinfo.UserID = mu.UserID; pinfo.PayPlatID = platid; pinfo.MoneyID = 0; pinfo.MoneyReal = pinfo.MoneyPay; //用于支付宝网银 pinfo.PlatformInfo = Request.Form["payplat_rad"]; if (!string.IsNullOrEmpty(PayNo)) { payBll.Update(pinfo); } else { pinfo.Status = (int)M_Payment.PayStatus.NoPay; pinfo.PayNo = payBll.CreatePayNo(); payBll.Add(pinfo); } string url = "PayOnline.aspx?PayNo=" + pinfo.PayNo; if (pinfo.PayPlatID == 0) { url += "&method=" + Request.Form["payplat_rad"]; } Response.Redirect(url); }
//确定,生成信息写入ZL_Payment protected void BtnSubmit_Click(object sender, EventArgs e) { int platid = DataConverter.CLng(Request.Form["payplat_rad"]); M_UserInfo mu = SnsHelper.GetLogin(); M_Payment pinfo = new M_Payment(); M_OrderList orderMod = new M_OrderList(); if (!string.IsNullOrEmpty(PayNo))//支付单付款 { pinfo = payBll.SelModelByPayNo(PayNo); if (pinfo.Status != (int)M_Payment.PayStatus.NoPay) { function.WriteErrMsg("The order has been paid, please do not repeat the payment"); return; } } else { DataTable orderDT = orderBll.GetOrderbyOrderNo(OrderNo); GetTotal(orderDT, ref price, ref fare, ref allamount); if (allamount < 0.01) { function.WriteErrMsg("The amount of the payment should not be less than 0.01 yuan"); } if (orderDT != null && orderDT.Rows.Count > 0) { orderMod = orderBll.GetOrderListByid(DataConverter.CLng(orderDT.Rows[0]["id"])); orderBll.Update(orderMod); } pinfo.PaymentNum = OrderNo; pinfo.MoneyPay = allamount; DataTable cartDT = new DataTable(); if (orderMod.id > 0) { cartDT = bcart.GetCartProOrderID(orderMod.id); pinfo.Remark = cartDT.Rows.Count > 1 ? "[" + cartDT.Rows[0]["ProName"] as string + "]等" : cartDT.Rows[0]["ProName"] as string; } else { pinfo.Remark = "没有对应订单"; } } pinfo.UserID = mu.UserID; pinfo.PayPlatID = platid; pinfo.MoneyID = 0; pinfo.MoneyReal = pinfo.MoneyPay; //用于支付宝网银 pinfo.PlatformInfo = Request.Form["payplat_rad"]; if (!string.IsNullOrEmpty(PayNo)) { payBll.Update(pinfo); } else { pinfo.Status = (int)M_Payment.PayStatus.NoPay; pinfo.PayNo = payBll.CreatePayNo(); payBll.Add(pinfo); } string url = "PayOnline.aspx?PayNo=" + pinfo.PayNo; if (pinfo.PayPlatID == 0) { url += "&method=" + Request.Form["payplat_rad"]; } Response.Redirect(url); }
protected void Page_Load(object sender, EventArgs e) { B_Admin badmin = new B_Admin(); if (!B_ARoleAuth.Check(ZLEnum.Auth.shop, "OrderList")) { function.WriteErrMsg("没有权限进行此项操作"); } if (!IsPostBack) { MyBind(); } Label1.Text = SiteConfig.SiteInfo.SiteName + "[客户签收单]"; if (oll.FondOrder(Mid) == true) { M_OrderList orderinfo = oll.GetOrderListByid(Mid); string OrderNo = orderinfo.OrderNo.ToString(); this.Reuser.Text = orderinfo.Reuser.ToString(); int paymenst = orderinfo.Paymentstatus; int Settles = orderinfo.Settle; this.dingdanID.Text = OrderNo; //订单号 this.addtime.Text = orderinfo.AddTime.ToString(); //订单时间 this.Reusers.Text = orderinfo.Reuser.ToString(); //订货人 this.Jiedao.Text = orderinfo.Shengfen + " " + orderinfo.Jiedao; //联系地址 this.Deliverytime.Text = orderinfo.Deliverytime.ToString(); //送货时间 switch (orderinfo.Deliverytime) { case 1: this.Deliverytime.Text = "对送货时间没有特殊要求"; break; case 2: this.Deliverytime.Text = "双休日或者周一至周五的晚上送达"; break; case 3: this.Deliverytime.Text = "周一至周五的白天送达"; break; default: break; } this.Phone.Text = orderinfo.Phone.ToString(); //联系电话 this.Mobile.Text = orderinfo.MobileNum; //手机 this.Ordermessage.Text = orderinfo.Ordermessage.ToString(); //订货留言 DataTable cplist = cpl.GetCartProOrderID(Mid); DataTable newtable = cplist.DefaultView.ToTable(false, "Shijia", "Pronum"); double allmoney = 0; for (int i = 0; i < newtable.Rows.Count; i++) { allmoney = allmoney + DataConverter.CDouble(cplist.Rows[i]["Allmoney"]); } AllMoney_L.Text = orderinfo.Ordersamount.ToString("f2"); Fare_L.Text = orderinfo.Freight.ToString("f2"); } else { function.WriteErrMsg("找不到购物车信息"); } Call.SetBreadCrumb(Master, "<li>商城管理</li><li><a href='UserOrderinfo.aspx'>店铺订单</a></li><li>订单列表</li>"); }