コード例 #1
0
ファイル: MemberService.cs プロジェクト: uvaa/ytjkb
        /// <summary>
        /// 修改操作
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public async Task <ApiResult <string> > Edit(Member model)
        {
            var res = new ApiResult <string>()
            {
                statusCode = (int)ApiEnum.Error
            };

            try
            {
                //判断账号是否存在
                var isexModel = Db.Queryable <Member>().Single(m => m.LoginName == model.LoginName && m.Guid != model.Guid);
                if (isexModel != null)
                {
                    res.message = "用户名已存在,请更换~";
                    return(res);
                }
                model.LoginPwd = DES3Encrypt.EncryptString(model.LoginPwd);
                await Db.Updateable(model).ExecuteCommandAsync();

                res.statusCode = (int)ApiEnum.Status;
            }
            catch (Exception ex)
            {
                res.message = ApiEnum.Error.GetEnumText() + ex.Message;
                Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
            }
            return(res);
        }
コード例 #2
0
ファイル: ErpStaffService.cs プロジェクト: xman086/SoaProJect
        /// <summary>
        /// 修改登录密码
        /// </summary>
        /// <returns></returns>
        public async Task <ApiResult <string> > ModifyLoginPwdAsync(StaffModifyPwdParm parm)
        {
            var res = new ApiResult <string>()
            {
                data = "1", statusCode = (int)ApiEnum.ParameterError
            };

            try
            {
                //判断原密码是否正确
                parm.HistoryPwd = DES3Encrypt.EncryptString(parm.HistoryPwd);
                var isExt = ErpStaffDb.IsAny(m => m.LoginPwd == parm.HistoryPwd && m.Guid == parm.Guid);
                if (!isExt)
                {
                    res.message = "原密码输入错误~";
                    return(await Task.Run(() => res));
                }
                //开始修改新密码
                parm.NewPwd = DES3Encrypt.EncryptString(parm.NewPwd);
                ErpStaffDb.Update(m => new ErpStaff()
                {
                    LoginPwd = parm.NewPwd
                }, m => m.Guid == parm.Guid);
                res.statusCode = (int)ApiEnum.Status;
            }
            catch (Exception ex)
            {
                res.statusCode = (int)ApiEnum.Error;
                res.message    = ApiEnum.Error.GetEnumText() + ex.Message;
            }
            return(await Task.Run(() => res));
        }
コード例 #3
0
ファイル: SysUserController.cs プロジェクト: ztxyzu/BasisSoa
        public async Task <ApiResult <string> > Post(EditSysUserDto Params)
        {
            ApiResult <string> res   = new ApiResult <string>();
            TokenModelBeta     token = JwtToken.ParsingJwtToken(HttpContext);

            //开启事务
            try {
                SysUser userInfo = _mapper.Map <SysUser>(Params);
                userInfo.Id          = Guid.NewGuid().ToString();
                userInfo.CreatorTime = DateTime.Now;
                userInfo.CreatorId   = token.Id;
                await _userService.AddAsync(userInfo);

                SysUserLogon userLogonInfo = _mapper.Map <SysUserLogon>(Params);
                userLogonInfo.Id               = Guid.NewGuid().ToString();
                userLogonInfo.UserId           = userInfo.Id;
                userLogonInfo.LogOnCount       = 0;
                userLogonInfo.UserSecretkey    = Md5Crypt.Encrypt(Guid.NewGuid().ToString());
                userLogonInfo.UserPassword     = Md5Crypt.Encrypt(DES3Encrypt.EncryptString(userLogonInfo.UserPassword.ToLower(), userLogonInfo.UserSecretkey).ToLower(), false).ToLower();
                userLogonInfo.PasswordSecurity = UniversalTool.PassSecurityValidation(userLogonInfo.UserPassword);
                await _userLogonService.AddAsync(userLogonInfo);
            }
            catch (Exception ex) {
                res.code    = (int)ApiEnum.Error;
                res.message = "异常:" + ex.Message;
            }

            //事务结束


            return(await Task.Run(() => res));
        }
コード例 #4
0
        /// <summary>
        /// 用户登录实现
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public async Task <ApiResult <SysUserInfo> > LoginAsync(SysAdminLogin parm)
        {
            var res = new ApiResult <SysUserInfo>();

            parm.password = DES3Encrypt.EncryptString(parm.password);
            var model = db.Queryable <SysUserInfo>()
                        .Where(c => c.loginName == parm.loginname).First();

            if (model != null)
            {
                if (model.loginPWD.Equals(parm.password))
                {
                    //修改登录时间

                    //保存操作日志
                    res.success = true;
                    res.message = "获取成功";
                    res.data    = model;
                }
                else
                {
                    res.success    = false;
                    res.message    = "密码错误";
                    res.statusCode = (int)ApiEnum.Error;
                }
            }
            else
            {
                res.success    = false;
                res.statusCode = (int)ApiEnum.Error;
                res.message    = "账号错误~";
            }
            return(await Task.Run(() => res));
        }
コード例 #5
0
        /// <summary>
        /// 添加一条数据
        /// </summary>
        /// <returns></returns>
        public async Task <ApiResult <string> > AddAsync(ErpShops parm)
        {
            var res = new ApiResult <string>()
            {
                data = "1", statusCode = 200
            };

            try
            {
                //判断登录账号和店铺名是否存在
                var isExt = ErpShopsDb.IsAny(m => m.LoginName == parm.LoginName && m.ShopName == parm.ShopName);
                if (isExt)
                {
                    res.statusCode = (int)ApiEnum.ParameterError;
                    res.message    = "该商铺已存在~";
                }
                else
                {
                    parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
                    parm.Guid     = Guid.NewGuid().ToString();
                    var dbres = ErpShopsDb.Insert(parm);
                    if (!dbres)
                    {
                        res.statusCode = (int)ApiEnum.Error;
                        res.message    = "插入数据失败~";
                    }
                }
            }
            catch (Exception ex)
            {
                res.statusCode = (int)ApiEnum.Error;
                res.message    = ApiEnum.Error.GetEnumText() + ex.Message;
            }
            return(await Task.Run(() => res));
        }
