private RoyaltyFailedRecordQueryCondition getCondition()
{
var condition = new RoyaltyFailedRecordQueryCondition
{
ETDZDateRange =
new Range <DateTime>(DateTime.Parse(txtStartDate.Text), DateTime.Parse(txtEndDate.Text.Trim()))
};
if (!string.IsNullOrEmpty(txtOrderId.Text.Trim()))
{
condition.OrderId = decimal.Parse(txtOrderId.Text.Trim());
}
return(condition);
}
public IEnumerable <RoyaltyFailedRecord> Query(RoyaltyFailedRecordQueryCondition condition, Pagination pagination)
{
var result = new List <RoyaltyFailedRecord>();
var fields = "OrderId,PayTime,ETDZTime,TradeAmount,RoyaltyInfo,ErrorMsg";
var catelog = "dbo.T_RoyaltyFailedInfo";
var orderbyFiled = "ETDZTime";
var where = new StringBuilder();
if (condition.OrderId.HasValue)
{
where.AppendFormat("OrderId={0} AND ", condition.OrderId.Value);
}
where.AppendFormat("ETDZTime BETWEEN '{0}' AND '{1}'", condition.ETDZDateRange.Lower.Date, condition.ETDZDateRange.Upper.Date.AddDays(1).AddTicks(-1));
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
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())
{
result.Add(new RoyaltyFailedRecord()
{
OrderId = reader.GetDecimal(0),
PayTime = reader.GetDateTime(1),
ETDZTime = reader.GetDateTime(2),
TradeAmount = reader.GetDecimal(3),
RoyaltyInfo = reader.GetString(4),
FailedReason = reader.GetString(5)
});
}
}
if (pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
}
return(result);
}
/// <summary>
/// 查询分润失败记录
/// </summary>
/// <param name="condition">查询条件</param>
/// <param name="pagination">分页信息</param>
public static IEnumerable <RoyaltyFailedRecord> QueryRoyaltyFailedRecords(RoyaltyFailedRecordQueryCondition condition, Pagination pagination)
{
var repository = Factory.CreateRoyaltyRepository();
return(repository.Query(condition, pagination));
}
