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