/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tbNews model)
{
SqlParameter[] parameters = {
new SqlParameter("@NewsTitle", SqlDbType.NVarChar,20),
new SqlParameter("@NewsContent", SqlDbType.Text),
new SqlParameter("@TypeID", SqlDbType.Int,4),
new SqlParameter("@OldUrl", SqlDbType.NVarChar,100),
new SqlParameter("@Author", SqlDbType.NVarChar,20),
new SqlParameter("@KeyWords", SqlDbType.NVarChar,200),
new SqlParameter("@Metades", SqlDbType.NVarChar,200),
new SqlParameter("@Review", SqlDbType.NVarChar,200),
new SqlParameter("@ClickNum", SqlDbType.Int,4),
new SqlParameter("@ImgUrl",SqlDbType.NVarChar,200)
};
parameters[0].Value = model.NewsTitle;
parameters[1].Value = model.NewsContent;
parameters[2].Value = model.TypeID;
parameters[3].Value = model.OldUrl;
parameters[4].Value = model.Author;
parameters[5].Value = model.KeyWords;
parameters[6].Value = model.Metades;
parameters[7].Value = model.Review;
parameters[8].Value = model.ClickNum;
parameters[9].Value = model.ImgUrl;
return db.ExcuteCommandReturnInt("tbNews_ADD", CommandType.StoredProcedure, parameters);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string img =DateTime.Now.ToString("yyyyMMddhhmmss")+fpImg.FileName;
tbNews news = new tbNews()
{
Author = this.txtAuthor.Text,
ClickNum = int.Parse(this.txtClick.Text),
KeyWords = this.txtKeyword.Text,
Metades = this.txtZhaiyao.Text,
OldUrl = this.txtForm.Text,
NewsContent = this.FCKeditor1.Value,
NewsTitle = this.txtTitle.Text,
Review = this.txtDaodu.Text,
TypeID = int.Parse(this.ddlClassId.SelectedValue),
ImgUrl = img
};
int count= newbll.Add(news);
if (count != 0)
{
//上传图片
string path=Server.MapPath(@"\Admin\FileImg\NewsImg\");
if (MyComm.FileUpLoad(fpImg, path, img) == "false")
{
ClientScript.RegisterStartupScript(this.GetType(), "test", "alert('文件上传失败')", true);
}
}
}