空气质量监测管理系统

S1总复习(5)空气质量监测管理系统

数据库操作

主表

从表

主窗口

主窗体

界面

代码

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 db1107121监测系统
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

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

        private void 录入监测数据ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //实例化添加窗口
            FromAdd fromAdd = new FromAdd();
            //设置子窗口
            fromAdd.MdiParent = this;
            //显示窗口
            fromAdd.Show();
        }

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

        private void 查询监测结果ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //实例化窗口
            fromQuery fromQuery = new fromQuery();
            //设置值子窗口
            fromQuery.MdiParent = this;
            //显示窗口
            fromQuery.Show();
        }
    }
}

添加窗口

界面

代码

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

namespace db1107121监测系统
{
    public partial class FromAdd : Form
    {
        public FromAdd()
        {
            InitializeComponent();
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            //窗口关闭
            this.Close();
        }

        private void btnEmpty_Click(object sender, EventArgs e)
        {
            //清空文本
            txtName.Text = "";
            txtBeCareful.Text = "";
            txtPM.Text = "";
        }

        private void FromAdd_Load(object sender, EventArgs e)
        {
            //加载组合框
            CbLoad();
        }

        private void CbLoad()
        {
            //调用帮手
            DbHelper helper = new DbHelper();

            //新建 sql 语句
            String sql = "select * from StationInfo";

            //让帮手干活
            DataTable dt = helper.getTable(sql);

            //设置显示值
            cbMonitoring.DisplayMember = "StationName";
            //设置实际值
            cbMonitoring.ValueMember = "StationID";
            //绑定数据源
            cbMonitoring.DataSource = dt;
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            //调用帮手
            DbHelper helper = new DbHelper();

            //获取值
            //文本 
            String name = txtName.Text;
            String beCareful = txtBeCareful.Text;
            String PM = txtPM.Text;
            //组合框
            String cbId = cbMonitoring.SelectedValue.ToString();
            //时间
            DateTime start = dtpStart.Value;
            DateTime end = dtpEnd.Value;
            String startStr = start.ToShortDateString();
            String endStr = end.ToShortDateString();
            //单选框
            //判断选中状态
            String tag = checkRadio(rbOne, rbTwo, rbThree);

            //非空验证
            bool b = CheckIsEmpty(name, beCareful, PM);

            if (!b)
            {
                return;
            }

            //新建 sql 语句
            String sql = String.Format("insert into AirQualityID values ({0},'{1},'{2}','{3}',{4},{5},'{6}');", cbId,
                name, startStr, endStr
                , PM, tag, beCareful);

            int update = helper.update(sql);

            if (update > 0)
            {
                MessageBox.Show("添加成功！");
            }
            else
            {
                MessageBox.Show("添加失败！");
            }
        }

        private String checkRadio(RadioButton rbOne, RadioButton rbTwo, RadioButton rbThree)
        {
            //定义一个返回值
            String tag = "";

            if (rbOne.Checked)
            {
                tag = rbOne.Tag.ToString();
            }
            else if (rbTwo.Checked)
            {
                tag = rbTwo.Tag.ToString();
            }
            else if (rbThree.Checked)
            {
                tag = rbThree.Tag.ToString();
            }

            //返回值
            return tag;
        }

        private bool CheckIsEmpty(string name, string beCareful, string pm)
        {
            bool b = true;

            if (name.Trim().Length == 0 && beCareful.Trim().Length == 0 && pm.Trim().Length == 0)
            {
                MessageBox.Show("所有信息不可以为空！");
                b = false;
            }
            else if (name.Trim().Length == 0 || beCareful.Trim().Length == 0 || pm.Trim().Length == 0)
            {
                MessageBox.Show("保存失败！");
                b = false;
            }

            return b;
        }
    }
}

查询窗口

界面

代码

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

namespace db1107121监测系统
{
    public partial class fromQuery : Form
    {
        private DataSet ds;
        
        public fromQuery()
        {
            InitializeComponent();
        }

        private void fromQuery_Load(object sender, EventArgs e)
        {
            dgvLoad();
        }

        private void dgvLoad()
        {
            //调用帮手
            DbHelper helper = new DbHelper();

            //新建 sql 语句
            String sql =
                "select StationName,InputName,StartDate,EndDate,PM,LevelNum,Notes from AirQualityID inner join StationInfo on AirQualityID.StationID = StationInfo.StationID";
            
            //让帮手干活
            ds = helper.getDataSet(sql);

            //自动生成列
            dgvTable.AutoGenerateColumns = false;
            //关闭空行
            dgvTable.AllowUserToAddRows = false;
            
            //绑定数据源
            dgvTable.DataSource = ds.Tables["table"];
        }

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

        private void btnQuery_Click(object sender, EventArgs e)
        {
            //获取文本框里的值
            String queryText = txtQuery.Text;
            
            //分检sql 语句
            String cond = String.Format("InputName like '%{0}%'",queryText);
            
            //数据分检中心
            DataView dv = new DataView(ds.Tables["table"]);
            dv.RowFilter = cond;
            
            //重新绑定数据源
            dgvTable.DataSource = dv;
        }
    }
}