public void resetData()
        {
            DataSet dstmp = new DataSet();
            //创建虚拟数据表
            DataTable table = new DataTable("TAB_NM");
            //获取列集合,添加列
            DataColumnCollection columns = table.Columns;
            columns.Add("教工号", typeof(String));
            columns.Add("姓名", typeof(String));
            columns.Add("基本工资", typeof(float));
            columns.Add("津贴", typeof(float));
            columns.Add("公积金", typeof(float));
            columns.Add("生活费", typeof(float));
            columns.Add("所得税", typeof(float));

            List<Teacher> list = new TeacherDB().selectAll();
            //Teacher mTeacher = new Teacher();
            foreach (Teacher mTeacher in list)
            {
                //添加一行记录
                DataRow row = table.NewRow();
                row["教工号"] = mTeacher.Id;
                row["姓名"] = mTeacher.Name;
                row["基本工资"] = mTeacher.BaseSalary;
                row["津贴"] = mTeacher.Allowance;
                row["公积金"] = mTeacher.Fund;
                row["生活费"] = mTeacher.Sanitary;
                row["所得税"] = mTeacher.IncomeTax;
                table.Rows.Add(row);

            }
            dstmp.Tables.Add(table); //把信息表放入DataSet中

            dataGridView1.DataSource = dstmp.Tables["TAB_NM"];
        }
