/// <summary> /// 获得数据列表 /// </summary> public List <zs.Model.Tbl_Message> DataTableToList(DataTable dt) { List <zs.Model.Tbl_Message> modelList = new List <zs.Model.Tbl_Message>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { zs.Model.Tbl_Message model; for (int n = 0; n < rowsCount; n++) { model = new zs.Model.Tbl_Message(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["name"] != null && dt.Rows[n]["name"].ToString() != "") { model.name = dt.Rows[n]["name"].ToString(); } if (dt.Rows[n]["mail"] != null && dt.Rows[n]["mail"].ToString() != "") { model.mail = dt.Rows[n]["mail"].ToString(); } if (dt.Rows[n]["tel"] != null && dt.Rows[n]["tel"].ToString() != "") { model.tel = dt.Rows[n]["tel"].ToString(); } if (dt.Rows[n]["title"] != null && dt.Rows[n]["title"].ToString() != "") { model.title = dt.Rows[n]["title"].ToString(); } if (dt.Rows[n]["conts"] != null && dt.Rows[n]["conts"].ToString() != "") { model.conts = dt.Rows[n]["conts"].ToString(); } if (dt.Rows[n]["askTime"] != null && dt.Rows[n]["askTime"].ToString() != "") { model.askTime = DateTime.Parse(dt.Rows[n]["askTime"].ToString()); } if (dt.Rows[n]["reply"] != null && dt.Rows[n]["reply"].ToString() != "") { model.reply = dt.Rows[n]["reply"].ToString(); } if (dt.Rows[n]["replyTime"] != null && dt.Rows[n]["replyTime"].ToString() != "") { model.replyTime = DateTime.Parse(dt.Rows[n]["replyTime"].ToString()); } if (dt.Rows[n]["isShow"] != null && dt.Rows[n]["isShow"].ToString() != "") { model.isShow = int.Parse(dt.Rows[n]["isShow"].ToString()); } modelList.Add(model); } } return(modelList); }
protected void Button1_Click(object sender, EventArgs e) { zs.Model.Tbl_Message model = bll.GetModel(int.Parse(Request.QueryString["id"].ToString())); model.reply = this.TextBox1.Text.Trim(); model.replyTime = DateTime.Now; model.isShow = 1; bll.Update(model); string content = "<p>亲爱的" + name + "同学:</p><p style='text-indent:2em;'>您好!</p><p style='text-indent:2em;'>您于[" + asktime + "]在浙江树人大学招生网留言咨询:“" + conts + "”。</p><p style='text-indent:2em;'>我们的答复是:“" + this.TextBox1.Text.Trim() + "”。</p><p style='text-indent:2em;'>感谢您的咨询,愿我们的答案能让您满意!在此祝您生活幸福,学业有成!</p><p style='text-indent:2em;color:red'>(此邮件由zs.zjsru.edu.cn自动发送,请勿回复!)</p>"; this.Label1.Text = "回复成功!"; this.Label1.Text += ApplicationMethod.send_mail(mail, "浙江树人大学招生网留言回复", content, ""); }
private void BindData() { if (Request.QueryString["id"] != null) { zs.Model.Tbl_Message model = bll.GetModel(int.Parse(Request.QueryString["id"].ToString())); name = model.name; mail = model.mail; tel = model.tel; title = model.title; conts = model.conts; id = model.id.ToString(); asktime = model.askTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zs.Model.Tbl_Message model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zs.Model.Tbl_Message model) { return(dal.Add(model)); }