public ActionResult GetMaterialTypePageList(CmsMaterialTypeQuery query)
{
try
{
var result = _cmsMaterialTypeRepository.GetMaterialTypePageList(query);
return(Page(result.Data, result.Page));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
public ActionResult GetMaterialTypeList(CmsMaterialTypeQuery query)
{
try
{
var result = _cmsMaterialTypeRepository.GetMaterialTypeList(query);
return(Success("获取成功", result));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
/// <summary>
/// 获取素材类型列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List <dynamic> GetMaterialTypeList(CmsMaterialTypeQuery query)
{
return(_sqlQuery.Select(@"
MATERIAL_TYPE_ID,
MATERIAL_TYPE_NAME,
CREATE_DATE")
.Filter("MATERIAL_ATTR", query.MATERIAL_ATTR)
.Filter("DEL_FLAG", 1)
.Filter("BG_NO", AbpSession.BG_NO)
.OrderBy("CREATE_DATE desc")
.GetList <dynamic>("CMS_MATERIAL_TYPE", Context.Database.GetDbConnection()));
}
