コード例 #1
0
        /// <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);
        }
コード例 #2
0
        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();
        }
コード例 #3
0
        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);
        }
コード例 #4
0
        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();
            }
        }