/// <summary>
/// 查询清Q通知结果
/// </summary>
/// <param name="conditoin"></param>
/// <returns></returns>
public static DataTable QueryInformRecords(InfomrRecordSearchConditoin conditoin)
{
using (var command = Factory.CreateCommand())
{
var transferInfomationRepository = Factory.CreateTransfeRepository(command);
return(transferInfomationRepository.QueryInformRecords(conditoin));
}
}
/// <summary>
/// 查询清Q通知结果
/// </summary>
/// <param name="conditoin"></param>
/// <param name="pagination"></param>
/// <returns></returns>
public static IEnumerable <InformRecord> QueryInformRecords(InfomrRecordSearchConditoin conditoin, Pagination pagination)
{
using (var command = Factory.CreateCommand())
{
var transferInfomationRepository = Factory.CreateTransfeRepository(command);
return(transferInfomationRepository.QueryInformRecords(conditoin, pagination));
}
}
public DataTable QueryInformRecords(InfomrRecordSearchConditoin conditoin)
{
DataTable dt = null;
using (var op = new DbOperator("System.Data.SqlClient", ConnectionManager.B3BConnectionString))
{
ClearParameters();
if (!string.IsNullOrWhiteSpace(conditoin.Carrier))
{
AddParameter("@Carrier", conditoin.Carrier);
}
else
{
AddParameter("@Carrier", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(conditoin.FlightNo))
{
AddParameter("@FlightNo", conditoin.FlightNo);
}
else
{
AddParameter("@FlightNo", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(conditoin.Departure))
{
AddParameter("@Departure", conditoin.Departure);
}
else
{
AddParameter("@Departure", DBNull.Value);
}
if (conditoin.TransferType.HasValue)
{
AddParameter("@TransferType", (byte)conditoin.TransferType.Value);
}
else
{
AddParameter("@TransferType", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(conditoin.Arrival))
{
AddParameter("@Arrival", conditoin.Arrival);
}
else
{
AddParameter("@Arrival", DBNull.Value);
}
if (conditoin.PurchaserId.HasValue)
{
AddParameter("@PurchaserId", conditoin.PurchaserId.Value);
}
else
{
AddParameter("@PurchaserId", DBNull.Value);
}
if (conditoin.InformType.HasValue)
{
AddParameter("@InformMethod", (byte)conditoin.InformType.Value);
}
else
{
AddParameter("@InformMethod", DBNull.Value);
}
if (conditoin.InformResult.HasValue)
{
AddParameter("@InformResult", (byte)conditoin.InformResult.Value);
}
else
{
AddParameter("@InformResult", DBNull.Value);
}
if (conditoin.InformTimeFrom.HasValue)
{
AddParameter("@InformTimeFrom", conditoin.InformTimeFrom.Value);
}
else
{
AddParameter("@InformTimeFrom", DBNull.Value);
}
if (conditoin.InformTimeTo.HasValue)
{
AddParameter("@InformTimeTo", conditoin.InformTimeTo.Value);
}
else
{
AddParameter("@InformTimeTo", DBNull.Value);
}
System.Data.Common.DbParameter oTotalTicketCount = op.AddParameter("@oTotalCount");
oTotalTicketCount.DbType = System.Data.DbType.Int32;
oTotalTicketCount.Direction = System.Data.ParameterDirection.Output;
dt = op.ExecuteTable("dbo.P_QueryFlightInformDetail", System.Data.CommandType.StoredProcedure);
}
return(dt);
}
public IEnumerable <InformRecord> QueryInformRecords(InfomrRecordSearchConditoin conditoin, Pagination pagination)
{
ClearParameters();
List <InformRecord> result = null;
if (!string.IsNullOrWhiteSpace(conditoin.Carrier))
{
AddParameter("@Carrier", conditoin.Carrier);
}
else
{
AddParameter("@Carrier", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(conditoin.FlightNo))
{
AddParameter("@FlightNo", conditoin.FlightNo);
}
else
{
AddParameter("@FlightNo", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(conditoin.Departure))
{
AddParameter("@Departure", conditoin.Departure);
}
else
{
AddParameter("@Departure", DBNull.Value);
}
if (conditoin.TransferType.HasValue)
{
AddParameter("@TransferType", (byte)conditoin.TransferType.Value);
}
else
{
AddParameter("@TransferType", DBNull.Value);
}
if (!string.IsNullOrWhiteSpace(conditoin.Arrival))
{
AddParameter("@Arrival", conditoin.Arrival);
}
else
{
AddParameter("@Arrival", DBNull.Value);
}
if (conditoin.PurchaserId.HasValue)
{
AddParameter("@PurchaserId", conditoin.PurchaserId.Value);
}
else
{
AddParameter("@PurchaserId", DBNull.Value);
}
if (conditoin.InformType.HasValue)
{
AddParameter("@InformMethod", (byte)conditoin.InformType.Value);
}
else
{
AddParameter("@InformMethod", DBNull.Value);
}
if (conditoin.InformResult.HasValue)
{
AddParameter("@InformResult", (byte)conditoin.InformResult.Value);
}
else
{
AddParameter("@InformResult", DBNull.Value);
}
if (conditoin.InformTimeFrom.HasValue)
{
AddParameter("@InformTimeFrom", conditoin.InformTimeFrom.Value);
}
else
{
AddParameter("@InformTimeFrom", DBNull.Value);
}
if (conditoin.InformTimeTo.HasValue)
{
AddParameter("@InformTimeTo", conditoin.InformTimeTo.Value);
}
else
{
AddParameter("@InformTimeTo", DBNull.Value);
}
AddParameter("@iPagesize", pagination.PageSize);
AddParameter("@iPageIndex", pagination.PageIndex);
AddParameter("@iGetCount", pagination.GetRowCount);
var totalCount = AddParameter("@oTotalCount");
totalCount.DbType = System.Data.DbType.Int32;
totalCount.Direction = System.Data.ParameterDirection.Output;
using (var reader = ExecuteReader("dbo.P_QueryFlightInformDetail", System.Data.CommandType.StoredProcedure))
{
result = new List <InformRecord>();
while (reader.Read())
{
var item = new InformRecord();
item.TransferId = reader.GetGuid(0);
item.PurchaserId = reader.GetGuid(1);
item.PurchaserAccount = reader.GetString(2);
item.Carrier = reader.GetString(3);
item.FlightNO = reader.GetString(4);
item.DepartureCityName = reader.GetString(5);
item.DepartureName = reader.GetString(6);
//item.Departure = reader.GetString(5);
//item.Arrival = reader.GetString(7);
item.ArrivalCityName = reader.GetString(7);
item.ArrivalName = reader.GetString(8);
item.TransferType = (TransferType)reader.GetByte(9);
item.InformAccount = reader.IsDBNull(13) ? string.Empty : reader.GetString(13);
item.InfromerName = reader.IsDBNull(14) ? string.Empty : reader.GetString(14);
if (!reader.IsDBNull(11))
{
item.InformType = (InformType)reader.GetByte(11);
}
if (!reader.IsDBNull(12))
{
item.InformResult = (InformResult)reader.GetByte(12);
}
if (!reader.IsDBNull(10))
{
item.InformTime = reader.GetDateTime(10);
}
result.Add(item);
}
}
if (pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
return(result);
}
