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