/// <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(""); } }
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"; } } }
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>"); } }
/// <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); } }
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> /// <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> /// <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(); } }
/// <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 databind() { if (Session["UserModel"] is LoginModel) { #region 权限 LoginModel model = Session["UserModel"] as LoginModel; bool isbte = false; ////返利 List <Hi.Model.SYS_SysName> Sysl = new Hi.BLL.SYS_SysName().GetList("", " CompID=" + model.CompID, ""); Sysl = Sysl.FindAll(p => p.Name == "订单支付返利是否启用"); if (Sysl != null && Sysl.Count > 0) { isbte = Sysl[0].Value.ToString() == "1"; } else { isbte = false; } ////是否启用库存 this.spwhgl.Visible = OrderInfoType.rdoOrderAudit("商品是否启用库存", model.CompID) == "0" ? true : false; Erptype = model.Erptype; if (model != null) { //获得用户类型 Hi.Model.SYS_Users sysUser = new Hi.BLL.SYS_Users().GetModel(model.UserID); if (sysUser != null && Common.HasAdminRole(sysUser.ID)) { //订单 //ddgl.Visible = true; ddlb.Visible = true; //ddsh.Visible = true; //ddfh.Visible = true; //ddth.Visible = true; //收款 // ddskbl.Visible = true; ddskmx.Visible = true; //zdskbl.Visible = true; //zdskmx.Visible = true; //qbcx.Visible = true; //ddsk.Visible = true; //zdsk.Visible = true; //qyqb.Visible = true; //商品 splb.Visible = true; spfl.Visible = true; spsxwh.Visible = true; spggmb.Visible = true; spkc.Visible = true; sprk.Visible = true; spck.Visible = true; sppd.Visible = false; Dd3.Visible = true; //jxsjg.Visible = true; //spbks.Visible = true; spcx.Visible = true; ddcx.Visible = true; //代理商 jxslb.Visible = true; jxssh.Visible = true; jxsgly.Visible = true; jxsfl.Visible = true; jxsqy.Visible = true; //dlssyzl.Visible = true; //我的报表 ddtj.Visible = true; jxstj.Visible = true; sptj.Visible = true; zltj.Visible = true; spxsmx.Visible = true; //sjfx.Visible = true; //zhfx.Visible = true; //ddfx.Visible = true; //jxsfx.Visible = true; //cpfx.Visible = true; //cpabcfx.Visible = true; //ysfx.Visible = true; //设置 skzhgl.Visible = true; gwqxwh.Visible = true; ygzhwh.Visible = true; xgdlmm.Visible = true; xtsz.Visible = true; xxfb.Visible = true; lyhf.Visible = true; qyxx.Visible = true; xsywh.Visible = true; dply.Visible = true; dpxx.Visible = true; dpwh.Visible = true; //商品 spxx.Visible = true; spwh.Visible = true; spcxgl.Visible = true; //代理商 jxsxx.Visible = true; jsxsz.Visible = true; //设置 jbsz.Visible = true; xxwh.Visible = true; wddp.Visible = true; //招商 zslb.Visible = true; sylb.Visible = true; dlssy.Visible = true; wdsy.Visible = true; //合同 htlb.Visible = true; //我的桌面 //wdzm.Visible = true; ddglHref.Attributes["href"] = ResolveUrl("../Order/OrderCreateList.aspx"); //ddskHref.Attributes["href"] = ResolveUrl("../Report/CompCollection.aspx"); goodsHref.Attributes["href"] = ResolveUrl("../GoodsNew/GoodsList.aspx"); disHref.Attributes["href"] = ResolveUrl("../SysManager/DisList.aspx"); reportHref.Attributes["href"] = ResolveUrl("../Report/CustSaleRpt.aspx"); sysHref.Attributes["href"] = ResolveUrl("../Pay/PayAccountList.aspx"); zsHref.Attributes["href"] = ResolveUrl("../CMerchants/CMerchantsList.aspx"); htHref.Attributes["href"] = ResolveUrl("../Contract/ContractList.aspx"); } else { //string sql = "select rf.FunCode from SYS_RoleSysFun rf join SYS_CompUser u on u.RoleID=rf.RoleID where u.UserID=" + model.UserID; //DataTable dt = SqlHelper.Query(SqlHelper.LocalSqlServer, sql).Tables[0]; List <Hi.Model.SYS_RoleSysFun> list = new Hi.BLL.SYS_RoleSysFun().GetList(" FunCode ", " CompID=" + model.CompID + " AND RoleID IN (SELECT RoleID FROM dbo.SYS_RoleUser WHERE UserID=" + model.UserID + " AND IsEnabled=1 AND dr=0) GROUP BY FunCode ", ""); for (int i = 0; i < list.Count; i++) { string code = list[i].FunCode.ToString(); switch (code) { //订单 case "10": ddglHref.Attributes["href"] = ResolveUrl("../Order/OrderCreateList.aspx"); break; case "1011": ddlb.Visible = true; break; case "1111": ddskmx.Visible = true; break; //case "1112": // zdskbl.Visible = true; // break; //case "1114": // zdskmx.Visible = true; // break; //case "1115": // qbcx.Visible = true; // break; //商品 case "12": goodsHref.Attributes["href"] = ResolveUrl("../GoodsNew/GoodsInfoList.aspx"); break; case "1210": splb.Visible = true; break; case "1213": spkc.Visible = true; break; case "1214": spfl.Visible = true; break; //case "1215": // jxsjg.Visible = true; // break; case "1216": spsxwh.Visible = true; break; case "1217": spggmb.Visible = true; break; //case "1218": // spbks.Visible = true; // break; case "1219": spcx.Visible = true; break; case "1220": spkc.Visible = true; break; case "1221": sprk.Visible = true; break; case "1223": spck.Visible = true; break; case "1225": sppd.Visible = false; break; case "1227": Dd3.Visible = true; break; case "1232": spcx.Visible = true; break; case "1233": ddcx.Visible = true; break; //代理商 case "13": disHref.Attributes["href"] = ResolveUrl("../SysManager/DisList.aspx"); break; case "1310": jxslb.Visible = true; break; case "1312": jxssh.Visible = true; break; case "1314": jxsgly.Visible = true; break; case "1315": jxsfl.Visible = true; break; case "1316": jxsqy.Visible = true; break; //我的报表 case "14": reportHref.Attributes["href"] = ResolveUrl("../Report/CustSaleRpt.aspx"); break; case "1410": ddtj.Visible = true; break; case "1411": jxstj.Visible = true; break; case "1412": sptj.Visible = true; break; case "1413": zltj.Visible = true; break; case "1414": spxsmx.Visible = true; break; //case "1416": // zhfx.Visible = true; // break; //case "1417": // ddfx.Visible = true; // break; //case "1418": // jxsfx.Visible = true; // break; //case "1419": // cpfx.Visible = true; // break; //case "1420": // cpabcfx.Visible = true; // break; //case "1421": // ysfx.Visible = true; // break; //设置 case "15": sysHref.Attributes["href"] = ResolveUrl("../Pay/PayAccountList.aspx"); break; case "1510": skzhgl.Visible = true; break; case "1511": gwqxwh.Visible = true; break; case "1512": ygzhwh.Visible = true; break; case "1513": xtsz.Visible = true; break; case "1514": xxfb.Visible = true; break; case "1515": lyhf.Visible = true; break; case "1516": qyxx.Visible = true; break; case "1517": xsywh.Visible = true; break; case "1518": dpxx.Visible = true; break; case "1519": dpwh.Visible = true; break; case "1520": dply.Visible = true; break; //招商 case "16": zsHref.Attributes["href"] = ResolveUrl("../CMerchants/CMerchantsList.aspx"); break; case "1611": zslb.Visible = true; break; case "1614": sylb.Visible = true; break; case "1617": dlssy.Visible = true; break; case "1618": wdsy.Visible = true; break; //合同 case "17": htHref.Attributes["href"] = ResolveUrl("../Contract/ContractList.aspx"); break; case "1711": htlb.Visible = true; break; } string[] OrderCode = new string[] { "1011", "1012", "1013", "1015" }; if (OrderCode.Contains(code)) { ddglHref.Attributes["href"] = ResolveUrl("../Order/OrderCreateList.aspx"); } } //我的桌面 //wdzm.Style.Add("display", "none;"); //我要开通 //ktwykt.Style.Add("display", "none;"); } //我要维护,修改登录密码 xgdlmm.Visible = true; //gmfw.Visible = true; } #endregion } }
/// <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; } } }
/// <summary> /// 审核通过 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { Hi.Model.DIS_OrderReturn OrderReturnModel = OrderReturnBll.GetModel(KeyID); string AuditUserID = string.Empty; string AuditDate = string.Empty; string AuditRemark = string.Empty; int pay = 0; if (!string.IsNullOrEmpty(this.hidAuditUserID.Value)) { AuditUserID = this.hidAuditUserID.Value.Trim().ToString(); } //if (!string.IsNullOrEmpty(this.txtArriveDate.Value.Trim().ToString())) //{ // AuditDate = this.txtArriveDate.Value.Trim().ToString(); //} if (!string.IsNullOrEmpty(this.lblArriveDate.InnerText.Trim().ToString())) { AuditDate = this.lblArriveDate.InnerText.Trim().ToString(); } if (!string.IsNullOrEmpty(this.txtRemark.Value.Trim().ToString())) { AuditRemark = this.txtRemark.Value.Trim().ToString(); } if (OrderReturnModel != null) { //判断退货单状态是否正确 if (OrderReturnModel.ReturnState == (int)Enums.AuditState.提交) { Hi.Model.DIS_Order OrderModel = new Hi.BLL.DIS_Order().GetModel(OrderReturnModel.OrderID); if (OrderModel == null) { JScript.AlertMsgOne(this, "订单信息有误!不能通过审核", JScript.IconOption.错误, 2500); return; } int State = 0; string StateRemark = string.Empty; string LogRemark = string.Empty; StateRemark = "退货审核通过"; //订单支付状态 pay = OrderModel.PayState; LogRemark = "退货退款:" + OrderModel.PayedAmount.ToString("N"); //判断订单状态是否正确 if ((OrderModel.OState == (int)Enums.OrderState.已发货 || OrderModel.OState == (int)Enums.OrderState.已到货) && OrderModel.ReturnState == (int)Enums.ReturnState.申请退货) { if (OrderModel.PayState == (int)Enums.PayState.已支付 || pay == (int)Enums.PayState.部分支付) { //订单已支付退货退款 //State = (int)Enums.AuditState.已审; State = (int)Enums.AuditState.已完结; OrderModel.OState = (int)Enums.OrderState.已退货; OrderModel.PayState = (int)Enums.PayState.已退款; OrderModel.ReturnState = (int)Enums.ReturnState.退货退款; } else { //订单未支付退货 OrderModel.OState = (int)Enums.OrderState.已退货; State = (int)Enums.AuditState.已完结; } #region //if (OrderModel.Otype == (int)Enums.OType.赊销订单) //{ //if (OrderModel.PayState == (int)Enums.PayState.已支付 || pay == (int)Enums.PayState.部分支付 || OrderModel.PayState == (int)Enums.PayState.已结算) //{ // //订单已支付退货退款 // //State = (int)Enums.AuditState.已审; // State = (int)Enums.AuditState.已完结; // OrderModel.OState = (int)Enums.OrderState.已退货; // OrderModel.PayState = (int)Enums.PayState.已退款; // OrderModel.ReturnState = (int)Enums.ReturnState.退货退款; //} //else //{ // //订单未支付退货 // OrderModel.OState = (int)Enums.OrderState.已退货; // State = (int)Enums.AuditState.已审; //} //} //else //{ // //OrderModel.OState = (int)Enums.OrderState.退货处理; // //State = (int)Enums.AuditState.已审; // if (OrderModel.PayState == (int)Enums.PayState.已支付 || pay == (int)Enums.PayState.部分支付 || OrderModel.PayState == (int)Enums.PayState.已结算) // { // OrderModel.OState = (int)Enums.OrderState.已退货; // OrderModel.PayState = (int)Enums.PayState.已退款; // OrderModel.ReturnState = (int)Enums.ReturnState.退货退款; // State = (int)Enums.AuditState.已完结; // } // else // { // OrderModel.OState = (int)Enums.OrderState.已退货; // State = (int)Enums.AuditState.已审; // } //} #endregion OrderModel.ts = DateTime.Now; OrderModel.modifyuser = this.UserID; OrderReturnModel.AuditUserID = AuditUserID.ToInt(0); OrderReturnModel.AuditDate = AuditDate.ToDateTime(); OrderReturnModel.AuditRemark = AuditRemark; OrderReturnModel.ReturnState = State; OrderReturnModel.ts = DateTime.Now; OrderReturnModel.modifyuser = this.UserID; #region 把退款金额变为代理商的企业钱包金额 int order = 0; int prepay = 0; SqlConnection con = new SqlConnection(LocalSqlServer); con.Open(); SqlTransaction sqlTrans = con.BeginTransaction(); Hi.Model.PAY_PrePayment PrepayModel = new Hi.Model.PAY_PrePayment(); Hi.BLL.PAY_PrePayment PrepayBLL = new Hi.BLL.PAY_PrePayment(); PrepayModel.CompID = OrderModel.CompID; PrepayModel.DisID = OrderModel.DisID; PrepayModel.OrderID = OrderModel.ID; PrepayModel.Start = 1; PrepayModel.PreType = 4; PrepayModel.price = OrderModel.PayedAmount; //已支付金额 PrepayModel.Paytime = DateTime.Now; PrepayModel.CrateUser = this.UserID; PrepayModel.CreatDate = DateTime.Now; PrepayModel.OldId = 0; PrepayModel.AuditState = 2; PrepayModel.IsEnabled = 1; PrepayModel.AuditUser = this.UserID; PrepayModel.dr = 0; PrepayModel.ts = DateTime.Now; PrepayModel.guid = Common.Number_repeat(""); try { //order = new Hi.BLL.DIS_Order().UpdateOrderByggh(con, OrderModel, sqlTrans, KeyID, (int)Enums.AuditState.已完结); order = OrderInfoType.ReturnOrderUpdate(con, sqlTrans, OrderReturnModel, OrderModel); //if (OrderModel.Otype == (int)Enums.OType.赊销订单) //{ // //支付的订单 生成企业钱包 // if (pay == (int)Enums.PayState.已支付||pay == (int)Enums.PayState.部分支付|| pay == (int)Enums.PayState.已结算) // { // prepay = new Hi.BLL.PAY_PrePayment().InsertPrepay(con, PrepayModel, sqlTrans); // } // else // { // //未支付的订单 不生成企业钱包 // prepay = 1; // } //} //else //{ if (pay == (int)Enums.PayState.已支付 || pay == (int)Enums.PayState.部分支付) { //支付的订单 生成企业钱包 prepay = new Hi.BLL.PAY_PrePayment().InsertPrepay(con, PrepayModel, sqlTrans); //退款减积分 OrderInfoType.AddIntegral(CompID, OrderModel.DisID, "1", 2, OrderModel.ID, OrderModel.PayedAmount, "订单退款", "", this.UserID); } else { //未支付的订单 不生成企业钱包 prepay = 1; } //} sqlTrans.Commit(); } catch { order = 0; prepay = 0; sqlTrans.Rollback(); } finally { con.Close(); } #endregion if (prepay > 0 && order > 0) { if (OrderInfoType.rdoOrderAudit("订单下单数量是否取整", this.CompID) == "0") { //退货审核通过,返还商品库存 string sql = new Hi.BLL.DIS_Order().GetSqlAddInve(OrderModel.ID, null, 0); new Hi.BLL.DIS_Order().UpdateOrderState(sql); } if (pay == (int)Enums.PayState.未支付) { // type : "4":订单发货通知;"3":订单状态变更通知(待发货、审批通过);"2":订单支付通知;"1":下单通知 new Common().GetWxService("44", OrderReturnModel.OrderID.ToString(), "0"); //代理商手机号 string Phone = Common.GetDis(OrderModel.DisID, "Phone"); string msg = "您的订单:" + OrderModel.ReceiptNo + "退货申请已通过!"; //退款向代理商推送信息提示 Common.GetPhone(Phone, msg); } else { //type : "4":订单发货通知;"3":订单状态变更通知(待发货、审批通过);"2":订单支付通知;"1":下单通知 new Common().GetWxService("44", OrderReturnModel.OrderID.ToString(), "0"); new Common().GetWxService("45", OrderReturnModel.OrderID.ToString(), "0"); //代理商手机号 string Phone = Common.GetDis(OrderModel.DisID, "Phone"); string msg = "您的订单:" + OrderModel.ReceiptNo + "退货金额已退回您的企业钱包账户,请查收!"; //退款向代理商推送信息提示 Common.GetPhone(Phone, msg); } Utils.AddSysBusinessLog(this.CompID, "Order", OrderReturnModel.OrderID.ToString(), StateRemark, LogRemark); Response.Write("<script language=\"javascript\">window.parent.AuditReturn('" + Common.DesEncrypt(this.KeyID.ToString(), Common.EncryptKey) + "');</script>"); } } else { JScript.AlertMsgOne(this, "订单信息有误!不能通过审核!", JScript.IconOption.错误, 2500); return; } } else { JScript.AlertMsgOne(this, "数据状态不正确,不能进行审核!", JScript.IconOption.错误, 2500); } } else { JScript.AlertMsgOne(this, "数据不存在!", JScript.IconOption.错误, 2500); } }
/// <summary> /// 绑定数据 /// </summary> public void Bind() { if (KeyID != 0) { string Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", CompID); Hi.Model.BD_Promotion ProModel = ProBll.GetModel(KeyID); if (ProModel != null) { this.lblProTitle.InnerText = ProModel.ProTitle; this.lblProType.InnerText = Common.GetProType(ProModel.ProType.ToString()); pro = ProModel.ProType.ToString(); this.lblProIsEnabled.InnerText = Common.GetIsEnabled(ProModel.IsEnabled.ToString()); this.lblProStartDate.InnerText = ProModel.ProStartTime == DateTime.MinValue ? "" : ProModel.ProStartTime.ToString("yyyy-MM-dd"); this.lblProEndDate.InnerText = ProModel.ProEndTime == DateTime.MinValue ? "" : ProModel.ProEndTime.ToString("yyyy-MM-dd"); this.lblProInfos.InnerText = ProModel.ProInfos; if (ProModel.ProStartTime <= DateTime.Now && ProModel.ProEndTime.AddDays(1) > DateTime.Now) { //促销活动中 //判断是否禁用 if (ProModel.IsEnabled == 0) { //未禁用 this.liEdit.Visible = true; //编辑 this.liDel.Visible = true; //删除 this.liNo.Visible = false; //禁用 this.liOk.Visible = true; //启用 } else { //已禁用 this.liEdit.Visible = false; //编辑 this.liDel.Visible = false; //删除 this.liNo.Visible = true; //禁用 this.liOk.Visible = false; //启用 } } else if (ProModel.ProStartTime > DateTime.Now) { //判断是否禁用 if (ProModel.IsEnabled == 0) { //未禁用 this.liEdit.Visible = true; //编辑 this.liDel.Visible = true; //删除 this.liNo.Visible = false; //禁用 this.liOk.Visible = true; //启用 } else { //已禁用 this.liEdit.Visible = false; //编辑 this.liDel.Visible = false; //删除 this.liNo.Visible = true; //禁用 this.liOk.Visible = false; //启用 } } else { this.liEdit.Visible = true; //编辑 this.liDel.Visible = true; //删除 this.liNo.Visible = false; //禁用 this.liOk.Visible = false; //启用 } //促销活动商品明细 List <Hi.Model.BD_PromotionDetail> gl = ProDBll.GetList("", " CompId=" + this.CompID + " and ProID=" + KeyID, ""); if (gl != null && gl.Count > 0) { if (ProModel.ProType == 3) { lblDisCount.InnerText = "订购数量每满(" + (int)ProModel.Discount + "),获赠品(" + gl[0].GoodsPrice.ToString("#,####" + Digits) + ")个"; } else if (ProModel.ProType == 4) { lblDisCount.InnerText = "在原订货价基础上再打折(" + (int)ProModel.Discount + ")%"; } this.rpDtl.DataSource = gl; this.rpDtl.DataBind(); } } } }
/// <summary> /// 选择商品 /// </summary> /// <param name="Id">商品Id</param> public static void Goods(int Id, int DisId, int CompId) { DataTable dt = null; int ProID = 0; //获取商品信息 Hi.Model.BD_GoodsInfo goodsinfoModel = new Hi.BLL.BD_GoodsInfo().GetModel(Id); string Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", CompId); if (goodsinfoModel != null) { int IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompId).ToInt(0); if (IsInve == 0) { if (goodsinfoModel.Inventory <= 0) { return; } } decimal TinkerPrice = 0; decimal Price = goodsinfoModel.TinkerPrice; if (goodsinfoModel.IsOffline == 1) { //判断是否存在促销活动 优先取促销活动价 ProID = Common.GetPro(goodsinfoModel.GoodsID.ToString(), goodsinfoModel.ID.ToString(), CompId.ToString()); if (ProID == 0) { //判断是否启用代理商价格维护 if (Common.IsDisPrice != "0") { //获取商品价格 List <Hi.Model.BD_GoodsPrice> pl = new Hi.BLL.BD_GoodsPrice().GetList("top 1 *", "DisID=" + DisId + " and CompID=" + CompId + " and GoodsInfoID=" + Id + " and isnull(IsEnabled,0)=1 and ISNULL(dr,0)=0", ""); if (pl != null && pl.Count > 0) { TinkerPrice = pl[0].TinkerPrice.ToString() == "" ? goodsinfoModel.TinkerPrice : pl[0].TinkerPrice; Price = pl[0].TinkerPrice.ToString() == "" ? goodsinfoModel.TinkerPrice : pl[0].TinkerPrice; } else { TinkerPrice = goodsinfoModel.TinkerPrice.ToString() == "" ? 0 : goodsinfoModel.TinkerPrice; Price = goodsinfoModel.TinkerPrice.ToString() == "" ? 0 : goodsinfoModel.TinkerPrice; } } else { TinkerPrice = goodsinfoModel.TinkerPrice.ToString() == "" ? 0 : goodsinfoModel.TinkerPrice; Price = goodsinfoModel.TinkerPrice.ToString() == "" ? 0 : goodsinfoModel.TinkerPrice; } } else { TinkerPrice = Common.GetProPrice(goodsinfoModel.GoodsID.ToString(), goodsinfoModel.ID.ToString(), CompId.ToString()); } } else { Price = 0; TinkerPrice = 0; } //判断是不是赠品 //if (GoodsName(goodsinfoModel.GoodsID, "IsSale") == "1") //{ // TinkerPrice = 0; //} if (HttpContext.Current.Session["GoodsInfo"] == null) { dt = new DataTable(); dt.Columns.Add("Id", typeof(string)); //订单明细Id dt.Columns.Add("DisId", typeof(string)); //代理商Id dt.Columns.Add("CompId", typeof(string)); //企业Id dt.Columns.Add("GoodsID", typeof(Int64)); //商品基本档案ID dt.Columns.Add("GoodsinfoID", typeof(Int64)); //商品ID dt.Columns.Add("BarCode", typeof(string)); //商品编码 dt.Columns.Add("GoodsName", typeof(string)); //商品名称 dt.Columns.Add("GoodsInfos", typeof(string)); //商品属性信息 dt.Columns.Add("Inventory", typeof(decimal)); //商品库存 dt.Columns.Add("Price", typeof(decimal)); //商品价格 dt.Columns.Add("AuditAmount", typeof(decimal)); //审核后价格 dt.Columns.Add("Unit", typeof(string)); //商品计量单位 dt.Columns.Add("Pic", typeof(string)); //商品图片 //dt.Columns.Add("StockNum", typeof(int)); //数据类型为 文本 dt.Columns.Add("GoodsNum", typeof(decimal)); //商品数量 dt.Columns.Add("Remark", typeof(string)); //备注 dt.Columns.Add("vdef1", typeof(string)); //是否促销商品 dt.Columns.Add("vdef2", typeof(string)); //促销商品数量 dt.Columns.Add("vdef3", typeof(string)); //促销Protype dt.Columns.Add("Total", typeof(decimal)); //小计 DataRow dr1 = dt.NewRow(); dr1["Id"] = 0; dr1["DisId"] = DisId; dr1["CompId"] = CompId; dr1["GoodsID"] = goodsinfoModel.GoodsID; dr1["GoodsinfoID"] = Id; dr1["BarCode"] = goodsinfoModel.BarCode; dr1["GoodsName"] = GoodsName(goodsinfoModel.GoodsID, "GoodsName"); dr1["GoodsInfos"] = goodsinfoModel.ValueInfo == "" ? Util.GetSubString(Common.GetGoodsMemo(goodsinfoModel.GoodsID), 30) : goodsinfoModel.ValueInfo; dr1["Price"] = Price; dr1["Inventory"] = goodsinfoModel.Inventory; dr1["Pic"] = GoodsName(goodsinfoModel.GoodsID, "Pic"); dr1["AuditAmount"] = TinkerPrice; dr1["Unit"] = GoodsName(goodsinfoModel.GoodsID, "Unit"); dr1["GoodsNum"] = decimal.Parse(string.Format("{0:N4}", (1).ToString("#,####" + Digits))); dr1["Remark"] = ""; dr1["vdef1"] = ProID; //Common.GetPro(goodsinfoModel.GoodsID, Id.ToString(), CompId.ToString()); dr1["vdef2"] = "0"; dr1["vdef3"] = ""; dr1["Total"] = TinkerPrice * 1; dt.Rows.Add(dr1); } else { dt = HttpContext.Current.Session["GoodsInfo"] as DataTable; DataRow dr2 = dt.NewRow(); dr2["Id"] = 0; dr2["DisId"] = DisId; dr2["CompId"] = CompId; dr2["GoodsID"] = goodsinfoModel.GoodsID; dr2["GoodsinfoID"] = Id; dr2["BarCode"] = goodsinfoModel.BarCode; dr2["GoodsName"] = GoodsName(goodsinfoModel.GoodsID, "GoodsName"); dr2["GoodsInfos"] = goodsinfoModel.ValueInfo == "" ? Util.GetSubString(Common.GetGoodsMemo(goodsinfoModel.GoodsID), 30) : goodsinfoModel.ValueInfo; dr2["Inventory"] = goodsinfoModel.Inventory; dr2["Price"] = Price; dr2["Pic"] = GoodsName(goodsinfoModel.GoodsID, "Pic"); dr2["AuditAmount"] = TinkerPrice; dr2["Unit"] = GoodsName(goodsinfoModel.GoodsID, "Unit"); dr2["GoodsNum"] = decimal.Parse(string.Format("{0:N4}", (1).ToString("#,####" + Digits))); dr2["Remark"] = ""; dr2["vdef1"] = ProID;// Common.GetPro(goodsinfoModel.GoodsID, Id.ToString(), CompId.ToString()); dr2["vdef2"] = "0"; dr2["vdef3"] = ""; dr2["Total"] = TinkerPrice * 1; dt.Rows.Add(dr2); } dt.DefaultView.Sort = "id desc"; HttpContext.Current.Session["GoodsInfo"] = dt; } }
/// <summary> /// 修改是绑定的数据 /// </summary> public void Bind() { //判断是否有权限 if (!Common.PageCompOperable("Order", KeyID, CompID)) { Response.Redirect("../../NoOperable.aspx"); return; } Hi.Model.DIS_Order OrderInfoModel = new Hi.BLL.DIS_Order().GetModel(KeyID); if (OrderInfoModel != null) { hidts.Value = OrderInfoModel.ts.ToString(); //时间戳 this.divGoodsName.InnerText = disBing(CompID.ToString(), OrderInfoModel.DisID.ToString()); //筛选商品 Hi.Model.BD_Distributor model = new Hi.BLL.BD_Distributor().GetModel(OrderInfoModel.DisID); this.txtDisName.Value = model.DisName; //代理商名称 this.txtDisName.Disabled = true; //只读 this.hidDisID.Value = OrderInfoModel.DisID.ToString(); //代理商ID if (Request["type"] + "" != "2" || Fanli == 1) { this.txtRebate.Value = OrderInfoModel.bateAmount.ToString(); //返利金额 } this.txtDate.Value = OrderInfoModel.ArriveDate.ToString("yyyy-MM-dd") == "0001-01-01" ? "" : OrderInfoModel.ArriveDate.ToString("yyyy-MM-dd"); //交货日期 this.lblPsType.InnerText = OrderInfoModel.GiveMode; //配送方式 this.lblPsType2.InnerText = OrderInfoModel.GiveMode == "送货" ? "自提" : "送货"; this.hidPsType.Value = OrderInfoModel.GiveMode; //配送方式 this.OrderNote.Value = OrderInfoModel.Remark; //订单备注 this.hidAdder.Value = OrderInfoModel.Address; //地址 this.hidAddName.Value = OrderInfoModel.Principal; //联系人 this.hidAddPhone.Value = OrderInfoModel.Phone; //联系人电话 this.hrAdder.Value = OrderInfoModel.AddrID.ToString(); //收货地址id this.hrOrderFj.Value = OrderInfoModel.Atta; //附件文件 string str10 = decimal.Parse(string.Format("{0:N2}", OrderInfoModel.PostFee.ToString())).ToString("0.00"); //运费 this.lblPostFee.InnerText = str10; //运费 this.hidPostFree.Value = str10; //运费 //附件 string str3 = string.Empty; //附件信息 if (OrderInfoModel.Atta.ToString() != "") { StringBuilder li = new StringBuilder(); string[] atta = OrderInfoModel.Atta.Split(new string[] { "@@" }, StringSplitOptions.RemoveEmptyEntries); if (atta.Length > 0) { foreach (var item in atta) { string[] att = item.Split(new string[] { "^^" }, StringSplitOptions.RemoveEmptyEntries); li.AppendFormat("<li> <a href=\"javascript:;\" 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)); } } str3 = li.ToString(); } //收货信息 string str = "收货人:" + OrderInfoModel.Principal + ",联系电话:" + OrderInfoModel.Phone + ",收货地址:" + OrderInfoModel.Address; string price = string.Empty;//返利总金额 if (Request.QueryString["type"] + "" == "2") { //再次购买时获取返利总金额 price = OrderType.GetRebate(0, OrderInfoModel.DisID); } else { //其他获取返利总金额 price = OrderType.GetRebate(KeyID, OrderInfoModel.DisID); } //可用返利金额 string str4 = "可用返利¥ <label id=\"lblRebate\">" + string.Format("{0:N2}", price.ToString()) + "</label><i class=\"sus-i seebate\"></i>"; List <Hi.Model.DIS_OrderDetail> ll = new Hi.BLL.DIS_OrderDetail().GetList("", "isnull(dr,0)=0 and orderId=" + KeyID, ""); if (ll.Count > 0) { string html = string.Empty; //绑定的商品数据 int index = 0; //索引 string str8 = "0.00"; //商品小计 foreach (Hi.Model.DIS_OrderDetail obj in ll) { Hi.Model.BD_GoodsInfo model2 = new Hi.BLL.BD_GoodsInfo().GetModel(obj.GoodsinfoID); string kc = string.Empty; decimal newprice = obj.AuditAmount; //判断修改和再次购买时的价格 显示的 decimal newprice2 = obj.GoodsPrice; //判断修改和再次购买时的价格 隐藏的 str8 = decimal.Parse(string.Format("{0:N2}", obj.sumAmount)).ToString("0.00"); //判断修改和再次购买时的小计价格 // decimal str88 = 0;//判断修改和再次购买时的小计价格 隐藏的 if (Request.QueryString["type"] + "" == "2") { //再次 购买时获取库存 kc = model2.Inventory.ToString(); // newprice2 = newprice = BLL.Common.GetGoodsPrice(this.CompID, OrderInfoModel.DisID, obj.GoodsinfoID); // str8 = decimal.Parse(string.Format("{0:N2}", newprice * obj.GoodsNum)).ToString("0.00"); } else { //其他获取库存 kc = (model2.Inventory + obj.GoodsNum + obj.ProNum.ToDecimal(0)).ToString(); } string pic = new Hi.BLL.BD_Goods().GetModel(Convert.ToInt32(model2.GoodsID)).Pic; //图片 string str6 = IsInve == 0 ? "" : "display:none"; //是否显示库存 string str7 = string.Empty; //是否促销 str7 = SelectGoodsInfo.protitle(obj.ProID, obj.Protype, obj.Unit); // ConvertJson.IsCx(dt.Rows[0]["proTypes"].ToString(), dt.Rows[0]["proType"].ToString(), dt.Rows[0]["proGoodsPrice"].ToString(), dt.Rows[0]["proDiscount"].ToString(), dt.Rows[0]["unit"].ToString()); //SelectGoodsInfo.protitle(obj.ProID, obj.Protype, obj.Unit); string Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", this.CompID); //小数位数 decimal num = decimal.Parse(string.Format("{0:N4}", (obj.GoodsNum).ToString("#,####" + Digits))); //购买数量 string str9 = obj.Remark; //goodsInfoid备注 if (obj.Remark != null && obj.Remark.Length > 6) { str9 = obj.Remark.Substring(0, 6) + "..."; } string strremark = string.Empty;//鼠标移上去时显示的备注 if (obj.Remark != "") { strremark = "<div class=\"divremark" + index + "\">" + str9 + "</div><div class=\"cur\">" + obj.Remark + "</div>"; } // decimal zxprice = BLL.Common.GetGoodsPrice(this.CompID, OrderInfoModel.DisID, obj.GoodsinfoID); html += "<tr trindex=\"" + index + "\" trindex2=\"" + index + "\" id=\"" + obj.ID + "\" tip=\"" + obj.GoodsinfoID + "\"><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\">商品编码:" + obj.GoodsCode + str7 + "</a><a href=\"javascript:;\" class=\"name\">" + GetGoodsName(obj.GoodsName, obj.GoodsInfos, "1") + "<i>" + GetGoodsName(obj.GoodsName, obj.GoodsInfos, "2") + "</i></a></div></td><td><div class=\"tc\">" + obj.Unit + "</div></td><td><input type=\"text\" tip2=\"" + index + "\" class=\"boxs divprice" + index + "\" value=\"" + decimal.Parse(string.Format("{0:N2}", newprice)).ToString("0.00") + "\" maxlength=\"9\" ><input type=\"hidden\" class=\"hidPrice\" value=\"" + decimal.Parse(string.Format("{0:N2}", newprice2)).ToString("0.00") + "\" /></td><td style=\"" + str6 + "\"><div class=\"tc\"><input type=\"hidden\" id=\"hidInventory_" + index + "\" value=\"" + decimal.Parse(string.Format("{0:N2}", kc)).ToString(Digits) + "\" />" + decimal.Parse(string.Format("{0:N2}", kc)).ToString(Digits) + "</div></td><td><div class=\"sl divnum\" tip=\"" + obj.GoodsinfoID + "\" tip2=\"" + index + "\"><a href=\"javascript:void(0);\" class=\"minus\">-</a><input type=\"text\" class=\"box txtGoodsNum txtGoodsNum" + index + "\" 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_" + index + "\">¥" + str8 + "</div></td><td><div class=\"tc alink\"><a href=\"javascript:;\" class=\"aremark" + index + "\">" + (obj.Remark == "" ? "添加" : "编辑") + "</a>" + strremark + "</div></td></tr>"; index++; } this.lblTotalAmount.InnerText = decimal.Parse(string.Format("{0:N2}", OrderInfoModel.TotalAmount)).ToString("0.00"); //商品总额 string str2 = string.Empty; //开票信息 List <Hi.Model.DIS_OrderExt> l = new Hi.BLL.DIS_OrderExt().GetList("", "orderID=" + KeyID, ""); if (l.Count > 0) { foreach (Hi.Model.DIS_OrderExt item in l) { this.hrOrderInv.Value = item.DisAccID; //开票Id this.hidLookUp.Value = item.Rise; //发票抬头 this.hidBank.Value = item.OBank; //开会银行 this.hidContext.Value = item.Content; //发票内容 this.hidAccount.Value = item.OAccount; //开户帐号 this.hidRegNo.Value = item.TRNumber; //纳税人登记号 if (item.IsOBill == 0) { str2 = "不开票"; this.hidVal.Value = "0"; } else if (item.IsOBill == 1 && item.OAccount == "" && item.TRNumber == "" && item.OBank == "") { str2 = "发票抬头:" + item.Rise + ",发票内容:" + item.Content; this.hidVal.Value = "1"; } else { str2 = "发票抬头:" + item.Rise + ",发票内容:" + item.Content + ",开户银行:" + item.OBank + ",开户账户:" + item.OAccount + ",纳税人登记号:" + item.TRNumber; this.hidVal.Value = "2"; } this.lblCux.InnerText = decimal.Parse(string.Format("{0:N2}", item.ProAmount.ToString())).ToString("0.00");//订单促销 } } if (Convert.ToDecimal(str8) < 0) { str8 = "0.00"; } if (Request["type"] + "" != "2" || Fanli == 1) { this.lblFanl.InnerText = decimal.Parse(string.Format("{0:N2}", OrderInfoModel.bateAmount.ToString())).ToString("0.00");//返利金额 } ClientScript.RegisterStartupScript(this.GetType(), "adder", "<script>$(function(){$(\".site .site-if\").text(\"" + str + "\");$(\".invoice .in-if\").text(\"" + str2 + "\");$(\".attach .list\").html(\"" + str3.Replace("\"", "'") + "\");$(\".edit-ok .txt\").html(\"" + str4.Replace("\"", "'") + "\"); $(\".tabLine table tbody\").html(\"" + html.Replace("\"", "'") + "\"); $(\"#lblYFPrice\").text(\"" + decimal.Parse(string.Format("{0:N2}", (Request["type"] + "" == "2" && Fanli == 0 ? OrderInfoModel.AuditAmount + OrderInfoModel.bateAmount : OrderInfoModel.AuditAmount))).ToString("0.00") + "\"); $(\".jxs-box .opt-i\").hide();})</script>"); } } }
/// <summary> /// 订单商品明细 /// </summary> /// <param name="Id">订单Id</param> public static void OrderDetail(int Id, int DisId, int CompId) { HttpContext.Current.Session["GoodsInfo"] = null; List <Hi.Model.DIS_OrderDetail> l = OrderDetailBll.GetList("", " isnull(dr,0)=0 and OrderId=" + Id, "Id desc"); string Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", CompId); if (l != null && l.Count > 0) { DataTable dt = null; foreach (Hi.Model.DIS_OrderDetail item in l) { //获取商品信息 Hi.Model.BD_GoodsInfo goodsinfoModel = new Hi.BLL.BD_GoodsInfo().GetModel(item.GoodsinfoID); if (goodsinfoModel != null) { //获取商品价格 //List<Hi.Model.BD_GoodsPrice> pl = new Hi.BLL.BD_GoodsPrice().GetList("top 1 *", "DisID=" + DisId + " and CompID=" + CompId + " and GoodsInfoID=" + item.GoodsinfoID + " and IsEnabled=1 and ISNULL(dr,0)=0", ""); //if (pl != null) //{ // if (pl.Count > 0) // { //} //} if (HttpContext.Current.Session["GoodsInfo"] == null) { dt = new DataTable(); dt.Columns.Add("Id", typeof(string)); //订单明细Id dt.Columns.Add("DisId", typeof(string)); //代理商Id dt.Columns.Add("CompId", typeof(string)); //企业Id dt.Columns.Add("GoodsID", typeof(Int64)); //商品基本档案ID dt.Columns.Add("GoodsinfoID", typeof(Int64)); //商品ID dt.Columns.Add("BarCode", typeof(string)); //商品编码 dt.Columns.Add("GoodsName", typeof(string)); //商品名称 dt.Columns.Add("GoodsInfos", typeof(string)); //商品属性信息 dt.Columns.Add("Price", typeof(decimal)); //商品价格 dt.Columns.Add("Inventory", typeof(decimal)); //商品库存 dt.Columns.Add("AuditAmount", typeof(decimal)); //审核后价格 dt.Columns.Add("Unit", typeof(string)); //商品计量单位 dt.Columns.Add("Pic", typeof(string)); //商品图片 //dt.Columns.Add("StockNum", typeof(int)); //数据类型为 文本 dt.Columns.Add("GoodsNum", typeof(decimal)); //商品数量 dt.Columns.Add("Remark", typeof(string)); //备注 dt.Columns.Add("vdef1", typeof(string)); //是否促销商品 dt.Columns.Add("vdef2", typeof(string)); //促销商品数量 dt.Columns.Add("vdef3", typeof(string)); //促销Protype dt.Columns.Add("Total", typeof(decimal)); //小计 DataRow dr1 = dt.NewRow(); dr1["Id"] = item.ID; dr1["DisId"] = DisId; dr1["CompId"] = CompId; dr1["GoodsID"] = goodsinfoModel.GoodsID; dr1["GoodsinfoID"] = goodsinfoModel.ID; dr1["BarCode"] = goodsinfoModel.BarCode; dr1["GoodsName"] = GoodsName(goodsinfoModel.GoodsID, "GoodsName"); dr1["GoodsInfos"] = item.GoodsInfos == "" ? Util.GetSubString(Common.GetGoodsMemo(goodsinfoModel.GoodsID), 30) : item.GoodsInfos; dr1["Price"] = item.Price; dr1["Inventory"] = goodsinfoModel.Inventory + item.GoodsNum; dr1["Pic"] = GoodsName(goodsinfoModel.GoodsID, "Pic"); dr1["AuditAmount"] = item.AuditAmount; dr1["Unit"] = GoodsName(goodsinfoModel.GoodsID, "Unit"); dr1["GoodsNum"] = decimal.Parse(string.Format("{0:N4}", item.GoodsNum.ToString("#,####" + Digits))); dr1["Remark"] = item.Remark; if (item.vdef1 != null) { dr1["vdef1"] = item.vdef1.ToString() == "" ? "0" : item.vdef1.ToString(); } else { dr1["vdef1"] = "0"; } if (item.vdef5 != "") { dr1["vdef2"] = decimal.Parse(string.Format("{0:N4}", Convert.ToDecimal(item.vdef5).ToString("#,####" + Digits))); } else { dr1["vdef2"] = "0"; } //dr1["vdef3"] = item.vdef6; dr1["Total"] = item.sumAmount; dt.Rows.Add(dr1); } else { dt = HttpContext.Current.Session["GoodsInfo"] as DataTable; DataRow dr2 = dt.NewRow(); dr2["Id"] = item.ID; dr2["DisId"] = DisId; dr2["CompId"] = CompId; dr2["GoodsID"] = goodsinfoModel.GoodsID; dr2["GoodsinfoID"] = goodsinfoModel.ID; dr2["BarCode"] = goodsinfoModel.BarCode; dr2["GoodsName"] = GoodsName(goodsinfoModel.GoodsID, "GoodsName"); dr2["GoodsInfos"] = item.GoodsInfos == "" ? Util.GetSubString(Common.GetGoodsMemo(goodsinfoModel.GoodsID), 30) : item.GoodsInfos; dr2["Price"] = item.Price; dr2["Inventory"] = goodsinfoModel.Inventory + item.GoodsNum; dr2["Pic"] = GoodsName(goodsinfoModel.GoodsID, "Pic"); dr2["AuditAmount"] = item.AuditAmount; dr2["Unit"] = GoodsName(goodsinfoModel.GoodsID, "Unit"); dr2["GoodsNum"] = decimal.Parse(string.Format("{0:N4}", item.GoodsNum.ToString("#,####" + Digits))); dr2["Remark"] = item.Remark; if (item.vdef1 != null) { dr2["vdef1"] = item.vdef1.ToString() == "" ? "0" : item.vdef1.ToString(); } else { dr2["vdef1"] = "0"; } if (item.vdef5 != "") { dr2["vdef2"] = decimal.Parse(string.Format("{0:N4}", Convert.ToDecimal(item.vdef5).ToString("#,####" + Digits))); } else { dr2["vdef2"] = "0"; } //dr2["vdef3"] = item.vdef6; dr2["Total"] = item.sumAmount; dt.Rows.Add(dr2); } dt.DefaultView.Sort = "id desc"; HttpContext.Current.Session["GoodsInfo"] = dt; } } } }
/// <summary> /// 修改订单 /// </summary> /// <param name="OrderInfoModel"></param> /// <param name="OrderDetailList"></param> /// <returns></returns> public static int UpdateOrder(DateTime dts, Hi.Model.DIS_Order OrderInfoModel, Hi.Model.DIS_OrderExt OrderExt, List <Hi.Model.DIS_OrderDetail> OrderDetailList, string delOrderD) { //判断订单时间 if (new Hi.BLL.DIS_Order().Getts("Dis_Order", OrderInfoModel.ID, dts) == 0) { return(-1); } int OrderId = 0; //返回修改库存的sql System.Text.StringBuilder sqlInven = new System.Text.StringBuilder(); int IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", OrderInfoModel.CompID).ToInt(0); if (IsInve == 0) { //修改商品库存,先返还订单明细删除的商品库存 sqlInven.AppendFormat(new Hi.BLL.DIS_Order().GetSqlInventory(delOrderD, OrderDetailList)); } //SqlConnection con = new SqlConnection(LocalSqlServer); //con.Open(); //System.Data.IsolationLevel.RepeatableRead SqlTransaction sqlTrans = DBUtility.SqlHelper.CreateStoreTranSaction(); //可以做循环 try { //private object thislock = OrderInfoModel.ID as object; //lock (thislock) //{ OrderId = OrderBll.UpdateOrder(sqlTrans.Connection, OrderInfoModel, sqlTrans); if (OrderDetailList.Count <= 0) { OrderId = 0; sqlTrans.Rollback(); } else { if (OrderExt != null) { //修改订单扩展表 if (!OrderExtBll.Update(sqlTrans.Connection, OrderExt, sqlTrans)) { OrderId = 0; sqlTrans.Rollback(); } } if (!delOrderD.Equals("")) { //修改时 删除商品后 清除在数据库中存在的该商品 if (OrderDetailBll.GetDel(delOrderD, sqlTrans.Connection, sqlTrans) < 0) { OrderId = 0; sqlTrans.Rollback(); } } foreach (Hi.Model.DIS_OrderDetail item in OrderDetailList) { Hi.Model.DIS_OrderDetail OrderDeModel = OrderDetailBll.GetModel(item.ID); int count = 0; if (OrderDeModel != null) { if (IsInve == 0) { //修改订单明细时,先返还商品库存 sqlInven.AppendFormat("update BD_GoodsInfo set Inventory+={0} where ID={1};", OrderDeModel.GoodsNum + Convert.ToDecimal(OrderDeModel.ProNum), OrderDeModel.GoodsinfoID); } item.OrderID = OrderInfoModel.ID; //修改订单时,订单明细里存在该商品 修改商品信息 count = OrderDetailBll.UpdateOrderDetail(sqlTrans.Connection, item, sqlTrans); if (count == 0) { OrderId = 0; sqlTrans.Rollback(); } } else { //修改订单时,订单明细里不存在该商品新增商品信息 item.OrderID = OrderInfoModel.ID; count = OrderDetailBll.AddOrderDetail(sqlTrans.Connection, item, sqlTrans); if (count == 0) { OrderId = 0; sqlTrans.Rollback(); } } } if (IsInve == 0) { //修改商品库存,先返还订单明细删除的商品库存 //sqlInven.AppendFormat(new Hi.BLL.DIS_Order().GetSqlInventory(delOrderD, OrderDetailList)); if (new Hi.BLL.DIS_OrderDetail().GetUpdateInventory(sqlInven.ToString(), sqlTrans.Connection, sqlTrans) <= 0) { OrderId = 0; sqlTrans.Rollback(); } } if (OrderInfoType.rdoOrderAudit("订单支付返利是否启用", OrderInfoModel.CompID) == "1") { //订单支付返利启用 if (bate.TransEditRebate(OrderInfoModel.DisID, OrderInfoModel.bateAmount, OrderInfoModel.ID, OrderInfoModel.CreateUserID, sqlTrans)) { sqlTrans.Commit(); return(OrderId); } } sqlTrans.Commit(); } //} } catch { OrderId = 0; sqlTrans.Rollback(); } finally { } return(OrderId); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.hidType2.Value = Request.QueryString["type"] + ""; this.hidDisID.Value = this.DisID.ToString(); this.hidKeyId.Value = KeyID.ToString(); StringBuilder strwhere = new StringBuilder(); Fanli = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", CompID).ToInt(0); this.hidFanl.Value = Fanli.ToString(); LoginModel logUser = Session["UserModel"] as LoginModel; Common.ListComps(this.ddrComp, this.UserID.ToString(), this.CompID.ToString()); this.hidCompId.Value = this.ddrComp.Value.ToString(); decimal CreditAmount = 0; if (BLL.Common.GetCredit(this.hidCompId.Value.ToString().ToInt(0), logUser.DisID, out CreditAmount)) { decimal GetSumAmount = OrderInfoType.GetSumAmount(logUser.DisID.ToString(), this.hidCompId.Value.ToString(), KeyID); if (GetSumAmount >= CreditAmount) { this.Msg.InnerHtml = "您的授信额度(" + CreditAmount + ")已用完或超出!无法下单"; this.Btn.InnerHtml = "<a href=\"javascript:; \" class=\"gray-btn2\">取消</a>"; } else { this.Msg.InnerHtml = ""; } } else { this.Msg.InnerHtml = ""; } // isbate = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", CompID).ToInt(0); //if (Fanli == 0) //{ // this.trbate.Visible = false; // this.rebate.Visible = false; //} //商品是否启用库存 IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", this.CompID).ToInt(0); if (IsInve == 0) { strwhere.AppendFormat("and info.Inventory>0"); } DataTable dt = SqlHelper.Query(SqlHelper.LocalSqlServer, SelectGoodsInfo.Returnsql(CompID.ToString(), DisID.ToString(), strwhere.ToString(), "1")).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(CompID, 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; } } } this.divGoodsName.InnerText = ConvertJson.ToJson2(dt); //代理商列表 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(); } else { if ((Request.QueryString["type"] + "") == "1") { this.hidType.Value = Request.QueryString["type"] + ""; ShopCart(); } } } }
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 void Bind() { //首次进行页面清除Session Session.Remove("GoodsPrice"); if (KeyID != 0) { string Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", CompID); Hi.Model.BD_Promotion ProModel = ProBll.GetModel(KeyID); //促销公告 List <Hi.Model.BD_CompNews> newsl = new Hi.BLL.BD_CompNews().GetList("", " PMID=" + KeyID + "and isnull(IsEnabled,0)=1", ""); if (ProModel != null) { this.txtPromotiontitle.Value = ProModel.ProTitle; this.txtPromotionDate.Value = ProModel.ProStartTime == DateTime.MinValue ? "" : ProModel.ProStartTime.ToString("yyyy-MM-dd"); this.txtPromotionDate1.Value = ProModel.ProEndTime == DateTime.MinValue ? "" : ProModel.ProEndTime.ToString("yyyy-MM-dd"); this.txtProInfos.Value = ProModel.ProInfos; if (newsl != null && newsl.Count > 0) { this.isOkComNews.Checked = true; this.isNoComNews.Checked = false; } else { this.isOkComNews.Checked = false; this.isNoComNews.Checked = true; } //促销方式 if (ProModel.ProType == 3) { this.promotionType3.Checked = true; this.txtSendFull.Value = string.Format("{0:N4}", ProModel.Discount.ToString("#,####" + Digits)); } else { this.promotionType4.Checked = true; this.txtDiscount.Value = string.Format("{0:N4}", ProModel.Discount.ToString("#,####" + Digits)); } //促销禁用 if (ProModel.IsEnabled == 0) { this.IsEnabled0.Checked = true; } else { this.IsEnabled1.Checked = true; } decimal count = 0; //促销活动商品明细 List <Hi.Model.BD_PromotionDetail> gl = ProDBll.GetList("", " CompId=" + this.CompID + " and ProID=" + KeyID, ""); if (gl != null && gl.Count > 0) { List <Hi.Model.BD_GoodsInfo> ll = new List <Hi.Model.BD_GoodsInfo>(); Hi.Model.BD_GoodsInfo model = null; foreach (var item in gl) { model = new Hi.Model.BD_GoodsInfo(); model.CompID = this.CompID; model.IsEnabled = true; model.CreateUserID = this.UserID; model.CreateDate = DateTime.Now; model.ts = DateTime.Now; model.modifyuser = this.UserID; model.ID = item.GoodInfoID; model.GoodsID = item.GoodsID; model.SalePrice = GoodsPrice(item.GoodInfoID.ToString()); model.TinkerPrice = item.GoodsPrice; //促销价 count = item.GoodsPrice; ll.Add(model); } if (ProModel.ProType == 3) { //满送 this.txtSendNum.Value = string.Format("{0:N4}", count.ToString("#,####" + Digits)); } Session["GoodsPrice"] = ll; this.rpDtl.DataSource = ll; this.rpDtl.DataBind(); } } } else { this.rpDtl.DataSource = ""; this.rpDtl.DataBind(); } }