/// <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();
}
}
