public DbQueryResult GetReconciliationExpressFeeDetails(ReconciliationExpressFeeQuery query) { DbQueryResult result; if (null == query || string.IsNullOrWhiteSpace(query.BeginTime) || string.IsNullOrWhiteSpace(query.EndTime)) { result = new DbQueryResult(); } else { DbQueryResult dbQueryResult = new DbQueryResult(); StringBuilder stringBuilder = new StringBuilder(); // string text = this.BuildReconciliationQuery(query); //if (string.IsNullOrEmpty(text)) //{ // return result = new DbQueryResult(); //} //if (query.PageIndex == 1) //{ // stringBuilder.AppendFormat(" SELECT TOP {0} * FROM VW_GetTradeDetails B where 0=0 {1} ORDER BY TradingTime DESC", query.PageSize, text); //} //else //{ // stringBuilder.AppendFormat("select TOP {0} * from (select *, Row_Number() OVER (ORDER BY TradingTime desc) 'Number' from VW_GetTradeDetails where 0=0 {1} ) B where Number <={2} and Number>{3} ", query.PageSize, text, query.PageIndex * query.PageSize, (query.PageIndex - 1) * query.PageSize); //} //if (query.IsCount) //{ // stringBuilder.AppendFormat(";select count(1) as Total from VW_GetTradeDetails where 0=0 {0} ", text); //} DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_GetExpressFee"); //@pageIndex //@pageSize //@DetailsType //@PayDate //@beginTime //@endTime this.database.AddInParameter(storedProcCommand, "pageIndex", DbType.Int32, query.PageIndex); this.database.AddInParameter(storedProcCommand, "pageSize", DbType.Int32, query.PageSize); this.database.AddInParameter(storedProcCommand, "DetailsType", DbType.String, string.IsNullOrEmpty(query.DetailsType) ? "" : query.DetailsType); this.database.AddInParameter(storedProcCommand, "PayDate", DbType.String, string.IsNullOrEmpty(query.PayDate) ? "" : query.PayDate); this.database.AddInParameter(storedProcCommand, "beginTime", DbType.String, string.IsNullOrEmpty(query.BeginTime) ? "" : query.BeginTime); this.database.AddInParameter(storedProcCommand, "endTime", DbType.String, string.IsNullOrEmpty(query.EndTime) ? "" : query.EndTime); this.database.AddInParameter(storedProcCommand, "supplierId", DbType.Int32, query.Supplier); storedProcCommand.CommandTimeout = 300; using (IDataReader dataReader = this.database.ExecuteReader(storedProcCommand)) { dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader); if (query.IsCount && dataReader.NextResult()) { dataReader.Read(); dbQueryResult.TotalRecords = dataReader.GetInt32(0); } } result = dbQueryResult; } return(result); }
/// <summary> /// 获取快递费用报表 /// </summary> /// <returns></returns> public static DbQueryResult GetReconciliationExpressFeeDetails(ReconciliationExpressFeeQuery query) { return(new ReconciliationOrdersDao().GetReconciliationExpressFeeDetails(query)); }