55128ht_New/YiSha.Business/YiSha.Service/KJH/ZT_ArticleService.cs

using System;
using System.Linq;
using System.Data.Common;
using System.Collections.Generic;
using System.Threading.Tasks;
using YiSha.Util.Extension;
using YiSha.Util.Model;
using YiSha.Data;
using YiSha.Enum;
using System.ComponentModel.DataAnnotations.Schema;
using YiSha.Entity.KJH;
using YiSha.Model.Param.KJH;
using YiSha.IService.KJH;

namespace YiSha.Service.KJH
{
    /// <summary>
    /// 创 建：clg
    /// 日 期：2021-06-29 14:40
    /// 描 述：专题文章服务实现类
    /// </summary>
    public partial class ZT_ArticleService : IZT_ArticleService
    {
        private DBConnectTypeEnum dbConnectType = DBConnectTypeEnum.KjhDB;
        #region 获取数据
        /// <summary>
        /// 获取列表数据
        /// </summary>
        /// <param name="param">请求参数</param>
        /// <returns></returns>
        public async Task<List<ZT_ArticleEntity>> GetList(ZT_ArticleListParam param)
        {
            var expression = ListFilterPartial(param);
            var list = await _baseRepository.BaseRepository(dbConnectType).FindList(expression);
            return list.ToList();
        }

        /// <summary>
        /// 获取分页数据
        /// </summary>
        /// <param name="param">请求参数</param>
        /// <param name="pagination">分页条件</param>
        /// <returns></returns>
        public async Task<List<ZT_ArticleEntity>> GetPageList(ZT_ArticleListParam param, Pagination pagination)
        {
            if (param.Cid != null)
            {
                var entity = await _zT_ColumnService.GetEntity((int)param.Cid, param.CName);
                param.TagId = entity.TagId;
            }
            var expression = ListFilterPartial(param);
            var list = await _baseRepository.BaseRepository(dbConnectType).FindList(expression, pagination);
            return list.ToList();
        }

        /// <summary>
        /// 获取指定列数据
        /// </summary>
        /// <param name="column">表字段列</param>
        /// <param name="where">条件</param>
        /// <param name="parameters">条件参数</param>
        /// <param name="sort">排序列</param>
        /// <param name="sortType">排序类型</param>
        /// <returns></returns>
        public async Task<List<ZT_ArticleEntity>> GetListColumn(string column, string where, List<DbParameter> parameters, string groupBy = "", string sort = "basecreatetime", string sortType = "desc")
        {
            if (string.IsNullOrEmpty(column) || string.IsNullOrEmpty(where))
                return new List<ZT_ArticleEntity>();
            if (!string.IsNullOrEmpty(groupBy))
                groupBy = $" group by {groupBy} ";
            string tableName = typeof(ZT_ArticleEntity).GetAttributeValue((TableAttribute ta) => ta.Name);
            string selectSql = $"select {column} from {tableName} where 1 = 1 and {where} {groupBy} order by {sort} {sortType}";
            var result = await _baseRepository.BaseRepository(dbConnectType).FindList<ZT_ArticleEntity>(selectSql, DbParameterExtension.ToDbParameter(parameters.ToArray()));
            return result.ToList();
        }

        /// <summary>
        /// 根据主键Id获取数据
        /// </summary>
        /// <param name="id">主键id</param>
        /// <returns></returns>
        public async Task<ZT_ArticleEntity> GetEntity(int id)
        {
            return await _baseRepository.BaseRepository(dbConnectType).FindEntity<ZT_ArticleEntity>(id);
        }
        #endregion

        #region 提交数据
        /// <summary>
        /// 保存数据
        /// </summary>
        /// <param name="entity">实体参数</param>
        /// <returns></returns>
        public async Task SaveForm(ZT_ArticleEntity entity)
        {
            if (entity.Id.IsNullOrZero())
            {
                entity.Create();
                await _baseRepository.BaseRepository(dbConnectType).Insert(entity);
            }
            else
            {

                await _baseRepository.BaseRepository(dbConnectType).Update(entity);
            }
        }

