public QueryResult GetFPCheckMaster(FPCheckQueryFilter query) { int totalCount; return(new QueryResult() { Data = ObjectFactory <IFPCheckQueryDA> .Instance.Query(query, out totalCount), TotalCount = totalCount }); }
public virtual DataTable Query(FPCheckQueryFilter 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("QueryFPCheckMaster"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, " a.sysno ASC ")) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "a.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, "8601"); cmd.CommandText = sqlBuilder.BuildQuerySql(); cmd.SetParameterValue("@ChannelID", queryCriteria.ChannelID); DataTable dt = cmd.ExecuteDataTable(); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public FPCheck() { viewModel = new FPCheckVM(); queryRequest = new FPCheckQueryFilter(); InitializeComponent(); }
/// <summary> /// 查询FP状态 /// </summary> /// <param name="request"></param> /// <param name="callback"></param> public void Query(FPCheckQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "/CustomerService/FPCheckMaster/Query"; restClient.QueryDynamicData(relativeUrl, request, callback); }