public DbQueryResult GetInsuranceOrdeByPager(InsuranceOrderQuery query)
{
string selectFields = "InsuranceOrderId,InsuranceOrderCity1Name,InsuranceOrderIsRenewal,InsuranceOrderCarType,InsuranceOrderCity2Name,InsuranceOrderCompany_Name,InsuranceOrderTel,InsuranceOrderName,InsuranceOrderStatu,InsuranceOrderCreatDate,InsuranceOrderAmount";
string table = "Hishop_InsuranceOrder";
string pk = "InsuranceOrderId";
string filter = " 1=1 ";
if (!string.IsNullOrWhiteSpace(query.UserName))
{
filter = filter + string.Format(" AND InsuranceOrderName LIKE '%{0}%'", query.UserName);
}
if (!string.IsNullOrWhiteSpace(query.OpenId))
{
filter = filter + string.Format(" AND InsuranceOrderOpenId = '{0}'", query.OpenId);
}
if (!string.IsNullOrWhiteSpace(query.Cellphone))
{
filter = filter + string.Format(" AND InsuranceOrderTel LIKE '%{0}%'", query.Cellphone);
}
if (query.CashBackTypes.HasValue)
{
filter = filter + string.Format(" AND InsuranceOrderStatu = {0}", (int)query.CashBackTypes.Value);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, table, pk, filter, selectFields));
}
private void BindCashBackData()
{
InsuranceOrderQuery query = new InsuranceOrderQuery
{
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
Cellphone = this.cellphone,
UserName = this.Username
};
if (!string.IsNullOrWhiteSpace(this.type))
{
query.CashBackTypes = new InsuranceOrderTypes?((InsuranceOrderTypes)int.Parse(this.type));
}
DbQueryResult cashBackByPager = dao.GetInsuranceOrdeByPager(query);
this.grdMemberList.DataSource = cashBackByPager.Data;
this.grdMemberList.DataBind();
this.pager1.TotalRecords = this.pager.TotalRecords = cashBackByPager.TotalRecords;
}
