📄 default.aspx.cs
字号:
}
catch{}
//Label6.Text=Convert.ToString((int)Application["user_sessions"]-(int)Application["huiyuan_sessions"]);
HttpBrowserCapabilities bc= Request.Browser;
Label3.Text=bc.Browser+" "+bc.Version;
Label2.Text=bc.Platform;
hostname=Dns.GetHostName();
IPHostEntry jj=Dns.GetHostByName(hostname);
//IPAddress ip=Dns.Resolve(hostname);
Label1.Text=jj.AddressList[0].ToString();
//主体
mysql="SELECT * FROM ancestor ORDER BY ancestor_id";
//Try
mydada=new SqlDataAdapter(mysql,myconn);
DataTable mytable;
DataTable mytable1;
DataTable mytable2;
DataTable mytable3;
DataTable mytable4;
DataTable mytable5;
mytable=new DataTable();
mydada.Fill(mytable);
//
HtmlTableRow myrow;
HtmlTableCell mycell;
if(mytable.Rows.Count>0)
{
for(int i=0;i<=mytable.Rows.Count-1;i++)
{
mysql="SELECT top 1 postid,zhuti,yonghuming,shijian FROM posts where ancestor_id='"+mytable.Rows[i]["ancestor_id"]+"' ORDER BY postid desc";
mydada=new SqlDataAdapter(mysql,myconn);
mytable1=new DataTable();
mydada.Fill(mytable1);
string zhuti;
string name;
string time;
try
{
if(mytable1.Rows[0]["zhuti"].ToString().Length>=15)
zhuti=mytable1.Rows[0]["zhuti"].ToString().Trim().Substring(0,15)+"<FONT color='gray'>…</font>";
else
zhuti=mytable1.Rows[0]["zhuti"].ToString().Trim();
zhuti="<A href='huifu.aspx?post_id="+mytable1.Rows[0]["postid"].ToString()+"&ancestor_id="+mytable.Rows[i]["ancestor_id"]+"&Page=1'><font face='宋体' color='#0066ff'>"+zhuti+"</font></A>";
name=mytable1.Rows[0]["yonghuming"].ToString().Trim();
name="<A title='点击查看作者资料' href='hyziliaochakan.aspx?UserId="+name+"' target='_blank'><font face='宋体'><font color=#BB865E>※</font>"+name+"<font color=#BB865E>※</font></font></a>";
time=Convert.ToDateTime(mytable1.Rows[0]["shijian"]).ToLongDateString().ToString();
}
catch
{
zhuti="<font color=#ff00ff>暂无新主题</font>";
name="";
time="";
}
mysql="SELECT count(*) FROM posts where ancestor_id='"+mytable.Rows[i]["ancestor_id"]+"' ";
mydada=new SqlDataAdapter(mysql,myconn);
//mytable1.Clear();
mytable2=new DataTable();
mydada.Fill(mytable2);
string top="";
try
{
top=mytable2.Rows[0][0].ToString().Trim();
}
catch
{}
////////////////////
DateTime now1=DateTime.Now;
mysql="SELECT count(postid) FROM posts where ancestor_id='"+mytable.Rows[i]["ancestor_id"]+"' and shijian>='"+now1.ToString("yyyy-MM-dd")+"'";
mydada=new SqlDataAdapter(mysql,myconn);
//mytable1.Clear();
mytable3=new DataTable();
mydada.Fill(mytable3);
string today="0";
int today1=0;
try
{
today1=Convert.ToInt32(mytable3.Rows[0][0].ToString());
}
catch
{}
mysql="SELECT distinct count(huifu_id) FROM huifu,posts where posts.ancestor_id='"+mytable.Rows[i]["ancestor_id"]+"' and posts.postid=huifu.post_id and huifu.shijian>='"+now1.ToString("yyyy-MM-dd")+"'";
mydada=new SqlDataAdapter(mysql,myconn);
//mytable1.Clear();
mytable5=new DataTable();
mydada.Fill(mytable5);
try
{
today=Convert.ToString(today1+Convert.ToInt32(mytable5.Rows[0][0].ToString()));
}
catch
{}
//////////////////////
mysql="SELECT distinct count(huifu_id) FROM huifu,posts where posts.ancestor_id='"+mytable.Rows[i]["ancestor_id"]+"' and posts.postid=huifu.post_id";
mydada=new SqlDataAdapter(mysql,myconn);
//mytable4.Clear();
mytable4=new DataTable();
mydada.Fill(mytable4);
string huifu="";
try
{
huifu=mytable4.Rows[0][0].ToString().Trim();
}
catch
{}
string banzhu="";
if(mytable.Rows[i]["banzhu"].ToString().Trim()=="")
banzhu="<A href='../ader/zhaoping.aspx'target='_blank'>诚聘版主</a>";
else
banzhu="<font color=#BB865E>|</font><A title='点击查看版主资料' href='hyziliaochakan.aspx?UserId="+mytable.Rows[i]["banzhu"].ToString().Trim()+"' target='_blank'><font face='宋体' color=red>"+mytable.Rows[i]["banzhu"].ToString().Trim()+"</font></A><font color=#BB865E>|</font>";
string banzhu1="";
if(mytable.Rows[i]["banzhu1"].ToString().Trim()=="")
banzhu1="";
else
banzhu1="<font color=#BB865E>|</font><A title='点击查看版主资料' href='hyziliaochakan.aspx?UserId="+mytable.Rows[i]["banzhu1"].ToString().Trim()+"' target='_blank'><font face='宋体' color=#800000>"+mytable.Rows[i]["banzhu1"].ToString().Trim()+"</font></A><font color=#BB865E>|</font>";
string banzhu2="";
if(mytable.Rows[i]["banzhu2"].ToString().Trim()=="")
banzhu2="";
else
banzhu2="<font color=#BB865E>|</font><A title='点击查看版主资料' href='hyziliaochakan.aspx?UserId="+mytable.Rows[i]["banzhu2"].ToString().Trim()+"' target='_blank'><font face='宋体' color=#800000>"+mytable.Rows[i]["banzhu2"].ToString().Trim()+"</font></A><font color=#BB865E>|</font>";
string banzhu3="";
if(mytable.Rows[i]["banzhu3"].ToString().Trim()=="")
banzhu3="";
else
banzhu3="<font color=#BB865E>|</font><A title='点击查看版主资料' href='hyziliaochakan.aspx?UserId="+mytable.Rows[i]["banzhu3"].ToString().Trim()+"' target='_blank'><font face='宋体' color=#800000>"+mytable.Rows[i]["banzhu3"].ToString().Trim()+"</font></A><font color=#BB865E>|</font>";
string banzhu4="";
if(mytable.Rows[i]["banzhu4"].ToString().Trim()=="")
banzhu4="";
else
banzhu4="<font color=#BB865E>|</font><A title='点击查看版主资料' href='hyziliaochakan.aspx?UserId="+mytable.Rows[i]["banzhu4"].ToString().Trim()+"' target='_blank'><font face='宋体' color=#800000>"+mytable.Rows[i]["banzhu4"].ToString().Trim()+"</font></A><font color=#BB865E>|</font>";
string lujing="";
mycomm=new SqlCommand("SELECT COUNT(huifu_id) FROM huifu,posts WHERE ( "+
"posts.postid=huifu.post_id and posts.ancestor_id="+mytable.Rows[i]["ancestor_id"]+" and huifu.shijian>='"+DateTime.Now.ToString("yyyy-MM-dd")+"')",myconn);
read=mycomm.ExecuteReader();
if(read.Read())
{
if(read.GetInt32(0)>0)
{
lujing="<IMG alt='有新的帖子' src='./images/forum_isnews.gif'>";
read.Close();
}
else
{
read.Close();
mycomm=new SqlCommand("SELECT COUNT(postid) FROM posts WHERE ( "+
"ancestor_id="+mytable.Rows[i]["ancestor_id"]+" and shijian>='"+DateTime.Now.ToString("yyyy-MM-dd")+"')",myconn);
read=mycomm.ExecuteReader();
if(read.Read())
{
if(read.GetInt32(0)>0)
{
lujing="<IMG alt='有新的帖子' src='./images/forum_isnews.gif'>";
read.Close();
}
else
{
lujing="<font face='宋体'><IMG alt='没有新的帖子' src='./images/forum_nonews.gif'></font>";
read.Close();
}
}
else
{
lujing="<IMG alt='没有新的帖子' src='./images/forum_nonews.gif'>";
reader.Close();
}
}
}
else
{
lujing="<IMG alt='没有新的帖子' src='./images/forum_nonews.gif'>";
reader.Close();
}
if(mytable.Rows[i]["islock"].ToString()=="1")
lujing="<IMG alt='被锁定的论坛' src='./images/forum_lock.gif'>";
myrow=new HtmlTableRow();
//cell1
mycell=new HtmlTableCell();
mycell.Controls.Add(new LiteralControl ("<TABLE class=tableBorder1 cellSpacing='1' cellPadding='0' width='760' align='center' border='0'>"+
"<TR>"+
"<TD class='tablebody1' width=60px style='WIDTH: 60px' height='90' rowSpan='2' align='center' valign='middle'>"+
"<P>"+lujing+"</P>"+
"</TD>"+
"<TD class='tableBody1' rowSpan='1' height='70'>"+
"<TABLE id='Table3' cellSpacing='0' cellPadding='0' width='100%' border='0'>"+
"<TR><td width='380'>〖<A href='zhuti.aspx?ancestor_id="+mytable.Rows[i]["ancestor_id"]+"&Page=1'><FONT color='blue'>"+mytable.Rows[i]["neirong"]+"</FONT></FONT></A>〗<br>"+
" <A title="+mytable.Rows[i]["neirong"]+" href='zhuti.aspx?ancestor_id="+mytable.Rows[i]["ancestor_id"]+"&Page=1'><IMG src='./images/Forum_readme.gif' border='0'></A> "+
" "+mytable.Rows[i]["shuoming"]+""+
" </TD>"+
"<td width=80 ><A href='zhuti.aspx?ancestor_id="+mytable.Rows[i]["ancestor_id"]+"&Page=1' title='"+mytable.Rows[i]["shuoming"]+"'><IMG width='65' height='65' border=0 src='"+mytable.Rows[i]["face"]+"'></a></td> "+
"<TD class='tableBody1' width=240 height='60'>"+
"<FONT face='宋体'>主题："+zhuti+"</FONT><br>"+
"<FONT face='宋体'>作者："+name+"</FONT><br>"+
"<FONT face='宋体'>日期："+time+"</FONT>"+
"</TR></table>"+
"</td></TR>"+
"<TR><td><TABLE id='Table3' cellSpacing='0' cellPadding='0' width='100%' border='0'>"+
"<tr> <TD class='tablebody2' height='20'>版主："+banzhu+" "+banzhu1+" "+banzhu2+" "+banzhu3+" "+banzhu4+""+
" </TD>"+
" <TD class='tablebody2' width='240' height='20'><FONT face='宋体' color=#000000><b>Today：</b><font color=red>"+today+"</font></FONT> <FONT face='宋体'><FONT face='宋体' color=#000000><b>Topics：</b></font>"+top+"</FONT> <FONT face='宋体'><FONT face='宋体' color=#000000><b>Posts：</b></font>"+huifu+"</FONT></TD></tr></table></td>"+
"</TR>"+
"</TABLE> <table cellSpacing='0' cellPadding='0' border='0'><tr><td height=1></td></tr></table>"));
myrow.Cells.Add(mycell);
if(Convert.ToInt32(mytable.Rows[i]["ancestor_id"])<10)
table.Rows.Add(myrow);
else if( Convert.ToInt32(mytable.Rows[i]["ancestor_id"])<20)
Table111.Rows.Add(myrow);
else if( Convert.ToInt32(mytable.Rows[i]["ancestor_id"])<30)
Table112.Rows.Add(myrow);
else
Table113.Rows.Add(myrow);
}
}
myconn.Close();
}
protected void Button1_Click(object sender, System.EventArgs e)
{
if(xingming.Value.Trim()==""||password.Value.Trim()=="")
{
Response.Redirect("error.aspx");
}
else
{
string sql="select* from huiyuan where yonghuming=@name and mima=@mima";
mycomm= new SqlCommand(sql,myconn);
mycomm.Parameters.Add(new SqlParameter("@name", SqlDbType.Char, 20));
mycomm.Parameters["@name"].Value =xingming.Value.Trim();
mycomm.Parameters.Add(new SqlParameter("@mima", SqlDbType.Char, 20));
mycomm.Parameters["@mima"].Value =password.Value.Trim();
myconn.Open();
SqlDataReader dr;
dr=mycomm.ExecuteReader();
if(dr.Read())
{
Response.Cookies["free_huiyuan"].Value=xingming.Value.ToString().Trim();
dr.Close();
myconn.Close();
myconn.Open();
mycomm=new SqlCommand("update huiyuan set lastlogin='"+DateTime.Now+"'where yonghuming='"+xingming.Value.Trim()+"'",myconn);
mycomm.ExecuteNonQuery();
Response.Redirect("default.aspx");
}
else
{
dr.Close();
Response.Redirect("error.aspx");
}
myconn.Close();
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -