public IEnumerable <SuspendOperation> QuerySuspendOption(SuspendOperationQueryParameter parameter, Pagination pagination)
{
if (parameter == null)
{
throw new ArgumentException("parameter");
}
if (pagination == null)
{
throw new ArgumentException("pagination");
}
var result = new List <SuspendOperation>();
ClearParameters();
if (parameter.Company.HasValue)
{
AddParameter("@iCompany", parameter.Company);
}
else
{
AddParameter("@iCompany", DBNull.Value);
}
AddParameter("@iStartDate", parameter.OperateDate.Lower);
AddParameter("@iEndDate", parameter.OperateDate.Upper);
AddParameter("@iPageIndex", pagination.PageIndex);
AddParameter("@iPageSize", pagination.PageSize);
AddParameter("@iGetCount", pagination.GetRowCount);
var totalCount = AddParameter("@oTotalCount");
totalCount.DbType = System.Data.DbType.Int32;
totalCount.Direction = System.Data.ParameterDirection.Output;
using (var reader = ExecuteReader("P_QuerySuspendOptions", System.Data.CommandType.StoredProcedure))
{
while (reader.Read())
{
var item = new SuspendOperation
{
Id = reader.GetGuid(0),
Owner = reader.GetGuid(1),
Airlines = reader.GetString(2),
Reason = reader.GetString(3),
OperateTime = reader.GetDateTime(4),
OperateType = (PolicySuspendOperationType)reader.GetByte(5),
Operator = reader.GetString(6),
IP = reader.GetString(7),
OperatorRoleType = (PublishRole)reader.GetByte(8),
CompanyId = reader.GetValue(9) == DBNull.Value ? Guid.Empty : reader.GetGuid(9),
CompanyName = reader.GetString(10)
};
result.Add(item);
}
}
if (pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
return(result);
}
private SuspendOperationQueryParameter GetCondition()
{
SuspendOperationQueryParameter parameter = new SuspendOperationQueryParameter
{
OperateDate = new ChinaPay.Core.Range <DateTime> {
Lower = DateTime.Parse(txtStartTime.Text), Upper = DateTime.Parse(txtEndTime.Text).AddDays(1).AddMilliseconds(-1)
},
};
if (Request.QueryString["id"] != null)
{
parameter.Company = Guid.Parse(Request.QueryString["id"]);
}
return(parameter);
}
