/// <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("无返回参数"); } }