/// <summary> /// 获取列表 /// </summary> public List<ConstructionSiteModel> GetList(ref PagerModel pager, string address, string cusName, string designer, string proMinister, string checker, string startDateStart, string startDateEnd, string endDateStart, string endDateEnd) { StringBuilder sql = new StringBuilder(string.Format(@" select * from Pro_ConstructionSite where 1=1 ")); if (!string.IsNullOrWhiteSpace(address)) { sql.AppendFormat(" and Address like '%{0}%'", address); } if (!string.IsNullOrWhiteSpace(cusName)) { sql.AppendFormat(" and CusName like '%{0}%'", cusName); } if (!string.IsNullOrWhiteSpace(designer)) { sql.AppendFormat(" and Designer like '%{0}%'", designer); } if (!string.IsNullOrWhiteSpace(proMinister)) { sql.AppendFormat(" and ProMinister like '%{0}%'", proMinister); } if (!string.IsNullOrWhiteSpace(checker)) { sql.AppendFormat(" and Checker like '%{0}%'", checker); } if (!string.IsNullOrWhiteSpace(startDateStart)) { sql.AppendFormat(" and StartDate >= '{0}'", startDateStart); } if (!string.IsNullOrWhiteSpace(startDateEnd)) { sql.AppendFormat(" and StartDate <= '{0}'", startDateEnd); } if (!string.IsNullOrWhiteSpace(endDateStart)) { sql.AppendFormat(" and EndDate >= '{0}'", endDateStart); } if (!string.IsNullOrWhiteSpace(endDateEnd)) { sql.AppendFormat(" and EndDate <= '{0}'", endDateEnd); } string orderby = string.Format("order by {0} {1}", pager.sort, pager.order); PagerModel pagerModel = sqliteHelper.FindPageBySql<ConstructionSiteModel>(sql.ToString(), orderby, pager.rows, pager.page); pager.totalRows = pagerModel.totalRows; pager.result = pagerModel.result; return pagerModel.result as List<ConstructionSiteModel>; }
/// <summary> /// 获取列表 /// </summary> public ActionResult GetList(PagerModel pager, string address, string cusName, string designer, string proMinister, string checker, string startDateStart, string startDateEnd, string endDateStart, string endDateEnd) { constructionSiteDal.GetList(ref pager, address, cusName, designer, proMinister, checker, startDateStart, startDateEnd, endDateStart, endDateEnd); var json = new { total = pager.totalRows, rows = pager.result as List<ConstructionSiteModel> }; return Json(json, JsonRequestBehavior.AllowGet); }
/// <summary> /// 获取列表 /// </summary> public ActionResult GetList(PagerModel pager, string startDate, string endDate, string address, string designer, string adviser, string follower) { followDal.GetList(ref pager, startDate, endDate, address, designer, adviser, follower); var json = new { total = pager.totalRows, rows = pager.result as List<FollowModel> }; return Json(json, JsonRequestBehavior.AllowGet); }
/// <summary> /// 获取列表 /// </summary> public ActionResult GetList(PagerModel pager) { roleDal.GetList(ref pager); var json = new { total = pager.totalRows, rows = pager.result as List<RoleModel> }; return Json(json, JsonRequestBehavior.AllowGet); }
/// <summary> /// 获取集合 /// </summary> public List<RoleModel> GetList(ref PagerModel pager) { StringBuilder sql = new StringBuilder(string.Format(@" select role.* from Sys_Role role where 1=1 ")); string orderby = string.Format("order by {0} {1}", pager.sort, pager.order); PagerModel pagerModel = sqliteHelper.FindPageBySql<RoleModel>(sql.ToString(), orderby, pager.rows, pager.page); pager.totalRows = pagerModel.totalRows; pager.result = pagerModel.result; return pagerModel.result as List<RoleModel>; }
/// <summary> /// 获取列表 /// </summary> public List<FollowModel> GetList(ref PagerModel pager, string startDate, string endDate, string address, string designer, string adviser, string follower) { StringBuilder sql = new StringBuilder(string.Format(@" select * from Pro_Follow where 1=1 ")); if (!string.IsNullOrWhiteSpace(startDate)) { sql.AppendFormat(" and FollowDate >= '{0}'", startDate); } if (!string.IsNullOrWhiteSpace(endDate)) { sql.AppendFormat(" and FollowDate <= '{0}'", endDate); } if (!string.IsNullOrWhiteSpace(address)) { sql.AppendFormat(" and Address like '%{0}%'", address); } if (!string.IsNullOrWhiteSpace(designer)) { sql.AppendFormat(" and Designer like '%{0}%'", designer); } if (!string.IsNullOrWhiteSpace(adviser)) { sql.AppendFormat(" and Adviser like '%{0}%'", adviser); } if (!string.IsNullOrWhiteSpace(follower)) { sql.AppendFormat(" and Follower like '%{0}%'", follower); } string orderby = string.Format("order by {0} {1}", pager.sort, pager.order); PagerModel pagerModel = sqliteHelper.FindPageBySql<FollowModel>(sql.ToString(), orderby, pager.rows, pager.page); pager.totalRows = pagerModel.totalRows; pager.result = pagerModel.result; return pagerModel.result as List<FollowModel>; }
/// <summary> /// 获取列表 /// </summary> public ActionResult GetList(PagerModel pager, string billCode, string startDate, string endDate, string cusName, string proMinister, string address) { constructDal.GetList(ref pager, billCode, startDate, endDate, cusName, proMinister, address); var json = new { total = pager.totalRows, rows = pager.result as List<ConstructModel> }; return Json(json, JsonRequestBehavior.AllowGet); }