frmblrz.cs

学生宿舍管理系统 学生宿舍管理系统

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

namespace 学生宿舍管理系统
{
    public partial class FrmBLRZ : Form
    {
        public FrmBLRZ()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string s = "select 学号 from 入住登记表 where 学号='" + maskedTextBox1.Text + "'";
            string s1= "select 栋号,房间号码,床位号码 from 入住登记表 where 栋号='" + maskedTextBox4.Text + "'and 房间号码='" + maskedTextBox5.Text + "' and 床位号码="+ maskedTextBox9.Text+"";
            string s2="select 栋号,房间号码,入住人数 from 房间基本信息表 where 栋号='" + maskedTextBox4.Text + "'and 房间号码='" + maskedTextBox5.Text + "' and 入住人数<可住人数";
            string s3="insert into 入住登记表(栋号,房间号码,床位号码,学号,姓名,性别,所属学院,班级,年度,联系电话,入住日期) values('"+maskedTextBox4.Text +"','"+maskedTextBox5.Text +"',"+maskedTextBox9.Text  +",'"+maskedTextBox1.Text  +"','"+maskedTextBox2.Text  +"','"+comboBox1 .Text +"','"+maskedTextBox6.Text  +"','"+maskedTextBox7.Text  +"','"+maskedTextBox3.Text + "','"+maskedTextBox8 .Text +"','"+dateTimePicker1 .Text +"')";
            string s4 = "update 房间基本信息表 set 入住人数=入住人数+1,空缺人数=空缺人数-1 where 栋号='" + maskedTextBox4.Text + "'and 房间号码='" + maskedTextBox5.Text + "'";
          
            MyData mydata = new MyData();
            OleDbDataReader dr = mydata.getDataReader(s);
           
            if (maskedTextBox1.Text == "")
            {
                MessageBox.Show("请输入学号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            } 
            if (maskedTextBox2.Text == "")
            {
                MessageBox.Show("请输入姓名！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (comboBox1.Text == "")
            {
                MessageBox.Show("请选择性别！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (maskedTextBox3.Text == "")
            {
                MessageBox.Show("请输入年度！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (maskedTextBox4.Text == "")
            {
                MessageBox.Show("请输入栋号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (maskedTextBox5.Text == "")
            {
                MessageBox.Show("请输入房间号码！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (maskedTextBox9.Text == "")
            {
                MessageBox.Show("请输入床位号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (maskedTextBox6.Text == "")
            {
                MessageBox.Show("请输入所属学院！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (maskedTextBox7.Text == "")
            {
                MessageBox.Show("请输入班级！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (maskedTextBox8.Text == "")
            {
                MessageBox.Show("请输入联系电话！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
        
          if (dr.HasRows == true)
            {
                MessageBox.Show("您输入的学号已存在，请重新输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                OleDbDataReader dr2 = mydata.getDataReader(s2);
                if (dr2.HasRows != true)
                   {
                    MessageBox.Show("您输入的房间不存在或已经住满，请重新输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                   }
                else 
                {
                    OleDbDataReader dr1=mydata .getDataReader (s1);
                    if (dr1.HasRows == true)
                    {
                        MessageBox.Show("您输入的床位号已被占用，请查询后再分配！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        OleDbDataReader dr11 = mydata.getDataReader("select 栋号,房间号码,可住人数 from 房间基本信息表 where 栋号='" + maskedTextBox4.Text + "'and 房间号码='" + maskedTextBox5.Text + "' and 可住人数<" + maskedTextBox9.Text + " or "+maskedTextBox9 .Text +"<=0" );
                        if (dr11.HasRows==true )
                        {
                            MessageBox.Show("您输入的床位号不存在，请查询后再分配！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            mydata.updateSql(s4);
                            mydata.updateSql(s3);
                            MessageBox.Show("登记成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            maskedTextBox1.Text = ""; maskedTextBox2.Text = ""; maskedTextBox3.Text = ""; maskedTextBox4.Text = ""; maskedTextBox5.Text = ""; maskedTextBox6.Text = "";
                            maskedTextBox7.Text = ""; maskedTextBox8.Text = ""; maskedTextBox9.Text = ""; comboBox1.Text = "";
                        }
                        
                    }
                }
            }


        }

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

    
    }
}