private string StrWhere(SYSNotifySearch condition)
{
string where = string.Empty;
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
where += string.Format(" and (MsgType like '%{0}%' or MsgCode like '%{0}%')", condition.keyword);
}
return(where);
}
public ActionResult GetPage(SYSNotifySearch condition)
{
string where = StrWhere(condition);
PageJsonModel <SYSNotify> page = new PageJsonModel <SYSNotify>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = " SYSNotify ";
page.strSelect = string.Format(" *,(case when REPLACE(Subscriber,',{0},',',')=',' then '' else REPLACE(Subscriber,',{0},',',') end) as elseSubscriber ", CurrentUser.UserName);
page.strWhere = where;
page.strOrder = "ID desc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
public ActionResult GetPage(SYSNotifySearch condition)
{
string where = StrWhere(condition);
PageJsonModel <SYSNotify> page = new PageJsonModel <SYSNotify>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = " SYSNotify ";
page.strSelect = " * ";
page.strWhere = where;
page.strOrder = "ID desc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
