frmszbz.cs

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

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

namespace 学生宿舍管理系统
{
    public partial class FrmSZBZ : Form
    {
        public FrmSZBZ()
        {
            InitializeComponent();
        }
        string strSQL;
        MyData mydata = new MyData();
        private void Form2_Load(object sender, EventArgs e)
        {
          
           
        }

        private void button1_Click(object sender, EventArgs e)
        {

            if (textBox1.Text == "" || textBox2.Text == "")
            {
                if (textBox1.Text == "")
                {
                    MessageBox.Show("输入的水单价不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    textBox1.Focus();
                }
                if (textBox2.Text == "")
                {
                    MessageBox.Show("输入的电单价不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    textBox2.Focus();
                }
            }
            else
            {

                try
                {
                    if (double.Parse(textBox1.Text) <= 0 || double.Parse(textBox2.Text) < 0)
                    {
                        if (double.Parse(textBox1.Text) <= 0)
                        {
                            MessageBox.Show("输入的水费单价无效", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            textBox1.Text = "";
                            textBox1.Focus();
                        }
                        if (double.Parse(textBox2.Text) <= 0)
                        {
                            MessageBox.Show("输入的电费单价无效", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            textBox2.Text = "";
                            textBox2.Focus();
                        }
                    }
                    else
                    {
                        strSQL = "update 标准费用表 set 水费单价=" + textBox1.Text + " ";
                        strSQL = strSQL + ",电费单价=" + textBox2.Text + "";
                        mydata.updateSql(strSQL);
                        if (mydata.updateSql(strSQL))
                        {
                            MessageBox.Show("各种收费设置成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                }
                catch
                {

                    MessageBox.Show("请你输入有效数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    textBox1.Text = "";
                    textBox2.Text = "";
                    textBox1.Focus();
                }
            }
          
          
        }

        private void button2_Click(object sender, EventArgs e)
        {

            if (textBox3.Text == "" || textBox4.Text == "")
            {
                if (textBox3.Text == "")
                {
                    MessageBox.Show("输入用水费标准不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    textBox3.Focus();
                }
                if (textBox4.Text == "")
                {
                    MessageBox.Show("输入用电费标准不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    textBox4.Focus();
                }
            }
            else
            {
                try
                {
                    if (double.Parse(textBox3.Text) <= 0 || double.Parse(textBox4.Text) < 0)
                    {
                        if (double.Parse(textBox3.Text) <= 0)
                        {
                            MessageBox.Show("输入用水费标准无效", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            textBox3.Focus();
                        }
                        if (double.Parse(textBox4.Text) <= 0)
                        {
                            MessageBox.Show("输入用电费标准无效", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            textBox4.Focus();
                        }
                    }
                    else
                    {
                        strSQL = "update 标准费用表 set 用水标准 =" + textBox3.Text + " ";
                        strSQL = strSQL + ",用电标准 =" + textBox4.Text + "";
                        mydata.updateSql(strSQL);
                        if (mydata.updateSql(strSQL))
                        {
                            MessageBox.Show("使用标准设置成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                }
                catch
                {

                    MessageBox.Show("请你输入有效数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    textBox3.Text = "";
                    textBox4.Text = "";
                    textBox3.Focus();
                }
            }

        }
    }
}