public IEnumerable <BargainDefaultPolicyInfo> QueryBargainDefaultList(BargainDefaultPolicyQueryParameter parameter, Pagination pagination) { if (parameter == null) { throw new ArgumentException("parameter"); } if (pagination == null) { throw new ArgumentException("pagination"); } var result = new List <BargainDefaultPolicyInfo>(); ClearParameters(); AddParameter("@iAirline", parameter.Airline); AddParameter("@iProvinceCode", parameter.ProvinceCode); if (parameter.AdultProviderId.HasValue) { AddParameter("@iAdultProviderId", parameter.AdultProviderId); } else { AddParameter("@iAdultProviderId", DBNull.Value); } AddParameter("@iPageIndex", pagination.PageIndex); AddParameter("@iPageSize", pagination.PageSize); AddParameter("@iGetCount", pagination.GetRowCount); var totalCount = AddParameter("@oTotalCount"); totalCount.DbType = System.Data.DbType.Int32; totalCount.Direction = System.Data.ParameterDirection.Output; using (var reader = ExecuteReader("P_QueryBarginDefaultPolicy", System.Data.CommandType.StoredProcedure)) { while (reader.Read()) { var item = new BargainDefaultPolicyInfo { AdultCommission = reader.GetDecimal(0), Airline = reader.GetString(1), AdultProviderId = reader.GetGuid(2), ProvinceCode = reader.GetString(3), AdultProviderAbbreviateName = reader.GetString(4), AdultProviderName = reader.GetString(5) }; result.Add(item); } } if (pagination.GetRowCount) { pagination.RowCount = (int)totalCount.Value; } return(result); }
private BargainDefaultPolicyQueryParameter getCondition() { BargainDefaultPolicyQueryParameter parameter = new BargainDefaultPolicyQueryParameter(); if (!string.IsNullOrWhiteSpace(ddlAirlines.SelectedValue)) { parameter.Airline = ddlAirlines.SelectedValue; } if (!string.IsNullOrWhiteSpace(ddlProvince.SelectedValue)) { parameter.ProvinceCode = ddlProvince.SelectedValue; } if (AdultAgentCompany.CompanyId.HasValue) { parameter.AdultProviderId = AdultAgentCompany.CompanyId; } return(parameter); }