コード例 #6
0
ファイル: UserController.cs プロジェクト: uvaa/ytjkb
        public async Task <IActionResult> Add([FromBody] List <FormParam> param)
        {
            var res = await _memberService.Login(param);

            if (res.statusCode != 200)
            {
                return(Ok(res));
            }
            //保存认证策略
            var modelStr = JsonConvert.SerializeObject(res.data);
            //加密保存起来
            var jmStr    = DES3Encrypt.EncryptString(modelStr);
            var identity = new ClaimsPrincipal(
                new ClaimsIdentity(new[]
            {
                new Claim(KeyHelper.BbsUserKey, jmStr),
            }, BbsUserAuthorizeAttribute.BbsUserAuthenticationScheme)
                );
            await HttpContext.SignInAsync(BbsUserAuthorizeAttribute.BbsUserAuthenticationScheme, identity, new AuthenticationProperties
            {
                AllowRefresh = false
            });

            return(Ok(res));
        }
コード例 #7
0
ファイル: ErpStaffService.cs プロジェクト: xman086/SoaProJect
        /// <summary>
        /// 修改一条数据
        /// </summary>
        /// <returns></returns>
        public async Task <ApiResult <string> > ModifyAsync(ErpStaff parm)
        {
            var res = new ApiResult <string>()
            {
                data = "1", statusCode = 200
            };

            try
            {
                parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
                ErpStaffDb.Update(m => new ErpStaff()
                {
                    TrueName  = parm.TrueName,
                    Sex       = parm.Sex,
                    LoginName = parm.LoginName,
                    Status    = parm.Status,
                    Mobile    = parm.Mobile,
                    LoginPwd  = parm.LoginPwd
                }, m => m.Guid == parm.Guid);
            }
            catch (Exception ex)
            {
                res.statusCode = (int)ApiEnum.Error;
                res.message    = ApiEnum.Error.GetEnumText() + ex.Message;
            }
            return(await Task.Run(() => res));
        }
コード例 #8
0
ファイル: SysAdminService.cs プロジェクト: xman086/SoaProJect
        /// <summary>
        /// 用户登录实现
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public async Task <ApiResult <SysAdmin> > LoginAsync(SysAdminLogin parm)
        {
            var res = new ApiResult <SysAdmin>();

            try
            {
                parm.password = DES3Encrypt.EncryptString(parm.password);
                var model = Db.Queryable <SysAdmin>()
                            .Where(m => m.LoginName == parm.loginname).First();
                if (model != null)
                {
                    if (model.LoginPwd.Equals(parm.password))
                    {
                        //修改登录时间
                        model.LoginDate   = DateTime.Now;
                        model.UpLoginDate = model.LoginDate;
                        SysAdminDb.Update(model);

                        #region 保存操作日志
                        var logModel = new SysLog()
                        {
                            Guid        = Guid.NewGuid().ToString(),
                            LoginName   = model.LoginName,
                            DepartName  = model.DepartmentName,
                            OptionTable = "SysAdmin",
                            Summary     = "登录操作",
                            IP          = Utils.GetIp(),
                            LogType     = (int)LogEnum.Login,
                            Urls        = Utils.GetUrl(),
                            AddTime     = DateTime.Now
                        };
                        SysLogDb.Insert(logModel);
                        #endregion

                        res.success = true;
                        res.message = "获取成功!";
                        res.data    = model;
                    }
                    else
                    {
                        res.success    = false;
                        res.statusCode = (int)ApiEnum.Error;
                        res.message    = "密码错误~";
                    }
                }
                else
                {
                    res.success    = false;
                    res.statusCode = (int)ApiEnum.Error;
                    res.message    = "账号错误~";
                }
            }
            catch (Exception ex)
            {
                res.message    = ApiEnum.Error.GetEnumText() + ex.Message;
                res.statusCode = (int)ApiEnum.Error;
            }
            return(await Task.Run(() => res));
        }
コード例 #9
0
ファイル: UserController.cs プロジェクト: uvaa/ytjkb
        public async Task <Core.Model.Member.Member> GetLoginUser()
        {
            var auth = await HttpContext.AuthenticateAsync(BbsUserAuthorizeAttribute.BbsUserAuthenticationScheme);

            var str = auth.Principal.Identities.First(u => u.IsAuthenticated).FindFirst(KeyHelper.BbsUserKey).Value;

            return(JsonConvert.DeserializeObject <Core.Model.Member.Member>(DES3Encrypt.DecryptString(str)));
        }
コード例 #10
0
ファイル: SysAdminService.cs プロジェクト: zero530/FytSoaCms
        /// <summary>
        /// 修改菜单
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public async Task <ApiResult <string> > ModifyAsync(SysAdmin parm)
        {
            var res = new ApiResult <string>
            {
                statusCode = (int)ApiEnum.Error
            };

            try
            {
                //修改,判断用户是否和其它的重复
                var isExisteName = await Db.Queryable <SysAdmin>().AnyAsync(m => m.LoginName == parm.LoginName && m.Guid != parm.Guid);

                if (isExisteName)
                {
                    res.message    = "用户名已存在,请更换~";
                    res.statusCode = (int)ApiEnum.ParameterError;
                    return(await Task.Run(() => res));
                }

                parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
                if (!string.IsNullOrEmpty(parm.DepartmentGuid))
                {
                    // 说明有父级  根据父级,查询对应的模型
                    var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
                    parm.DepartmentGuidList = model.ParentGuidList;
                }
                var dbres = await Db.Updateable <SysAdmin>().UpdateColumns(m => new SysAdmin()
                {
                    LoginName          = parm.LoginName,
                    LoginPwd           = parm.LoginPwd,
                    DepartmentName     = parm.DepartmentName,
                    DepartmentGuid     = parm.DepartmentGuid,
                    DepartmentGuidList = parm.DepartmentGuidList,
                    TrueName           = parm.TrueName,
                    Number             = parm.Number,
                    Sex    = parm.Sex,
                    Mobile = parm.Mobile,
                    Email  = parm.Email,
                    Status = parm.Status
                }).Where(m => m.Guid == parm.Guid).ExecuteCommandAsync();

                if (dbres > 0)
                {
                    res.statusCode = (int)ApiEnum.Status;
                    res.message    = "更新成功!";
                }
                else
                {
                    res.message = "更新失败!";
                }
            }
            catch (Exception ex)
            {
                res.message = ApiEnum.Error.GetEnumText() + ex.Message;
                Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
            }
            return(res);
        }
コード例 #11
0
        public async Task <IActionResult> GetModelByGuid([FromBody] ParmString parm)
        {
            var res = await _adminService.GetModelAsync(m => m.Guid == parm.parm);

            if (!string.IsNullOrEmpty(res.data.Guid))
            {
                res.data.LoginPwd = DES3Encrypt.DecryptString(res.data.LoginPwd);
            }
            return(Ok(res));
        }