示例#2
0
        public void test()
        {
            TeacherDB teacherDB = new TeacherDB();

            //测试delete
            Console.WriteLine(teacherDB.delete("teacher"));

            //测试update
            /*Teacher t1 = new Teacher();
            t1.Id = "ABC111";
            t1.Name = "zxcxzczxc";
            Console.WriteLine(teacherDB.updata(t1));*/

            /*
            //测试insert
            Teacher t1 = new Teacher();
            t1.Id = "test1";
            teacherDB.insert(t1);
            */

            /*
            //测试selectTeacherByUserName
            Teacher t1 = new Teacher();
            t1 = teacherDB.selectTeacherById("teacher");
            MessageBox.Show(t1.ToString());
            */

            /*
            //测试selectAll
            List<Teacher> all = teacherDB.selectAll();
            foreach (Teacher t1 in all)
            {
                Console.WriteLine(t1.ToString());
            }
            */
        }
        private void button2_Click(object sender, EventArgs e)
        {
            if (b == false)
            {
                MessageBox.Show("请先查询!", "警告!");
                return;
            }
            //判断教工号【是否符合条件,是否被修改】
            if (!mTeacher.Id.Equals(textBox1.Text.ToString().Trim()))
            {
                if (Util.checkTeacherId(textBox1.Text.ToString().Trim()))
                    mTeacher.Id = textBox1.Text.ToString().Trim();//如果教工号改变则重新为mTeacher的id赋值;
                else
                {
                    textBox1.Select();
                    return;
                }

            }

            int f;//临时变量判断所有值是否全部检查通过;
                if ((f=Util.checkNum(textBox2.Text.ToString().Trim()))==0)
                    mTeacher.BaseSalary = float.Parse(textBox2.Text.ToString().Trim());
                else
                {
                    if(f==1)
                        MessageBox.Show("请输入正确数值!(基本工资)", "警告!");
                    else
                        MessageBox.Show("请输入数值!(基本工资)", "警告!");
                    textBox2.Select();
                    return;
                }

                if ((f=Util.checkNum(textBox3.Text.ToString().Trim()))==0)
                    mTeacher.Allowance = float.Parse(textBox3.Text.ToString().Trim());
                else
                {
                    if (f == 1)
                        MessageBox.Show("请输入正确数值!(津贴)", "警告!");
                    else
                        MessageBox.Show("请输入数值!(津贴)", "警告!");
                    textBox3.Select();
                    return;
                }
                if ((f=Util.checkNum(textBox4.Text.ToString().Trim()))==0)
                    mTeacher.Fund = float.Parse(textBox4.Text.ToString().Trim());
                else
                {
                    if (f == 1)
                        MessageBox.Show("请输入正确数值!(公积金)", "警告!");
                    else
                        MessageBox.Show("请输入数值!(公积金)", "警告!");
                    textBox4.Select();
                    return;
                }
                if ((f=Util.checkNum(textBox5.Text.ToString().Trim()))==0)
                    mTeacher.Sanitary = float.Parse(textBox5.Text.ToString().Trim());
                else
                {
                    if (f == 1)
                        MessageBox.Show("请输入正确数值!(生活费)", "警告!");
                    else
                        MessageBox.Show("请输入数值!(生活费)", "警告!");
                    textBox5.Select();
                    return;
                }
                if ((f=Util.checkNum(textBox6.Text.ToString().Trim()))==0)
                    mTeacher.IncomeTax = float.Parse(textBox6.Text.ToString().Trim());
                else
                {
                    if (f == 1)
                        MessageBox.Show("请输入正确数值!(所得税)", "警告!");
                    else
                        MessageBox.Show("请输入数值!(所得税)", "警告!");
                    textBox6.Select();
                    return;
                }
                TeacherDB tdb = new TeacherDB();
                if (tdb.updata(mTeacher) == 0)
                {
                    MessageBox.Show("修改失败!", "警告!");
                    return;
                }
                else
                {
                    MessageBox.Show("修改成功!", "消息!");
                    TeacherSelect._getInstance().resetData();
                    SalarySelect._getInstance().resetData();
                }

                //如果控件已经存在就删除重建;
                textBox1.Text = "";
                Util.checkView(this);
        }
 private void button3_Click(object sender, EventArgs e)
 {
     TeacherDB tdb = new TeacherDB();
     if ("".Equals(textBox1.Text.ToString().Trim()))
     {
         MessageBox.Show("教工号不能为空!","警告!");
         return;
     }
     if (tdb.delete(textBox1.Text.ToString().Trim())==0)
     {
         MessageBox.Show("用户名不存在!","警告!");
         return;
     }
     TeacherSelect._getInstance().resetData();
     SalarySelect._getInstance().resetData();
     MessageBox.Show("删除成功!","消息!");
     textBox1.Text = "";
     //如果控件已经存在就删除重建;
     Util.checkView(this);
 }
        private void button2_Click(object sender, EventArgs e)
        {
            if (b == false)
            {
                MessageBox.Show("请先查询!", "警告!");
                return;
            }
            //判断教工号【是否符合条件,是否被修改】
            if (!mTeacher.Id.Equals(textBox1.Text.ToString().Trim()))
            {
                if(Util.checkTeacherId(textBox1.Text.ToString().Trim()))
                    mTeacher.Id = textBox1.Text.ToString().Trim();//如果教工号改变则重新为mTeacher的id赋值;
                else
                {
                    textBox1.Select();
                    return;
                }

            }
            //开始为mTeacher赋值
                mTeacher.Name = textBox2.Text.ToString().Trim();
                if (rb1.Checked)
                    mTeacher.Sex = "男";
                else
                    mTeacher.Sex = "女";

                mTeacher.Organization = textBox3.Text.ToString().Trim();
                mTeacher.Address = textBox4.Text.ToString().Trim();
                mTeacher.Phone = textBox5.Text.ToString().Trim();
                TeacherDB tdb = new TeacherDB();
                tdb.updata(mTeacher);
                if (tdb.updata(mTeacher) == 0)
                {
                    MessageBox.Show("修改失败!", "警告!");
                    return;
                }
                else
                {
                    MessageBox.Show("修改成功!", "消息!");
                    TeacherSelect._getInstance().resetData();
                    SalarySelect._getInstance().resetData();
                }

                //如果控件已经存在就删除重建;
                textBox1.Text = "";
                Util.checkView(this);

                b = false;//查询未完成
        }
        private void button1_Click(object sender, EventArgs e)
        {
            flag = true;//初始化flag
            //判断教工号格式
            if(!Util.checkInputTeacherId(textBox1.Text.ToString().Trim(),label7,1))
                flag=false;

            //判断基本工资
            if (!Util.checkSalary(textBox2, label8))
                flag = false;

            //判断津贴
            if (!Util.checkSalary(textBox3, label9))
                flag = false;

            //判断公积金
            if (!Util.checkSalary(textBox4, label10))
                flag = false;

            //判断生活费
            if (!Util.checkSalary(textBox5, label11))
                flag = false;

            //判断所得税
            if (!Util.checkSalary(textBox6, label12))
                flag = false;

            if (flag == true)
            {
                Teacher mTeacher = new TeacherDB().selectTeacherById(textBox1.Text.ToString().Trim());
                mTeacher.BaseSalary = float.Parse(textBox2.Text.ToString().Trim());
                mTeacher.Allowance = float.Parse(textBox3.Text.ToString().Trim());
                mTeacher.Fund = float.Parse(textBox4.Text.ToString().Trim());
                mTeacher.Sanitary = float.Parse(textBox5.Text.ToString().Trim());
                mTeacher.IncomeTax = float.Parse(textBox6.Text.ToString().Trim());
                TeacherDB tdb = new TeacherDB();
                if (tdb.updata(mTeacher) == 0)
                {
                    MessageBox.Show("插入失败!", "警告!");
                    return;
                }
                else
                {
                    TeacherSelect._getInstance().resetData();
                    SalarySelect._getInstance().resetData();
                    MessageBox.Show("插入成功!", "消息!");
                    textBox1.Text = "";
                    textBox2.Text = "";
                    textBox3.Text = "";
                    textBox4.Text = "";
                    textBox5.Text = "";
                    textBox6.Text = "";
                    label7.Text = "";
                    label8.Text = "";
                    label9.Text = "";
                    label10.Text = "";
                    label11.Text = "";
                    label12.Text = "";
                }
            }
        }
