（纯代码）基于C#-winform的书店采购管理系统的设计

最新推荐文章于 2023-09-26 13:45:43 发布
最新推荐文章于 2023-09-26 13:45:43 发布
阅读量1.4k 收藏 47
点赞数 7
分类专栏： 毕业设计 文章标签： 数据库 字符串 c# visual studio asp.net
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jiuka_/article/details/116750085
版权

（纯代码）基于C#-winform的书店采购管理系统的设计

Book.cs

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

namespace WindowsFormsApplication1
{
    class Book
    {
        private string bookid;

        public string Bookid
        {
            get { return bookid; }
            set { bookid = value; }
        }
        private string bookname;

        public string Bookname
        {
            get { return bookname; }
            set { bookname = value; }
        }
        private string languages;

        public string Languages
        {
            get { return languages; }
            set { languages = value; }
        }
        private string author;

        public string Author
        {
            get { return author; }
            set { author = value; }
        }
        private string price;

        public string Price
        {
            get { return price; }
            set { price = value; }
        }
        private string comment;

        public string Comment
        {
            get { return comment; }
            set { comment = value; }
        }
    }
}

BookData.cs

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WindowsFormsApplication1
{
    class BookData
    {
        private SqlConnection conn;
        private SqlCommand cmd;
        private SqlDataReader dr;
        public BookData()
        {
            //定义链接字符串
            string connString = DBConnect.connstring;
            //创建连接对象
            conn = new SqlConnection(connString); ;
            cmd = conn.CreateCommand();
        }
        //查询
        public List<Book> Select()
        {
            List<Book> list = new List<Book>();
            cmd.CommandText = "select * from bookinfo";
            conn.Open();

            dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    Book data = new Book();
                    data.Bookid = dr[0].ToString();
                    data.Bookname= dr[1].ToString();
                    data.Languages = dr[2].ToString();
                    data.Author = dr[3].ToString();
                    data.Price = dr[4].ToString();
                    data.Comment = dr[5].ToString();

                    list.Add(data);
                }
            }
            conn.Close();

            return list;
        }
        public Book Select(string bookid)
        {
            
            cmd.CommandText = "select * from bookinfo where bookid=@bookid";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@bookid",bookid);
            conn.Open();

            dr = cmd.ExecuteReader();
            Book data = new Book();
            if (dr.HasRows)
            {
                dr.Read();
                data.Bookid = dr[0].ToString();
                data.Bookname = dr[1].ToString();
                data.Languages = dr[2].ToString();
                data.Author = dr[3].ToString();
                data.Price = dr[4].ToString();
                data.Comment = dr[5].ToString();      
            }
            conn.Close();

            return data;
        }
        //删除
        public void Delete(string bookname1)
        {
            cmd.CommandText = "delete from bookinfo where bookname=@book";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@book", bookname1);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        //多条件查询
        public List<Book> Select(string bookid, string bookname, string languages, string author, string comment)
        {
            //做五个恒等条件
            string tj1 = " 1=1 ";
            string tj2 = " 1=1 ";
            string tj3 = " 1=1 ";
            string tj4 = " 1=1 ";
            string tj5 = " 1=1 ";
            //根据用户输入改变条件
            //用户输入了姓名
            if(bookid !="")
            {
                tj1 = " bookid like @bookid ";
            }
            //用户输入了班级
            if(bookname !="")
            {
                tj2 = " bookname = @bookname ";            
            }
            //用户输入了班级
            if (languages != "")
            {
                tj3 = " languages = @languages ";
            }
            //用户输入了班级
            if (author != "")
            {
                tj4 = " author = @author ";
            }
            //用户输入了班级
            if (comment != "")
            {
                tj5 = " comment = @comment ";
            }
            //拼接成完整的条件
            string tj = " where " + tj1 + " and " + tj2 + " and " + tj3 + " and " + tj4 + " and " + tj5;
            List<Book> list = new List<Book>();
            cmd.CommandText = "select * from bookinfo"+tj;
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@bookid","%"+bookid+"%");
            cmd.Parameters.AddWithValue("@bookname",bookname);
            cmd.Parameters.AddWithValue("@languages", languages);
            cmd.Parameters.AddWithValue("@author", author);
            cmd.Parameters.AddWithValue("@comment", comment);

            conn.Open();

            dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    Book data = new Book();
                    data.Bookid = dr[0].ToString();
                    data.Bookname = dr[1].ToString();
                    data.Languages = dr[2].ToString();
                    data.Author = dr[3].ToString();
                    data.Price = dr[4].ToString();
                    data.Comment = dr[5].ToString();

                    list.Add(data); 
                }
            }
            conn.Close();

            return list;
        }
        //修改
        public void Update(string bookid, string bookname, string languages, string author, string price, string comment)
        {
            cmd.CommandText = "update bookinfo set bookid=@bookid,bookname=@bookname,languages=@languages,author=@author,price=@price,comment=@comment where bookid = @bookid";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@bookid", bookid);
            cmd.Parameters.AddWithValue("@bookname", bookname);
            cmd.Parameters.AddWithValue("@languages", languages);
            cmd.Parameters.AddWithValue("@author", author);
            cmd.Parameters.AddWithValue("@price", price);
            cmd.Parameters.AddWithValue("@comment", comment);

            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        //添加
        public bool Add(string bookid, string bookname, string languages, string author, string price, string comment)
        {
            cmd.CommandText = "insert into bookinfo values(@bookid,@bookname,@languages,@author,@price,@comment)";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@bookid", bookid);
            cmd.Parameters.AddWithValue("@bookname", bookname);
            cmd.Parameters.AddWithValue("@languages", languages);
            cmd.Parameters.AddWithValue("@author", author);
            cmd.Parameters.AddWithValue("@price", price);
            cmd.Parameters.AddWithValue("@comment", comment);

            conn.Open();
            int n = cmd.ExecuteNonQuery();
            conn.Close();

            if (n > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
    }
}

DBConnect.cs

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace WindowsFormsApplication1
{
    class DBConnect
    {
        public static string connstring = ConfigurationManager.ConnectionStrings["WindowsFormsApplication1.Properties.Settings.BOOKConnectionString1"].ToString();
        //public static string connstring = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\BOOK.mdf;Integrated " +"Security=True;Connect Timeout=30";
    }
}

Loginid.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    class Loginid
    {
        public static string loginid = "";
        public static string role = "1";
    }
}

