代碼個人工作總結(jié)

本文格式為Word版下載后可任意編輯和復(fù)制第第頁代碼個人工作總結(jié)

分頁：

usingSystem;

usingSystem.Collections;

usingSystem.Configuration;

usingSystem.Data;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.Security;

usingSystem.Web.UI;

usingSystem.Web.UI.HtmlControls;

usingSystem.Web.UI.WebControls;

usingSystem.Web.UI.WebControls.WebParts;

usingSystem.Xml.Linq;

usingSystem.Configuration;

usingSystem.Data.SqlClient;

publicpartialclasstemplates_scanmessageboard:System.Web.UI.Page

{

publicstaticintcurrentpages=1;

publicstaticinttatolpages=1;

publicstaticintsize=5;

publicstaticintm=0;

protectedvoidPage_Load(objectsender,EventArgse)

{

stringcon=ConfigurationSettings.AppSettings[sqlconn];

SqlConnectionconn=newSqlConnection(con);

conn.Open();

SqlCommandcmd=newSqlCommand();

cmd.Connection=conn;

cmd.CommandType=CommandType.Text;

cmd.CommandText=selectcount(*)frommessage;

inti=Convert.ToInt32(cmd.ExecuteScalar());

tatolpages=i/size;

m=i%size;

if(tatolpages==0)

{

cmd.CommandText=select*frommessage;

SqlDataReadersdr=cmd.ExecuteReader();

while(sdr.Read())

{

Label1.Text+=(divclass=contentbrdiv

style=width:300px;float:left;+sdr[Ucontent]+/divdivstyle=float:rightahref=detailmessage.aspx?id=+sdr[id]+查看詳情/a——ahref=pinlun.aspx?id=+sdr[id]+批閱留言/a——ahref=deletemessage.aspx?id=+sdr[id]+刪除留言

/a/div/divhrsize=3width=100%/);

}

Label2.Text+=當前頁數(shù)為：+currentpages+--共+(tatolpages+1)+頁;conn.Close();

conn.Dispose();

}

else

{

cmd.CommandText=selecttop+size+*frommessagewhere(idnotin(selecttop+(currentpages-1)*size+idfrommessageorderbyiddesc))orderbyiddesc;

SqlDataReadersdr=cmd.ExecuteReader();

while(sdr.Read())

{

Label1.Text+=(divclass=contentbrdiv

style=width:300px;float:left;+sdr[Ucontent]+/divdivstyle=float:rightahref=detailmessage.aspx?id=+sdr[id]+查看詳情/a——ahref=pinlun.aspx?id=+sdr[id]+批閱留言/a——ahref=deletemessage.aspx?id=+sdr[id]+刪除留言/a/div/divhrsize=3width=100%/);

}

if(m==0)

{

Label2.Text+=當前頁數(shù)為：+currentpages+--共+(tatolpages)+頁;}

else

{

Label2.Text+=當前頁數(shù)為：+currentpages+--共+(tatolpages+1)+頁;

}

conn.Close();

conn.Dispose();

}

}

protectedvoidButton1_Click(objectsender,EventArgse)

{

currentpages=1;

Label1.Text=;

Label2.Text=;

stringcon=ConfigurationSettings.AppSettings[sqlconn];

SqlConnectionconn=newSqlConnection(con);

conn.Open();

SqlCommandcmd=newSqlCommand();

cmd.Connection=conn;

cmd.CommandType=CommandType.Text;

cmd.CommandText=selecttop+size+*frommessagewhere(idnotin(selecttop+(currentpages-1)*size+idfrommessageorderbyiddesc))orderbyiddesc;SqlDataReadersdr=cmd.ExecuteReader();

while(sdr.Read())

{

Label1.Text+=(divclass=contentbrdivstyle=width:300px;float:left;+sdr[Ucontent]+/divdivstyle=float:rightahref=detailmessage.aspx?id=+sdr[id]+查看詳情/a——ahref=pinlun.aspx?id=+sdr[id]+批閱留言/a——a

href=deletemessage.aspx?id=+sdr[id]+刪除留言/a/div/divhrsize=3

width=100%/);

}

if(m==0)

{

Label2.Text+=當前頁數(shù)為：+currentpages+--共+(tatolpages)+頁;}

else

{

Label2.Text+=當前頁數(shù)為：+currentpages+--共+(tatolpages+1)+頁;}

conn.Close();

conn.Dispose();

}

protectedvoidButton3_Click(objectsender,EventArgse)

{

if(m==0)

{

if(currentpages(tatolpages))

{

currentpages=currentpages+1;

Label1.Text=;

Label2.Text=;

stringcon=ConfigurationSettings.AppSettings[sqlconn];

SqlConnectionconn=newSqlConnection(con);

conn.Open();

SqlCommandcmd=newSqlCommand();

cmd.Connection=conn;

cmd.CommandType=CommandType.Text;

cmd.CommandText=selecttop+size+*frommessagewhere(idnotin(select

top+(currentpages-1)*size+idfrommessageorderbyiddesc))orderbyiddesc;SqlDataReadersdr=cmd.ExecuteReader();

while(sdr.Read())

{

Label1.Text+=(divclass=contentbrdiv

style=width:300px;float:left;+sdr[Ucontent]+/divdivstyle=float:rightahref=detailmessage.aspx?id=+sdr[id]+查看詳情/a——ahref=pinlun.aspx?id=+sdr[id]+批閱留言/a——ahref=deletemessage.aspx?id=+sdr[id]+刪除留言/a/div/divhrsize=3width=100%/);

}

Label2.Text+=當前頁數(shù)為：+currentpages+--共+(tatolpages)+頁;conn.Close();

conn.Dispose();

}

else

{

this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(),key,alert(已是最終一頁！);,true);

Response.Redirect(scanmessageboard.aspx);

}

}

else

{

if(currentpages=(tatolpages))

{

currentpages=currentpages+1;

Label1.Text=;

Label2.Text=;

stringcon=ConfigurationSettings.AppSettings[sqlconn];

SqlConnectionconn=newSqlConnection(con);

conn.Open();

SqlCommandcmd=newSqlCommand();

cmd.Connection=conn;

cmd.CommandType=CommandType.Text;

cmd.CommandText=selecttop+size+*frommessagewhere(idnotin(selecttop+(currentpages-1)*size+idfrommessageorderbyiddesc))orderbyiddesc;SqlDataReadersdr=cmd.ExecuteReader();

while(sdr.Read())

{

Label1.Text+=(divclass=contentbrdiv

style=width:300px;float:left;+sdr[Ucontent]+/divdivstyle=float:rightahref=detailmessage.aspx?id=+sdr[id]+查看詳情/a——ahref=pinlun.aspx?id=+

sdr[id]+批閱留言/a——ahref=deletemessage.aspx?id=+sdr[id]+刪除留言/a/div/divhrsize=3width=100%/);

}

Label2.Text+=當前頁數(shù)為：+currentpages+--共+(tatolpages+1)+頁;

conn.Close();

conn.Dispose();

}

else

{

this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(),key,alert(已是最終一頁！);,true);

Response.Redirect(scanmessageboard.aspx);

}

}

}

protectedvoidButton2_Click(objectsender,EventArgse)

{

if(currentpages1)

{

currentpages=currentpages-1;

Label1.Text=;

Label2.Text=;

stringcon=ConfigurationSettings.AppSettings[sqlconn];

SqlConnectionconn=newSqlCo