/// <summary>
/// 添加订单
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public Message Add(Olb_ChargeOrder info)
{
Message m;
try
{
//需要为每个方法创建一个DataContext实例 原因在于DataContext的缓存机制
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
Table <Olb_ChargeOrder> tbl = dd.GetTable <Olb_ChargeOrder>();
//string guid = Guid.NewGuid().ToString();
//info.ID = guid;
tbl.InsertOnSubmit(info);
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <Olb_ChargeOrder>(info)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "添加订单失败！" + e.Message
};
}
return(m);
}
/// <summary>
/// 编辑订单
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public Message Edit(Olb_ChargeOrder info)
{
Message m;
try
{
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
Olb_ChargeOrder dbinfo = dd.GetTable <Olb_ChargeOrder>().Where(p => p.ID == info.ID).SingleOrDefault();
ConvertHelper.Copy <Olb_ChargeOrder>(dbinfo, info);
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <Olb_ChargeOrder>(dbinfo)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "编辑订单失败！" + e.Message
};
}
return(m);
}
public Olb_ChargeOrder GetChargeOrderById(string id)
{
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
Olb_ChargeOrder dbinfo = dd.GetTable <Olb_ChargeOrder>().Where(p => p.ID == id).SingleOrDefault();
return(dbinfo);
}
protected void Page_Load(object sender, EventArgs e)
{
SortedDictionary <string, string> sPara = GetRequestGet();
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"];
if (Request.QueryString["trade_status"] == "TRADE_FINISHED" || Request.QueryString["trade_status"] == "TRADE_SUCCESS")
{
//判断该笔订单是否在商户网站中已经做过处理
//如果没有做过处理，根据订单号（out_trade_no）在商户网站的订单系统中查到该笔订单的详细，并执行商户的业务程序
//如果有做过处理，不执行商户的业务程序
Olb_ChargeOrder order = ChargeOrderService.GetInstance().GetChargeOrderById(out_trade_no);
if (order != null)
{
string result = IotMService.GetInstance().Charge(order.GasUserID, order.CompanyID, (decimal)order.OrderMoney);
if (result == "")
{
GasUser gasUser = IotMService.GetInstance().GetGasUserByUserId(order.GasUserID, order.CompanyID);
Olb_PaymentRecord payMent = new Olb_PaymentRecord()
{
Account = order.Account,
GasUserID = order.GasUserID,
PayMoney = order.OrderMoney,
PayTime = DateTime.Now,
Balance = gasUser.Balance,
GasUserAddress = gasUser.Address,
GasUserName = gasUser.UserName
};
PaymentManageService.GetInstance().AddPaymentRecord(payMent);
//jsonMessage = new Message() { Result = true, TxtMessage = "充值成功。" };
Response.Redirect("../PayMentDetail.aspx");
}
}
}
else
{
Response.Write("trade_status=" + Request.QueryString["trade_status"]);
}
//打印页面
Response.Write("验证成功<br />");
//——请根据您的业务逻辑来编写程序（以上代码仅作参考）——
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
}
else//验证失败
{
Response.Write("验证失败");
}
}
else
{
Response.Write("无返回参数");
}
}
