public IEnumerable <DataTransferObject.Policy.ExternalPolicyLog> QueryExternalPolicys(decimal?orderId, System.DateTime stratDate, System.DateTime endDate, ChinaPay.Core.Pagination pagination)
{
List <DataTransferObject.Policy.ExternalPolicyLog> result = new List <DataTransferObject.Policy.ExternalPolicyLog>();
string fields = "[OrderId],[Id],[Platform],[Provider],[TicketType],[RequireChangePNR],[Condition],[ETDZSpeed],[WorkStart],[WorkEnd],[ScrapStart],[ScrapEnd],[OriginalRebate],[Rebate],[ParValue],[OfficeNo],[RequireAuth] ,[RecordDate],[OriginalPolicyContent]";
string catelog = "[dbo].[T_ExternalPolicyCopy]";
string orderbyFiled = "[RecordDate] DESC";
System.Text.StringBuilder where = new System.Text.StringBuilder();
using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString))
{
where.AppendFormat("[RecordDate] BETWEEN N'{0}' AND N'{1}'", stratDate, endDate.AddDays(1).AddTicks(-1));
if (orderId.HasValue)
{
where.AppendFormat(" AND [OrderId] = {0}", orderId);
}
dbOperator.AddParameter("@iField", fields);
dbOperator.AddParameter("@iCatelog", catelog);
dbOperator.AddParameter("@iCondition", where.ToString());
dbOperator.AddParameter("@iOrderBy", orderbyFiled);
dbOperator.AddParameter("@iPagesize", pagination.PageSize);
dbOperator.AddParameter("@iPageIndex", pagination.PageIndex);
dbOperator.AddParameter("@iGetCount", pagination.GetRowCount);
var totalCount = dbOperator.AddParameter("@oTotalCount");
totalCount.DbType = System.Data.DbType.Int32;
totalCount.Direction = System.Data.ParameterDirection.Output;
using (var reader = dbOperator.ExecuteReader("dbo.P_Pagination", System.Data.CommandType.StoredProcedure))
{
while (reader.Read())
{
var log = new DataTransferObject.Policy.ExternalPolicyLog();
log.OrderId = reader.GetDecimal(0);
log.Id = reader.GetString(1);
log.Platform = (PlatformType)reader.GetByte(2);
log.Provider = reader.GetGuid(3);
log.TicketType = (TicketType)reader.GetByte(4);
log.RequireChangePNR = reader.GetBoolean(5);
log.Condition = reader.GetString(6);
log.ETDZSpeed = reader.GetInt32(7);
log.WorkStart = Izual.Time.Parse(reader.GetValue(8).ToString());
log.WorkEnd = Izual.Time.Parse(reader.GetValue(9).ToString());
log.ScrapStart = Izual.Time.Parse(reader.GetValue(10).ToString());
log.ScrapEnd = Izual.Time.Parse(reader.GetValue(11).ToString());
log.OriginalRebate = reader.GetDecimal(12);
log.Rebate = reader.GetDecimal(13);
log.ParValue = reader.GetDecimal(14);
log.OfficeNo = reader.IsDBNull(15) ? string.Empty : reader.GetString(15);
log.RequireAuth = reader.GetBoolean(16);
log.RecordDate = reader.GetDateTime(17);
log.OriginalContent = reader.IsDBNull(18)?string.Empty:reader.GetString(18);
result.Add(log);
}
}
if (pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
}
return(result);
}
/// <summary>
/// 查询外平台政策
/// </summary>
public static IEnumerable <ExternalPolicyLog> QueryExternalPolicyLogs(decimal?orderId, DateTime stratDate, DateTime endDate, ChinaPay.Core.Pagination pagination)
{
return(Repository.Factory.CreateSettingReposity().QueryExternalPolicys(orderId, stratDate, endDate, pagination));
}