vip.cs

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

namespace WindowsFormsApplication1
{
    public class  Vip
    {
        private string vip_id;

        public string Vip_id
        {
            get { return vip_id; }
            set { vip_id = value; }
        }
        private string vip_name;

        public string Vip_name
        {
            get { return vip_name; }
            set { vip_name = value; }
        }
        private string id_card;

        public string Id_card
        {
            get { return id_card; }
            set { id_card = value; }
        }
        private string telephone;

        public string Telephone
        {
            get { return telephone; }
            set { telephone = value; }
        }
        private string vip_role;

        public string Vip_role
        {
            get { return vip_role; }
            set { vip_role = value; }
        }
    }
}

denglu.cs

denglu.cs设计

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class denglu : Form
    {
        
        public denglu()
        {
            InitializeComponent();

        }

        private void denglu_Load(object sender, EventArgs e)
        {

        }

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            zhuce Z = new zhuce(1); //显示注册面
            Z.Show();
            this.Hide();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string user_id, pass;
            bool flag = false;
            string flag1 = "False";
            user_id = textBox1.Text;
            pass = textBox2.Text;


            string connString = DBConnect.connstring;


            //string connString = "Data Source=WIN-UGHAI4S6Q72\\MSSQLSERVER1;Initial Catalog=BOOK;Integrated Security=True";
            


            SqlConnection con = new SqlConnection(connString);
            if (textBox1.Text == "")
                MessageBox.Show("用户名不能为空！", "提示");
            else if (textBox2.Text == "")
                MessageBox.Show("密码不能为空！", "提示");
            try //try...catch...异常处理语句
            {                
                con.Open();
                string sqlstring = "select * from userinfo where user_id='" + user_id + "'and password='" + pass + "'";
                //执行con对象的函数，返回一个SqlCommand类型的对象
                SqlCommand command = new SqlCommand(sqlstring, con); 
                
                //用cmd的函数执行语句，返回SqlDataReader对象thisReader,thisReader就是返回的结果集（也就是数据库中查询到的表数据）
                SqlDataReader thisReader = command.ExecuteReader();
                //判断用户名及密码是否正确，对flag进行赋值
                while (thisReader.Read())
                {
                    if ((thisReader.GetValue(0).ToString().Trim()) == (user_id.ToString().Trim()))
                    {
                        if (thisReader.GetValue(1).ToString().Trim() == pass.ToString().Trim())
                        {
                            flag = true;
                            Loginid.role = thisReader.GetValue(2).ToString().Trim();
                        }
                    }
                }
                con.Close();
               

            }
            catch (Exception ex2)
            {
                MessageBox.Show("连接远程SQL数据库发生错误：" + ex2.ToString(), "错误！");
            }

             try //try...catch...异常处理语句
            { 
            con.Open();
            string sqlstring1 = "select * from [user] where user_id='" + user_id + "'";
            //执行con对象的函数，返回一个SqlCommand类型的对象
            SqlCommand command1 = new SqlCommand(sqlstring1, con);

            //用cmd的函数执行语句，返回SqlDataReader对象thisReader,thisReader就是返回的结果集（也就是数据库中查询到的表数据）
            SqlDataReader thisReader1 = command1.ExecuteReader();
            //判断用户名是否有效，对flag1进行赋值
            while (thisReader1.Read())
            {
                flag1 = thisReader1[4].ToString().Trim();
            }
            con.Close();
            }
             catch (Exception ex2)
             {
                 MessageBox.Show("连接远程SQL数据库发生错误：" + ex2.ToString(), "错误！");
             }

            if (flag && flag1 == "True")
            {
                MessageBox.Show("登陆成功！");
                Loginid.loginid = this.textBox1.Text;
                mian C = new mian(); //显示主页面
                C.Show();
                this.Hide();
            }
            else if (flag==false)
            {
                MessageBox.Show("请检查你的用户名和密码!");
                textBox1.Focus();
            }
            else if (flag1=="False")
            {
                MessageBox.Show("你的账号无效!");
                textBox1.Focus();
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            System.Environment.Exit(0);
        }
    }
}

zhuce.cs

注册

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class zhuce : Form
    {
        private int bs;
        public zhuce()
        {
            InitializeComponent();
        }
        public zhuce(int strtext)
        {
            InitializeComponent();
            bs = strtext;
        }
        public void c()
        {
            textBox1.Text = "";
            textBox2.Text = "";

        }
        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "" | textBox2.Text == "")
            {
                MessageBox.Show("请输入完整信息");
                return;
            }
            ///LoginId不能为重复
            //定义链接字符串
            string connString = DBConnect.connstring;
            //创建连接对象
            SqlConnection conn = new SqlConnection(connString);
            //组合sql查询语句
            string sqlSelect = "select user_id from userinfo where user_id='" + textBox1.Text.Trim() + "'";
            SqlCommand cmd1 = new SqlCommand(sqlSelect, conn);
            //执行查询
            conn.Open();
            object result1 = cmd1.ExecuteScalar();
            //判断账号是否重复
            if (result1 != null)
            {
                MessageBox.Show("该账户已被注册");
                conn.Close();
                return;
            }
            conn.Close();


            //添加注册信息SQL语句
            string sql = "insert into userinfo(user_id,password,role)";
            sql += "values('{0}','{1}','{2}')";
            sql = string.Format(sql, textBox1.Text, textBox2.Text,"1");

            SqlCommand cmd = new SqlCommand(sql, conn);
            //打开连接
            conn.Open();
            //执行操作
            int reslt = cmd.ExecuteNonQuery();
            conn.Close();
            //清空输入
            c();
            //注册成功
            MessageBox.Show("注册成功");
            if (bs == 1)
            {
                denglu D = new denglu(); //显示登录面
                D.Show();
                this.Hide();
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (bs == 1)
            {
                denglu D = new denglu(); //显示登录面
                D.Show();
                this.Hide();
            }
            else
            {
                this.Hide();
            }
        }
    }
}

mian.cs

