QiFeng.ZWY.Dal/WechatEventHistory.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System; 
using System.Text;
using System.Data.SqlClient;
using System.Data;
using QiFeng.LMSD.DBUtility;
using QiFeng.LMSD.Model;

namespace QiFeng.LMSD.Dal
{
    public class WechatEventHistoryDal : BaseDal<WechatEventHistoryDal>
	{
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(WechatEventHistory model, string tableName)
        {
            var strSql = new StringBuilder();
            strSql.Append("insert into " + tableName + "(");
            strSql.Append("WechatInfoId,ToUserName,FromUserName,MsgType,Event,EventContent,CreateTime,ReceiveTime,EventKey,Ticket,Latitude,Longitude,Precision,CardId,FriendUserName,IsGiveByFriend,UserCardCode,OldUserCardCode,OuterId,ConsumeSource,LocationId,StaffOpenId,TransId,Fee,OriginalFee,ModifyBonus,ModifyBalance,Detail,OrderId,Status,PayFinishTime,[Desc],FreeCoinCount,PayCoinCount,RefundFreeCoinCount,RefundPayCoinCount,OrderType,Memo,ReceiptInfo,FailTime,FailReason,ExpiredTime, AddTime, IsDelete");
            strSql.Append(") values (");
            strSql.Append("@WechatInfoId,@ToUserName,@FromUserName,@MsgType,@Event,@EventContent,@CreateTime,@ReceiveTime,@EventKey,@Ticket,@Latitude,@Longitude,@Precision,@CardId,@FriendUserName,@IsGiveByFriend,@UserCardCode,@OldUserCardCode,@OuterId,@ConsumeSource,@LocationId,@StaffOpenId,@TransId,@Fee,@OriginalFee,@ModifyBonus,@ModifyBalance,@Detail,@OrderId,@Status,@PayFinishTime,@Desc,@FreeCoinCount,@PayCoinCount,@RefundFreeCoinCount,@RefundPayCoinCount,@OrderType,@Memo,@ReceiptInfo,@FailTime,@FailReason,@ExpiredTime,@AddTime, @IsDelete");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
			            new SqlParameter("@WechatInfoId", SqlDbType.Int,4) ,            
                        new SqlParameter("@ToUserName", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@FromUserName", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@MsgType", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@Event", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@EventContent", SqlDbType.NVarChar,4000) ,            
                        new SqlParameter("@CreateTime", SqlDbType.Int,4) ,            
                        new SqlParameter("@ReceiveTime", SqlDbType.DateTime) ,            
                        new SqlParameter("@EventKey", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Ticket", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Latitude", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Longitude", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Precision", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@CardId", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@FriendUserName", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@IsGiveByFriend", SqlDbType.Int,4) ,            
                        new SqlParameter("@UserCardCode", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@OldUserCardCode", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@OuterId", SqlDbType.Int,4) ,            
                        new SqlParameter("@ConsumeSource", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@LocationId", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@StaffOpenId", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@TransId", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@Fee", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@OriginalFee", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@ModifyBonus", SqlDbType.Int,4) ,            
                        new SqlParameter("@ModifyBalance", SqlDbType.Int,4) ,            
                        new SqlParameter("@Detail", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@OrderId", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Status", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@PayFinishTime", SqlDbType.Int,4) ,            
                        new SqlParameter("@Desc", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@FreeCoinCount", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@PayCoinCount", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@RefundFreeCoinCount", SqlDbType.NVarChar,50) ,            
                        new SqlParameter("@RefundPayCoinCount", SqlDbType.NVarChar,50) ,