保健品销售网站 三层架构/DataAccess/Operations.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace DBAccess
{
    public static class Operations//会被反复调用,因此定义为静态类
    {
        static SqlConnection myConn;
        static SqlCommand cmd;
        static SqlDataAdapter sda;
        static SqlDataReader sdr;
        static Operations()//实例化对象，构造函数自动调用
        {
            myConn = new SqlConnection();
            myConn.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
            cmd = new SqlCommand();
            cmd.Connection = myConn;
            sda = new SqlDataAdapter();
        }
        /// <summary>
        /// 用来执行insert、update和delete操作
        /// </summary>
        /// <param name="cmdText">存储过程(可移植性差)名称或SQL语句</param>
        /// <param name="cmdType">告诉数据库要执行的是存储过程还是SQl语句</param>
        /// <param name="names">存储过程的参数名所组成的数组</param>
        /// <param name="values">存储过程的参数值所组成的数组</param>
        /// <returns>影响的行数</returns>
        public static int ExecuteSQL(string cmdText, CommandType cmdType, string[] names, object[] values)
        {
            cmd.CommandText = cmdText;
            cmd.CommandType = cmdType;
            cmd.Parameters.Clear();
            if (names != null)//代表存储过程有参数
            {
                for (int i = 0; i < names.Length; i++)
                {
                    cmd.Parameters.AddWithValue(names[i], values[i]);
                }
            }
            if (myConn.State == ConnectionState.Closed)
            {
                myConn.Open();
            }
            int count = cmd.ExecuteNonQuery();//接受方法返回值
            myConn.Close();
            return count;
        }
        public static int ExecuteSQL(string cmdText, CommandType cmdType)//重载
        {
            cmd.CommandText = cmdText;
            cmd.CommandType = cmdType;
            cmd.Parameters.Clear();
            if (myConn.State == ConnectionState.Closed)
            {