/// <summary> /// 查询备案信息 /// </summary> /// <returns></returns> public ActionResult QueryProductEntryInfo() { ProductEntryInfoQueryFilter filter = BuildQueryFilterEntity <ProductEntryInfoQueryFilter>(); var user = UserAuthHelper.GetCurrentUser(); filter.SellerSysNo = user != null ? user.SellerSysNo : 0; var result = ProductMaintainService.QueryProductEntryInfo(filter); return(AjaxGridJson(result)); }
/// <summary> /// 查询备案信息 /// </summary> /// <param name="filter">查询条件</param> /// <param name="dataCount">总记录数</param> /// <returns></returns> public static List <ProductEntryInfo> ProductEntryInfoQuery(ProductEntryInfoQueryFilter filter, out int dataCount) { List <ProductEntryInfo> result = new List <ProductEntryInfo>(); CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryProductEntryInfo"); using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(command.CommandText, command, filter, !string.IsNullOrWhiteSpace(filter.SortFields) ? filter.SortFields : "P.SysNo DESC")) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "P.MerchantSysNo", DbType.Int32, "@SellerSysNo", QueryConditionOperatorType.Equal, filter.SellerSysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "P.SysNo", DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, filter.ProductSysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "P.ProductTitle", DbType.String, "@ProductTitle", QueryConditionOperatorType.Like, filter.ProductTitle); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Product_SKUNO", DbType.String, "@ProductSKUNO", QueryConditionOperatorType.Like, filter.ProductSKUNO); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Supplies_Serial_No", DbType.String, "@SuppliesSerialNo", QueryConditionOperatorType.Like, filter.SuppliesSerialNo); if (!string.IsNullOrEmpty(filter.ManufactureDateBegin)) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ManufactureDate", DbType.String, "@ManufactureDateBegin", QueryConditionOperatorType.MoreThanOrEqual, filter.ManufactureDateBegin); } if (!string.IsNullOrEmpty(filter.ManufactureDateEnd)) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ManufactureDate", DbType.String, "@ManufactureDateEnd", QueryConditionOperatorType.LessThan, DateTime.Parse(filter.ManufactureDateEnd).AddDays(1).ToShortDateString()); } if (filter.EntryStatus == 0) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ISNULL(EntryStatus, 0)", DbType.Int32, "@EntryStatus1", QueryConditionOperatorType.Equal, filter.EntryStatus); } else { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "EntryStatus", DbType.Int32, "@EntryStatus", QueryConditionOperatorType.Equal, filter.EntryStatus); } command.CommandText = builder.BuildQuerySql(); result = command.ExecuteEntityList <ProductEntryInfo>(); dataCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(result); } }