/// <summary> /// 查询类别名用于标题 /// </summary> /// <param name="CaName"></param> /// <returns></returns> public CodeContentCss CodeContentCssSelectCaNameTitle(string CaName) { DataTable dt = new DataTable(); CodeContentCss css = new CodeContentCss(); string sql = " SELECT top 1 caName FROM codeContentCss WHERE caName=@caName"; SqlParameter[] par = { new SqlParameter("@CaName", CaName) }; dt = sqlhelper.GetDataTable(sql, CommandType.Text, par); css.CaName = dt.Rows[0]["caName"].ToString(); return(css); }
/// <summary> /// 文章 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdd_Click(object sender, EventArgs e) { codeContentCssDAO cssdao = new codeContentCssDAO(); CodeContentCss codecss = new CodeContentCss(); string textTitle = TextBoxTitle.Text; string dropDownList2 = DropDownList2.Text; string dropDownList1 = DropDownList1.Text; string textareaExp = TextareaExp.InnerText; string textareaContent = TextareaContent.InnerText; if (textTitle == "") { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('标题不能为空');</script>"); return; } else if (textareaExp == "") { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('说明不能为空');</script>"); return; } else if (textareaContent == "") { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('内容不能为空');</script>"); return; } codecss.Title = textTitle; codecss.CaName = dropDownList1; codecss.PopName = dropDownList2; codecss.Explain = textareaExp; codecss.NewsContent = textareaContent; bool res = cssdao.CodeContentCssInsert(codecss); if (res) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('文章增加插入成功');</script>"); TextBoxTitle.Text = ""; TextareaExp.InnerText = ""; TextareaContent.InnerText = ""; } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('文章增加插入失败');</script>"); } }
/// <summary> /// 根据id查找内容 /// </summary> /// <param name="id">内容id</param> /// <returns></returns> public CodeContentCss CodeContentCssSelectId(string id) { CodeContentCss css = new CodeContentCss(); DataTable dt = new DataTable(); string sql = "SELECT * FROM codeContentCss WHERE id=@id"; SqlParameter[] par = { new SqlParameter("@id", id) }; dt = sqlhelper.GetDataTable(sql, CommandType.Text, par); css.Id = id; css.Title = dt.Rows[0]["title"].ToString(); css.NewsContent = dt.Rows[0]["newsContent"].ToString(); css.CreateTime = dt.Rows[0]["createTime"].ToString(); css.CaName = dt.Rows[0]["caName"].ToString(); css.Explain = dt.Rows[0]["explain"].ToString(); return(css); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { AboutSiteDAO abdao = new AboutSiteDAO(); aboutMy abmy = abdao.AboutSiteSelect(); lblMyName.Text = abmy.MyName; string caid = Request.QueryString["CaId"]; codeContentCssDAO codecssdao = new codeContentCssDAO(); CodeContentCss css = codecssdao.CodeContentCssSelectId(caid); string strTime = css.CreateTime; lblTime.Text = Convert.ToDateTime(strTime).ToString("yyyy-MM-dd"); lblCaName.Text = css.CaName; lblContent.Text = css.NewsContent; lblTitle.Text = css.Title; lblcate.Text = css.CaName; lblExplain.Text = css.Explain; } }
/// <summary> /// 插入css栏目内容 /// </summary> /// <param name="codeCss">实体类</param> /// <returns></returns> public bool CodeContentCssInsert(CodeContentCss codeCss) { bool falg = false; string sql = "insert into codeContentCss(title,newsContent,caName,explain,popName)values(@title,@newsContent,@caName,@explain,@popName)"; SqlParameter[] par = { new SqlParameter("@title", codeCss.Title), new SqlParameter("@newsContent", codeCss.NewsContent), new SqlParameter("@caName", codeCss.CaName), new SqlParameter("@explain", codeCss.Explain), new SqlParameter("@popName", codeCss.PopName) }; int res = sqlhelper.ExecuteNonQuery(sql, CommandType.Text, par); if (res > 0) { falg = true; } return(falg); }