主界面

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class mian : Form
    {
        public mian()
        {
            InitializeComponent();
        }

        private void mian_Load(object sender, EventArgs e)
        {
            label1.Text = "当前账号：" + Loginid.loginid;
        }
   
        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            mian1 Z1 = new mian1(); //显示图书流通面
            Z1.Show();
            this.Hide();
        }

        private void toolStripButton2_Click(object sender, EventArgs e)
        {
            mian2_ Z2 = new mian2_(); //显示图书查询面
            Z2.Show();
            this.Hide();
        }

        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            mian3 Z3 = new mian3(); //显示图书管理面
            Z3.Show();
            this.Hide();
        }

        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            mian4 Z4 = new mian4(); //显示顾客管理面
            Z4.Show();
            this.Hide();
        }

        private void toolStripButton5_Click(object sender, EventArgs e)
        {
            mian5 Z5 = new mian5(); //显示采购管理面
            Z5.Show();
            this.Hide();
        }

        private void toolStripButton6_Click(object sender, EventArgs e)
        {
            mian6 Z6 = new mian6(); //显示设置面
            
            Z6.Show();
            this.Hide();
        }
    }
}

mian1.cs

添加

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class mian1 : Form
    {
        public mian1()
        {
            InitializeComponent();
        }
        //用来存储传递过来的主键值
        private string Bookid = "";
        //用来存储该类的对象
        private static mian1 xg = null;
        public mian1(string bookid)
        {
            InitializeComponent();
            this.Bookid = bookid;
        }
        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            mian1 Z1 = new mian1(); //显示图书流通面
            Z1.Show();
            this.Hide();
        }

        private void toolStripButton2_Click(object sender, EventArgs e)
        {
            mian2_ Z2 = new mian2_(); //显示图书查询面
            Z2.Show();
            this.Hide();
        }

        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            mian3 Z3 = new mian3(); //显示图书管理面
            Z3.Show();
            this.Hide();
        }

        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            mian4 Z4 = new mian4(); //显示顾客管理面
            Z4.Show();
            this.Hide();
        }

        private void toolStripButton5_Click(object sender, EventArgs e)
        {
            mian5 Z5 = new mian5(); //显示采购管理面
            Z5.Show();
            this.Hide();
        }

        private void toolStripButton6_Click(object sender, EventArgs e)
        {
            mian6 Z6 = new mian6(); //显示设置面
            Z6.Show();
            this.Hide();
        }

        private void mian1_Load(object sender, EventArgs e)
        {

        }
        //返回对象的方法
        public static mian1 NewXiuGai(string bookid)
        {
            if (xg == null || xg.IsDisposed)
            {
                xg = new mian1(bookid);
            }

            return xg;
        }

        private void button2_Click(object sender, EventArgs e)//修改
        {
            //获取数据
          
            string bookid = textBox1.Text;
            string bookname = textBox2.Text;
            string languages = textBox3.Text;
            string author = textBox4.Text;
            string price = textBox5.Text;
            string comment = textBox6.Text;

            BookData ida = new BookData();
            ida.Update(bookid, bookname, languages, author, price,comment);

            //this.Owner.Tag = 1;
            //给mian1的成员变量bs赋值
            mian3.bs = 1;
            this.Close();
        }

        private void button1_Click(object sender, EventArgs e)//添加
        {
            string bookid = textBox1.Text;
            string bookname = textBox2.Text;
            string languages = textBox3.Text;
            string author = textBox4.Text;
            string price = textBox5.Text;
            string comment = textBox6.Text;

           
            BookData ida = new BookData();
            ida.Add(bookid, bookname, languages, author, price, comment);

            //this.Owner.Tag = 1;
            mian3.bs = 1;
            this.Close();
        }

    }
}

mian2.cs

图书查询

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class mian2_ : WindowsFormsApplication1.mian
    {
        public mian2_()
        {
            InitializeComponent();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            
        }

        private void mian2__Load(object sender, EventArgs e)
        {
            // TODO:  这行代码将数据加载到表“bOOKDataSet1.bookinfo”中。您可以根据需要移动或删除它。
            this.bookinfoTableAdapter1.Fill(this.bOOKDataSet1.bookinfo);
           

        }
      
        private void label7_Click(object sender, EventArgs e)
        {

        }

        private void label10_Click(object sender, EventArgs e)
        {

        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)//查询
        {
            //取数据
            string bookid = textBox1.Text;
            string bookname = textBox2.Text;
            string languages = textBox3.Text;
            string author = textBox4.Text;
            string comment = textBox5.Text;
            //根据条件查询，结果交给datagirdview显示
            BookData da = new BookData();
            dataGridView1.DataSource = da.Select(bookid, bookname, languages, author, comment);
            dataGridView1.AutoGenerateColumns = false;


        }
        public void c()
        {
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";
        }
        private void button2_Click(object sender, EventArgs e)//清空
        {   
            //重置
         
            //清空输入
            c();
        }
    }
}

mian3.cs

