/// <summary>
/// 分页获取用户信息
/// </summary>
/// <param name="page">第几页</param>
/// <param name="rows">单页条数</param>
/// <returns></returns>
public ActionResult RetrieveByPage(int page, int rows)
{
int total = 0;
var users = new List <User>();
using (TaskAllocationDBContext ctx = new TaskAllocationDBContext())
{
total = ctx.Users.Count();
users = ctx.Users.OrderByDescending(u => u.Id).Skip((page - 1) * rows).Take(rows).ToList();
}
return(DataGrid(total, users));
}
public ActionResult Index()
{
using (TaskAllocationDBContext ctx = new TaskAllocationDBContext())
{
var r2 = ctx.TaskItems.ToList();
var r3 = ctx.Users.ToList();
var r4 = ctx.Tasks.ToList();
}
ViewBag.IsLogon = IsLogon();
return(View());
}
public ActionResult Delete(int id)
{
using (TaskAllocationDBContext ctx = new TaskAllocationDBContext())
{
var user = ctx.Users.Where(u => u.Id == id).FirstOrDefault();
if (user != null)
{
ctx.Entry <User>(user).State = EntityState.Deleted;
}
else
{
throw new Exception("user id is not exist:" + id);
}
ctx.SaveChanges();
}
return(SuccessMessage(BasicMessage.DeleteSuccess));
}
public ActionResult Index(User user)
{
using (TaskAllocationDBContext ctx = new TaskAllocationDBContext())
{
User loginUser = ctx.Users.Where(u => u.Name == user.Name && u.Password == user.Password).FirstOrDefault();
if (loginUser != null)
{
FormsAuthentication.SetAuthCookie(user.Name, false);
//存入Session
Session["LoginUserName"] = user.Name;
return(SuccessMessage());
}
else
{
return(FailedMessage("用户名或者密码错误。"));
}
}
}
private static void SaveUser(UserSaveObject userDTO)
{
if (string.IsNullOrWhiteSpace(userDTO.Name))
{
throw new ArgumentNullException("用户名为空。");
}
using (TaskAllocationDBContext ctx = new TaskAllocationDBContext())
{
if (userDTO.Id.HasValue)
{
var user = ctx.Users.Where(u => u.Id == userDTO.Id).FirstOrDefault();
if (user != null)
{
user.Name = userDTO.Name;
}
else
{
throw new ArgumentException("user id is not exist:" + userDTO.Id);
}
}
else
{
var existCount = ctx.Users.Where(u => u.Name == userDTO.Name).Count();
if (existCount > 0)
{
throw new ArgumentException("用户名" + userDTO.Name + "已存在。");
}
ctx.Users.Add(new User()
{
Name = userDTO.Name
});
}
ctx.SaveChanges();
}
}
