微信支付后台服务器返回的接口通知notify_url(回调接口设计)-C/S框架网

C# Code:

using CSFramework.DB;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
/// DBHelper数据层
/// </summary>
public static class DBHelper
{
   //日志数据库
   private static IDatabase CreateLogDB()
   {
      string conn_log = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["Simidata_LogDB"].ToString();
      return DatabaseFactory.CreateDatabase(DatabaseType.SqlServer, conn_log);
   }
   
   //业务数据库
   private static IDatabase CreateSimidataDB()
   {
      string conn_log = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["Simidata"].ToString();
      return DatabaseFactory.CreateDatabase(DatabaseType.SqlServer, conn_log);
   }
   
   /// <summary>
   /// 写日志
   /// </summary>
   /// <param name="logType">日志类型</param>
   /// <param name="content">内容</param>
   /// <param name="ip">IP</param>
   public static void WriteLog(string logType, string content, string ip)
   {
      string sql = "INSERT INTO dbo.sys_Log(TS,IP,LogType,LogContent) SELECT GETDATE(),@IP,@LogType,@LogContent";
      IDatabase db = CreateLogDB();
      CommandHelper cmd = db.CreateCommand(sql);
      cmd.AddParam("@IP", ip);
      cmd.AddParam("@LogType", logType);
      cmd.AddParam("@LogContent", content);
      db.ExecuteCommand(cmd.Command);
   }
   
   /// <summary>
   /// 更新本地数据库订单状态
   /// </summary>
   /// <param name="orderID">订单编号</param>
   /// <param name="success">true/false</param>
   /// <param name="WxTransactionID">微信交易号</param>
   /// <param name="amount">金额(分)</param>
   /// <returns></returns>
   public static bool UpdateOrderState(string orderID, bool success, string WxTransactionID, int amount)
   {
      string sql = "UPDATE dbo.tb_PayTransList SET FlagTrans=2,WxCallbackTime=GETDATE(),WxTransactionID=@WxTransactionID WHERE MerID=@MerID AND Amount*100=@Amount";
      
      IDatabase db = CreateSimidataDB ();
      CommandHelper cmd = db.CreateCommand(sql);
      cmd.AddParam("@WxTransactionID", WxTransactionID);
      cmd.AddParam("@MerID", orderID);
      cmd.AddParam("@Amount", amount);
      int i = db.ExecuteCommand(cmd.Command);
      return i == 1;
   }
}

//来源:C/S框架网(www.csframework.com) QQ:23404761

C# Code:

<xml>
<return_code><![CDATA[SUCCESS]]></return_code>
<return_msg><![CDATA[OK]]></return_msg>
</xml>