public bool TryTestConn()
{
//err = string.Empty;
if (!string.IsNullOrEmpty(ConnName))
{
DalBase helper = DalCreate.CreateDal(ConnName);
try
{
helper.Con.Open();
Version = helper.Con.ServerVersion;
if (string.IsNullOrEmpty(Version)) { Version = helper.DataBaseType.ToString(); }
helper.Con.Close();
IsOK = true;
ErrorMsg = string.Empty;
}
catch (Exception er)
{
ErrorMsg = er.Message;
IsOK = false;
}
finally
{
helper.Dispose();
}
}
else
{
IsOK = false;
}
return IsOK;
}
private void Init(object procNameOrSql, string conn)
{
#region 分析是Sql或者存储过程
if (procNameOrSql != null)
{
if (procNameOrSql is Enum)
{
Type t = procNameOrSql.GetType();
string enumName = t.Name;
if (enumName != "ProcNames")
{
if (enumName.Length > 1 && enumName[1] == '_')
{
conn = enumName.Substring(2).Replace("Enum", "Conn");
}
else
{
string[] items = t.FullName.Split('.');
if (items.Length > 1)
{
conn = items[items.Length - 2] + "Conn";
items = null;
}
}
}
t = null;
}
_procName = procNameOrSql.ToString().Trim();
_isProc = _procName.IndexOf(' ') == -1;//不包含空格
}
#endregion
_conn = conn;
SetDbBase(DalCreate.CreateDal(conn));
}
private void Init(object procNameOrSql, string conn, bool isClearPara)
{
#region 分析是Sql或者存储过程
if (procNameOrSql != null)
{
if (string.IsNullOrEmpty(conn))
{
if (procNameOrSql is Enum)
{
conn = CrossDB.GetConnByEnum(procNameOrSql as Enum);
}
else if (procNameOrSql is String)
{
string fixName;
conn = CrossDB.GetConn(procNameOrSql.ToString(), out fixName);
}
}
_procName = procNameOrSql.ToString().Trim();
_isProc = _procName.IndexOf(' ') == -1;//不包含空格
}
#endregion
DalBase dalBase = null;
if (conn != null && dalHelper == null)
{
dalBase = DalCreate.CreateDal(conn);
}
SetDalBase(dalBase, isClearPara);
}
private static void SetDefault()
{
DbBase db = DalCreate.CreateDal(DefaultConn);
if (db != null)
{
_DefaultDataBase = db.DataBase;
_DefaultDalType = db.dalType;
db.Dispose();
}
}
internal DalBase ResetDalBase(string dbTableName)
{
if (IsOwnerOtherDb(dbTableName)) //是其它数据库名称。
{
if (_con.State != ConnectionState.Closed) //事务中。。创建新链接切换
{
string dbName = dbTableName.Split('.')[0];
return(DalCreate.CreateDal(GetConnString(dbName)));
}
}
return(this);
}
internal DbBase ResetDbBase(string dbTableName)
{
if (IsOwnerOtherDb(dbTableName))//是其它数据库名称。
{
string dbName = dbTableName.Split('.')[0];
if (_con.State != ConnectionState.Closed)//事务中。。创建新链接切换
{
return DalCreate.CreateDal(GetNewConn(dbName));
}
}
return this;
}
//public string TryTestConn()
//{
// string err;
// return TryTestConn(out err);
//}
public string TryTestConn()
{
string version = string.Empty;
//err = string.Empty;
if (!string.IsNullOrEmpty(Conn))
{
DbBase helper = DalCreate.CreateDal(Conn);
try
{
helper.Con.Open();
version = helper.Con.ServerVersion;
if (string.IsNullOrEmpty(version))
{
version = helper.dalType.ToString();
}
helper.Con.Close();
IsOK = true;
ErrorMsg = string.Empty;
}
catch (Exception er)
{
ErrorMsg = er.Message;
//err = er.Message;
IsOK = false;
}
finally
{
helper.Dispose();
}
}
else
{
IsOK = false;
}
return(version);
}
