/// <summary>
/// 执行 非查询 sql语句（插入，删除，修改等）
/// </summary>
/// <param name="strSql">sql语句</param>
/// <returns>返回命令影响行数 返回-1时命令出错</returns>
public static int ExecuteNonQuery(String strSql, SqlConnection cnn)
{
SqlCommand cmd = new SqlCommand(strSql, cnn);
int nReturn = -1;
try
{
cnn.Open();
nReturn = cmd.ExecuteNonQuery();
}
catch (SqlException e)
{
GLog.LogError("ExecuteNonQuery", e);
}
finally
{
cnn.Close();
cnn = null;
}
return(nReturn);
}
/// <summary>
/// 执行 非查询 sql语句（插入，删除，修改等）
/// </summary>
/// <param name="strSql">sql语句</param>
/// <param name="cmdType">命令字符串类型，如text,StoredProcedure</param>
/// <param name="cmdParms">命令执行参数</param>
/// <returns>返回命令影响行数 返回-1时命令出错</returns>
public static int ExecuteNonQuery(String strSql, CommandType cmdType, SqlParameter[] cmdParms, SqlConnection cnn)
{
SqlCommand cmd = PrepareCommand(cnn, null, cmdType, strSql, cmdParms);
int nReturn = -1;
try
{
cnn.Open();
nReturn = cmd.ExecuteNonQuery();
}
catch (SqlException e)
{
GLog.LogError("ExecuteNonQuery", e);
}
finally
{
cnn.Close();
cnn = null;
}
return(nReturn);
}
/// <summary>
/// 执行返回查询第一行第一列内容命令
/// </summary>
/// <param name="strSql">sql语句</param>
/// <returns>返回查询结果中的第一行第一列</returns>
public static object ExecuteScalar(String strSql, SqlConnection cnn)
{
SqlCommand cmd = new SqlCommand(strSql, cnn);
object oReturn = null;
try
{
cnn.Open();
oReturn = cmd.ExecuteScalar();
}
catch (SqlException e)
{
GLog.LogError("ExecuteScalar", e);
}
finally
{
cnn.Close();
cnn = null;
}
return(oReturn);
}
/// <summary>
/// 执行返回查询第一行第一列内容命令
/// </summary>
/// <param name="strSql">sql语句</param>
/// <param name="cmdType">命令字符串类型，如text,StoredProcedure</param>
/// <param name="cmdParms">命令执行参数</param>
/// <returns>返回查询结果中的第一行第一列</returns>
public static object ExecuteScalar(String strSql, CommandType cmdType, SqlParameter[] cmdParms, SqlConnection cnn)
{
SqlCommand cmd = PrepareCommand(cnn, null, cmdType, strSql, cmdParms);
object oReturn = null;
try
{
cnn.Open();
oReturn = cmd.ExecuteScalar();
}
catch (SqlException e)
{
GLog.LogError("ExecuteScalar", e);
}
finally
{
cnn.Close();
cnn = null;
}
return(oReturn);
}
/// <summary>
/// 执行查询命令，尽量不要使用此函数
/// </summary>
/// <param name="strSql">sql语句</param>
/// <returns>返回SqlDataReader</returns>
public static SqlDataReader ExecuteReader(String strSql, SqlConnection cnn)
{
SqlCommand cmd = new SqlCommand(strSql, cnn);
SqlDataReader oReader = null;
try
{
cnn.Open();
oReader = cmd.ExecuteReader(CommandBehavior.CloseConnection | CommandBehavior.SequentialAccess);
}
catch (SqlException e)
{
GLog.LogError("ExecuteReader", e);
}
catch (Exception e)
{
GLog.LogError("ExecuteReader", e);
}
finally
{
}
return(oReader);
}
