List<SqlParameter> paras = new List<SqlParameter>();
StringBuilder strSQL = new StringBuilder();
strSQL.AppendFormat(" SELECT DISTINCT TOP {0} N_Style_Assess.Content,dbo.N_Style_Assess.AddTime ",this.ItemSetting.Top);
strSQL.Append(" FROM dbo.N_Style_Assess");
strSQL.Append(" INNER JOIN dbo.Product ON dbo.N_Style_Assess.ProductCode = dbo.Product.ProductCode");
strSQL.Append(" INNER JOIN dbo.N_Style_Product ON dbo.Product.ProductCode = dbo.N_Style_Product.ProductCode");
strSQL.Append(" INNER JOIN dbo.N_Style_Category ON dbo.N_Style_Product.StyleID = dbo.N_Style_Category.StyleID");
strSQL.Append(" WHERE dbo.N_Style_Assess.IsShow = 1");
strSQL.Append(" AND Colligation = 5");
strSQL.Append(" AND Appearance = 5");
strSQL.Append(" AND Comfort = 5");
所有评论