コード例 #12
0
        /// <summary>
        /// 添加部门信息
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public async Task <ApiResult <string> > AddAsync(SysAdmin parm)
        {
            var res = new ApiResult <string>
            {
                statusCode = (int)ApiEnum.ParameterError
            };

            try
            {
                //判断用吗是否存在
                var isExisteName = await Db.Queryable <SysAdmin>().AnyAsync(m => m.LoginName == parm.LoginName);

                if (isExisteName)
                {
                    res.message = "用户名已存在,请更换~";
                    return(res);
                }
                parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
                if (string.IsNullOrEmpty(parm.HeadPic))
                {
                    parm.HeadPic = "/themes/img/avatar.jpg";
                }
                parm.Guid    = Guid.NewGuid().ToString();
                parm.AddDate = DateTime.Now;
                if (!string.IsNullOrEmpty(parm.DepartmentGuid))
                {
                    // 说明有父级  根据父级,查询对应的模型
                    var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
                    parm.DepartmentGuidList = model.ParentGuidList;
                }
                SysAdminDb.Insert(parm);
                //查询授权表,type=2 更新新的权限值
                //添加新的
                var authorityList = new List <SysPermissions>();
                foreach (var item in parm.RoleList)
                {
                    authorityList.Add(new SysPermissions()
                    {
                        RoleGuid  = item.guid,
                        AdminGuid = parm.Guid,
                        Types     = 2
                    });
                }
                await Db.Insertable(authorityList).ExecuteCommandAsync();

                res.statusCode = (int)ApiEnum.Status;
            }
            catch (Exception ex)
            {
                res.message = ApiEnum.Error.GetEnumText() + ex.Message;
                Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
            }
            return(await Task.Run(() => res));
        }
コード例 #13
0
        /// <summary>
        /// 用户登录实现
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public async Task <ApiResult <SysAdminMenuDto> > LoginAsync(SysAdminLogin parm)
        {
            var res = new ApiResult <SysAdminMenuDto>()
            {
                statusCode = (int)ApiEnum.Error
            };

            try
            {
                var adminModel = new SysAdminMenuDto();
                parm.password = DES3Encrypt.EncryptString(parm.password);
                var model = await Db.Queryable <SysAdmin>()
                            .Where(m => m.LoginName == parm.loginname).FirstAsync();

                if (model == null)
                {
                    res.message = "账号错误";
                    return(res);
                }
                if (!model.LoginPwd.Equals(parm.password))
                {
                    res.message = "密码错误~";
                    return(res);
                }
                if (!model.Status)
                {
                    res.message = "登录账号被冻结,请联系管理员~";
                    return(res);
                }
                adminModel.menu = GetMenuByAdmin(model.Guid);
                if (adminModel == null)
                {
                    res.message = "当前账号没有授权功能模块,无法登录~";
                    return(res);
                }
                //修改登录时间
                model.LoginDate   = DateTime.Now;
                model.UpLoginDate = model.LoginDate;
                model.LoginSum    = model.LoginSum + 1;
                SysAdminDb.Update(model);



                res.statusCode   = (int)ApiEnum.Status;
                adminModel.admin = model;
                res.data         = adminModel;
            }
            catch (Exception ex)
            {
                res.message = ex.Message;
                Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
            }
            return(res);
        }
コード例 #14
0
ファイル: ErpStaffService.cs プロジェクト: xman086/SoaProJect
        /// <summary>
        /// 根据账号密码登录
        /// </summary>
        /// <returns></returns>
        public async Task <ApiResult <ShopBasicDto> > LoginAsync(StaffLoginDto parm)
        {
            var res = new ApiResult <ShopBasicDto> {
                statusCode = (int)ApiEnum.ParameterError
            };
            //先查询员工账号是否可以登录,如果可以,根据员工的归属加盟商,在查询对应的加盟商
            var staffModel = ErpStaffDb.GetSingle(m => m.LoginName == parm.loginName);

            if (staffModel == null)
            {
                res.message = "登录账号错误";
                return(await Task.Run(() => res));
            }
            //判断密码
            parm.loginPwd = DES3Encrypt.EncryptString(parm.loginPwd);
            if (staffModel.LoginPwd != parm.loginPwd)
            {
                res.message = "密码错误";
                return(await Task.Run(() => res));
            }
            if (staffModel.Status != 0)
            {
                res.message = "账号被冻结,请联系管理员";
                return(await Task.Run(() => res));
            }
            //根据商铺ID查询店铺信息,以及修改账号登录信息
            staffModel.LoginCount   += 1;
            staffModel.LastLoginDate = DateTime.Now;
            staffModel.UpLoginDate   = staffModel.LastLoginDate;
            staffModel.IsDevice      = parm.isDevice;
            staffModel.DeviceName    = parm.deviceName;
            staffModel.Token         = parm.token;
            //修改员工信息
            ErpStaffDb.Update(staffModel);

            //根据员工的关联的加盟商ID,查询加盟商信息
            var shopModel = ErpShopsDb.GetSingle(m => m.Guid == staffModel.ShopGuid);

            if (shopModel == null)
            {
                res.message = "店铺不存在!";
                return(await Task.Run(() => res));
            }
            res.statusCode = (int)ApiEnum.Status;
            res.data       = new ShopBasicDto()
            {
                StaffGuid = staffModel.Guid,
                ShopGuid  = shopModel.Guid,
                ShopName  = shopModel.ShopName,
                AdminName = staffModel.TrueName,
                Mobile    = staffModel.Mobile
            };
            return(await Task.Run(() => res));
        }
コード例 #15
0
        public async Task <IActionResult> IsLogin()
        {
            var auth = await HttpContext.AuthenticateAsync(BbsUserAuthorizeAttribute.BbsUserAuthenticationScheme);

            var str   = auth.Principal.Identities.First(u => u.IsAuthenticated).FindFirst(KeyHelper.BbsUserKey).Value;
            var model = JsonConvert.DeserializeObject <Core.Model.Member.Member>(DES3Encrypt.DecryptString(str));

            return(Ok(new ApiResult <Core.Model.Member.Member>()
            {
                data = model
            }));
        }
