QiFeng.ZWY.Dal/WechatInfo.cs

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

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

using System; 
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using QiFeng.LMSD.DBUtility;
using QiFeng.LMSD.Model;
using QiFeng.LMSD.Model.Dto;

namespace QiFeng.LMSD.Dal
{
	public partial class WechatInfoDal : BaseDal<WechatInfoDal>
	{
		#region 默认方法
		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatInfo model)
		{
			var strSql=new StringBuilder();
			strSql.Append("insert into WechatInfo(");			
            strSql.Append("WechatId,WeChatName,WechatLogin,WechatPwd,AppId,Secret,OriginalId,CreateDate,AreaId,AuthorizeUrl,PayKey,MchId,NickName,Menus,SignatureToken,CertPath,NjiaCode,IsDelete");
			strSql.Append(") values (");
            strSql.Append("@WechatId,@WeChatName,@WechatLogin,@WechatPwd,@AppId,@Secret,@OriginalId,@CreateDate,@AreaId,@AuthorizeUrl,@PayKey,@MchId,@NickName,@Menus,@SignatureToken,@CertPath,@NjiaCode,@IsDelete");            
            strSql.Append(") ");            
            strSql.Append(";select @@IDENTITY");		
			SqlParameter[] parameters = {
			            new SqlParameter("@WechatId", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@WeChatName", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@WechatLogin", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@WechatPwd", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@AppId", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@Secret", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@OriginalId", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@CreateDate", SqlDbType.DateTime) ,            
                        new SqlParameter("@AreaId", SqlDbType.Int,4) ,            
                        new SqlParameter("@AuthorizeUrl", SqlDbType.NVarChar,512) ,            
                        new SqlParameter("@PayKey", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@MchId", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@NickName", SqlDbType.NVarChar,64) ,            
                        new SqlParameter("@Menus", SqlDbType.NVarChar,2048) ,            
                        new SqlParameter("@SignatureToken", SqlDbType.NVarChar,32) ,            
                        new SqlParameter("@CertPath", SqlDbType.NVarChar,512) ,  
                        new SqlParameter("@NjiaCode", SqlDbType.NVarChar, 64), 
                        new SqlParameter("@IsDelete", SqlDbType.Bit,1)             
              
            };
			            
            parameters[0].Value = model.WechatId;                        
            parameters[1].Value = model.WeChatName;                        
            parameters[2].Value = model.WechatLogin;                        
            parameters[3].Value = model.WechatPwd;                        
            parameters[4].Value = model.AppId;                        
            parameters[5].Value = model.Secret;                        
            parameters[6].Value = model.OriginalId;                        
            parameters[7].Value = model.CreateDate;                        
            parameters[8].Value = model.AreaId;                        
            parameters[9].Value = model.AuthorizeUrl;                        
            parameters[10].Value = model.PayKey;