/// <summary> /// 列表 /// </summary> /// <param name="searchSetting"></param> /// <returns></returns> public static IPageOfList<CompanyProductInfo> List(CompanyProductSearchSetting searchSetting) { FastPaging fp = new FastPaging(); fp.OverOrderBy = " CP.PublishDateTime DESC"; fp.PageIndex = searchSetting.PageIndex; fp.PageSize = searchSetting.PageSize; fp.QueryFields = "*"; fp.TableName = "CompanyProducts"; fp.PrimaryKey = "Id"; fp.TableReName = "CP"; fp.WithOptions = " WITH(NOLOCK)"; fp.Condition = " IsDeleted = 0 "; if(searchSetting.CompanyId >0){ fp.Condition += string.Format(" AND CompanyId = {0}", searchSetting.CompanyId); } if(searchSetting.CategoryId > 0){ fp.Condition += string.Format(" AND CategoryId = {0}",searchSetting.CategoryId); } if(searchSetting.SystemCategoryId >0){ fp.Condition += string.Format(" AND SystemCategoryId = {0}",searchSetting.SystemCategoryId); } IList<CompanyProductInfo> list = new List<CompanyProductInfo>(); CompanyProductInfo model = null; DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005()); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { model = GetByDataRow(dr); if (model != null) { list.Add(model); } } } int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL())); return new PageOfList<CompanyProductInfo>(list, searchSetting.PageIndex, searchSetting.PageSize, count); }
/// <summary> /// 产品列表 /// </summary> /// <param name="searchSetting"></param> /// <returns></returns> public static IPageOfList<CompanyProductInfo> List(CompanyProductSearchSetting searchSetting) { return CompanyProductManage.List(searchSetting); }