using?System;
using?System.Collections;
using?System.Configuration;
using?System.Data;
using?System.Linq;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.HtmlControls;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.xml.Linq;

namespace?MvcBBS
{
????public?partial?class?_Default?:?System.Web.UI.Page
????{
????????protected?void?Page_Load（object?sender?EventArgs?e）
????????{
????????????if?（!IsPostBack）
????????????{
????????????????string?sqlLan?=?“SELECT?a.groupIdgroupNamegroupInfob.mainTc.huiTd.contentIdd.titled.userIdd.usernamed.addTime?FROM?groupInfo?AS?a?LEFT?join“
??????????????????????????????+?“?（SELECT?count（*）?AS?mainTgroupId?FROM?contentInfo?where?parId=0?GROUP?BY?groupId）?AS?b?ON?a.groupId=b.groupId“
??????????????????????????????+?“?LEFT?JOIN?“
??????????????????????????????+?“?（SELECT?count（*）?AS?huiTgroupId?FROM?contentInfo?where?parId>0?GROUP?BY?groupId）?AS?c?ON?a.groupId=c.groupId“
??????????????????????????????+?“?LEFT?JOIN?“
??????????????????????????????+?“?（SELECT?TOP（SELECT?count（*）?FROM?groupInfo）?contentInfo.groupIdcontentIdtitlecontentInfo.userIduserInfo.userNameaddTime?“
??????????????????????????????+?“?FROM?contentInfouserInfo?WHERE?contentInfo.userId=userInfo.userId?GROUP?BY?contentInfo.groupIdcontentIdtitle“
??????????????????????????????+?“?contentInfo.userIduserInfo.userNameaddTime?ORDER?BY?addTime?DESC）?AS?d?ON?a.groupId=d.groupId“;
????????????????DataTable?dt?=?SqlHelper.ExcuteQuery（sqlLan）;
????????????????datalistlan.DataSource?=?dt;
????????????????datalistlan.DataBind（）;

????????????????if?（Session[“name“]?!=?null?&&?Session[“name“].ToString（）?!=?““）
????????????????{
????????????????????Label1.Text?=?“歡迎您?“;
????????????????????linkButton1.Text?=?Session[“name“].ToString（）;
????????????????????linkButton1.PostBackUrl?=?“userinfo.aspx“;
????????????????}

????????????????Label2.Text?=?SqlHelper.ExecuteScalar（“select?count（*）?from?userInfo“）.ToString（）;
????????????????Label3.Text?=?SqlHelper.ExecuteScalar（“select?count（*）?from?contentInfo?where?addTime=getdate（）“）.ToString（）;
????????????????Label4.Text?=?SqlHelper.ExecuteScalar（“select?count（*）?from?contentInfo“）.ToString（）;
????????????????DataTable?dtt?=?SqlHelper.ExcuteQuery（“select?top?1?userIduserName?from?userInfo?order?by?userId“）;
????????????????linkButton2.Text?=?dtt.Rows[0][1].ToString（）;
????????????????linkButton2.PostBackUrl?=?“userInfo.aspx?userid=“?+?dtt.Rows[0][0].ToString（）;
????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????914??2011-04-22?10:03??MvcBBS\LiuYanBan.sln

????..A..H.?????36352??2011-04-22?10:03??MvcBBS\LiuYanBan.suo

?????文件????????455??2011-04-18?11:49??MvcBBS\newWrite\Default.aspx

?????文件????????503??2011-04-18?11:49??MvcBBS\newWrite\Default.aspx.cs

?????文件????????831??2011-04-18?11:49??MvcBBS\newWrite\Default.aspx.designer.cs

?????文件???????4093??2011-04-18?11:49??MvcBBS\newWrite\newWrite.csproj

?????文件???????7822??2011-04-18?11:49??MvcBBS\newWrite\Web.config

?????文件???????1348??2011-04-18?11:49??MvcBBS\newWrite\Properties\AssemblyInfo.cs

?????文件???????5711??2011-04-21?21:00??MvcBBS\MvcBBS\Default.aspx

?????文件???????2619??2011-04-21?20:45??MvcBBS\MvcBBS\Default.aspx.cs

?????文件???????3246??2011-04-21?20:57??MvcBBS\MvcBBS\Default.aspx.designer.cs

?????文件????????844??2011-04-12?21:37??MvcBBS\MvcBBS\Default.aspx.designer.cs~RF1602ba3.TMP

?????文件???????3435??2011-04-18?15:18??MvcBBS\MvcBBS\LiuYan.aspx

?????文件???????2220??2011-04-19?23:24??MvcBBS\MvcBBS\LiuYan.aspx.cs

?????文件???????1881??2011-04-18?12:16??MvcBBS\MvcBBS\LiuYan.aspx.designer.cs

?????文件???????9603??2011-04-12?22:34??MvcBBS\MvcBBS\liuyan.css

?????文件???????2998??2011-04-21?20:43??MvcBBS\MvcBBS\LoginUser.aspx

?????文件???????5394??2011-04-18?14:57??MvcBBS\MvcBBS\LoginUser.aspx.cs

?????文件???????2914??2011-04-21?20:40??MvcBBS\MvcBBS\LoginUser.aspx.designer.cs

?????文件???????9653??2011-04-21?20:48??MvcBBS\MvcBBS\main.css

?????文件???????1219??2011-04-19?15:28??MvcBBS\MvcBBS\LiuYanBan.csproj.user

?????文件???????3794??2011-04-20?21:08??MvcBBS\MvcBBS\userInfo.aspx

?????文件???????5685??2011-04-20?00:05??MvcBBS\MvcBBS\newWrite.aspx.cs

?????文件???????2225??2011-04-20?00:06??MvcBBS\MvcBBS\newWrite.aspx.designer.cs

?????文件???????9603??2011-04-18?14:55??MvcBBS\MvcBBS\newWrite.css

?????文件???????4054??2011-04-15?17:53??MvcBBS\MvcBBS\regUser.aspx

?????文件???????5596??2011-04-18?14:24??MvcBBS\MvcBBS\regUser.aspx.cs

?????文件???????4991??2011-04-14?16:36??MvcBBS\MvcBBS\regUser.aspx.designer.cs

?????文件???????9625??2011-04-13?12:43??MvcBBS\MvcBBS\regUser.css

?????文件???????8448??2011-04-12?21:39??MvcBBS\MvcBBS\SqlHelper.cs

............此處省略76個文件信息