图书管理

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class mian3 : WindowsFormsApplication1.mian
    {
        public static int bs = 0;
        public mian3()
        {
            InitializeComponent();
        }

        private void mian3_Load(object sender, EventArgs e)
        {
            // TODO:  这行代码将数据加载到表“bOOKDataSet1.bookinfo”中。您可以根据需要移动或删除它。
            this.bookinfoTableAdapter1.Fill(this.bOOKDataSet1.bookinfo);

            BookData da = new BookData();
            //绑定数据源
            dataGridView1.DataSource = da.Select();
            //取消自动显示列
            dataGridView1.AutoGenerateColumns = false;

            //取消选中第一行
            dataGridView1.ClearSelection();

        }

        private void button4_Click(object sender, EventArgs e) //删除
        {
            MessageBoxButtons btn = MessageBoxButtons.YesNoCancel;
            if (MessageBox.Show("确定要删除么？", "删除数据", btn) == DialogResult.Yes)
            {
                //取数据
                string bookname1 = textBox6.Text;
                BookData da = new BookData();
                if (textBox6.Text!="")
                    da.Delete(bookname1);
                else
                {
                    try
                    {
                        //取出选中行里面绑定的对象
                        Book data = dataGridView1.SelectedRows[0].DataBoundItem as Book;
                        da.Delete(data.Bookid);
                    }                               
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message.ToString());
                    }
                }


                dataGridView1.DataSource = da.Select();
            }
        }

        private void button1_Click(object sender, EventArgs e)//查询
        {
            //取数据
            string bookid = textBox1.Text;
            string bookname = textBox2.Text;
            string languages = textBox3.Text;
            string author = textBox4.Text;   
            string comment = textBox5.Text;
            //根据条件查询，结果交给datagirdview显示
            BookData da = new BookData();
            dataGridView1.DataSource = da.Select(bookid, bookname, languages, author, comment);
            dataGridView1.AutoGenerateColumns = false;
        }
        public void c()
        {
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";
           
        }
        private void button5_Click(object sender, EventArgs e)//清空条件
        {

            //清空输入
            c();
        }

        private void button2_Click(object sender, EventArgs e)//添加
        {
            //打出修改窗体
            mian1 tj = new mian1();
            //显示窗体
            tj.Show();
            //xg.Owner = this;
            //让修改窗体获得焦点
            tj.Focus();
        }

        private void button3_Click(object sender, EventArgs e)//修改
        {
            if (dataGridView1.SelectedRows.Count > 0)
            {
                //取出选中项的主键值
                Book data = dataGridView1.SelectedRows[0].DataBoundItem as Book;
                //打出修改窗体
                mian1 xg = mian1.NewXiuGai(data.Bookid);
                //显示窗体
                xg.Show();
                //xg.Owner = this;
                //让修改窗体获得焦点
                xg.Focus();
            }
            else
            {
                MessageBox.Show("没有选中任何项！");
            }
        }
        //时钟工具间隔执行的事件，刷新主窗体
        private void timer1_Tick(object sender, EventArgs e)
        {
            if (bs == 1)
            {
                BookData da = new BookData();
                dataGridView1.DataSource = da.Select();
                bs = 0;
            }
            //if (Convert.ToInt32(this.Tag) == 1)
            //{
            //    BookData da = new BookData();
            //    dataGridView1.DataSource = da.Select();
            //    this.Tag = 0;
            //}

        }

        private void textBox6_TextChanged(object sender, EventArgs e)
        {

        }

        private void label8_Click(object sender, EventArgs e)
        {

        }
    }
}

mian4.cs

销售管理

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class mian4 : WindowsFormsApplication1.mian
    {
        public mian4()
        {
            InitializeComponent();
        }

        private void mian4_Load(object sender, EventArgs e)
        {
            // TODO:  这行代码将数据加载到表“bOOKDataSet1.bookinfo”中。您可以根据需要移动或删除它。
            this.bookinfoTableAdapter1.Fill(this.bOOKDataSet1.bookinfo);
            // TODO:  这行代码将数据加载到表“bOOKDataSet1.pay”中。您可以根据需要移动或删除它。
            this.payTableAdapter1.Fill(this.bOOKDataSet1.pay);


        }

        private void button1_Click(object sender, EventArgs e)
        {

            //打出销售单窗体
            Form1 xs = new Form1();
            //显示窗体
            xs.Show();
          
            //xs.Owner = this;
            //让修改窗体获得焦点
            xs.Focus();
        }

        private void fillToolStripButton_Click(object sender, EventArgs e)
        {


        }

        private void button2_Click(object sender, EventArgs e)
        {

            //打出销售单窗体
            rj rj = new rj();
            //显示窗体
            rj.Show();
            rj.Focus();
        }
    }
}

mian5.cs

采购管理

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class mian5 : WindowsFormsApplication1.mian
    {
        public mian5()
        {
            InitializeComponent();
        }

        private void mian5_Load(object sender, EventArgs e)
        {
            // TODO:  这行代码将数据加载到表“bOOKDataSet1.bookinfo”中。您可以根据需要移动或删除它。
            this.bookinfoTableAdapter1.Fill(this.bOOKDataSet1.bookinfo);
            // TODO:  这行代码将数据加载到表“bOOKDataSet1.purchase”中。您可以根据需要移动或删除它。
            this.purchaseTableAdapter1.Fill(this.bOOKDataSet1.purchase);


        }

        private void button1_Click(object sender, EventArgs e)
        {
            //打出销售单窗体
            Form2 cg = new Form2();
            //显示窗体
            cg.Show();
            //xs.Owner = this;
            //让修改窗体获得焦点
            cg.Focus();
        }
    }
}

mian6.cs

系统管理

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class mian6 : WindowsFormsApplication1.mian
    {
        public mian6()
        {
            InitializeComponent();
           
        } 
        private void button1_Click(object sender, EventArgs e)
        {
            //打出顾客管理窗体
            Form3 gk = new Form3();
            //显示窗体
            gk.Show();
            //xs.Owner = this;
            //让修改窗体获得焦点
            gk.Focus();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //打出修改密码窗体
            Form4 xg = new Form4();
            //显示窗体
            xg.Show();
            //xs.Owner = this;
            //让修改窗体获得焦点
            xg.Focus();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            if (Loginid.role == "0")
            {
                //打出权限管理窗体
                Form5 qx = new Form5();
                //显示窗体
                qx.Show();
                //xs.Owner = this;
                //让修改窗体获得焦点
                qx.Focus();
            }
            else
            {
                MessageBox.Show("当前账号无权限打开");
                return;
            }

        }
    }
}

Form1.cs

销售单

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private SqlConnection conn;
        private SqlCommand cmd;

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {

        }

        public bool Add(string paycode, string bookid, string bookname, string vip_id, DateTime pay_date, string price, string num, string id)
        {
            int n=0;
            try //try...catch...异常处理语句
            {   //定义链接字符串
                string connString = DBConnect.connstring;
                //创建连接对象
                conn = new SqlConnection(connString);
                cmd = conn.CreateCommand();
            }
            catch (Exception ex2)
            {
                MessageBox.Show("连接远程SQL数据库发生错误：" + ex2.ToString(), "错误！");
            }
            try
            {
                cmd.CommandText = "insert into pay values(@paycode,@bookid,@bookname,@vip_id,@pay_date,@price,@num,@id)";
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@paycode", paycode);
                cmd.Parameters.AddWithValue("@bookid", bookid);
                cmd.Parameters.AddWithValue("@bookname", bookname);
                cmd.Parameters.AddWithValue("@vip_id", vip_id);
                cmd.Parameters.AddWithValue("@pay_date", pay_date);
                cmd.Parameters.AddWithValue("@price", price);
                cmd.Parameters.AddWithValue("@num", num);
                cmd.Parameters.AddWithValue("@id", id);
                conn.Open();
                n = cmd.ExecuteNonQuery();
                conn.Close();
                
            }
            catch (Exception ex2)
            {
                MessageBox.Show("销售单添加发生错误：" + ex2.ToString(), "错误！");
            }
            if (n > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string paycode = textBox1.Text;
            string bookid = textBox2.Text;
            string bookname = textBox3.Text;
            string vip_id = textBox4.Text;
            DateTime pay_date = Convert.ToDateTime(dateTimePicker1.Text);
            string price = textBox5.Text;
            string num = textBox6.Text;
            string id = textBox7.Text; 
            Add(paycode,bookid, bookname, vip_id, pay_date, price, num,id);
           
            
            //this.Owner.Tag = 1;
            this.Close();
        }
    }
}

Form2.cs

采购单

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
        }
        private SqlConnection conn;
        private SqlCommand cmd;
        public bool Add(string purchase_id, string bookid, string bookname, string number, string id, string id_end)
        {
            int n = 0;
            try //try...catch...异常处理语句
            {   //定义链接字符串
                string connString = DBConnect.connstring;
                //创建连接对象
                conn = new SqlConnection(connString);
                cmd = conn.CreateCommand();
            }
            catch (Exception ex2)
            {
                MessageBox.Show("连接远程SQL数据库发生错误：" + ex2.ToString(), "错误！");
            }
            try
            {
                cmd.CommandText = "insert into purchase values(@purchase_id,@bookid,@bookname,@number,@id,@id_end)";
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@purchase_id", purchase_id);
                cmd.Parameters.AddWithValue("@bookid", bookid);
                cmd.Parameters.AddWithValue("@bookname", bookname);
                cmd.Parameters.AddWithValue("@number", number);
                cmd.Parameters.AddWithValue("@id", id);
                cmd.Parameters.AddWithValue("@id_end", id_end);
                conn.Open();
                n = cmd.ExecuteNonQuery();
                conn.Close();
            }
            catch (Exception ex2)
            {
                MessageBox.Show("采购单添加发生错误：" + ex2.ToString(), "错误！");
            }
            if (n > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string purchase_id = textBox1.Text;
            string bookid = textBox2.Text;
            string bookname = textBox3.Text;
            string number = textBox4.Text;
            string id = textBox5.Text;
            string id_end = textBox6.Text;
            //BookData ida = new BookData();
            Add(purchase_id, bookid, bookname, number, id, id_end);
            //this.Owner.Tag = 1;
            this.Close();
        }
    }
}

Form3.cs

顾客管理

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form3 : Form
    {
        private SqlConnection conn;
        private SqlCommand cmd;
        private SqlDataReader dr;
        public Form3()
        {
            InitializeComponent();

            //定义链接字符串
            string connString = DBConnect.connstring;
            //创建连接对象
            conn = new SqlConnection(connString); 
            cmd = conn.CreateCommand();
        
        }
        private void Form3_Load(object sender, EventArgs e)
        {
            // TODO:  这行代码将数据加载到表“bOOKDataSet1.vip”中。您可以根据需要移动或删除它。
            this.vipTableAdapter1.Fill(this.bOOKDataSet1.vip);


        }
        //删除
        public void Delete(string vip_id)
        {
            cmd.CommandText = "delete from vip where vip_id=@vip_id";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@vip_id", vip_id);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        //多条件查询
        public List<Vip> Select(string vip_id, string vip_name, string id_card, string telephone, string vip_role)
        {
            
            //做五个恒等条件
            string tj1 = " 1=1 ";
            string tj2 = " 1=1 ";
            string tj3 = " 1=1 ";
            string tj4 = " 1=1 ";
            string tj5 = " 1=1 ";
            //根据用户输入改变条件
            //用户输入了姓名
            if (vip_id != "")
            {
                tj1 = " vip_id like @vip_id ";
            }
            //用户输入了班级
            if (vip_name != "")
            {
                tj2 = " vip_name = @vip_name ";
            }
            //用户输入了班级
            if (id_card != "")
            {
                tj3 = " id_card = @id_card ";
            }
            //用户输入了班级
            if (telephone != "")
            {
                tj4 = " telephone = @telephone ";
            }
            //用户输入了班级
            if (vip_role != "")
            {
                tj5 = " vip_role = @vip_role ";
            }
            //拼接成完整的条件
            string tj = " where " + tj1 + " and " + tj2 + " and " + tj3 + " and " + tj4 + " and " + tj5;
            List<Vip> list = new List<Vip>();
            cmd.CommandText = "select * from vip" + tj;
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@vip_id", "%" + vip_id + "%");
            cmd.Parameters.AddWithValue("@vip_name", vip_name);
            cmd.Parameters.AddWithValue("@id_card", id_card);
            cmd.Parameters.AddWithValue("@telephone", telephone);
            cmd.Parameters.AddWithValue("@vip_role", vip_role);

            conn.Open();

            dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    Vip data = new Vip();
                    data.Vip_id = dr[0].ToString();
                    data.Vip_name = dr[1].ToString();
                    data.Id_card = dr[2].ToString();
                    data.Telephone = dr[3].ToString();
                    data.Vip_role = dr[4].ToString();
                    
                    list.Add(data);
                }
            }
            conn.Close();

            return list;
           
        }
        //修改
        public void Update(string vip_id, string vip_name, string id_card, string telephone, string vip_role)
        {
            cmd.CommandText = "update vip set vip_id=@vip_id,vip_name=@vip_name, id_card=@id_card,telephone=@telephone,vip_role=@vip_role where vip_id = @vip_id";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@vip_id", vip_id);
            cmd.Parameters.AddWithValue("@vip_name", vip_name);
            cmd.Parameters.AddWithValue("@id_card", id_card);
            cmd.Parameters.AddWithValue("@telephone", telephone);
            cmd.Parameters.AddWithValue("@vip_role", vip_role);
           

            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        //添加
        public bool Add(string vip_id, string vip_name, string id_card, string telephone, string vip_role)
        {
            cmd.CommandText = "insert into vip values(@vip_id,@vip_name,@id_card,@telephone,@vip_role)";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@vip_id", vip_id);
            cmd.Parameters.AddWithValue("@vip_name", vip_name);
            cmd.Parameters.AddWithValue("@id_card", id_card);
            cmd.Parameters.AddWithValue("@telephone", telephone);
            cmd.Parameters.AddWithValue("@vip_role", vip_role);
            conn.Open();
            int n = cmd.ExecuteNonQuery();
            conn.Close();

            if (n > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        private void button1_Click(object sender, EventArgs e)//查询
        {
            //取数据
            string vip_id = textBox1.Text;
            string vip_name = textBox2.Text;
            string id_card = textBox3.Text;
            string telephone = textBox4.Text;
            string vip_role = textBox5.Text;
            //根据条件查询，结果交给datagirdview显示

            dataGridView1.DataSource = Select(vip_id,vip_name,id_card,telephone,vip_role);
            dataGridView1.AutoGenerateColumns = false;
        }

        private void button2_Click(object sender, EventArgs e)//添加
        {
            string vip_id = textBox1.Text;
            string vip_name = textBox2.Text;
            string id_card = textBox3.Text;
            string telephone = textBox4.Text;
            string vip_role = textBox5.Text;
            Add(vip_id, vip_name, id_card, telephone, vip_role);
        }

        private void button3_Click(object sender, EventArgs e)//修改
        {
            string vip_id = textBox1.Text;
            string vip_name = textBox2.Text;
            string id_card = textBox3.Text;
            string telephone = textBox4.Text;
            string vip_role = textBox5.Text;
            Update(vip_id, vip_name, id_card, telephone, vip_role);
        }

        private void button4_Click(object sender, EventArgs e)//删除
        {
            string vip_id = textBox1.Text;

            Delete(vip_id);
        }
        public void c()
        {
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";

        }
        private void button5_Click(object sender, EventArgs e)//清空
        {
            c();
        }
    }
}

Form4.cs

修改密码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form4 : Form
    {
        private SqlConnection conn;
        private SqlCommand cmd;
        public Form4()
        {
            InitializeComponent();
            //定义链接字符串
            string connString = DBConnect.connstring;
            //创建连接对象
            conn = new SqlConnection(connString); ;
            cmd = conn.CreateCommand();
            
        }
 
        private void label1_Click(object sender, EventArgs e)
        {

        }
        public void c()
        {
            textBox1.Text = "";
            textBox2.Text = "";

        }

        private void Form4_Load(object sender, EventArgs e)
        {
            //denglu frm1 = (denglu)this.Owner;
            label1.Text = "当前账号：" + Loginid.loginid;
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string password1 = textBox1.Text;
            string password2 = textBox2.Text;
            string user_id = Loginid.loginid;
            if (textBox1.Text == "" | textBox2.Text == "")
            {
                MessageBox.Show("请输入完整信息");
                return;
            }
            if (textBox1.Text == textBox2.Text)
            {
                cmd.CommandText = "update userinfo set password=@password where user_id = @user_id";
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@user_id", user_id);
                cmd.Parameters.AddWithValue("@password", password1);
                conn.Open();
                cmd.ExecuteNonQuery();
                conn.Close();
                MessageBox.Show("修改成功");
                return;
            }
            else
            {
                MessageBox.Show("密码不一致");
                return;
            }
        }


    }
}

