/// <summary>
/// 执行返回查询第一行第一列内容命令
/// </summary>
/// <param name="strSql">sql语句</param>
/// <param name="cmdType">命令字符串类型，如text,StoredProcedure</param>
/// <param name="cmdParms">命令执行参数</param>
/// <returns>返回查询结果中的第一行第一列</returns>
public object ExecuteScalar(String strSql, CommandType cmdType, SqlParameter[] cmdParms)
{
SqlCommand cmd = SQLBase.PrepareCommand(m_cnn, m_oTransaction, cmdType, strSql, cmdParms);
object oReturn = null;
try
{
oReturn = cmd.ExecuteScalar();
}
catch (SqlException e)
{
throw e;
}
finally
{
}
return(oReturn);
}
/// <summary>
/// 执行 非查询 sql语句（插入，删除，修改等）
/// </summary>
/// <param name="strSql">sql语句</param>
/// <param name="cmdType">命令字符串类型，如text,StoredProcedure</param>
/// <param name="cmdParms">命令执行参数</param>
/// <returns>返回命令影响行数 返回-1时命令出错</returns>
public int ExecuteNonQuery(String strSql, CommandType cmdType, SqlParameter[] cmdParms)
{
SqlCommand cmd = SQLBase.PrepareCommand(m_cnn, m_oTransaction, cmdType, strSql, cmdParms);
int nReturn = -1;
try
{
nReturn = cmd.ExecuteNonQuery();
}
catch (SqlException e)
{
throw e;
}
finally
{
}
return(nReturn);
}
/// <summary>
/// 执行查询命令 根据Select SQL语句填充DataSet
/// </summary>
/// <param name="strSql">sql语句</param>
/// <param name="cmdType">命令字符串类型，如text,StoredProcedure</param>
/// <param name="cmdParms">命令执行参数</param>
/// <param name="table">需填充的DataSet</param>
/// <returns>返回DataSet中数据行数； 返回-1时查询命令出错</returns>
public int FillDataSet(String strSql, CommandType cmdType, SqlParameter[] cmdParms, DataSet dataset)
{
SqlDataAdapter da = new SqlDataAdapter();
int nRow = -1;
try
{
da.SelectCommand = SQLBase.PrepareCommand(m_cnn, m_oTransaction, cmdType, strSql, cmdParms);
nRow = da.Fill(dataset);
}
catch (SqlException e)
{
throw e;
}
finally
{
da.Dispose();
}
return(nRow);
}
