Dal/DSiteSettings.cs

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

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

using System;
using System.Text;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Data;
using Model;
namespace Dal
{
    public partial class DSiteSettings
    {
        #region  Method
        public bool HasRecord(int Site_Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from SiteSettings");
            strSql.Append(" where ");
            strSql.Append(" Site_Id = @Site_Id  ");
            SqlParameter[] parameters = {
					new SqlParameter("@Site_Id", SqlDbType.Int,4)
};
            parameters[0].Value = Site_Id;

            return OLEDBHelper.HasRecord(strSql.ToString(), parameters, CommandType.Text);
        }



        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(MSiteSettings model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SiteSettings(");
            strSql.Append("Site_Id,Site_Dir,Site_annlys,Site_Pop,Site_Service,Site_Name,Site_Seo,Site_Static,Site_Logo,Site_Water,Water_Top,Water_Left,Water_Pic");
            strSql.Append(") values (");
            strSql.Append("@Site_Id,@Site_Dir,@Site_annlys,@Site_Pop,@Site_Service,@Site_Name,@Site_Seo,@Site_Static,@Site_Logo,@Site_Water,@Water_Top,@Water_Left,@Water_Pic");
            strSql.Append(") ");

            SqlParameter[] parameters = {
			            new SqlParameter("@Site_Id", SqlDbType.Int,4) ,            
                        new SqlParameter("@Site_Dir", SqlDbType.VarChar,255) ,            
                        new SqlParameter("@Site_annlys", SqlDbType.VarChar,255) ,            
                        new SqlParameter("@Site_Pop", SqlDbType.Int,4) ,            
                        new SqlParameter("@Site_Service", SqlDbType.Int,4) ,            
                        new SqlParameter("@Site_Name", SqlDbType.VarChar,255) ,            
                        new SqlParameter("@Site_Seo", SqlDbType.Int,4) ,            
                        new SqlParameter("@Site_Static", SqlDbType.Int,4) ,            
                        new SqlParameter("@Site_Logo", SqlDbType.VarChar,255) ,            
                        new SqlParameter("@Site_Water", SqlDbType.Int,4) ,            
                        new SqlParameter("@Water_Top", SqlDbType.Int,4) ,            
                        new SqlParameter("@Water_Left", SqlDbType.Int,4) ,            
                        new SqlParameter("@Water_Pic", SqlDbType.VarChar,255)             
              
            };

            parameters[0].Value = model.Site_Id;
            parameters[1].Value = model.Site_Dir;
            parameters[2].Value = model.Site_annlys;
            parameters[3].Value = model.Site_Pop;