public ActionResult GetList() { ztest01Entities db = new ztest01Entities(); //把获得的数据转成list离合 List <usersinfo> list = db.usersinfo.Where <usersinfo>(u => true).ToList(); //然后反序列化为json返回到前端 return(Json(list)); }
/// <summary> /// 获得id并且展示详情 /// </summary> /// <param name="id">参数必须和路由设置的id一致,路由叫id这里也是id</param> /// <returns></returns> public ActionResult ShowDetail(int id) { ztest01Entities db = new ztest01Entities(); var ui = db.usersinfo.Where <usersinfo>(u => u.uid == id).FirstOrDefault(); StringBuilder sb = new StringBuilder(); sb.Append("<table border='1' >"); sb.Append("<tr><th>编号</th><th>账号</th><th>邮箱</th><th>手机号</th><th>时间</th></tr>"); sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td></tr>", ui.uid, ui.uaccount, ui.uemail, ui.uphone, ui.udatetime); sb.Append("</table>"); ViewData["thisUser"] = sb.ToString(); return(Content(ViewData["thisUser"].ToString())); }
public ActionResult UpdateUser(int id) { ztest01Entities db = new ztest01Entities(); var ui = db.usersinfo.Where <usersinfo>(u => u.uid == id).FirstOrDefault(); ViewData["uid"] = id; ViewData["uaccount"] = ui.uaccount; ViewData["upassword"] = ui.upassword; ViewData["uemail"] = ui.uemail; ViewData["uphone"] = ui.uphone; //return Content("UpdateUser"); return(View()); }
public ActionResult DeleteUser(int id) { ztest01Entities db = new ztest01Entities(); var ui = db.usersinfo.Where <usersinfo>(u => u.uid == id).FirstOrDefault(); db.usersinfo.Remove(ui); if (db.SaveChanges() > 0) { return(RedirectToAction("UsersInfoView", "UsersInfo", new { id = 1 })); } else { return(Content("Error")); } }
[HttpPost]//只能接收post,优先处理post请求 public ActionResult Register(usersinfo ui) { ui.udatetime = DateTime.Now.ToString(); ztest01Entities db = new ztest01Entities(); db.usersinfo.Add(ui); if (db.SaveChanges() > 0) { return(Content("成功")); } else { return(Content("失败")); } //return View(); }
//如果表单元素的name属性的值和实体类中的属性的名字保持一致, //那么表单中的数据会自动赋值给实体中的属性 //public ActionResult Regist() //{ //[HttpPost]//优先处理post请求 public ActionResult Regist(usersinfo ui) { //usersinfo ui = new usersinfo(); //ui.uaccount = Request["username"]; //ui.upassword = Request["userpass"]; //ui.uemail = Request["useremail"]; //ui.uphone = Request["userphone"]; ui.udatetime = DateTime.Now.ToString(); ztest01Entities db = new ztest01Entities(); db.usersinfo.Add(ui); if (db.SaveChanges() > 0) { return(Content("成功")); } else { return(Content("失败")); } }
public ActionResult ExecuteUpdate(usersinfo ui) { ztest01Entities db = new ztest01Entities(); var thisUi = db.usersinfo.Where(u => u.uid == ui.uid).FirstOrDefault(); thisUi.uaccount = ui.uaccount; thisUi.upassword = ui.upassword; thisUi.uemail = ui.uemail; thisUi.uphone = ui.uphone; thisUi.udatetime = DateTime.Now.ToString(); db.usersinfo.Attach(thisUi); db.Entry(thisUi).State = EntityState.Modified; if (db.SaveChanges() > 0) { return(Content("修改成功")); } else { return(Content("失败")); } }
// GET: UsersInfo public ActionResult UsersInfoView(int id) { ztest01Entities db = new ztest01Entities(); //传递过来的页码 int pageIndex = id; //var thisNum = Request["name"]; //if (int.TryParse(Request["name"], out pageIndex)) //{ // pageIndex = 1; //} //计算总的数据行数 int dataCount = db.usersinfo.Where(u => true).Count(); int eachPage = 20; //计算总的页数 每页20 int pageCount = Convert.ToInt32(Math.Ceiling((double)dataCount / eachPage)); pageIndex = pageIndex < 1 ? 1 : pageIndex; pageIndex = pageIndex > pageCount ? pageCount : pageIndex; var usersInfoList = db.usersinfo.Where <usersinfo>(u => true).OrderByDescending <usersinfo, int>(u => u.uid).Skip <usersinfo>((pageIndex - 1) * eachPage).Take <usersinfo>(eachPage); StringBuilder sb = new StringBuilder(); foreach (var usersinfo in usersInfoList) { sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td><a href='/UsersInfo/ShowDetail/{0}'>详情</a> <a href='/UsersInfo/UpdateUser/{0}'>修改</a> <a href='/UsersInfo/DeleteUser/{0}'>删除</a></td></tr>", usersinfo.uid, usersinfo.uaccount, usersinfo.uemail, usersinfo.uphone, usersinfo.udatetime); } //ViewData["usersinfoList"] = sb.ToString(); ViewData["pageIndex"] = pageIndex; ViewData["usersinfo"] = sb.ToString(); return(View()); }