/// <summary> /// 登录访问器 /// </summary> /// <param name="miicSocialUserDao">登录DAO</param> /// <returns>登录访问生成条件</returns> public MiicConditionCollections visitor(MiicSocialUserDao miicSocialUserDao) { MiicConditionCollections result = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition passwordCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.SM3Password), getMD5bySM2(rsaPassword), DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, passwordCondition)); MiicConditionCollections userCodeCondition = new MiicConditionCollections(MiicDBLogicSetting.And); MiicCondition socialCodeCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.SocialCode), socialCode, DbType.String, MiicDBOperatorSetting.Equal); userCodeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, socialCodeCondition)); MiicCondition mobileCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.Mobile), socialCode, DbType.String, MiicDBOperatorSetting.Equal); userCodeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, mobileCondition)); result.Add(userCodeCondition); MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(validCondition)); MiicCondition activateFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.ActivateFlag), ((int)(MiicSimpleApproveStatusSetting.Agree)).ToString(), DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(activateFlagCondition)); MiicCondition disabledFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.DisabledFlag), ((int)(MiicYesNoSetting.No)).ToString(), DbType.String, MiicDBOperatorSetting.Equal); result.Add(new MiicConditionLeaf(disabledFlagCondition)); return(result); }
public MiicConditionCollections visitor(MiicSocialUserDao socialUserDao) { MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicConditionCollections keywordCondition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition socialCode = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.SocialCode), Keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, socialCode)); MiicCondition userName = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.UserName), Keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, userName)); MiicCondition email = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.Email), Keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, email)); condition.Add(keywordCondition); if (UserType != UserTypeSetting.All) { if (UserType == UserTypeSetting.AllAdminDeparter) { MiicConditionCollections userTypeCondition = new MiicConditionCollections(); MiicCondition contryDepart = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.UserType), ((int)UserTypeSetting.CountryDepartUser).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, contryDepart)); MiicCondition localDepart = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.UserType), ((int)UserTypeSetting.LocalDepartUser).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, localDepart)); condition.Add(userTypeCondition); } else if (UserType == UserTypeSetting.AllAdminPerson) { MiicConditionCollections userTypeCondition = new MiicConditionCollections(); MiicCondition countryAdmin = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.UserType), ((int)UserTypeSetting.CountryAdmin).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, countryAdmin)); MiicCondition localAdmin = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.UserType), ((int)UserTypeSetting.LocalAdmin).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, localAdmin)); MiicCondition admin = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.UserType), ((int)UserTypeSetting.Administrator).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, admin)); condition.Add(userTypeCondition); } else { MiicCondition userTypeCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.UserType), ((int)UserType).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(userTypeCondition)); } } if (IsDisabled != MiicYesNoSetting.Unknown) { MiicCondition disabledFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.DisabledFlag), ((int)IsDisabled).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(disabledFlagCondition)); } if (IsActived != UserActivateSetting.Unknown) { MiicCondition activateFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.ActivateFlag), ((int)IsActived).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(activateFlagCondition)); } if (IsValid != MiicValidTypeSetting.Unknown) { MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <SearchUserView, string>(o => o.Valid), ((int)IsValid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(validCondition)); } return(condition); }
public MiicConditionCollections visitor(MiicSocialUserDao socialUserDao) { MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); if (DownloadType == MiicYesNoSetting.Yes) { MiicConditionCollections keywordCondition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition socialCode = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.SocialCode), Keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, socialCode)); MiicCondition userName = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.UserName), Keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, userName)); MiicCondition email = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.Email), Keyword, DbType.String, MiicDBOperatorSetting.Like); keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, email)); condition.Add(keywordCondition); if (UserType != UserTypeSetting.All) { if (UserType == UserTypeSetting.AllAdminDeparter) { MiicConditionCollections userTypeCondition = new MiicConditionCollections(); MiicCondition contryDepart = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.UserType), ((int)UserTypeSetting.CountryDepartUser).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, contryDepart)); MiicCondition localDepart = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.UserType), ((int)UserTypeSetting.LocalDepartUser).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, localDepart)); condition.Add(userTypeCondition); } else if (UserType == UserTypeSetting.AllAdminPerson) { MiicConditionCollections userTypeCondition = new MiicConditionCollections(); MiicCondition countryAdmin = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.UserType), ((int)UserTypeSetting.CountryAdmin).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, countryAdmin)); MiicCondition localAdmin = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.UserType), ((int)UserTypeSetting.LocalAdmin).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, localAdmin)); MiicCondition admin = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.UserType), ((int)UserTypeSetting.Administrator).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, admin)); condition.Add(userTypeCondition); } else { MiicCondition userTypeCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.UserType), ((int)UserType).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(userTypeCondition)); } } if (IsDisabled != MiicYesNoSetting.Unknown) { MiicCondition disabledFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.DisabledFlag), ((int)IsDisabled).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(disabledFlagCondition)); } if (IsActived != UserActivateSetting.Unknown) { MiicCondition activateFlagCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.ActivateFlag), ((int)IsActived).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(activateFlagCondition)); } if (IsValid != MiicValidTypeSetting.Unknown) { MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.Valid), ((int)IsValid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(validCondition)); } } else if (DownloadType == MiicYesNoSetting.No) { MiicConditionCollections userIDConditions = new MiicConditionCollections(MiicDBLogicSetting.No); if (CheckIDs.Count != 0) { bool first = true; foreach (string userID in CheckIDs) { if (first == true) { MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.ID), userID, DbType.String, MiicDBOperatorSetting.Equal); userIDConditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, userIDCondition)); first = false; } else { MiicCondition userIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DownloadAllUserView, string>(o => o.ID), userID, DbType.String, MiicDBOperatorSetting.Equal); userIDConditions.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, userIDCondition)); } } condition.Add(userIDConditions); } else { throw new Exception("勾选用户不能为空"); } } return(condition); }
/// <summary> /// 找回密码访问器 /// </summary> /// <param name="miicSocialUserDao">微博用户DAO</param> /// <returns>生成查找条件</returns> public MiicConditionCollections Vistor(MiicSocialUserDao miicSocialUserDao) { MiicConditionCollections condition = new MiicConditionCollections(); switch (Type) { case MiicGetBackTypeSetting.Email: MiicCondition emailCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.Email), Value, DbType.String, MiicDBOperatorSetting.Equal); MiicCondition isEmailBindConditon = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.EmailBind), ((int)MiicYesNoSetting.Yes).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, emailCondition)); condition.Add(new MiicConditionLeaf(isEmailBindConditon)); break; case MiicGetBackTypeSetting.Mobile: MiicCondition mobileCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.Mobile), Value, DbType.String, MiicDBOperatorSetting.Equal); MiicCondition isMobileBindConditon = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.MobileBind), ((int)MiicYesNoSetting.Yes).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, mobileCondition)); condition.Add(new MiicConditionLeaf(isMobileBindConditon)); break; } if (LoginType == UserLoginTypeSetting.Friends) { MiicConditionCollections userTypeCondition = new MiicConditionCollections(MiicDBLogicSetting.And); MiicCondition user = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.UserType), ((int)UserTypeSetting.PersonUser).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, user)); MiicCondition administrator = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.UserType), ((int)UserTypeSetting.Administrator).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, administrator)); MiicCondition countryAdmin = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.UserType), ((int)UserTypeSetting.CountryAdmin).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, countryAdmin)); MiicCondition localAdmin = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.UserType), ((int)UserTypeSetting.LocalAdmin).ToString(), DbType.String, MiicDBOperatorSetting.Equal); userTypeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, localAdmin)); condition.Add(userTypeCondition); } else if (LoginType == UserLoginTypeSetting.Manage) { MiicCondition administrator = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <MiicSocialUserInfo, string>(o => o.UserType), ((int)UserTypeSetting.Administrator).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(administrator)); } return(condition); }