コード例 #16
0
ファイル: AdminController.cs プロジェクト: duzhenyi/DL
        public IActionResult AdminModify(string id)
        {
            ViewBag.Roles = _sysRoleService.GetListAsync(m => m.IsEnable, m => m.Sort, DbOrderEnum.Desc).Result.data;
            var adminModel = _sysAdminService.GetModelAsync(id).Result.data;

            //密码解密
            if (adminModel != null)
            {
                adminModel.Pwd = DES3Encrypt.DecryptString(adminModel.Pwd);
            }
            return(View(adminModel));
        }
コード例 #17
0
 public void OnGet(string guid, string shop)
 {
     staffModel = _staffService.GetByGuidAsync(guid).Result.data;
     if (staffModel != null)
     {
         //密码解密
         staffModel.LoginPwd = DES3Encrypt.DecryptString(staffModel.LoginPwd);
     }
     if (!string.IsNullOrEmpty(shop))
     {
         staffModel.ShopGuid = shop;
     }
 }
コード例 #18
0
ファイル: MemberService.cs プロジェクト: uvaa/ytjkb
        /// <summary>
        /// 登录
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public async Task <ApiResult <Member> > Login(List <FormParam> param)
        {
            var res = new ApiResult <Member>()
            {
                statusCode = (int)ApiEnum.Error
            };

            try
            {
                if (param == null || param.Count == 0)
                {
                    res.message = ApiEnum.ParameterError.GetEnumText();
                    return(res);
                }

                var model = await Db.Queryable <Member>().SingleAsync(m => m.LoginName == param[0].value || m.Mobile == param[0].value || m.Email == param[0].value && !m.IsDel);

                if (model == null)
                {
                    res.message = "用户名输入错误~";
                    return(res);
                }

                if (!model.Status)
                {
                    res.message = "账号被冻结,请联系客服专员~";
                    return(res);
                }
                //密码处理
                var pass = DES3Encrypt.EncryptString(param[1].value);
                if (!pass.Equals(model.LoginPwd))
                {
                    res.message = "密码输入错误~";
                    return(res);
                }

                //修改时间
                model.LoginSum += 1;
                model.LoginTime = DateTime.Now;
                await Db.Updateable(model).ExecuteCommandAsync();

                res.data       = model;
                res.statusCode = (int)ApiEnum.Status;
            }
            catch (Exception ex)
            {
                res.message = ex.Message;
            }

            return(res);
        }
コード例 #19
0
        /// <summary>
        /// 修改密码
        /// </summary>
        public async Task <ApiResult <string> > UpdatePwdAsync(UpdatePwdDto parm)
        {
            var res = new ApiResult <string>
            {
                statusCode = (int)ApiEnum.Error
            };

            try
            {
                if (string.IsNullOrEmpty(parm.userId))
                {
                    res.message    = "当前登录用户已过期";
                    res.statusCode = (int)ApiEnum.LoginExpireError;
                    return(await Task.Run(() => res));
                }
                if (parm.new_pwd != parm.con_pwd)
                {
                    res.message    = "两次密码输入不一致";
                    res.statusCode = (int)ApiEnum.ParameterError;
                    return(await Task.Run(() => res));
                }

                var model = await Db.Queryable <SysAdmin>().Where(t => t.Guid == parm.userId).FirstAsync();

                if (model.LoginPwd != DES3Encrypt.EncryptString(parm.old_pwd))
                {
                    res.message    = "原密码错误";
                    res.statusCode = (int)ApiEnum.ParameterError;
                    return(await Task.Run(() => res));
                }

                model.LoginPwd = DES3Encrypt.EncryptString(parm.new_pwd);
                var dbres = await Db.Updateable(model).UpdateColumns(t => new { t.LoginPwd }).ExecuteCommandAsync();

                if (dbres > 0)
                {
                    res.statusCode = (int)ApiEnum.Status;
                    res.message    = "更新成功!";
                }
                else
                {
                    res.message = "更新失败!";
                }
            }
            catch (Exception ex)
            {
                res.message = ApiEnum.Error.GetEnumText() + ex.Message;
                Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
            }
            return(res);
        }
コード例 #20
0
        /// <summary>
        /// 登录方法
        /// </summary>
        /// <param name="db"></param>
        /// <param name="lmodel"></param>
        /// <returns></returns>
        public ResultJson Logins(SqlSugarClient db, vLoginModel lmodel)
        {
            var json = new ResultJson()
            {
                backurl = "/fytadmin/index/"
            };
            var model = db.Queryable <sysadmin>().Single(m => m.LoginName == lmodel.loginname);

            if (model != null)
            {
                LogProvider.Error(LoggerEnums.Info.ToString(), DES3Encrypt.EncryptString(lmodel.password));
                if (model.LoginPwd.Equals(DES3Encrypt.EncryptString(lmodel.password)))
                {
                    //判断是否冻结
                    if (model.Status)
                    {
                        json.data = model;
                        //根据管理员的角色ID查询菜单,目前支持模块化权限验证
                        var roleModel = db.Queryable <sysrolemenu>().Where(m => m.RoleID == model.RoleID).ToList();
                        var mlist     = roleModel.Select(item => item.MenuID).ToList();
                        //根据角色关联的菜单ID,查询菜单集合
                        var menuList   = db.Queryable <sysmenu>().Where(m => mlist.Contains(m.ID)).ToList();
                        var adminModel = new AdminModel()
                        {
                            ID = model.ID, sysadmin = model, sysMenu = menuList
                        };
                        //将用户登录信息保存的session中
                        SessionHelper.SetSession(KeyHelper.SESSION_ADMIN_INFO, ProtobufHelper.Serialize(adminModel));
                        //将登录ID保存到cookie中
                        CookieHelper.SetCookie(KeyHelper.COOKIE_ADMIN_USERID, DES3Encrypt.EncryptString(model.ID.ToString()), 1);
                    }
                    else
                    {
                        json.status = 403;
                        json.msg    = "您的账号被冻结,请联系管理员~";
                    }
                }
                else
                {
                    json.status = 402;
                    json.msg    = "密码错误~";
                }
            }
            else
            {
                json.status = 401;
                json.msg    = "用户名错误~";
            }
            return(json);
        }
