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