public QueryResult QueryTariffInfo(TariffInfoQueryFilter request) { int totalCount; var dataTable = ObjectFactory <ITariffInfoQueryDA> .Instance.QueryTariffInfo(request, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
/// <summary> /// 税率规格信息查询 /// </summary> /// <param name="queryVM"></param> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="SortField"></param> /// <param name="callback"></param> public void TariffInfoQuery(TariffInfoQueryFilterVM queryVM, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { TariffInfoQueryFilter queryFilter = new TariffInfoQueryFilter(); queryFilter = queryVM.ConvertVM <TariffInfoQueryFilterVM, TariffInfoQueryFilter>(); queryFilter.PagingInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; string relativeUrl = "/CommonService/Tariff/Query"; restClient.QueryDynamicData(relativeUrl, queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } callback(obj, args); }); }
/// <summary> /// 查询税率规则 /// </summary> /// <param name="queryCriteria"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryTariffInfo(TariffInfoQueryFilter 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("QueryTariffInfo"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "SysNo desc")) { //系统编号 if (queryCriteria.SysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, queryCriteria.SysNo.Value); } if (queryCriteria.Status.HasValue) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, queryCriteria.Status.Value); } if (!string.IsNullOrEmpty(queryCriteria.ItemCategoryName)) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "ItemCategoryName", DbType.String, "@ItemCategoryName", QueryConditionOperatorType.Equal, queryCriteria.ItemCategoryName); } if (!string.IsNullOrEmpty(queryCriteria.TariffCode)) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "TariffCode", DbType.String, "@TariffCode", QueryConditionOperatorType.Equal, queryCriteria.TariffCode); } if (!string.IsNullOrEmpty(queryCriteria.TariffRate)) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "TariffRate", DbType.String, "@TariffRate", QueryConditionOperatorType.Equal, queryCriteria.TariffRate); } if (queryCriteria.ParentSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "ParentSysNo", DbType.Int32, "@ParentSysNo", QueryConditionOperatorType.Equal, queryCriteria.ParentSysNo.Value); } if (queryCriteria.SearchCode.HasValue) { if (string.IsNullOrEmpty(queryCriteria.TariffCode) && string.IsNullOrEmpty(queryCriteria.ItemCategoryName) && !queryCriteria.ParentSysNo.HasValue) { cmd.CommandText = sqlBuilder.BuildQuerySql().Replace("#RepalceWhere#", "where TariffPrice>0"); } else { cmd.CommandText = sqlBuilder.BuildQuerySql().Replace("#RepalceWhere#", "and TariffPrice>0"); } } else { cmd.CommandText = sqlBuilder.BuildQuerySql().Replace("#RepalceWhere#", ""); } EnumColumnList enumConfig = new EnumColumnList(); enumConfig.Add("Status", typeof(TariffStatus)); DataTable dt = cmd.ExecuteDataTable(enumConfig); totalCount = int.Parse(cmd.GetParameterValue("TotalCount").ToString()); return(dt); } }