办公用品管理系统

S1总复习(3)办公用品管理系统

Dbhelper 文件见S1总复习(2)手机信息管理系统

数据库操作

主界面

界面

代码

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 frmMain
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void 记录录入ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            recordEntry recordEntry = new recordEntry();
            recordEntry.Show();
            recordEntry.MdiParent = this;
        }

        private void 记录查询ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            query query = new query();
            query.Show();
            query.MdiParent = this;
        }

        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

添加窗口

界面

代码

using System;
using System.Windows.Forms;

namespace frmMain
{
    public partial class recordEntry : Form
    {
        public recordEntry()
        {
            InitializeComponent();
        }

        private void btnEmpty_Click(object sender, EventArgs e)
        {
            txtGoods.Text = "";
            txtDate.Text = "";
            txtNum.Text = "";
            txtReason.Text = "";
            txtMan.Text = "";
        }

        private void btnYes_Click(object sender, EventArgs e)
        {

            //接送文本框中的值
            //物品
            String goods = txtGoods.Text;
            //数量
            String num = txtNum.Text;
            //时间
            String date = txtDate.Text;
            //用途
            String reason = txtReason.Text;
            //员工
            String man = txtMan.Text;
            
            //非空验证
            if (goods.Length == 0 && num.Length == 0 && date.Length == 0 && reason.Length == 0 && man.Length == 0) 
            {
                MessageBox.Show("所有文本框不能为空，请认真填写！");
                return;
            }
            else if (goods.Length == 0 || num.Length == 0 || date.Length == 0 || reason.Length == 0 || man.Length == 0)
            {
                MessageBox.Show("文本框不能为空，请认真填写！");
                return;
            }

            //新建sql语句
            String sql = String.Format("insert into Record values ('{0}','{1}','{2}','{3}','{4}');",goods,num,date,reason,man);
            
            //调用帮手
            DbHelper helper = new DbHelper();
            
            //让帮手干活
            int update = helper.update(sql);

            if (update > 0)
            {
                MessageBox.Show("提交成功!");
            }
            else
            {
                MessageBox.Show("提交失败！");
            }
            this.Close();
        }

        private void btnNo_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

查询窗口

界面

代码

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

namespace frmMain
{
    public partial class query : Form
    {

        public query()
        {
            InitializeComponent();
        }

        private void query_Load(object sender, EventArgs e)
        {
            //关闭空行
            dataGridView1.AllowUserToAddRows = false;
            //关闭自动生成列
            dataGridView1.AutoGenerateColumns = false;

            //绑定数据
            //新建 sql 语句
            String sql = "select * from Record;";
            
            //调用帮手
            DbHelper helper = new DbHelper();
            
            //让帮手干活
            DataTable dt = helper.getTable(sql);

            dataGridView1.DataSource = dt;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //调用帮手
            DbHelper helper = new DbHelper();
            
            //提取文本框内容
            String query = txtQuery.Text;

            if (query.Length == 0)
            {
                String sqlAll = "select * from Record";

                DataTable dt = helper.getTable(sqlAll);

                dataGridView1.DataSource = dt;
            }


            //sql语句
            String sql = "select * from Record";
            
            //让帮手干活
            DataSet ds = helper.getDataSet(sql);


            //新建查询
            //调用DataView
            DataView dv = new DataView(ds.Tables["table"]);

            String cond = String.Format("GoodsName like '%{0}%'",query);
            
            dv.RowFilter = cond;

            dataGridView1.DataSource = dv;

        }
    }
}