internal static IUser GetUser(string loginName, string safePwd) { try { DataTable dt = new DataContext().ExecuteDataTable(UnitOfWork.GetEAConnection(), "select top 1 * from AC_Operator ", ParameterBuilder.BuildParameters() .SafeAdd("LoginName", loginName) .SafeAdd("Password", safePwd)); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; return new User() { ID = dr["ID"].ToSafeString(), Name = dr["UserName"].ToSafeString(), UserType = (short)dr["UserType"], LoginName = dr["LoginName"].ToSafeString(), Theme = dr["Skin"].ToSafeString() ?? "Default", OrgID = dr["OwnerOrg"].ToSafeString() }; } } catch (Exception ex) { GlobalLogger.Error<Authorize>(string.Format("获取用户loginName={0}出错", loginName), ex); throw; } return null; }
public static string GetUerName(this string id) { DataContext dataContext = new DataContext(); IEAConnection conn = UnitOfWork.GetEAConnection(); object value = dataContext.ExecuteScalar(conn, string.Format("select top 1 UserName from AC_Operator where id='{0}'", id)); if (value == null) value = dataContext.ExecuteScalar(conn, string.Format("select top 1 UserName from AC_Operator where LoginName='{0}'", id)); return value.ToSafeString(); }
/// <summary> /// Ctor /// </summary> /// <param name="httpContext">HTTP context</param> /// <param name="customerService">Customer service</param> /// <param name="customerSettings">Customer settings</param> public FormsAuthenticationService(HttpContextBase httpContext) { this.httpContext = httpContext; this.expirationTimeSpan = FormsAuthentication.Timeout; this.dataContext = new DataContext(); }