/// <summary>
/// 得到一个对象实体
/// </summary>
public Pan.Model.Feedback DataRowToModel(DataRow row)
{
Pan.Model.Feedback model=new Pan.Model.Feedback();
if (row != null)
{
if(row["id"]!=null && row["id"].ToString()!="")
{
model.id=int.Parse(row["id"].ToString());
}
if(row["name"]!=null)
{
model.name=row["name"].ToString();
}
if(row["sex"]!=null)
{
model.sex=row["sex"].ToString();
}
if(row["mobile_num"]!=null)
{
model.mobile_num=row["mobile_num"].ToString();
}
if(row["content"]!=null)
{
model.content=row["content"].ToString();
}
if(row["time"]!=null)
{
model.time=row["time"].ToString();
}
}
return model;
}
public ActionResult FBApply()
{
Feedback fb = new Feedback();
Pan.Model.Feedback model = new Pan.Model.Feedback();
model.mobile_num = Request.Form["shouji"];
model.name = Request.Form["chengwei"];
model.sex = Request.Form["gender"];
model.time = DateTime.Now.ToString();
model.content = Request.Form["liuyan"];
fb.Add(model);
loan.Models.common.MailSender ms = new Models.common.MailSender();
StringBuilder body = new StringBuilder();
body.Append("<div>姓名:");
body.Append(model.name);
body.Append("</div>");
body.Append("<div>性别:");
body.Append(model.sex);
body.Append("</div>");
body.Append("<div>联系方式:");
body.Append(model.mobile_num);
body.Append("</div>");
body.Append("<div>留言内容:");
body.Append(model.content);
body.Append("</div>");
body.Append("<div>留言日期:");
body.Append(model.time);
body.Append("</div>");
ms.send("留言", body.ToString());
return Content("<script>alert('留言成功,我们的工作人员会尽快跟您联系。');window.location='/FeedBack.html';</script>");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Pan.Model.Feedback GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 id,name,sex,mobile_num,content,time from Feedback ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
Pan.Model.Feedback model=new Pan.Model.Feedback();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
