/// <summary> /// 公司分页查询 /// </summary> /// <param name="condition">查询条件</param> /// <returns>结果</returns> public IEnumerable <MCompany> QueryCompanyByPagings(TCompanyCondition condition) { this.ClearParameters(); StringBuilder sqlCondition = new StringBuilder("ParenttCompanyId = @ParenttCompanyId"); this.AddParameter("@ParenttCompanyId", condition.ParenttCompanyId); if (!string.IsNullOrWhiteSpace(condition.AccountNo)) { sqlCondition.Append(" AND AccountNo = @AccountNo "); this.AddParameter("@AccountNo", condition.AccountNo); } if (!string.IsNullOrWhiteSpace(condition.CompanyName)) { sqlCondition.Append(" AND AccountName = @AccountName "); this.AddParameter("@AccountName", condition.CompanyName); } if (condition.GetRowsCount) { string sqlCount = "SELECT COUNT(0) FROM Company WHERE " + sqlCondition + ";"; object obj = this.ExecuteScalar(sqlCount); condition.RowsCount = obj == null ? 0 : Convert.ToInt32(obj); } string sqlData = "SELECT * FROM Company WHERE " + sqlCondition + " ORDER BY CreateTime DESC LIMIT @StratRows, @PageSize;"; this.AddParameter("@StratRows", condition.StratRows); this.AddParameter("@PageSize", condition.PageSize); return(this.BuildEntitiesFromSql(sqlData)); }
/// <summary> /// 公司分页查询 /// </summary> /// <param name="condition">查询条件</param> /// <returns>结果</returns> public static IEnumerable <TCompany> QueryCompanyByPagings(TCompanyCondition condition) { using (var companyRepository = DbContext.CreateICompanyRepository()) { var data = companyRepository.QueryCompanyByPagings(condition).ToTCompanys(); return(data); } }
/// <summary> /// 用户列表 /// </summary> /// <returns>结果</returns> public ActionResult CompanyList(TCompanyCondition condition) { if (condition != null) { condition.ParenttCompanyId = Company.CompanyId; var data = AccountService.QueryCompanyByPagings(condition); PagedList <TCompany> pageList = new PagedList <TCompany>(data, condition.PageIndex, condition.PageSize, condition.RowsCount); ViewModel <TCompanyCondition, PagedList <TCompany> > result = new ViewModel <TCompanyCondition, PagedList <TCompany> > { Condition = condition, Data = pageList }; return(this.View(result)); } else { return(this.View()); } }