/// <summary> /// 增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Eyousoft_yhq.Model.Order model) { DbCommand cmd = this._db.GetStoredProcCommand("proc_Order_Add"); this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID); this._db.AddInParameter(cmd, "ProductID", DbType.AnsiStringFixedLength, model.ProductID); this._db.AddOutParameter(cmd, "OrderCode", DbType.AnsiStringFixedLength, 255); this._db.AddInParameter(cmd, "MemberID", DbType.AnsiStringFixedLength, model.MemberID); this._db.AddInParameter(cmd, "MemberName", DbType.String, model.MemberName); this._db.AddInParameter(cmd, "MemberTel", DbType.String, model.MemberTel); this._db.AddInParameter(cmd, "MemberSex", DbType.Byte, (int)model.MemberSex); this._db.AddInParameter(cmd, "OrderState", DbType.Byte, (int)model.OrderState); this._db.AddInParameter(cmd, "PayState", DbType.Byte, (int)model.PayState); this._db.AddInParameter(cmd, "IsCheck", DbType.AnsiStringFixedLength, this.GetBooleanToStr(model.IsCheck)); this._db.AddInParameter(cmd, "ConfirmCode", DbType.String, model.ConfirmCode); this._db.AddInParameter(cmd, "OrderPrice", DbType.Decimal, model.OrderPrice); this._db.AddInParameter(cmd, "PeopleNum", DbType.Int32, model.PeopleNum); this._db.AddInParameter(cmd, "Remark", DbType.String, model.Remark); this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4); _db.AddInParameter(cmd, "WeiDianId", DbType.AnsiStringFixedLength, model.WeiDianId); DbHelper.RunProcedureWithResult(cmd, this._db); model.OrderCode = this._db.GetParameterValue(cmd, "OrderCode").ToString(); return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result"))); }
protected string saveContract(string id) { string contractHTML = Request.Form["saveHTML"]; if (string.IsNullOrEmpty(contractHTML) || string.IsNullOrEmpty(id)) { return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "操作失败!")); } Eyousoft_yhq.BLL.Order OrderBll = new Eyousoft_yhq.BLL.Order(); Eyousoft_yhq.Model.Order OrderModel = new Eyousoft_yhq.Model.Order() { OrderID = id, ContractText = contractHTML, IsealCheck = false }; bool result = OrderBll.updateContract(OrderModel); if (result) { return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("1", "操作成功,等待审核!")); } else { return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "数据丢失!请重新操作!")); } }
/// <summary> /// 设置寄送地址 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool setAddressID(Eyousoft_yhq.Model.Order model) { if (string.IsNullOrEmpty(model.OrderID)) { return(false); } return(dal.setAddressID(model)); }
/// <summary> /// 保存返佣金额 /// </summary> /// <param name="model"></param> /// <returns></returns> public int SaveReMoney(Eyousoft_yhq.Model.Order model) { if (string.IsNullOrEmpty(model.OrderID)) { return(0); } return(dal.SaveReMoney(model)); }
/// <summary> /// 修改订单支付状态 /// </summary> /// <param name="OrderID"></param> /// <returns></returns> public int UpdatePayState(Eyousoft_yhq.Model.Order model) { if (string.IsNullOrEmpty(model.OrderID)) { return(0); } return(dal.UpdatePayState(model)); }
public bool updateContract(Eyousoft_yhq.Model.Order model) { if (string.IsNullOrEmpty(model.OrderID)) { return(false); } return(dal.updateContract(model)); }
/// <summary> /// 账户支付订单 /// </summary> /// <param name="dingdan">订单</param> /// <param name="huiyuanbianhao">支付人</param> /// <returns></returns> public int XiaoFei(Eyousoft_yhq.Model.Order dingdan, string huiyuanbianhao) { if (string.IsNullOrEmpty(dingdan.OrderID) || string.IsNullOrEmpty(huiyuanbianhao)) { return(0); } return(dal.XiaoFei(dingdan, huiyuanbianhao)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Eyousoft_yhq.Model.Order model) { model.OrderID = Guid.NewGuid().ToString(); if (string.IsNullOrEmpty(model.MemberID) || string.IsNullOrEmpty(model.ProductID)) { return(0); } return(dal.Add(model)); }
/// <summary> /// 保存操作 /// </summary> /// <param name="doType"></param> protected void pageSave(string doType) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); model.OrderID = Utils.GetQueryStringValue("orderid"); model.OrderState = (Eyousoft_yhq.Model.OrderState)Utils.GetInt(Utils.GetFormValue(this.ddl_orderState.UniqueID)); model.Remark = Utils.GetFormValue(this.txtSpecialMark.UniqueID); model.OrderPrice = Utils.GetDecimal(Utils.GetFormValue(this.lblOrderPrice.UniqueID)); model.SendFile = NewGetAttach(); string OrderIhpone = this.lblPtel.Text; string OrderCode = this.InOrderId.Value; bool result = false; string msg = ""; Eyousoft_yhq.Model.MCompanySetting exModel = new Eyousoft_yhq.BLL.KV().GetCompanySetting(); if (model.OrderState == Eyousoft_yhq.Model.OrderState.待付款 || model.OrderState == Eyousoft_yhq.Model.OrderState.已取消) { if (exModel != null && exModel.MsgNumber > 0) { if (doType == "save") { result = bll.Update(model) > 0 ? true : false; msg = result ? "修改成功!" : "修改失败!"; if (result == true) { SendMsg(model.OrderState, OrderIhpone, OrderCode, model.OrderID); } } } else { msg = "短信数量不足,修改短信发送失败!"; } } else { if (doType == "save") { result = bll.Update(model) > 0 ? true : false; msg = result ? "修改成功!" : "修改失败!"; } } if (doType == "savepdf") { result = bll.SavePDF(model) > 0 ? true : false; msg = result ? "保存成功!" : "保存失败!"; } Response.Clear(); Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg)); Response.End(); }
/// <summary> /// 保存返佣金额 /// </summary> /// <param name="model"></param> /// <returns></returns> public int SaveReMoney(Eyousoft_yhq.Model.Order model) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("UPDATE tbl_Order SET RebackMoney = @RebackMoney WHERE OrderID =@OrderID "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID); this._db.AddInParameter(cmd, "RebackMoney", DbType.Decimal, model.RebackMoney); return(DbHelper.ExecuteSql(cmd, this._db)); }
/// <summary> /// 保存支付状态 /// </summary> /// <param name="model"></param> /// <returns></returns> public int SavePayState(Eyousoft_yhq.Model.Order model) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("UPDATE tbl_Order SET PayState = @PayState,OrderState=@OrderState WHERE OrderID =@OrderID "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID); this._db.AddInParameter(cmd, "PayState", DbType.Byte, (int)model.PayState); this._db.AddInParameter(cmd, "OrderState", DbType.Byte, (int)model.OrderState); return(DbHelper.ExecuteSql(cmd, this._db)); }
/// <summary> /// 设置寄送地址 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool setAddressID(Eyousoft_yhq.Model.Order model) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("UPDATE tbl_Order SET AddressID = @AddressID WHERE OrderID =@OrderID "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID); this._db.AddInParameter(cmd, "AddressID", DbType.AnsiStringFixedLength, model.AddressID); return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false); }
/// <summary> /// 获取一个订单 /// </summary> /// <param name="OrderID">订单编号</param> /// <returns></returns> public Eyousoft_yhq.Model.Order GetModel(string OrderID) { Eyousoft_yhq.Model.Order model = null; string StrSql = "select * from view_Order where OrderId=@OrderId"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "OrderId", DbType.AnsiStringFixedLength, OrderID); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.SendFile = this.GetAttachList(dr["ComAttachXML"].ToString(), OrderID); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); model.AvailNum = dr.IsDBNull(dr.GetOrdinal("AvailNum")) ? 0 : dr.GetInt32(dr.GetOrdinal("AvailNum")); } } return(model); }
/// <summary> /// 修改合同数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool updateContract(Eyousoft_yhq.Model.Order model) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("UPDATE tbl_Order SET ContractText = @ContractText , IsealCheck=@IsealCheck WHERE OrderID =@OrderID "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID); this._db.AddInParameter(cmd, "IsealCheck", DbType.AnsiStringFixedLength, GetBooleanToStr(model.IsealCheck)); this._db.AddInParameter(cmd, "ContractText", DbType.String, model.ContractText); return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false); }
public int SavePDF(Eyousoft_yhq.Model.Order model) { DbCommand cmd = this._db.GetStoredProcCommand("proc_Order_UpdatePDF"); this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID); this._db.AddInParameter(cmd, "ComAttachXML", DbType.Xml, CreateComNoticeXML(model.SendFile)); this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4); DbHelper.RunProcedureWithResult(cmd, this._db); return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result"))); }
/// <summary> /// 账户支付订单 /// </summary> /// <param name="dingdan">订单</param> /// <param name="huiyuanbianhao">支付人</param> /// <returns></returns> public int XiaoFei(Eyousoft_yhq.Model.Order dingdan, string huiyuanbianhao) { DbCommand cmd = _db.GetStoredProcCommand("proc_XiaoFei"); this._db.AddInParameter(cmd, "HuiYuanBianHao", DbType.AnsiStringFixedLength, huiyuanbianhao); this._db.AddInParameter(cmd, "DingDanBianHao", DbType.AnsiStringFixedLength, dingdan.OrderID); this._db.AddInParameter(cmd, "DingDanZT", DbType.Byte, dingdan.PayState); this._db.AddInParameter(cmd, "JinE", DbType.Decimal, dingdan.OrderPrice); this._db.AddOutParameter(cmd, "result", DbType.Int32, 4); DbHelper.RunProcedureWithResult(cmd, this._db); return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result"))); }
/// <summary> /// 修改订单支付状态 /// </summary> /// <param name="OrderID"></param> /// <returns></returns> public int UpdatePayState(Eyousoft_yhq.Model.Order Model) { DbCommand cmd = this._db.GetStoredProcCommand("proc_OrderState_Update"); this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, Model.OrderID); this._db.AddInParameter(cmd, "PayState", DbType.Byte, (int)Model.PayState); this._db.AddInParameter(cmd, "ConfirmCode", DbType.AnsiStringFixedLength, Model.ConfirmCode); this._db.AddInParameter(cmd, "OrderState", DbType.Byte, (int)Model.OrderState); this._db.AddInParameter(cmd, "JState", DbType.Byte, (int)Model.JIESUAN); this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4); DbHelper.RunProcedureWithResult(cmd, this._db); return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result"))); }
/// <summary> /// 保存行程单 /// </summary> /// <param name="model"></param> /// <returns></returns> public int SavePDF(Eyousoft_yhq.Model.Order model) { if (string.IsNullOrEmpty(model.OrderID)) { return(0); } if (model.SendFile != null && model.SendFile.Count > 0) { for (int i = 0; i < model.SendFile.Count; i++) { model.SendFile[i].ItemId = model.OrderID; } } return(dal.SavePDF(model)); } /// <summary>
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Eyousoft_yhq.Model.Order model) { DbCommand cmd = this._db.GetStoredProcCommand("proc_Order_Update"); this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID); this._db.AddInParameter(cmd, "OrderState", DbType.Byte, (int)model.OrderState); this._db.AddInParameter(cmd, "OrderPrice", DbType.Decimal, model.OrderPrice); this._db.AddInParameter(cmd, "Remark", DbType.String, model.Remark); this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4); DbHelper.RunProcedureWithResult(cmd, this._db); return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result"))); }
protected void InitBind(string orid) { Eyousoft_yhq.BLL.Order OrderBll = new Eyousoft_yhq.BLL.Order(); if (!string.IsNullOrEmpty(orid)) { Eyousoft_yhq.Model.Order OrderModel = OrderBll.GetModel(orid); if (OrderModel != null) { ProtudId = OrderModel.ProductID; lbName.Text = OrderModel.ProductName; lbSum.Text = OrderModel.PeopleNum.ToString(); lbPrice.Text = Convert.ToDecimal(OrderModel.OrderPrice / OrderModel.PeopleNum).ToString("C0"); lbOderPrice.Text = (OrderModel.OrderPrice).ToString("C0"); lbOderPrice2.Text = (OrderModel.OrderPrice).ToString("C0"); } } }
protected bool AddOrder(string Pid, object OrderstateDown, decimal Price, out Eyousoft_yhq.Model.Order order) { Eyousoft_yhq.BLL.Order OrderBll = new Eyousoft_yhq.BLL.Order(); var MemberModel = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo(); int peopole = Utils.GetInt(Utils.GetQueryStringValue("renshu"), 1); if (MemberModel != null) { Eyousoft_yhq.Model.Order OrderModel = new Eyousoft_yhq.Model.Order() { OrderID = Guid.NewGuid().ToString(), ProductID = Pid, MemberID = MemberModel.UserID, MemberTel = MemberModel.UserName, MemberName = MemberModel.ContactName, MemberSex = MemberModel.ContactSex, OrderState = (Eyousoft_yhq.Model.OrderState)OrderstateDown, PayState = Eyousoft_yhq.Model.PaymentState.未支付, IsCheck = true, ConfirmCode = "", Remark = "", OrderPrice = Price * peopole, PeopleNum = peopole }; OrderModel.WeiDianId = Utils.GetQueryStringValue("weidianid"); int num = OrderBll.Add(OrderModel); if (num > 0) { order = OrderModel; return true; } else { order = OrderModel; return false; } } else { order = new Eyousoft_yhq.Model.Order(); return false; } }
protected bool AddOrder(string Pid, object OrderstateDown, decimal Price, out Eyousoft_yhq.Model.Order order) { Eyousoft_yhq.BLL.Order OrderBll = new Eyousoft_yhq.BLL.Order(); var MemberModel = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo(); int peopole = Utils.GetInt(Utils.GetQueryStringValue("renshu"), 1); if (MemberModel != null) { Eyousoft_yhq.Model.Order OrderModel = new Eyousoft_yhq.Model.Order() { OrderID = Guid.NewGuid().ToString(), ProductID = Pid, MemberID = MemberModel.UserID, MemberTel = MemberModel.UserName, MemberName = MemberModel.ContactName, MemberSex = MemberModel.ContactSex, OrderState = (Eyousoft_yhq.Model.OrderState)OrderstateDown, PayState = Eyousoft_yhq.Model.PaymentState.未支付, IsCheck = true, ConfirmCode = "", Remark = "", OrderPrice = Price * peopole, PeopleNum = peopole }; OrderModel.WeiDianId = Utils.GetQueryStringValue("weidianid"); int num = OrderBll.Add(OrderModel); if (num > 0) { order = OrderModel; return(true); } else { order = OrderModel; return(false); } } else { order = new Eyousoft_yhq.Model.Order(); return(false); } }
protected string SaveAdress() { string OrderID = Utils.GetQueryStringValue("OrderId"); string Adress = Utils.GetQueryStringValue("AdId"); Eyousoft_yhq.BLL.Order Or = new Eyousoft_yhq.BLL.Order(); Eyousoft_yhq.Model.Order OrModel = new Eyousoft_yhq.Model.Order { OrderID = OrderID, AddressID = Adress }; bool IsTrue = Or.setAddressID(OrModel); if (IsTrue) { return(UtilsCommons.AjaxReturnJson("1", "合同寄送地址添加成功!")); } else { return(UtilsCommons.AjaxReturnJson("0", "合同寄送地址添加失败!")); } }
protected string saveContract(string id) { string contractHTML = Request.Form["saveHTML"]; if (string.IsNullOrEmpty(contractHTML) || string.IsNullOrEmpty(id)) return EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "操作失败!"); Eyousoft_yhq.BLL.Order OrderBll = new Eyousoft_yhq.BLL.Order(); Eyousoft_yhq.Model.Order OrderModel = new Eyousoft_yhq.Model.Order() { OrderID = id, ContractText = contractHTML, IsealCheck = Utils.GetFormValue("isCheck") == "0" ? false : true }; bool result = OrderBll.updateContract(OrderModel); if (result) { return EyouSoft.Common.UtilsCommons.AjaxReturnJson("1", "操作成功!"); } else { return EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "数据丢失!请重新操作!"); } }
/// <summary> /// 设置支付状态和返佣金额 /// </summary> /// <param name="orderid"></param> /// <param name="mark"></param> private void savePaysateOrRemoney(string orderid, string mark) { var model = new Eyousoft_yhq.Model.Order() { OrderID = orderid, RebackMoney = Utils.GetDecimal(Utils.GetFormValue(txt_ReMoney.UniqueID)), PayState = Eyousoft_yhq.Model.PaymentState.已支付, OrderState = Eyousoft_yhq.Model.OrderState.已成交 }; bool result = false; string msg = ""; if (mark == "1") { result = new Eyousoft_yhq.BLL.Order().SavePayState(model) == 1 ? true : false; } else if (mark == "2") { result = new Eyousoft_yhq.BLL.Order().SaveReMoney(model) == 1 ? true : false; } else { msg = "参数错误,请从新操作"; } if (result) { msg = "修改成功"; } else { msg = "修改失败"; } Response.Clear(); Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg)); Response.End(); }
protected string AliPayOrder() { string id = Utils.GetQueryStringValue("ids"); if (!string.IsNullOrEmpty(id)) { Eyousoft_yhq.BLL.Order OrderBll = new Eyousoft_yhq.BLL.Order(); Eyousoft_yhq.Model.Order OrderModel = OrderBll.GetModel(id); if (OrderModel != null) { if (OrderModel.OrderState == Eyousoft_yhq.Model.OrderState.待付款) { if (OrderModel.PayState == Eyousoft_yhq.Model.PaymentState.未支付) { return(UtilsCommons.AjaxReturnJson("1", "支付跳转中.....")); } else { return(UtilsCommons.AjaxReturnJson("2", "订单已经支付无需重复支付")); } } else { return(UtilsCommons.AjaxReturnJson("2", "订单正在审核当中或已经完成支付请到订单中心查看")); } } else { return(UtilsCommons.AjaxReturnJson("2", "订单不存在,请重新选择!")); } } else { return(UtilsCommons.AjaxReturnJson("2", "订单不存在,请重新选择!")); } }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList<Eyousoft_yhq.Model.Order> GetList(Eyousoft_yhq.Model.MSearchOrder serModel) { IList<Eyousoft_yhq.Model.Order> list = new List<Eyousoft_yhq.Model.Order>(); StringBuilder query = new StringBuilder(); query.Append("select * from view_Order where 1=1"); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.MemberID)) { query.AppendFormat(" and MemberID = '{0}' ", serModel.MemberID); } if (!string.IsNullOrEmpty(serModel.OrderCode)) { query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode); } if (!string.IsNullOrEmpty(serModel.ConfirmCode)) { query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode); } if (serModel.OrderState.HasValue) { query.AppendFormat(" AND OrderState = '{0}' ", (int)serModel.OrderState.Value); } if (serModel.PaymentState.HasValue) { query.AppendFormat(" AND PayState = '{0}' ", (int)serModel.PaymentState.Value); } if (serModel.STime.HasValue) { query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value); } if (serModel.ETime.HasValue) { query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(serModel.RouteName)) { query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName); } if (serModel.OrderPrice != 0) { query.AppendFormat(" AND OrderPrice = '{0}' ", serModel.OrderPrice); } if (!string.IsNullOrEmpty(serModel.PromotionCode)) { query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' )", serModel.PromotionCode); } } query.Append(" order by IssueTime DESC "); DbCommand cmd = this._db.GetSqlStringCommand(query.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.SendFile = this.GetAttachList(dr["ComAttachXML"].ToString(), model.OrderID); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); list.Add(model); } }; return list; }
protected void Page_Load(object sender, EventArgs e) { SortedDictionary<string, string> sPara = GetRequestPost(); if (sPara.Count > 0)//判断是否有带返回参数 { Notify aliNotify = new Notify(); bool verifyResult = aliNotify.Verify(sPara, Request.QueryString["notify_id"], Request.QueryString["sign"]); if (verifyResult)//验证成功 { ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中服务器异步通知参数列表 //商户订单号 string out_trade_no = Request.QueryString["out_trade_no"]; //支付宝交易号 string trade_no = Request.QueryString["trade_no"]; //交易状态 string trade_status = Request.QueryString["trade_status"]; Eyousoft_yhq.BLL.Order OrderType = new Eyousoft_yhq.BLL.Order(); var OrderModel = new Eyousoft_yhq.Model.Order(); string res = string.Empty; if (trade_status == "TRADE_FINISHED") { } else if (Request.QueryString["trade_status"] == "TRADE_SUCCESS") { OrderModel = OrderType.GetModel(out_trade_no); if (OrderModel != null && OrderModel.PayState != Eyousoft_yhq.Model.PaymentState.已支付) { Eyousoft_yhq.Model.MConDetaile jilu = new Eyousoft_yhq.Model.MConDetaile() { HuiYuanID = OrderModel.MemberID, XFway = Eyousoft_yhq.Model.XFfangshi.消费, DingDanBianHao = OrderModel.OrderCode, JiaoYiHao = DateTime.Now.ToString("yyyyMMddHHmm") + Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(5), JiaoYiShiJian = DateTime.Now, DDCarrtes = Eyousoft_yhq.Model.DDleibie.旅游订单, JinE = OrderModel.OrderPrice }; new Eyousoft_yhq.BLL.BConDetaile().Add(jilu);//消费记录 string Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); while (OrderType.Exists(Ra)) { Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); } Eyousoft_yhq.Model.Order OrderInfo = new Eyousoft_yhq.Model.Order() { OrderID = out_trade_no, PayState = Eyousoft_yhq.Model.PaymentState.已支付, ConfirmCode = Ra, OrderState = Eyousoft_yhq.Model.OrderState.已成交 }; int Sum = OrderType.UpdatePayState(OrderInfo); if (Sum > 0) { Eyousoft_yhq.BLL.Member UM = new Eyousoft_yhq.BLL.Member(); bool Mo = UM.GetModel(OrderModel.MemberID).valiUser; if (!Mo) { #region 短信发送 string code = string.Empty; IList<Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); code = string.Format("下单成功,确认码:{0}!【惠旅游】", Ra); Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(OrderModel.MemberTel, code, channel[0], out res);//发送 #endregion #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = OrderModel.MemberTel, MsgText = code, ReResult = res }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } } } var chongzhiModel = new Eyousoft_yhq.BLL.BChongZhi().GetModel(out_trade_no); if (chongzhiModel != null && chongzhiModel.PayState == Eyousoft_yhq.Model.PaymentState.未支付) { var member = new Eyousoft_yhq.BLL.Member().GetModel(chongzhiModel.OperatorID); if (member != null) { member.YuE = member.YuE + chongzhiModel.OptMoney; bool result = new Eyousoft_yhq.BLL.Member().Update(member); } new Eyousoft_yhq.BLL.BChongZhi().SheZhiZhiFus(out_trade_no, Eyousoft_yhq.Model.PaymentState.已支付); } } else { } //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— Response.Write("success"); //请不要修改或删除 Response.Redirect("/Huiyuan/OrderList.aspx"); ///////////////////////////////////////////////////////////////////////////////////////////////////////////// } else//验证失败 { Response.Write("fail"); } } else { Response.Write("无通知参数"); } }
protected void Page_Load(object sender, EventArgs e) { Dictionary <string, string> sPara = GetRequestGet(); if (sPara.Count > 0)//判断是否有带返回参数 { Notify aliNotify = new Notify(); bool verifyResult = aliNotify.VerifyReturn(sPara, Request.QueryString["sign"]); if (verifyResult)//验证成功 { ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中页面跳转同步通知参数列表 //商户订单号 string out_trade_no = Request.QueryString["out_trade_no"]; //支付宝交易号 string trade_no = Request.QueryString["trade_no"]; //交易状态 string result = Request.QueryString["result"]; Eyousoft_yhq.BLL.Order OrderType = new Eyousoft_yhq.BLL.Order(); var OrderModel = new Eyousoft_yhq.Model.Order(); string res = string.Empty; if (result == "success") { //纪录充值消费纪录 try { string price = Request.QueryString["price"]; Eyousoft_yhq.BLL.BConDetaile service = new Eyousoft_yhq.BLL.BConDetaile(); Eyousoft_yhq.Model.MConDetaile con = new Eyousoft_yhq.Model.MConDetaile(); con.JiaoYiHao = trade_no; con.DingDanBianHao = out_trade_no; con.JinE = Decimal.Parse(price); con.JiaoYiShiJian = DateTime.Now; con.XFway = Eyousoft_yhq.Model.XFfangshi.消费; EyouSoft.Model.SSOStructure.MUserInfo userInfo = Session["HuiYuanInfo"] as EyouSoft.Model.SSOStructure.MUserInfo; con.HuiYuanID = userInfo.UserID; service.Add(con); } catch (Exception) { } OrderModel = OrderType.GetModel(out_trade_no); if (OrderModel.PayState != Eyousoft_yhq.Model.PaymentState.已支付) { string Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); while (OrderType.Exists(Ra)) { Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); } Eyousoft_yhq.Model.Order OrderInfo = new Eyousoft_yhq.Model.Order() { OrderID = out_trade_no, PayState = Eyousoft_yhq.Model.PaymentState.已支付, ConfirmCode = Ra, OrderState = Eyousoft_yhq.Model.OrderState.已成交 }; int Sum = OrderType.UpdatePayState(OrderInfo); if (Sum > 0) { Eyousoft_yhq.BLL.Member UM = new Eyousoft_yhq.BLL.Member(); bool Mo = UM.GetModel(OrderModel.MemberID).valiUser; if (!Mo) { #region 短信发送 string code = string.Empty; IList <Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); //code = CreateZxingCode(Ra) + string.Format("下单成功,确认码:{0}!【惠旅游】", Ra);//生成二维码,发送彩信 Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(OrderModel.MemberTel, code, channel[0], out res);//发送 #endregion #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = OrderModel.MemberTel, MsgText = code, ReResult = res }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } } } } Response.Redirect("/AppPage/orderlist.aspx"); //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— ///////////////////////////////////////////////////////////////////////////////////////////////////////////// } else//验证失败 { Response.Write("验证失败"); } } else { Response.Write("无返回参数"); } }
protected void Page_Load(object sender, EventArgs e) { SortedDictionary<string, string> sPara = GetRequestPost(); if (sPara.Count > 0)//判断是否有带返回参数 { Notify aliNotify = new Notify(); bool verifyResult = aliNotify.Verify(sPara, Request.Form["notify_id"], Request.Form["sign"]); if (verifyResult)//验证成功 { ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中服务器异步通知参数列表 //商户订单号 string out_trade_no = Request.Form["out_trade_no"]; //支付宝交易号 string trade_no = Request.Form["trade_no"]; //交易状态 string trade_status = Request.Form["trade_status"]; if (Request.Form["trade_status"] == "TRADE_FINISHED") { Response.Write("success"); } else if (Request.Form["trade_status"] == "TRADE_SUCCESS") { var OrderModel = new Eyousoft_yhq.Model.Order(); var OrderBll = new Eyousoft_yhq.BLL.Order(); OrderModel = OrderBll.GetModel(out_trade_no); if (OrderModel != null && OrderModel.PayState == Eyousoft_yhq.Model.PaymentState.未支付) { string result = string.Empty; string Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); while (OrderBll.Exists(Ra)) { Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); } OrderModel.OrderID = out_trade_no; OrderModel.PayState = Eyousoft_yhq.Model.PaymentState.已支付; OrderModel.OrderState = Eyousoft_yhq.Model.OrderState.已成交; OrderModel.ConfirmCode = Ra; int Sum = OrderBll.UpdatePayState(OrderModel); if (Sum > 0) { Eyousoft_yhq.BLL.Member UM = new Eyousoft_yhq.BLL.Member(); bool Mo = UM.GetModel(OrderModel.MemberID).valiUser; if (!Mo) { #region 短信发送 string code = string.Empty; IList<Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); code = string.Format("下单成功,确认码:{0}!【惠旅游】", Ra); Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(OrderModel.MemberTel, code, channel[0], out result);//发送 #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = OrderModel.MemberTel, MsgText = code, ReResult = result }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion #endregion } } } var chongzhiModel = new Eyousoft_yhq.BLL.BChongZhi().GetModel(out_trade_no); if (chongzhiModel != null && chongzhiModel.PayState == Eyousoft_yhq.Model.PaymentState.未支付) { var member = new Eyousoft_yhq.BLL.Member().GetModel(chongzhiModel.OperatorID); if (member != null) { member.YuE = member.YuE + chongzhiModel.OptMoney; bool result = new Eyousoft_yhq.BLL.Member().Update(member); } new Eyousoft_yhq.BLL.BChongZhi().SheZhiZhiFus(out_trade_no, Eyousoft_yhq.Model.PaymentState.已支付); } } else { } //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— Response.Write("success"); //请不要修改或删除 ///////////////////////////////////////////////////////////////////////////////////////////////////////////// } else//验证失败 { Response.Write("fail"); } } else { Response.Write("无通知参数"); } }
protected void Page_Load(object sender, EventArgs e) { SortedDictionary <string, string> sPara = GetRequestPost(); if (sPara.Count > 0)//判断是否有带返回参数 { Notify aliNotify = new Notify(); bool verifyResult = aliNotify.Verify(sPara, Request.QueryString["notify_id"], Request.QueryString["sign"]); if (verifyResult)//验证成功 { ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中服务器异步通知参数列表 //商户订单号 string out_trade_no = Request.QueryString["out_trade_no"]; //支付宝交易号 string trade_no = Request.QueryString["trade_no"]; //交易状态 string trade_status = Request.QueryString["trade_status"]; Eyousoft_yhq.BLL.Order OrderType = new Eyousoft_yhq.BLL.Order(); var OrderModel = new Eyousoft_yhq.Model.Order(); string res = string.Empty; if (trade_status == "TRADE_FINISHED") { } else if (Request.QueryString["trade_status"] == "TRADE_SUCCESS") { OrderModel = OrderType.GetModel(out_trade_no); if (OrderModel != null && OrderModel.PayState != Eyousoft_yhq.Model.PaymentState.已支付) { Eyousoft_yhq.Model.MConDetaile jilu = new Eyousoft_yhq.Model.MConDetaile() { HuiYuanID = OrderModel.MemberID, XFway = Eyousoft_yhq.Model.XFfangshi.消费, DingDanBianHao = OrderModel.OrderCode, JiaoYiHao = DateTime.Now.ToString("yyyyMMddHHmm") + Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(5), JiaoYiShiJian = DateTime.Now, DDCarrtes = Eyousoft_yhq.Model.DDleibie.旅游订单, JinE = OrderModel.OrderPrice }; new Eyousoft_yhq.BLL.BConDetaile().Add(jilu);//消费记录 string Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); while (OrderType.Exists(Ra)) { Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); } Eyousoft_yhq.Model.Order OrderInfo = new Eyousoft_yhq.Model.Order() { OrderID = out_trade_no, PayState = Eyousoft_yhq.Model.PaymentState.已支付, ConfirmCode = Ra, OrderState = Eyousoft_yhq.Model.OrderState.已成交 }; int Sum = OrderType.UpdatePayState(OrderInfo); if (Sum > 0) { Eyousoft_yhq.BLL.Member UM = new Eyousoft_yhq.BLL.Member(); bool Mo = UM.GetModel(OrderModel.MemberID).valiUser; if (!Mo) { #region 短信发送 string code = string.Empty; IList <Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); code = string.Format("下单成功,确认码:{0}!【惠旅游】", Ra); Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(OrderModel.MemberTel, code, channel[0], out res);//发送 #endregion #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = OrderModel.MemberTel, MsgText = code, ReResult = res }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } } } var chongzhiModel = new Eyousoft_yhq.BLL.BChongZhi().GetModel(out_trade_no); if (chongzhiModel != null && chongzhiModel.PayState == Eyousoft_yhq.Model.PaymentState.未支付) { var member = new Eyousoft_yhq.BLL.Member().GetModel(chongzhiModel.OperatorID); if (member != null) { member.YuE = member.YuE + chongzhiModel.OptMoney; bool result = new Eyousoft_yhq.BLL.Member().Update(member); } new Eyousoft_yhq.BLL.BChongZhi().SheZhiZhiFus(out_trade_no, Eyousoft_yhq.Model.PaymentState.已支付); } } else { } //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— Response.Write("success"); //请不要修改或删除 Response.Redirect("/Huiyuan/OrderList.aspx"); ///////////////////////////////////////////////////////////////////////////////////////////////////////////// } else//验证失败 { Response.Write("fail"); } } else { Response.Write("无通知参数"); } }
protected void Page_Load(object sender, EventArgs e) { Dictionary <string, string> sPara = GetRequestPost(); if (sPara.Count > 0)//判断是否有带返回参数 { Notify aliNotify = new Notify(); bool verifyResult = aliNotify.VerifyNotify(sPara, Request.Form["sign"]); if (verifyResult)//验证成功 { ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中服务器异步通知参数列表 //解密(如果是RSA签名需要解密,如果是MD5签名则下面一行清注释掉) sPara = aliNotify.Decrypt(sPara); //XML解析notify_data数据 try { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(sPara["notify_data"]); //商户订单号 string out_trade_no = xmlDoc.SelectSingleNode("/notify/out_trade_no").InnerText; //支付宝交易号 string trade_no = xmlDoc.SelectSingleNode("/notify/trade_no").InnerText; //交易状态 string trade_status = xmlDoc.SelectSingleNode("/notify/trade_status").InnerText; if (trade_status == "TRADE_FINISHED")//交易成功 { Response.Write("success"); } else if (trade_status == "TRADE_SUCCESS")//支付成功 { Eyousoft_yhq.BLL.Order OrderType = new Eyousoft_yhq.BLL.Order(); var OrderModel = new Eyousoft_yhq.Model.Order(); OrderModel = OrderType.GetModel(out_trade_no); string res = string.Empty; if (OrderModel.PayState != Eyousoft_yhq.Model.PaymentState.已支付) { string Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); while (OrderType.Exists(Ra)) { Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); } Eyousoft_yhq.Model.Order OrderInfo = new Eyousoft_yhq.Model.Order() { OrderID = out_trade_no, PayState = Eyousoft_yhq.Model.PaymentState.已支付, ConfirmCode = Ra, OrderState = Eyousoft_yhq.Model.OrderState.已成交, JIESUAN = Eyousoft_yhq.Model.JSfangshi.预付 }; int Sum = OrderType.UpdatePayState(OrderInfo); if (Sum > 0) { Eyousoft_yhq.BLL.Member UM = new Eyousoft_yhq.BLL.Member(); bool Mo = UM.GetModel(OrderModel.MemberID).valiUser; if (!Mo) { #region 短信发送 string code = string.Empty; IList <Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); code = string.Format("下单成功,确认码:{0}!【惠旅游】", Ra); Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(OrderModel.MemberTel, code, channel[0], out res);//发送 #endregion #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = OrderModel.MemberTel, MsgText = code, ReResult = res }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } } } Response.Redirect("/AppPage/orderlist.aspx"); } else { Response.Write(trade_status); } } catch (Exception exc) { Response.Write(exc.ToString()); } //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— ///////////////////////////////////////////////////////////////////////////////////////////////////////////// } else//验证失败 { Response.Write("fail"); } } else { Response.Write("无通知参数"); } }
protected void Page_Load(object sender, EventArgs e) { SortedDictionary <string, string> sPara = GetRequestPost(); if (sPara.Count > 0)//判断是否有带返回参数 { Notify aliNotify = new Notify(); bool verifyResult = aliNotify.Verify(sPara, Request.Form["notify_id"], Request.Form["sign"]); if (verifyResult)//验证成功 { ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中服务器异步通知参数列表 //商户订单号 string out_trade_no = Request.Form["out_trade_no"]; //支付宝交易号 string trade_no = Request.Form["trade_no"]; //交易状态 string trade_status = Request.Form["trade_status"]; if (Request.Form["trade_status"] == "TRADE_FINISHED") { Response.Write("success"); } else if (Request.Form["trade_status"] == "TRADE_SUCCESS") { var OrderModel = new Eyousoft_yhq.Model.Order(); var OrderBll = new Eyousoft_yhq.BLL.Order(); OrderModel = OrderBll.GetModel(out_trade_no); if (OrderModel != null && OrderModel.PayState == Eyousoft_yhq.Model.PaymentState.未支付) { string result = string.Empty; string Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); while (OrderBll.Exists(Ra)) { Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); } OrderModel.OrderID = out_trade_no; OrderModel.PayState = Eyousoft_yhq.Model.PaymentState.已支付; OrderModel.OrderState = Eyousoft_yhq.Model.OrderState.已成交; OrderModel.ConfirmCode = Ra; int Sum = OrderBll.UpdatePayState(OrderModel); if (Sum > 0) { Eyousoft_yhq.BLL.Member UM = new Eyousoft_yhq.BLL.Member(); bool Mo = UM.GetModel(OrderModel.MemberID).valiUser; if (!Mo) { #region 短信发送 string code = string.Empty; IList <Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); code = string.Format("下单成功,确认码:{0}!【惠旅游】", Ra); Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(OrderModel.MemberTel, code, channel[0], out result);//发送 #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = OrderModel.MemberTel, MsgText = code, ReResult = result }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion #endregion } } } var chongzhiModel = new Eyousoft_yhq.BLL.BChongZhi().GetModel(out_trade_no); if (chongzhiModel != null && chongzhiModel.PayState == Eyousoft_yhq.Model.PaymentState.未支付) { var member = new Eyousoft_yhq.BLL.Member().GetModel(chongzhiModel.OperatorID); if (member != null) { member.YuE = member.YuE + chongzhiModel.OptMoney; bool result = new Eyousoft_yhq.BLL.Member().Update(member); } new Eyousoft_yhq.BLL.BChongZhi().SheZhiZhiFus(out_trade_no, Eyousoft_yhq.Model.PaymentState.已支付); } } else { } //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— Response.Write("success"); //请不要修改或删除 ///////////////////////////////////////////////////////////////////////////////////////////////////////////// } else//验证失败 { Response.Write("fail"); } } else { Response.Write("无通知参数"); } }
/// <summary> /// 添加订单 /// </summary> /// <returns></returns> private string saveOrder() { Eyousoft_yhq.Model.OrderState Orderstate = Eyousoft_yhq.Model.OrderState.未处理; int orderNums = Utils.GetInt(Utils.GetFormValue("orderNum")); string id = Utils.GetFormValue("id"); var model = new Eyousoft_yhq.BLL.Product().GetModel(id); if (model != null) { if (model.ResidueNum - orderNums >= 0) { Orderstate = Eyousoft_yhq.Model.OrderState.待付款; } Eyousoft_yhq.BLL.Order OrderBll = new Eyousoft_yhq.BLL.Order(); var MemberModel = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo(); if (MemberModel != null) { Eyousoft_yhq.Model.Order OrderModel = new Eyousoft_yhq.Model.Order() { ProductID = id, OrderCode = DateTime.Now.ToString("yyyy-MM-dd "), MemberID = MemberModel.UserID, MemberTel = Utils.GetFormValue("receiveMobile"), MemberName = Utils.GetFormValue("receiveName"), MemberSex = MemberModel.ContactSex, OrderState = Orderstate, PayState = Eyousoft_yhq.Model.PaymentState.未支付, IsCheck = true, ConfirmCode = "", Remark = "", OrderPrice = model.AppPrice * orderNums, PeopleNum = orderNums }; int num = OrderBll.Add(OrderModel); if (num > 0 && Orderstate == Eyousoft_yhq.Model.OrderState.待付款) { return(UtilsCommons.AjaxReturnJson("1", "操作成功,请及时付款!", OrderModel.OrderID)); } if (num > 0 && Orderstate == Eyousoft_yhq.Model.OrderState.未处理) { string result = string.Empty; //返回发送结果 string sendNum = string.Empty; //发送账号 Eyousoft_yhq.Model.MCompanySetting exModel = new Eyousoft_yhq.BLL.KV().GetCompanySetting(); if (exModel == null || exModel.MsgNumber <= 0) { return(UtilsCommons.AjaxReturnJson("2", "操作成功,等待审核!短信发送失败,请联系我们!")); } IList <Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); var ProductTypeModel = new Eyousoft_yhq.BLL.ProductType().GetModel(model.ProductType); if (ProductTypeModel == null || ProductTypeModel.AdminName == null) { sendNum = HuiYuanInfo.ContactTel; string Msg = "收到新订单请处理,订单号为:" + OrderModel.OrderCode.Trim() + "!【惠旅游】"; Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(sendNum, Msg, channel[0], out result);//发送 #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = sendNum, MsgText = Msg, ReResult = result }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } else { for (int i = 0; i < ProductTypeModel.AdminName.Count; i++) { sendNum = new Eyousoft_yhq.BLL.User().GetModel(ProductTypeModel.AdminName[i].AdminN).Telephone; string Msg = "收到新订单请处理,订单号为:" + OrderModel.OrderCode.Trim() + "!【惠旅游】"; Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(sendNum, Msg, channel[0], out result);//发送 #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = sendNum, MsgText = Msg, ReResult = result }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } } if (result == "成功") { return(UtilsCommons.AjaxReturnJson("2", "操作成功,等待审核!已通知客服人员!")); } return(UtilsCommons.AjaxReturnJson("2", "操作成功,等待审核!短信发送失败,请联系我们!")); } return(UtilsCommons.AjaxReturnJson("0", "操作失败!")); } else { return(UtilsCommons.AjaxReturnJson("0", "操作失败,请登陆后重新操作... ...")); } } return(UtilsCommons.AjaxReturnJson("0", "操作失败,此产品已经下架... ...")); }
/// <summary> /// 获取返佣 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList<Eyousoft_yhq.Model.Order> GetFYList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { IList<Eyousoft_yhq.Model.Order> list = new List<Eyousoft_yhq.Model.Order>(); string tableName = "view_Order"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" PayState=2 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.MemberID)) { query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' OR MemberID = '{1}' ) ", serModel.PromotionCode, serModel.MemberID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); list.Add(model); } }; return list; }
/// <summary> /// 添加订单 /// </summary> /// <returns></returns> private string saveOrder() { Eyousoft_yhq.Model.OrderState Orderstate = Eyousoft_yhq.Model.OrderState.未处理; int orderNums = Utils.GetInt(Utils.GetFormValue("orderNum")); string id = Utils.GetFormValue("id"); var model = new Eyousoft_yhq.BLL.Product().GetModel(id); if (model != null) { if (model.ResidueNum - orderNums >= 0) { Orderstate = Eyousoft_yhq.Model.OrderState.待付款; } Eyousoft_yhq.BLL.Order OrderBll = new Eyousoft_yhq.BLL.Order(); var MemberModel = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo(); if (MemberModel != null) { Eyousoft_yhq.Model.Order OrderModel = new Eyousoft_yhq.Model.Order() { ProductID = id, OrderCode = DateTime.Now.ToString("yyyy-MM-dd "), MemberID = MemberModel.UserID, MemberTel = Utils.GetFormValue("receiveMobile"), MemberName = Utils.GetFormValue("receiveName"), MemberSex = MemberModel.ContactSex, OrderState = Orderstate, PayState = Eyousoft_yhq.Model.PaymentState.未支付, IsCheck = true, ConfirmCode = "", Remark = "", OrderPrice = model.AppPrice * orderNums, PeopleNum = orderNums }; int num = OrderBll.Add(OrderModel); if (num > 0 && Orderstate == Eyousoft_yhq.Model.OrderState.待付款) { return UtilsCommons.AjaxReturnJson("1", "操作成功,请及时付款!", OrderModel.OrderID); } if (num > 0 && Orderstate == Eyousoft_yhq.Model.OrderState.未处理) { string result = string.Empty;//返回发送结果 string sendNum = string.Empty; //发送账号 Eyousoft_yhq.Model.MCompanySetting exModel = new Eyousoft_yhq.BLL.KV().GetCompanySetting(); if (exModel == null || exModel.MsgNumber <= 0) return UtilsCommons.AjaxReturnJson("2", "操作成功,等待审核!短信发送失败,请联系我们!"); IList<Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); var ProductTypeModel = new Eyousoft_yhq.BLL.ProductType().GetModel(model.ProductType); if (ProductTypeModel == null || ProductTypeModel.AdminName == null) { sendNum = HuiYuanInfo.ContactTel; string Msg = "收到新订单请处理,订单号为:" + OrderModel.OrderCode.Trim() + "!【惠旅游】"; Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(sendNum, Msg, channel[0], out result);//发送 #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = sendNum, MsgText = Msg, ReResult = result }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } else { for (int i = 0; i < ProductTypeModel.AdminName.Count; i++) { sendNum = new Eyousoft_yhq.BLL.User().GetModel(ProductTypeModel.AdminName[i].AdminN).Telephone; string Msg = "收到新订单请处理,订单号为:" + OrderModel.OrderCode.Trim() + "!【惠旅游】"; Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(sendNum, Msg, channel[0], out result);//发送 #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = sendNum, MsgText = Msg, ReResult = result }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } } if (result == "成功") return UtilsCommons.AjaxReturnJson("2", "操作成功,等待审核!已通知客服人员!"); return UtilsCommons.AjaxReturnJson("2", "操作成功,等待审核!短信发送失败,请联系我们!"); } return UtilsCommons.AjaxReturnJson("0", "操作失败!"); } else { return UtilsCommons.AjaxReturnJson("0", "操作失败,请登陆后重新操作... ..."); } } return UtilsCommons.AjaxReturnJson("0", "操作失败,此产品已经下架... ..."); }
/// <summary> /// 获取一个订单 /// </summary> /// <param name="OrderID">订单编号</param> /// <returns></returns> public Eyousoft_yhq.Model.Order GetModel(string OrderID) { Eyousoft_yhq.Model.Order model = null; string StrSql = "select * from view_Order where OrderId=@OrderId"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "OrderId", DbType.AnsiStringFixedLength, OrderID); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.SendFile = this.GetAttachList(dr["ComAttachXML"].ToString(), OrderID); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); model.AvailNum = dr.IsDBNull(dr.GetOrdinal("AvailNum")) ? 0 : dr.GetInt32(dr.GetOrdinal("AvailNum")); } } return model; }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList<Eyousoft_yhq.Model.Order> GetScanList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { IList<Eyousoft_yhq.Model.Order> list = new List<Eyousoft_yhq.Model.Order>(); string tableName = "view_OrderScan"; string fileds = " * "; string orderByString = " AppTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (serModel.ConSumState.HasValue) { query.AppendFormat(" AND ConSumState = '{0}' ", (int)serModel.ConSumState.Value); } if (!string.IsNullOrEmpty(serModel.OrderCode)) { query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode); } if (!string.IsNullOrEmpty(serModel.ConfirmCode)) { query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode); } if (!string.IsNullOrEmpty(serModel.AppUserId)) { query.AppendFormat(" and AppUserId = '{0}' ", serModel.AppUserId); } if (!string.IsNullOrEmpty(serModel.AppUser)) { query.AppendFormat(" and AppUserName like '%{0}%' ", serModel.ConfirmCode); } if (serModel.STime.HasValue) { query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value); } if (serModel.ETime.HasValue) { query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1)); } if (serModel.XSTime.HasValue) { query.AppendFormat(" AND AppTime>='{0}' ", serModel.XSTime.Value); } if (serModel.XETime.HasValue) { query.AppendFormat(" AND AppTime< '{0}' ", serModel.XETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(serModel.RouteName)) { query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.AppTime = dr.IsDBNull(dr.GetOrdinal("AppTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("AppTime")); model.AppUserName = dr.IsDBNull(dr.GetOrdinal("AppUserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("AppUserName")); model.AppMobNo = dr.IsDBNull(dr.GetOrdinal("AppMobNo")) ? "" : dr.GetString(dr.GetOrdinal("AppMobNo")); list.Add(model); } }; return list; }
protected string SaveAdress() { string OrderID = Utils.GetQueryStringValue("OrderId"); string Adress = Utils.GetQueryStringValue("AdId"); Eyousoft_yhq.BLL.Order Or = new Eyousoft_yhq.BLL.Order(); Eyousoft_yhq.Model.Order OrModel = new Eyousoft_yhq.Model.Order { OrderID = OrderID, AddressID = Adress }; bool IsTrue = Or.setAddressID(OrModel); if (IsTrue) { return UtilsCommons.AjaxReturnJson("1", "合同寄送地址添加成功!"); } else { return UtilsCommons.AjaxReturnJson("0", "合同寄送地址添加失败!"); } }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList<Eyousoft_yhq.Model.Order> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { IList<Eyousoft_yhq.Model.Order> list = new List<Eyousoft_yhq.Model.Order>(); string tableName = "view_Order"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.MemberID)) { query.AppendFormat(" and MemberID = '{0}' ", serModel.MemberID); } if (!string.IsNullOrEmpty(serModel.OrderCode)) { query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode); } if (!string.IsNullOrEmpty(serModel.ConfirmCode)) { query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode); } if (!string.IsNullOrEmpty(serModel.AppUserId)) { query.AppendFormat(" and AppUserId = '{0}' ", serModel.AppUserId); } if (!string.IsNullOrEmpty(serModel.AppUser)) { query.AppendFormat(" and AppUserName like '%{0}%' ", serModel.ConfirmCode); } if (serModel.OrderState.HasValue) { query.AppendFormat(" AND OrderState = '{0}' ", (int)serModel.OrderState.Value); } if (serModel.ConSumState.HasValue) { query.AppendFormat(" AND ConSumState = '{0}' ", (int)serModel.ConSumState.Value); } if (serModel.PaymentState.HasValue) { query.AppendFormat(" AND PayState = '{0}' ", (int)serModel.PaymentState.Value); } if (serModel.STime.HasValue) { query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value); } if (serModel.ETime.HasValue) { query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1)); } if (serModel.XSTime.HasValue) { query.AppendFormat(" AND AppTime>='{0}' ", serModel.XSTime.Value); } if (serModel.XETime.HasValue) { query.AppendFormat(" AND AppTime< '{0}' ", serModel.XETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(serModel.RouteName)) { query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName); } if (serModel.OrderPrice != 0) { query.AppendFormat(" AND OrderPrice = '{0}' ", serModel.OrderPrice); } if (!string.IsNullOrEmpty(serModel.PromotionCode)) { query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' )", serModel.PromotionCode); } if (serModel.jiesuan.HasValue) { query.AppendFormat(" AND JState = '{0}' ", (int)serModel.jiesuan.Value); } if (!string.IsNullOrEmpty(serModel.ChanPinFaBuRenId)) { query.AppendFormat(" AND ChanPinFaBuRenId='{0}' ", serModel.ChanPinFaBuRenId); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.SendFile = this.GetAttachList(dr["ComAttachXML"].ToString(), model.OrderID); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.AppTime = dr.IsDBNull(dr.GetOrdinal("AppTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("AppTime")); model.AppUserName = dr.IsDBNull(dr.GetOrdinal("AppUserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("AppUserName")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); model.WeiDianName = dr["WeiDianName"].ToString(); list.Add(model); } }; return list; }
protected void Page_Load(object sender, EventArgs e) { #region 订单信息 string tmpOrderId = Request.QueryString["OrderId"]; Eyousoft_yhq.BLL.Order OrderInfo = new Eyousoft_yhq.BLL.Order(); Eyousoft_yhq.Model.Order OrderModel = null; if (!string.IsNullOrEmpty(tmpOrderId)) { OrderModel = OrderInfo.GetModel(tmpOrderId); if (OrderModel != null) { if (OrderModel.OrderPrice <= 0) { Response.Write("支付金额必须大于0才能支付!"); Response.End(); } else if (OrderModel.OrderState != Eyousoft_yhq.Model.OrderState.待付款) { Response.Write("订单状态不符合请稍候支付"); Response.End(); } else if (OrderModel.PayState != Eyousoft_yhq.Model.PaymentState.未支付) { Response.Write("订单已支付"); Response.End(); } } } else { Response.Write("订单错误"); Response.End(); } #endregion #region 手机支付宝 支付 //支付宝网关地址 string GATEWAY_NEW = "http://wappaygw.alipay.com/service/rest.htm?"; ////////////////////////////////////////////调用授权接口alipay.wap.trade.create.direct获取授权码token//////////////////////////////////////////// //返回格式 string format = "xml"; //必填,不需要修改 //返回格式 string v = "2.0"; //必填,不需要修改 //请求号 string req_id = DateTime.Now.ToString("yyyyMMddHHmmss"); //必填,须保证每次请求都是唯一 //req_data详细信息 //服务器异步通知页面路径 string notify_url = AlipayLibrary.Config.GetConfigString("Alipay", "app_notify_url");// "http://www.xxx.com/Alipay/notify_url.aspx"; //需http://格式的完整路径,不允许加?id=123这类自定义参数 //页面跳转同步通知页面路径 string call_back_url = AlipayLibrary.Config.GetConfigString("Alipay", "app_callback_url");// "http://127.0.0.1:64704/Alipay/call_back_url.aspx"; //需http://格式的完整路径,不允许加?id=123这类自定义参数 //操作中断返回地址 string merchant_url = AlipayLibrary.Config.GetConfigString("Alipay", "app_return_url"); //用户付款中途退出返回商户的地址。需http://格式的完整路径,不允许加?id=123这类自定义参数 #region 订单信息|卖家帐号 //卖家支付宝帐户 string seller_email = AlipayLibrary.Config.GetConfigString("appSettings", "AlipayAccount"); //必填 //商户订单号 string out_trade_no = OrderModel.OrderID; //商户网站订单系统中唯一订单号,必填 //订单名称 string subject = "产品名称:" + OrderModel.ProductName; //必填 //付款金额 string total_fee = OrderModel.OrderPrice.ToString(); //必填 #endregion //请求业务参数详细 string req_dataToken = "<direct_trade_create_req><notify_url>" + notify_url + "</notify_url><call_back_url>" + call_back_url + "</call_back_url><seller_account_name>" + seller_email + "</seller_account_name><out_trade_no>" + out_trade_no + "</out_trade_no><subject>" + subject + "</subject><total_fee>" + total_fee + "</total_fee><merchant_url>" + merchant_url + "</merchant_url></direct_trade_create_req>"; //必填 //把请求参数打包成数组 Dictionary <string, string> sParaTempToken = new Dictionary <string, string>(); sParaTempToken.Add("partner", Config.Partner); sParaTempToken.Add("_input_charset", Config.Input_charset.ToLower()); sParaTempToken.Add("sec_id", Config.Sign_type.ToUpper()); sParaTempToken.Add("service", "alipay.wap.trade.create.direct"); sParaTempToken.Add("format", format); sParaTempToken.Add("v", v); sParaTempToken.Add("req_id", req_id); sParaTempToken.Add("req_data", req_dataToken); //建立请求 string sHtmlTextToken = Submit.BuildRequest(GATEWAY_NEW, sParaTempToken); //URLDECODE返回的信息 Encoding code = Encoding.GetEncoding(Config.Input_charset); sHtmlTextToken = HttpUtility.UrlDecode(sHtmlTextToken, code); //解析远程模拟提交后返回的信息 Dictionary <string, string> dicHtmlTextToken = Submit.ParseResponse(sHtmlTextToken); //获取token string request_token = dicHtmlTextToken["request_token"]; ////////////////////////////////////////////根据授权码token调用交易接口alipay.wap.auth.authAndExecute//////////////////////////////////////////// //业务详细 string req_data = "<auth_and_execute_req><request_token>" + request_token + "</request_token></auth_and_execute_req>"; //必填 //把请求参数打包成数组 Dictionary <string, string> sParaTemp = new Dictionary <string, string>(); sParaTemp.Add("partner", Config.Partner); sParaTemp.Add("_input_charset", Config.Input_charset.ToLower()); sParaTemp.Add("sec_id", Config.Sign_type.ToUpper()); sParaTemp.Add("service", "alipay.wap.auth.authAndExecute"); sParaTemp.Add("format", format); sParaTemp.Add("v", v); sParaTemp.Add("req_data", req_data); //建立请求 string sHtmlText = Submit.BuildRequest(GATEWAY_NEW, sParaTemp, "get", "确认"); Response.Write(sHtmlText); #endregion }
protected string MemberOrder(string PId) { var model = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo(); //用户是否登录 if (model != null) { Eyousoft_yhq.BLL.Product ProductBll = new Eyousoft_yhq.BLL.Product(); var ProModel = ProductBll.GetModel(PId); Eyousoft_yhq.Model.Order order = new Eyousoft_yhq.Model.Order(); //产品是否存在 if (ProModel != null) { if (ProModel != null && ProModel.ResidueNum <= 0) { Eyousoft_yhq.Model.MCompanySetting exModel = new Eyousoft_yhq.BLL.KV().GetCompanySetting(); //短信数量 if (exModel != null && exModel.MsgNumber > 0) { IList<Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); bool IsMsgAdd = AddOrder(PId, (int)Eyousoft_yhq.Model.OrderState.未处理, ProModel.AppPrice, out order); if (IsMsgAdd) { string result = string.Empty;//返回发送结果 string sendNum = string.Empty; //发送账号 Eyousoft_yhq.BLL.ProductType ProductTypeBll = new Eyousoft_yhq.BLL.ProductType(); var ProductTypeModel = ProductTypeBll.GetModel(ProModel.ProductType); var AdminUser = new EyouSoft.Model.SSOStructure.MWebmasterInfo(); if (ProductTypeModel != null) { for (int i = 0; i < ProductTypeModel.AdminName.Count; i++) { AdminUser = new Eyousoft_yhq.BLL.User().GetModel(ProductTypeModel.AdminName[i].AdminN); if (AdminUser != null) sendNum = AdminUser.Telephone; string Msg = string.Format("产品{0}有未处理订单,订单号:{1}!【惠旅游】", ProModel.ProductName, order.OrderCode); Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(sendNum, Msg, channel[0], out result);//发送 #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = sendNum, MsgText = Msg, ReResult = result }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } } if (result == "成功") return UtilsCommons.AjaxReturnJson("1", "下单成功,订单由客服人员进行座位确认,在72小时内会短信通知您是否成交"); return UtilsCommons.AjaxReturnJson("1", "下单成功,我们会尽快与您联系!"); } else { return UtilsCommons.AjaxReturnJson("0", "下单失败,请重新下单"); } } else { return UtilsCommons.AjaxReturnJson("0", "短信系统维护中,请稍后再试!"); } } else { bool IsAdd = AddOrder(PId, (int)Eyousoft_yhq.Model.OrderState.待付款, ProModel.AppPrice, out order); if (IsAdd) { return UtilsCommons.AjaxReturnJson("99", "下单成功,请付款", order.OrderID); } else { return UtilsCommons.AjaxReturnJson("0", "下单失败,请重新下单"); } } } else { return UtilsCommons.AjaxReturnJson("0", "商品已下价!"); } } else { return UtilsCommons.AjaxReturnJson("2", "请先登录再操作!"); } }
protected void Page_Load(object sender, EventArgs e) { Dictionary<string, string> sPara = GetRequestGet(); if (sPara.Count > 0)//判断是否有带返回参数 { Notify aliNotify = new Notify(); bool verifyResult = aliNotify.VerifyReturn(sPara, Request.QueryString["sign"]); if (verifyResult)//验证成功 { ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中页面跳转同步通知参数列表 //商户订单号 string out_trade_no = Request.QueryString["out_trade_no"]; //支付宝交易号 string trade_no = Request.QueryString["trade_no"]; //交易状态 string result = Request.QueryString["result"]; Eyousoft_yhq.BLL.Order OrderType = new Eyousoft_yhq.BLL.Order(); var OrderModel = new Eyousoft_yhq.Model.Order(); string res = string.Empty; if (result == "success") { //纪录充值消费纪录 try { string price = Request.QueryString["price"]; Eyousoft_yhq.BLL.BConDetaile service = new Eyousoft_yhq.BLL.BConDetaile(); Eyousoft_yhq.Model.MConDetaile con = new Eyousoft_yhq.Model.MConDetaile(); con.JiaoYiHao = trade_no; con.DingDanBianHao = out_trade_no; con.JinE = Decimal.Parse(price); con.JiaoYiShiJian = DateTime.Now; con.XFway = Eyousoft_yhq.Model.XFfangshi.消费; EyouSoft.Model.SSOStructure.MUserInfo userInfo = Session["HuiYuanInfo"] as EyouSoft.Model.SSOStructure.MUserInfo; con.HuiYuanID = userInfo.UserID; service.Add(con); } catch (Exception) { } OrderModel = OrderType.GetModel(out_trade_no); if (OrderModel.PayState != Eyousoft_yhq.Model.PaymentState.已支付) { string Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); while (OrderType.Exists(Ra)) { Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); } Eyousoft_yhq.Model.Order OrderInfo = new Eyousoft_yhq.Model.Order() { OrderID = out_trade_no, PayState = Eyousoft_yhq.Model.PaymentState.已支付, ConfirmCode = Ra, OrderState = Eyousoft_yhq.Model.OrderState.已成交 }; int Sum = OrderType.UpdatePayState(OrderInfo); if (Sum > 0) { Eyousoft_yhq.BLL.Member UM = new Eyousoft_yhq.BLL.Member(); bool Mo = UM.GetModel(OrderModel.MemberID).valiUser; if (!Mo) { #region 短信发送 string code = string.Empty; IList<Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); //code = CreateZxingCode(Ra) + string.Format("下单成功,确认码:{0}!【惠旅游】", Ra);//生成二维码,发送彩信 Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(OrderModel.MemberTel, code, channel[0], out res);//发送 #endregion #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = OrderModel.MemberTel, MsgText = code, ReResult = res }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } } } } Response.Redirect("/AppPage/orderlist.aspx"); //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— ///////////////////////////////////////////////////////////////////////////////////////////////////////////// } else//验证失败 { Response.Write("验证失败"); } } else { Response.Write("无返回参数"); } }
protected void Page_Load(object sender, EventArgs e) { Dictionary<string, string> sPara = GetRequestPost(); if (sPara.Count > 0)//判断是否有带返回参数 { Notify aliNotify = new Notify(); bool verifyResult = aliNotify.VerifyNotify(sPara, Request.Form["sign"]); if (verifyResult)//验证成功 { ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中服务器异步通知参数列表 //解密(如果是RSA签名需要解密,如果是MD5签名则下面一行清注释掉) sPara = aliNotify.Decrypt(sPara); //XML解析notify_data数据 try { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(sPara["notify_data"]); //商户订单号 string out_trade_no = xmlDoc.SelectSingleNode("/notify/out_trade_no").InnerText; //支付宝交易号 string trade_no = xmlDoc.SelectSingleNode("/notify/trade_no").InnerText; //交易状态 string trade_status = xmlDoc.SelectSingleNode("/notify/trade_status").InnerText; if (trade_status == "TRADE_FINISHED")//交易成功 { Response.Write("success"); } else if (trade_status == "TRADE_SUCCESS")//支付成功 { Eyousoft_yhq.BLL.Order OrderType = new Eyousoft_yhq.BLL.Order(); var OrderModel = new Eyousoft_yhq.Model.Order(); OrderModel = OrderType.GetModel(out_trade_no); string res = string.Empty; if (OrderModel.PayState != Eyousoft_yhq.Model.PaymentState.已支付) { string Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); while (OrderType.Exists(Ra)) { Ra = Eyousoft_yhq.SQLServerDAL.Utils.GetRandomString(12); } Eyousoft_yhq.Model.Order OrderInfo = new Eyousoft_yhq.Model.Order() { OrderID = out_trade_no, PayState = Eyousoft_yhq.Model.PaymentState.已支付, ConfirmCode = Ra, OrderState = Eyousoft_yhq.Model.OrderState.已成交, JIESUAN = Eyousoft_yhq.Model.JSfangshi.预付 }; int Sum = OrderType.UpdatePayState(OrderInfo); if (Sum > 0) { Eyousoft_yhq.BLL.Member UM = new Eyousoft_yhq.BLL.Member(); bool Mo = UM.GetModel(OrderModel.MemberID).valiUser; if (!Mo) { #region 短信发送 string code = string.Empty; IList<Eyousoft_yhq.Model.SMSChannel> channel = Eyousoft_yhq.Web.BsendMsg.CommonProcess.GetSMSChannels(); code = string.Format("下单成功,确认码:{0}!【惠旅游】", Ra); Eyousoft_yhq.Web.BsendMsg.CommonProcess.SendSMS(OrderModel.MemberTel, code, channel[0], out res);//发送 #endregion #region 短信日志 Eyousoft_yhq.Model.MsgLog MsLog = new Eyousoft_yhq.Model.MsgLog { TelCode = OrderModel.MemberTel, MsgText = code, ReResult = res }; new Eyousoft_yhq.BLL.MsgLog().Add(MsLog); #endregion } } } Response.Redirect("/AppPage/orderlist.aspx"); } else { Response.Write(trade_status); } } catch (Exception exc) { Response.Write(exc.ToString()); } //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— ///////////////////////////////////////////////////////////////////////////////////////////////////////////// } else//验证失败 { Response.Write("fail"); } } else { Response.Write("无通知参数"); } }