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