public QueryResult QueryOrderCheckMasterList(OrderCheckMasterQueryFilter request) { int totalCount; return(new QueryResult() { Data = ObjectFactory <IOrderCheckMasterQueryDA> .Instance.Query(request, out totalCount), TotalCount = totalCount }); }
public virtual DataTable Query(OrderCheckMasterQueryFilter queryCriteria, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = queryCriteria.PagingInfo.SortBy; pagingEntity.MaximumRows = queryCriteria.PagingInfo.PageSize; pagingEntity.StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetOrderCheckMaster"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, " SysNo ")) { cmd.SetParameterValue("@CompanyCode", queryCriteria.CompanyCode); cmd.CommandText = sqlBuilder.BuildQuerySql(); DataTable dt = cmd.ExecuteDataTable(3, typeof(OrderCheckStatus)); totalCount = dt.Rows.Count; return(dt); } }
private void DataGrid_Result_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { OrderCheckMasterQueryFilter request = new OrderCheckMasterQueryFilter(); request.PagingInfo = new PagingInfo { PageSize = int.MaxValue, PageIndex = e.PageIndex, SortBy = e.SortField }; request.CompanyCode = CPApplication.Current.CompanyCode; OrderCheckMasterFacade facade = new OrderCheckMasterFacade(this); facade.QueryOrderCheckMaster(request, (obj, args) => { if (args.FaultsHandle()) { return; } List <OrderCheckMasterVM> list = DynamicConverter <OrderCheckMasterVM> .ConvertToVMList(args.Result.Rows); dataGridOrderCheckList.ItemsSource = list; dataGridOrderCheckList.TotalCount = list.Count(); }); }
public void QueryOrderCheckMaster(OrderCheckMasterQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "/CustomerService/OrderCheckMaster/Query"; restClient.QueryDynamicData(relativeUrl, request, callback); }