/// <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);
}
