protected void btnAdd_Click(object sender, EventArgs e)
{
DALnew dal = new DALnew();
newEntity news = new newEntity();
news.Author = Session["adminID"].ToString();
//news.Author = "admin";
news.Content = content.Value;
news.ReleaseTime = DateTime.Parse(txtReleaseTime.Text);
news.Title = txtTitle.Text;
if (FileUpload1.HasFile)
{
int startPosition = FileUpload1.FileName.LastIndexOf("."); //获取后缀名的起始位置
string extName = FileUpload1.FileName.Substring(startPosition).ToLower(); //获取后缀名
string path = Server.MapPath("./File/");
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + extName;
string saveFile = path + fileName; //实现上传的
string showFile = "./File/" + fileName; //后期页面上显示的
FileUpload1.SaveAs(saveFile);
news.RelateFile = showFile;
}
dal.Addnews(news);
this.Page.RegisterClientScriptBlock("", "<script>新闻发布成功！</script>");
Response.Redirect("NewsManage.aspx");
}
protected void submit_Click(object sender, EventArgs e)
{
DALnew dal = new DALnew();
newEntity news = new newEntity();
news.Title = desc1.Value;
news.Content = content.Value;
news.Author = Session["name"].ToString();
news.ReleaseTime = System.DateTime.Now;
if (FileUpload1.HasFile)
{
int startPosition = FileUpload1.FileName.LastIndexOf(".");
string extName = FileUpload1.FileName.Substring(startPosition).ToLower();
string path = Server.MapPath("./File/");
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + extName;
string saveFile = path + fileName;
string showFile = "./File/" + fileName;
FileUpload1.SaveAs(saveFile);
news.RelateFile = showFile;
}
dal.Addnews(news);
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('新闻发布成功!');</script>");
}
protected void submit_Click(object sender, EventArgs e)
{
DALnew dal = new DALnew();
newEntity news = (newEntity)ViewState["news"];
news.Title = desc1.Value;
news.Content = desc.Value;
dal.Modnews(news);
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('编辑成功！');</script>");
}
/// <summary>
/// 获取数据并展示
/// </summary>
/// <param name="id"></param>
public void GetData(int id)
{
DALnew dal = new DALnew();
newEntity news = dal.Getnews(id);
ViewState["news"] = news;//在当前页缓存数据。
txtTitle.Text = news.Title;
txtReleaseTime.Text = news.ReleaseTime.ToString();
content.Value = news.Content;
}
public void GetData(int id)
{
//将取回的数据在页面进行展示，可以修改的数据使用TextBox来展示，并提供修改。
//通过按钮触发，实现将数据编辑保存的功能
DALnew dal = new DALnew();
newEntity news = dal.Getnews(id);
ViewState["news"] = news;
desc.Value = news.Content;
}
protected void submit_Click(object sender, EventArgs e)
{
DALnew dal = new DALnew();
newEntity news = new newEntity();
news.Title = desc1.Value;
news.Content = desc.Value;
news.Author = Session["uName"].ToString();
news.ReleaseTime = System.DateTime.Now;
dal.Addnews(news);
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('新闻编辑成功');</script>");
}
public void Bind(int id)
{
DALnew dal = new DALnew();
newEntity news = dal.Getnews(id);
lt1.Text = news.Title;
lb1.Text = news.ReleaseTime.ToString();
lt2.Text = news.Content;
if (!string.IsNullOrEmpty(news.RelateFile))
{
lt3.Text = "附件：<a href='" + news.RelateFile + "'>单击下载附件</a>";
}
}
/// <summary>
/// Select an item by Primarykey
/// </summary>
/// <param name="id"></param>
/// <returns>an item</returns>
public newEntity Getnews(int id)
{
newEntity news = new newEntity();
//primarykeys
//get paras
SqlParameter[] newsParms = GetnewsPrimaryKeyParameters();
//set values to paras
newsParms[0].Value = id;
//select
using (SqlDataReader reader = SQLHelper.ExecuteReader(SQLHelper.ConnectionString, CommandType.Text, SELECT_ONE_SQL, newsParms))
{
if (reader.Read())
{
if (!reader.IsDBNull(0))
{
news.Id = reader.GetInt32(0);
}
if (!reader.IsDBNull(1))
{
news.Title = reader.GetString(1);
}
if (!reader.IsDBNull(2))
{
news.Author = reader.GetString(2);
}
if (!reader.IsDBNull(3))
{
news.ReleaseTime = reader.GetDateTime(3);
}
if (!reader.IsDBNull(4))
{
news.Content = reader.GetString(4);
}
if (!reader.IsDBNull(5))
{
news.RelateFile = reader.GetString(5);
}
}
else
{
news = null;
}
}
return(news);
}
/// <summary>
/// Insert an item
/// </summary>
/// <param name="news"></param>
/// <returns>count of rows affected</returns>
public int Addnews(newEntity news)
{
int backvalue = 0;
//get paras
SqlParameter[] newsParms = GetnewsParametersInsert();
//set values to paras
newsParms[0].Value = news.Title;
newsParms[1].Value = news.Author;
newsParms[2].Value = news.ReleaseTime;
newsParms[3].Value = news.Content;
newsParms[4].Value = news.RelateFile;
//insert
using (SqlConnection conn = new SqlConnection(SQLHelper.ConnectionString))
{
backvalue = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, INSERT_SQL, newsParms);
}
return(backvalue);
}
/// <summary>
/// Select items by Columns
/// </summary>
/// <returns>IList<newEntity></returns>
public IList <newEntity> GetnewsTopN(int n)
{
IList <newEntity> newss = new List <newEntity>();
using (SqlDataReader reader = SQLHelper.ExecuteReader(SQLHelper.ConnectionString, CommandType.Text, SELECT_ALL_SQL, null))
{
int i = 0;
while (reader.Read() && i < n)
{
newEntity news = new newEntity();
if (!reader.IsDBNull(0))
{
news.Id = reader.GetInt32(0);
}
if (!reader.IsDBNull(1))
{
news.Title = reader.GetString(1);
}
if (!reader.IsDBNull(2))
{
news.Author = reader.GetString(2);
}
if (!reader.IsDBNull(3))
{
news.ReleaseTime = reader.GetDateTime(3);
}
if (!reader.IsDBNull(4))
{
news.Content = reader.GetString(4);
}
if (!reader.IsDBNull(5))
{
news.RelateFile = reader.GetString(5);
}
newss.Add(news);
i++;
}
}
return(newss);
}
/// <summary>
/// private common select by conditions
/// </summary>
/// <returns>IList<newEntity></returns>
private IList <newEntity> GetnewsbyQueryString(string SQLstr)
{
IList <newEntity> newss = new List <newEntity>();
using (SqlDataReader reader = SQLHelper.ExecuteReader(SQLHelper.ConnectionString, CommandType.Text, SQLstr))
{
while (reader.Read())
{
newEntity news = new newEntity();
if (!reader.IsDBNull(0))
{
news.Id = reader.GetInt32(0);
}
if (!reader.IsDBNull(1))
{
news.Title = reader.GetString(1);
}
if (!reader.IsDBNull(2))
{
news.Author = reader.GetString(2);
}
if (!reader.IsDBNull(3))
{
news.ReleaseTime = reader.GetDateTime(3);
}
if (!reader.IsDBNull(4))
{
news.Content = reader.GetString(4);
}
if (!reader.IsDBNull(5))
{
news.RelateFile = reader.GetString(5);
}
newss.Add(news);
}
}
return(newss);
}
