select a.* from (
Select id,kind,uid,cname,row_number()over(partition by cname order by id ) as row from info_table where CONTAINS(pdname,'XX产品') and DATEDIFF(day,addtime,getdate())<7  
)a where a.row=1

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;
using System.Drawing.Imaging;
using System.Drawing.Text;
using System.IO;
/// <summary>
/// 本页面只作为一个图片被调用
/// </summary>
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SetFontImage(Request.QueryString["familyName"], Convert.ToInt32(Request.QueryString["fontSize"]), Request.QueryString["targetString"]);
    }
    /// <summary>
    /// 生成文字图片
    /// </summary>
    /// <param name="familyName">字体</param>
    /// <param name="fontSize">字号</param>
    /// <param name="targetString">生成内容</param>
    public void SetFontImage(string familyName,int fontSize,string targetString)
    {
        //创建位图对象
        Bitmap objBitmap = null;
        //创建绘图图面对象
        Graphics g = null;
        //创建并初始化字体对象
        Font stringFont = new Font(familyName, fontSize, FontStyle.Bold);
        //文本布局对象
        StringFormat stringFormat = new StringFormat();
        //设置文本格式
        stringFormat.FormatFlags = StringFormatFlags.NoWrap;
        //绘图过程
        try
        {
            //实例化位图对象
            objBitmap = new Bitmap(1, 1);
            //实例化绘图图面对象，将位图对象放入图面中
            g = Graphics.FromImage(objBitmap);
            //获取欲绘制文字图片的高宽
            SizeF stringSize = g.MeasureString(targetString, stringFont);
            int nWidth = (int)stringSize.Width;
            int nHeight = (int)stringSize.Height;
            //获取高宽后释放无用的图面对象资源和位图对象资源
            g.Dispose();
            objBitmap.Dispose();
            //根据已获得的高宽实例化新的位图对象
            objBitmap = new Bitmap(nWidth, nHeight);
            //根据新的位图对象实例化新的绘图图面对象
            g = Graphics.FromImage(objBitmap);
            //填充图片，可以指定背景颜色，开始坐标和图片高宽，指定文本呈现样式
            g.FillRectangle(new SolidBrush(Color.White), new Rectangle(0, 0, nWidth, nHeight));
            g.TextRenderingHint = TextRenderingHint.AntiAlias;
            //开始绘制
            g.DrawString(targetString, stringFont, new SolidBrush(Color.Black), new PointF(0, 0), stringFormat);
            //生成图片
            objBitmap.Save(Response.OutputStream, ImageFormat.Gif);
            
        }
        catch (Exception ee)
        {
            Response.Write(ee.ToString());
        }
        finally
        {
            if (null != g) g.Dispose();
            if (null != objBitmap) objBitmap.Dispose();
            Response.End();
        }
    }
}

html
　　<div id="wrap">正常文字的换行(亚洲文字和非亚洲文字)元素拥有默认的white-space:normal,当定义</div>
　　css
　　#wrap{white-space:normal; width:200px; }

html
　　<div id="wrap">flywenetflywenetflywenetflywenetflywenetflywenetflywenet</div>
　　css
　　#wrap{word-break:break-all; width:200px;}
或者
    #wrap{word-wrap:break-word; width:200px;}

html
　　<div id="wrap">flywenetflywenetflywenetflywenetflywenetflywenetflywenet</div>
　　css
　　#wrap{word-break:break-all; width:200px; overflow:auto;}

<table style="table-layout:fixed" width="200"><tr><td>flywenetflywenetflywenetflywenetflywenetflywenetflywenet</td></tr></table>

<table width="200" style="table-layout:fixed;"><tr><td width="25%" style="word-break : break-all; ">flywenetflywenetflywenetflywenetflywenetflywenetflywenet</td><td style="word-wrap : break-word ;">flywenetflywenetflywenetflywenetflywenetflywenetflywenet</td></tr></table>

<table style="table-layout:fixed" width="200"><tr>
<td width="25%"   style="word-break : break-all; overflow:hidden; ">flywenetflywenetflywenetflywenetflywenetflywenetflywenet</td>
<td width="75%" style="word-wrap : break-word; overflow:hidden; ">flywenetflywenetflywenetflywenetflywenetflywenetflywenet</td>
</tr></table>

.wrap { table-layout:fixed; word-break: break-all; overflow:hidden; }

<option value="cancelIndex">  - 取消首页独享</option>

<option>------------------------</option>
<option value="doSystem">  - 模块系统化</option>
<option value="cancelSystem">  - 取消系统化</option>

Case "cancelIndex":
                conn.Execute("update blog_module set IndexOnly=false where id="&selectID(i))

Case "doSystem":
                conn.Execute("update blog_module set IsSystem=true where id="&selectID(i))
Case "cancelSystem":
                conn.Execute("update blog_module set IsSystem=false where id="&selectID(i))