public string GetAllUsers()
{
WeixinRobotLib.Entity.Linq.dbDataContext db = new WeixinRobotLib.Entity.Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings["LocalSQLServer"].ConnectionString);
// db.ObjectTrackingEnabled = false;
var source = (from ms in db.aspnet_Membership
join us in db.aspnet_Users on ms.UserId equals us.UserId
select new { us.UserId, us.UserName, ms.IsLockedOut }).ToList();
return(JsonConvert.SerializeObject(source));
}
public Boolean SetUserLock(string UserName, Boolean IsLockOut)
{
MembershipUser usr = System.Web.Security.Membership.GetUser(UserName);
if (IsLockOut == false)
{
return(usr.UnlockUser());
}
else
{
WeixinRobotLib.Entity.Linq.dbDataContext db = new WeixinRobotLib.Entity.Linq.dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings["LocalSQLServer"].ConnectionString);
//db.ObjectTrackingEnabled = false;
WeixinRobotLib.Entity.Linq.aspnet_Users aspnet_Users = db.aspnet_Users.SingleOrDefault(t => t.UserId == new Guid(usr.ProviderUserKey.ToString()));
aspnet_Users.aspnet_Membership.IsLockedOut = true;
db.SubmitChanges();
return(true);
}
}
