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