public ActionResult AjaxQuery() { ProductCategoryQueryFilter queryCriteria = BuildQueryFilterEntity <ProductCategoryQueryFilter>(); queryCriteria.SortFields = "ProductSysNo"; int?currentSellerSysNo = null; int currentSellerSysNoValue = UserAuthHelper.GetCurrentUser().SellerSysNo; if (currentSellerSysNoValue > 0) { currentSellerSysNo = currentSellerSysNoValue; } queryCriteria.SellerSysNo = currentSellerSysNo; QueryResult <ProductCategoryQueryBasicInfo> result = ProductAttachmentService.QueryProductCategorys(queryCriteria); return(AjaxGridJson(result)); }
public static QueryResult <ProductCategoryQueryBasicInfo> QueryProductCategorys(ProductCategoryQueryFilter queryCriteria) { int totalCount = 0; QueryResult <ProductCategoryQueryBasicInfo> result = new QueryResult <ProductCategoryQueryBasicInfo>(); List <ProductCategoryQueryBasicInfo> list = ProductAttachmentDA.QueryProductCategory(queryCriteria, out totalCount); result.ResultList = list; result.PageInfo = new PageInfo { PageIndex = queryCriteria.PageIndex, PageSize = queryCriteria.PageSize, TotalCount = totalCount, }; return(result); }
public static List <ProductCategoryQueryBasicInfo> QueryProductCategory(ProductCategoryQueryFilter queryCriteria, out int totalCount) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryProductCategory"); var pagingInfo = new PagingInfoEntity { StartRowIndex = queryCriteria.PageIndex * queryCriteria.PageSize, MaximumRows = queryCriteria.PageSize, SortField = queryCriteria.SortFields, }; using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, string.IsNullOrEmpty(pagingInfo.SortField) ? pagingInfo.SortField : "P.ProductSysNo DESC")) { if (!String.IsNullOrEmpty(queryCriteria.ProductSysNo)) { dataCommand.AddInputParameter("@ProductID", DbType.String, queryCriteria.ProductSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "P.ProductSysNo", DbType.String, "@ProductID", QueryConditionOperatorType.Like, queryCriteria.ProductSysNo); } if (!String.IsNullOrEmpty(queryCriteria.ProductName)) { dataCommand.AddInputParameter("@ProductName", DbType.String, queryCriteria.ProductName); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "P.ProductName", DbType.String, "@ProductName", QueryConditionOperatorType.Like, queryCriteria.ProductName); } if (!String.IsNullOrEmpty(queryCriteria.ProductAttachmentSysNo)) { dataCommand.AddInputParameter("@AttachmentID", DbType.String, queryCriteria.SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "P.AttachmentSysNo", DbType.String, "@ProductAttachmentSysNo", QueryConditionOperatorType.Like, queryCriteria.ProductAttachmentSysNo); } //if (!String.IsNullOrEmpty(queryCriteria.ProductAttachmentSysNo)) //{ // dataCommand.AddInputParameter("@AttachmentName", DbType.String, queryCriteria.AttachmentName); // sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, // "P.AttachmentName", // DbType.String, "@AttachmentName", // QueryConditionOperatorType.Like, // queryCriteria.AttachmentName); //} if (!String.IsNullOrEmpty(queryCriteria.EditUser)) { dataCommand.AddInputParameter("@EditUser", DbType.String, queryCriteria.EditUser); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "P.InUser", DbType.String, "@EditUser", QueryConditionOperatorType.Like, queryCriteria.EditUser); } //sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "P.InDate", DbType.DateTime, "@InDate", QueryConditionOperatorType.LessThanOrEqual, QueryConditionOperatorType.MoreThanOrEqual, queryCriteria.InDateEnd, queryCriteria.InDateStart); if (queryCriteria.InDateStart != null) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "P.InDate", DbType.DateTime, "@InDateStart", QueryConditionOperatorType.MoreThanOrEqual, queryCriteria.InDateStart ); } if (queryCriteria.InDateEnd != null) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "P.InDate", DbType.DateTime, "@InDateEnd", QueryConditionOperatorType.LessThanOrEqual, queryCriteria.InDateEnd ); } if (queryCriteria.SellerSysNo.HasValue) { dataCommand.AddInputParameter("@SellerSysNo", DbType.String, queryCriteria.SellerSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "P.SellerID", DbType.String, "@SellerSysNo", QueryConditionOperatorType.Equal, queryCriteria.SellerSysNo); } dataCommand.CommandText = sqlBuilder.BuildQuerySql(); List <ProductCategoryQueryBasicInfo> list = dataCommand.ExecuteEntityList <ProductCategoryQueryBasicInfo>(); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(list); } }