public ActionResult GetSysModulePageList(WctSysmoduleMstrQuery query)
{
try
{
var result = _wctSysmoduleMstrRepository.GetSysModulePageList(query);
return(Page(result.Data, result.Page));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
/// <summary>
/// 获取系统模块分页列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public PagerList <dynamic> GetSysModulePageList(WctSysmoduleMstrQuery query)
{
var sql = "";
if (!string.IsNullOrEmpty(query.SYSM_JSON_VALUE))
{
sql = "to_char(SYSM_JSON_VALUE) like '%" + query.SYSM_JSON_VALUE + "%'";
}
return(_sqlQuery.Select(@"
SYSM_ID,
SYSM_KEY,
SYSM_TITLE,
to_char(SYSM_JSON_VALUE),
UPDATE_DATE")
.Filter("SYSM_KEY", query.SYSM_KEY)
.Filter("SYSM_TITLE", query.SYSM_TITLE)
.Filter("BG_NO", AbpSession.BG_NO)
.Filter("DEL_FLAG", "1")
.And("SYSM_CODE is null")
.And(sql)
.OrderBy("UPDATE_DATE desc")
.GetPageList <dynamic>(@"WCT_SYSMODULE_MSTR", Context.Database.GetDbConnection(), query));
}
