public QueryResult QueryDeductList(DeductQueryFilter request) { int totalCount = 0; QueryResult returnResult = new QueryResult() { Data = ObjectFactory <IDeductQueryDA> .Instance.LoadDeductInfo(request, out totalCount) }; returnResult.TotalCount = totalCount; return(returnResult); }
private void btnSearch_Click(object sender, RoutedEventArgs e) { //构造查询条件 //扣款名称 string name = this.txtName.Text.Trim(); if (name.Length > 200) { return; } deductQueryVM.Name = this.txtName.Text.Trim(); //构造查询条件 this.queryRequest = EntityConverter <DeductQueryVM, DeductQueryFilter> .Convert(deductQueryVM); QueryResultGrid.Bind(); }
void dgDeductInfo_LoadingDataSource(object sender, LoadingDataEventArgs e) { DeductQueryFilter filter = new DeductQueryFilter() { DeductType = DeductType.Temp, Status = Status.Effective }; serviceFacade.QueryDeducts(filter, (obj, args) => { if (args.FaultsHandle()) { ItemList = new List <DeductVM>(); return; } ItemList = DynamicConverter <DeductVM> .ConvertToVMList(args.Result.Rows); this.dgDeductInfo.ItemsSource = ItemList; }); }
/// <summary> /// 扣款项维护列表 /// </summary> /// <param name="queryFilter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable LoadDeductInfo(DeductQueryFilter queryFilter, out int totalCount) { if (queryFilter == null) { totalCount = -1; return(null); } CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryDeductList"); if (null != queryFilter.PageInfo.SortBy) { if (queryFilter.PageInfo.SortBy.IndexOf("[Status]") > -1) { queryFilter.PageInfo.SortBy = "D." + queryFilter.PageInfo.SortBy; } } PagingInfoEntity pagingInfo = new PagingInfoEntity() { SortField = queryFilter.PageInfo.SortBy, StartRowIndex = queryFilter.PageInfo.PageIndex * queryFilter.PageInfo.PageSize, MaximumRows = queryFilter.PageInfo.PageSize }; using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, pagingInfo, "Indate DESC")) { if (!string.IsNullOrEmpty(queryFilter.Name)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Name", DbType.String, "@Name", QueryConditionOperatorType.Like, queryFilter.Name); } if (queryFilter.DeductType.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "DeductType", DbType.Int32, "@DeductType", QueryConditionOperatorType.Equal, queryFilter.DeductType.Value); } if (queryFilter.AccountType.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "AccountType", DbType.Int32, "@AccountType", QueryConditionOperatorType.Equal, queryFilter.AccountType.Value); } if (queryFilter.DeductMethod.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "DeductMethod", DbType.Int32, "@DeductMethod", QueryConditionOperatorType.Equal, queryFilter.DeductMethod.Value); } if (queryFilter.Status.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "D.Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, queryFilter.Status.Value); } command.CommandText = sqlBuilder.BuildQuerySql(); command.SetParameterValue("@StartNumber", queryFilter.PageInfo.PageSize * queryFilter.PageInfo.PageIndex); command.SetParameterValue("@EndNumber", queryFilter.PageInfo.PageSize * queryFilter.PageInfo.PageIndex + queryFilter.PageInfo.PageSize); EnumColumnList columnEnums = new EnumColumnList(); columnEnums.Add("DeductType", typeof(DeductType)); columnEnums.Add("AccountType", typeof(AccountType)); columnEnums.Add("DeductMethod", typeof(DeductMethod)); columnEnums.Add("Status", typeof(Status)); DataTable dt = command.ExecuteDataTable(columnEnums); totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(dt); } }
/// <summary> /// 查询扣款项维护列表 /// </summary> /// <param name="request"></param> /// <param name="callback"></param> public void QueryDeducts(DeductQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "/POService/Deduct/QueryDeductList"; restClient.QueryDynamicData(relativeUrl, request, callback); }