//修改分类资讯
protected void btnChangeClass_Click(object sender, EventArgs e)
{
int newsid = Convert.ToInt32(Request.QueryString["news_id"]);
using (var db = new HuXiuEntities())
{
News news = db.News.SingleOrDefault(a => a.news_id == newsid);
News_class newsclass = db.News_class.SingleOrDefault(a => a.news_classname == dropClass.SelectedItem.ToString());
news.news_id = newsclass.news_classid;
db.SaveChanges();
Response.Write("<script>alert('修改成功！');location='News_Delete.aspx'</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Write("<script>alert('尚未登录!');location='../Login/Login.aspx'</script>");
}
int id = Convert.ToInt32(Request.QueryString["news_classid"]);
if (!IsPostBack)
{
using (var db = new HuXiuEntities())
{
News_class newsclass = db.News_class.SingleOrDefault(a => a.news_classid == id);
txtName.Text = newsclass.news_classname;
}
}
}
protected void rptActivity_begin_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
if (e.CommandName == "Delete")
{
using (var db = new HuXiuEntities())
{
News_class newsclass = db.News_class.SingleOrDefault(a => a.news_classid == id);
db.News_class.Remove(newsclass);
db.SaveChanges();
Response.Write("<script>alert('删除成功！');location='Newsclass_Delete.aspx'</script>");
}
}
}
protected void btnSub_Click(object sender, EventArgs e)
{
if (txtClass.Text == "")
{
Response.Write("<script>alert('输入不能为空！')</script>");
}
else
{
using (var db = new HuXiuEntities())
{
News_class newsclass = new News_class();
newsclass.news_classname = txtClass.Text;
db.News_class.Add(newsclass);
Response.Write("<script>alert('添加成功！');location='Newsclass_Add.aspx'</script>");
db.SaveChanges();
}
}
}
protected void btnSub_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["news_classid"]);
if (txtName.Text == "")
{
Response.Write("<script>alert('输入不能为空！')</script>");
}
else
{
using (var db = new HuXiuEntities())
{
News_class newsclass = db.News_class.SingleOrDefault(a => a.news_classid == id);
newsclass.news_classname = txtName.Text;
db.SaveChanges();
Response.Write("<script>alert('修改成功！');location='Newsclass_Delete.aspx'</script>");
}
}
}
//添加资讯
protected void btnSub_Click(object sender, EventArgs e)
{
int newsclassid;
try
{
if (fup.PostedFile.FileName == "")
{
lblInfo.Text = "请选择文件！";
}
else
{
if (!IsAllowedExtension(fup) == false)
{
lblInfo.Text = "上传文件格式不正确！";
}
if (IsAllowedExtension(fup) == true)
{
string filepath = fup.PostedFile.FileName;
string filename = filepath.Substring(filepath.LastIndexOf("\\") + 1);
string serverpath = Server.MapPath("picture/") + filename;
fup.PostedFile.SaveAs(serverpath);
serverpath = "picture/" + filename;
using (var db = new HuXiuEntities())
{
var news = new News();
if (txtTitle.Text == "")
{
Response.Write("<script>alert('输入不能为空！')</script>");
}
else if (Server.HtmlDecode(myEditor.InnerHtml) == "")
{
Response.Write("<script>alert('输入不能为空！')</script>");
}
else if (txtAuthor.Text == "")
{
Response.Write("<script>alert('输入不能为空！')</script>");
}
else
{
news.news_title = txtTitle.Text;
news.news_content = Server.HtmlDecode(myEditor.InnerHtml);
news.news_time = DateTime.Now;
int cout;
using (var dd = new HuXiuEntities())
{
var topcount = from it in db.News where it.news_top == 1 select it;
cout = topcount.ToList().Count;
}
if (Convert.ToInt16(radlTop.SelectedValue) == 1 && cout > 2)
{
Response.Write("<script>alert('已有三条头条，不能再设置头条了！');location='News_Add.aspx'</script>");
}
else
{
news.news_top = Convert.ToInt16(radlTop.SelectedValue);
news.news_cover = serverpath;
using (var db_0 = new HuXiuEntities())
{
string dropclass = dropClass.SelectedValue.ToString();
News_class news_class = db_0.News_class.SingleOrDefault(a => a.news_classname == dropclass);
newsclassid = news_class.news_classid;
}
news.news_class = newsclassid;
news.new_column = 1;
news.new_author = txtAuthor.Text;
db.News.Add(news);
db.SaveChanges();
}
lblInfo.Text = "上传成功！";
Response.Write("<script>alert('添加成功！');location='News_Add.aspx'</script>");
}
}
}
else
{
lblInfo.Text = "请上传图片！";
}
}
}
catch (Exception ex)
{
lblInfo.Text = DateTime.Now.ToString() + "上传发生错误！原因是：" + ex.ToString();
}
}
