/// <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());
}
}