Form5.cs

权限管理

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form5 : Form
    {
        private SqlConnection conn;
        private SqlCommand cmd;
        private SqlDataReader dr;
        private string password = "";
        private string role = "";
        private string status = "";
        private int bs = 0;
        public Form5()
        {
            InitializeComponent();
            //定义链接字符串
            string connString = DBConnect.connstring;
            //创建连接对象
            conn = new SqlConnection(connString);
            cmd = conn.CreateCommand();
        }

        private void Form5_Load(object sender, EventArgs e)
        {
            // TODO:  这行代码将数据加载到表“bOOKDataSet1.user”中。您可以根据需要移动或删除它。
            this.userTableAdapter.Fill(this.bOOKDataSet1.user);
           
            groupBox1.Text = "当前账号：" + Loginid.loginid ;
        }
        //删除
        public void Delete(string id)
        {
            cmd.CommandText = "delete from [user] where id=@id";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@id", id);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        //修改
        public void Update(string id, string name, string user_id, string password, string status)
        {
            cmd.CommandText = "update [user] set id=@id,name=@name,user_id=@user_id,password=@password,status=@status where id = @id";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@id", id);
            cmd.Parameters.AddWithValue("@name", name);
            cmd.Parameters.AddWithValue("@user_id", user_id);
            cmd.Parameters.AddWithValue("@password", password);
            cmd.Parameters.AddWithValue("@status", status);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        //添加
        public bool Add(string id, string name, string user_id, string password, string status)
        {
            cmd.CommandText = "insert into [user] values(@id,@name,@user_id,@password,@status)";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@id", id);
            cmd.Parameters.AddWithValue("@name", name);
            cmd.Parameters.AddWithValue("@user_id", user_id);
            cmd.Parameters.AddWithValue("@password", password);
            cmd.Parameters.AddWithValue("@status", status);
            conn.Open();
            int n = cmd.ExecuteNonQuery();
            conn.Close();

            if (n > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        private void groupBox1_Enter(object sender, EventArgs e)
        {

        }

        private void button3_Click(object sender, EventArgs e)
        {
            if (Loginid.role=="0")
            {
                //打出信息表窗体
                user B = new user();
                //显示窗体
                B.Show();
                //xs.Owner = this;
                //让修改窗体获得焦点
                B.Focus();
            }
            else
            {
                MessageBox.Show("当前账号不是最高权限");
                return;
            }
        }

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            zhuce Z = new zhuce(2); //显示注册面
            Z.Show();
            //让修改窗体获得焦点
            Z.Focus();
        }

        private void button1_Click(object sender, EventArgs e)//确定
        {
            string user_id = comboBox1.Text.Trim();
            string id = textBox1.Text;
            string name = textBox2.Text;
            status = (radioButton1.Checked == true ? "1" : "0");
            if (textBox1.Text == "")
                MessageBox.Show("用户名不能为空！", "提示");
            else if (textBox2.Text == "")
                MessageBox.Show("密码不能为空！", "提示");
            cmd.CommandText = "select * from userinfo where user_id='" + user_id + "'";
            cmd.Parameters.Clear();
            conn.Open();
            dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                password = dr[1].ToString().Trim();
            }
            conn.Close();

            cmd.CommandText = "select id from [user] where user_id='" + user_id + "'";
            cmd.Parameters.Clear();
            conn.Open();
            object result1 = cmd.ExecuteScalar();
            //判断账号是否存在
            if (result1 != null)
                bs = 0;
            else
                bs = 1;
            conn.Close();
            if (bs==1)
                Add(id, name, user_id, password, status);
            else
                Update(id, name, user_id, password, status);
            
        }
        private void button2_Click(object sender, EventArgs e)
        {
        string id = textBox1.Text;
            Delete(id);
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            string user_id = comboBox1.Text.Trim();

            cmd.CommandText = "select * from userinfo where user_id='" + user_id + "'";
            cmd.Parameters.Clear();
            conn.Open();
            dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                role = dr[2].ToString().Trim();
            }
            conn.Close();
            if (role=="0")
                checkBox1.Checked = true;
            else if (role=="1")
            {
                checkBox1.Checked = false;
            }

            cmd.CommandText = "select * from [user] where user_id='" + user_id + "'";
            cmd.Parameters.Clear();
            conn.Open();
            dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                status = dr[4].ToString().Trim();
            }
            conn.Close();
            if (status == "True")
                radioButton1.Checked = true;
            else if (status == "False")
            {
                radioButton1.Checked = false;
                radioButton2.Checked = true;
            }
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            string user_id = comboBox1.Text.Trim();
            role = (checkBox1.Checked == true ? "0" : "1");
            cmd.CommandText = "update userinfo set role=@role where user_id='" + user_id + "'";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@role", role);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            string user_id = comboBox1.Text.Trim();
            if (bs==0)
            {
            role = (radioButton1.Checked == true ? "True" : "False");
            cmd.CommandText = "update [user] set status=@status where user_id='" + user_id + "'";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@status", status);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            }
        }
    }
}

user.cs

员工信息

rj.cs

日结统计

数据库表创建语句：

CREATE TABLE [dbo].[bookinfo] (
	[bookid] [nchar] (10) NOT NULL ,
	[bookname] [nvarchar] (50) NULL ,
	[languages] [nchar] (10) NULL ,
	[author] [nchar] (10) NULL ,
	[price] [nchar] (10) NULL ,
	[comment] [int] NULL 
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[pay] (
	[paycode] [nchar] (10) NOT NULL ,
	[bookid] [nchar] (10) NOT NULL ,
	[bookname] [nvarchar] (50) NOT NULL ,
	[vip_id] [nchar] (10) NOT NULL ,
	[pay_date] [datetime] NOT NULL ,
	[price] [nchar] (10) NOT NULL ,
	[num] [int] NOT NULL ,
	[id] [nchar] (10) NOT NULL 
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE trigger Tri3 on [dbo].[pay]
for insert
as
begin
declare @c char(10),@d int
select @c=bookid from inserted
select @d=num from inserted
update bookinfo
set comment=comment-@d
where bookid=@c
end



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE trigger [dbo].[Tri4] on [dbo].[pay]
for update
as
begin
declare @c1 char(10),@c2 char(10),@d1 int,@d2 int
select @c1=bookid from deleted
select @c2=bookid from inserted
select @d1=num from deleted
select @d2=num from inserted
if(@c1=@c2)
update bookinfo
set comment=comment-(@d2-@d1)
where bookid=@c1
else
update bookinfo
set comment=comment+@d1
where bookid=@c1
update bookinfo
set comment=comment-@d2
where bookid=@c2
end



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


CREATE TABLE [dbo].[purchase] (
	[purchase_id] [nchar] (10) NOT NULL ,
	[bookid] [nchar] (10) NOT NULL ,
	[bookname] [nvarchar] (50) NOT NULL ,
	[number] [int] NOT NULL ,
	[id] [nchar] (10) NOT NULL ,
	[id_end] [nchar] (10) NULL 
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE trigger Tri1 on [dbo].[purchase]
for insert
as
begin
declare @a char(10),@b int
select @a=bookid from inserted
select @b=number from inserted
update bookinfo
set comment=comment+@b
where bookid=@a
end


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE trigger [dbo].[Tri2] on [dbo].[purchase]
for update
as
begin
declare @a1 char(10),@a2 char(10),@b1 int,@b2 int
select @a1=bookid from deleted
select @a2=bookid from inserted
select @b1=number from deleted
select @b2=number from inserted
if(@a1=@a2)
update bookinfo
set comment=comment+(@b2-@b1)
where bookid=@a1
else
update bookinfo
set comment=comment-@b1
where bookid=@a1
update bookinfo
set comment=comment+@b2
where bookid=@a2
end


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


CREATE TABLE [dbo].[user] (
	[id] [nchar] (10) NOT NULL ,
	[name] [nchar] (10) NULL ,
	[user_id] [nchar] (10) NOT NULL ,
	[password] [nchar] (10) NULL ,
	[status] [bit] NOT NULL 
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[userinfo] (
	[user_id] [nchar] (10) NOT NULL ,
	[password] [nchar] (10) NULL ,
	[role] [int] NOT NULL 
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[vip] (
	[vip_id] [nchar] (10) NOT NULL ,
	[vip_name] [varchar] (50) NULL ,
	[id_card] [varchar] (50) NULL ,
	[telephone] [varchar] (50) NULL ,
	[vip_role] [int] NULL 
) ON [PRIMARY]
GO
jiuka_
关注
  • 7
    点赞
  • 踩
  • 47
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
简易C#商城系统
07-24
1、我们所提供的课程都配有字幕2、讲解的是按照开发项目的流程逐步讲解3、一步步讲解开发项目实战的流程4、从设计文档，到开发编码，最后到商城的前后端测试5、通过该项目能提高本身的项目管理经验6、了解更多的项目开发流程7、沉淀足够的项目经验
asp.net+c#药品超市进销存管理系统
专注分享bishe530的博客
05-12 499
在药品添加界面输入药品的，名称，规格，生产企业，生产日期，有效期，生产厂家，所在仓库药品相关信息之后点击确定即可添加信息成功再添加药品信息成功之后，通过点击药品信息管理，可以查看已经添加好的药品信息，同时还可对药品信息进行修改和删除的操作。随着时代的发展，药店对药品超市的管理提出了新的要求，传统的药品超市管理，已经不能够满足当前药店对药物的管理了，药物一般都拥有种类繁多， 价格不一，治疗功效不易，用法用量不同等特点，如何对这些琳琅满目的药物进行更加科学合理的管理，是很多药店的管理人员一直以为所关心的问题。
C#小型书店管理系统
QQwli的博客
01-19 5342
C#小型书店管理系统一、开发技术和环境二、系统设计三、系统实现1.注册登录2.管理3.查询4.录入修改5.删除6.销售7.管理员显示四、总结 一次非常简单的课程设计，资源链接如下： 课程设计源代码、论文：https://download.csdn.net/download/QQwli/14801274 一、开发技术和环境 （1）开发环境 开发系统：Windows 10操作系统； 开发工具：Visual Studio 2010 开发语言：C# （2）数据库 SQL Server (SQLEXPRESS) （3
基于C#-winform的书店采购管理系统的设计
jiuka_的博客
05-13 2222
基于C#-winform的书店采购管理系统的设计1开发工具简介2数据库设计3系统展示4功能模块5系统实现6Windows安装开发解决方案 本博客，主要记录我做毕业设计的各个步骤，分享下自己的心得，同时可以互相学习。 1开发工具简介 开发平台：windows 10 开发工具：visual studio 2013 数据库：SQL Server 2012 开发框架：.NET Framework4.0 建模工具：Visio 2013 Windows安装开发解决方案：InstallShield 2010 2数据库
采购管理系统C#WinForm编程
09-19
有登录和注册界面，功能简单。TreeView显示商品类型，DataGridView显示商品表内容。可以对商品进行编辑（增，删，改）。双击DataGridView中的任意字段，可以弹出对应记录的编辑窗体。
基于C#的Winform图书管理系统设计源码
最新发布
04-11
本源码提供了一个基于C#的Winform图书管理系统设计。项目包含129个文件，其中包括50个C#源文件、23个资源文件、23个资源文件、5个缓存文件、4个VSIDX文件、4个应用程序文件、4个EXE文件、3个清单文件、2个配置文件和...
基于 C# winform 的书店管理系统.zip
03-13
管理系统是一种通过计算机技术实现的用于组织、监控和控制各种活动的软件系统。这些系统通常被设计用来提高效率、减少错误、加强安全性，同时提供数据和信息支持。以下是一些常见类型的管理系统： 学校管理系统： ...
asp.net/net/c#电子购物商城系统-成品
热门推荐
csdn663648的博客
01-24 1万+
摘要 本文研究了一种基于数据关联规则的购物系统。其开发主要包括后台数据库的建立、后台管理和首页的网页设计。系统采用Microsoft c#作为ASP的核心语言。NET开发工具，使用Microsoft IIS 5.0建立运行环境，然后结合SQL Server 2000建立数据连接关系。利用其各个组成部分，在短时间内建立了数据库，并对数据库进行了分析和asp。 本计算机毕业设计asp.net/net/c#电子购物商城系统主要使用的法律系统开发生命周期(SDLC)系统开发生命周期和结构化方法(结构化的方法)来
C#编写WinForm窗体应用程序（第四期）
生产队的刘同学
02-25 4875
C#编写WinForm窗体应用程序（第四期） 文章目录C#编写WinForm窗体应用程序（第四期）C# RadioButton：单选按钮控件【实例】完成选择用户权限的操作，并在消息框中显示所选的权限名。C# CheckBox【实例】完成选择用户爱好的操作，并在消息框中显示所选的爱好。C# CheckedListBox【实例】使用复选列表框完成选购水果的操作。结束语 C# RadioButton：单选按钮控件 在 C# 语言中 RadioButton 是单选按钮控件，多个 RadioButton 控件可以为一
## C# winform DataGridView 实现的购物车
qq_40823894的博客
12-17 1527
C# winform界面实现的购物车，能根据所选的数据，实时算出工资和数量
C# 采购供应管理系统源码
11-18
有订单模块\货品采购模块\入仓和领料模块\报价模块;相当于一个强大的仓库管理系统,有问题请联系:QQ282647881
采购管理系统c#
05-31
用c#编写的采购管理系统，拥有全部的代码，是基于web开发的。
C#采购与库存管理系统
01-02
c#开发，把采购与库存管理相结合的一套系统，本人学生，这是学期末的课程设计，有所缺陷，请大家谅解！
一个ERP系统采购管理,出入库操作,销售管理,财务管理（C#源程序）
09-17
一个ERP系统采购管理,出入库操作,销售管理,财务管理（C#）包含源程序
VS2005+SQL2000C#采购管理系统
09-11
用C#写的采购管理系统，带数据库。直接附加即可。开发工具是VS2005+SQL2000，三层架构。是非常好的学习资料
WinForm无边框窗体：纯代码绘制标题栏及其控件，窗体四周阴影，可拖拽。可直接继承使用。
MissPuya的博客
04-09 2795
因WinForm本身的窗体界面太过传统，需要自定义标题栏部分时，又因修改难度较大或始终有点不理想，基于对于C#的热爱，只好选择动手纯代码绘制，所以记录了此文章，以作备用。1、当ShowCaption属性值为FALSE时，窗体为一个不含任何控件的四周阴影、可拖拽窗体。2、当ShowCaption属性值为TRUE时，窗体为一个包含标题栏的四周阴影、可拖拽窗体。此时鼠标仅在标题栏范围内按下才可进行窗体的拖拽操作。3、当窗体的MaximizeBox属性值为FALSE时，窗体的大小是不可调整的。默认值：false。
【附源码】购书服务系统的设计与实现695599【附源码】计算机毕设SSM
巧才计算机毕设
09-26 68
本章主要介绍购书服务系统的使用案例和系统的相关可行性要求。我已经从技术、经济、法律和运营四个方面确认了该系统可以在线运行。
java实现控制台购书系统
saber的博客
04-11 3689
面向对象实现相信看了对你理解更为透彻
【Java案例】基于控制台的购书系统
weixin_66697650的博客
01-12 1万+
（1）输出所有图书的信息：包括每本书的编号、书名、单价、库存。（2）顾客购买书时，根据提示输入购买书的数量。（3）购买完毕后输出顾客的订单信息，包括：订单号、订单明细、订单总额。
C#课件：医院住院管理系统.ppt
05-07
这篇文档详细介绍了基于C#编程语言和Winform技术，利用Visual Studio 2010开发环境，与SQL Server数据库配合构建的医院住院管理系统。该系统旨在提高医院住院部管理效率，提供对病人信息、病房信息、科室信息和职工...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值