示例#1
0
        /// <summary>
        /// 更新用户级别(0-普通用户、10 以上 Vip等级)
        /// </summary>
        public void UpdateUserLevel()
        {
            using (var db = new DBEntities())
            {
                var users = (from ua in db.Users
                             where !ua.IsDeleted && ua.UserLevel == -1
                             select ua.UserID).ToList();

                if (users != null && users.Count > 0)
                {
                    db.Database.ExecuteSqlCommand(@"update Users set UserLevel=isnull(aa.UserLevel,0)
                    from users left join (
                    select isnull(users.UserID,UserRoleMaps.UserID) UserID,max(UserLevelRules.UserLevel) UserLevel from UserLevelRules left join users on UserLevelRules.OrgCode=users.OrgCode
                    left join UserRoleMaps on UserLevelRules.RoleID=UserRoleMaps.RoleID
                    where UserLevelRules.IsDeleted=0 and ((UserLevelRules.RuleDimension=0 and users.UserID is not null)
                    or (UserLevelRules.RuleDimension=1 and UserRoleMaps.UserID is not null))
                    group by users.UserID,UserRoleMaps.UserID)aa on  users.UserID = aa.UserID
                    where Users.UserLevel=-1");

                    foreach (var item in users)
                    {
                        var User_CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserDTO>(StringCacheKeyType.User, item);
                        User_CacheKey.RemoveCache();
                    }
                }
            }
        }
示例#2
0
        /// <summary>
        /// 更新用户信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public ApiResult UpdateUserInfo([FromBody] UserDTO model)
        {
            userService  = new BLL.User.Implements.UserService();
            model.UserID = CurrentOperatorUserID;
            if (userService.UpdateUserInfo(model))
            {
                var GetUserIDByMobile_CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserDTO>(StringCacheKeyType.User, model.UserID);
                GetUserIDByMobile_CacheKey.RemoveCache();
                return(true.ToApiResultForBoolean());
            }

            return(EnumApiStatus.BizError.ToApiResultForApiStatus());
        }
示例#3
0
 /// <summary>
 /// 找回密码
 /// </summary>
 /// <param name="userID"></param>
 /// <param name="userPwd"></param>
 /// <returns></returns>
 public bool ResetPassword(string userID, string userPwd)
 {
     if (base.Update(userID, i => new Entity.User {
         Password = StringEncrypt.EncryptWithMD5(userPwd)
     }))
     {
         //采用缓存淘汰策略
         var cacheKey_User = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserDTO>(StringCacheKeyType.User, userID);
         cacheKey_User.RemoveCache();
         return(true);
     }
     else
     {
         return(false);
     }
 }
示例#4
0
        /// <summary>
        /// 修改密码信息
        /// </summary>
        /// <param name="userModel"></param>
        public ApiResult ChangePassword(RequestUserChangePasswordDTO passwordModel)
        {
            try
            {
                using (DBEntities db = new DBEntities())
                {
                    if (passwordModel.NewPassword != passwordModel.ConfirmPassword.Trim())
                    {
                        return(EnumApiStatus.BizChangePasswordConfirmPasswordError.ToApiResultForApiStatus());
                    }

                    if (passwordModel.NewPassword == passwordModel.OldPassword)
                    {
                        return(EnumApiStatus.BizChangePasswordNewPasswordEqualOld.ToApiResultForApiStatus());
                    }

                    string oldMD5 = StringEncrypt.EncryptWithMD5(passwordModel.OldPassword);
                    string oldSHA = StringEncrypt.EncryptWithSHA(passwordModel.OldPassword);

                    var user = db.Users.Where(t => t.UserID == passwordModel.UserID && (t.Password == oldMD5 || t.Password == oldSHA)).FirstOrDefault();

                    if (user == null)
                    {
                        return(EnumApiStatus.BizChangePasswordOldPasswordError.ToApiResultForApiStatus());
                    }
                    user.Password = StringEncrypt.EncryptWithMD5(passwordModel.NewPassword);
                    if (db.SaveChanges() > 0)
                    {
                        var GetUserIDByMobile_CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserDTO>(StringCacheKeyType.User, passwordModel.UserID);
                        GetUserIDByMobile_CacheKey.RemoveCache();

                        return(EnumApiStatus.BizOK.ToApiResultForApiStatus("密码修改成功"));
                    }
                    else
                    {
                        return(EnumApiStatus.BizChangePasswordOldPasswordError.ToApiResultForApiStatus());
                    }
                }
            }
            catch (Exception ex)
            {
                LogHelper.WriteError(ex);
                return(EnumApiStatus.BizError.ToApiResultForApiStatus("修改密码失败"));
            }
        }
示例#5
0
        /// <summary>
        /// 更新会员信息

        /// 日期:2017年4月15日
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public EnumApiStatus UpdateMemberInfo(BLL.User.DTOs.Request.RequestUserMemberDTO request)
        {
            using (DBEntities db = new DBEntities())
            {
                using (db.BeginTransaction())
                {
                    var model = db.UserMembers.Where(q => q.UserID == request.MemberID && q.MemberID == request.MemberID && q.IsDeleted == false).FirstOrDefault();
                    if (model == null)
                    {
                        return(EnumApiStatus.BizError);
                    }

                    // 当前用户不能有相同身份证的就诊人 add by lrj 2017-7-20
                    if (!string.IsNullOrEmpty(request.IDNumber))
                    {
                        var mid = db.UserMembers.Where(q => q.IDNumber == request.IDNumber && q.MemberID != model.MemberID &&
                                                       q.IsDeleted == false).Select(q => q.MemberID).FirstOrDefault();
                    }

                    #region 必填参数
                    model.MemberName = request.MemberName;
                    // model.Relation = request.Relation;
                    model.Gender     = request.Gender;
                    model.Marriage   = request.Marriage;
                    model.IDType     = request.IDType;
                    model.MemberName = request.MemberName;
                    #endregion

                    #region 可选参数(有值才修改)
                    if (request.Birthday != null)
                    {
                        model.Birthday = request.Birthday;
                    }

                    if (request.Mobile != null)
                    {
                        model.Mobile = request.Mobile;
                    }

                    if (request.IDNumber != null)
                    {
                        model.IDNumber = request.IDNumber;
                    }

                    if (request.Nationality != null)
                    {
                        model.Nationality = request.Nationality;
                    }
                    if (request.Province != null)
                    {
                        model.Province = request.Province;
                    }

                    if (request.ProvinceRegionID != null)
                    {
                        model.ProvinceRegionID = request.ProvinceRegionID;
                    }

                    if (request.City != null)
                    {
                        model.City = request.City;
                    }

                    if (request.CityRegionID != null)
                    {
                        model.CityRegionID = request.CityRegionID;
                    }

                    if (request.District != null)
                    {
                        model.District = request.District;
                    }

                    if (request.DistrictRegionID != null)
                    {
                        model.DistrictRegionID = request.DistrictRegionID;
                    }

                    if (request.Town != null)
                    {
                        model.Town = request.Town;
                    }

                    if (request.TownRegionID != null)
                    {
                        model.TownRegionID = request.TownRegionID;
                    }

                    if (request.Village != null)
                    {
                        model.Village = request.Village;
                    }

                    if (request.VillageRegionID != null)
                    {
                        model.VillageRegionID = request.VillageRegionID;
                    }

                    if (request.Address != null)
                    {
                        model.Address = request.Address;
                    }

                    if (request.Email != null)
                    {
                        model.Email = request.Email;
                    }

                    if (request.PostCode != null)
                    {
                        model.PostCode = request.PostCode;
                    }

                    #endregion

                    #region 是否已经存在本人关系的就诊人
                    if (request.Relation == EnumUserRelation.MySelf)
                    {
                        var members = GetMemberList(request.UserID);

                        //本人关系已经存在
                        if (members.Any(a => a.Relation == EnumUserRelation.MySelf && a.MemberID != model.MemberID))
                        {
                            return(EnumApiStatus.BizUserMemberRejectUpdateMySelfExists);
                        }
                    }
                    #endregion

                    #region 通过身份证号码获取性别和身份证号码
                    if (model.IDType == EnumUserCardType.IDCard && !string.IsNullOrEmpty(model.IDNumber))
                    {
                        string birthday, sex;
                        var    res = ToolHelper.GetBirthdaySexFromIdCard(model.IDNumber, out birthday, out sex);

                        //身份证号码正确
                        if (res)
                        {
                            model.Birthday = birthday;
                            model.Gender   = sex == "0" ? EnumUserGender.Male : EnumUserGender.Female;
                        }
                        else
                        {
                            //身份证号码格式错误
                            return(EnumApiStatus.BizUserMemberRejectInsertUpdateIDNumberFormatError);
                        }
                    }
                    #endregion

                    model.Relation = request.Relation;
                    if (request.IsDefault.HasValue && request.IsDefault == true)
                    {
                        model.IsDefault = true;
                    }
                    else if (request.IsDefault.HasValue && request.IsDefault == false)
                    {
                        model.IsDefault = false;
                    }

                    if (request.Relation == EnumUserRelation.MySelf)
                    {
                        var user = db.Users.Where(a => a.UserID == request.UserID).FirstOrDefault();
                        user.UserCNName = model.MemberName;
                        user.UserENName = model.MemberName;
                    }


                    if (db.SaveChanges() > 0)
                    {
                        db.Commit();
                        var userMemberCacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserMemberDTO>(XuHos.Common.Cache.Keys.StringCacheKeyType.User_Member, model.MemberID);
                        userMemberCacheKey.RemoveCache();

                        var User_CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserDTO>(XuHos.Common.Cache.Keys.StringCacheKeyType.User, request.UserID);
                        User_CacheKey.RemoveCache();
                    }
                }
                //设置默认
                if (request.IsDefault.HasValue && request.IsDefault.Value)
                {
                    SetDefaultMember(request.MemberID, request.UserID);
                }
                return(EnumApiStatus.BizOK);
            }
        }
示例#6
0
        /// <summary>
        /// 新增成员

        /// 日期:2017年4月15日
        /// </summary>
        /// <param name="userMemberEntity"></param>
        /// <returns></returns>
        public ApiResult InsertMemberInfo(BLL.User.DTOs.Request.RequestUserMemberDTO request)
        {
            ApiResult result = new ApiResult();

            string memberid = string.Empty;

            #region 身份证号码格式校验
            if (!string.IsNullOrEmpty(request.IDNumber) && request.IDType == EnumUserCardType.IDCard)
            {
                string birthday, sex;
                var    res = ToolHelper.GetBirthdaySexFromIdCard(request.IDNumber, out birthday, out sex);

                //身份证号码正确
                if (res)
                {
                    request.Birthday = birthday;
                    request.Gender   = sex == "0" ? EnumUserGender.Male : EnumUserGender.Female;
                }
                else
                {
                    result.Status = EnumApiStatus.BizUserMemberRejectInsertUpdateIDNumberFormatError;
                    result.Msg    = result.Status.GetEnumDescript();
                    return(result);
                }
            }
            #endregion

            using (DBEntities db = new DBEntities())
            {
                using (db.BeginTransaction())
                {
                    db.Configuration.AutoDetectChangesEnabled = true;
                    bool       isAdd            = false;
                    UserMember userMemberEntity = null;
                    if (!string.IsNullOrEmpty(request.IDNumber))
                    {
                        userMemberEntity = (from q in db.UserMembers
                                            where q.IDNumber == request.IDNumber && q.MemberName == request.MemberName && q.IsDeleted == false
                                            orderby q.ModifyTime descending, q.CreateTime descending, q.MemberID
                                            select q).FirstOrDefault();
                    }

                    if (userMemberEntity == null)
                    {
                        isAdd = true;
                        #region 可选参数(默认值)
                        if (request.Birthday == null)
                        {
                            request.Birthday = "";
                        }

                        if (request.Mobile == null)
                        {
                            request.Mobile = "";
                        }

                        if (request.IDNumber == null)
                        {
                            request.IDNumber = "";
                        }

                        if (request.Nationality == null)
                        {
                            request.Nationality = "";
                        }

                        if (request.Province == null)
                        {
                            request.Province = "";
                        }
                        if (request.ProvinceRegionID == null)
                        {
                            request.ProvinceRegionID = "";
                        }

                        if (request.City == null)
                        {
                            request.City = "";
                        }
                        if (request.CityRegionID == null)
                        {
                            request.CityRegionID = "";
                        }

                        if (request.District == null)
                        {
                            request.District = "";
                        }
                        if (request.DistrictRegionID == null)
                        {
                            request.DistrictRegionID = "";
                        }

                        if (request.Town == null)
                        {
                            request.Town = "";
                        }
                        if (request.TownRegionID == null)
                        {
                            request.TownRegionID = "";
                        }

                        if (request.Village == null)
                        {
                            request.Village = "";
                        }
                        if (request.VillageRegionID == null)
                        {
                            request.VillageRegionID = "";
                        }

                        if (request.Address == null)
                        {
                            request.Address = "";
                        }

                        if (request.Email == null)
                        {
                            request.Email = "";
                        }

                        if (request.PostCode == null)
                        {
                            request.PostCode = "";
                        }

                        if (request.IsDefault == null || !request.IsDefault.HasValue)
                        {
                            request.IsDefault = false;
                        }
                        #endregion
                        userMemberEntity              = request.Map <RequestUserMemberDTO, Entity.UserMember>();
                        userMemberEntity.MemberID     = Guid.NewGuid().ToString("N");
                        userMemberEntity.CreateTime   = DateTime.Now;
                        userMemberEntity.CreateUserID = request.UserID;
                    }


                    //默认成员
                    var defaultMemberEntity = GetDefaultMemberInfo(request.UserID).Map <ResponseUserMemberDTO, Entity.UserMember>();

                    memberid = userMemberEntity.MemberID;

                    //默认成员不存在
                    if (defaultMemberEntity == null)
                    {
                        //当前成员为默认
                        userMemberEntity.IsDefault = true;
                    }

                    if (request.Relation == EnumUserRelation.MySelf)
                    {
                        var userEntity = db.Users.Where(a => a.UserID == request.UserID).FirstOrDefault();
                        userEntity.UserCNName = request.MemberName;
                        userEntity.UserENName = request.MemberName;
                        var mySelfMember = (from m in db.UserMembers
                                            where m.UserID == request.UserID && m.Relation == EnumUserRelation.MySelf &&
                                            m.IsDeleted == false && m.IsDeleted == false
                                            select m).FirstOrDefault();

                        //如果默认成员已经存在则更新默认成员
                        if (mySelfMember != null)
                        {
                            //兼容bat 服务站,新增自己关系是,要是原来的自己关系信息不完整(身份证号为空),则覆盖
                            //身份证不为空,且操作机构不为网络医院
                            var webapiConfig = SysConfigService.Get <XuHos.Common.Config.Sections.Api>();
                            if (string.IsNullOrEmpty(mySelfMember.IDNumber) && request.OrgID != webapiConfig.OrgID)
                            {
                                mySelfMember.Gender     = request.Gender;
                                mySelfMember.Marriage   = request.Marriage;
                                mySelfMember.MemberName = request.MemberName;

                                #region 可选参数(有值才修改)
                                if (request.Birthday != null)
                                {
                                    mySelfMember.Birthday = request.Birthday;
                                }

                                if (request.Mobile != null)
                                {
                                    mySelfMember.Mobile = request.Mobile;
                                }

                                if (request.IDNumber != null)
                                {
                                    mySelfMember.IDNumber = request.IDNumber;
                                }

                                if (request.Nationality != null)
                                {
                                    mySelfMember.Nationality = request.Nationality;
                                }
                                if (request.Province != null)
                                {
                                    mySelfMember.Province = request.Province;
                                }

                                if (request.ProvinceRegionID != null)
                                {
                                    mySelfMember.ProvinceRegionID = request.ProvinceRegionID;
                                }

                                if (request.City != null)
                                {
                                    mySelfMember.City = request.City;
                                }

                                if (request.CityRegionID != null)
                                {
                                    mySelfMember.CityRegionID = request.CityRegionID;
                                }

                                if (request.District != null)
                                {
                                    mySelfMember.District = request.District;
                                }

                                if (request.DistrictRegionID != null)
                                {
                                    mySelfMember.DistrictRegionID = request.DistrictRegionID;
                                }

                                if (request.Town != null)
                                {
                                    mySelfMember.Town = request.Town;
                                }

                                if (request.TownRegionID != null)
                                {
                                    mySelfMember.TownRegionID = request.TownRegionID;
                                }

                                if (request.Village != null)
                                {
                                    mySelfMember.Village = request.Village;
                                }

                                if (request.VillageRegionID != null)
                                {
                                    mySelfMember.VillageRegionID = request.VillageRegionID;
                                }

                                if (request.Address != null)
                                {
                                    mySelfMember.Address = request.Address;
                                }

                                if (request.Email != null)
                                {
                                    mySelfMember.Email = request.Email;
                                }

                                if (request.PostCode != null)
                                {
                                    mySelfMember.PostCode = request.PostCode;
                                }

                                #endregion
                                memberid = mySelfMember.MemberID;
                                db.Update(mySelfMember);
                            }
                            else
                            {
                                result.Status = EnumApiStatus.BizUserMemberRejectUpdateMySelfExists;
                                result.Msg    = result.Status.GetEnumDescript();
                                return(result);
                            }
                        }
                    }

                    if (isAdd)
                    {
                        db.UserMembers.Add(userMemberEntity);
                    }
                    //db.Update(userEntity);
                    var count = db.SaveChanges();
                    db.Commit();
                    if (count > 0)
                    {
                        var userMemberCacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserMemberDTO>(XuHos.Common.Cache.Keys.StringCacheKeyType.User_Member, userMemberEntity.MemberID);
                        userMemberCacheKey.RemoveCache();

                        var User_CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserDTO>(XuHos.Common.Cache.Keys.StringCacheKeyType.User, request.UserID);
                        User_CacheKey.RemoveCache();
                        result.Status = EnumApiStatus.BizOK;
                    }
                    else
                    {
                        result.Status = EnumApiStatus.BizError;
                    }
                }
                //设置默认
                if (request.IsDefault.HasValue && request.IsDefault.Value)
                {
                    SetDefaultMember(memberid, request.UserID);
                }
                result.Data = memberid;
                result.Msg  = result.Status.GetEnumDescript();
                return(result);
            }
        }