private FreezeQueryCondition getCondition()
{
var parmater = new FreezeQueryCondition();
parmater.OrderId = StringUtility.ToNullableDecimal(txtOrderId.Text.Trim());
parmater.ApplyformId = StringUtility.ToNullableDecimal(txtApplyFormId.Text.Trim());
parmater.RequestDate = new Range <DateTime>(DateTime.Parse(txtStartDate.Text.Trim()), DateTime.Parse(txtEndDate.Text.Trim()));
//DateTime.Parse(txtEndDate.Text.Trim()).AddDays(1).AddTicks(-1));
if (!string.IsNullOrWhiteSpace(ddlStatus.SelectedValue))
{
parmater.Success = ddlStatus.SelectedValue == "1";
}
if (!string.IsNullOrWhiteSpace(ddlFreezeType.SelectedValue))
{
parmater.Type = (FreezeType)int.Parse(ddlFreezeType.SelectedValue);
}
return(parmater);
}
public IEnumerable <FreezeBaseInfo> Query(FreezeQueryCondition condition, Pagination pagination)
{
var result = new List <FreezeBaseInfo>();
var fields = "[Type],Id,OrderId,ApplyformId,TradeNo,Account,Amount,FreezeNo,UnfreezeNo,RequestTime,Success,ProcessTime,Remark";
var catelog = "dbo.T_OrderFreeze";
var orderbyFiled = "ApplyformId DESC,RequestTime";
var where = new StringBuilder();
if (condition.OrderId.HasValue)
{
where.AppendFormat("OrderId={0} AND ", condition.OrderId.Value);
}
if (condition.ApplyformId.HasValue)
{
where.AppendFormat("ApplyformId={0} AND ", condition.ApplyformId.Value);
}
if (condition.Type.HasValue)
{
where.AppendFormat("[Type]={0} AND ", (byte)condition.Type.Value);
}
if (condition.Success.HasValue)
{
where.AppendFormat("Success={0} AND ", condition.Success.Value?1:0);
}
where.AppendFormat("RequestTime BETWEEN '{0}' AND '{1}'", condition.RequestDate.Lower.Date, condition.RequestDate.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())
{
FreezeBaseInfo item = null;
var type = (FreezeType)reader.GetByte(0);
if (type == FreezeType.Freeze)
{
item = new FreezeInfo(reader.GetGuid(1))
{
TradeNo = getString(reader["TradeNo"]),
No = getString(reader["FreezeNo"])
};
}
else
{
item = new UnfreezeInfo(reader.GetGuid(1))
{
FreezeNo = getString(reader["FreezeNo"]),
No = getString(reader["UnfreezeNo"])
};
}
item.OrderId = reader.GetDecimal(2);
item.ApplyformId = reader.GetDecimal(3);
item.Account = reader.GetString(5);
item.Amount = reader.GetDecimal(6);
item.RequestTime = reader.GetDateTime(9);
item.Success = reader.GetBoolean(10);
if (!reader.IsDBNull(11))
{
item.ProcessedTime = reader.GetDateTime(11);
}
item.Remark = reader.IsDBNull(12) ? string.Empty : reader.GetString(12);
result.Add(item);
}
}
if (pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
}
return(result);
}
public static IEnumerable <FreezeBaseInfo> Query(FreezeQueryCondition condition, Pagination pagination)
{
var repository = Order.Repository.Factory.CreateFreezeRepository();
return(repository.Query(condition, pagination));
}
