private FlightTransferCondition getCondition()
{
var condition = new FlightTransferCondition();
if (!string.IsNullOrWhiteSpace(this.ddlAirline.SelectedValue))
{
condition.Carrier = this.ddlAirline.SelectedValue;
}
if (!string.IsNullOrWhiteSpace(this.txtFlightNo.Text))
{
condition.OriginalFlightNo = this.txtFlightNo.Text;
}
if (!string.IsNullOrWhiteSpace(this.ddlTranferType.SelectedValue))
{
condition.TransferType = (TransferType)int.Parse(this.ddlTranferType.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(this.txtTakeOffLowerTime.Text))
{
condition.OriginalTakeOffLowerTime = DateTime.Parse(this.txtTakeOffLowerTime.Text);
}
if (!string.IsNullOrWhiteSpace(this.txtTakeOffUpperTime.Text))
{
condition.OriginalTakeOffUpperTime = DateTime.Parse(this.txtTakeOffUpperTime.Text).AddDays(1).AddMilliseconds(-3);
}
return(condition);
}
public IEnumerable <PurchaseTransferInformation> QueryTransferInformationByPurchase(FlightTransferCondition condition, Pagination pagination)
{
ClearParameters();
var result = new List <PurchaseTransferInformation>();
if (!string.IsNullOrWhiteSpace(condition.Carrier))
{
AddParameter("@iCarrier", condition.Carrier);
}
if (!string.IsNullOrWhiteSpace(condition.OriginalFlightNo))
{
AddParameter("@iOriginalFlightNo", condition.OriginalFlightNo);
}
if (condition.TransferType.HasValue)
{
AddParameter("@iTransferType", (byte)condition.TransferType);
}
if (condition.OriginalTakeOffLowerTime.HasValue)
{
AddParameter("@iOriginalTakeOffLowerTime", condition.OriginalTakeOffLowerTime);
}
if (condition.OriginalTakeOffUpperTime.HasValue)
{
AddParameter("@iOriginalTakeOffUpperTime", condition.OriginalTakeOffUpperTime);
}
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_QueryPurchaseFlightTransferInformation", System.Data.CommandType.StoredProcedure))
{
while (reader.Read())
{
var oFlightNO = reader.GetString(0);
string nFlightNO = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
var item = new PurchaseTransferInformation()
{
OriginalCarrier = oFlightNO.Substring(0, 2),
OriginalFlightNo = oFlightNO.Substring(2),
OriginalTakeoffTime = reader.GetDateTime(1),
OriginalArrivalTime = reader.GetDateTime(2),
Carrier = !string.IsNullOrEmpty(nFlightNO) ? nFlightNO.Substring(0, 2) : string.Empty,
FlightNo = !string.IsNullOrEmpty(nFlightNO) ? nFlightNO.Substring(2) : string.Empty,
TransferType = (TransferType)reader.GetByte(8),
};
if (!reader.IsDBNull(4))
{
item.FlightDate = reader.GetDateTime(4);
item.AddDays = reader.GetInt32(7);
if (!reader.IsDBNull(5))
{
item.TakeoffTime = reader.GetDateTime(5);
item.TakeoffTime = item.FlightDate.Value.AddHours(item.TakeoffTime.Value.Hour)
.AddMinutes(item.TakeoffTime.Value.Minute);
}
if (!reader.IsDBNull(6))
{
item.ArrivalTime = reader.GetDateTime(6);
item.ArrivalTime = item.FlightDate.Value.AddDays(item.AddDays).AddHours(item.ArrivalTime.Value.Hour).AddMinutes(item.ArrivalTime.Value.Minute);
}
}
result.Add(item);
}
}
if (pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
return(result);
}
/// <summary>
/// 采购查看航班变动信息
/// </summary>
/// <returns></returns>
public static IEnumerable <PurchaseTransferInformation> QueryTransferInformationByPurchase(FlightTransferCondition condition, Pagination pagination)
{
using (var command = Factory.CreateCommand())
{
var transferInformationRepository = Factory.CreateTransfeRepository(command);
return(transferInformationRepository.QueryTransferInformationByPurchase(condition, pagination));
}
}
