Estsh-Yiri/Estsh.Core.Services/Repositories/BaseManagerRepository.cs

using System.Collections;
using Estsh.Core.Dapper;
using Estsh.Core.Models;
using System.Data;
using System.Text;
using Dapper;
using Estsh.Core.Repository.IRepositories;

/***************************************************************************************************
*
* 更新人：sitong.dong
* 描述：
* 修改时间：2022.06.22
* 修改日志：系统迭代升级
*
**************************************************************************************************/
namespace Estsh.Core.Repositories
{

    public class BaseManagerRepository : BaseRepository<SysBase>, IBaseManagerRepository
    {
        public BaseManagerRepository(DapperDbContext _dapperDbContext) : base(_dapperDbContext)
        {
        }

        /// <summary>
        /// 获取分页数据列表
        /// </summary>
        /// <param name="PageSize">一页显示多少条数据</param>
        /// <param name="PageIndex">当前第几页</param>
        /// <param name="strWhere">条件</param>
        /// <param name="OrderBy">排序字段</param>
        /// <returns></returns>
        public Hashtable getListByPage(int PageSize, int PageIndex, string strWhere, string OrderBy)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                Hashtable result = new Hashtable();
                DynamicParameters parameters = new DynamicParameters();
                parameters.Add( "@TotalCount", 0, DbType.Int32, ParameterDirection.Output);
                parameters.Add( "@TotalPage", 0, DbType.Int32, ParameterDirection.Output);
                parameters.Add( "@Table", "sys_base");
                parameters.Add( "@Column", "*");
                parameters.Add( "@OrderColumn", OrderBy);
                parameters.Add( "@GroupColumn", "");
                parameters.Add( "@PageSize", PageSize);
                parameters.Add( "@CurrentPage", PageIndex);
                parameters.Add( "@Group", 0);
                parameters.Add( "@Condition", strWhere);

                List<SysBase> datalist = dbConn.Query<SysBase>("Com_Pagination", parameters, commandType: CommandType.StoredProcedure).ToList();
                result.Add("dataList", datalist);
                result.Add("totalCount", parameters.Get<int>("@TotalCount"));
                return result;
            }
        }
        /// <summary>
        /// 增加系统参数
        /// </summary>
        /// <param name="parames"></param>
        /// <returns></returns>
        public int SaveBase(SysBase parames)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                StringBuilder SqlStringBuilder = new StringBuilder(1024);
                SqlStringBuilder.Append("INSERT INTO dbo.sys_base ");
                SqlStringBuilder.Append("        ( param_name , ");
                SqlStringBuilder.Append("          param_value , ");
                SqlStringBuilder.Append("          param_desc , ");
                SqlStringBuilder.Append("		   create_userid ");
                SqlStringBuilder.Append("		  , create_time ");
                SqlStringBuilder.Append("         , enabled ");
                SqlStringBuilder.Append("        ) ");
                SqlStringBuilder.Append("VALUES  ( @ParamName ,  ");
                SqlStringBuilder.Append("          @ParamValue , ");
                SqlStringBuilder.Append("          @ParamDesc , ");
                SqlStringBuilder.Append("		   @createUserid ");
                SqlStringBuilder.Append("		  , CONVERT(varchar(50), GETDATE(), 21)");
                SqlStringBuilder.Append("         , @enabled  ");
                SqlStringBuilder.Append("        ) ");

                return dbConn.Execute(SqlStringBuilder.ToString(), parames);
            }

        }
        /// <summary>
        /// 修改参数
        /// </summary>
        /// <param name="parames"></param>
        /// <returns></returns>
        public int EditBase(SysBase parames)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                StringBuilder sql = new StringBuilder(1024);
                sql.Append("UPDATE dbo.sys_base SET param_value=@ParamValue,param_desc=@ParamDesc,enabled=@Enabled ,update_userid = @updateUserId ,update_time=CONVERT(varchar(50), GETDATE(), 21)  WHERE param_id=@ParamId");
                return dbConn.Execute(sql.ToString(), parames);
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="parame_id"></param>
        /// <returns></returns>
        public int deleteBase(string parame_id)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                StringBuilder sql = new StringBuilder(1024);
                sql.Append("update sys_base set Enabled='N'  where param_id = '" + parame_id + "'");
                return dbConn.Execute(sql.ToString());
            }
        }

        //启用
        public int EnableData(String ids)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                String delStr = "update sys_base set Enabled='Y'  WHERE param_id in (" + ids + ")";
                int result = dbConn.Execute(delStr);
                return result;
            }
        }

        //禁用
        public int DisableData(String ids)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                String delStr = "update sys_base set Enabled='N'  WHERE param_id in (" + ids + ")";
                int result = dbConn.Execute(delStr);
                return result;
            }
        }

        /// <summary>
        ///  查询系统参数列表
        /// </summary>
        /// <param name="strWhere"></param>
        /// <returns></returns>
        public List<SysBase> getBaseList(string strWhere)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                string sql = "select * from sys_base where enabled='Y' " + strWhere;
                return dbConn.Query<SysBase>(sql).ToList();
            }
        }

        /// <summary>
        ///  根据id查询系统参数列表
        /// </summary>
        /// <param name="strWhere"></param>
        /// <returns></returns>
        public List<SysBase> getList(string paramId)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                string sql = "select * from sys_base where param_id='" + paramId + "' and enabled='Y' ";
                return dbConn.Query<SysBase>(sql).ToList();
            }
        }
    }
}