public void Query(int refundSysNo, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { RefundBalanceQueryFilter queryFilter = new RefundBalanceQueryFilter(); queryFilter.RefundSysNo = refundSysNo; queryFilter.PagingInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; string relativeUrl = string.Format("/RMAService/RefundBalance/Query"); restClient.QueryDynamicData(relativeUrl, queryFilter, callback); }
public QueryResult QueryRefundBalanceListByRefundSysNo(RefundBalanceQueryFilter queryFilter) { int _refundSysNo; if (!int.TryParse(queryFilter.RefundSysNo.ToString(), out _refundSysNo)) { throw new ArgumentException("Invalid refundSysNo"); } int totalCount; var dataTable = ObjectFactory <IRefundBalanceQueryDA> .Instance.Query(queryFilter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
public DataTable Query(RefundBalanceQueryFilter queryFilter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = queryFilter.PagingInfo.SortBy; pagingEntity.MaximumRows = queryFilter.PagingInfo.PageSize; pagingEntity.StartRowIndex = queryFilter.PagingInfo.PageIndex * queryFilter.PagingInfo.PageSize; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryRefundBalance"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, null, "RB.[SysNo] DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RB.[OrgRefundSysNo]", DbType.Int32, "@RefundSysNo", QueryConditionOperatorType.Equal, queryFilter.RefundSysNo); cmd.CommandText = sqlBuilder.BuildQuerySql(); cmd.ReplaceParameterValue("#OrderType#", SOIncomeOrderType.RO_Balance); EnumColumnList enumList = new EnumColumnList(); enumList.Add("Status", typeof(RefundBalanceStatus)); enumList.Add("AuditStatus", typeof(RefundStatus)); DataTable dt = cmd.ExecuteDataTable(enumList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }