空气质量监测管理系统

一、语言和环境

A、实现语言
C#，WinForms
B、环境要求
Visual Studio 2012，SQL Server 2008

二、功能要求

使用 Visual Studio 2012 实现空气质量监测管理功能，SQL Server 2008 作为
后台数据库，程序界面采用 MDI 窗体风格，主菜单包括菜单项：“录入监测数据”、“查
询监测结果”和“退出”，学员需完成这三个功能;

三、实现代码

1、录入监测数据

private void buttonclose_Click(object sender, EventArgs e)
        {
            //关闭
            this.Close();

        }

        private void buttonsubmit_Click(object sender, EventArgs e)
        {
            //提交
           
           
            if( refer()){
                SqlConnection conn = new SqlConnection(constr);
                conn.Open();
                StringBuilder sb = new StringBuilder();
                sb.AppendFormat("insert into dbo.irQualityInfo(StationID,InputName,StartDate,EndDate,PM,Level,Notes)");
                sb.AppendFormat(" values");
                sb.AppendFormat("( '{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
                    cmbStationID.SelectedValue,
                    textInputName.Text,
                    textStartDate.Text,
                    textEndDate.Text,
                    textPM.Text,
                    textLevel.Text,
                    textNotes.Text );

                SqlCommand cmd = new SqlCommand(sb.ToString(),conn);
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    MessageBox.Show("数据保存成功");

                }
                else {
                    MessageBox.Show("保存失败");
                }
            }
        }
        public bool refer() {
            //提交验证
            if (this.cmbStationID.Text.Trim().Length==0){
                MessageBox.Show("所有信息均不能为空");
                return false;
          
          }
            if(this.textInputName.Text.Trim().Length==0){
                MessageBox.Show("所有信息均不能为空");
                return false;
          
            }
            if (this.textStartDate.Text.Trim().Length == 0)
            {
                MessageBox.Show("所有信息均不能为空");
                return false;

            } if (this.textEndDate.Text.Trim().Length == 0)
            {
                MessageBox.Show("所有信息均不能为空");
                return false;

            } if (this.textPM.Text.Trim().Length == 0)
            {
                MessageBox.Show("所有信息均不能为空");
                return false;

            } if (this.textLevel.Text.Trim().Length == 0)
            {
                MessageBox.Show("所有信息均不能为空");
                return false;

            } if (this.textNotes.Text.Trim().Length == 0)
            {
                MessageBox.Show("所有信息均不能为空");
                return false;

            }
            return true;
        }

        private void buttonempty_Click(object sender, EventArgs e)
        {
            //清空
            clear();

        }
        public void clear() {
            //清除
            this.cmbStationID.Text = "";
            this.textInputName.Text = "";
            this.textStartDate.Text = "";
            this.textEndDate.Text = "";
            this.textPM.Text= "";
            this.textLevel.Text = "";
            this.textNotes.Text = "";
            

        }

        private void FromAdd_Load(object sender, EventArgs e)
        {
            //绑定数据
            SqlConnection conn = new SqlConnection(constr);
            string sql = "select * from StationInfo";
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(sql,conn);
            da.Fill(ds);

            DataRow dr = ds.Tables[0].NewRow();
            dr["StationID"] = 0;
            dr["StationName"] = "请选择";
            ds.Tables[0].Rows.InsertAt(dr,0);

            cmbStationID.DisplayMember = "StationName";
            cmbStationID.ValueMember = "StationID";
            cmbStationID.DataSource = ds.Tables[0];
        }
    }

2.查询监测结果

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

        private void FormMain_Load(object sender, EventArgs e)//加载
        {
            find();
        }
       

        private void buttonfind_Click(object sender, EventArgs e)
        {//查找
          
            if(yz()==true){
                find();
               

            }

        }
        
        public void find() {
            
            //查找
                SqlConnection conn = new SqlConnection(constr);
                string sql = ("select a.*,b.StationName from dbo.irQualityInfo as a,dbo.StationInfo as b where a.StationID=b.StationID");
                if (this.textBox1.Text.Trim() != "")
                {

                    sql += " and InputName like '%" + this.textBox1.Text.Trim() + "%'";
                  
                }
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(sql, conn);
                da.Fill(ds);

               
      
                if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count> 0)
                {
                              dataGridView1.AutoGenerateColumns = false;
                dataGridView1.DataSource = ds.Tables[0];
                }
                else
                {
                    MessageBox.Show("查无此人");

                }
                
            }
        public bool yz() {
            //验证
            bool b = true;
           
            if( textBox1.Text.Trim().Length == 0){
                MessageBox.Show("请输入要查找的录入人员名称");
                return false;
            }
            return b;

        }
          

        }

3.退出

       private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //关闭应用程序
            Application.Exit();
            

        }

四、总结

总的来说比较简单，主要用到添加操作跟查询操作，注意逻辑顺序跟语法范就好，还有方法的调用一定不要忘记