博客园URL重写月份那里 存储过程代码应该是这样的

          url重写   下次开发一定这么搞，呵呵

          博客园的那个月份的 应该是如下存储过程的思维
ALTER proc [dbo].[GetMonthCount]
(
@userId int   --用户ID号  根据username获取
)
as
begin 
 
SELECT month([createdate])  as month , year([createdate]) as  year
      
      ,count([content_id])  as  count
      
  FROM [ForeTechTest].[dbo].[blog_content]

where  User_id=@userId

group by year([createdate]),month([createdate])
order by year([createdate]) desc ,month([createdate]) desc
end

 

 

操作结果如下：

 

aspx页面

 <div>
    <%=TableTime() %>
    </div>

cs页面：

 

 

public string TableTime()
    {

        try
        {
            System.Data.SqlClient.SqlParameter para = new System.Data.SqlClient.SqlParameter("@userId",2);//为了简单起见
            DataSet ds = DBTool.ExecuteDataset(System.Data.CommandType.StoredProcedure, "GetMonthCount", para);
            string UID = "JASENKIN";//为了简单   设置此值
            string Year, Month;
            StringBuilder sb = new StringBuilder();
            sb.Append("<ul>");
            if(ds!=null&&ds.Tables[0].Rows.Count>0){
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                Year = ds.Tables[0].Rows[i]["year"].ToString();
                Month = ds.Tables[0].Rows[i]["month"].ToString();
                sb.Append("<li><a href=/Blog/" + UID + "/" + Year + "/" + Month + "/index.aspx" + ">");
                sb.Append(Year + "年" + Month + "月");
                sb.Append("("+ds.Tables[0].Rows[i]["count"].ToString()+")");
                sb.Append("</a></li>");
            }
            }
            sb.Append("</ul>");
            return sb.ToString();

        }
        catch
        {
            return "";
        }
    }

 

 

 

测试结果

 

 

*********************************