public static void CreateSearchItem(ref StringBuilder sqlWhere, ref ParamsHelper parms, params string[] cols)
{
if (HttpContext.Current.User.IsInRole("Administrators") || HttpContext.Current.User.IsInRole("System"))
{
return;
}
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(500);
}
if (parms == null)
{
parms = new ParamsHelper();
}
var Profile = new CustomProfileCommon();
var upi = JsonConvert.DeserializeObject <UserProfileInfo>(Profile.UserInfo);
sqlWhere.Append("and AppCode = @AppCode ");
var parm = new SqlParameter("@AppCode", SqlDbType.Char, 6);
parm.Value = string.IsNullOrEmpty(upi.SiteCode) ? GlobalConfig.SiteCode : upi.SiteCode;
parms.Add(parm);
if (!string.IsNullOrEmpty(Profile.UserRule) && cols != null && !string.IsNullOrEmpty(cols[0]))
{
sqlWhere.AppendFormat("and CHARINDEX(convert(varchar(36),{0}),'{1}') > 0 ", cols[0], Profile.UserRule);
}
if (upi.SiteCode == "000000")
{
sqlWhere.Append("and UserId = @UserId ");
parm = new SqlParameter("@UserId", SqlDbType.UniqueIdentifier);
parm.Value = WebCommon.GetUserId();
parms.Add(parm);
}
}
public void SetMigrateAnonymous()
{
var userId = WebCommon.GetUserId();
IList <SiteMenusInfo> smis = new List <SiteMenusInfo>();
UserProfileInfo upi = new UserProfileInfo();
var userRule = string.Empty;
var menuBll = new SiteMenus();
var Profile = new CustomProfileCommon();
if (Roles.GetRolesForUser().Length == 0)
{
var guestRole = new SiteRoles().GetAspnetModel(Membership.ApplicationName, "guest");
string[] accessIds = { guestRole.Id.ToString() };
smis = menuBll.GetMenusAccess(Membership.ApplicationName, accessIds, false);
upi = new UserProfileInfo {
SiteCode = AppCode, SiteTitle = GlobalConfig.SiteTitle
};
}
else
{
var accessIds = new List <string>();
accessIds.Add(userId.ToString());
var roleIds = new SiteRoles().GetAspnetRoleIds(Membership.ApplicationName, Roles.GetRolesForUser());
foreach (var item in roleIds)
{
accessIds.Add(item.ToString());
}
var isAdmin = HttpContext.Current.User.IsInRole("Administrators");
Task[] tasks = new Task[3];
tasks[0] = Task.Factory.StartNew(() =>
{
var fuInfo = new FeatureUser().GetModel(userId, "UserProfile");
if (fuInfo != null)
{
upi.SiteCode = fuInfo.SiteCode;
upi.SiteTitle = fuInfo.SiteTitle;
upi.SiteLogo = string.IsNullOrWhiteSpace(fuInfo.SiteLogo) ? "" : WebCommon.GetSiteAppName() + fuInfo.SiteLogo;
upi.CultureName = fuInfo.CultureName;
}
else
{
if (isAdmin)
{
upi.SiteCode = GlobalConfig.SiteCode;
upi.SiteTitle = GlobalConfig.SiteTitle;
}
}
});
tasks[1] = Task.Factory.StartNew(() =>
{
smis = menuBll.GetMenusAccess(Membership.ApplicationName, accessIds.ToArray(), isAdmin);
});
tasks[2] = Task.Factory.StartNew(() =>
{
userRule = new Staff().GetUserRule(userId);
});
Task.WaitAll(tasks);
}
Profile.UserMenus = JsonConvert.SerializeObject(smis);
Profile.UserInfo = JsonConvert.SerializeObject(upi);
Profile.UserRule = userRule;
Profile.Save();
}