private void Bind() { if (KeyID != 0) { string sql = "SELECT * FROM [dbo].[CompCollection_view] where CompID=" + this.CompID + " and ID=" + KeyID; DataTable ds = SqlHelper.Query(SqlHelper.LocalSqlServer, sql).Tables[0]; if (ds != null && ds.Rows.Count > 0) { int orderid = Convert.ToInt32(ds.Rows[0]["orderID"]); Hi.Model.DIS_Order orderModel = new Hi.BLL.DIS_Order().GetModel(orderid); this.lblReceiptNo.InnerText = orderModel.ReceiptNo.ToString(); this.lblOState.InnerText = OrderInfoType.OState(orderid); this.lblPayState.InnerText = OrderInfoType.PayState(orderModel.PayState); this.lblTotalPrice.InnerText = orderModel.AuditAmount.ToString("N"); this.lblPayedPrice.InnerText = ds.Rows[0]["Price"].ToString().ToDecimal(0).ToString("N"); this.lblPayAuomet.InnerText = orderModel.PayedAmount.ToString("N"); if (ds.Rows[0]["Date"] != null && ds.Rows[0]["Date"].ToString() != "") { this.lblArriveDate.InnerText = Convert.ToDateTime(ds.Rows[0]["Date"]).ToString("yyyy-MM-dd"); } this.lblDisUser.InnerText = Common.GetUserName(orderModel.DisUserID); this.lblCreateDate.InnerText = Convert.ToDateTime(orderModel.CreateDate).ToString("yyyy-MM-dd"); this.lblPaySource.InnerText = ds.Rows[0]["Source"].ToString(); } } }
/// <summary> /// 查询商品使用的促销方式 by szj 2016-04-13 /// </summary> /// <param name="proID">促销ID</param> public static string ProType(object proID) { string TheLabel = string.Empty; if (proID.ToString() != "") { DataTable dt = new Hi.BLL.BD_Promotion().ProType(proID.ToString()); if (dt != null && dt.Rows.Count > 0) { TheLabel = "<div class=\"sale-box\"><i class=\"sale\">促销</i><div class=\"sale-txt\"><i class=\"arrow\"></i>"; if (dt.Rows[0]["Type"].ToString() == "0") { TheLabel += "特价商品"; } else if (dt.Rows[0]["Type"].ToString() == "1") { if (dt.Rows[0]["Protype"].ToString() == "3") { TheLabel += "满" + OrderInfoType.GetNum(dt.Rows[0]["DisCount"].ToString().ToDecimal(0)) + "件" + ",获赠商品(" + OrderInfoType.GetNum(dt.Rows[0]["GoodsPrice"].ToString().ToDecimal(0)) + ")个"; } else { TheLabel += "在原订货价基础上已打(" + Convert.ToInt32(dt.Rows[0]["DisCount"]) + ")%折"; } } TheLabel += " </div></div>"; } } return(TheLabel); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { KeyID = Common.DesDecrypt(Request["KeyID"], Common.EncryptKey).ToInt(0); databind(); IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0); hidCompID.Value = CompID.ToString(); hidUserType.Value = 4.ToString(); hidPicpath.Value = Common.GetPicBaseUrl(CompID.ToString()); if (!string.IsNullOrEmpty(Request["top"])) { top = Request["top"].ToInt(0); } //if (top == 0) // navigation2.Attributes.Add("href", "orderBuy.aspx"); //else if (top == 2) // navigation2.Attributes.Add("href", "../Order/OrderAuditList.aspx"); //else if (top == 3) // navigation2.Attributes.Add("href", "../Order/OrderShipList.aspx"); //else if (top == 4)//线下付款成功,刷新页面 // ClientScript.RegisterStartupScript(this.GetType(), "payshowTop", "<script>TopShow();</script>"); } }
public string cxtype = "no"; //是否是桌面点最新促销进来 protected void Page_Load(object sender, EventArgs e) { cxtype = Request["cx"];//地址栏是否有传值 if (!IsPostBack) { Common.ListComps(this.ddrComp, this.UserID.ToString(), this.CompID.ToString()); this.hidCompId.Value = this.ddrComp.Value; //厂商id this.hidDisId.Value = this.DisID.ToString(); //代理商id this.hidsDigits.Value = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", this.DisID); //是否取整 this.hidFlie.Value = Common.GetPicBaseUrl(this.ddrComp.Value); //图片路径 this.hidIsInve.Value = OrderInfoType.rdoOrderAudit("商品是否启用库存", this.CompID); //是否启用库存 object sc = Request["sc"]; //收藏商品 if (sc != null) { if (sc.ToString().Trim() == "sc") { this.hidShouc.Value = sc.ToString().Trim(); } } //加入收藏 if (!Common.HasRight(this.CompID, this.UserID, "2111", this.DisID)) { this.iskeep.Value = "1"; } //加入购物车 if (!Common.HasRight(this.CompID, this.UserID, "2112", this.DisID)) { this.isaddCart.Value = "1"; } } }
/// <summary> /// 判断促销 /// </summary> /// <returns></returns> public static string IsCxComp(string proTypes, string proType, string proGoodsPrice, string proDisCount, string unit, int Compid) { string Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", Compid); string str = string.Empty; if (!Util.IsEmpty(proTypes)) { if (proTypes == "0")//特价促销 { str = "特价商品"; } else if (proTypes == "1")//商品促销 { if (proType == "3") { //商品促销满送 str = "满" + decimal.Parse(string.Format("{0:N2}", Convert.ToDecimal(proDisCount).ToString("#,##" + Digits))) + unit + " ,获赠商品(" + decimal.Parse(string.Format("{0:N2}", Convert.ToDecimal(proGoodsPrice).ToString("#,##" + Digits))) + ")" + unit; } else if (proType == "4")//商品促销打折 { str = "在原订货价基础上打" + (Convert.ToDecimal(proDisCount) / 10).ToString("N") + "折"; } } return("<div class=\"sale-box\"><i class=\"sale\">促销</i><div class=\"sale-txt\"><i class=\"arrow\"></i>" + str + "</div></div>"); } else { return(""); } }
private void Bind() { Hi.Model.DIS_Order orderModel = new Hi.BLL.DIS_Order().GetModel(orderid); string sql = string.Empty; if (paymentid > 0) { sql = "SELECT * FROM [dbo].[CompCollection_view] where PreType=" + PreType + " and paymentid=" + paymentid; } DataTable ds = SqlHelper.Query(SqlHelper.LocalSqlServer, sql).Tables[0]; if (ds != null && ds.Rows.Count > 0 && orderModel != null) { this.lblReceiptNo.InnerText = orderModel.ReceiptNo.ToString(); this.lblOState.InnerText = OrderInfoType.OState(orderModel.ID); this.lblPayState.InnerText = OrderInfoType.PayState(orderModel.PayState); this.lblTotalPrice.InnerText = orderModel.AuditAmount.ToString("N"); this.lblPayedPrice.InnerText = ds.Rows[0]["Price"].ToString().ToDecimal(0).ToString("N"); this.lblPayAuomet.InnerText = orderModel.PayedAmount.ToString("N"); this.lblArriveDate.InnerText = Convert.ToDateTime(ds.Rows[0]["Date"]).ToString("yyyy-MM-dd"); this.lblDisUser.InnerText = Common.GetUserName(orderModel.DisUserID); this.lblCreateDate.InnerText = Convert.ToDateTime(orderModel.CreateDate).ToString("yyyy-MM-dd"); this.lblPaySource.InnerText = ds.Rows[0]["Source"].ToString(); ViewState["paymentID"] = ds.Rows[0]["paymentID"].ToString().ToInt(0); } }
/// <summary> /// 非空判断 /// </summary> /// <param name="value"></param> /// <param name="str"></param> /// <param name="index"></param> /// <returns></returns> public string CheckVal(string value, string str, int index) { int IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0);//是否启用库存 if (str == "商品库存") { if (IsInve == 0) { if (Util.IsEmpty(value)) { Eroor = true; throw new ApplicationException("Excel行号为: <i error>" + (index + TitleIndex + 1) + "</i> 的数据有误。" + str + "已启用不能为空!请修改后重新导入。<br/>"); } } } else if (str != "商品编码") { if (Util.IsEmpty(value)) { Eroor = true; throw new ApplicationException("Excel行号为: <i error>" + (index + TitleIndex + 1) + "</i> 的数据有误。" + str + "不能为空!请修改后重新导入。<br/>"); } } return(value); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["CompId"] != null) { CompId = Request["CompId"].ToString().ToInt(0); } if (Request["index"] != null) { this.hidIndex.Value = Request["index"].ToString(); } if (Request["goodsInfoId"] != null) { this.hidgoodsInfoId.Value = Request["goodsInfoId"].ToString(); } if (Request["goodsInfoIdList"] != null) { this.hidgoodsInfoIdList.Value = Request["goodsInfoIdList"].ToString(); } Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", CompId); //IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompId).ToInt(0); //tdIsInve.Visible = IsInve == 0; hidsDigits.Value = Digits; //hidIsInve.Value = IsInve.ToString(); hidCompId.Value = CompId.ToString(); hidDisId.Value = DisID.ToString(); hidImgViewPath.Value = Common.GetPicBaseUrl(CompId.ToString()); //databind(); menu2.InnerHtml = GoodsCategory(CompId); } }
/// <summary> /// 签收 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSing_Click(object sender, EventArgs e) { Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(KeyID); if (OrderModel.OState == (int)Enums.OrderState.已发货 && OrderModel.ReturnState == (int)Enums.ReturnState.未退货) { Hi.Model.DIS_OrderOut OutModel = new Hi.BLL.DIS_OrderOut().GetOutModel(KeyID); OutModel.SignDate = DateTime.Now; OutModel.SignRemark = ""; OutModel.SignUser = Common.GetUserName(this.UserID); OutModel.SignUserId = this.UserID; OutModel.IsSign = 1; OutModel.ts = DateTime.Now; OutModel.modifyuser = this.UserID; if (OrderInfoType.SignOrder(OutModel, OrderModel) > 0) { Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "订单签收", ""); new Common().GetWxService("3", KeyID.ToString(), "1"); if (!string.IsNullOrEmpty(Request["type1"]) && Request["type1"].ToString() == "ReceivingList") { Response.Redirect("receivinglist.aspx"); } Response.Redirect("neworder/orderdetail.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey)); //Bind(); } } }
/// <summary> /// 签收 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void btnSing_Click(int KeyID) { Hi.BLL.DIS_Order OrderBll = new Hi.BLL.DIS_Order(); Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(KeyID); if (OrderModel.OState == (int)Enums.OrderState.已发货 && OrderModel.ReturnState == (int)Enums.ReturnState.未退货) { Hi.Model.DIS_OrderOut OutModel = new Hi.BLL.DIS_OrderOut().GetOutModel(KeyID); OutModel.SignDate = DateTime.Now; OutModel.SignRemark = ""; OutModel.SignUser = this.UserName; OutModel.SignUserId = this.UserID; OutModel.IsSign = 1; OutModel.ts = DateTime.Now; OutModel.modifyuser = this.UserID; if (OrderInfoType.SignOrder(OutModel, OrderModel) > 0) { Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "订单签收", ""); new Common().GetWxService("3", KeyID.ToString(), "1"); string str = "\"str\":true"; str = "{" + str + "}"; Response.Write(str); Response.End(); //Bind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0); Bind(); } }
protected void Page_Load(object sender, EventArgs e) { //ClientScript.RegisterStartupScript(this.GetType(), "msg", "<script>$(\".txt_product_class\").css(\"width\", \"140px\"); $(\".txt_product_class\").attr(\"class\",\"box txt_product_class\")</script>"); if (!IsPostBack) { IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0); this.txtPager.Value = "12"; Bind(); } }
public int Fanli = 0; //是否启用返利 protected void Page_Load(object sender, EventArgs e) { object obj = Request["action"]; if (obj != null) { if (obj.ToString() == "dislist") { string compid = Request["compId"] + ""; string disid = Request["disId"] + ""; Response.Write(disBing(compid, disid)); Response.End(); } } if (!IsPostBack) { DataTable dt = Common.BindDisList(this.CompID.ToString());//代理商绑定 if (dt != null) { this.rptDisList.DataSource = dt; this.rptDisList.DataBind(); } this.hidType2.Value = Request.QueryString["type"] + "";//2 再次购买 this.hidKeyId.Value = KeyID.ToString(); this.hidCompId.Value = this.CompID.ToString(); Fanli = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", CompID).ToInt(0); this.hidFanl.Value = Fanli.ToString(); //是否启用返利 IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0); //是否启用库存 //代理商列表 List <Hi.Model.BD_Distributor> list = new Hi.BLL.BD_Distributor().GetList("ID,DisName", "isnull(dr,0)=0 and compid=" + this.CompID, ""); this.divDisList.InnerText = ConvertJson.ToJson(Common.FillDataTable(list)); if (KeyID != 0) { if (Request.QueryString["type"] + "" != "2") { Hi.Model.DIS_Order model = new Hi.BLL.DIS_Order().GetModel(KeyID); //判断订单是否可以修改 企业下单订单已审未支付,代理商下单企业不能修改 if (model.OState > (int)Enums.OrderState.待审核) { JScript.AlertAndRedirect("订单已被其他人修改,请刷新后再重新操作!", "orderdetail.aspx?top=1&KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey)); return; } } else { this.hidType.Value = Request.QueryString["type"] + ""; } Bind(); } } }
protected void Page_Load(object sender, EventArgs e) { Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", CompID); ClientScript.RegisterStartupScript(this.GetType(), "msg", "<script>$(\".txt_product_class\").css(\"width\", \"150px\");</script>"); if (!IsPostBack) { this.txtPager.Value = Common.PageSize; this.txtBCreateDate.Value = DateTime.Now.AddDays(1 - DateTime.Now.Day).ToString("yyyy-MM-dd"); this.txtECreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); ViewState["strwhere"] = Where(); Bind(); } }
/// <summary> /// 购物车商品 /// </summary> public void ShopCart() { DataTable dt = new Hi.BLL.DIS_ShopCart().GetGoodsCart(" sc.[CompID]=" + this.CompID + " and sc.[DisID]=" + this.DisID + "and sc.dr=0", "sc.[CreateDate] desc "); if (dt != null && dt.Rows.Count > 0) { decimal TotalAmount = 0; string html = string.Empty; string Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", this.CompID); //小数位数 string str6 = IsInve == 0 ? "" : "display:none"; for (int i = 0; i < dt.Rows.Count; i++) { int goodsinfoid = Convert.ToInt32(dt.Rows[i]["GoodsinfoID"].ToString()); Hi.Model.BD_GoodsInfo model3 = new Hi.BLL.BD_GoodsInfo().GetModel(goodsinfoid); Hi.Model.BD_Goods model4 = new Hi.BLL.BD_Goods().GetModel(model3.GoodsID); string pic = dt.Rows[i]["pic"].ToString(); // new Hi.BLL.BD_Goods().GetModel(Convert.ToInt32(model2.GoodsID)).Pic; string inventory = string.Empty; BLL.Common.GetInevntory(this.CompID, goodsinfoid, 0, Convert.ToDecimal(dt.Rows[i]["GoodsNum"]), out inventory); // dt.Rows[i]["Inventory"].ToString(); string str7 = string.Empty; //是否促销 if (dt.Rows[i]["ProID"].ToString() != "0") { str7 = SelectGoodsInfo.protitle(dt.Rows[i]["ProID"].ToString(), dt.Rows[i]["Unit"].ToString()); } string strremark = string.Empty; decimal zxprice = BLL.Common.GetGoodsPrice(this.CompID, this.DisID, goodsinfoid);//最新价格 decimal num = decimal.Parse(string.Format("{0:N4}", Convert.ToDecimal(dt.Rows[i]["GoodsNum"]).ToString("#,####" + Digits))); TotalAmount += zxprice * num; html += "<tr tip=\"" + goodsinfoid + "\" trindex=\"" + i + "\" trindex2=\"" + i + "\" id=\"\"><td class=\"t8\"><div class=\"addg\"><a href=\"javascript:;\" class=\"minus2\"></a><a href=\"javascript:;\" class=\"add2\"></a></div></td><td><div class=\"sPic\"><a class=\"opt-i2\"></a><span><a href=\"javascript:;\"><img src=\"" + Common.GetPicURL(pic, "resize200") + "\" width=\"60\" height=\"60\"></a></span><a href=\"javascript:;\" class=\"code\">商品编码:" + dt.Rows[i]["barCode"].ToString() + str7 + "</a><a href=\"javascript:;\" class=\"name\">" + GetGoodsName(model4.GoodsName, model3.ValueInfo, "1") + "<i>" + GetGoodsName(model4.GoodsName, model3.ValueInfo, "2") + "</i></a></div></td><td><div class=\"tc\">" + model4.Unit + "</div></td><td><div class=\"tc divprice" + i + "\" tip=\"" + decimal.Parse(string.Format("{0:N2}", zxprice)).ToString("0.00") + "\">¥" + decimal.Parse(string.Format("{0:N2}", zxprice)).ToString("0.00") + "</div><input type=\"hidden\" class=\"hidPrice\" value=\"" + zxprice + "\" /></td><td style=\"" + str6 + "\"><div class=\"tc\"><input type=\"hidden\" id=\"hidInventory_" + i + "\" value=\"" + decimal.Parse(string.Format("{0:N2}", inventory)).ToString(Digits) + "\" />" + decimal.Parse(string.Format("{0:N2}", inventory)).ToString(Digits) + "</div></td><td><div class=\"sl divnum\" tip=\"" + dt.Rows[i]["GoodsinfoID"].ToString() + "\" tip2=\"" + i + "\"><a href=\"javascript:void(0);\" class=\"minus\">-</a><input type=\"text\" class=\"box txtGoodsNum txtGoodsNum" + i + "\" onfocus=\"InputFocus(this)\" onkeyup='KeyInt2(this)' maxlength=\"9\" value=\"" + num + "\"><a href=\"javascript:void(0);\" class=\"add\">+</a></div></td><td><div class=\"tc lblTotal_" + i + "\">¥" + decimal.Parse(string.Format("{0:N2}", zxprice * num)).ToString("0.00") + "</div></td><td><div class=\"tc alink\"><a href=\"javascript:;\" class=\"aremark" + i + "\">添加</a>" + strremark + "</div></td></tr>"; } //查询购物车商品数量、总价 // DataTable dtp = new Hi.BLL.DIS_ShopCart().SumCartNum(this.CompID.ToString(), this.DisID.ToString()); // if (dtp != null && dtp.Rows.Count > 0) //{ //TotalAmount = (dtp.Rows[0]["SumAmount"].ToString().ToDecimal(0)); //订单总价 this.lblTotalAmount.InnerText = decimal.Parse(string.Format("{0:N2}", TotalAmount.ToString())).ToString("0.00");//商品总额 //订单促销 decimal ProAmount = Common.GetProPrice(TotalAmount, out ProID, out ProIDD, out ProType, this.CompID); this.lblCux.InnerText = decimal.Parse(string.Format("{0:N2}", ProAmount.ToString())).ToString("0.00"); //合计 string str8 = (TotalAmount - ProAmount).ToString("N"); ClientScript.RegisterStartupScript(this.GetType(), "adder", "<script>$(function(){disId=" + this.DisID + "; $(\".tabLine table tbody tr:last\").before(\"" + html.Replace("\"", "'") + "\");$(\"#lblYFPrice\").text(\"" + str8 + "\")})</script>"); // } } else { Response.Redirect("/Distributor/Shop.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { this.ddrComp.Attributes.Add("onchange", base.Page.GetPostBackEventReference(this.ddrComp)); if (!IsPostBack) { IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0); this.hidIsInve.Value = IsInve.ToString(); //小数位数 this.hidsDigits.Value = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", this.CompID); Common.ListComps(this.ddrComp, this.UserID.ToString(), this.CompID.ToString()); databind(); ToTalPrice2();//购物车总价 } }
protected void Page_Load(object sender, EventArgs e) { Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", this.CompID); dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID); if (!IsPostBack) { this.txtPager.Value = "12"; this.txtArriveDate.Value = DateTime.Now.AddDays(1 - DateTime.Now.Day).ToString("yyyy-MM-dd"); this.txtArriveDate1.Value = DateTime.Now.ToString("yyyy-MM-dd"); Common.ListComps(this.ddrComp, this.UserID.ToString(), this.CompID.ToString()); ViewState["strwhere"] = Where(); Bind(); } }
/// <summary> /// 代理商选择商品 /// </summary> /// <returns></returns> public string disBing(string compid, string disid) { StringBuilder strwhere = new StringBuilder(); //商品是否启用库存 IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", compid.ToInt(0)).ToInt(0); if (IsInve == 0) { strwhere.AppendFormat("and info.Inventory>0"); } DataTable dt = SqlHelper.Query(SqlHelper.LocalSqlServer, SelectGoodsInfo.Returnsql(compid, disid, strwhere.ToString(), "2")).Tables[0]; List <int> infoidl = new List <int>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { int id = item["ID"].ToString().ToInt(0);//BD_goodsInfo表的ID infoidl.Add(id); } } //获取商品价格 List <BLL.gDprice> l = BLL.Common.GetPrice(Convert.ToInt32(compid), Convert.ToInt32(disid), infoidl); if (l != null && l.Count > 0) { foreach (var item in l) { DataRow[] dr = dt.Select(" ID=" + item.goodsInfoId); if (dr.Length > 0) { //获取的价格大于促销价时、取促销价 dr[0]["pr"] = item.FinalPrice; dr[0]["typeTinkerPrice"] = item.typePrice; dr[0]["disTinkerPrice"] = item.disPrice; dr[0]["disProPr"] = item.bpPrice; } } } return(ConvertJson.ToJson2(dt)); }
/// <summary> /// 绑定数据 /// </summary> public void Bind() { if (KeyID != 0) { if (!Common.PageCompOperable("Order", KeyID, CompID)) { Response.Redirect("../../NoOperable.aspx"); return; } Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(KeyID); if (OrderModel != null) { DisID = OrderModel.DisID; this.PrintDate.InnerText = DateTime.Now.ToString("yyyy年MM月dd日"); this.lblReceiptNo.InnerText = OrderModel.ReceiptNo; this.lblDisName.InnerText = Common.GetDis(OrderModel.DisID, "DisName"); this.lblCreateDate.InnerText = OrderModel.CreateDate == DateTime.MinValue ? "" : OrderModel.CreateDate.ToString("yyyy-MM-dd"); this.lblDisUser.InnerText = Common.GetUserName(OrderModel.DisUserID); this.lblOtype.InnerText = OrderInfoType.OType(OrderModel.Otype); this.lblTotalPrice.InnerText = OrderModel.AuditAmount.ToString("N"); this.lblPayState.InnerText = OrderInfoType.PayState(OrderModel.PayState); this.lblPayPrice.InnerText = OrderModel.PayedAmount.ToString("N"); if (OrderModel.PayState == (int)Enums.PayState.未支付) { this.lblPayState.Attributes.Add("style", "Color:Red"); } else { this.lblPayState.Attributes.Add("style", "Color:green"); } this.lblAddr.InnerText = Common.GetAddr(OrderModel.AddrID); this.lblRemark.InnerText = OrderModel.Remark; BindOrderDetail(DisID); } } }
/// <summary> /// 获取商品编码 /// </summary> /// <returns></returns> public string GetGoodsCode(string values) { Hi.Model.BD_Goods goodsModel = new Hi.BLL.BD_Goods().GetModel(goodsId); DataTable dt = Session["price"] as DataTable; string isInv = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", this.DisID); //是否取整 if (dt.Rows.Count != 0) { if (dt.Select("isnull(valueinfo,'')='" + values + "'").Length != 0) { for (int i = 0; i < dt.Select("isnull(valueinfo,'')='" + values + "'").Length; i++) { return(dt.Select("isnull(valueinfo,'')='" + values + "'")[i]["barcode"].ToString() + "," + decimal.Parse(string.Format("{0:N2}", dt.Select("isnull(valueinfo,'')='" + values + "'")[i]["inventory"].ToString())).ToString(isInv)); } } } return(""); }
/// <summary> /// 绑定 /// </summary> public void Bind() { if (KeyID != 0) { Hi.Model.DIS_OrderOut OrderOutModel = OrderOutBll.GetModel(KeyID); if (OrderOutModel != null) { OrderId = OrderOutModel.OrderID; this.lblReceiptNo.InnerText = OrderOutModel.ReceiptNo; this.lblOrderNo.InnerText = OrderInfoType.getOrder(OrderOutModel.OrderID, "ReceiptNo"); DisID = OrderOutModel.DisID; ProID = OrderInfoType.getOrderExt(OrderOutModel.OrderID, "ProID"); ProPrice = OrderInfoType.getOrderExt(OrderOutModel.OrderID, "ProAmount"); ProIDD = OrderInfoType.getOrderExt(OrderOutModel.OrderID, "ProDID"); ProType = OrderInfoType.getOrderExt(OrderOutModel.OrderID, "Protype"); this.lblDisName.InnerText = Common.GetDis(OrderOutModel.DisID, "DisName"); this.hidDisId.Value = OrderOutModel.DisID.ToString(); this.lblSendDate.InnerText = OrderOutModel.SendDate == DateTime.MinValue ? "" : OrderOutModel.SendDate.ToString("yyyy-MM-dd"); //this.lblExpress.InnerText = OrderOutModel.Express; //this.lblExpressNo.InnerText = OrderOutModel.ExpressNo; //this.lblExpressPerson.InnerText = OrderOutModel.ExpressPerson; //this.lblExpressTel.InnerText = OrderOutModel.ExpressTel; //this.lblExpressBao.InnerText = OrderOutModel.ExpressBao.ToString(); //this.lblPostFee.InnerText = OrderOutModel.PostFee.ToString("N"); this.lblActionUser.InnerText = OrderOutModel.ActionUser; this.lblRemark.InnerText = OrderOutModel.Remark; //签收信息 this.lblIsSign.InnerText = OrderOutModel.IsSign == 0 ? "未签收" : "已签收"; this.lblSignUser.InnerText = OrderOutModel.SignUser; this.hidSignUserId.Value = OrderOutModel.SignUserId.ToString(); this.lblSignDate.InnerText = OrderOutModel.SignDate == DateTime.MinValue ? "" : OrderOutModel.SignDate.ToString("yyyy-MM-dd"); this.lblSignRemark.InnerText = OrderOutModel.SignRemark; BindOrderDetail(OrderOutModel.OrderID, OrderOutModel.DisID); } } }
/// <summary> /// 非空判断 /// </summary> /// <param name="value"></param> /// <param name="str"></param> /// <param name="index"></param> /// <returns></returns> public string CheckVal(string value, string str, DataRow dr) { int IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0);//是否启用库存 if (str == "商品库存") { if (IsInve == 0) { if (string.IsNullOrWhiteSpace(value)) { dr["chkstr"] += "<br>" + str + "已启用不能为空!"; } } } else if (str == "商品名称") { if (string.IsNullOrWhiteSpace(value)) { dr["chkstr"] += "<br>" + str + "不能为空!"; } } else if (str == "计量单位") { if (string.IsNullOrWhiteSpace(value)) { dr["chkstr"] += "<br>" + str + "不能为空!"; } } else if (str == "价格") { if (string.IsNullOrWhiteSpace(value)) { dr["chkstr"] += "<br>" + str + "不能为空!"; } } return(value); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { IsShow = OrderInfoType.rdoOrderAudit("订单明细是否显示店铺商品", 0).ToInt(0); IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0); hidCompID.Value = CompID.ToString(); hidUserType.Value = this.TypeID.ToString(); hidPicpath.Value = Common.GetWebConfigKey("OssImgPath") + "company/" + CompID + "/"; if (!string.IsNullOrEmpty(Request["top"])) { top = Request["top"].ToInt(0); } if (top == 0) { navigation2.Attributes.Add("href", "orderBuy.aspx"); } else if (top == 2) { navigation2.Attributes.Add("href", "../Order/OrderAuditList.aspx"); } else if (top == 3) { navigation2.Attributes.Add("href", "../Order/OrderShipList.aspx"); } else if (top == 4)//线下付款成功,刷新页面 { ClientScript.RegisterStartupScript(this.GetType(), "payshowTop", "<script>TopShow();</script>"); } databind(); } }
public void databind() { if (!string.IsNullOrEmpty(Request["KeyID"])) { KeyID = Common.DesDecrypt((Request["KeyID"] + ""), Common.EncryptKey).ToInt(0); } if (!string.IsNullOrEmpty(Request["DisID"])) { DisID = (Request["DisID"] + "").ToInt(0); } string where = "and isnull(o.dr,0)=0 and o.otype<>9 and o.DisID=" + DisID + " and o.ID= " + KeyID; DataTable dt = new Hi.BLL.DIS_Order().GetList("", where); if (dt != null && dt.Rows.Count > 0) { //this.Literal1.Text= barcode.get39(dt.Rows[0]["ReceiptNo"].ToString(), 1, 40); Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", dt.Rows[0]["CompID"].ToString().ToInt(0)); // 订单编号 lblReceiptNo.InnerText = dt.Rows[0]["ReceiptNo"].ToString(); codeno = dt.Rows[0]["ReceiptNo"].ToString(); this.Image1.ImageUrl = "~/Distributor/newOrder/Code39.aspx?KeyID=" + codeno; lblCreateDate.InnerText = dt.Rows[0]["CreateDate"].ToString().ToDateTime().ToString("yyyy-MM-dd"); lblArrDate.InnerText = dt.Rows[0]["ArriveDate"].ToString() == "" ? "" : dt.Rows[0]["ArriveDate"].ToString().ToDateTime().ToString("yyyy-MM-dd"); //订单流程 lblTotalAmount.InnerText = dt.Rows[0]["TotalAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["TotalAmount"].ToString().ToDecimal().ToString("0.00"); lblProAmount.InnerText = dt.Rows[0]["ProAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["ProAmount"].ToString().ToDecimal().ToString("0.00"); lblbateAmount.InnerText = dt.Rows[0]["bateAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["bateAmount"].ToString().ToDecimal().ToString("0.00"); lblPostFee.InnerText = dt.Rows[0]["PostFee"].ToString() == "" ? "0.00" : dt.Rows[0]["PostFee"].ToString().ToDecimal().ToString("0.00"); lblAuditAmount.InnerText = dt.Rows[0]["AuditAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["AuditAmount"].ToString().ToDecimal().ToString("0.00"); //代理商 if (Common.TypeID() == 1 || Common.TypeID() == 5) { name.InnerText = "厂商:"; lblDisName.InnerText = Common.Getcom(dt.Rows[0]["CompID"].ToString().ToInt(), "CompName"); } else { name.InnerText = "代理商:"; lblDisName.InnerText = Common.GetDis(dt.Rows[0]["DisID"].ToString().ToInt(0), "DisName"); } //下单信息 //lblArriveDate.InnerText = dt.Rows[0]["ArriveDate"].ToString().ToDateTime() == DateTime.MinValue ? "" : dt.Rows[0]["ArriveDate"].ToString().ToDateTime().ToString("yyyy-MM-dd"); lblGiveMode.InnerText = dt.Rows[0]["GiveMode"].ToString(); iRemark.InnerText = dt.Rows[0]["Remark"].ToString(); if (dt.Rows[0]["AddrID"].ToString() != "") { //收货地址 lblPrincipal.InnerText = dt.Rows[0]["Principal"].ToString(); lblPhone.InnerText = dt.Rows[0]["Phone"].ToString(); lblAddress.InnerText = dt.Rows[0]["Address"].ToString(); } else { iaddr.InnerText = "无"; } //开票信息 //if (dt.Rows[0]["IsOBill"].ToString().ToInt(0) != 1) //{ // lblRise.InnerText = dt.Rows[0]["Rise"].ToString(); // lblContent.InnerText = dt.Rows[0]["Content"].ToString(); // lblOBank.InnerText = dt.Rows[0]["OBank"].ToString(); // lblOAccount.InnerText = dt.Rows[0]["OAccount"].ToString(); // lblTRNumber.InnerText = dt.Rows[0]["TRNumber"].ToString(); //} //else // this.iInvoice.InnerHtml = "不开发票"; //发票信息 //lblBillNo.InnerText = dt.Rows[0]["BillNo"].ToString(); //lblIsBill.InnerText = dt.Rows[0]["IsBill"].ToString() == "1" ? "是" : "否"; //订单所有商品明细 DataTable l = new Hi.BLL.DIS_OrderDetail().GetOrderDe("", " IsNUll(o.dr,0)=0 and o.OrderId=" + KeyID); if (l != null && l.Rows.Count > 0) { rptOrderD.DataSource = l; rptOrderD.DataBind(); } } }
//public Hi.Model.SYS_Users user = null; //public int KeyID = 0; //public int CompID = 0; protected void Page_Load(object sender, EventArgs e) { //user = LoginModel.IsLogined(this); //if (Request["KeyID"] != null) //{ // string Id = Common.DesDecrypt(Request["KeyID"].ToString(), Common.EncryptKey); // KeyID = Id.ToInt(0); // CompID = user.CompID; //} if (KeyID != 0) { //user = LoginModel.IsLogined(this); //if (user != null) //{ if (KeyID != 0) { if (!Common.PageDisOperable("Order", KeyID, this.DisID)) { Response.Redirect("../NoOperable.aspx"); return; } order = new Hi.BLL.DIS_Order().GetModel(KeyID); orderreturn = new Hi.BLL.DIS_OrderReturn().GetModel(order.ID.ToString()); if (orderreturn == null) { Response.Redirect("OrderList.aspx"); } ReceiptNo = orderreturn.ReceiptNo; ProID = OrderInfoType.getOrderExt(orderreturn.OrderID, "ProID"); ProPrice = OrderInfoType.getOrderExt(orderreturn.OrderID, "ProAmount"); ProIDD = OrderInfoType.getOrderExt(orderreturn.OrderID, "ProDID"); ProType = OrderInfoType.getOrderExt(orderreturn.OrderID, "Protype"); this.lblTotalPrice.InnerText = order.AuditAmount.ToString("N"); Hi.Model.SYS_Users disuser = new Hi.BLL.SYS_Users().GetModel(orderreturn.AuditUserID); switch (orderreturn.ReturnState) { case -1: ReturnState = "已拒绝"; AuditUserName = disuser == null ? "" : disuser.TrueName; AuditDate = orderreturn.AuditDate.ToString("yyyy-MM-dd"); AuditRemark = orderreturn.AuditRemark; A_btn.InnerHtml = "<a href=\"#\" onclick=\"returnLog();\" class=\"btnBl\"><i class=\"dailyIcon\"></i>日志</a><a href=\"returnorderlist.aspx\" class=\"btnBl\"><i class=\"returnIcon\"></i>返回</a>"; //增加修改,取消退货按钮代码,把后面一截拷进去就OK了 <a href=\"returnorderadd.aspx?KeyID="+KeyID+"&type=update\" class=\"btnBl\"><i class=\"editIcon\"></i>修改退货单</a><a href=\"#\" onclick=\"offIcon();\" class=\"btnBl\"><i class=\"offIcon\"></i>取消退货单</a> break; case 0: ReturnState = "未提交"; A_btn.InnerHtml = "<a href=\"#\" onclick=\"editIcon();\" class=\"btnOr\"><i class=\"editIcon\"></i>提交退货单</a><a href=\"#\" onclick=\"offIcon();\" class=\"btnBl\"><i class=\"offIcon\"></i>取消退货单</a><a href=\"#\" onclick=\"returnLog();\" class=\"btnBl\"><i class=\"dailyIcon\"></i>日志</a><a href=\"#\" onclick=\"areturn()\" class=\"btnBl\"><i class=\"returnIcon\"></i>返回</a>"; break; case 1: ReturnState = "待审核"; A_btn.InnerHtml = "<a href=\"#\" onclick=\"returnLog();\" class=\"btnBl\"><i class=\"dailyIcon\"></i>日志</a><a href=\"ReturnOrderList.aspx\" class=\"btnBl\"><i class=\"returnIcon\"></i>返回</a>"; break; case 2: ReturnState = "已退货"; AuditUserName = disuser == null ? "" : disuser.TrueName; AuditDate = orderreturn.AuditDate.ToString("yyyy-MM-dd"); AuditRemark = orderreturn.AuditRemark; A_btn.InnerHtml = "<a href=\"#\" onclick=\"returnLog();\" class=\"btnBl\"><i class=\"dailyIcon\"></i>日志</a><a href=\"ReturnOrderList.aspx\" class=\"btnBl\"><i class=\"returnIcon\"></i>返回</a>"; break; case 4: ReturnState = "已退货款"; AuditUserName = disuser == null ? "" : disuser.TrueName; AuditDate = orderreturn.AuditDate.ToString("yyyy-MM-dd"); AuditRemark = orderreturn.AuditRemark; A_btn.InnerHtml = "<a href=\"#\" onclick=\"returnLog();\" class=\"btnBl\"><i class=\"dailyIcon\"></i>日志</a><a href=\"ReturnOrderList.aspx\" class=\"btnBl\"><i class=\"returnIcon\"></i>返回</a>"; break; } CreateDate = orderreturn.CreateDate.ToString("yyyy-MM-dd"); ReturnContent = orderreturn.ReturnContent; BindGoods(); } else { Response.Redirect("orderlist.aspx"); } } if (!string.IsNullOrEmpty(Request["OffIcon"]) && Request["OffIcon"].ToString() == "true") { A_OffIcon(null, null); } if (!string.IsNullOrEmpty(Request["editIcon"]) && Request["editIcon"].ToString() == "true") { A_EditIcon(null, null); } //} }
//public void BindGoods() //{ // SelectGoods.Clear(this.CompID); // SelectGoods.OrderDetail(KeyID, DisID, this.CompID); // DataTable dt = Session["GoodsInfo"] as DataTable; // if (dt != null) // { // this.rpDtl.DataSource = dt; // this.rpDtl.DataBind(); // } // else // { // this.rpDtl.DataSource = ""; // this.rpDtl.DataBind(); // } // SelectGoods.Clear(DisID, this.CompID); //} //protected void A_AddOrderReturn(object sender, EventArgs e) //{ // if (order != null) // { // if (!string.IsNullOrEmpty(txtremark.Value.Trim())) // { // if (string.IsNullOrEmpty(Request.QueryString["type"])) // { // Hi.Model.DIS_OrderReturn orderreturn = new Hi.Model.DIS_OrderReturn(); // Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetDisID(user.UserName); // orderreturn.CompID = dis.CompID; // orderreturn.DisID = dis.ID; // orderreturn.OrderID = order.ID; // orderreturn.CreateDate = DateTime.Now; // orderreturn.CreateUserID = user.ID; // orderreturn.ReturnContent = txtremark.Value; // orderreturn.ReturnState = (int)Enums.AuditState.未提交; // orderreturn.ts = DateTime.Now; // orderreturn.modifyuser = user.ID; // int orderreturnid = OrderInfoType.ReturnOrderAdd(orderreturn, order.ID); // if (orderreturnid > 0) // { // Utils.AddSysBusinessLog(this.CompID, "Order", order.ID.ToString(), "申请退货", ""); // Response.Redirect("returnorderinfo.aspx?KeyID=" + order.ID); // } // else // { // JScript.AlertMsg(this, "退货失败,请稍候再试"); // } // } // else if (Request.QueryString["type"].ToString() == "update") // { // Hi.Model.DIS_OrderReturn orderreturn = new Hi.BLL.DIS_OrderReturn().GetModel(KeyID.ToString()); // Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetDisID(user.UserName); // orderreturn.CompID = dis.CompID; // orderreturn.DisID = dis.ID; // orderreturn.OrderID = order.ID; // orderreturn.CreateDate = DateTime.Now; // orderreturn.CreateUserID = user.ID; // orderreturn.ReturnContent = txtremark.Value; // orderreturn.ReturnState = (int)Enums.AuditState.未提交; // orderreturn.ts = DateTime.Now; // orderreturn.modifyuser = user.ID; // if (new Hi.BLL.DIS_OrderReturn().Update(orderreturn)) // { // Response.Redirect("returnorderinfo.aspx?KeyID=" + order.ID); // } // } // } // else // { // JScript.AlertMsg(this, "请注明退货原因"); // } // } //} //public int GetGoodsID(string goodsinfoid) //{ // Hi.Model.BD_GoodsInfo goodsinfo = new Hi.BLL.BD_GoodsInfo().GetModel(int.Parse(goodsinfoid)); // return goodsinfo.GoodsID; //} protected void A_AddOrderReturn(object sender, EventArgs e) { Hi.Model.DIS_Order order = OrderBll.GetModel(KeyID); if (order != null) { if (order.OState == (int)Enums.OrderState.已到货 && (order.ReturnState == (int)Enums.ReturnState.未退货 || order.ReturnState == (int)Enums.ReturnState.拒绝退货)) { if (string.IsNullOrEmpty(Request.QueryString["type"])) { Hi.Model.DIS_OrderReturn orderreturn = new Hi.Model.DIS_OrderReturn(); //Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID); orderreturn.ReceiptNo = order.ReceiptNo + SysCode.GetCode("退单", order.ID.ToString()); orderreturn.CompID = this.CompID; orderreturn.DisID = this.DisID; orderreturn.OrderID = order.ID; orderreturn.ReturnDate = DateTime.Now; orderreturn.CreateDate = DateTime.Now; orderreturn.CreateUserID = this.UserID; orderreturn.ReturnContent = Common.NoHTML(txtremark.Value); orderreturn.ReturnState = (int)Enums.AuditState.提交; orderreturn.ts = DateTime.Now; orderreturn.modifyuser = this.UserID; int orderreturnid = OrderInfoType.ReturnOrderAdd(orderreturn, order.ID); if (orderreturnid > 0) { order.ts = DateTime.Now; order.ReturnState = (int)Enums.ReturnState.申请退货; order.ReturnMoneyDate = DateTime.Now; order.ReturnMoneyUser = this.UserName; order.ReturnMoneyUserId = this.UserID; if (new Hi.BLL.DIS_Order().Update(order)) { //Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "订单修改", orderreturn.ReturnContent); ClientScript.RegisterStartupScript(GetType(), "msg", "<script>window.parent.ResurnOrder();</script>"); } } else { JScript.AlertMsgOne(this, "退货失败,请稍候再试!", JScript.IconOption.哭脸); } } else if (Request.QueryString["type"].ToString() == "update") { Hi.Model.DIS_OrderReturn orderreturn = new Hi.BLL.DIS_OrderReturn().GetModel(KeyID.ToString()); Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(DisID); orderreturn.CompID = dis.CompID; orderreturn.DisID = dis.ID; orderreturn.OrderID = order.ID; orderreturn.CreateDate = DateTime.Now; orderreturn.CreateUserID = this.UserID; orderreturn.ReturnContent = Common.NoHTML(txtremark.Value); orderreturn.ReturnState = (int)Enums.AuditState.未提交; orderreturn.ts = DateTime.Now; orderreturn.modifyuser = this.UserID; if (new Hi.BLL.DIS_OrderReturn().Update(orderreturn)) { Response.Redirect("returnorderinfo.aspx?KeyID=" + Common.DesEncrypt(order.ID.ToString(), Common.EncryptKey)); } } } else { JScript.AlertMsgOne(this, "订单处理中,不能申请退货!", JScript.IconOption.哭脸); } } }
/// <summary> /// 订单信息 /// </summary> public void databind() { if (KeyID != 0) { //判断改该条数据代理商是否有操作权限 if (!Common.PageDisOperable("Order", KeyID, DisID)) { Response.Redirect("../NoOperable.aspx"); return; } hidOrderID.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey); string where = "and isnull(o.dr,0)=0 and o.otype<>9 and o.DisID=" + DisID + " and o.ID= " + KeyID; DataTable dt = new Hi.BLL.DIS_Order().GetList("", where); if (dt != null && dt.Rows.Count > 0) { //再次购买 buyagain.Visible = false; //订单修改 modifyorder.Visible = false; //订单作废 ordervoid.Visible = false; //申请退货 //orderReturn.Visible = false; Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", dt.Rows[0]["CompID"].ToString().ToInt(0)); IsShow = OrderInfoType.rdoOrderAudit("订单明细是否显示店铺商品", 0).ToInt(0); IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", dt.Rows[0]["CompID"].ToString().ToInt(0)).ToInt(0); hidDigits.Value = Digits; isbate = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", dt.Rows[0]["CompID"].ToString().ToInt(0)).ToInt(0); if (isbate == 0) { if (dt.Rows[0]["bateAmount"].ToString() == "" || dt.Rows[0]["bateAmount"].ToString() == "0.00") { this.trbate.Visible = false; this.rebate.Visible = false; } } // 订单编号 lblReceiptNo.InnerText = dt.Rows[0]["ReceiptNo"].ToString(); lblCreateDate.InnerText = dt.Rows[0]["CreateDate"].ToString().ToDateTime().ToString("yyyy-MM-dd"); lblOstate.InnerText = OrderType.GetOState(dt.Rows[0]["OState"].ToString(), dt.Rows[0]["IsOutState"].ToString()); hidOstate.Value = dt.Rows[0]["OState"].ToString(); lblCompID.InnerText = Common.Getcom(dt.Rows[0]["CompID"].ToString().ToInt(0), "CompName"); orderCompId = Convert.ToString(dt.Rows[0]["CompID"]); hidIsOutstate.Value = dt.Rows[0]["IsOutState"].ToString(); OState = dt.Rows[0]["OState"].ToString().ToInt(0); IsOutState = dt.Rows[0]["IsOutState"].ToString().ToInt(0); payState = dt.Rows[0]["PayState"].ToString().ToInt(0); ReturnState = dt.Rows[0]["ReturnState"].ToString().ToInt(0); hidDts.Value = dt.Rows[0]["ts"].ToString(); //订单流程 lblTotalAmount.InnerText = dt.Rows[0]["TotalAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["TotalAmount"].ToString().ToDecimal().ToString("N"); lblProAmount.InnerText = dt.Rows[0]["ProAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["ProAmount"].ToString().ToDecimal().ToString("N"); lblbateAmount.InnerText = dt.Rows[0]["bateAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["bateAmount"].ToString().ToDecimal().ToString("N"); lblbate.InnerText = dt.Rows[0]["bateAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["bateAmount"].ToString().ToDecimal().ToString("N"); lblPostFee.InnerText = dt.Rows[0]["PostFee"].ToString() == "" ? "0.00" : dt.Rows[0]["PostFee"].ToString().ToDecimal().ToString("0.00"); lblAuditAmount.InnerText = dt.Rows[0]["AuditAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["AuditAmount"].ToString().ToDecimal().ToString("N"); //下单信息 lblArriveDate.InnerText = dt.Rows[0]["ArriveDate"].ToString() == "" ? "" : dt.Rows[0]["ArriveDate"].ToString().ToDateTime().ToString("yyyy-MM-dd"); lblGiveMode.InnerText = dt.Rows[0]["GiveMode"].ToString(); iRemark.InnerText = dt.Rows[0]["Remark"].ToString(); //收货地址 lblPrincipal.InnerText = dt.Rows[0]["Principal"].ToString(); lblPhone.InnerText = dt.Rows[0]["Phone"].ToString(); lblAddress.InnerText = dt.Rows[0]["Address"].ToString(); hidAddrID.Value = dt.Rows[0]["AddrID"].ToString(); //开票信息 if (dt.Rows[0]["IsOBill"].ToString().ToInt(0) > 0) { hidDisAccID.Value = dt.Rows[0]["DisAccID"].ToString(); hidval.Value = dt.Rows[0]["IsOBill"].ToString(); string Billing = string.Empty; Billing += "发票抬头:<label id=\"lblRise\" runat=\"server\">" + dt.Rows[0]["Rise"].ToString() + "</label>"; Billing += ",发票内容:<label id=\"lblContent\" runat=\"server\">" + dt.Rows[0]["Content"].ToString() + "</label>"; if (dt.Rows[0]["IsOBill"].ToString().ToInt(0) == 2) { Billing += ",开户银行:<label id=\"lblOBank\" runat=\"server\">" + dt.Rows[0]["OBank"].ToString() + "</label>"; Billing += ",开户账户:<label id=\"lblOAccount\" runat=\"server\">" + dt.Rows[0]["OAccount"].ToString() + "</label>"; Billing += ",纳税人登记号:<label id=\"lblTRNumber\" runat=\"server\">" + dt.Rows[0]["TRNumber"].ToString() + "</label>"; } else { Billing += ",纳税人登记号:<label id=\"lblTRNumber\" runat=\"server\">" + dt.Rows[0]["TRNumber"].ToString() + "</label>"; } iInvoice.InnerHtml = Billing; //lblRise.InnerText = dt.Rows[0]["Rise"].ToString(); //lblContent.InnerText = dt.Rows[0]["Content"].ToString(); //lblOBank.InnerText = dt.Rows[0]["OBank"].ToString(); //lblOAccount.InnerText = dt.Rows[0]["OAccount"].ToString(); //lblTRNumber.InnerText = dt.Rows[0]["TRNumber"].ToString(); } else { this.iInvoice.InnerHtml = "不开发票"; } //发票信息 lblBillNo.InnerText = dt.Rows[0]["BillNo"].ToString(); lblIsBill.InnerText = dt.Rows[0]["IsBill"].ToString() == "1" ? "是" : "否"; this.hidisBill.Value = dt.Rows[0]["IsBill"].ToString(); string msg = string.Empty; bool flag = Common.FCan(dt.Rows[0]["DisID"].ToString(), "1", out msg); if (flag) { this.lblmsg.InnerText = msg; } decimal nopayAmount = OrderInfoType.GetSumAmount(dt.Rows[0]["DisID"].ToString(), dt.Rows[0]["CompID"].ToString(), KeyID); if (nopayAmount > 0) { string promptmsg = "订单待支付金额为¥" + nopayAmount.ToString("0.00") + ",请尽快支付"; this.lblPrompt.InnerText = promptmsg; } else { this.lblPrompt.Visible = false; } #region 订单支付信息 TotalAmount = Convert.ToDecimal(dt.Rows[0]["AuditAmount"]).ToString("0.00"); PayedAmount = Convert.ToDecimal(dt.Rows[0]["PayedAmount"]).ToString("0.00"); //订单已支付不显示支付按钮(未审核、未支付完成) if (Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.未提交 || Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.待审核 || Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.待审核 || Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.已退货 || Convert.ToInt32(dt.Rows[0]["OState"]) == (int)Enums.OrderState.已作废 || (Convert.ToDecimal(dt.Rows[0]["AuditAmount"]) - Convert.ToDecimal(dt.Rows[0]["PayedAmount"]) == 0)) { btn_pay.Visible = false; } paymoney = (Convert.ToDecimal(dt.Rows[0]["AuditAmount"]) - Convert.ToDecimal(dt.Rows[0]["PayedAmount"])).ToString("0.00"); //加密keyId desKeyID.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey); //绑定支付流水信息 DataTable paytable = new Hi.BLL.PAY_PrePayment().GetPayedItem(KeyID); rptmessage.DataSource = paytable; rptmessage.DataBind(); //初始值加载 txtArriveDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); DataTable dtpayment = new Hi.BLL.PAY_PrePayment().GetDate(" top 1 CreateDate, payName ,paycode ,paybank", "pay_payment", " DisID=" + DisID + " and vdef3=5 order by CreateDate desc"); foreach (DataRow dr in dtpayment.Rows) { bankname.Value = Convert.ToString(dr["payName"]); bankcode.Value = Convert.ToString(dr["paycode"]); bank.Value = Convert.ToString(dr["paybank"]); } //附件 //if (dt.Rows[0]["Atta"].ToString() != "") //{ // StringBuilder li = new StringBuilder(); // string[] atta = dt.Rows[0]["Atta"].ToString().Split(new string[] { "$$&&" }, StringSplitOptions.RemoveEmptyEntries); // if (atta.Length > 0) // { // foreach (var item in atta) // { // li.AppendFormat("<li> <a href=\"javascript:;\" class=\"name\">{0}</a><a href=\"javascript:;\" class=\"bule del\" orderid=\"{1}\">删除</a><a href=\"javascript:;\" class=\"bule\">下载</a></li>", item, KeyID); // } // } // this.payulfile.InnerHtml = li.ToString(); //} #endregion //附件 if (dt.Rows[0]["Atta"].ToString() != "") { StringBuilder li = new StringBuilder(); string[] atta = dt.Rows[0]["Atta"].ToString().Split(new string[] { "@@" }, StringSplitOptions.RemoveEmptyEntries); if (atta.Length > 0) { foreach (var item in atta) { string[] att = item.Split(new string[] { "^^" }, StringSplitOptions.RemoveEmptyEntries); if (att.Length > 1) { li.AppendFormat("<li> <a href=\"{2}\" target=\"_blank\" class=\"name\">{0}(大小:{4}KB)</a><a href=\"javascript:;\" class=\"bule del\" tip=\"{3}\" orderid=\"{1}\">删除</a><a href=\"{2}\" target=\"_blank\" class=\"bule\">下载</a></li>", att[0] + att[1].Substring(att[1].LastIndexOf(".")), KeyID, Common.GetWebConfigKey("ImgViewPath") + "OrderFJ/" + item, item, OrderType.GetSize(item)); } } } ulAtta.InnerHtml = li.ToString(); this.hrOrderFj.Value = dt.Rows[0]["Atta"].ToString(); } #region 订单明细 //订单所有商品明细 DataTable l = new Hi.BLL.DIS_OrderDetail().GetOrderDe("", " IsNUll(o.dr,0)=0 and o.OrderId=" + KeyID); if (l != null && l.Rows.Count > 0) { rptOrderD.DataSource = l; rptOrderD.DataBind(); //待发货商品 DataTable lno = SelectGoodsInfo.SreeenDataTable(l, "isnull(IsOut,0)=0"); //l.Select(string.Format("IsOut={0}", 0)); if (lno != null && lno.Rows.Count > 0) { rptIsout.DataSource = lno; rptIsout.DataBind(); } //已发货商品 List <Hi.Model.DIS_OrderOutDetail> loud = new Hi.BLL.DIS_OrderOutDetail().GetList("", " isnull(dr,0)=0 and OrderID=" + KeyID, ""); //发货单 and o.IsAudit<>3 DataTable lo = new Hi.BLL.DIS_OrderOut().GetList("", " isnull(o.dr,0)=0 and o.OrderID=" + KeyID + " Order by o.IsAudit"); if (loud != null && loud.Count > 0) { //outbind(lo, l, loud); outGoods.InnerHtml = SelectGoodsInfo.outbind(lo, l, loud, Digits, 0); } #region 流程时间控件 if (lo != null && lo.Rows.Count > 0) { if (((int)Enums.OrderState.已发货 <= OState || OState == (int)Enums.OrderState.退货处理) && (IsOutState == 3 || IsOutState == 4)) { //订单发货时间 DataRow[] sendlo = lo.Select("IsAudit<>3"); DataRow[] dv = sendlo.OrderByDescending(x => x["id"]).ToArray(); if (dv.Length > 0) { sendde = dv[0]["SendDate"].ToString() != "" ? dv[0]["SendDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : ""; } } if ((int)Enums.OrderState.已到货 <= OState || OState == (int)Enums.OrderState.退货处理) { //订单签收时间 DataRow[] signlo = lo.Select("IsAudit<>3 and IsSign=1"); DataRow[] dr = signlo.OrderByDescending(x => x["id"]).ToArray(); if (dr.Length > 0) { signde = dr[0]["SignDate"].ToString() != "" ? dr[0]["SignDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : ""; } } } #endregion } #endregion #region 流程时间控件 //订单流程时间显示 //订单提交时间 CreateDate = dt.Rows[0]["CreateDate"].ToString() != "" ? dt.Rows[0]["CreateDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : ""; //订单审核时间 AuditDate = dt.Rows[0]["AuditDate"].ToString() != "" ? dt.Rows[0]["AuditDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : ""; #endregion 流程时间控件 #region 订单操作按钮 switch (OState) { case (int)Enums.OrderState.待审核: modifyorder.Visible = true; buyagain.Visible = true; ordervoid.Visible = true; break; case (int)Enums.OrderState.已审: //订单审核前,可以修改订单。 buyagain.Visible = true; break; case (int)Enums.OrderState.退货处理: //orderReturn.Visible = false; buyagain.Visible = true; btn_pay.Visible = false; fulfil = signde; break; case (int)Enums.OrderState.已发货: modifyorder.Visible = false; buyagain.Visible = true; break; case (int)Enums.OrderState.已到货: modifyorder.Visible = false; buyagain.Visible = true; if (dt.Rows[0]["CreateDate"].ToString().ToDateTime() > DateTime.Now.AddMonths(-3)) { //三个月以内的订单可退货 //if (ReturnState < (int)Enums.ReturnState.申请退货) //orderReturn.Visible = true; } if (ReturnState >= (int)Enums.ReturnState.申请退货) { btn_pay.Visible = false; } if (sendde == "" && signde == "" && AuditDate != "") { fulfil = AuditDate; } else if (AuditDate.ToString() == "") { fulfil = CreateDate; } else { fulfil = signde == "" ? sendde : signde; } break; case (int)Enums.OrderState.已作废: modifyorder.Visible = false; buyagain.Visible = true; fulfil = Convert.ToDateTime(dt.Rows[0]["ts"]).ToString("yyyy-MM-dd HH:mm"); break; case (int)Enums.OrderState.已退货: buyagain.Visible = true; btn_pay.Visible = false; fulfil = signde; break; default: break; } #endregion //订单修改,再次购买 if (!Common.HasRight(this.CompID, this.UserID, "1010", this.DisID)) { this.buyagain.Visible = false; this.modifyorder.Visible = false; } //订单作废 if (!Common.HasRight(this.CompID, this.UserID, "2012", this.DisID)) { this.ordervoid.Visible = false; } //在线支付 if (!Common.HasRight(this.CompID, this.UserID, "2014", this.DisID)) { ClientScript.RegisterStartupScript(this.GetType(), "btn_pay_xs", "<script> $('#btn_pay_xs').hide();</script>"); } //线下支付 if (!Common.HasRight(this.CompID, this.UserID, "2015", this.DisID)) { this.btn_pay_xx.Visible = false; } //申请退货 //if (!Common.HasRight(this.CompID, this.UserID, "2311", this.DisID)) //this.orderReturn.Visible = false; //确认收货 if (!Common.HasRight(this.CompID, this.UserID, "2013", this.DisID)) { ClientScript.RegisterStartupScript(this.GetType(), "btnsign", "<script> $('.btnsign,.btnsigni').hide();</script>"); } } } else { Response.Redirect("../NoOperable.aspx"); return; } }
protected void Page_Load(object sender, EventArgs e) { //this.lblMsg.InnerText = Request["msg"]; LogManager.LogFielPrefix = "jsnx"; LogManager.LogPath = "C:/requestpag/"; LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "进入回调页面"); SortedDictionary <string, string> sPara = GetRequestPost(); try { if (sPara == null || sPara.Count <= 0) { Response.Write("无通知参数"); LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "退出回调页面\r\nError:无通知参数"); return; } Notify aliNotify = new Notify(); bool verifyResult = aliNotify.Verify(sPara, Request.Form["notify_id"], Request.Form["sign"]); if (!verifyResult)//验证失败 { Response.Write("fail"); LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "退出回调页面\r\nError:验证失败"); return; } //企业订单号 string out_trade_no = Common.NoHTML(Request.Form["out_trade_no"]); //支付宝交易号 string trade_no = Common.NoHTML(Request.Form["trade_no"]); //交易状态 string trade_status = Common.NoHTML(Request.Form["trade_status"]); decimal prepayPrice = 0; string guid = ""; int orderid = 0; Hi.Model.PAY_RegisterLog regM = new Hi.Model.PAY_RegisterLog(); List <Hi.Model.PAY_RegisterLog> regL = new Hi.BLL.PAY_RegisterLog().GetList("", " Ordercode = '" + out_trade_no + "'", ""); if (regL == null || regL.Count <= 0) { Response.Write("找不到" + out_trade_no); LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "退出回调页面\r\nError:找不到" + out_trade_no); return; } regM = regL[0]; try { regM.Start = trade_status; regM.ResultMessage = trade_no; new Hi.BLL.PAY_RegisterLog().Update(regM); } catch { } guid = regM.number; orderid = regM.OrderId; Hi.Model.DIS_Order orderModel = new Hi.BLL.DIS_Order().GetModel(orderid); Hi.Model.PAY_Payment payM = new Hi.Model.PAY_Payment(); List <Hi.Model.PAY_Payment> payL = new Hi.BLL.PAY_Payment().GetList("", " guid = '" + guid + "' ", ""); if (payL == null || payL.Count <= 0) { Response.Write("找不到" + out_trade_no); LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "退出回调页面\r\nError:找不到" + out_trade_no); return; } payM = payL[0]; if (payM.IsAudit == 1) { Response.Write("success");//请不要修改或删除,输出success后,支付宝将不再发送通知 LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "退出回调页面\r\n支付成功\r\n支付订单号:" + out_trade_no); return; } if (trade_status != "TRADE_SUCCESS") { Response.Write(GetTradeStatusByName(trade_status)); LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "退出回调页面\r\nError:" + GetTradeStatusByName(trade_status) + "\r\n支付订单号:" + out_trade_no); return; } Hi.Model.PAY_PrePayment prepayM = new Hi.Model.PAY_PrePayment(); List <Hi.Model.PAY_PrePayment> prepayL = new Hi.BLL.PAY_PrePayment().GetList("", " vdef4 = '" + payM.ID + "' ", ""); if (prepayL != null && prepayL.Count > 0) { prepayM = prepayL[0]; prepayPrice = prepayM.price * -1; } int order = 0; int prepay = 0; int pay = 0; SqlConnection con = new SqlConnection(LocalSqlServer); con.Open(); SqlTransaction sqlTrans = con.BeginTransaction(); try { order = new Hi.BLL.DIS_Order().UpdateOrderPstate(con, orderid, payM.PayPrice + prepayPrice, sqlTrans); pay = new Hi.BLL.PAY_Payment().updatePayState(con, payM.ID, sqlTrans); if (prepayPrice > 0) { prepay = new Hi.BLL.PAY_PrePayment().updatePrepayState(con, prepayM.ID, sqlTrans); } else { prepay = 1; } sqlTrans.Commit(); } catch (Exception ex) { Response.Write("Error"); LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "退出回调页面\r\nError:" + ex.Message + "\r\n支付订单号:" + out_trade_no); order = 0; prepay = 0; pay = 0; sqlTrans.Rollback(); } finally { con.Close(); } if (order <= 0 || prepay <= 0 || pay <= 0) { Response.Write("Error"); LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "退出回调页面\r\nError:支付成功,修改状态失败,等待下次页面通知\r\n支付订单号:" + out_trade_no); return; } try { new Common().GetWxService("2", orderModel.ID.ToString(), "1"); if (orderModel.Otype != 9) { OrderInfoType.AddIntegral(orderModel.CompID, orderModel.DisID, "1", 1, orderModel.ID, (prepayPrice + payM.PayPrice), "订单支付", "", orderModel.CreateUserID); } } catch { } if (orderModel.Otype == (int)Enums.OType.推送账单) { Utils.AddSysBusinessLog(orderModel.CompID, "Order", orderModel.ID.ToString(), "账单支付", "支付:" + (prepayPrice + payM.PayPrice).ToString("0.00") + "元(支付宝支付)", payM.CreateUserID.ToString()); } else { Utils.AddSysBusinessLog(orderModel.CompID, "Order", orderModel.ID.ToString(), "订单支付", "支付:" + (prepayPrice + payM.PayPrice).ToString("0.00") + "元(支付宝支付)", payM.CreateUserID.ToString()); } Response.Write("success"); //请不要修改或删除,输出success后,支付宝将不再发送通知 LogManager.WriteLog(LogFile.Trace.ToString(), "时间:" + DateTime.Now.ToString("yyyy-MMdd HH:mm:ss") + "\r\n" + "退出回调页面\r\n支付成功\r\n支付订单号:" + out_trade_no); return; } catch (Exception ex) { LogManager.LogFielPrefix = "requestpag"; LogManager.LogPath = "C:/requestpag/"; LogManager.WriteLog(LogFile.Error.ToString(), "Error:" + ex.Message + "\r\n"); Response.Write(ex.Message); return; } finally { Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { //ResultNotify resultNotify = new ResultNotify(this); //resultNotify.ProcessNotify(); string resultFromWx = getPostStr(); //设置支付参数 var res = XDocument.Parse(resultFromWx); string return_code = res.Element("xml").Element("return_code").Value; string out_trade_no = res.Element("xml").Element("out_trade_no").Value; string result_code = res.Element("xml").Element("result_code").Value; string price = res.Element("xml").Element("total_fee").Value; ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中服务器异步通知参数列表 if (return_code == "SUCCESS" || result_code == "SUCCESS") { //判断该笔订单是否在商户网站中已经做过处理 //如果没有做过处理,根据订单号(out_trade_no)在商户网站的订单系统中查到该笔订单的详细,并执行商户的业务程序 //如果有做过处理,不执行商户的业务程序 string strWhere2 = string.Empty; if (out_trade_no != "") { strWhere2 += " number = '" + out_trade_no + "'"; } Hi.Model.PAY_RegisterLog regM = new Hi.Model.PAY_RegisterLog(); List <Hi.Model.PAY_RegisterLog> regL = new Hi.BLL.PAY_RegisterLog().GetList("", strWhere2, ""); if (regL == null || regL.Count <= 0) { //response.Redirect("../Distributor/Pay/Error.aspx?msg=未找到对应的支付记录!", false); //return; Console.WriteLine("未找到对应的支付记录!"); } regM = regL[0]; string strWhere = string.Empty; if (out_trade_no != "") { strWhere += " guid = '" + out_trade_no + "'"; } strWhere += " and isnull(dr,0)=0"; Hi.Model.PAY_Payment payM = new Hi.Model.PAY_Payment(); List <Hi.Model.PAY_Payment> payL = new Hi.BLL.PAY_Payment().GetList("", strWhere, ""); if (payL == null || payL.Count <= 0) { //response.Redirect("../Distributor/Pay/Error.aspx?msg=未找到对应的支付记录!", false); // return; Console.WriteLine("未找到对应的支付记录!"); } payM = payL[0]; payM.PayDate = DateTime.Now; payM.ts = DateTime.Now; payM.status = 0; //trade_status == "TRADE_FINISHED" ? 80 : 90; new Hi.BLL.PAY_Payment().Update(payM); regM.Start = ""; // trade_status; new Hi.BLL.PAY_RegisterLog().Update(regM); if (payM.IsAudit == 2) //该支付记录未修改成功进入,修改成功就不进入,请不要重复操作 { //!!!支付成功 !!! decimal prepayPrice = 0; //企业钱包充值 Hi.Model.PAY_PrePayment prepayMnew = new Hi.Model.PAY_PrePayment(); string strWhere3 = string.Empty; if (out_trade_no != "") { strWhere3 += " ID = " + payM.OrderID; } strWhere3 += " and isnull(dr,0)=0"; List <Hi.Model.PAY_PrePayment> plist = new Hi.BLL.PAY_PrePayment().GetList("", strWhere3, ""); if (plist.Count > 0) { prepayMnew = plist[0]; } //订单 Hi.Model.DIS_Order orderModel = new Hi.BLL.DIS_Order().GetModel(payM.OrderID); if (orderModel != null) { string strWhere1 = string.Empty; strWhere1 += " vdef4 = '" + payM.ID + "'"; strWhere1 += " and isnull(dr,0)=0"; Hi.Model.PAY_PrePayment prepayM = new Hi.Model.PAY_PrePayment(); List <Hi.Model.PAY_PrePayment> prepayL = new Hi.BLL.PAY_PrePayment().GetList("", strWhere1, ""); if (prepayL != null && prepayL.Count > 0) { prepayM = prepayL[0]; prepayPrice = prepayM.price * -1; } int order = 0; int prepay = 0; int pay = 0; decimal prices = Convert.ToDecimal(price); SqlConnection con = new SqlConnection(LocalSqlServer); con.Open(); SqlTransaction sqlTrans = con.BeginTransaction(); try { order = new Hi.BLL.DIS_Order().UpdateOrderPstate(con, orderModel.ID, payM.PayPrice + prepayPrice - Convert.ToDecimal(payM.vdef5), sqlTrans); pay = new Hi.BLL.PAY_Payment().updatePayState(con, payM.ID, sqlTrans); if (prepayPrice > 0) { prepay = new Hi.BLL.PAY_PrePayment().updatePrepayState(con, prepayM.ID, sqlTrans); } else { prepay = 1; } sqlTrans.Commit(); } catch { order = 0; prepay = 0; pay = 0; sqlTrans.Rollback(); } finally { con.Close(); } if (order <= 0 || prepay <= 0 || pay <= 0) { Console.WriteLine("支付成功,但修改支付状态失败,请联系系统管理员,勿重复操作!"); } try { //new Common().GetWxService("2", orderModel.ID.ToString(), "1"); if (orderModel.Otype != 9) { OrderInfoType.AddIntegral(orderModel.CompID, orderModel.DisID, "1", 1, orderModel.ID, (prepayPrice + prices), "订单支付", "", orderModel.CreateUserID); } } catch { } if (orderModel.Otype == (int)Enums.OType.推送账单) { Utils.AddSysBusinessLog(orderModel.CompID, "Order", orderModel.ID.ToString(), "账单支付", "支付:" + (prepayPrice + prices).ToString("0.00") + "元(微信支付" + prices.ToString("0.00") + (prepayM.ID > 0 ? "+企业钱包支付" + prepayPrice.ToString("0.00") : "") + "【含手续费" + Convert.ToDecimal(payM.vdef5).ToString("0.00") + "元】)", payM.CreateUserID.ToString()); } else { Utils.AddSysBusinessLog(orderModel.CompID, "Order", orderModel.ID.ToString(), "订单支付", "支付:" + (prepayPrice + prices).ToString("0.00") + "元(微信支付" + prices.ToString("0.00") + (prepayM.ID > 0 ? "+企业钱包支付" + prepayPrice.ToString("0.00") : "") + "【含手续费" + Convert.ToDecimal(payM.vdef5).ToString("0.00") + "元】)", payM.CreateUserID.ToString()); } //微信和安卓消息推送 try { new Common().GetWxService("2", orderModel.ID.ToString(), "1", prepayPrice + prices); } catch { } Response.Write("success"); //请不要修改或删除 }//钱包充值 else if (prepayMnew != null) { int prepay = 0; int pay = 0; SqlConnection con = new SqlConnection(LocalSqlServer); con.Open(); SqlTransaction sqlTrans = con.BeginTransaction(); try { pay = new Hi.BLL.PAY_Payment().updatePayState(con, payM.ID, sqlTrans); prepay = new Hi.BLL.PAY_PrePayment().updatePrepayState(con, prepayMnew.ID, sqlTrans); sqlTrans.Commit(); } catch { pay = 0; prepay = 0; sqlTrans.Rollback(); } finally { con.Close(); } } else { //response.Redirect("../Distributor/Pay/Error.aspx?msg=未找到该支付订单!", false); //return; Console.WriteLine("未找到该支付记录!"); } } else { Console.WriteLine("success"); } Response.Write("success"); } else//验证失败 { Response.Write("fail"); } }
/// <summary> /// 订单信息 /// </summary> public void databind() { if (KeyID != 0) { hidOrderID.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey); string where = "and isnull(o.dr,0)=0 and o.otype<>9 and o.ID= " + KeyID; DataTable dt = new Hi.BLL.DIS_Order().GetList("", where); if (dt != null && dt.Rows.Count > 0) { CompID = dt.Rows[0]["CompID"].ToString().ToInt(0); DisID = dt.Rows[0]["DisID"].ToString().ToInt(0); hidDisID.Value = DisID.ToString(); //判断改该条数据代理商是否有操作权限 if (!Common.PageDisOperable("Order", KeyID, DisID)) { Response.Redirect("../NoOperable.aspx"); return; } //////再次购买 ////buyagain.Visible = false; //////订单修改 ////modifyorder.Visible = false; //订单作废 //ordervoid.Visible = false; //////订单审核 ////orderaudit.Visible = false; Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", dt.Rows[0]["CompID"].ToString().ToInt(0)); hidDigits.Value = Digits; isbate = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", CompID).ToInt(0); if (isbate == 0) { trbate.Visible = false; rebate.Visible = false; } OState = dt.Rows[0]["OState"].ToString().ToInt(0); if (OState == (int)Enums.OrderState.已作废) { orderDelete.Visible = true; } else { orderDelete.Visible = false; } IsOutState = dt.Rows[0]["IsOutState"].ToString().ToInt(0); payState = dt.Rows[0]["PayState"].ToString().ToInt(0); hidIsOutstate.Value = dt.Rows[0]["IsOutState"].ToString(); hidOstate.Value = OState.ToString(); hidpaystate.Value = payState.ToString(); #region 订单操作按钮 //switch (OState) //{ // case (int)Enums.OrderState.未提交: // //modifyorder.Visible = true; // //buyagain.Visible = true; // //orderaudit.Visible = true; // //ordervoid.Visible = true; // deliver.Attributes.Add("style", "display: none;"); // break; // case (int)Enums.OrderState.待审核: // //modifyorder.Visible = true; // //buyagain.Visible = true; // //orderaudit.Visible = true; // //ordervoid.Visible = true; // deliver.Attributes.Add("style", "display: none;"); // break; // case (int)Enums.OrderState.已审: // //订单审核前,可以修改订单。 // buyagain.Visible = true; // if (payState == 0) // { // //订单支付前订单可以作废,支付后不能作废订单 // ordervoid.Visible = true; // } // break; // case (int)Enums.OrderState.退货处理: // buyagain.Visible = true; // fulfil = signde; // break; // case (int)Enums.OrderState.已发货: // modifyorder.Visible = false; // buyagain.Visible = true; // break; // case (int)Enums.OrderState.已到货: // modifyorder.Visible = false; // buyagain.Visible = true; // fulfil = signde; // break; // case (int)Enums.OrderState.已作废: // modifyorder.Visible = false; // buyagain.Visible = true; // break; // case (int)Enums.OrderState.已退货: // buyagain.Visible = true; // fulfil = signde; // break; // default: // break; //} #endregion // 订单编号 lblReceiptNo.InnerText = dt.Rows[0]["ReceiptNo"].ToString(); lblDisName.InnerText = Common.GetDisValue(dt.Rows[0]["DisID"].ToString().ToInt(0), "DisName").ToString(); lblCreateDate.InnerText = dt.Rows[0]["CreateDate"].ToString().ToDateTime().ToString("yyyy-MM-dd"); lblOstate.InnerText = OrderType.GetOState(dt.Rows[0]["OState"].ToString(), dt.Rows[0]["IsOutState"].ToString()); //订单流程 lblTotalAmount.InnerText = dt.Rows[0]["TotalAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["TotalAmount"].ToString().ToDecimal().ToString("N"); lblProAmount.InnerText = dt.Rows[0]["ProAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["ProAmount"].ToString().ToDecimal().ToString("N"); lblbateAmount.InnerText = dt.Rows[0]["bateAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["bateAmount"].ToString().ToDecimal().ToString("N"); lblbate.InnerText = dt.Rows[0]["bateAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["bateAmount"].ToString().ToDecimal().ToString("0.00"); lblPostFee.InnerText = dt.Rows[0]["PostFee"].ToString() == "" ? "0.00" : dt.Rows[0]["PostFee"].ToString().ToDecimal().ToString("0.00"); lblAuditAmount.InnerText = dt.Rows[0]["AuditAmount"].ToString() == "" ? "0.00" : dt.Rows[0]["AuditAmount"].ToString().ToDecimal().ToString("N"); //下单信息 lblArriveDate.InnerText = dt.Rows[0]["ArriveDate"].ToString() == "" ? "" : dt.Rows[0]["ArriveDate"].ToString().ToDateTime().ToString("yyyy-MM-dd"); lblGiveMode.InnerText = dt.Rows[0]["GiveMode"].ToString(); iRemark.InnerText = dt.Rows[0]["Remark"].ToString(); //收货地址 lblPrincipal.InnerText = dt.Rows[0]["Principal"].ToString(); lblPhone.InnerText = dt.Rows[0]["Phone"].ToString(); lblAddress.InnerText = dt.Rows[0]["Address"].ToString(); hidAddrID.Value = dt.Rows[0]["AddrID"].ToString(); //开票信息 if (dt.Rows[0]["IsOBill"].ToString() == "1") { hidDisAccID.Value = dt.Rows[0]["DisAccID"].ToString(); hidval.Value = dt.Rows[0]["IsOBill"].ToString(); string Billing = string.Empty; Billing += "发票抬头:<label id=\"lblRise\" runat=\"server\">" + dt.Rows[0]["Rise"].ToString() + "</label>"; Billing += ",发票内容:<label id=\"lblContent\" runat=\"server\">" + dt.Rows[0]["Content"].ToString() + "</label>"; if (!string.IsNullOrEmpty(dt.Rows[0]["OBank"].ToString())) { Billing += ",开户银行:<label id=\"lblOBank\" runat=\"server\">" + dt.Rows[0]["OBank"].ToString() + "</label>"; Billing += ",开户账户:<label id=\"lblOAccount\" runat=\"server\">" + dt.Rows[0]["OAccount"].ToString() + "</label>"; Billing += ",纳税人登记号:<label id=\"lblTRNumber\" runat=\"server\">" + dt.Rows[0]["TRNumber"].ToString() + "</label>"; } iInvoice.InnerHtml = Billing; //lblRise.InnerText = dt.Rows[0]["Rise"].ToString(); //lblContent.InnerText = dt.Rows[0]["Content"].ToString(); //lblOBank.InnerText = dt.Rows[0]["OBank"].ToString(); //lblOAccount.InnerText = dt.Rows[0]["OAccount"].ToString(); //lblTRNumber.InnerText = dt.Rows[0]["TRNumber"].ToString(); } else { this.iInvoice.InnerHtml = "不开发票"; } //发票信息 lblBillNo.InnerText = dt.Rows[0]["BillNo"].ToString(); lblIsBill.InnerText = dt.Rows[0]["IsBill"].ToString() == "1" ? "是" : "否"; lblIsBill.Attributes.Add("tip", dt.Rows[0]["IsBill"].ToString()); this.hidisBill.Value = dt.Rows[0]["IsBill"].ToString(); #region 订单支付信息 TotalAmount = Convert.ToDecimal(dt.Rows[0]["AuditAmount"]).ToString("0.00"); PayedAmount = Convert.ToDecimal(dt.Rows[0]["PayedAmount"]).ToString("0.00"); //订单已支付不显示支付按钮(未审核、未支付完成) if (Convert.ToInt32(dt.Rows[0]["OState"]) == 1 || (Convert.ToDecimal(dt.Rows[0]["AuditAmount"]) - Convert.ToDecimal(dt.Rows[0]["PayedAmount"]) == 0)) { btn_pay.Visible = false; } paymoney = (Convert.ToDecimal(dt.Rows[0]["AuditAmount"]) - Convert.ToDecimal(dt.Rows[0]["PayedAmount"])).ToString("0.00"); //加密keyId desKeyID.Value = Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey); //绑定支付流水信息 DataTable paytable = new Hi.BLL.PAY_PrePayment().GetPayedItem(KeyID); rptmessage.DataSource = paytable; rptmessage.DataBind(); //初始值加载 txtArriveDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); DataTable dtpayment = new Hi.BLL.PAY_PrePayment().GetDate(" top 1 CreateDate, payName ,paycode ,paybank", "pay_payment", " DisID=" + DisID + " and vdef3=5 order by CreateDate desc"); foreach (DataRow dr in dtpayment.Rows) { bankname.Value = Convert.ToString(dr["payName"]); bankcode.Value = Convert.ToString(dr["paycode"]); bank.Value = Convert.ToString(dr["paybank"]); } #endregion //附件 if (dt.Rows[0]["Atta"].ToString() != "") { StringBuilder li = new StringBuilder(); string[] atta = dt.Rows[0]["Atta"].ToString().Split(new string[] { "@@" }, StringSplitOptions.RemoveEmptyEntries); if (atta.Length > 0) { foreach (var item in atta) { string[] att = item.Split(new string[] { "^^" }, StringSplitOptions.RemoveEmptyEntries); if (att.Length > 1) { li.AppendFormat("<li> <a href=\"{2}\" target=\"_blank\" class=\"name\">{0}(大小:{4}KB)</a><a href=\"javascript:;\" class=\"bule del\" tip=\"{3}\" orderid=\"{1}\">删除</a><a href=\"{2}\" target=\"_blank\" class=\"bule\">下载</a></li>", att[0] + att[1].Substring(att[1].LastIndexOf(".")), KeyID, Common.GetWebConfigKey("ImgViewPath") + "OrderFJ/" + item, item, OrderType.GetSize(item)); } } } ulAtta.InnerHtml = li.ToString(); this.hrOrderFj.Value = dt.Rows[0]["Atta"].ToString(); } #region 订单明细 //订单所有商品明细 DataTable l = new Hi.BLL.DIS_OrderDetail().GetOrderDe("", " IsNUll(o.dr,0)=0 and o.OrderId=" + KeyID); if (l != null && l.Rows.Count > 0) { rptOrderD.DataSource = l; rptOrderD.DataBind(); //待发货商品 DataTable lno = SelectGoodsInfo.SreeenDataTable(l, "isnull(IsOut,0)=0"); //l.Select(string.Format("IsOut={0}", 0)); if (lno != null && lno.Rows.Count > 0) { txtDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); rptIsout.DataSource = lno; rptIsout.DataBind(); } else { deliver.Attributes.Add("style", "display: none;"); } //已发货商品 List <Hi.Model.DIS_OrderOutDetail> loud = new Hi.BLL.DIS_OrderOutDetail().GetList("", " isnull(dr,0)=0 and OrderID=" + KeyID, ""); //发货单 作废-- and o.IsAudit<>3 DataTable lo = new Hi.BLL.DIS_OrderOut().GetList("", " isnull(o.dr,0)=0 and o.OrderID=" + KeyID + " Order by o.IsAudit"); if (loud != null && loud.Count > 0) { //outbind(lo, l, loud); outGoods.InnerHtml = SelectGoodsInfo.outbind(lo, l, loud, Digits, 1); } #region 流程时间控件 //订单流程时间显示 //订单提交时间 CreateDate = dt.Rows[0]["CreateDate"].ToString() != "" ? dt.Rows[0]["CreateDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : ""; //订单审核时间 AuditDate = dt.Rows[0]["AuditDate"].ToString() != "" ? dt.Rows[0]["AuditDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : ""; if (lo != null && lo.Rows.Count > 0) { if (((int)Enums.OrderState.已发货 <= OState || OState == (int)Enums.OrderState.退货处理) && (IsOutState == 3 || IsOutState == 4)) { //订单发货时间 DataRow[] sendlo = lo.Select("IsAudit<>3"); DataRow[] dv = sendlo.OrderByDescending(x => x["id"]).ToArray(); if (dv.Length > 0) { sendde = dv[0]["SendDate"].ToString() != "" ? dv[0]["SendDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : ""; } } if ((int)Enums.OrderState.已到货 <= OState || OState == (int)Enums.OrderState.退货处理) { //订单签收时间 DataRow[] signlo = lo.Select("IsAudit<>3 and IsSign=1"); DataRow[] dr = signlo.OrderByDescending(x => x["id"]).ToArray(); if (dr.Length > 0) { signde = dr[0]["SignDate"].ToString() != "" ? dr[0]["SignDate"].ToString().ToDateTime().ToString("yyyy-MM-dd HH:mm") : ""; } } } #endregion } #endregion } else { Response.Redirect("../NoOperable.aspx"); return; } } }