示例#7
0
        /*
         *教工号判断
         *
         */
        public static Boolean checkTeacherId(String str)
        {
            if ("".Equals(str))
            {
                MessageBox.Show("教工号不能为空!", "警告!");
                return false;
            }
            else
            {
                Regex idReg = new Regex("[A-Z]{3}[0-9]{3}");
                if (!idReg.IsMatch(str))
                {
                    MessageBox.Show("格式应为:ABC123", "警告!");
                    return false;
                }

                Teacher mTeacher = new TeacherDB().selectTeacherById(str);
                if (mTeacher == null)
                {
                    MessageBox.Show("教工号不存在!", "注意!");
                    return false;

                }
            }

            return true;
        }
示例#8
0
        private void button1_Click(object sender, EventArgs e)
        {
            flag = true;//初始化flag
            //判断教工号格式
            if (!Util.checkInputTeacherId(textBox1.Text.ToString().Trim(), label7,2))
                flag = false;

            //判断手机号码格式
            Regex phoneReg = new Regex("1[3,5,7,8][0,2,3,6,5,7,8][0-9]{8}");
            if (phoneReg.IsMatch(textBox5.Text.Trim()))
            {
                label8.Text = "通过!";
            }
            else
            {
                label8.Text ="手机号输入有误!";
                flag = false;
            }

            //判断姓名是否为空
            if (Util.isEmpty(textBox2.Text))
            {
                label9.Text = "不能为空!";
                flag = false;
            }
            else
            {
                label9.Text = "通过!";
            }

            //判断单位名称是否为空
            if (Util.isEmpty(textBox3.Text))
            {
                label10.Text = "不能为空!";
                flag = false;
            }
            else
            {
                label10.Text = "通过!";
            }

            //判断家庭住址是否为空
            if (Util.isEmpty(textBox4.Text))
            {
                label11.Text = "不能为空!";
                flag = false;
            }
            else
            {
                label11.Text = "通过!";
            }
            if (flag == true)
            {
                Teacher mTeacher = new Teacher();
                mTeacher.Id = textBox1.Text.ToString().Trim();
                mTeacher.Name = textBox2.Text.ToString().Trim();
                if (radioButton1.Checked)
                    mTeacher.Sex = "男";
                else
                    mTeacher.Sex = "女";
                mTeacher.Organization = textBox3.Text.ToString().Trim();
                mTeacher.Address = textBox4.Text.ToString().Trim();
                mTeacher.Phone = textBox5.Text.ToString().Trim();
                TeacherDB mTeacherDB = new TeacherDB();
                mTeacherDB.insert(mTeacher);

                MessageBox.Show("录入成功!");
                TeacherSelect._getInstance().resetData();
                SalarySelect._getInstance().resetData();
                textBox1.Text = "";
                textBox2.Text = "";
                textBox3.Text = "";
                textBox4.Text = "";
                textBox5.Text = "";
                radioButton1.Checked = true;
                label7.Text = "";
                label8.Text = "";
                label9.Text = "";
                label10.Text = "";
                label11.Text = "";

            }
        }