public QueryResult QuerySaleAdvTemplates(SaleAdvTemplateQueryFilter msg) { int totalCount; var dataTable = ObjectFactory <ISaleAdvTemplateQueryDA> .Instance.Query(msg, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
public DataTable Query(SaleAdvTemplateQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = filter.PagingInfo.SortBy; pagingEntity.MaximumRows = filter.PagingInfo.PageSize; pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QuerySaleAdvTemplates"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "result.CreateDate DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sa.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sa.CreateTime", DbType.DateTime, "@CreateDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.CreateDateFrom); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sa.CreateTime", DbType.DateTime, "@CreateDateTo", QueryConditionOperatorType.LessThan, filter.CreateDateTo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sa.Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, filter.Status); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "v_user.DisplayName", DbType.String, "@CreateUser", QueryConditionOperatorType.Like, filter.CreateUser); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sa.CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); cmd.CommandText = sqlBuilder.BuildQuerySql(); DataTable dt = cmd.ExecuteDataTable(new EnumColumnList { { "Status", typeof(SaleAdvStatus) }, { "EnableReplyRank", typeof(CustomerRank) }, { "Type", typeof(ShowType) }, { "GroupType", typeof(GroupType) } }); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public void Query(SaleAdvQueryVM vm, int pageSize, int pageIndex, string sortField, EventHandler <RestClientEventArgs <dynamic> > callback) { SaleAdvTemplateQueryFilter filter = vm.ConvertVM <SaleAdvQueryVM, SaleAdvTemplateQueryFilter>(); filter.CompanyCode = CPApplication.Current.CompanyCode; filter.PagingInfo = new QueryFilter.Common.PagingInfo { PageSize = pageSize, PageIndex = pageIndex, SortBy = sortField }; string relativeUrl = "/MKTService/SaleAdvTemplate/Query"; restClient.QueryDynamicData(relativeUrl, filter, (obj, args) => { if (args.FaultsHandle()) { return; } callback(obj, args); }); }