protected void Modify_Click(object sender, EventArgs e)
{
RiJiDAO rijidao = new RiJiDAO();
RiJiModal rijimodal = new RiJiModal();
string wid = TxtId.Text;
string con = TxtCont.InnerText;
string url = TxtUrl.Text;
rijimodal.Id = wid;
rijimodal.RiJiText = con;
rijimodal.RiJiImgUrl = url;
bool b = rijidao.RiJiUpdate(rijimodal);
if (b)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('个人日记修改成功');</script>");
TxtCont.InnerText = "";
TxtUrl.Text = "";
Response.Redirect("default.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('个人日记修改失败');</script>");
}
}
/// <summary>
/// 个人日记
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Btn_Click(object sender, EventArgs e)
{
RiJiDAO rijidao = new RiJiDAO();
RiJiModal rijimodal = new RiJiModal();
string txtcon = TxtCont.InnerText;
string txturl = TxtUrl.Text;
if (txtcon == "")
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('内容不能为空');</script>");
return;
}
else if (txturl == "")
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('地址不能为空');</script>");
return;
}
rijimodal.RiJiText = txtcon;
rijimodal.RiJiImgUrl = txturl;
bool bol = rijidao.RiJiInsert(rijimodal);
if (bol)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('个人日记插入成功');</script>");
TxtCont.InnerText = "";
TxtUrl.Text = "";
Response.Redirect("default.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('个人日记插入失败');</script>");
}
}
/// <summary>
/// 插入日记内容
/// </summary>
/// <param name="riji"></param>
/// <returns></returns>
public bool RiJiInsert(RiJiModal riji)
{
bool flag = false;
string sql = "INSERT into RiJiDB(riJiText,riJiImgUrl) VALUES(@riJiText,@riJiImgUrl)";
SqlParameter[] par =
{
new SqlParameter("@riJiText", riji.RiJiText),
new SqlParameter("@riJiImgUrl", riji.RiJiImgUrl)
};
int res = sqlhelper.ExecuteNonQuery(sql, CommandType.Text, par);
if (res > 0)
{
flag = true;
}
return(flag);
}
/// <summary>
/// 修改日记内容
/// </summary>
/// <param name="riji"></param>
/// <returns></returns>
public bool RiJiUpdate(RiJiModal riji)
{
bool flag = false;
string sql = "UPDATE RiJiDB set riJiText=@riJiText,riJiImgUrl=@riJiImgUrl WHERE id=@id";
SqlParameter[] par =
{
new SqlParameter("@id", riji.Id),
new SqlParameter("@riJiText", riji.RiJiText),
new SqlParameter("@riJiImgUrl", riji.RiJiImgUrl)
};
int res = sqlhelper.ExecuteNonQuery(sql, CommandType.Text, par);
if (res > 0)
{
flag = true;
}
return(flag);
}
