/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(KeyID); try { string BillNo = this.txtBillNo.Value.Trim(); string IsBill = this.rdoIsBillOk.Checked ? "1" : "0"; if (OrderModel != null) { //if (OrderModel.IsBill == 0) //{ // OrderModel.BillNo = BillNo; // OrderModel.IsBill = IsBill.ToInt(0); // if (OrderBll.Update(OrderModel)) // { // Response.Write("<script language=\"javascript\">window.parent.Audit('" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey) + "');</script>"); // } //} //else // JScript.AlertMsgOne(this, "发票信息已完成,不能再保存!", JScript.IconOption.错误, 2500); } else { JScript.AlertMsgOne(this, "数据不存在!", JScript.IconOption.错误, 2500); } } catch (Exception ex) { JScript.AlertMsgOne(this, "保存失败!", JScript.IconOption.错误, 2500); } }
/// <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> protected void btnReturn_Click(object sender, EventArgs e) { if (Request.QueryString["Id"] != null) { Id = Convert.ToInt32(Request.QueryString["Id"]); } Hi.Model.DIS_Order OrderInfoModel = OrderInfoBll.GetModel(Id); if (OrderInfoModel != null) { if (OrderInfoModel.OState > (int)Enums.OrderState.未提交) { string sql = " update [DIS_Order] set [OState]=" + (int)Enums.OrderState.退回 + " where ID=" + Id; if (OrderInfoBll.UpdateOrderState(sql)) { //Utils.AddSysBusinessLog(this.CompID, "Order", Id.ToString(), "退回", ""); Bind(); } } } else { JScript.ShowAlert(this, "数据不存在!"); } }
/// <summary> /// 审核 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAudit_Click(object sender, EventArgs e) { Hi.Model.DIS_Order OrderInfoModel = OrderInfoBll.GetModel(KeyID); if (OrderInfoModel != null) { if (OrderInfoModel.OState == (int)Enums.OrderState.待审核) { string sql = " update [DIS_Order] set [OState]=" + (int)Enums.OrderState.已审 + " where ID=" + KeyID; if (OrderInfoBll.UpdateOrderState(sql)) { Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "审核通过", ""); Bind(); } } else { JScript.AlertMsgOne(this, "数据状态不正确,不能进行审核!", JScript.IconOption.错误, 2500); } } else { JScript.AlertMsgOne(this, "数据不存在", JScript.IconOption.错误, 2500); } }
/// <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 rptOrder_ItemCommand(object source, RepeaterCommandEventArgs e) { string type = e.CommandName; Id = Convert.ToInt32(e.CommandArgument); if (type == "del") { Hi.Model.DIS_Order OrderInfoModel = OrderInfoBLL.GetModel(Id); if (OrderInfoModel != null) { if (OrderInfoModel.OState == (int)Enums.OrderState.退回 || OrderInfoModel.OState == (int)Enums.OrderState.未提交) { OrderInfoModel.dr = 1; bool falg = OrderInfoBLL.OrderDel(OrderInfoModel); if (falg) { //JScript.ShowAlert(this, ""); Bind(); } } else { JScript.AlertMsgOne(this, "订单处理中,不能删除!", JScript.IconOption.错误); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hid_start.Value = Request.QueryString["start"] + ""; int state = Convert.ToInt32(Request.QueryString["start"]); if (state == 2 || state == 0) { btnSave.Text = "发货"; } else if (state == 1) { btnSave.Text = "销账"; } Hi.Model.DIS_Order OrdModel = new Hi.Model.DIS_Order(); OrdModel = new Hi.BLL.DIS_Order().GetModel(KeyID); this.txtdisname.InnerText = new Hi.BLL.BD_Distributor().GetModel(OrdModel.DisID).DisName; this.hidDisId.Value = OrdModel.DisID.ToString(); this.txtordercode.InnerText = OrdModel.ReceiptNo; this.hidordid.Value = OrdModel.ID.ToString(); this.txtPayCorrectPrice.InnerText = (OrdModel.AuditAmount - OrdModel.PayedAmount).ToString("0.00"); this.hidCompId.Value = this.CompID.ToString(); //Bind(); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["KeyID"] == "") { KeyID = 0; } else { KeyID = Common.DesDecrypt(Request.QueryString["KeyID"], Common.EncryptKey).ToInt(0); } Cmpid = this.CompID; if (!Common.PageDisOperable("Order", KeyID, this.DisID)) { Response.Redirect("../../NoOperable.aspx", true); return; } if (!IsPostBack) { Bind(); //绑定 orderModel = new Hi.BLL.DIS_Order().GetModel(KeyID); BindPaySettings(orderModel.CompID); //给页面隐藏域赋值 } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(KeyID); if (OrderModel != null) { //this.txtBillNo.Value = OrderModel.BillNo; //if (OrderModel.IsBill == 1) //{ // this.txtBillNo.Attributes["readonly"] = "readonly"; // this.rdoIsBillNo.Attributes["disabled"] = "true"; // this.rdoIsBillOk.Attributes["disabled"] = "true"; // this.rdoIsBillOk.Checked = true; // this.rdoIsBillNo.Checked = false; // this.Save.Visible = false; //} //else //{ // this.rdoIsBillOk.Checked = false; // this.rdoIsBillNo.Checked = true; //} } } }
protected void Bind() { this.txtDisUser.InnerText = Common.GetUserName(this.UserID); this.hidDisUserId.Value = this.UserID.ToString(); if (KeyID != 0) { if (!Common.PageCompOperable("Order", KeyID, CompID)) { Response.Redirect("../../NoOperable.aspx"); return; } Hi.Model.DIS_Order OrderInfoModel = OrderInfoBll.GetModel(KeyID); if (OrderInfoModel != null) { string js = "<script language=javascript>history.go(-1);</script>"; //编辑订单时 判断订单状态 if (OrderInfoModel.AddType == (int)Enums.AddType.企业补单 || OrderInfoModel.AddType == (int)Enums.AddType.App企业补单) { //企业补单 if (OrderInfoModel.OState >= (int)Enums.OrderState.已审 && OrderInfoModel.PayState != (int)Enums.PayState.未支付) { HttpContext.Current.Response.Write(string.Format(js)); } } else { //App下单 网页下单 if (OrderInfoModel.OState >= (int)Enums.OrderState.待审核) { HttpContext.Current.Response.Write(string.Format(js)); } } this.lblReceiptNo.InnerText = OrderInfoModel.ReceiptNo; DisId = OrderInfoModel.DisID; this.hidTotalAmount.Value = OrderInfoModel.TotalAmount.ToString("N"); this.txtArriveDate.Value = OrderInfoModel.ArriveDate == DateTime.MinValue ? "" : OrderInfoModel.ArriveDate.ToString("yyyy-MM-dd"); this.txtDisUser.InnerText = Common.GetUserName(OrderInfoModel.DisUserID); this.hidDisUserId.Value = OrderInfoModel.DisUserID.ToString(); this.txtRemark.Value = OrderInfoModel.Remark; } } else { //清除商品数据 SelectGoods.Clear(); } }
/// <summary> /// 菜单操作 /// </summary> /// <param name="Oid"></param> /// <param name="PageIndex"></param> /// <returns></returns> public string OrderMeau(string Oid) { string Str_Meau = ""; Oid = Server.UrlDecode(Oid); string id = Common.DesDecrypt(Oid, Common.EncryptKey); if (id == "") { return(""); } Hi.Model.DIS_Order OrderModel = OrderInfoBLL.GetModel(id.ToString().ToInt(0)); if (OrderModel != null) { if (this.Erptype == 0) { //非U8、U9等用户 可以对订单进行操作 if (OrderModel.OState == (int)Enums.OrderState.待审核) { //if (Common.HasRight(this.CompID,this.UserID, "1012")) //Str_Meau += "<a class='tablelinkQx' style='cursor: pointer;' onclick='return RegionAudit(\"" + Server.UrlEncode(Oid) + "\")'>审核</a>"; Str_Meau += "<a class='tablelinkQx' style='cursor: pointer;' href='../newOrder/orderdetail.aspx?top=1&KeyID=" + Server.UrlEncode(Oid) + "'>详情</a>"; } //else if (OrderModel.OState == (int)Enums.OrderState.已发货){ } else if (OrderModel.OState == (int)Enums.OrderState.已审 && (OrderModel.PayState == (int)Enums.PayState.已支付 || OrderModel.PayState == (int)Enums.PayState.部分支付 || OrderModel.Otype == (int)Enums.OType.赊销订单) && OrderModel.ReturnState == (int)Enums.ReturnState.未退货) { //if (Common.HasRight(this.CompID,this.UserID, "1013")) //Str_Meau += "<a class='tablelinkQx' style='cursor: pointer;' onclick='return ship(\"" + Server.UrlEncode(Oid) + "\"," + OrderInfoType.JuOrder(id.ToInt(0)) + ")'>发货</a>"; Str_Meau += "<a class='tablelinkQx' style='cursor: pointer;' href='../newOrder/orderdetail.aspx?top=1&KeyID=" + Server.UrlEncode(Oid) + "'>详情</a>"; } else if ((OrderModel.OState == (int)Enums.OrderState.已审) && (OrderModel.Otype != (int)Enums.OType.赊销订单 || OrderModel.PayState == (int)Enums.PayState.未支付) && OrderModel.ReturnState == (int)Enums.ReturnState.未退货) { Str_Meau += "<a class='tablelinkQx' style='cursor: pointer;' href='../newOrder/orderdetail.aspx?top=1&KeyID=" + Server.UrlEncode(Oid) + "'>详情</a>"; } else { Str_Meau += "<a class='tablelinkQx' style='cursor: pointer;' href='../newOrder/orderdetail.aspx?top=1&KeyID=" + Server.UrlEncode(Oid) + "'>详情</a>"; } } else { //U8、U9等用户 不能对订单进行操作 Str_Meau += "<a class='tablelinkQx' style='cursor: pointer;' href='../newOrder/orderdetail.aspx?top=1&KeyID=" + Server.UrlEncode(Oid) + "'>详情</a>"; } } return(Str_Meau); }
/// <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); } } }
public static string Edit(string KeyID, string type, string remark) { remark = Common.NoHTML(remark); Common.ResultMessage Msg = new Common.ResultMessage(); if (type == "0") { Hi.BLL.DIS_Order OrderBll = new Hi.BLL.DIS_Order(); int oID = Common.DesDecrypt(KeyID, Common.EncryptKey).ToInt(0); Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(oID); if (OrderModel != null) { OrderModel.Remark = Common.NoHTML(remark); OrderModel.ts = DateTime.Now; if (OrderBll.Update(OrderModel)) { Msg.result = true; Msg.code = OrderModel.ts.ToString("yyyy-MM-dd HH:mm"); } } else { Msg.code = "未查找到数据"; } } else if (type == "1") { Hi.BLL.DIS_OrderDetail OrderBllDetail = new Hi.BLL.DIS_OrderDetail(); Hi.Model.DIS_OrderDetail OrderModelDetail = OrderBllDetail.GetModel(KeyID.ToInt(0)); if (OrderModelDetail != null) { OrderModelDetail.Remark = Common.NoHTML(remark); OrderModelDetail.ts = DateTime.Now; if (OrderBllDetail.Update(OrderModelDetail)) { Msg.result = true; } } } else { Msg.result = true; } return(new JavaScriptSerializer().Serialize(Msg)); }
public static string Edit(string KeyID, string type, string tip) { Common.ResultMessage Msg = new Common.ResultMessage(); Hi.BLL.DIS_Order OrderBll = new Hi.BLL.DIS_Order(); Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(Common.DesDecrypt(KeyID, Common.EncryptKey).ToInt(0)); if (OrderModel != null) { if (OrderModel.OState == -1 || OrderModel.OState == 0 || OrderModel.OState == 1 || OrderModel.OState == 2) { if (type == "0") { if (tip != "") { OrderModel.ArriveDate = tip.ToDateTime(); } else { OrderModel.ArriveDate = DateTime.MinValue; } OrderModel.ts = DateTime.Now; if (OrderBll.Update(OrderModel)) { Msg.result = true; } } else { OrderModel.GiveMode = tip; OrderModel.ts = DateTime.Now; if (OrderBll.Update(OrderModel)) { Msg.result = true; } } } } else { Msg.code = "未查找到数据"; } return(new JavaScriptSerializer().Serialize(Msg)); }
public void rptOrder_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { Hi.Model.DIS_Order drv = (Hi.Model.DIS_Order)e.Item.DataItem; ta += Convert.ToDecimal(drv.AuditAmount); tb += Convert.ToDecimal(drv.PayedAmount); } if (e.Item.ItemType == ListItemType.Footer) { if (e.Item.FindControl("total1") != null) { Label tol1 = (Label)e.Item.FindControl("total1"); tol1.Text = string.Format("{0}", ta.ToString("N")); } if (e.Item.FindControl("total2") != null) { Label tol2 = (Label)e.Item.FindControl("total2"); tol2.Text = string.Format("{0}", tb.ToString("N")); } } }
/// <summary> /// 取消订单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnOff_Click(object sender, EventArgs e) { Hi.Model.DIS_Order OrderModel = OrderBll.GetModel(KeyID); if (OrderModel != null) { if ((OrderModel.OState == (int)Enums.OrderState.已审 || OrderModel.OState == (int)Enums.OrderState.待审核) && OrderModel.PayState == (int)Enums.PayState.未支付) { string sql = " update [DIS_Order] set [OState]=" + (int)Enums.OrderState.已作废 + " where ID=" + KeyID; if (OrderBll.UpdateOrderState(sql)) { Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "订单作废", ""); //Bind(); Response.Redirect("neworder/orderdetail.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey)); } } else { JScript.AlertMsgOne(this, "数据状态不正确,无法取消!", JScript.IconOption.错误); } } }
/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { if (Request.QueryString["Id"] != null) { Id = Convert.ToInt32(Request.QueryString["Id"]); } Hi.Model.DIS_Order OrderInfoModel = OrderInfoBll.GetModel(Id); if (OrderInfoModel != null) { if (OrderInfoModel.OState == (int)Enums.OrderState.未提交 || OrderInfoModel.OState == (int)Enums.OrderState.退回) { int OState = 1; if (OrderInfoModel.IsAudit == 1) { //无需审核 OState = (int)Enums.OrderState.已审; } string sql = " update [DIS_Order] set [OState]=" + OState + " where ID=" + Id; if (OrderInfoBll.UpdateOrderState(sql)) { //Utils.AddSysBusinessLog(this.CompID, "Order", Id.ToString(), "提交", ""); Bind(); } } else { JScript.ShowAlert(this, "数据状态不正确,不能进行审核!"); } } else { JScript.ShowAlert(this, "数据不存在!"); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDel_Click(object sender, EventArgs e) { Hi.Model.DIS_Order OrderInfoModel = OrderBll.GetModel(KeyID); if (OrderInfoModel != null) { bool del = false; //if (OrderInfoModel.AddType == (int)Enums.AddType.企业补单) //{ // if (OrderInfoModel.OState == (int)Enums.OrderState.已提交) // del = true; //} //else //{ //} //判断订单状态是否能删除 if (OrderInfoModel.OState == (int)Enums.OrderState.退回 || OrderInfoModel.OState == (int)Enums.OrderState.已作废 || OrderInfoModel.OState == (int)Enums.OrderState.未提交) { del = true; } if (del) { OrderInfoModel.dr = 1; bool falg = OrderBll.OrderDel(OrderInfoModel); if (falg) { Utils.AddSysBusinessLog(this.CompID, "Order", KeyID.ToString(), "订单删除", ""); //JScript.AlertMsg(this, "订单删除成功!", "OrderList.aspx"); ClientScript.RegisterStartupScript(this.GetType(), "del", "<script>window.location.href = 'OrderList.aspx'</script>"); } } else { JScript.AlertMsgOne(this, "订单处理中,不能删除!", JScript.IconOption.错误); } } }
/// <summary> /// 获取推送用户的别名 /// </summary> /// <param name="order"></param> /// <param name="userType">0:推送给经销商 1:推送给企业</param> /// <returns></returns> public string[] GetUserAlias(Hi.Model.DIS_Order order, string userType) { List <Hi.Model.SYS_CompUser> userList = new List <Hi.Model.SYS_CompUser>(); switch (userType.Trim()) { case "0": userList = new Hi.BLL.SYS_CompUser().GetList("", " compID='" + order.CompID + "' and IsAudit = 2 and disID='" + order.DisID + "' and dr=0 and IsEnabled=1 and (Utype=1 or Utype =5)", ""); break; case "1": userList = new Hi.BLL.SYS_CompUser().GetList("", " compID='" + order.CompID + "' and IsAudit = 2 and dr=0 and IsEnabled=1 and Utype between 3 and 4", ""); break; case "2": userList = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and IsAudit = 2 and IsEnabled=1 and Utype in (1,3,4,5)", ""); break; default: return(null); } if (userList == null || userList.Count == 0) { return(null); } string[] arr = new String[userList.Count]; for (int i = 0; i < userList.Count; i++) { arr[i] = AESHelper.Encrypt_MD5(userList[i].ID.ToString()); } return(arr); }
//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> /// <param name="user"></param> /// <param name="order"></param> /// <param name="sendType"></param> /// <returns></returns> public string GetAlertContent(Hi.Model.DIS_Order order, string sendType) { string res = string.Empty; switch (sendType) { case "1": //下单通知 StringBuilder strSql = new StringBuilder(); strSql.Append("您有一条新的订单消息。"); //strSql.Append("您好,您有一条新的订单("); //strSql.Append(order.ReceiptNo); //strSql.Append(")。"); res = strSql.ToString(); break; case "2": //订单支付通知 StringBuilder str = new StringBuilder(); if (order.Otype == 9) { str.Append("您收到一笔账单付款。"); } else { str.Append("您收到一笔订单付款。"); } //str.Append("您好,您有一条订单("); //str.Append(order.ReceiptNo); //str.Append(")已支付。"); res = str.ToString(); break; case "3": //签收提醒 StringBuilder SIGN = new StringBuilder(); //SIGN.Append("您好,您有一条订单("); //SIGN.Append(order.ReceiptNo); //SIGN.Append(")已签收。"); SIGN.Append("您有一张订单已签收。"); res = SIGN.ToString(); break; case "4": //退货申请 StringBuilder RETGOODS = new StringBuilder(); //RETGOODS.Append("您好,您有一条订单("); //RETGOODS.Append(order.ReceiptNo); //RETGOODS.Append(")申请退货。"); RETGOODS.Append("您有一张订单申请退货。"); res = RETGOODS.ToString(); break; case "5": //经销商修改订单 StringBuilder UPDATEORDER = new StringBuilder(); UPDATEORDER.Append("您有一张订单已更新。"); res = UPDATEORDER.ToString(); break; case "41": //代人下单通知 StringBuilder ORDERADD = new StringBuilder(); //ORDERADD.Append("您好,您有一条新的订单("); //ORDERADD.Append(order.ReceiptNo); //ORDERADD.Append(")。"); ORDERADD.Append("核心企业代您生成一条新的订单。"); res = ORDERADD.ToString(); break; case "42": //订单审批 StringBuilder sql = new StringBuilder(); //sql.Append("您好,您有一条订单("); //sql.Append(order.ReceiptNo); //sql.Append(")已审批。"); sql.Append("您有一张订单已审核。"); res = sql.ToString(); break; case "43": //订单发货 StringBuilder sqlSend = new StringBuilder(); //sqlSend.Append("您好,您有一条订单("); //sqlSend.Append(order.ReceiptNo); //sqlSend.Append(")已发货。"); sqlSend.Append("您有一张订单已发货。"); res = sqlSend.ToString(); break; case "44": //退货审核 StringBuilder RETAUDIT = new StringBuilder(); //RETAUDIT.Append("您好,您有一条退货订单("); //RETAUDIT.Append(order.ReceiptNo); //RETAUDIT.Append(")已审核。"); RETAUDIT.Append("您的退货申请已审核"); res = RETAUDIT.ToString(); break; case "45": //退款 StringBuilder REFUND = new StringBuilder(); //REFUND.Append("您好,您有一条订单("); StringBuilder COMUPDATEORDER = new StringBuilder(); COMUPDATEORDER.Append("您有一张订单已更新。"); res = COMUPDATEORDER.ToString(); break; case "46": //经销商修改订单 StringBuilder UPDATEORDER_comp = new StringBuilder(); UPDATEORDER_comp.Append("您有一张订单已更新。"); res = UPDATEORDER_comp.ToString(); break; } return(res); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.DIS_Order model) { return(dal.Add(model)); }
/// <summary> /// 生成订单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string ReceiptNo = string.Empty; string Otype = string.Empty; string ArriveDate = string.Empty; decimal TotalAmount = 0; decimal OtherAmount = 0; string DisUser = string.Empty; string DisUserId = string.Empty; string LogRemark = string.Empty; //日志备注 string Remark = string.Empty; string str = string.Empty; if (this.DisListID.Disid == "") { str += " - 代理商不能为空。\\r\\n"; } if (this.txtunit.Value == "") { str += " - 费用名称不能为空。\\r\\n"; } if (this.txtOtherAmount.Value.ToDecimal(0) <= 0) { str += " - 账单金额不能为0。\\r\\n"; } if (this.txtRemark.Value != "") { Remark = Common.NoHTML(this.txtRemark.Value.Trim().ToString()); if (Remark.Length > 400) { str += " - 账单备注不能大于400个字符。\\r\\n"; } } if (str != "") { JScript.AlertMsgOne(this, str, JScript.IconOption.错误, 2500); return; } try { Hi.Model.DIS_Order OrderInfoModel = null; DisId = Convert.ToInt32(this.DisListID.Disid); decimal Amount = Convert.ToDecimal(this.txtOtherAmount.Value); TotalAmount = Amount; if (this.txtArriveDate.Value.Trim() != "") { ArriveDate = Common.NoHTML(this.txtArriveDate.Value.Trim().ToString()); } else { ArriveDate = DateTime.MinValue.ToString(); } DisUser = Common.NoHTML(this.txtDisUser.InnerText.Trim().ToString()); DisUserId = Common.NoHTML(this.hidDisUserId.Value.Trim().ToString()); OrderInfoModel = OrderInfoBll.GetModel(KeyID); LogRemark += " 账单总价:" + Amount.ToString("N"); #region 新增订单 //新增订单 String guid = Guid.NewGuid().ToString().Replace("-", ""); ReceiptNo = SysCode.GetZD_NewCode("账单", 1); OrderInfoModel = new Hi.Model.DIS_Order(); OrderInfoModel.GUID = guid; OrderInfoModel.CompID = this.CompID; OrderInfoModel.DisID = DisId; OrderInfoModel.ReceiptNo = ReceiptNo; int OState = 1; //无需审核 OState = (int)Enums.OrderState.已审; OrderInfoModel.IsAudit = 1; OrderInfoModel.OState = OState; OrderInfoModel.Remark = Remark; OrderInfoModel.CreateUserID = this.UserID; OrderInfoModel.CreateDate = DateTime.Now; //总价 OrderInfoModel.TotalAmount = TotalAmount; OrderInfoModel.AuditAmount = TotalAmount; OrderInfoModel.OtherAmount = OtherAmount; OrderInfoModel.ArriveDate = ArriveDate.ToDateTime(); OrderInfoModel.DisUserID = DisUserId.ToInt(0); OrderInfoModel.Otype = (int)Enums.OType.推送账单; OrderInfoModel.AddType = (int)Enums.AddType.网页下单; OrderInfoModel.ts = DateTime.Now; //OrderInfoModel.vdef9 = "0"; OrderInfoModel.vdef2 = this.txtunit.Value.Trim();//费用科目 int OrderId = new Hi.BLL.DIS_Order().Add(OrderInfoModel); if (OrderId > 0) { Utils.AddSysBusinessLog(this.CompID, "Order", OrderId.ToString(), "账单新增", LogRemark); //代理商手机号 string Phone = Common.GetDis(DisId, "Phone"); string msg = "您的账单:" + ReceiptNo + "已经生成," + this.txtunit.Value.Trim() + ":" + TotalAmount + "元,请尽快完成付款![ " + Common.GetCompValue(CompID, "CompName") + " ]"; //账单推送向代理商推送信息提示 Common.GetPhone(Phone, msg); string Id = Common.DesEncrypt(OrderId.ToString(), Common.EncryptKey); ClientScript.RegisterStartupScript(this.GetType(), "add", "<script>window.location.href ='OrderZdtsInfo.aspx?KeyID=" + Id + "';</script>"); } #endregion } catch (Exception ex) { throw ex; } }
/// <summary> /// 新增订单 /// </summary> /// <param name="OrderInfoModel"></param> /// <param name="OrderDetailList"></param> /// <returns></returns> public static int TansOrder(Hi.Model.DIS_Order OrderInfoModel, Hi.Model.DIS_OrderExt OrderExt, List <Hi.Model.DIS_OrderDetail> OrderDetailList) { int OrderId = 0; int OrderExtId = 0; System.Text.StringBuilder sqlInven = new System.Text.StringBuilder(); int IsInve = rdoOrderAudit("商品是否启用库存", OrderInfoModel.CompID).ToInt(0); SqlTransaction sqlTrans = DBUtility.SqlHelper.CreateStoreTranSaction(); //可以做循环 try { OrderId = OrderBll.AddOrder(sqlTrans.Connection, OrderInfoModel, sqlTrans); if (OrderId == 0) { OrderId = 0; sqlTrans.Rollback(); return(OrderId); } OrderExt.OrderID = OrderId; OrderExtId = OrderExtBll.Add(sqlTrans.Connection, OrderExt, sqlTrans); if (OrderExtId == 0) { OrderId = 0; sqlTrans.Rollback(); return(OrderId); } if (OrderDetailList.Count <= 0) { OrderId = 0; sqlTrans.Rollback(); } else { foreach (Hi.Model.DIS_OrderDetail item in OrderDetailList) { item.OrderID = OrderId; int 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("", OrderDetailList)); if (new Hi.BLL.DIS_OrderDetail().GetUpdateInventory(sqlInven.ToString(), sqlTrans.Connection, sqlTrans) <= 0) { OrderId = 0; //sqlTrans.Rollback(); } } if (rdoOrderAudit("订单支付返利是否启用", OrderInfoModel.CompID) == "1") { //订单支付返利启用 if (OrderInfoModel.bateAmount > 0) { //使用返利大于0; if (bate.TransRebate(OrderInfoModel.DisID, OrderInfoModel.bateAmount, OrderId, OrderInfoModel.CreateUserID, sqlTrans)) { sqlTrans.Commit(); return(OrderId); } else { sqlTrans.Rollback(); OrderId = 0; return(OrderId); } } } sqlTrans.Commit(); } } catch { OrderId = 0; sqlTrans.Rollback(); } finally { //sqlTrans.Connection.Close(); } return(OrderId); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.DIS_Order model) { return(dal.Update(model)); }
protected void Page_Load(object sender, EventArgs e) { if (KeyID != 0) { if (!Common.PageDisOperable("Order", KeyID, this.DisID)) { Response.Redirect("../NoOperable.aspx"); return; } order = OrderBll.GetModel(KeyID); if (order != null) { //receiptno = order.ReceiptNo; //DisID = order.DisID; //Otype = OrderInfoType.OType(order.Otype); //if (user != null) //{ // //UserID = user.ID; // //CompID = user.CompID; // //DisID = user.DisID; // //DisUser = new Hi.BLL.SYS_Users().GetModel(order.DisUserID); // //if (DisUser != null) // //{ // // truename = DisUser.UserName; // // BindGoods(); // //} //} //else //{ // Response.Redirect("orderlist.aspx"); //} } else { Response.Redirect("orderlist.aspx"); } // if (Request["KeyID"] != null) // { // KeyID = int.Parse(Request["KeyID"]); // } // if (KeyID != 0) // { // order = OrderBll.GetModel(KeyID); // if (order != null) // { // Otype = OrderInfoType.OType(order.Otype); // if (user != null) // { // truename = user.TrueName; // BindGoods(); // } // } // else // { // Response.Redirect("orderlist.aspx"); // } // } // else // { // Response.Redirect("orderlist.aspx"); // } } }
//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); } //} }
/// <summary> /// 订单支付 /// </summary> /// <param name="orderid">订单ID</param> /// <param name="txtPayOrder">支付金额</param> /// <param name="price">企业钱包金额</param> /// <param name="yfk">预付款</param> /// <param name="payPas"></param> public Wxpay_Url PayOrder(int orderid, decimal txtPayOrder, decimal price, int yfk, string payPas) { //使用企业钱包 OrderModel = new Hi.BLL.DIS_Order().GetModel(orderid); disModel = new Hi.BLL.BD_Distributor().GetModel(OrderModel.DisID); #region 界面上显示 this.lblOrderNO.InnerText = OrderModel.ReceiptNo.Trim().ToString(); this.fee.InnerText = this.CompName;//收款方 // this.lblOrderNO.HRef = "../neworder/orderdetail.aspx?KeyID=" + Common.DesEncrypt(orderid.ToString(), Common.EncryptKey); #endregion 界面上显示 #region 企业钱包支付 begin if (disModel == null) { ErrMessage("数据异常,代理商有误", orderid.ToString()); } decimal sumPrice = new Hi.BLL.PAY_PrePayment().sums(disModel.ID, disModel.CompID); //剩余企业钱包 int disid = OrderModel.DisID; //代理商ID string password = disModel.Paypwd; if (yfk == 1) { if (payPas == null || payPas.Trim().ToString() == "") { ErrMessage("企业钱包密码不能为空", orderid.ToString()); } payPas = payPas.Trim().ToString(); if (password == Util.md5("123456")) { ErrMessage("请先修改企业钱包支付密码", orderid.ToString()); } else { if (payPas == "") { ErrMessage("密码不能为空", orderid.ToString()); } } } decimal payPrice = 0;//支付金额 if (txtPayOrder == 0) { ErrMessage("支付金额不能为0", orderid.ToString()); } if (yfk == 1 && txtPayOrder < price) { ErrMessage("使用企业钱包大于支付金额!", orderid.ToString()); } if (yfk == 1) { payPrice = txtPayOrder - price; } else { payPrice = txtPayOrder; } if (txtPayOrder > OrderModel.AuditAmount + OrderModel.OtherAmount - OrderModel.PayedAmount) { ErrMessage("支付金额大于未支付金额,不能支付!", orderid.ToString()); } if (!(( (OrderModel.Otype == (int)Enums.OType.赊销订单 && (OrderModel.OState != (int)Enums.OrderState.退回 && OrderModel.OState != (int)Enums.OrderState.未提交 && OrderModel.OState != (int)Enums.OrderState.待审核) && (OrderModel.PayState == (int)Enums.PayState.未支付 || OrderModel.PayState == (int)Enums.PayState.部分支付)) || (OrderModel.Otype != (int)Enums.OType.赊销订单 && OrderModel.Otype != (int)Enums.OType.推送账单 && (OrderModel.OState == (int)Enums.OrderState.已审 || OrderModel.OState == (int)Enums.OrderState.已发货 || OrderModel.OState == (int)Enums.OrderState.已到货) && (OrderModel.PayState == (int)Enums.PayState.未支付 || OrderModel.PayState == (int)Enums.PayState.部分支付)) || (OrderModel.Otype == (int)Enums.OType.推送账单 && OrderModel.OState == (int)Enums.OrderState.已审 && (OrderModel.PayState == (int)Enums.PayState.部分支付 || OrderModel.PayState == (int)Enums.PayState.未支付)) ) && OrderModel.OState != (int)Enums.OrderState.已作废)) { if (OrderModel.Otype == (int)Enums.OType.推送账单) { ErrMessage("账单异常,不能支付", orderid.ToString()); } else { ErrMessage("订单异常,不能支付", orderid.ToString()); } } if (yfk == 1 && price > 0) { //企业钱包处理 if (sumPrice < price) { ErrMessage("企业钱包余额不足", orderid.ToString()); } if (disModel.Paypwd != Util.md5(payPas)) { ErrMessage("支付密码不正确", orderid.ToString()); } Hi.Model.PAY_PrePayment prepayModel = new Hi.Model.PAY_PrePayment(); prepayModel.CompID = disModel.CompID; prepayModel.DisID = disModel.ID; prepayModel.OrderID = OrderModel.ID; prepayModel.Start = 2; prepayModel.PreType = 5; prepayModel.price = price * -1; prepayModel.Paytime = DateTime.Now; prepayModel.CreatDate = DateTime.Now; prepayModel.CrateUser = this.UserID; prepayModel.AuditState = 2; prepayModel.IsEnabled = 1; prepayModel.ts = DateTime.Now; prepayModel.modifyuser = this.UserID; prepayModel.guid = Common.Number_repeat(Guid.NewGuid().ToString().Replace("-", "")); // prepayModel.vdef1 = "订单支付"; prepayid = new Hi.BLL.PAY_PrePayment().Add(prepayModel); int prepay = 0; int order = 0; if (prepayid > 0 && payPrice == 0)//payPrice(网银支付金额)= 0 ,只用企业钱包支付,修改状态 { SqlConnection con = new SqlConnection(LocalSqlServer); con.Open(); SqlTransaction sqlTrans = con.BeginTransaction(); try { prepay = new Hi.BLL.PAY_PrePayment().updatePrepayState(con, prepayid, sqlTrans); //修改企业钱包状态 order = new Hi.BLL.DIS_Order().UpdateOrderPstate(con, OrderModel.ID, price, sqlTrans); //修改订单状态 if (prepay > 0 && order > 0) { sqlTrans.Commit(); } else { sqlTrans.Rollback(); } } catch { prepay = 0; order = 0; sqlTrans.Rollback(); } finally { con.Close(); } if (prepay > 0 && order > 0) { try { if (OrderModel.Otype == (int)Enums.OType.推送账单) { Utils.AddSysBusinessLog(disModel.CompID, "Order", OrderModel.ID.ToString(), "账单支付", "支付:" + price.ToString("0.00") + "元(企业钱包支付)", this.UserID.ToString()); } else { Utils.AddSysBusinessLog(disModel.CompID, "Order", OrderModel.ID.ToString(), "订单支付", "支付:" + price + "元(企业钱包支付)", this.UserID.ToString()); } if (OrderModel.Otype != 9) { OrderInfoType.AddIntegral(this.CompID, this.DisID, "1", 1, OrderModel.ID, price, "订单支付", "", this.UserID); } new Common().GetWxService("2", OrderModel.ID.ToString(), "1", price); } catch (Exception ex) { ErrMessage("支付失败", orderid.ToString()); } if (OrderModel.Otype == (int)Enums.OType.推送账单) { Response.Redirect("PaySuccess.aspx?type=" + Common.DesEncrypt("2", Common.EncryptKey) + "&KeyID=" + Common.DesEncrypt(OrderModel.ID.ToString(), Common.EncryptKey) + "&Pid=" + Common.DesEncrypt("0".ToString(), Common.EncryptKey) + "&PPid=" + Common.DesEncrypt(prepayid.ToString(), Common.EncryptKey) + "&IsRef=Y", false); } else { Response.Redirect("PaySuccess.aspx?type=" + Common.DesEncrypt("1", Common.EncryptKey) + "&KeyID=" + Common.DesEncrypt(OrderModel.ID.ToString(), Common.EncryptKey) + "&Pid=" + Common.DesEncrypt("0".ToString(), Common.EncryptKey) + "&PPid=" + Common.DesEncrypt(prepayid.ToString(), Common.EncryptKey) + "&IsRef=Y", false); } } } } #endregion #region 插入支付表记录 Hi.Model.PAY_Payment payModel = new Hi.Model.PAY_Payment(); string orderNo = WebConfigurationManager.AppSettings["OrgCode"] + DateTime.Now.ToString("yyyyMMdd");//支付订单号前半部分 string guid = Guid.NewGuid().ToString().Replace("-", ""); payModel.OrderID = OrderModel.ID; // orderid; payModel.DisID = this.DisID; payModel.Type = 0; // isDBPay; payModel.PayUser = disModel.DisName; payModel.PayPrice = payPrice; payModel.IsAudit = 2; payModel.guid = Common.Number_repeat(guid); payModel.vdef3 = "1"; //1,订单支付,2,预付款充值、汇款 payModel.vdef4 = orderNo; payModel.CreateDate = DateTime.Now; payModel.CreateUserID = this.UserID; payModel.ts = DateTime.Now; payModel.modifyuser = this.UserID; payModel.PrintNum = 1; //支付宝支付无需结算 //判断账户类型,判断支付渠道 payModel.Channel = "7"; //1,快捷支付,2,银联支付 ,3,网银支付,4,B2B网银支付,5,线下支付,6,支付宝支付 7,微信支付 payModel.State = 0; //手续费收取方 payModel.vdef5 = "0.00"; //支付手续费 payid = new Hi.BLL.PAY_Payment().Add(payModel); if (prepayid > 0) { Hi.Model.PAY_PrePayment prepayMent = new Hi.BLL.PAY_PrePayment().GetModel(prepayid); prepayMent.vdef4 = payid.ToString();//与企业钱包关联 new Hi.BLL.PAY_PrePayment().Update(prepayMent); } Hi.Model.PAY_RegisterLog regModel = new Hi.Model.PAY_RegisterLog(); regModel.OrderId = OrderModel.ID;// orderid; regModel.Ordercode = orderNo + payid.ToString(); regModel.number = payModel.guid; regModel.Price = payPrice; regModel.Payuse = "订单支付"; regModel.PayName = disModel.DisName; regModel.DisID = OrderModel.DisID; regModel.PayTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); regModel.Remark = OrderModel.Remark;// orderModel.Remark; regModel.DisName = new Hi.BLL.BD_Company().GetModel(disModel.CompID).CompName; regModel.BankID = "支付宝支付"; regModel.CreateUser = this.UserID; regModel.CreateDate = DateTime.Now; regModel.LogType = 1311; int regid = new Hi.BLL.PAY_RegisterLog().Add(regModel); if (payid <= 0 || regid <= 0) { Response.Redirect("Error.aspx?type=" + Common.DesEncrypt("3", Common.EncryptKey) + "&KeyID=" + Common.DesEncrypt(Convert.ToString(KeyID), Common.EncryptKey) + "&msg=" + Common.DesEncrypt("支付失败!", Common.EncryptKey), false); } //订单所有商品明细 DataTable l = new Hi.BLL.DIS_OrderDetail().GetOrderDe("", " IsNUll(o.dr,0)=0 and o.OrderId=" + orderid); foreach (DataRow dr in l.Rows) { GoodsName += dr["GoodsName"] + ","; } GoodsName = GoodsName.Substring(0, GoodsName.Length - 1);//去掉最后一个逗号 if (GoodsName.Length > 15) { GoodsName = GoodsName.Substring(0, 10) + "..."; } #endregion int amount = Convert.ToInt32(payPrice * 100);//支付金额(单位:分) //隐藏域赋值 this.hidguid.Value = payModel.guid; this.hidprice.Value = payPrice.ToString(); this.hidordid.Value = payModel.OrderID.ToString(); this.hidpid.Value = payid.ToString(); this.hidppid.Value = prepayid.ToString(); // btnWxPay_Click(payModel.guid, orderid.ToString(), amount); Wxpay_Url wxpaymodel = new Wxpay_Url(); wxpaymodel.Guid = payModel.guid; wxpaymodel.OrderID = orderid.ToString(); wxpaymodel.Amount = amount; wxpaymodel.Hidguid = payModel.guid; wxpaymodel.Hidprice = payModel.PayPrice.ToString(); wxpaymodel.Hidordid = payModel.OrderID.ToString(); wxpaymodel.Hidpid = payid.ToString(); wxpaymodel.Hidppid = prepayid.ToString(); return(wxpaymodel); }
/// <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); }
public void Bind() { orderModel = new Hi.BLL.DIS_Order().GetModel(KeyID); // 订单检查 if (orderModel == null) { //if (orderModel.Otype == (int)Enums.OType.推送账单) // JScript.AlertMethod(this, "无效的账单!", JScript.IconOption.错误, "function (){ location.replace('" + ("orderDzfzdList.aspx") + "'); }"); //else JScript.AlertMethod(this, "无效的订单!", JScript.IconOption.错误, "function (){ location.replace('" + ("orderPayList.aspx") + "'); }"); //this.lblPayError.InnerText = "无效的订单!"; return; } // 状态检查 if (!( ( (orderModel.Otype == (int)Enums.OType.销售订单 && (orderModel.OState == (int)Enums.OrderState.已审 || orderModel.OState == (int)Enums.OrderState.已发货 || orderModel.OState == (int)Enums.OrderState.已到货) && (orderModel.PayState == (int)Enums.PayState.未支付 || orderModel.PayState == (int)Enums.PayState.部分支付)) || (orderModel.Otype == (int)Enums.OType.推送账单 && orderModel.OState == (int)Enums.OrderState.已审 && (orderModel.PayState == (int)Enums.PayState.部分支付 || orderModel.PayState == (int)Enums.PayState.未支付)) ) && orderModel.OState != (int)Enums.OrderState.已作废)) { if (orderModel.Otype == (int)Enums.OType.推送账单) { JScript.AlertMethod(this, "账单异常,不能支付!", JScript.IconOption.错误, "function (){ location.replace('" + ("orderDzfzdList.aspx") + "'); }"); } else { JScript.AlertMethod(this, "订单异常,不能支付!", JScript.IconOption.错误, "function (){ location.replace('" + ("orderPayList.aspx") + "'); }"); } return; } // 审核状态 if (orderModel.OState < 2) { JScript.AlertMethod(this, "该订单未审核,不能支付!", JScript.IconOption.错误, "function (){ location.replace('" + ("../neworder/orderdetail.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey)) + "'); }"); return; } // 支付状态检查 if (orderModel.PayState != (int)Enums.PayState.未支付 && orderModel.PayState != (int)Enums.PayState.部分支付) { Response.Redirect("Error.aspx?type=" + Common.DesEncrypt("1", Common.EncryptKey) + "&KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey)); return; } // 开销户 List <Hi.Model.PAY_OpenAccount> LOpen = new Hi.BLL.PAY_OpenAccount().GetList("", "DisID=" + this.DisID + " and State=1 and isnull(dr,0)=0", ""); // 提现户 List <Hi.Model.PAY_Withdrawals> Lwith = new Hi.BLL.PAY_Withdrawals().GetList("", "DisID=" + this.DisID + " and state=1 and isnull(dr,0)=0", ""); if (LOpen.Count > 0 && Lwith.Count > 0) { String msghd_rspcode = ""; String msghd_rspmsg = ""; String amt_balamt = ""; String msghd_rspcode1 = ""; String msghd_rspmsg1 = ""; String credit_nousedamt = ""; String Json = ""; String Json1 = ""; try { IPubnetwk ipu = new IPubnetwk(); Json = ipu.trd13010("{\"msghd_trdt\":\"" + DateTime.Now.ToString("yyyyMMdd") + "\",\"srl_ptnsrl\":\"" + Common.Number_repeat("") + "\",\"cltacc_cltno\":\"" + LOpen[0].AccNumver + "\",\"cltacc_cltnm\":\"" + LOpen[0].AccName + "\",\"bkacc_accno\":\"" + Lwith[0].AccNm + "\",\"bkacc_accnm\":\"" + LOpen[0].AccName + "\"}"); Json1 = ipu.trd70000("{\"msghd_trdt\":\"" + DateTime.Now.ToString("yyyyMMdd") + "\",\"srl_ptnsrl\":\"" + Common.Number_repeat("") + "\",\"cltacc_cltno\":\"" + LOpen[0].AccNumver + "\",\"cltacc_cltnm\":\"" + LOpen[0].AccName + "\"}"); } catch { } try { JsonData Params = JsonMapper.ToObject(Json); msghd_rspcode = Params["msghd_rspcode"].ToString(); msghd_rspmsg = Params["msghd_rspmsg"].ToString(); amt_balamt = Params["amt_balamt"].ToString(); this.lblBalance1.InnerHtml = (Convert.ToDecimal(amt_balamt) / 100).ToString("N2"); JsonData Params1 = JsonMapper.ToObject(Json1); msghd_rspcode1 = Params1["msghd_rspcode"].ToString(); msghd_rspmsg1 = Params1["msghd_rspmsg"].ToString(); credit_nousedamt = Params1["credit_nousedamt"].ToString(); this.lblBalance3.InnerHtml = (Convert.ToDecimal(credit_nousedamt) / 100).ToString("N2"); } catch { } } // 在线融资记录 PList = new Hi.BLL.PAY_Financing().GetList("", "DisID=" + this.DisID + " and OrderID=" + KeyID + " and State=3 and isnull(dr,0)=0", ""); if (PList.Count > 0) { this.lblBalance5.InnerHtml = PList[0].AclAmt.ToString("0.00"); } decimal payPrice = orderModel.AuditAmount + orderModel.OtherAmount - orderModel.PayedAmount; this.lblOrderNO.InnerText = orderModel.ReceiptNo.Trim().ToString(); //账单支付链接 if (orderModel.Otype == 9) // 推送账单 { this.lblOrderNO.HRef = "../OrderZDInfo.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey); } else { this.lblOrderNO.HRef = "../neworder/orderdetail.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey); } this.hidOrderid.Value = KeyID.ToString(); this.lblPricePay.InnerText = payPrice.ToString("0.00"); this.hidPricePay.Value = payPrice.ToString("0.00"); this.lblPriceO.InnerText = (orderModel.AuditAmount + orderModel.OtherAmount).ToString("0.00"); if (this.txtPayOrder.Value == "") { this.txtPayOrder.Value = payPrice.ToString("0.00"); } else { this.txtPayOrder.Value = Convert.ToDecimal(this.txtPayOrder.Value).ToString("0.00"); } this.hidUserName.Value = this.UserName; decimal sumPrice = new Hi.BLL.PAY_PrePayment().sums(orderModel.DisID, orderModel.CompID); this.lblSumPrice.InnerText = sumPrice.ToString("0.00"); this.hidSumPrice.Value = sumPrice.ToString("0.00"); string strWhere = " 1=1 "; if (this.DisID != 0) { strWhere += " and DisID = " + this.DisID; } strWhere += " and Start = 1 and vdef6 = 0 and isnull(dr,0)=0"; List <Hi.Model.PAY_FastPayMent> fastList = new Hi.BLL.PAY_FastPayMent().GetList("", strWhere, ""); this.rptQpay.DataSource = fastList; this.rptQpay.DataBind(); List <Hi.Model.PAY_BankInfo> BankL = new Hi.BLL.PAY_BankInfo().GetList("", " vdef1=0", ""); this.rptOtherBank.DataSource = BankL; this.rptOtherBank.DataBind(); }