//预处理命令
private bool PrepareCommand(BeyonDBCommand cmd, BeyonDBConnection conn, ref BeyonDBTransaction trans, bool useTrans, CommandType cmdType, string cmdText, params IDataParameter[] cmdParms)
{
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.Connection = conn;
cmd.CommandText = cmdText;
if (useTrans)
{
//启动事务，关联事务
trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
cmd.Transaction = trans;
}
cmd.CommandType = cmdType;
if (cmdParms != null)
{
foreach (BeyonDBParameter p in cmdParms)
{
cmd.Parameters.Add(p);
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
//测试数据库是否成功连接
public bool DetectDBConnectState()
{
using (BeyonDBConnection conn = new BeyonDBConnection(ConnectString))
{
try
{
//打开连接
conn.Open();
return(true);
}
catch (Exception ex)
{
//捕捉异常，不作其他处理
string str = ex.ToString();
return(false);
}
}
}