📄 st_edit.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace ST_GROUP.Blog
{
/// <summary>
/// ST_edit 的摘要说明。
/// </summary>
public partial class ST_edit : System.Web.UI.Page
{
OleDbConnection ST_myConn;
public string ST_n_content;
protected void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string ST_dns = ConfigurationSettings.AppSettings["conn"];
ST_myConn = new OleDbConnection(ST_dns);
if (Request.QueryString["id"]==null || Request.QueryString["id"]=="")
{
Response.Write("<script>alert('参数不能为空');</script>");
Response.End();
}
string ST_action;
if (Request.QueryString["action"]!=null)
{
ST_action = Request.QueryString["action"].ToString();
}
else
{
ST_action="edit";
}
switch (ST_action)
{
case "edit":
this.ST_Edit_Article();
break;
case "cedit":
this.ST_C_Edit();
break;
case "saveedit":
this.ST_Save_Edit();
break;
case "savecedit":
this.ST_Save_C_Edit();
break;
case "cmd":
this.ST_Cmd();
break;
case "nocmd":
this.ST_No_Cmd();
break;
case "cdel":
this.ST_Del_Class();
break;
case "delre":
this.ST_Del_Re();
break;
case "dellink":
this.ST_Del_Link();
break;
case "delmsg":
this.ST_Del_Msg();
break;
case "hfmsg":
this.ST_Hf_Msg();
break;
case "shfmsg":
this.ST_Shf_Msg();
break;
default:
this.ST_Del_Article();
break;
}
Page.DataBind();
}
public void ST_Edit_Article()
{
OleDbCommand ST_myCmd = new OleDbCommand("select * from ST_news where ST_n_id="+ Request.QueryString["id"] +"",ST_myConn);
OleDbCommand ST_listCmd = new OleDbCommand("select * from ST_class",ST_myConn);
ST_myConn.Open();
OleDbDataReader ST_read = ST_myCmd.ExecuteReader();
//OleDbDataReader listread = listCmd.ExecuteReader();
if (ST_read.Read())
{
string n_title = ST_read["ST_n_title"].ToString();
string n_author = ST_read["ST_n_author"].ToString();
string c_id = ST_read["ST_c_id"].ToString();
string n_key = ST_read["ST_n_key"].ToString();
ST_n_content =ST_read["ST_n_content"].ToString();
string n_iscmd = ST_read["ST_n_iscmd"].ToString();
ST_read.Close();
Response.Write("<table width=98% border=0 align=center cellpadding=0 cellspacing=1 bgcolor=#f9f8f4>");
Response.Write("<form action=ST_edit.aspx?action=saveedit&id="+ Request.QueryString["id"] +" method=post name=form1>");
Response.Write(" <TBODY>");
Response.Write(" <tr bgcolor=#ffffff>");
Response.Write(" <td height=20 colspan=2>");
Response.Write(" <div align=center class=article>修改文章</div>");
Response.Write(" </td>");
Response.Write(" </tr>");
Response.Write(" <tr bgcolor=#ffffff>");
Response.Write(" <td width=204 height=20><div align=center>标题：</div>");
Response.Write(" </td>");
Response.Write(" <td width=553 height=20> <INPUT type=text id=n_title name=n_title value='"+ n_title +"'></td>");
Response.Write(" </tr>");
Response.Write(" <tr bgcolor=#ffffff>");
Response.Write(" <td height=20><div align=center>作者：</div>");
Response.Write(" </td>");
Response.Write(" <td height=20> <INPUT type=text id=n_author name=n_author value='"+ n_author +"'></td>");
Response.Write(" </tr>");
Response.Write(" <tr bgcolor=#ffffff>");
Response.Write(" <td height=20>");
Response.Write(" <div align=center>类别：</div>");
Response.Write(" </td>");
Response.Write(" <td height=9> ");
this.ST_getList(c_id);
Response.Write(" </td>");
Response.Write(" </tr>");
Response.Write(" <tr bgcolor=#ffffff>");
Response.Write(" <td height=20>");
Response.Write(" <div align=center>摘要：</div>");
Response.Write(" </td>");
Response.Write(" <td height=10> <TEXTAREA id=n_key name=n_key rows=4 cols=40>"+ n_key +"</TEXTAREA></td>");
Response.Write(" </tr>");
Response.Write(" <tr bgcolor=#ffffff>");
Response.Write(" <td height=20><div align=center>内容：</div>");
Response.Write(" </td>");
Response.Write(" <td height=20> <TEXTAREA id=n_content name=n_content rows=10 cols=40>"+ ST_n_content +"</TEXTAREA></td>");
Response.Write(" </td>");
Response.Write(" </tr>");
Response.Write(" <tr bgcolor=#ffffff>");
Response.Write(" <td height=20><div align=center>选项：</div>");
Response.Write(" </td>");
Response.Write(" <td height=20>推荐 <input name=n_iscmd type=checkbox id=n_iscmd value=1");
if (n_iscmd=="1")
{
Response.Write(" checked>");
}
else
{
Response.Write(">");
}
Response.Write(" </td>");
Response.Write(" </tr>");
Response.Write(" <tr bgcolor=#ffffff>");
Response.Write(" <td height=20 colspan=2><div align=center>");
Response.Write(" <INPUT type=submit value=修改><FONT face=宋体> </FONT> <INPUT type=reset value=重写></div>");
Response.Write(" </td>");
Response.Write(" </tr>");
Response.Write(" </TBODY>");
Response.Write(" </form>");
ST_myConn.Close();
}
}
public void ST_C_Edit()
{
OleDbCommand ST_myCmd = new OleDbCommand("select * from ST_class where ST_c_id="+ Request.QueryString["id"] +"",ST_myConn);
ST_myConn.Open();
OleDbDataReader ST_read = ST_myCmd.ExecuteReader();
if (ST_read.Read())
{
Response.Write("<br>");
Response.Write("<br>");
Response.Write("<br>");
Response.Write("<table align=center>");
Response.Write("<form action=ST_edit.aspx?action=savecedit&id="+ Request.QueryString["id"] +" method=post>");
Response.Write("<tr><td>名称:</td>");
Response.Write("<td><input name=c_name type=text value='"+ ST_read["ST_c_name"].ToString() +"'></td>");
Response.Write("</tr><tr><td><input type=submit value=修改></td>");
Response.Write("</tr></form>");
Response.Write("</table>");
}
ST_myConn.Close();
}
public void ST_Save_C_Edit()
{
string ST_c_name = ST_HtmlEncode(Request.Form["c_name"]);
string ST_sql = "update ST_class set ST_c_name='"+ ST_c_name +"' where ST_c_id="+ Request.QueryString["id"] +"";
OleDbCommand ST_myCmd = new OleDbCommand(ST_sql,ST_myConn);
ST_myConn.Open();
ST_myCmd.ExecuteNonQuery();
ST_myConn.Close();
Response.Redirect("ST_type.aspx");
}
public void ST_Save_Edit()
{
string ST_n_title = ST_HtmlEncode(Request.Form["n_title"]);
string ST_n_author = ST_HtmlEncode(Request.Form["n_author"]);
string ST_n_key = ST_HtmlEncode(Request.Form["n_key"]);
string ST_n_content = ST_HtmlEncode(Request.Form["n_content"]);
int ST_cmd;
if (Request.Form["n_iscmd"]!=null)
{
ST_cmd=1;
}
else
{
ST_cmd=0;
}
string ST_sql = "update ST_news set ST_n_title='"+ ST_n_title +"',ST_n_author='"+ ST_n_author +"',ST_n_key='"+ ST_n_key +"',ST_n_content='"+ ST_n_content +"',ST_c_id="+ Request.Form["listtype"] +",ST_n_iscmd="+ ST_cmd +" where ST_n_id="+ Request.QueryString["id"] +"";
OleDbCommand ST_myCmd = new OleDbCommand(ST_sql,ST_myConn);
ST_myConn.Open();
ST_myCmd.ExecuteNonQuery();
ST_myConn.Close();
Response.Redirect("ST_main.aspx");
}
public void ST_Cmd()
{
Response.Write("推荐");
}
public void ST_No_Cmd()
{
Response.Write("取消推荐");
}
public void ST_Del_Article()
{
string ST_sql = "delete from ST_news where ST_n_id in ("+ Request.QueryString["id"] +")";
OleDbCommand ST_myCmd = new OleDbCommand(ST_sql,ST_myConn);
ST_myConn.Open();
ST_myCmd.ExecuteNonQuery();
ST_myConn.Close();
Response.Redirect("ST_main.aspx");
}
public void ST_Del_Class()
{
string ST_sql = "delete from ST_class where ST_c_id in ("+ Request.QueryString["id"] +")";
OleDbCommand ST_myCmd = new OleDbCommand(ST_sql,ST_myConn);
ST_myConn.Open();
ST_myCmd.ExecuteNonQuery();
ST_myConn.Close();
Response.Redirect("ST_type.aspx");
}
public void ST_Del_Re()
{
string ST_sql = "delete from ST_replay where ST_r_id in ("+ Request.QueryString["id"] +")";
OleDbCommand ST_myCmd = new OleDbCommand(ST_sql,ST_myConn);
//评论减一
OleDbCommand ST_reCmd = new OleDbCommand("update ST_news set ST_n_re=ST_n_re-1 where ST_n_id=" +Request.QueryString["nid"]+ "",ST_myConn);
ST_myConn.Open();
ST_myCmd.ExecuteNonQuery();
ST_reCmd.ExecuteNonQuery();
ST_myConn.Close();
Response.Redirect("ST_admin_replay.aspx");
}
public void ST_Del_Link()
{
string ST_sql = "delete from ST_link where ST_l_id in ("+ Request.QueryString["id"] +")";
OleDbCommand ST_myCmd = new OleDbCommand(ST_sql,ST_myConn);
ST_myConn.Open();
ST_myCmd.ExecuteNonQuery();
ST_myConn.Close();
Response.Redirect("ST_admin_link.aspx");
}
public void ST_Del_Msg()
{
string ST_sql = "delete from ST_message where ST_id in ("+ Request.QueryString["id"] +")";
OleDbCommand ST_myCmd = new OleDbCommand(ST_sql,ST_myConn);
ST_myConn.Open();
ST_myCmd.ExecuteNonQuery();
ST_myConn.Close();
Response.Redirect("ST_admin_message.aspx");
}
public void ST_Hf_Msg()
{
Response.Write("<form method=post action='ST_edit.aspx?action=shfmsg&id="+Request.QueryString["id"]+"'>");
Response.Write("<TEXTAREA id=content name=content rows=6 cols=40></TEXTAREA>");
Response.Write("<input type=submit name=Button1 value=回复 id=Button1 />");
Response.Write("</form>");
Response.End();
}
public void ST_Shf_Msg()
{
string ST_sql = "update ST_message set ST_hf='"+Request.Form["content"]+"' where ST_id = "+ Request.QueryString["id"] +"";
//Response.Write (sql);
OleDbCommand ST_myCmd = new OleDbCommand(ST_sql,ST_myConn);
ST_myConn.Open();
ST_myCmd.ExecuteNonQuery();
ST_myConn.Close();
Response.Redirect("ST_admin_message.aspx");
}
public void ST_getList(string id)
{
Response.Write ("<select name='listtype'>");
OleDbCommand ST_listCmd = new OleDbCommand("select * from ST_class",ST_myConn);
OleDbDataReader ST_read = ST_listCmd.ExecuteReader();
while (ST_read.Read())
{
Response.Write ("<option value="+ST_read[0].ToString()+"");
if (id==ST_read[0].ToString())
{
Response.Write(" selected ");
}
Response.Write(">"+ST_read[1].ToString()+"</option>");
}
Response.Write ("</select>");
}
private string ST_HtmlEncode(string str)
{
str = str.Replace(">",">");
str = str.Replace("<","<");
char ch;
ch = (char)32;
str = str.Replace(ch.ToString()," ");
ch = (char)34;
str = str.Replace(ch.ToString(),""");
ch = (char)39;
str = str.Replace(ch.ToString(),"'");
ch = (char)13;
str = str.Replace(ch.ToString()," ");
ch = (char)10;
str = str.Replace(ch.ToString(),"<br>");
return str;
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -