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