        /// <summary>
        /// 保存多条数据
        /// </summary>
        /// <param name="list">数据列表</param>
        /// <returns></returns>
        public async Task<int> InsertMany(List<ZT_ArticleEntity> list)
        {
            return await _baseRepository.BaseRepository(dbConnectType).Insert(list);
        }

        /// <summary>
        /// 根据主键Id删除数据
        /// </summary>
        /// <param name="ids">主键Id</param>
        /// <param name="del">是否真删除 true真删除 false软删除 默认false</param>
        /// <returns></returns>
        public async Task<int> DeleteFormById(string ids, bool del = false)
        {
            if (string.IsNullOrWhiteSpace(ids) || !ids.Split(", ").Any())
            {
                return await Task.FromResult(-1);
            }
            ids = $"{string.Join(",", ids.Split(","))}";
            string tableName = typeof(ZT_ArticleEntity).GetAttributeValue((TableAttribute ta) => ta.Name);
            List<DbParameter> parameters = new List<DbParameter>();
            parameters.Add(DbParameterExtension.CreateDbParameter("@id", ids, dbConnectType));
            string deleteSql = $"delete from {tableName} where FIND_IN_SET (id,@id)";
            return await _baseRepository.BaseRepository(dbConnectType).ExecuteBySql(deleteSql, DbParameterExtension.ToDbParameter(parameters.ToArray()));
        }

        /// <summary>
        /// 根据条件删除数据
        /// </summary>
        /// <param name="where">where条件</param>
        /// <param name="parameters">参数</param>
        /// <param name="del">是否真删除 true真删除 false软删除 默认false</param>
        /// <returns></returns>
        public async Task<int> DeleteFormByWhere(string where, List<DbParameter> parameters, bool del = false)
        {
            if (string.IsNullOrWhiteSpace(where))
            {
                return await Task.FromResult(-1);
            }
            string tableName = typeof(ZT_ArticleEntity).GetAttributeValue((TableAttribute ta) => ta.Name);
            string deleteSql = $"delete from {tableName} where {where}";
            return await _baseRepository.BaseRepository(dbConnectType).ExecuteBySql(deleteSql, DbParameterExtension.ToDbParameter(parameters.ToArray()));
        }

        /// <summary>
        /// 修改多条数据
        /// </summary>
        /// <param name="list">数据列表</param>
        /// <returns></returns>
        public async Task<int> UpdateMany(List<ZT_ArticleEntity> list)
        {
            return await _baseRepository.BaseRepository(dbConnectType).Update(list);
        }

        /// <summary>
        /// 根据条件修改数据
        /// </summary>
        /// <param name="setField">修改字段</param>
        /// <param name="where">where条件</param>
        /// <param name="parameters">参数</param>
        /// <returns></returns>
        public async Task<int> UpdateFormByWhere(string setField, string where, List<DbParameter> parameters)
        {
            if (string.IsNullOrWhiteSpace(setField) || string.IsNullOrWhiteSpace(where))
            {
                return await Task.FromResult(-1);
            }
            string tableName = typeof(ZT_ArticleEntity).GetAttributeValue((TableAttribute ta) => ta.Name);
            string updateSql = $"update {tableName} set {setField} where {where}";
            return await _baseRepository.BaseRepository(dbConnectType).ExecuteBySql(updateSql, DbParameterExtension.ToDbParameter(parameters.ToArray()));
        }
        #endregion

        #region 私有方法
        ///// <summary>
        ///// 列表条件过滤
        ///// 建议该方法放在Partial部分类中，因为代码生成时当前类会被覆盖（该方法在生成时将会被注释）
        ///// </summary>
        ///// <param name="param"></param>
        ///// <returns></returns>
        //private Expression<Func<ZT_ArticleEntity, bool>> ListFilter(ZT_ArticleListParam param)
        //{
        //    var expression = LinqExtensions.True<ZT_ArticleEntity>();
        //    expression = expression.And(t => t.BaseIsDelete == (int)IsDeleteEnum.No);
        //    if (param != null)
        //    {
        //    }
        //    return expression;
        //}
        #endregion
    }
}