添加文章前台
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="addnews.aspx.cs" Inherits="cht_addnews" %>
<%@Register Assembly="CKEditor.NET" Namespace="CKEditor.NET" TagPrefix="CKEditor"%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>后台新闻发布页面</title>
</head>
<body>
<form id="form1" runat="server">
<div>
添加文章<br />
新闻标题<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
<br />
新闻作者<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
<br />
新闻大类型<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<br />
新闻小类型<br />
新闻图片<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Image ID="Image1" runat="server" />
<br />
新闻内容<br />
<br />
<br /><CKEditor:CKEditorControl ID="ck14" BasePath="/ckeditor" runat="server"></CKEditor:CKEditorControl>
<asp:Button ID="Button1" runat="server" Text="确认" OnClick="Button1_Click" />
</div>
</form>
</body>
</html>
添加文章后台
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class cht_addnews : System.Web.UI.Page
{
//初始化一个连接开关
SqlConnection myConn = DBClass.GetConnection();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
MapPathStr();
}
//添加文章的方法开始
void MapPathStr()
{
string sFile = FileUpload1.PostedFile.FileName;
if (sFile.Trim().Length == 0)
{
sFile = sFile.Substring(sFile.LastIndexOf("\\") + 1);
// sFile = sFile.Substring(sFile.LastIndexOf("."));
string Dtime = DateTime.Now.Date.ToString("yyyy-MM-dd");
string Ftime = Convert.ToString(DateTime.Now.Hour) + Convert.ToString(DateTime.Now.Minute) + Convert.ToString(DateTime.Now.Second);
//string NullPath = "../" + "files/" + Dtime + Ftime + sFile.ToLower();
string NullPath = "files/" + Dtime + Ftime + sFile.ToLower();
// string NewsPath = "files/" + Dtime + Ftime + sFile.ToLower();
// string sPath = null;
// FileUpload1.PostedFile.SaveAs(sPath);
myConn.Open();
SqlCommand cmd = new SqlCommand("cnews_ADD", myConn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter ntime = new SqlParameter("@ntime", SqlDbType.DateTime.ToString());
ntime.Value = Dtime.ToString();
cmd.Parameters.Add(ntime);
SqlParameter nauthor = new SqlParameter("@nauthor", SqlDbType.VarChar, 200);
nauthor.Value = this.TextBox3.Text.ToString().Trim();
cmd.Parameters.Add(nauthor);
SqlParameter nname = new SqlParameter("@nname", SqlDbType.VarChar, 200);
nname.Value = this.TextBox4.Text.ToString().Trim();
cmd.Parameters.Add(nname);
SqlParameter ntype1 = new SqlParameter("@ntype1", SqlDbType.VarChar, 200);
ntype1.Value = this.TextBox1.Text.ToString().Trim();
cmd.Parameters.Add(ntype1);
SqlParameter ntype2 = new SqlParameter("@ntype2", SqlDbType.VarChar, 200);
ntype2.Value = this.TextBox2.Text.ToString().Trim();
cmd.Parameters.Add(ntype2);
SqlParameter ncontent = new SqlParameter("@ncontent", SqlDbType.Text);
ncontent.Value = this.ck14.Text.ToString();
cmd.Parameters.Add(ncontent);
SqlParameter nimage = new SqlParameter("@nimage", SqlDbType.Text);
nimage.Value ="";
cmd.Parameters.Add(nimage);
try
{
cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "Message", "<Script>alert('新闻发布成功!')</Script>");
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "Message", "<Script>alert('新闻发布失败!')</Script>");
}
finally
{
myConn.Dispose();
myConn.Close();
}
}
else
{
sFile = sFile.Substring(sFile.LastIndexOf("\\") + 1);
sFile = sFile.Substring(sFile.LastIndexOf("."));
string Dtime = DateTime.Now.Date.ToString("yyyy-MM-dd");
string Ftime = Convert.ToString(DateTime.Now.Hour) + Convert.ToString(DateTime.Now.Minute) + Convert.ToString(DateTime.Now.Second);
//string NullPath = "../" + "files/" + Dtime + Ftime + sFile.ToLower();
string NullPath = "files/" + Dtime + Ftime + sFile.ToLower();
string Ppath = Dtime + Ftime + sFile.ToLower();
// string NewsPath = "files/" + Dtime + Ftime + sFile.ToLower();
string sPath = Server.MapPath(NullPath);
FileUpload1.PostedFile.SaveAs(sPath);
myConn.Open();
SqlCommand cmd = new SqlCommand("cnews_ADD", myConn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter ntime = new SqlParameter("@ntime", SqlDbType.DateTime.ToString());
ntime.Value = Dtime.ToString();
cmd.Parameters.Add(ntime);
SqlParameter nauthor = new SqlParameter("@nauthor", SqlDbType.VarChar,200);
nauthor.Value = this.TextBox3.Text.ToString().Trim();
cmd.Parameters.Add(nauthor);
SqlParameter nname= new SqlParameter("@nname", SqlDbType.VarChar, 200);
nname.Value = this.TextBox4.Text.ToString().Trim();
cmd.Parameters.Add(nname);
SqlParameter ntype1 = new SqlParameter("@ntype1", SqlDbType.VarChar, 200);
ntype1.Value = this.TextBox1.Text.ToString().Trim();
cmd.Parameters.Add(ntype1);
SqlParameter ntype2 = new SqlParameter("@ntype2", SqlDbType.VarChar, 200);
ntype2.Value = this.TextBox2.Text.ToString().Trim();
cmd.Parameters.Add(ntype2);
SqlParameter ncontent = new SqlParameter("@ncontent", SqlDbType.Text);
ncontent.Value =this.ck14.Text.ToString();
cmd.Parameters.Add(ncontent);
SqlParameter nimage = new SqlParameter("@nimage", SqlDbType.Text);
nimage.Value = Ppath.ToString().Trim();
cmd.Parameters.Add(nimage);
try
{
cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "Message", "<Script>alert('新闻发布成功!')</Script>");
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "Message", "<Script>alert('新闻发布失败!')</Script>");
}
finally
{
myConn.Dispose();
myConn.Close();
}
}
}
//添加文章的方法结束
}
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server"><%-- ImageUrl='<%#Eval("nimage","./ht/files/{0}")%>' "/ht/files/"+
<asp:Image ID="image1"runat="server" ImageUrl='<%# Eval("nimage") %>' Width="300px" Height="500px" />
--%>
<div>
</div>
<asp:DataList ID="d1" runat="server" >
<ItemTemplate>
<asp:Image ID="Image2" runat="server" ImageUrl='<%#Eval("nimage","./ht/files/{0}")%>' AlternateText='<%#Eval("nname") %>' Width="100px" Height="100px" />
<b><asp:Label ID="i1" runat="server" ><%#Eval("nname")%></asp:Label></b>
<asp:Label ID="c1" runat="server"><%#Eval("ncontent") %></asp:Label>
<label title="阅读更多内容 >>"></label>
</ItemTemplate>
</asp:DataList>
</form>
<p>
</p>
</body>
</html>
显示文章后台
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class test : System.Web.UI.Page
{
SqlConnection myConn = DBClass.GetConnection();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//此方法绑定数据库
DBBind();
}
}
public void DBBind()
{
SqlConnection myConn = DBClass.GetConnection();
myConn.Open();
SqlCommand cmd = new SqlCommand("cnews_GetList", myConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "GoodsInfo");
d1.DataSource = ds.Tables["GoodsInfo"].DefaultView;
d1.DataBind();
//cmd.Dispose();woxiawuyaochuqule
myConn.Close();
}
}