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