public ActionResult GetMdmDutyPageList(MdmDutyMstrQuery query)
{
try
{
var result = _mdmDutyMstrRepository.GetMdmDutyPageList(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> GetMdmDutyPageList(MdmDutyMstrQuery query)
{
return(_sqlQuery.Select(@"
DUTY_ID,
DUTY_NO,
DUTY_NAME,
(
CASE DUTY_STATUS
WHEN 1 THEN
'启用'
ELSE
'禁用'
END
) AS DUTY_STATUS" )
.Filter("DUTY_NAME", query.DUTY_NAME, Operator.Contains)
.Filter("DUTY_NO", query.DUTY_NO, Operator.Contains)
.Filter("BG_NO", AbpSession.BG_NO)
.Filter("DEL_FLAG", "1")
.OrderBy("CREATE_DATE desc")
.GetPageList <dynamic>(@"MDM_DUTY_MSTR", Context.Database.GetDbConnection(), query));
}
