/// <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;
}
}
