/// <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);
}
