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