/// <summary>
/// 异步获取可用菜单模块列表
/// </summary>
/// <returns>PageDataModel<MenuEntity></returns>
public async Task <BasePagedListModel <MenuEntity> > GetCanUseListAsync()
{
BasePagedListModel <MenuEntity> list = new BasePagedListModel <MenuEntity>();
try
{
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = "M_DISABLED=0";
criteria.PageIndex = 1;
criteria.Fields = "*";
criteria.PageSize = 10000;
criteria.TableName = "S_MENU";
criteria.PrimaryKey = "M_ID";
criteria.Sort = "M_ORDERPATH ASC";
list = await pageListRepository.GetPageDataAsync <MenuEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法GetAllListAsync(int menuId)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法GetAllListAsync(int menuId)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法GetAllListAsync(int menuId)发生Exception，异常信息：{0}", ex);
}
return(list);
}
/// <summary>
/// 获取菜单按钮列表
/// </summary>
/// <param name="pageIndex">页索引</param>
/// <param name="pageSize">页大小</param>
/// <param name="menuId">菜单模块编号</param>
/// <returns>PageDataModel<MenuPurviewCodeEntity></returns>
public async Task <BasePagedListModel <MenuPurviewCodeEntity> > GetCanUseListAsync(int pageIndex, int pageSize)
{
BasePagedListModel <MenuPurviewCodeEntity> list = new BasePagedListModel <MenuPurviewCodeEntity>();
try
{
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = "MPC_DISABLED=0";
criteria.PageIndex = pageIndex;
criteria.Fields = "*";
criteria.PageSize = pageSize;
criteria.TableName = "S_MENU_PURVIEWCODE";
criteria.PrimaryKey = "MPC_ID";
criteria.Sort = "";
list = await pageListRepository.GetPageDataAsync <MenuPurviewCodeEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法GetCanUseListAsync(int pageIndex, int pageSize)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法GetCanUseListAsync(int pageIndex, int pageSize)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法GetCanUseListAsync(int pageIndex, int pageSize)发生Exception，异常信息：{0}", ex);
}
return(list);
}
public async Task <BasePagedListModel <Content2StatusNameEntity> > GetListAsync(ContentSearchParam param)
{
BasePagedListModel <Content2StatusNameEntity> list = new BasePagedListModel <Content2StatusNameEntity>();
try
{
#region 条件与排序
StringBuilder condition = new StringBuilder("1=1");
condition.AppendFormat(" AND CAT_ID={0}", param.CId);
if (param.Steps > -1)
{
condition.AppendFormat(" AND C_STATUS={0}", param.Steps);
}
if (param.Title.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND C_TITLE like '%{0}%'", param.Title.FilterSql());
}
if (param.SubTitle.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND C_SUBTITLE like '%{0}%'", param.SubTitle.FilterSql());
}
if (param.Summary.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND C_SUMMARY like '%{0}%'", param.Summary.FilterSql());
}
#endregion
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = condition.ToString();
criteria.PageIndex = param.PageIndex;
criteria.Fields = "*";
criteria.PageSize = param.PageSize;
criteria.TableName = "vw_C_CONTENT";
criteria.PrimaryKey = "C_ID";
if (param.SortName.IsNotNullOrEmpty() && param.SortOrder.IsNotNullOrEmpty())
{
criteria.Sort = $"{param.SortName.FilterSql()} {param.SortOrder.FilterSql()}";
}
list = await pageListRepository.GetPageDataAsync <Content2StatusNameEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法GetListAsync(ContentSearchParam param)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法GetListAsync(ContentSearchParam param)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法GetListAsync(ContentSearchParam param)发生Exception，异常信息：{0}", ex);
}
return(list);
}
/// <summary>
/// 获取用户列表
/// </summary>
/// <param name="param">用户搜索实体</param>
/// <returns>PageDataModel<UserEntity></returns>
public async Task <BasePagedListModel <UserEntity> > GetListAsync(UserSearchParam param)
{
BasePagedListModel <UserEntity> list = new BasePagedListModel <UserEntity>();
try
{
#region 条件与排序
StringBuilder condition = new StringBuilder("1=1");
if (param.Name.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND U_NAME='{0}'", param.Name.FilterSql());
}
if (param.RealName.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND U_REALNAME='{0}'", param.RealName.FilterSql());
}
if (param.Mobile.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND U_MOBILE='{0}'", param.Mobile.FilterSql());
}
#endregion
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = condition.ToString();
criteria.PageIndex = param.PageIndex;
criteria.Fields = "*";
criteria.PageSize = param.PageSize;
criteria.TableName = "S_USER";
criteria.PrimaryKey = "U_ID";
if (param.SortName.IsNotNullOrEmpty() && param.SortOrder.IsNotNullOrEmpty())
{
criteria.Sort = $"{param.SortName.FilterSql()} {param.SortOrder.FilterSql()}";
}
list = await pageListRepository.GetPageDataAsync <UserEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法GetListAsync(UserSearchParam param)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法GetListAsync(UserSearchParam param)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法GetListAsync(UserSearchParam param)发生Exception，异常信息：{0}", ex);
}
return(list);
}
/// <summary>
/// 获取广告列表
/// </summary>
/// <param name="param">搜索实体</param>
/// <returns>PageDataModel<AdvertEntity></returns>
public async Task <BasePagedListModel <AdvertEntity> > GetListAsync(AdvertSearchParam param)
{
BasePagedListModel <AdvertEntity> list = new BasePagedListModel <AdvertEntity>();
try
{
#region 条件与排序
StringBuilder condition = new StringBuilder("1=1");
if (param.TypeId > 0)
{
condition.AppendFormat(" AND A_TYPEID={0}", param.TypeId);
}
if (param.Name.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND A_TITLE like '%{0}%'", param.Name.FilterSql());
}
#endregion
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = condition.ToString();
criteria.PageIndex = param.PageIndex;
criteria.Fields = "*";
criteria.PageSize = param.PageSize;
criteria.TableName = "C_ADVERT";
criteria.PrimaryKey = "A_ID";
if (param.SortName.IsNotNullOrEmpty() && param.SortOrder.IsNotNullOrEmpty())
{
criteria.Sort = $"{param.SortName.FilterSql()} {param.SortOrder.FilterSql()}";
}
list = await pageListRepository.GetPageDataAsync <AdvertEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法UpdateStateByIdAsync(int id, byte state)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法UpdateStateByIdAsync(int id, byte state)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法UpdateStateByIdAsync(int id, byte state)发生Exception，异常信息：{0}", ex);
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="param">搜索实体</param>
public async Task <BasePagedListModel <ListDJLBEntity> > GetListAsync(DJLBSearchParam param)
{
BasePagedListModel <ListDJLBEntity> list = new BasePagedListModel <ListDJLBEntity>();
try
{
#region 条件与排序
StringBuilder condition = new StringBuilder("1=1");
if (param.DJQZ.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND DJQZ like '%{0}%'", param.DJQZ.FilterSql());
}
if (param.Name.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND Name like '%{0}%'", param.Name.FilterSql());
}
#endregion
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = condition.ToString();
criteria.PageIndex = param.PageIndex;
criteria.Fields = "a.*,b.Name AS DJDLName";
criteria.PageSize = param.PageSize;
criteria.TableName = "P_DJLB a JOIN P_DJDL b ON a.DJDLId=b.Id";
criteria.PrimaryKey = "Id";
if (param.SortName.IsNotNullOrEmpty() && param.SortOrder.IsNotNullOrEmpty())
{
criteria.Sort = $"{param.SortName.FilterSql()} {param.SortOrder.FilterSql()}";
}
list = await pageListRepository.GetPageDataAsync <ListDJLBEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法GetListAsync(DJLBSearchParam param)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法GetListAsync(DJLBSearchParam param)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法GetListAsync(DJLBSearchParam param)发生Exception，异常信息：{0}", ex);
}
return(list);
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <typeparam name="TFirst"></typeparam>
/// <typeparam name="TSecond"></typeparam>
/// <typeparam name="TReturn">dto</typeparam>
/// <param name="map">委托函数</param>
/// <param name="criteriaModel">查询数据Model</param>
/// <param name="splitOn">表示查询的SQL语句中根据哪个字段进行分割</param>
/// <returns></returns>
public async Task <BasePagedListModel <TReturn> > GetPageDataAsync <TFirst, TSecond, TReturn>(IConnectionProvider connectionProvider, Func <TFirst, TSecond, TReturn> map, PageCriteriaModel criteriaModel, string splitOn = "Id")
{
using (var conn = connectionProvider.CreateConn())
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("TableName", criteriaModel.TableName);
parameters.Add("PrimaryKey", criteriaModel.PrimaryKey);
parameters.Add("Fields", criteriaModel.Fields);
parameters.Add("Condition", criteriaModel.Condition);
parameters.Add("PageIndex", criteriaModel.PageIndex);
parameters.Add("PageSize", criteriaModel.PageSize);
parameters.Add("Sort", criteriaModel.Sort);
parameters.Add("RecordCount", dbType: DbType.Int32, direction: ParameterDirection.Output);
BasePagedListModel <TReturn> listModel = new BasePagedListModel <TReturn>()
{
Data = await conn.QueryAsync("sp_get_PageData", map, parameters, null, true, splitOn, null, commandType : CommandType.StoredProcedure),
Total = parameters.Get <int>("RecordCount")
};
return(listModel);
}
}
/// <summary>
/// 获取日志列表
/// </summary>
/// <param name="entity">日志搜索实体</param>
/// <returns>PageDataModel<LogEntity></returns>
public async Task <BasePagedListModel <LogEntity> > GetListAsync(LogSearchParam param)
{
BasePagedListModel <LogEntity> list = new BasePagedListModel <LogEntity>();
try
{
#region 条件与排序
StringBuilder condition = new StringBuilder("1=1");
if (param.Keyword.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND L_DATA like '%{0}%'", param.Keyword.FilterSql());
}
// 过滤搜索范围
if (param.Range != "all")
{
DateTime today = DateTime.Now;
switch (param.Range)
{
case "today":
condition.AppendFormat(" AND L_TIME>='{0}'", today.ToString("yyyy-MM-dd"));
break;
case "last3days":
condition.AppendFormat(" AND L_TIME>='{0}'", today.AddDays(-3).ToString("yyyy-MM-dd"));
break;
case "last7days":
condition.AppendFormat(" AND L_TIME>='{0}'", today.AddDays(-7).ToString("yyyy-MM-dd"));
break;
case "lastmonth":
condition.AppendFormat(" AND L_TIME>='{0}'", today.AddMonths(-1).ToString("yyyy-MM-dd"));
break;
case "lastyear":
condition.AppendFormat(" AND L_TIME>='{0}'", today.AddYears(-1).ToString("yyyy-MM-dd"));
break;
}
}
#endregion
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = condition.ToString();
criteria.PageIndex = param.PageIndex;
criteria.Fields = "*";
criteria.PageSize = param.PageSize;
criteria.TableName = "S_LOG";
criteria.PrimaryKey = "L_ID";
if (param.SortName.IsNotNullOrEmpty() && param.SortOrder.IsNotNullOrEmpty())
{
criteria.Sort = $"{param.SortName.FilterSql()} {param.SortOrder.FilterSql()}";
}
list = await pageListRepository.GetPageDataAsync <LogEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法GetListAsync(LogSearchParam param)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法GetListAsync(LogSearchParam param)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法GetListAsync(LogSearchParam param)发生Exception，异常信息：{0}", ex);
}
return(list);
}