コード例 #21
0
ファイル: ApisController.cs プロジェクト: mrmurphy6/Internal
        //解析token
        ActionResult AnalysisToken(ApiParamter paramter, out bool isret, out tMembersEntity member)
        {
            member = null;
            isret  = true;

            if (paramter == null)
            {
                return(RetToLogin("登录过期,请重新登录"));
            }

            if (paramter.token.IsEmpty())
            {
                return(RetToLogin("登录过期,请重新登录"));
            }

            paramter.token = DES3Encrypt.Decrypt(paramter.token);

            paramter.user = JsonAdapter.Deserialize <UserToken>(paramter.token);
            if (paramter.user == null)
            {
                return(RetJsonResult(ApiResponseCodeEnum.Fail, "非法请求"));
            }

            if (DateHelper.GetTimeStamp_Seconds() - paramter.user.time > (30 * 60))
            {
                return(RetToLogin("登录过期,请重新登录"));
            }

            if (paramter.user.Id <= 0)
            {
                return(RetJsonResult(ApiResponseCodeEnum.Fail, "非法请求"));
            }

            member = tMembersBLL.Instance.GetModel(paramter.user.Id);
            if (member == null)
            {
                return(RetJsonResult(ApiResponseCodeEnum.Fail, "非法请求"));
            }

            if (member.mbState.Value.Equals(YesNoEnum.No.GetHashCode()))
            {
                return(RetToLogin("账户被禁用"));
            }

            paramter.clientType = ClientHelper.IsPC(Request.UserAgent) ? "PC" : "H5";

            isret = false;
            return(RetJsonResult(ApiResponseCodeEnum.Success));
        }
コード例 #22
0
ファイル: SysUserController.cs プロジェクト: ztxyzu/BasisSoa
        public async Task <ApiResult <string> > Put(string Id, EditSysUserDto Params)
        {
            ApiResult <string> res = new ApiResult <string>();


            //开启事务
            try
            {
                SysUser userInfo = _mapper.Map <SysUser>(Params);
                if (!UniversalTool.ModuleIsNull(userInfo))
                {
                    userInfo.Id = Id;
                    await _userService.UpdateAsync(userInfo);
                }


                if (string.IsNullOrEmpty(Params.UserPassword) || Params.UserPassword == "********")
                {
                    Params.UserPassword     = null;
                    Params.PasswordSecurity = null;
                }
                SysUserLogon userLogonInfo = _mapper.Map <SysUserLogon>(Params);
                if (!UniversalTool.ModuleIsNull(userLogonInfo))
                {
                    SysUserLogon sysUserLogon = await _userLogonService.QueryFirstAsync(s => s.UserId == Id);

                    if (!string.IsNullOrEmpty(Params.UserPassword) && Params.UserPassword != "********")
                    {
                        userLogonInfo.PasswordSecurity = UniversalTool.PassSecurityValidation(userLogonInfo.UserPassword);
                        userLogonInfo.UserSecretkey    = Md5Crypt.Encrypt(Guid.NewGuid().ToString());
                        userLogonInfo.UserPassword     = Md5Crypt.Encrypt(DES3Encrypt.EncryptString(userLogonInfo.UserPassword.ToLower(), userLogonInfo.UserSecretkey).ToLower(), false).ToLower();
                    }
                    userLogonInfo.Id = sysUserLogon.Id;
                    await _userLogonService.UpdateAsync(userLogonInfo);
                }
            }
            catch (Exception ex)
            {
                res.code    = (int)ApiEnum.Error;
                res.message = "异常:" + ex.Message;
            }

            //事务结束

            return(await Task.Run(() => res));
        }
コード例 #23
0
ファイル: MemberController.cs プロジェクト: uvaa/ytjkb
        public async Task <IActionResult> GetModel([FromBody] ParmString obj)
        {
            var res = await _memberService.GetModelAsync(m => m.Guid == obj.parm);

            if (!string.IsNullOrEmpty(res.data?.Guid))
            {
                res.data.LoginPwd = DES3Encrypt.DecryptString(res.data.LoginPwd);
            }
            //获得所有组
            var group = await _groupService.GetListAsync(m => !m.IsDel, m => m.Level, DbOrderEnum.Asc);

            return(Ok(new ApiResult <MemberGroupDto>()
            {
                statusCode = res.statusCode, data = new MemberGroupDto()
                {
                    member = res.data, group = group.data
                }
            }));
        }
コード例 #24
0
        /// <summary>
        /// 添加部门信息
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public new async Task <ApiResult <string> > AddAsync(SysAdmin parm)
        {
            var res = new ApiResult <string>
            {
                statusCode = 200,
                data       = "1"
            };

            try
            {
                //判断用吗是否存在
                var isExisteName = SysAdminDb.IsAny(m => m.LoginName == parm.LoginName);
                if (isExisteName)
                {
                    res.message    = "用户名已存在,请更换~";
                    res.statusCode = (int)ApiEnum.ParameterError;
                    return(await Task.Run(() => res));
                }
                parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
                if (string.IsNullOrEmpty(parm.HeadPic))
                {
                    parm.HeadPic = "/themes/img/avatar.jpg";
                }
                parm.Guid    = Guid.NewGuid().ToString();
                parm.AddDate = DateTime.Now;
                if (!string.IsNullOrEmpty(parm.DepartmentGuid))
                {
                    // 说明有父级  根据父级,查询对应的模型
                    var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
                    parm.DepartmentGuidList = model.ParentGuidList;
                }
                SysAdminDb.Insert(parm);
            }
            catch (Exception ex)
            {
                res.message    = ApiEnum.Error.GetEnumText() + ex.Message;
                res.statusCode = (int)ApiEnum.Error;
                Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
            }
            return(await Task.Run(() => res));
        }
コード例 #25
0
        /// <summary>
        /// 根据用户名密码获取用户信息
        /// </summary>
        /// <param name="username"></param>
        /// <param name="password"></param>
        /// <returns></returns>
        public async Task <ApiResult <SysUser> > UserNameAndPassQueryAsync(string username, string password)
        {
            var res = new ApiResult <SysUser>();

            res.data = new SysUser();

            try
            {
                var userInfo = await Db.Queryable <SysUser>()
                               .Where(s => s.Account == username)
                               .Mapper(it => it.sysUserLogon, it => it.sysUserLogon.UserId)
                               .FirstAsync();

                if (userInfo != null)
                {
                    password = Md5Crypt.Encrypt(DES3Encrypt.EncryptString(password.ToLower(), userInfo.sysUserLogon.UserSecretkey).ToLower(), false).ToLower();
                    if (userInfo.sysUserLogon.UserPassword.Equals(password))
                    {
                        res.data = userInfo;
                    }
                    else
                    {
                        res.code    = (int)ApiEnum.Failure;
                        res.message = "账号错误,请重新输入";
                    }
                }
                else
                {
                    res.code    = (int)ApiEnum.Failure;
                    res.message = "用户不存在";
                }
            }
            catch (Exception ex)
            {
                res.message = ApiEnum.Error.GetEnumText() + ex.Message;
                res.code    = (int)ApiEnum.Error;
            }
            return(res);
        }
