/// <summary>
/// 执行存数过程返回受影响的行数
/// </summary>
/// <param name="procName">存数过程名称</param>
/// <param name="output">要返回的参数名</param>
/// <param name="param_Direction"></param>
/// <param name="values">参数</param>
/// <returns></returns>
public static object ExecuteNonQuery(string procName, string output, ParameterDirection param_Direction, params SqlParameter[] values)
{
object res_obj = null;
try
{
Createcommand(procName, values);
cmd.Parameters[output].Direction = param_Direction;
result = cmd.ExecuteNonQuery();
if (result != 0)
{
res_obj = cmd.Parameters[output].Value;
}
}
catch (Exception e)
{
ErrorLog.WriteEntry(e);
//throw e;
}
finally
{
CloseConnection();
}
return(res_obj);
}
/// <summary>
/// 执行存储过程返回一个SqlDataReader
/// </summary>
/// <param name="procName">存数过程的名称</param>
/// <param name="values">参数</param>
/// <returns>SqlDataReader</returns>
public static SqlDataReader ExecuteReader(string procName, params SqlParameter[] values)
{
try
{
Createcommand(procName, values);
reader = cmd.ExecuteReader();
}
catch (Exception e)
{
ErrorLog.WriteEntry(e);
reader.Close();
//throw e;
}
return(reader);
}
/// <summary>
/// 执行带参数的T-SQL语句返回一个SqlDataReader
/// </summary>
/// <param name="values">参数</param>
/// <returns>SqlDataReader</returns>
public static SqlDataReader ExecuteReader(params SqlParameter[] values)
{
try
{
Createcommand(values);
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception e)
{
ErrorLog.WriteEntry(e);
reader.Close();
//throw e;
}
return(reader);
}
/// <summary>
/// 执行存储过程,并返回结果集的第一行第一列
/// </summary>
/// <param name="procName">存储过程的名称</param>
/// <param name="values">参数</param>
/// <returns>结果集的第一行第一列</returns>
public static object ExecuteScalar(string procName, params SqlParameter[] values)
{
try
{
Createcommand(procName, values);
obj = cmd.ExecuteScalar();
}
catch (Exception e)
{
ErrorLog.WriteEntry(e);
//throw e;
}
finally
{
CloseConnection();
}
return(obj);
}
/// <summary>
/// 执行查询并返回结果集的第一行第一列
/// </summary>
/// <returns></returns>
public static object ExecuteScalar()
{
try
{
Createcommand();
obj = cmd.ExecuteScalar();
}
catch (Exception e)
{
ErrorLog.WriteEntry(e);
//throw e;
}
finally
{
CloseConnection();
}
return(obj);
}
/// <summary>
/// 根据条件执行命令,返回受影响的行数,所有条件都可为null
/// </summary>
/// <param name="cmdType">命令类型,可为空</param>
/// <param name="trans">是否有回滚,可为空</param>
/// <param name="values">是否有参数,可为空</param>
/// <returns>受影响的行数</returns>
public static int ExecuteNonQuery(CommandType cmdType, SqlTransaction trans, params SqlParameter[] values)
{
try
{
Createcommand(cmdType, trans, values);
result = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
ErrorLog.WriteEntry(e);
//throw e;
}
finally
{
CloseConnection();
}
return(result);
}
/// <summary>
/// 执行存数过程返回受影响的行数?
/// </summary>
/// <param name="procName">存数过程名称</param>
/// <param name="values">参数</param>
/// <returns>受影响的行数</returns>
public static int ExecuteNonQuery(string procName, params SqlParameter[] values)
{
try
{
Createcommand(procName, values);
result = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
ErrorLog.WriteEntry(e);
//throw e;
}
finally
{
CloseConnection();
}
return(result);
}
/// <summary>
/// 执行T-SQL语句返回受影响的行数
/// </summary>
/// <returns>受影响的行数</returns>
public static int ExecuteNonQuery()
{
try
{
Createcommand();
result = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
ErrorLog.WriteEntry(e);
//throw e;
}
finally
{
CloseConnection();
}
return(result);
}
/// <summary>
/// 执行存储过程并返回一个DataTable
/// </summary>
/// <param name="procName">存储过程名称</param>
/// <param name="values">参数</param>
/// <returns>DataTable</returns>
public static DataTable GetDateSet(string procName, params SqlParameter[] values)
{
dataSet = new DataSet();
try
{
Createcommand(procName, values);
adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataSet);
}
catch (Exception e)
{
ErrorLog.WriteEntry(e);
//throw e;
}
finally
{
CloseConnection();
}
return(dataSet.Tables[0]);
}