public void Insert(News_Datail model) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@"INSERT INTO [dbo].[News_Datail] ([NewsSortId] ,[NewsTitle] ,[CreatedTime] ,[NewsContent] ,[CreatedBy]) VALUES (@NewsSortId ,@NewsTitle ,@CreatedTime ,@NewsContent ,@CreatedBy )"); SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@NewsSortId", model.NewsSortId), new SqlParameter("@NewsTitle", model.NewsTitle), new SqlParameter("@CreatedTime", DateTime.Now), new SqlParameter("@NewsContent", model.NewsContent), new SqlParameter("@CreatedBy", model.CreatedBy) }; new SqlHelper().ExecuteNonQuery(sql.ToString(), paras); }
public void Update(News_Datail model) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@"UPDATE [dbo].[News_Datail] SET [NewsTitle] = @NewsTitle ,[CreatedTime] = @CreatedTime ,[NewsSortId] = @NewsSortId ,NewsContent = @NewsContent ,LastUpdatedBy = @LastUpdatedBy ,LastCreatedTime = @LastCreatedTime WHERE ID = @ID "); SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@NewsTitle", model.NewsTitle), new SqlParameter("@CreatedTime", model.CreatedTime), new SqlParameter("@NewsSortId", model.NewsSortId), new SqlParameter("@NewsContent", model.NewsContent), new SqlParameter("@ID", model.ID), new SqlParameter("@LastUpdatedBy", model.LastUpdatedBy), new SqlParameter("@LastCreatedTime", model.LastCreatedTime) }; new SqlHelper().ExecuteNonQuery(sql.ToString(), pars); }
protected void btnSelect_Click(object sender, EventArgs e) { var title = txtTitle.Text.Trim(); var sort = ddlSort.Text.Trim(); if (sort == "全部" && title != null) { News_Datail model = new News_Datail { NewsTitle = title }; DataSet ds = new NewsMgr().Select4(model); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } else if (sort != "全部" && title != null) { var id = Convert.ToInt32(sort); News_Datail model = new News_Datail { NewsTitle = title, NewsSortId = id }; DataSet ds = new NewsMgr().Select3(model); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } }
public void Insert() { var user = (UserInfo)Session["User"]; string userName = user.UserName; if (tbTitle.Text != "" && ddlSort.Text != "全部") { var id = Convert.ToInt32(ddlSort.Text.Trim()); News_Datail model = new News_Datail { NewsTitle = tbTitle.Text, NewsSortId = id, CreatedTime = DateTime.Now, NewsContent = CKEditorControl1.Text, CreatedBy = userName }; new NewsMgr().Insert(model); Response.Write("<script>alert('保存成功!')</script>"); Response.Write("<script>window.location.href='NewsList.aspx';</script>"); } else { Response.Write("<script>alert('请把所有信息填写完成!!')</script>"); } }
protected void btnDelete_Click(object sender, EventArgs e) { var user = (UserInfo)Session["User"]; if (user == null) { Response.Redirect("Login.aspx"); } for (int i = 0; i < GridView1.Rows.Count - 1; i++) { CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("cbChoose"); if (cbox != null) { if (cbox.Checked) { int id = Convert.ToInt32(GridView1.Rows[i].Cells[1].Text.Trim()); News_Datail model = new News_Datail { ID = id }; new NewsMgr().Delete(model); } } } newsBind(); Response.Write("<script>alert('删除成功!')</script>"); }
public void Delete(News_Datail model) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@"DELETE FROM [dbo].[News_Datail] WHERE ID=@ID "); SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@ID", model.ID) }; new SqlHelper().ExecuteNonQuery(sql.ToString(), pars); }
public DataSet SelectNewsContentById(News_Datail model) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@"select NewsContent ,NewsTitle ,CreatedTime from News_Datail where ID = @ID "); SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@ID", model.ID) }; DataSet ds = new SqlHelper().ExecuteQuery(sql.ToString(), pars); return(ds); }
public List <News_Datail> SelectTitleInf(NewsSort model) { var list = new List <News_Datail>(); DataSet ds = new DalNewsSort().Select2(model); DataTable dt = new DataTable(); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } foreach (DataRow dr in dt.Rows) { var mod = new News_Datail(); mod.NewsTitle = Convert.ToString(dr["NewsTitle"]); mod.CreatedTime = Convert.ToDateTime(dr["CreatedTime"]); list.Add(mod); } return(list); }
public DataSet Select3(News_Datail model) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@"SELECT News_Datail.ID ,News_Sort.NewsSortName ,News_Datail.NewsTitle ,News_Datail.CreatedTime FROM dbo.News_Datail inner join News_Sort on News_Datail.NewsSortId = News_Sort.ID WHERE NewsTitle like @NewsTitle "); SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@NewsTitle", "%" + model.NewsTitle + "%") }; DataSet ds = new SqlHelper().ExecuteQuery(sql.ToString(), pars); return(ds); }
public List <News_Datail> Select() { var list = new List <News_Datail>(); var ds = dn.SelectSortList(); var dt = new DataTable(); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } foreach (DataRow dr in dt.Rows) { var mod = new News_Datail(); mod.ID = Convert.ToInt32(dr["ID"]); mod.NewsSortId = Convert.ToInt32(dr["NewsSortId"]); mod.NewsTitle = Convert.ToString(dr["NewsTitle"]); mod.CreatedTime = Convert.ToDateTime(dr["CreatedTime"]); list.Add(mod); } return(list); }
public void contentBind() { if (Request["id"] == null) { DataSet ds = new NewsMgr().Select6(); lbContent.Text = ds.Tables[0].Rows[0]["NewsContent"].ToString(); lbCreatedTime.Text = Convert.ToString(ds.Tables[0].Rows[0]["CreatedTime"]); lbTitle.Text = ds.Tables[0].Rows[0]["NewsTitle"].ToString(); } else { var id = Convert.ToInt32(Request["id"]); News_Datail model = new News_Datail { ID = id }; DataSet ds = new NewsMgr().SelectNewsContentById(model); lbContent.Text = ds.Tables[0].Rows[0]["NewsContent"].ToString(); lbTitle.Text = ds.Tables[0].Rows[0]["NewsTitle"].ToString(); lbCreatedTime.Text = ds.Tables[0].Rows[0]["CreatedTime"].ToString(); } }
public void Update() { var user = (UserInfo)Session["User"]; string userName = user.UserName; var text = tbTitle.Text; var text2 = CKEditorControl1.Text; News_Datail model = new News_Datail { NewsTitle = tbTitle.Text, NewsSortId = Convert.ToInt32(ddlSort.Text.Trim()), NewsContent = CKEditorControl1.Text, CreatedTime = DateTime.Now, ID = Convert.ToInt32(Request["id"]), LastUpdatedBy = userName, LastCreatedTime = DateTime.Now }; new NewsMgr().Update(model); LasetUpdated(); Response.Write("<script>alert('保存成功!')</script>"); Response.Write("<script>window.location.href='NewsList.aspx';</script>"); }
public void Update(News_Datail model) { dn.Update(model); }
public DataSet SelectNewsContentById(News_Datail model) { DataSet ds = dn.SelectNewsContentById(model); return(ds); }
public void Insert(News_Datail model) { dn.Insert(model); }
public void Delete(News_Datail model) { dn.Delete(model); }
public DataSet Select4(News_Datail model) { return(dn.Select3(model)); }