public int updateModel(Bill_Msg model, string strusername, string strnid)
{
string sql = @"update bill_msg set title=@title,contents=@contents,mstype=@mstype,notifiername=@notifiername,endtime=@endtime,Accessories=@Accessories where writer='" + strusername + "' and id='" + strnid + "'";
SqlParameter[] sps =
{
new SqlParameter("@title", model.Title),
new SqlParameter("@contents", model.Contents),
new SqlParameter("@mstype", model.Mstype),
new SqlParameter("@notifiername", model.Notifiername),
new SqlParameter("@endtime", model.Endtime),
new SqlParameter("@Accessories", model.Accessories)
};
return(DataHelper.ExcuteNonQuery(sql, sps, false));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <param name="tran"></param>
public int InsertModel(Bill_Msg model)
{
string sql = @"insert into bill_msg(title,contents,writer,date,readtimes,mstype,notifierid,notifiername,endtime,Accessories) values(
@title, @contents, @writer, @date,@readtimes,@mstype,@notifierid,@notifiername,@endtime,@Accessories)";
SqlParameter[] sps =
{
new SqlParameter("@title", model.Title),
new SqlParameter("@contents", model.Contents),
new SqlParameter("@writer", model.Writer),
new SqlParameter("@date", model.Date),
new SqlParameter("@readtimes", model.ReadTimes),
new SqlParameter("@mstype", model.Mstype),
new SqlParameter("@notifierid", model.Notifierid),
new SqlParameter("@notifiername", model.Notifiername),
new SqlParameter("@endtime", model.Endtime),
new SqlParameter("@Accessories", model.Accessories)
};
return(DataHelper.ExcuteNonQuery(sql, sps, false));
}
private IList <Bill_Msg> ListMaker(string sql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <Bill_Msg> list = new List <Bill_Msg>();
foreach (DataRow dr in dt.Rows)
{
Bill_Msg model = new Bill_Msg();
model.ID = int.Parse(dr["id"].ToString());
model.Title = dr["title"].ToString();
model.Contents = dr["contents"].ToString();
model.Date = Convert.ToDateTime(dr["date"].ToString());
model.Writer = dr["writer"].ToString();
model.Mstype = dr["mstype"].ToString();
model.ReadTimes = dr["readTimes"].ToString();
model.Notifierid = dr["notifierid"].ToString();
model.Notifiername = dr["notifiername"].ToString();
model.Endtime = dr["endtime"].ToString();
model.Accessories = dr["Accessories"].ToString();
list.Add(model);
}
return(list);
}
protected void btnSave_Click(object sender, EventArgs e)
{
MsgDal dal = new MsgDal();
Bill_Msg model = new Bill_Msg();
if (Request["type"] == "add")
{
model.Title = txt_title.Text;
model.Contents = txt_content.Text;
model.Writer = Session["userCode"].ToString();
//beg发布时间
if (this.txt_addTime.Text.Trim() != "")
{
DateTime date = DateTime.MinValue;
bool flag = DateTime.TryParse(this.txt_addTime.Text.ToString(), out date);
if (flag)
{
model.Date = date;
}
else
{
Response.Write("<script>alert('日期格式错误！');</script>");
return;
}
}
else
{
Response.Write("<script>alert('请填写发布日期！');</script>");
txt_addTime.Focus();
return;
}
//end发布时间
//beg截止时间
if (this.txt_endTime.Text.Trim() != "")
{
DateTime date = DateTime.MinValue;
bool flag = DateTime.TryParse(this.txt_endTime.Text.ToString(), out date);
if (flag)
{
model.Endtime = date.ToString();
}
else
{
Response.Write("<script>alert('日期格式错误！');</script>");;
return;
}
}
else
{
Response.Write("<script>alert('请填写有效期限！');</script>");
txt_endTime.Focus();
return;
}
//end截止时间
model.ReadTimes = "0";
model.Mstype = lbType.Text.Trim();//ddlType.SelectedValue;
model.Accessories = "";
model.Notifierid = "";
model.Notifiername = "";
int row = dal.InsertModel(model);
if (row > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('保存成功！');window.location.href='messageList.aspx';", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('保存失败！');", true);
}
}
else
{
model.Title = txt_title.Text;
model.Contents = txt_content.Text;
model.Mstype = lbType.Text.Trim();//ddlType.SelectedValue;
//beg截止时间
if (this.txt_endTime.Text.Trim() != "")
{
DateTime date = DateTime.MinValue;
bool flag = DateTime.TryParse(this.txt_endTime.Text.ToString(), out date);
if (flag)
{
model.Endtime = date.ToString();
}
else
{
Response.Write("<script>alert('日期格式错误！');</script>");
return;
}
}
else
{
Response.Write("<script>alert('请填写有效期限！');</script>");
txt_endTime.Focus();
return;
}
//end截止时间
model.Notifiername = hftzr.Value;
model.Accessories = hffj.Value;
int row = dal.updateModel(model, Session["userCode"].ToString(), Request["id"]);
if (row > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('保存成功！');window.location.href='messageList.aspx';", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('保存失败！');", true);
}
}
}
