Esempio n. 1
0
        /// <summary>
        /// 查看/设置工作人员权限
        /// </summary>
        /// <param name="id">工作人员ID</param>
        /// <returns></returns>
        public ActionResult Roleinfo(int id)
        {
            User user = (from u in CQGJ.User
                         where u.UserID == id && u.IsAdmin == true
                         select u).First();
            Org org = (from u in CQGJ.User
                       from o in CQGJ.Org
                       where u.OrgID == o.OrgID && u.UserID == id
                       select o).First();
            string orgType = org.OrgType.ToString();
            var allroles = from r in CQGJ.Role
                           where r.RoleType.Contains(orgType)
                           select r;
            var myroles = from ur in CQGJ.UsersInRoles
                          from r in CQGJ.Role
                          where ur.AdminID == id && ur.RoleID == r.RoleID
                          select r;

            //更新工作人员角色信息
            if (Request.HttpMethod == "POST")
            {
                string[] keys = Request.Form.AllKeys;
                //先处理删除
                foreach (var r in myroles)
                {
                    if (!keys.Any(name => String.Equals(name, r.RoleID.ToString())))
                    {
                        int temp = r.RoleID;
                        UsersInRoles userrole = (from ur in CQGJ.UsersInRoles
                                                 where ur.AdminID == id && ur.RoleID == temp
                                                 select ur).First();
                        CQGJ.DeleteObject(userrole);
                    }
                }
                CQGJ.SaveChanges();
                //后处理插入
                foreach (string k in keys)
                {
                    int temp = Convert.ToInt16(k);
                    var recored = from ur in CQGJ.UsersInRoles
                                  where ur.AdminID == id && ur.RoleID == temp
                                  select ur;
                    if (recored.Count() <= 0)//小于0则插入新纪录
                    {
                        Role role = (from r in CQGJ.Role
                                     where r.RoleID == temp
                                     select r).First();
                        UsersInRoles ur = new UsersInRoles();
                        ur.AdminID = user.UserID;
                        ur.RoleID = role.RoleID;
                        CQGJ.AddToUsersInRoles(ur);
                        CQGJ.SaveChanges();
                    }
                }
                myroles = from ur in CQGJ.UsersInRoles
                          from r in CQGJ.Role
                          where ur.AdminID == id && ur.RoleID == r.RoleID
                          select r;
            }

            ViewData["MyRoles"] = myroles;
            ViewData["User"] = user;

            return View(allroles);
        }
Esempio n. 2
0
        /// <summary>
        /// 修改工作人员资料
        /// </summary>
        /// <param name="id">工作人员ID</param>
        /// <returns></returns>
        public ActionResult AdminEdit(int id)
        {
            AdminViewData viewData = new AdminViewData();

            Admin admin = (from a in CQGJ.Admin
                           where a.AdminID == id
                           select a).First();
            var myroles = from r in CQGJ.Role
                          from ur in CQGJ.UsersInRoles
                          where ur.RoleID == r.RoleID && ur.AdminID == admin.AdminID
                          select r;
            var allroles = from r in CQGJ.Role
                           select r;
            viewData.Nation = Nation(admin.Nation);
            viewData.GenderList = GenderList(admin.Gender);
            viewData.Admin = admin;
            if (Request.HttpMethod == "POST")
            {
                //更新信息
                string username = GetString("Username");
                if (username != null)
                {
                    var admins = from a in CQGJ.Admin
                                 where a.Username == username
                                 select a;
                    if (admins.Count() <= 0)
                    {
                        admin.Username = username;
                        if (GetString("Password") != "")
                        {
                            admin.Password = Core.Security.MD5Encrypt(GetString("Password"));
                        }
                        admin.Gender = GetString("Gender");
                        admin.Nation = GetString("Nation");
                        admin.Politics = GetString("Politics");
                        admin.IDCard = GetString("IDCard");
                        admin.Birthday = GetDate("Birthday");
                        if (admin.Birthday < new DateTime(1900, 1, 1))
                        { admin.Birthday = DateTime.Today; }
                        admin.Telephone = GetString("Telephone");
                        admin.Cellphone = GetString("Cellphone");
                        admin.WorkingOrgName = GetString("WorkingOrgName");
                        admin.Position = GetString("Position");
                        CQGJ.SaveChanges();

                        List<string> allkeys = Request.Form.AllKeys.ToList();

                        List<string> keys = new List<string> { };

                        for (int k = 0; k < allkeys.Count; k++)
                        {
                            if (allkeys[k].StartsWith("role-"))
                            {
                                keys.Add(allkeys[k].Substring(5, allkeys[k].Length - 5));
                            }
                        }

                        //先处理删除
                        foreach (var r in myroles)
                        {
                            if (!keys.Any(name => String.Equals(name, r.RoleID.ToString())))
                            {
                                int temp = r.RoleID;
                                UsersInRoles userrole = (from ur in CQGJ.UsersInRoles
                                                         where ur.AdminID == id && ur.RoleID == temp
                                                         select ur).First();
                                CQGJ.DeleteObject(userrole);
                            }
                        }
                        CQGJ.SaveChanges();
                        //后处理插入
                        foreach (string k in keys)
                        {
                            int temp = Convert.ToInt16(k);
                            var records = from ur in CQGJ.UsersInRoles
                                          where ur.AdminID == id && ur.RoleID == temp
                                          select ur;
                            if (records.Count() <= 0)//小于0则插入新纪录
                            {
                                UsersInRoles ur = new UsersInRoles();
                                ur.AdminID = id;
                                ur.RoleID = temp;
                                CQGJ.AddToUsersInRoles(ur);
                                CQGJ.SaveChanges();
                            }
                        }
                        myroles = from r in CQGJ.Role
                                  from ur in CQGJ.UsersInRoles
                                  where ur.RoleID == r.RoleID && ur.AdminID == admin.AdminID
                                  select r;
                    }
                    else
                    { ViewData["ErrorInfo"] = "用户名已存在!"; }
                }
                else
                {
                    ViewData["ErrorInfo"] = "用户名不能为空!";
                }
            }

            viewData.MyRoles = myroles.ToList();
            viewData.RoleList = allroles.ToList();

            return View(viewData);
        }