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