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; }