QiFeng.ZWY.Dal/WechatMsgRev.cs

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

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

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

namespace QiFeng.LMSD.Dal
{
    public class WechatMsgRevDal : BaseDal<WechatMsgRevDal>
    {
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(WechatMsgRev model, string tableName)
        {
            var strSql = new StringBuilder();
            strSql.Append("insert into " + tableName + "(");
            strSql.Append("WechatInfoId,ToUserName,FromUserName,CreateTime,MsgType,Event,EventKey,Ticket,Latitude,Longitude,Precision,CardId,IsGiveByFriend,UserCardCode,OuterId,MsgId,MediaId,Content,PicUrl,Format,ThumbMediaId,Location_X,Location_Y,Scale,Label,Title,Description,Url,AddTime,IsDelete");
            strSql.Append(") values (");
            strSql.Append("@WechatInfoId,@ToUserName,@FromUserName,@CreateTime,@MsgType,@Event,@EventKey,@Ticket,@Latitude,@Longitude,@Precision,@CardId,@IsGiveByFriend,@UserCardCode,@OuterId,@MsgId,@MediaId,@Content,@PicUrl,@Format,@ThumbMediaId,@Location_X,@Location_Y,@Scale,@Label,@Title,@Description,@Url,@AddTime,@IsDelete");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
			            new SqlParameter("@WechatInfoId", SqlDbType.Int,4) ,            
                        new SqlParameter("@ToUserName", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@FromUserName", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@CreateTime", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@MsgType", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Event", SqlDbType.NVarChar,255) ,            
                        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,255) ,            
                        new SqlParameter("@IsGiveByFriend", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@UserCardCode", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@OuterId", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@MsgId", SqlDbType.BigInt,8) ,            
                        new SqlParameter("@MediaId", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Content", SqlDbType.NVarChar,4000) ,            
                        new SqlParameter("@PicUrl", SqlDbType.NVarChar,1024) ,            
                        new SqlParameter("@Format", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@ThumbMediaId", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Location_X", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Location_Y", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Scale", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Label", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Title", SqlDbType.NVarChar,255) ,            
                        new SqlParameter("@Description", SqlDbType.Text) ,            
                        new SqlParameter("@Url", SqlDbType.NVarChar,1024) ,  
                        new SqlParameter("@AddTime", SqlDbType.DateTime), 
                        new SqlParameter("@IsDelete", SqlDbType.Bit,1)             
              
            };

            parameters[0].Value = model.WechatInfoId;
            parameters[1].Value = model.ToUserName;
            parameters[2].Value = model.FromUserName;