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