CC.Data/DAL/DALBase.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Collections;

using CC.Data.Helper;

namespace CC.Data.DAL
{
    public class DALBase<T> where T : class,new()
    {
        #region 变量声明
        /// <summary>
        /// 搜索全部数据
        /// </summary>
        private const string SQL_SELECT_ALL = "SELECT * FROM {0}";
        /// <summary>
        /// 根据过滤条件搜索全部数据
        /// </summary>
        private const string SQL_SELECT_ALL_CONDITION = "SELECT * FROM {0} Where {1}";
        /// <summary>
        /// 根据主键查找一条数据
        /// </summary>
        private const string SQL_SELECT_PK = "SELECT * FROM {0} WHERE {1}";
        /// <summary>
        /// 根据条件搜索数据
        /// </summary>
        private const string SQL_SELECT_CONDITION = "SELECT TOP 1 * FROM {0} WHERE {1}";
        /// <summary>
        /// 执行插入语句
        /// </summary>
        private const string SQL_INSERT = "INSERT INTO {0} ({1})VALUES({2})";
        /// <summary>
        /// 根据主键删除数据
        /// </summary>
        private const string SQL_DELETE_PK = "DELETE  FROM {0} WHERE {1}";
        /// <summary>
        /// 根据集合删除数据
        /// </summary>
        private const string SQL_DELETE_PRIMARYKEYS = "DELETE FROM {0} Where {1} in ({2})";
        /// <summary>
        /// 根据主键更新一条数据
        /// </summary>
        private const string SQL_UPDATE_PK = "UPDATE {0} SET {1} WHERE {2}";
        /// <summary>
        /// 分页显示数据
        /// </summary>
        private const string SQL_SELECT_PAGE = "SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY {0} {1})  AS RowNum,* From {2}  Where {3})AS CustomersWithRowNum Where RowNum >(({4}-1)*{5}) And RowNum <=({4}*{5})";
        /// <summary>
        /// 获取总数
        /// </summary>
        private const string SQL_SELECT_COUNT = "SELECT COUNT(*) FROM {0} WHERE {1}";


        #endregion

        #region 基本属性