QiFeng.ZWY.Dal/BaseDal.cs

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

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

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

namespace QiFeng.LMSD.Dal
{
    public class BaseDal<TO> where TO : BaseDal<TO>, new()
    {
        private static readonly TO _instance = new TO();

        /// <summary>
        /// 返回当前业务逻辑实例
        /// </summary>
        /// <returns>实例</returns>
        public static TO Instance
        {
            get
            {
                return _instance;
            }
        }

        public SqlParameter[] GetListParam(string tableName, string columnName, string orderColumn, string groupColumn, int pageSize, int pageIndex, string strCondition)
        {
            SqlParameter[] param =
            {
                new SqlParameter("@Table",tableName),
                new SqlParameter("@Column",columnName),
                new SqlParameter("@OrderColumn",orderColumn),
                new SqlParameter("@GroupColumn",groupColumn),
                new SqlParameter("@PageSize",pageSize),
                new SqlParameter("@CurrentPage",pageIndex),
                new SqlParameter("@Group",0),
                new SqlParameter("@Condition",strCondition),
                new SqlParameter("@TotalCount",0),
                new SqlParameter("@TotalPage",0)
            };
            return param;
        }

        protected List<T> GetQueryListPage<T>(string sql, SqlParameter[] parameters)
        {
            return GetQueryListPage<T>(sql, parameters, null);
        }

        protected List<T> GetQueryListPage<T>(string sql, SqlParameter[] parameters, SqlOptionContent sqlOptContent)
        {
            if (!string.IsNullOrWhiteSpace(sqlOptContent.OptionCondition))
                sql = sql.Replace(SqlOptionContent.OptionConditionTag,
                    string.IsNullOrWhiteSpace(sqlOptContent.OptionCondition) ? string.Empty : sqlOptContent.OptionCondition);

            if (!string.IsNullOrWhiteSpace(sqlOptContent.OptionGroupBy))
                sql = sql.Replace(SqlOptionContent.OptionGroupByTag,
                    string.IsNullOrWhiteSpace(sqlOptContent.OptionGroupBy) ? string.Empty : sqlOptContent.OptionGroupBy);

            if (!string.IsNullOrWhiteSpace(sqlOptContent.OptionJoin))