📄 mode.aspx
字号:
RightGifHtml = RightGifHtml + "</tr></table>";
return RightGifHtml;
}
//******************
//** 获取留言列表 **
//******************
public string GetMsgList()
{
//---------
//分页程序
//---------
string imgWidth = "285";
string imgHeight = "400";
int recordPerPage = g_rPerPage;//定义每页显示记录数
int nPageCount;//定义总页数
int nRecCount;//定义总记录数
int nPage;//定义当前页
nPage = Convert.ToInt32(Request["page"]);
//连接数据库
string StrSql = "Select * From Book order by id desc";
OleDbConnection MyConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(g_StrConn));
try
{
string MsgListTop = "";
string MsgListMiddle = "";
string MsgListBottom = "";
MsgListTop = MsgListTop + "<table style='width:450' border='0' cellspacing='0' cellpadding='0'>";
MsgListTop = MsgListTop + "<tr><td style=' height:40px' align='center' valign='top'><a id='mainFormTop'></a><img src='skins/" + g_Skin + "/show.gif' /></td></tr>";
MsgListTop = MsgListTop + "</table>";
MyConn.Open();
OleDbDataAdapter odAdapt = new OleDbDataAdapter(StrSql, MyConn);
DataSet DS = new DataSet();
odAdapt.Fill(DS);
DataTable DT = DS.Tables[0];
//获得总记录数
nRecCount = DT.Rows.Count;
//判断是否存在数据记录
if (nRecCount < 0)
{
return clsFct.errorMsg("暂时没有任何人留言！");
}
//确定数据记录要显示的页面数
nPageCount=nRecCount/recordPerPage;
if(nRecCount % recordPerPage > 0)
{
nPageCount ++;
}
if(nPage < 1)
{
nPage = 1;
}
if(nPage > nPageCount)
{
nPage = nPageCount;
}
//将页数显示到屏幕上，并作Ajax链接
MsgListBottom = MsgListBottom + "<table align='center'><tr><td>";
if (nPage < 2)
{
MsgListBottom = MsgListBottom + "<span class=font_12>首页 | 上一页 |</span> ";
}
else
{
MsgListBottom = MsgListBottom + "<span style='cursor:hand' onclick=addHash('msgList1'); class=font_13>首页</span><span class=font_12> | </span>";
MsgListBottom = MsgListBottom + "<span style='cursor:hand' onclick=addHash('msgList" + (nPage - 1) + "'); class=font_13>上一页</span><span class=font_12> | </span>";
}
if (nPageCount - nPage < 1)
{
MsgListBottom = MsgListBottom + "<span class=font_12>下一页 | 尾页 </span>";
}
else
{
MsgListBottom = MsgListBottom + "<span style='cursor:hand' onclick=addHash('msgList" + (nPage + 1) + "'); class=font_13>下一页</span><span class=font_12> | </span>";
MsgListBottom = MsgListBottom + "<span style='cursor:hand' onclick=addHash('msgList" + nPageCount + "'); class=font_13>尾页 </span>";
}
MsgListBottom = MsgListBottom + "<span class=font_12> 共" + nPageCount + "页 第" + nPage + "页 " + recordPerPage + "条/页</span>";
MsgListBottom = MsgListBottom + " <span class=font_12>Goto</span> <input type='text' name='likePage' size=2 maxlength=10 value=" + nPage + ">";
MsgListBottom = MsgListBottom + " <span class=font_12>页</span> ";
MsgListBottom = MsgListBottom + "<input type=button onclick=addHash('msgList'+likePage.value); value=GO!></td></tr></table>";
//确认当前页面的开始记录和终止记录
int nStart = recordPerPage * (nPage - 1);
int nEnd = nStart + recordPerPage - 1;
if(nEnd > nRecCount - 1)
nEnd = nRecCount - 1;
//在屏幕中输出记录
for(int i=nStart;i<=nEnd;i++)
{
MsgListMiddle = MsgListMiddle + "<form name='form" + DT.Rows[i]["id"].ToString().Trim() + "'><table style=' height:195px; width:425px; background-image:url(skins/" + g_Skin + "/showbj.gif); border-style:dashed; border-width:1px; border-color:Aqua;' cellpadding='0' cellspacing='0'>";
MsgListMiddle = MsgListMiddle + "<tr><td style=' height:0px; width:110px' align='center' valign='middle'>";
MsgListMiddle = MsgListMiddle + "<table style=' height:120px; width:145px' border='0' cellpadding='0' cellspacing='0'>";
MsgListMiddle = MsgListMiddle + "<tr><td style=' height:140px; width: 145px;' align='center' valign='bottom'><img alt='' src='FaceOrEmt/Face" + g_Face + "/" + DT.Rows[i]["Face"].ToString().Trim() + "'></td></tr>";
MsgListMiddle = MsgListMiddle + "<tr><td style=' height:20px; width: 145px;' align='center' class='font_13'><span class='font_12'>[" + DT.Rows[i]["name"].ToString().Trim() + "]</span><br />" + clsFct.DisContact(DT.Rows[i]["QQ"].ToString().Trim(), DT.Rows[i]["Email"].ToString().Trim(), DT.Rows[i]["Http"].ToString().Trim()) + "</td></tr>";
MsgListMiddle = MsgListMiddle + "<tr><td style=' height:20px; width: 145px;' align='center'>";
if (Convert.ToString(Session["Admin"]).CompareTo("True") == 0)
{
MsgListMiddle = MsgListMiddle + "<span style='cursor:hand' class='font_13' onclick=postdata('正在加载回复表单,请稍等....','Mode.aspx?Mode=GetReply&id=" + DT.Rows[i]["id"].ToString().Trim() + "','aReply" + DT.Rows[i]["id"].ToString().Trim() + "'); >回复</span> ";
MsgListMiddle = MsgListMiddle + "<span style='cursor:hand' class='font_13' onclick=postdata('正在加载主题修改表单,请稍等....','Mode.aspx?Mode=GetHeadEdit&id=" + DT.Rows[i]["id"].ToString().Trim() + "','aHead" + DT.Rows[i]["id"].ToString().Trim() + "');postdata('正在加载内容修改表单,请稍等....','Mode.aspx?Mode=GetContentEdit&id=" + DT.Rows[i]["id"].ToString().Trim() + "','aContent" + DT.Rows[i]["id"].ToString().Trim() + "'); >修改</span> ";
MsgListMiddle = MsgListMiddle + "<span style='cursor:hand' class='font_13' onclick=if(confirm('你确定要删除吗?')){postdata('正在删除留言,请稍等....','Mode.aspx?Mode=delMsg&id=" + DT.Rows[i]["id"].ToString().Trim() + "','mainForm');} >删除</span>";
}
MsgListMiddle = MsgListMiddle + "</td></tr>";
MsgListMiddle = MsgListMiddle + "</table></td>";
MsgListMiddle = MsgListMiddle + "<td style=' width:340px' align='center' valign='top'>";
MsgListMiddle = MsgListMiddle + "<table style=' height:208px; width:320px' border='0' cellpadding='0' cellspacing='0'>";
MsgListMiddle = MsgListMiddle + "<tr><td style=' height:15px' align='right' class='font_12'><span class='font_13'>" + DT.Rows[i]["msgTime"].ToString().Trim() + "</span></td></tr>";
MsgListMiddle = MsgListMiddle + "<tr><td style=' height:25px' class='font_12'><span class='font_12'><--<a id='aHead" + DT.Rows[i]["id"].ToString().Trim() + "'>" + clsFct.Keep(clsFct.FilterBadWords(DT.Rows[i]["head"].ToString().Trim(),g_leachGutterLag), 0) + "</a>--></span></td></tr>";
MsgListMiddle = MsgListMiddle + "<tr><td style=' height:138px;word-break:break-all' align='left' valign='middle'>";
MsgListMiddle = MsgListMiddle + "<table style=' height:126px; width:305px' border='0' cellpadding='0' cellspacing='0'>";
MsgListMiddle = MsgListMiddle + "<tr><td align='left' valign='middle' style='height: 163px'><div id='divContent'> ";
if (DT.Rows[i]["type"].ToString().Trim().CompareTo("2") == 0)
{
MsgListMiddle = MsgListMiddle + "<a class='fonta_12' id='aContent" + DT.Rows[i]["id"].ToString().Trim() + "'>" + clsFct.ubb(clsFct.Keep(DT.Rows[i]["content"].ToString().Trim(), 0), imgWidth, imgHeight, g_Emote) + "</a>";
}
else if (DT.Rows[i]["type"].ToString().Trim().CompareTo("1") == 0)
{
if (Convert.ToString(Session["Admin"]).CompareTo("True") == 0)
{
MsgListMiddle = MsgListMiddle + "<a class='font_13' id='aContent" + DT.Rows[i]["id"].ToString().Trim() + "'>" + clsFct.ubb(clsFct.Keep(clsFct.FilterBadWords(DT.Rows[i]["content"].ToString().Trim(),g_leachGutterLag), 0), imgWidth, imgHeight, g_Emote) + "</a>";
}
else
{
MsgListMiddle = MsgListMiddle + "<a class='font_13' id='aContent" + DT.Rows[i]["id"].ToString().Trim() + "'>以下是 " + DT.Rows[i]["name"].ToString().Trim() + " 写给管理员的悄悄话。<hr><br/> 你没有权限阅读！</a>";
}
}
else
{
MsgListMiddle = MsgListMiddle + "<a class='fontb_12' id='aContent" + DT.Rows[i]["id"].ToString().Trim() + "'>" + clsFct.ubb(clsFct.Keep(clsFct.FilterBadWords(DT.Rows[i]["content"].ToString().Trim(), g_leachGutterLag), 0), imgWidth, imgHeight, g_Emote) + "</a>";
}
MsgListMiddle = MsgListMiddle + "</div></td></tr>";
MsgListMiddle = MsgListMiddle + "</table></td></tr>";
MsgListMiddle = MsgListMiddle + "<tr><td style=' height:25px' align='left' valign='middle' class='font_12'>管理员回复：<span class='font_13'><a id='aReply" + DT.Rows[i]["id"].ToString().Trim() + "'>" + clsFct.Keep(DT.Rows[i]["reply"].ToString().Trim(), 0) + "</a></span></td></tr>";
MsgListMiddle = MsgListMiddle + "</table></td></tr>";
MsgListMiddle = MsgListMiddle + "</table></form>";
}
string MsgListHtml = MsgListTop + MsgListMiddle + MsgListBottom;
MyConn.Close();
return MsgListHtml;
}
catch
{
return clsFct.errorMsg("数据库连接失败,请重试!");
}
}
//**********************
//** 获取新增留言表单 **
//**********************
public string GetAddMsg()
{
string AddMsgHtml = "";
AddMsgHtml = AddMsgHtml + "<table width='470' height='353' border='0' cellpadding='0' cellspacing='0'>";
AddMsgHtml = AddMsgHtml + "<form name='form'>";
AddMsgHtml = AddMsgHtml + "<tr><td height='30' colspan='2' align='center'><a id='mainFormTop'></a><img src='skins/" + g_Skin + "/write.gif' width='89' height='37'>";
if (g_stop == 1 && Convert.ToString(Session["Admin"]).CompareTo("True") != 0)
{
AddMsgHtml = AddMsgHtml + "<br /><span style=' font-size:14px; color:Red;'>--------------------------------<br/>| 警告，管理员已经禁止用户留言！|<br/>--------------------------------</span>";
}
AddMsgHtml = AddMsgHtml + "</td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='15' colspan='2' align='right' class='font_12'>*内容为必填项 </td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td width='115' height='25' align='center' class='font_12'>* 留言人：</td><td width='385' align='left'><input id='msgName' type='text' class='form'";
if (Convert.ToString(Session["Admin"]).CompareTo("True")==0)
{
AddMsgHtml = AddMsgHtml + "value=管理员";
}
AddMsgHtml = AddMsgHtml + " size='15' maxlength='30' onblur=if(checkSpace('msgName')){showHint('hintName','R')}else{showHint('hintName','W')} /> <b id='hintName' style=' font-size:14px; color:Red;'></b></td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='25' align='center' class='font_12'>* 性别：<br></td><td align='left'><input name='MsgPersonSex' value='男' type='radio' checked='checked' onclick='SelectFaceSex();' /> <span class='font_12'>男</span> <input name='MsgPersonSex' value='女' type='radio' onclick='SelectFaceSex();' /> <span class='font_12'>女</span></td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='25' align='center' class='font_12'>* 头像：</td><td align='left'>";
AddMsgHtml = AddMsgHtml + "<table width='200' border='0' cellspacing='0' cellpadding='0'>";
AddMsgHtml = AddMsgHtml + "<tr><td width='80'><select name='MsgPersonFace'></select></td>";
AddMsgHtml = AddMsgHtml + "<td width='100'><span style='cursor:hand' onclick='ShowFaceList();' class='font_13'>[头像列表]</span></td>";
AddMsgHtml = AddMsgHtml + "</tr></table>";
AddMsgHtml = AddMsgHtml + "</td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='25' align='center' class='font_12'>QQ:</td><td align='left'><input type='text' id='msgQQ' size='25' maxlength='15' onblur=if(checkNum('msgQQ')){showHint('hintQQ','R')}else{showHint('hintQQ','W')} /> <b id='hintQQ' style='font-size:14px; color:Red;'></b></td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='25' align='center' class='font_12'>E-Mail:</td><td align='left'><input id='msgEmail' type='text' size='25' maxlength='50' onblur=if(checkEmail('msgEmail')){showHint('hintEmail','R')}else{showHint('hintEmail','W')} /> <b id='hintEmail' style='font-size:14px; color:Red;'></b></td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='25' align='center' class='font_12'>主页：</td><td align='left'><input type='text' id='msgHttp' size='25' maxlength='80' value='http://' onblur=if(checkUrl('msgHttp')){showHint('hintHttp','R')}else{showHint('hintHttp','W')} /><span class='font_12'> <b id='hintHttp' style='font-size:14px; color:Red;'></b></span></td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='25' align='center' class='font_12'>* 类型：<br></td><td align='left'><input name='msgType' value='0' type='radio' checked='checked' /> <span class='font_12'>普通</span> ";
if (Convert.ToString(Session["Admin"]).CompareTo("True") == 0)
{
AddMsgHtml = AddMsgHtml + "<input name='msgType' value='2' type='radio' /> <span class='font_12'>管理员</span>";
}
else
{
AddMsgHtml = AddMsgHtml + "<input name='msgType' value='1' type='radio' /> <span class='font_12'>悄悄话</span>";
}
AddMsgHtml = AddMsgHtml + "</td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='25' align='center' class='font_12'>* 主题：<br></td><td align='left'><input id='msgHead' type='text' size='40' maxlength='28' onblur=if(checkSpace('msgHead')){showHint('hintHead','R')}else{showHint('hintHead','W')} /> <b id='hintHead' style='font-size:14px; color:Red;'></b></td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='30' colspan='2' align='center' class='font_12'> 字限：<span id='total'>" + g_contentMaxLen + "</span> 已写：<span id='used'>0</span> 剩余：<span id='remain'>" + g_contentMaxLen + "</span> <span style='cursor:hand' onClick='if(msgContent.rows<60)msgContent.rows=msgContent.rows+5;' title=扩大编缉区>编辑区扩展 [+]</span><span style='cursor:hand' onClick='if(msgContent.rows>5)msgContent.rows=msgContent.rows-5;' title=缩小编缉区>[-]</span><span style='cursor:hand' onClick='msgContent.rows=10;' title=恢复编缉区>[=]</span> </td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td align='center' class='font_12'>* 内容：<br><br><br><span style='cursor:hand' class='font_13' onClick='image()'>插入图片</span><br><br><span style='cursor:hand' class='font_13' onClick='showEmtList()'>插入表情</span></td><td align='left'><textarea id='msgContent' cols='48' rows='10' onkeyup=gbcount(); onblur=if(checkSpace('msgContent')){showHint('hintContent','R')}else{showHint('hintContent','W')} ></textarea> <b id='hintContent' style='font-size:14px; color:Red;'></b></td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td height='30' colspan='2' align='center' class='font_12'>";
AddMsgHtml = AddMsgHtml + "<table id='emtList' style='display:none;' width='280' height='30' border='0' cellpadding='0' cellspacing='0'>";
AddMsgHtml = AddMsgHtml + "<tr><td align='right'>";
string tempStr="";
for (int i = 1; i <= 14; i++)
{
tempStr = tempStr + "<A href=javascript:emoticon('[表情" + i + "]')><img border=0 alt=插入表情符 height=28 width=28 src=FaceOrEmt/Emote" + g_Emote + "/em" + i + ".gif> ";
if (i == 7)
{
tempStr = tempStr + "<br />";
}
}
AddMsgHtml = AddMsgHtml + tempStr;
AddMsgHtml = AddMsgHtml + "</td></tr></table></td></tr>";
AddMsgHtml = AddMsgHtml + "<tr><td align='center'> </td><td align='left'><br/> <input type='button' onclick='postNewMsg();' value=' OK！ ' /> <input type='reset' value=' 重置 ' /></td></tr>";
AddMsgHtml = AddMsgHtml + "</form>";
AddMsgHtml = AddMsgHtml + "</table>";
return AddMsgHtml;
}
//************************
//** 获取管理员登陆表单 **
//************************
public string GetAdminLogin()
{
string AdminLoginHtml = "";
AdminLoginHtml = AdminLoginHtml + " <br><br><br><br><br>";
AdminLoginHtml = AdminLoginHtml + " <table width='470' height='150' border='0' cellpadding='0' cellspacing='0'>";
AdminLoginHtml = AdminLoginHtml + " <form name='form'>";
AdminLoginHtml = AdminLoginHtml + " <tr><td colspan='2' align='center' valign='middle'><span class='font_14'>管理员登陆 </span></td></tr>";
AdminLoginHtml = AdminLoginHtml + " <tr><td width='161' align='right' valign='middle'><span class='font_12'><b>I D </b>：</span></td><td align='left'><input name='adminID' type='text' maxlength='20' onblur=if(checkSpace('adminID')){showHint('hintAdminID','R')}else{showHint('hintAdminID','W')} /> <b id='hintAdminID' style=' font-size:14px; color:Red;'></b></td></tr>";
AdminLoginHtml = AdminLoginHtml + " <tr><td width='161' align='right' valign='middle'><span class='font_12'>密 码：</span></td><td align='left'><input name='password' type='password' maxlength='20' onblur=if(checkSpace('password')){showHint('hintPassword','R')}else{showHint('hintPassword','W')} /> <b id='hintPassword' style=' font-size:14px; color:Red;'></b></td></tr>";
AdminLoginHtml = AdminLoginHtml + " <tr><td width='161' align='right' valign='middle'><span class='font_12'>验证码：</span></td><td align='left'><input name='validate' type='text' size='4' maxlength='20' onblur=if(checkSpace('validate')){showHint('hintValidate','R')}else{showHint('hintValidate','W')} /> <img id='validateImg' src='validate.aspx' width='60' height='20' /> <b id='hintValidate' style=' font-size:14px; color:Red;'></b></td></tr>";
AdminLoginHtml = AdminLoginHtml + " <tr><td colspan='2' align='center' valign='middle'><input type='button' onclick='postAdminLogin()' value='登陆' /> <input type='reset' value='重置' /> </td></tr>";
AdminLoginHtml = AdminLoginHtml + " </form></table>";
return AdminLoginHtml;
}
//**********************
//** 获取主题修改表单 **
//**********************
public string GetHeadEdit()
{
string HeadEditHtml = "";
string startValue = "";
string id = Request.QueryString["id"];
if (!clsFct.IsNumber(id) || id.CompareTo("")==0)
{
return clsFct.errorMsg("警告！禁止输入非法数据。");
}
string StrSql = "Select * From book where id=" + id;
OleDbConnection MyConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(g_StrConn));
try
{
MyConn.Open();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -