/// <summary> /// Data Source=*;Initial Catalog=*;Connect Timeout=0;Persist Security Info=True;User ID=*;Password=* /// </summary> /// <param name="connectionString">connectionString</param> public DBConnectParams(string connectionString) { if (string.IsNullOrEmpty(connectionString)) throw new Exception("Fail to get ConnectionString,Please check config file! "); else { MatchCollection matches = Regex.Matches(connectionString, @"(([^;=]+)=([^;=#]*))", RegexOptions.Compiled); if (!connectionString.ToLower().Contains("integrated security")) { foreach (Match m in matches) { switch (m.Groups[2].Value.ToLower().Trim()) { case "data source": case "server": this._server = m.Groups[3].Value; break; case "initial catalog": case "database": this._database = m.Groups[3].Value; break; case "user id": case "uid": this._userId = m.Groups[3].Value; break; case "password": this._password = m.Groups[3].Value; break; case "pwd": this._password = m.Groups[3].Value; break; } } if (string.IsNullOrEmpty(this._server) || string.IsNullOrEmpty(this._database) || string.IsNullOrEmpty(this._userId)) throw new Exception("Fail to get ConnectionString,Please check! "); this._verifyType = VerifyTypeEnum.Database; } else { foreach (Match m in matches) { switch (m.Groups[2].Value.ToLower().Trim()) { case "data source": case "server": this._server = m.Groups[3].Value; break; case "initial catalog": case "database": this._database = m.Groups[3].Value; break; } } if (string.IsNullOrEmpty(this._server) || string.IsNullOrEmpty(this._database)) throw new Exception("Fail to get ConnectionString,Please check! "); this._verifyType = VerifyTypeEnum.Windows; } } }
/// <summary> /// New with VerifyTypeEnum.Database /// </summary> /// <param name="strServer">servername</param> /// <param name="strDB">DataBase</param> /// <param name="strUserID">UserID</param> /// <param name="strPwd">UserPassword</param> public DBConnectParams(string strServer, string strDB, string strUserID, string strPwd) { this._verifyType = VerifyTypeEnum.Database; this._server = strServer; this._database = strDB; this._userId = strUserID; this._password = strPwd; }
/// <summary> /// New with VerifyTypeEnum.Windows /// </summary> /// <param name="strServer">serverName</param> /// <param name="strDB">database</param> public DBConnectParams(string strServer, string strDB) { this._verifyType = VerifyTypeEnum.Windows; this._server = strServer; this._database = strDB; }
/// <summary> /// New with Empty /// </summary> public DBConnectParams() { this._verifyType = VerifyTypeEnum.Windows; this._server = string.Empty; }
/// <summary> /// 获取验证信息 /// </summary> /// <param name="token"></param> /// <param name="type"></param> /// <returns></returns> public VerifyEntity GetVerifyInfo(string token, VerifyTypeEnum type) { return(_content.Verifies.Where(x => x.Token == token && x.Status == (int)VerifyStatusEnum.Normal && x.Type == (int)type).FirstOrDefault()); }
/// <summary> /// 获取验证信息 /// </summary> /// <param name="token"></param> /// <param name="type"></param> /// <returns></returns> public VerifyEntity GetVerifyInfo(string token, VerifyTypeEnum type) { return(_data.GetVerifyInfo(token, type)); }