📄 admin_articleadd.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;
namespace WebNews.admin
{
/// <summary>
/// admin_articleAdd 的摘要说明。
/// </summary>
public class admin_articleAdd : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label myLabel;
protected System.Web.UI.WebControls.CheckBox Headline;
protected System.Web.UI.WebControls.CheckBox HighLight;
protected System.Web.UI.HtmlControls.HtmlInputText Title;
protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator3;
protected System.Web.UI.WebControls.CustomValidator CustomValidator1;
protected System.Web.UI.HtmlControls.HtmlTextArea Summary;
protected System.Web.UI.HtmlControls.HtmlInputText Key;
protected System.Web.UI.HtmlControls.HtmlInputText Author;
protected System.Web.UI.HtmlControls.HtmlInputText Source;
protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator2;
protected System.Web.UI.WebControls.Button Submit;
protected System.Web.UI.HtmlControls.HtmlTextArea Body;
protected System.Web.UI.WebControls.Button upload;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.HtmlControls.HtmlInputFile FileUp;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.DropDownList ClassName;
public string path;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack )
{
string us=(string)Session["userclass"];
if(us.Trim()=="系统管理员"||(int)Session["addnews"]==1||(int)Session["addnchk"]==1)
{
getClass();
}
else
{
Page.Visible=false;
}
}
}
private void getClass() //根据权限设置分类
{
string da=(string)Session["userclass"] ;
string classname=(string)Session["classname"];
if(da.Trim()=="系统管理员")
{
string con=ConfigurationSettings.AppSettings["dsn"]; //取得DSN字符
SqlConnection myConnection = new SqlConnection(con);//连接字符串
myConnection.Open();
SqlDataAdapter selClassAll = new SqlDataAdapter(); //创建SqlDataAdapter 类
selClassAll.SelectCommand=new SqlCommand("sp_selFclassAll",myConnection); //调用存储过程
selClassAll.SelectCommand.CommandType=CommandType.StoredProcedure ;
DataSet ds = new DataSet();
selClassAll.Fill(ds,"ClassName");
ClassName.DataSource=ds;
ClassName.DataTextField="classname";
ClassName.DataValueField="classname";
ClassName.DataBind();
myConnection.Close();
}
else
{
ListItem d=new ListItem(classname,classname);
ClassName.Items.Add(d);
}
}
private void addhints() //增加发表文章数
{
string username=(string)Session["username"];
string conn=ConfigurationSettings.AppSettings["dsn"]; //取得DSN字符
SqlConnection con = new SqlConnection(conn);//连接字符串
con.Open();
SqlCommand cmd=new SqlCommand("sp_addNum",con); //建立命令
cmd.CommandType=CommandType.StoredProcedure;
SqlParameter name=cmd.Parameters.Add("@username",SqlDbType.Char,200); //调用并设置存储过程参数
name.Value=username.Trim();
int r=cmd.ExecuteNonQuery(); //执行命令
}
private void addClassNum()
{
string username=(string)Session["username"];
string conn=ConfigurationSettings.AppSettings["dsn"]; //取得DSN字符
SqlConnection con = new SqlConnection(conn);//连接字符串
con.Open();
SqlCommand cmd=new SqlCommand("sp_addClassNum",con); //建立命令
cmd.CommandType=CommandType.StoredProcedure;
SqlParameter name=cmd.Parameters.Add("@className",SqlDbType.Char,200); //调用并设置存储过程参数
name.Value=ClassName.SelectedItem.Text.Trim();
int r=cmd.ExecuteNonQuery();
}
private void addArticle() //发表文章
{
int hl=0;
int HL=0;
string classname=ClassName.SelectedItem.Text.Trim() ; //获得分类名
if(Headline.Checked) //获得是否是头条新闻
{
hl=1;
}
else hl=0;
if(HighLight.Checked) //获得是否新闻醒目
{
HL=1;
}
else HL=0;
string title=Title.Value.Trim(); //获得新闻标题
string content=Body.Value.Trim();//获得新闻内容
content=Server.HtmlDecode(content);
string summary=Summary.Value.Trim(); //获得新闻简介
string nk=Key.Value.Trim(); //获得相关新闻
string at=Author.Value.Trim() ; //获得作者名
string sr=Source.Value.Trim();
try
{
string conn=ConfigurationSettings.AppSettings["dsn"]; //取得DSN字符
SqlConnection con = new SqlConnection(conn);//连接字符串
con.Open();
SqlCommand cmd=new SqlCommand("sp_addArticle1".Trim(),con); //建立命令
cmd.CommandType=CommandType.StoredProcedure;
SqlParameter cl=cmd.Parameters.Add("@classname",SqlDbType.Char,200); //调用并设置存储过程参数
cl.Value =classname;
SqlParameter tl=cmd.Parameters.Add("@title",SqlDbType.NVarChar,400);
tl.Value=title;
SqlParameter cn=cmd.Parameters.Add("@content",SqlDbType.NText);
cn.Value=content;
SqlParameter hd=cmd.Parameters.Add("@headline",SqlDbType.Int );
hd.Value=hl;
SqlParameter hil=cmd.Parameters.Add("@highlight",SqlDbType.Int );
hil.Value=HL;
SqlParameter sm=cmd.Parameters.Add("@summary",SqlDbType.Char,400);
sm.Value=summary;
SqlParameter key=cmd.Parameters.Add("@Nkey",SqlDbType.Char,100);
key.Value=nk;
SqlParameter author=cmd.Parameters.Add("@writer",SqlDbType.Char,400);
author.Value=at;
SqlParameter source=cmd.Parameters.Add("@source",SqlDbType.Char,400);
source.Value=sr;
SqlParameter username=cmd.Parameters.Add("@username",SqlDbType.Char,400);
username.Value=(string)Session["username"];
SqlParameter popedom=cmd.Parameters.Add("@popedom",SqlDbType.Char,100);
popedom.Value =Session["power"];
SqlParameter checkup=cmd.Parameters.Add("@checkup",SqlDbType.Int);
string ul=(string)Session["userclass"];
if(ul.Trim()=="系统管理员")
{
checkup.Value=1;
}
else checkup.Value=(int)Session["addnchk"];
int d=cmd.ExecuteNonQuery(); //添加新闻
if(d>0)
{
myLabel.Text="添加新闻成功";
con.Close();
}
else
{
myLabel.Text="添加新闻错误";
con.Close();
}
}
catch(Exception e)
{
Response.Write("Exception in Main: " + e.Message); //出错处理
}
}
#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()
{
this.upload.Click += new System.EventHandler(this.upload_Click);
this.CustomValidator1.ServerValidate += new System.Web.UI.WebControls.ServerValidateEventHandler(this.CustomValidator1_ServerValidate);
this.Submit.Click += new System.EventHandler(this.Submit_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void CustomValidator1_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
{
if(Summary.Value.Length>200)
{
args.IsValid=false ;
}
else
args.IsValid=true;
}
private void Submit_Click(object sender, System.EventArgs e)
{ //获得来源
if(Page.IsValid)
{
addArticle();
string userclass=(string)Session["userclass"];
int i=(int)Session["addnchk"];
if(userclass.Trim()=="系统管理员"||i==1)
{
addhints();
addClassNum();
}
}
}
private void upload_Click(object sender, System.EventArgs e)
{
if(FileUp.PostedFile.ContentLength!=0)
{
if(FileUp.PostedFile.ContentType=="image/pjpeg" || FileUp.PostedFile.ContentType=="image/gif"||FileUp.PostedFile.ContentType=="image/bmp") //设置上传文件类型
{
string filename=FileUp.PostedFile.FileName; //取得文件名
int i=filename.Length;
filename=filename.Remove(0,i-4);
string s=DateTime.Now.Year.ToString()+DateTime.Now.Month.ToString()+DateTime.Now.Day.ToString()+DateTime.Now.Hour.ToString()+DateTime.Now.Minute.ToString()+DateTime.Now.Second.ToString()+DateTime.Now.Millisecond.ToString();
string d=Server.MapPath("../upfiles/")+s+filename ; //设置文件名
FileUp.PostedFile.SaveAs(d); //保存文件
Body.Value+="<img src=../upfiles/"+s+filename+">"; //更改新闻内容
Label1.Text="上传成功";
}
else Label1.Text="只能上传图形文件";
}
else Label1.Text="请选择上传文件";
}
private void Button1_Click(object sender, System.EventArgs e)
{
Session["Title"]=Title.Value;
Session["Body"]=Body.Value;
Session["Summary"]=Summary.Value;
Session["Key"]=Key.Value;
Session["Author"]=Author.Value;
Session["Source"]=Source.Value;
// Response.Redirect("admin_articlePreView.aspx",false);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -