public async Task <IActionResult> GetTreeGridJson(string keyword)
{
BasePagedListModel <MenuEntity> pageDataModel = await menuService.GetAllListAsync(0);
var data = pageDataModel.Data.ToList();
if (keyword.IsNotNullOrEmpty())
{
data = data.TreeWhere(t => t.M_NAME.Contains(keyword));
}
var treeList = new List <TreeGridModel>();
foreach (MenuEntity item in data)
{
TreeGridModel treeModel = new TreeGridModel();
bool hasChildren = data.Count(t => t.M_PARENTID == item.M_ID) == 0 ? false : true;
treeModel.id = item.M_ID;
treeModel.isLeaf = hasChildren;
treeModel.parentId = item.M_PARENTID;
treeModel.expanded = hasChildren;
treeModel.entityJson = item.ToJson();
treeList.Add(treeModel);
}
return(Content(treeList.TreeGridJson()));
}
/// <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);
}
/// <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>
/// Creates an object that serializes the specified object to JSON
/// Used to serialize data for DataTables
/// </summary>
/// <typeparam name="T">Model type</typeparam>
/// <param name="model">The model to serialize.</param>
/// <returns>The created object that serializes the specified data to JSON format for the response.</returns>
/// <remarks>
/// See also https://datatables.net/manual/server-side#Returned-data
/// </remarks>
public JsonResult Json <T>(BasePagedListModel <T> model) where T : BaseSmiModel
{
return(Json(new
{
draw = model.Draw,
recordsTotal = model.RecordsTotal,
recordsFiltered = model.RecordsFiltered,
Data = model.Data
}));
}
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);
}
public async Task <IActionResult> GetGridJson(ContentSearchParam param)
{
BasePagedListModel <Content2StatusNameEntity> pageDataModel = await contentService.GetListAsync(param);
var data = new
{
total = pageDataModel.Total,
rows = pageDataModel.Data
};
return(Json(data));
}
public async Task <IActionResult> GetPCList(int mid, int pageIndex = 1, int pageSize = 10)
{
BasePagedListModel <MenuPurviewCodeEntity> pageDataModel = await menuPurviewCodeService.GetListByMenuIdAsync(pageIndex, pageSize, mid);
var data = new
{
total = pageDataModel.Total,
rows = pageDataModel.Data
};
return(Json(data));
}
public async Task <IActionResult> GetGridJson(UserSearchParam userSearchEntity)
{
BasePagedListModel <UserEntity> pageDataModel = await userService.GetListAsync(userSearchEntity);
var data = new
{
total = pageDataModel.Total,
rows = pageDataModel.Data
};
return(Json(data));
}
public async Task <IActionResult> GetCanAddUser(RoleUserSearchParam param)
{
BasePagedListModel <UserEntity> pageDataModel = await userService.GetCanUserListByRoleIdAsync(param);
var data = new
{
total = pageDataModel.Total,
rows = pageDataModel.Data
};
return(Json(data));
}
public async Task <IActionResult> GetGridJson(JFFSSearchParam param)
{
BasePagedListModel <JFFSEntity> pageDataModel = await service.GetListAsync(param);
var data = new
{
total = pageDataModel.Total,
rows = pageDataModel.Data
};
return(Json(data));
}
/// <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>
/// Creates an object that serializes the specified object to JSON
/// Used to serialize data for DataTables
/// </summary>
/// <typeparam name="T">Model type</typeparam>
/// <param name="model">The model to serialize.</param>
/// <returns>The created object that serializes the specified data to JSON format for the response.</returns>
public JsonResult Json <T>(BasePagedListModel <T> model) where T : BaseQNetModel
{
return(Json(new
{
draw = model.Draw,
recordsTotal = model.RecordsTotal,
recordsFiltered = model.RecordsFiltered,
data = model.Data,
//TODO: remove after moving to DataTables grids
Total = model.Total,
Data = model.Data
}));
}
public async Task <IActionResult> GetTreeSelectJson(int id)
{
BasePagedListModel <MenuEntity> pageDataModel = await menuService.GetAllListAsync(id);
var treeList = new List <TreeSelectModel>();
foreach (MenuEntity item in pageDataModel.Data)
{
TreeSelectModel treeModel = new TreeSelectModel();
treeModel.id = item.M_ID;
treeModel.text = item.M_NAME;
treeModel.parentId = item.M_PARENTID;
treeList.Add(treeModel);
}
return(Content(treeList.TreeSelectJson()));
}
/// <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>
/// <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>
/// <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);
}
}
public async Task <IActionResult> SetRuleForm(int roleId)
{
ViewBag.RoleId = roleId;
StringBuilder html = new StringBuilder();
BasePagedListModel <MenuEntity> pageDataModel = await menuService.GetCanUseListAsync();
if (pageDataModel.Total > 0)
{
BasePagedListModel <MenuPurviewCodeEntity> menuPCList = await mpcService.GetCanUseListAsync(1, 100000);
//初始化拥有的权限值
string initPermission = "," + await roleService.GetPermissionByRoleIdAsync(roleId);
foreach (MenuEntity item in pageDataModel.Data)
{
string s = String.Empty;
byte level = Convert.ToByte(item.M_LEVEL);
for (byte i = 0; i < level; i++)
{
s += "——";
}
html.Append("<tr>");
html.AppendFormat("<td><label class=\"checkbox-inline i-checks\"><input type=\"checkbox\" name=\"chkMCodes\">{0}{1}</label></td>", s, item.M_NAME);
html.Append("<td>");
html.AppendFormat("<label class=\"checkbox-inline i-checks\"><input value=\"{0}\" type=\"checkbox\" name=\"chkPCodes\"{1}>浏览</label>", item.M_CODE, initPermission.Contains("," + item.M_CODE + ",") ? " checked=\"checked\"" : "");
if (menuPCList.Total > 0)
{
List <MenuPurviewCodeEntity> pcItems = menuPCList.Data.ToList().FindAll(x => x.M_ID == item.M_ID);
foreach (MenuPurviewCodeEntity pcItem in pcItems)
{
html.AppendFormat("<label class=\"checkbox-inline i-checks\"><input value=\"{0}\" type=\"checkbox\" name=\"chkPCodes\"{2}>{1}</label>", pcItem.MPC_CODE, pcItem.MPC_NAME, initPermission.Contains("," + pcItem.MPC_CODE + ",") ? " checked=\"checked\"" : "");
}
}
html.Append("</td>");
html.Append("</tr>");
}
}
ViewBag.PCHtml = html.ToString();
return(View());
}
/// <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);
}
