public Olb_User GetLoginerByMd5Cookie(string md5Cookie) { Olb_User dbinfo = null; LoginerInfo info = LoginerManageHelper.getInstance().List.Where(p => p.Md5Key == md5Cookie).SingleOrDefault(); if (info != null && info.OperID != null && info.OperID != string.Empty) { DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString); dbinfo = dd.GetTable <Olb_User>().Where(p => p.Account == info.OperID).SingleOrDefault(); } return(dbinfo); }
public CompanyOperator GetLoginerByMd5Cookie(string md5Cookie) { CompanyOperator dbinfo = null; LoginerInfo info = LoginerManageHelper.getInstance().List.Where(p => p.Md5Key == md5Cookie).SingleOrDefault(); if (info != null && info.OperID != null && info.OperID != string.Empty) { string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"]; //Linq to SQL 上下文对象 DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString); dbinfo = dd.GetTable <CompanyOperator>().Where(p => p.CompanyID == info.Company && p.OperID == info.OperID).SingleOrDefault(); //账号已停用 if (dbinfo.State != null && dbinfo.State.ToString() == "1") { LoginerManageHelper.getInstance().Semaphore.WaitOne(); LoginerManageHelper.getInstance().List.RemoveAll(p => p.Md5Key == md5Cookie); LoginerManageHelper.getInstance().Semaphore.Release(); dbinfo = null; } } return(dbinfo); }