//预处理命令 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); } } }