コード例 #26
0
        /// <summary>
        /// 用户登录实现
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public async Task <ApiResult <SysAdmin> > LoginAsync(SysAdminLogin parm)
        {
            var res = new ApiResult <SysAdmin>();

            try
            {
                parm.password = DES3Encrypt.EncryptString(parm.password);
                var model = Db.Queryable <SysAdmin>()
                            .Where(m => m.LoginName == parm.loginname).First();
                if (model != null)
                {
                    if (model.LoginPwd.Equals(parm.password))
                    {
                        res.success = true;
                        res.message = "获取成功!";
                        res.data    = model;
                    }
                    else
                    {
                        res.success    = false;
                        res.statusCode = (int)ApiEnum.Error;
                        res.message    = "密码错误~";
                    }
                }
                else
                {
                    res.success    = false;
                    res.statusCode = (int)ApiEnum.Error;
                    res.message    = "账号错误~";
                }
            }
            catch (Exception ex)
            {
                res.message    = ApiEnum.Error.GetEnumText() + ex.Message;
                res.statusCode = (int)ApiEnum.Error;
            }
            return(await Task.Run(() => res));
        }
コード例 #27
0
        /// <summary>
        /// 异步添加种子数据
        /// </summary>
        /// <param name="DbContext"></param>
        /// <returns></returns>
        public static async Task SeedAsync(BaseDbContext DbContext)
        {
            try
            {
                // 注意!一定要先手动创建一个空的数据库
                // 会覆盖,可以设置为true,来备份数据
                // 如果生成过了,第二次,就不用再执行一遍了,注释掉该方法即可
                DbContext.CreateTableByEntity(false, typeof(SysLog),
                                              typeof(SysUser),
                                              typeof(SysUserLogon),
                                              typeof(SysOrganize),
                                              typeof(SysRole),
                                              typeof(SysModule),
                                              typeof(SysModuleAction),
                                              typeof(SysRoleAuthorize),
                                              typeof(SysRoleAuthorizeAction),
                                              typeof(SysMessage));

                #region 追加种子数据

                string UserId     = Guid.NewGuid().ToString();
                string RoleId     = Guid.NewGuid().ToString();
                string OrganizeId = Guid.NewGuid().ToString();
                string ModuleId   = Guid.NewGuid().ToString();


                string UserSecretkey = Guid.NewGuid().ToString();

                if (!await DbContext.Db.Queryable <SysUser>().AnyAsync())
                {
                    DbContext.Db.Insertable(new SysOrganize()
                    {
                        Id         = OrganizeId,
                        ParentId   = "00000000-0000-0000-0000-000000000000",
                        Category   = "GROUP",
                        FullName   = "仓单系统总管理",
                        FullNameEn = "",
                        ShortName  = "仓单系统总管理",

                        DeleteMark   = false,
                        DeleteUserId = "",
                        DeleteTime   = null,

                        Description   = "",
                        IsExpand      = true,
                        EnabledMark   = true,
                        SortCode      = 1,
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable(new SysRole()
                    {
                        Id         = RoleId,
                        OrganizeId = OrganizeId,
                        ParentId   = "00000000-0000-0000-0000-000000000000",
                        Category   = "FATHER",
                        FullName   = "系统管理员",
                        FullNameEn = "",

                        DeleteMark   = false,
                        DeleteUserId = "",
                        DeleteTime   = null,

                        Description   = "",
                        IsExpand      = true,
                        EnabledMark   = true,
                        SortCode      = 1,
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable(new SysUser()
                    {
                        Id              = UserId,
                        RoleId          = RoleId,
                        OrganizeId      = OrganizeId,
                        Account         = "admin",
                        HeadIcon        = "https://b-ssl.duitang.com/uploads/item/201508/12/20150812204143_KHCAQ.thumb.700_0.jpeg",
                        WeChat          = "",
                        Tel             = "",
                        Birthday        = null,
                        RealName        = "管理员",
                        Email           = "*****@*****.**",
                        Token           = "",
                        IsAdministrator = true,
                        Description     = "",
                        EnabledMark     = true,
                        SortCode        = 1,
                        CreatorTime     = DateTime.Now,
                        CreatorId       = "00000000-0000-0000-0000-000000000000"
                    }).ExecuteCommand();
                    DbContext.Db.Insertable(new SysUserLogon()
                    {
                        Id               = Guid.NewGuid().ToString(),
                        UserId           = UserId,
                        Theme            = "",
                        Language         = "",
                        MultiUserLogin   = false,
                        LogOnCount       = 0,
                        UserSecretkey    = UserSecretkey,
                        PasswordSecurity = UniversalTool.PassSecurityValidation("123456"),
                        UserPassword     = Md5Crypt.Encrypt(DES3Encrypt.EncryptString("123456".ToLower(), UserSecretkey).ToLower(), false).ToLower(),
                    }).ExecuteCommand();
                    DbContext.Db.Insertable(new SysLog()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        Account       = "系统",
                        NickName      = "DbInit",
                        ModuleName    = "SeedInitAsync",
                        Result        = "OK",
                        ResultData    = "初始化数据库所有基础表 和 数据",
                        CreatorUserId = UserId,
                        CreatorTime   = DateTime.Now,
                    }).ExecuteCommand();



                    //主菜单
                    DbContext.Db.Insertable <SysModule>(new SysModule()
                    {
                        Id         = ModuleId,
                        ParentId   = "00000000-0000-0000-0000-000000000000",
                        FullName   = "系统",
                        FullNameEn = "",
                        Icon       = "",
                        UrlAddress = "",
                        ApiUrl     = "",
                        IsMenu     = true,
                        IsExpand   = true,


                        Description   = "系统",
                        SortCode      = 99,
                        EnabledMark   = true,
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,

                        DeleteMark   = false,
                        DeleteTime   = null,
                        DeleteUserId = null,
                    }).ExecuteCommand();
                    //子菜单 用户
                    string userModuleId = Guid.NewGuid().ToString();
                    DbContext.Db.Insertable <SysModule>(new SysModule()
                    {
                        Id         = userModuleId,
                        ParentId   = ModuleId,
                        FullName   = "用户管理",
                        FullNameEn = "SysUser",
                        Icon       = "",
                        UrlAddress = "/SysAdmin/user",
                        ApiUrl     = "/Api/SysUser",
                        IsMenu     = false,
                        IsExpand   = false,

                        Description = "用户管理",
                        SortCode    = 4,
                        EnabledMark = true,

                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,

                        DeleteMark   = false,
                        DeleteTime   = null,
                        DeleteUserId = null,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = userModuleId,
                        ActionName    = "",
                        RequestMethod = "POST",
                        ACL           = "POST",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = userModuleId,
                        ActionName    = "",
                        RequestMethod = "PUT",
                        ACL           = "PUT",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = userModuleId,
                        ActionName    = "",
                        RequestMethod = "GET",
                        ACL           = "GET",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = userModuleId,
                        ActionName    = "",
                        RequestMethod = "DELETE",
                        ACL           = "DELETE",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = userModuleId,
                        ActionName    = "GetUserDetails",
                        RequestMethod = "GET",
                        ACL           = "GetUserDetails",
                        EnabledMark   = true,
                        Description   = "获取用户详情 个人中心信息编辑",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = userModuleId,
                        ActionName    = "GetTokenUserDetails",
                        RequestMethod = "GET",
                        ACL           = "GetTokenUserDetails",
                        EnabledMark   = true,
                        Description   = "获取用户详情根据Token",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();


                    //子菜单 角色
                    string roleModuleId = Guid.NewGuid().ToString();
                    DbContext.Db.Insertable <SysModule>(new SysModule()
                    {
                        Id         = roleModuleId,
                        ParentId   = ModuleId,
                        FullName   = "角色管理",
                        FullNameEn = "SysUser",
                        Icon       = "",
                        UrlAddress = "/SysAdmin/role",
                        ApiUrl     = "/Api/SysRole",
                        IsMenu     = false,
                        IsExpand   = false,

                        Description = "角色管理",
                        SortCode    = 3,
                        EnabledMark = true,

                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,

                        DeleteMark   = false,
                        DeleteTime   = null,
                        DeleteUserId = null,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = roleModuleId,
                        ActionName    = "",
                        RequestMethod = "POST",
                        ACL           = "POST",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = roleModuleId,
                        ActionName    = "",
                        RequestMethod = "PUT",
                        ACL           = "PUT",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = roleModuleId,
                        ActionName    = "",
                        RequestMethod = "GET",
                        ACL           = "GET",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = roleModuleId,
                        ActionName    = "",
                        RequestMethod = "DELETE",
                        ACL           = "DELETE",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = roleModuleId,
                        ActionName    = "GetRoleTreeList",
                        RequestMethod = "GET",
                        ACL           = "GetRoleTreeList",
                        EnabledMark   = true,
                        Description   = "获取角色树",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();

                    //子菜单 组织
                    string organizeModuleId = Guid.NewGuid().ToString();
                    DbContext.Db.Insertable <SysModule>(new SysModule()
                    {
                        Id         = organizeModuleId,
                        ParentId   = ModuleId,
                        FullName   = "组织管理",
                        FullNameEn = "SysUser",
                        Icon       = "",
                        UrlAddress = "/SysAdmin/organize",
                        ApiUrl     = "/Api/SysOrganize",
                        IsMenu     = false,
                        IsExpand   = false,

                        Description = "组织管理",
                        SortCode    = 2,
                        EnabledMark = true,

                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,

                        DeleteMark   = false,
                        DeleteTime   = null,
                        DeleteUserId = null,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = organizeModuleId,
                        ActionName    = "",
                        RequestMethod = "POST",
                        ACL           = "POST",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = organizeModuleId,
                        ActionName    = "",
                        RequestMethod = "PUT",
                        ACL           = "PUT",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = organizeModuleId,
                        ActionName    = "",
                        RequestMethod = "GET",
                        ACL           = "GET",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = organizeModuleId,
                        ActionName    = "",
                        RequestMethod = "DELETE",
                        ACL           = "DELETE",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = organizeModuleId,
                        ActionName    = "GetOrganizeTreeList",
                        RequestMethod = "GET",
                        ACL           = "GetOrganizeTreeList",
                        EnabledMark   = true,
                        Description   = "获取组织树",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();



                    //子菜单 模块
                    string moduleModuleId = Guid.NewGuid().ToString();
                    DbContext.Db.Insertable <SysModule>(new SysModule()
                    {
                        Id         = moduleModuleId,
                        ParentId   = ModuleId,
                        FullName   = "模块管理",
                        FullNameEn = "SysUser",
                        Icon       = "",
                        UrlAddress = "/SysAdmin/module",
                        ApiUrl     = "/Api/SysModule",
                        IsMenu     = false,
                        IsExpand   = false,

                        Description = "模块管理",
                        SortCode    = 1,
                        EnabledMark = true,

                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,

                        DeleteMark   = false,
                        DeleteTime   = null,
                        DeleteUserId = null,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = moduleModuleId,
                        ActionName    = "",
                        RequestMethod = "POST",
                        ACL           = "POST",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = moduleModuleId,
                        ActionName    = "",
                        RequestMethod = "PUT",
                        ACL           = "PUT",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = moduleModuleId,
                        ActionName    = "",
                        RequestMethod = "GET",
                        ACL           = "GET",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = moduleModuleId,
                        ActionName    = "",
                        RequestMethod = "DELETE",
                        ACL           = "DELETE",
                        EnabledMark   = true,
                        Description   = "",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = moduleModuleId,
                        ActionName    = "GetModuleTreeList",
                        RequestMethod = "GET",
                        ACL           = "GetModuleTreeList",
                        EnabledMark   = true,
                        Description   = "获取模块树",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();
                    DbContext.Db.Insertable <SysModuleAction>(new SysModuleAction()
                    {
                        Id            = Guid.NewGuid().ToString(),
                        ModuleId      = moduleModuleId,
                        ActionName    = "GetModuleTreeAuthList",
                        RequestMethod = "GET",
                        ACL           = "GetModuleTreeAuthList",
                        EnabledMark   = true,
                        Description   = "获取权限模块树",
                        CreatorTime   = DateTime.Now,
                        CreatorUserId = UserId,
                    }).ExecuteCommand();


                    //角色模块权限
                    foreach (var item in await DbContext.Db.Queryable <SysModule>().ToListAsync())
                    {
                        //角色权限
                        DbContext.Db.Insertable <SysRoleAuthorize>(new SysRoleAuthorize()
                        {
                            Id            = Guid.NewGuid().ToString(),
                            RoleId        = RoleId,
                            ModuleId      = item.Id,
                            CreatorTime   = DateTime.Now,
                            CreatorUserId = UserId,
                        }).ExecuteCommand();
                    }


                    //角色模块按钮权限

                    foreach (var item in await DbContext.Db.Queryable <SysRoleAuthorize, SysModule, SysModuleAction>((sr, sm, sma) => new object[] {
                        JoinType.Left, sr.ModuleId == sm.Id,
                        JoinType.Left, sm.Id == sma.ModuleId,
                    })
                             .Where((sr, sm, sma) => sma.Id != null)
                             .Select((sr, sm, sma) => new {
                        id = sr.Id,
                        actionid = sma.Id
                    }).ToListAsync())
                    {
                        //角色权限
                        DbContext.Db.Insertable <SysRoleAuthorizeAction>(new SysRoleAuthorizeAction()
                        {
                            Id             = Guid.NewGuid().ToString(),
                            RoleAuthId     = item.id,
                            ModuleActionId = item.actionid,
                            CreatorTime    = DateTime.Now,
                            CreatorUserId  = UserId,
                        }).ExecuteCommand();
                    }
                }


                #endregion
            }
            catch (Exception ex)
            {
            }
        }
コード例 #28
0
        /// <summary>
        /// 修改菜单
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public async Task <ApiResult <string> > ModifyAsync(SysAdmin parm)
        {
            var res = new ApiResult <string>
            {
                statusCode = (int)ApiEnum.Error
            };

            try
            {
                //修改,判断用户是否和其它的重复
                var isExisteName = await Db.Queryable <SysAdmin>().AnyAsync(m => m.LoginName == parm.LoginName && m.Guid != parm.Guid);

                if (isExisteName)
                {
                    res.message    = "用户名已存在,请更换~";
                    res.statusCode = (int)ApiEnum.ParameterError;
                    return(await Task.Run(() => res));
                }

                parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd);
                if (!string.IsNullOrEmpty(parm.DepartmentGuid))
                {
                    // 说明有父级  根据父级,查询对应的模型
                    var model = SysOrganizeDb.GetById(parm.DepartmentGuid);
                    parm.DepartmentGuidList = model.ParentGuidList;
                }
                //查询授权表,type=2 更新新的权限值
                //删除
                var authority = await Db.Deleteable <SysPermissions>().Where(m => m.AdminGuid == parm.Guid && m.Types == 2).ExecuteCommandAsync();

                //添加新的
                var authorityList = new List <SysPermissions>();
                foreach (var item in parm.RoleList)
                {
                    authorityList.Add(new SysPermissions()
                    {
                        RoleGuid  = item.guid,
                        AdminGuid = parm.Guid,
                        Types     = 2
                    });
                }
                await Db.Insertable(authorityList).ExecuteCommandAsync();

                var dbres = await Db.Updateable <SysAdmin>().SetColumns(m => new SysAdmin()
                {
                    LoginName          = parm.LoginName,
                    LoginPwd           = parm.LoginPwd,
                    RoleGuid           = parm.RoleGuid,
                    DepartmentName     = parm.DepartmentName,
                    DepartmentGuid     = parm.DepartmentGuid,
                    DepartmentGuidList = parm.DepartmentGuidList,
                    TrueName           = parm.TrueName,
                    Number             = parm.Number,
                    Sex    = parm.Sex,
                    Mobile = parm.Mobile,
                    Email  = parm.Email,
                    Status = parm.Status
                }).Where(m => m.Guid == parm.Guid).ExecuteCommandAsync();

                if (dbres > 0)
                {
                    res.statusCode = (int)ApiEnum.Status;
                    res.message    = "更新成功!";
                }
                else
                {
                    res.message = "更新失败!";
                }
            }
            catch (Exception ex)
            {
                res.message = ApiEnum.Error.GetEnumText() + ex.Message;
                Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
            }
            return(res);
        }
コード例 #29
0
ファイル: AdminBll.cs プロジェクト: kucenchen/ASP.NET
        /// <summary>
        /// 用户登录实现
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public async Task <ApiResult <SysAdmin> > LoginAsync(SysAdminLogin parm)
        {
            var res = new ApiResult <SysAdmin>();

            try
            {
                parm.password = DES3Encrypt.EncryptString(parm.password);

                var model = DbContext._.Db.From <SysAdmin>().Where(d => d.LoginName == parm.loginname).ToFirstDefault();
                if (model != null)
                {
                    if (!model.Status)
                    {
                        res.success    = false;
                        res.statusCode = (int)ApiEnum.Error;
                        res.message    = "账号冻结~";
                    }
                    else
                    {
                        if (model.LoginPwd.Equals(parm.password))
                        {
                            //修改登录时间
                            model.LoginDate   = DateTime.Now;
                            model.UpLoginDate = model.LoginDate;
                            //SysAdminDb.Update(model);
                            DbContext._.Db.Update <SysAdmin>(model, d => d.Guid == model.Guid);

                            #region 保存操作日志
                            //var logModel = new SysLog()
                            //{
                            //    Guid = Guid.NewGuid().ToString(),
                            //    LoginName = model.LoginName,
                            //    DepartName = model.DepartmentName,
                            //    OptionTable = "SysAdmin",
                            //    Summary = "登录操作",
                            //    IP = Utils.GetIp(),
                            //    LogType = (int)LogEnum.Login,
                            //    Urls = Utils.GetUrl(),
                            //    AddTime = DateTime.Now
                            //};
                            //SysLogDb.Insert(logModel);
                            #endregion

                            res.success = true;
                            res.message = "获取成功!";
                            res.data    = model;
                        }
                        else
                        {
                            res.success    = false;
                            res.statusCode = (int)ApiEnum.Error;
                            res.message    = "密码错误~";
                        }
                    }
                }
                else
                {
                    res.success    = false;
                    res.statusCode = (int)ApiEnum.Error;
                    res.message    = "账号错误~";
                }
            }
            catch (Exception ex)
            {
                res.message    = ApiEnum.Error.GetEnumText() + ex.Message;
                res.statusCode = (int)ApiEnum.Error;
            }
            return(await Task.Run(() => res));
        }
コード例 #30
0
 public void OnGet(string guid)
 {
     shopModel = _shopService.GetByGuidAsync(guid).Result.data;
     //密码解密
     shopModel.LoginPwd = DES3Encrypt.DecryptString(shopModel.LoginPwd);
 }