2024.12.20（周五）

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace Database.Manipulation
{
    /**
     * 数据库操作类，对数据库查询、更新、删除等操作
     */
    class Manipulation
    {
        /**
         * 查询函数，返回 SqlDataReader 对象
         */
        public static SqlDataReader query(string queryLanguage, SqlConnection sqlConnection)
        {
            // 确保连接已经打开
            if (sqlConnection.State != ConnectionState.Open)
            {
                sqlConnection.Open();
            }

            // 创建并执行 SqlCommand
            SqlCommand command = new SqlCommand(queryLanguage, sqlConnection);
            return command.ExecuteReader();
        }

        /**
         * 更新函数，用于更新数据库的数据
         */
        public static Boolean update(string updateLanguage, SqlConnection sqlConnection)
        {
            try
            {
                // 确保连接已打开
                if (sqlConnection.State != ConnectionState.Open)
                {
                    sqlConnection.Open();
                }

                SqlCommand command = new SqlCommand(updateLanguage, sqlConnection);
                int n = command.ExecuteNonQuery();
                return n > 0; // 如果更新行数大于 0，则返回 true
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }
        }

        /**
         * 调用存储过程函数，插入数据
         */
        public static Boolean insertStoredProcedure(string strProcName, params object[] paraValues)
        {
            SqlConnection sqlConnection = Connect.Connect.connectSql();
            try
            {
                // 确保连接已打开
                if (sqlConnection.State != ConnectionState.Open)
                {
                    Connect.Connect.openSql(sqlConnection);
                }

                SqlCommand command = new SqlCommand(strProcName, sqlConnection);
                command.CommandType = CommandType.StoredProcedure;

                if (paraValues != null)
                {
                    command.Parameters.AddRange(paraValues);
                }

                return command.ExecuteNonQuery() > 0;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }
            finally
            {
                Connect.Connect.closeSql(sqlConnection);
            }
        }

        /**
         * 调用存储过程函数，得到数据
         */
        public static DataTable readStoredProcedure(string strProcName, params object[] paraValues)
        {
            SqlConnection sqlConnection = Connect.Connect.connectSql();
            DataTable data = new DataTable();
            try
            {
                // 确保连接已打开
                if (sqlConnection.State != ConnectionState.Open)
                {
                    Connect.Connect.openSql(sqlConnection);
                }

                SqlCommand command = new SqlCommand(strProcName, sqlConnection);
                command.CommandType = CommandType.StoredProcedure;

                if (paraValues != null)
                {
                    command.Parameters.AddRange(paraValues);
                }

                using (SqlDataAdapter adapter = new SqlDataAdapter(command))
                {
                    adapter.Fill(data);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                Connect.Connect.closeSql(sqlConnection);
            }

            return data;
        }

        /**
         * 调用存储过程函数，删除数据
         */
        public static Boolean deleteStoredProcedure(string strProcName, params object[] paraValues)
        {
            SqlConnection sqlConnection = Connect.Connect.connectSql();
            try
            {
                // 确保连接已打开
                if (sqlConnection.State != ConnectionState.Open)
                {
                    Connect.Connect.openSql(sqlConnection);
                }

                SqlCommand command = new SqlCommand(strProcName, sqlConnection);
                command.CommandType = CommandType.StoredProcedure;

                if (paraValues != null)
                {
                    command.Parameters.AddRange(paraValues);
                }

                return command.ExecuteNonQuery() > 0;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }
            finally
            {
                Connect.Connect.closeSql(sqlConnection);
            }
        }
    }
}