public CommonPagedDataViewModel <ResourceModel> GetDataGridDataByCondition(int page, int rows, string name, string code) { CommonPagedDataViewModel <ResourceModel> result = new CommonPagedDataViewModel <ResourceModel>(); try { result = Resourcebll.GetResourceByCondition(page, rows, name, code); } catch (Exception ex) { } return(result); }
/// <summary> /// 分页查询 /// </summary> /// <param name="page"></param> /// <param name="rows"></param> /// <param name="name">业务系统名称</param> /// <param name="code">业务系统编码</param> /// <returns></returns> public ActionResult GetDataGridDataByCondition(int page, int rows, string name, string code) { AjaxViewModel <CommonPagedDataViewModel <ResourceModel> > result = new AjaxViewModel <CommonPagedDataViewModel <ResourceModel> >(); try { CommonPagedDataViewModel <ResourceModel> data = ResourceBll.GetResourceByCondition(page, rows, name, code); result = new AjaxViewModel <CommonPagedDataViewModel <ResourceModel> > { isSuccess = true, obj = data }; } catch (Exception ex) { } return(Json(result, JsonRequestBehavior.AllowGet)); }
public CommonPagedDataViewModel <ResourceModel> GetResourceByCondition(int pageIndex, int pageSize, string name, string code) { CommonPagedDataViewModel <ResourceModel> pageResult = new CommonPagedDataViewModel <ResourceModel>(); try { StringBuilder sql = new StringBuilder(); StringBuilder condition = new StringBuilder(); if (!string.IsNullOrEmpty(name)) { condition.Append(" and ResourceName like '%' + @ResourceName + '%'"); } sql.AppendFormat(@" set @coun=(select count(id) from Resource where 1=1 ); SELECT ID, ResourceName ,ResourceLink ,ResourcePassword, ResourceImg ,IsEnable ,Remark ,CreateTime ,LastUpdateTime,@coun as Coun FROM Resource bs WHERE 1 = 1 {2} LIMIT {0},{1}", (pageIndex - 1) * pageSize, pageSize, condition.ToString()); var result = EBDapperHelper.Query <ResourceModel>(sql.ToString(), new { Resource = name }).ToList(); pageResult.Items = result; pageResult.CurrentPage = pageIndex; if (result != null && result.Count > 0) { pageResult.TotalNum = result[0].Coun; pageResult.TotalPageCount = result[0].Coun; } } catch (Exception ex) { } return(pageResult); }