public Repository(string strConnection) { m_ctx = new DataContext(strConnection); DataLoadOptions dlo = new DataLoadOptions(); dlo.LoadWith<Artist>(c => c.Genre); m_ctx.LoadOptions = dlo; }
public static string UserLogin(string keyword, string password) { var userService = new Model.DataContext(); var account = userService.Users.First(a => a.UserName == keyword.Trim()); if (account != null) { var result = DeCrypt.VerifyPassWord(account.Password, password, account.Salt); if (!result) { return(null); } if (account.Token == null) { account.Token = Guid.NewGuid().ToString("N"); account.LastLoginTime = DateTime.Now; userService.Entry(account).State = EntityState.Modified; userService.SaveChanges(); } else { ////如果想实现同一账号同一时间只能一处登录,就用开放以下这段代码 //string key = prefixKey + account.Token; //MvcCore.Extensions.CacheExtensions.ClearCache(key); account.Token = Guid.NewGuid().ToString("N"); account.LastLoginTime = DateTime.Now; userService.Entry(account).State = EntityState.Modified; //MvcCore.Unity.Get<Data.Service.ISysDBTool>().Commit(); } var token = Login(account.Token); return(token); } return(null); }