/// <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="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();
}
/// <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="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("无通知参数");
}
}
