/// <summary>
/// 获取标签列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List <dynamic> GetTagMstrList(TagMstrQuery query)
{
return(_sqlQuery.Select(@"
TAG_MSTR_CODE,
TAG_NAME")
.Filter("CREATE_ORG_NO", query.CREATE_ORG_NO)
.Filter("DEL_FLAG", 1)
.OrderBy("UPDATE_DATE desc")
.GetList <dynamic>(@"TAG_MSTR", Context.Database.GetDbConnection()));
}
public ActionResult GetTagMstrList(TagMstrQuery query)
{
try
{
var result = _tagMstrRepository.GetTagMstrList(query);
return(Success("获取成功", result));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
public ActionResult GetTagMstrPageList(TagMstrQuery query)
{
try
{
var result = _tagMstrRepository.GetTagMstrPageList(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> GetTagMstrPageList(TagMstrQuery query)
{
return(_sqlQuery.Select(@"
TAG_MSTR_CODE,
TAG_NAME,
TAG_MSTR_DESC,
CREATE_DATE,
CASE TAG_STATUS
WHEN 1 THEN
'是'
ELSE
'否'
END TAG_STATUS")
.Filter("TAG_NAME", query.TAG_NAME, Operator.Contains)
.Filter("CREATE_ORG_NO", AbpSession.ORG_NO)
.Filter("DEL_FLAG", 1)
.OrderBy("UPDATE_DATE desc")
.GetPageList <dynamic>(@"TAG_MSTR", Context.Database.GetDbConnection(), query));
}