/// <summary> /// /// </summary> /// <param name="dbVistor"></param> /// <param name="sqlCommand"></param> /// <param name="param"></param> /// <returns></returns> public string FirstRow(DataBaseVisitor dbVistor, string sqlCommand, SqlParameter[] param) { DataBase DB = new DataBase(); if (false == DB.Open()) DB.Open(); SqlCommand cmd = new SqlCommand(dbVistor.ExecSql(sqlCommand), DB.m_sqlCon); if (param != null) { foreach (SqlParameter parameter in param) cmd.Parameters.Add(parameter); } try { string DeptName = cmd.ExecuteScalar().ToString(); return DeptName; } catch (Exception ex) { throw new Exception(ex.Message); return null; } }
/// <summary> /// 返回DataReader /// </summary> /// <param name="dbVistor">访问类</param> /// <param name="prams">命令参数</param> /// <param name="GetReader">返回DataReader</param> /// <param name="sqlCommand">查询命令</param> public void GetDataReader(DataBaseVisitor dbVistor, SqlParameter[] prams, out SqlDataReader getReader, string sqlCommand) { try { if (false == Open() || null == dbVistor) { getReader = null; return; } SqlCommand comm = new SqlCommand(dbVistor.ExecSql(sqlCommand), m_sqlCon); if (prams != null) { foreach (SqlParameter parameter in prams) comm.Parameters.Add(parameter); } getReader = comm.ExecuteReader(); comm.Dispose(); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 用ExecuteNonQuery执行SQL语句(重载2) /// </summary> /// <param name="dbVistor">访问类</param> /// <param name="procName">查询命令</param> /// <param name="prams">命令参数</param> /// <returns>执行是否成功</returns> public bool TransactSql(DataBaseVisitor dbVistor, string sqlCommand, SqlParameter[] param, out int nReturnRows) { nReturnRows = 0; if ((false == Open()) || (null == dbVistor)) return false; SqlCommand cmd = new SqlCommand(dbVistor.ExecSql(sqlCommand), m_sqlCon); if (param != null) { foreach (SqlParameter parameter in param) cmd.Parameters.Add(parameter); } try { nReturnRows = cmd.ExecuteNonQuery(); Close(); return true; } catch (SqlException ex) { Close(); throw new Exception(ex.Message); return false; } }
/// <summary> /// 返回查询命令的DataDet /// </summary> /// <param name="dbVistor">访问类</param> /// <param name="sqlCommand">查询命令</param> /// <param name="tableName">返回TableName</param> /// <param name="nEffectRows">返回查询行数</param> /// <returns></returns> public DataSet ReturnDataSet(DataBaseVisitor dbVistor, string sqlCommand, string tableName, out int nEffectRows) { try { nEffectRows = 0; if ((false == Open()) || (null == dbVistor)) return null; SqlCommand comm = new SqlCommand(dbVistor.ExecSql(sqlCommand), m_sqlCon); SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = comm; DataSet sqlDS = new DataSet(); nEffectRows = sqlDA.Fill(sqlDS, tableName); return sqlDS; } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 返回查询命令的DataDet /// </summary> /// <param name="dbVistor">访问类</param> /// <param name="prams">命令参数</param> /// <param name="sqlCommand">查询命令</param> /// <param name="tableName">返回TableName</param> /// <param name="nEffectRows">返回查询行数</param> /// <returns>查询的数据集</returns> public DataSet ReturnDataSet(DataBaseVisitor dbVistor, string sqlCommand, string TableName, string WhereSql) { try { if ((false == Open()) || (null == dbVistor)) return null; SqlCommand comm = new SqlCommand(dbVistor.ExecSql(sqlCommand) + WhereSql, m_sqlCon); SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = comm; DataSet sqlDS = new DataSet(); sqlDA.Fill(sqlDS, TableName); return sqlDS; } catch (Exception ex) { throw new Exception(ex.Message); return null; } }
/// <summary> /// 返回查询命令的DataDet /// </summary> /// <param name="dbVistor">访问类</param> /// <param name="prams">命令参数</param> /// <param name="sqlCommand">查询命令</param> /// <param name="tableName">返回TableName</param> /// <param name="nEffectRows">返回查询行数</param> /// <returns>查询的数据集</returns> public DataSet ReturnDataSet(DataBaseVisitor dbVistor, SqlParameter[] param, string sqlCommand, string tableName, out int nEffectRows) { try { nEffectRows = 0; if ((false == Open()) || (null == dbVistor)) return null; SqlCommand comm = new SqlCommand(dbVistor.ExecSql(sqlCommand), m_sqlCon); if (param != null) { foreach (SqlParameter parameter in param) comm.Parameters.Add(parameter); } else { Close(); nEffectRows = 0; return null; } SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = comm; DataSet sqlDS = new DataSet(); nEffectRows = sqlDA.Fill(sqlDS, tableName); return sqlDS; } catch (Exception ex) { throw new Exception(ex.Message); return null; } }
/// <summary> /// 返回查询命令的DataDet /// </summary> /// <param name="dbVistor">访问类</param> /// <param name="prams">命令参数</param> /// <param name="sqlCommand">查询命令</param> /// <returns>查询的数据集</returns> public DataSet ReturnDataSet(DataBaseVisitor dbVistor, SqlParameter[] param, string sqlCommand) { if ((false == Open()) || (null == dbVistor)) return null; try { SqlCommand comm = new SqlCommand(dbVistor.ExecSql(sqlCommand), m_sqlCon); if (param != null) { foreach (SqlParameter parameter in param) comm.Parameters.Add(parameter); } SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = comm; DataSet sqlDS = new DataSet(); sqlDA.Fill(sqlDS, "EastTable"); return sqlDS; } catch (Exception ex) { throw new Exception(ex.Message); return null; } }