/** * * 插入teacher,失败返回0 * */ public int insert(Teacher teacher) { String sql = "insert into teachers values('" + teacher.Id + "','" + teacher.Name + "','" + teacher.Sex + "','" + teacher.Organization + "','" + teacher.Address + "','" + teacher.Phone+ "'," + teacher.BaseSalary + "," + teacher.Allowance + "," + teacher.Fund + "," + teacher.Sanitary + "," + teacher.IncomeTax + ")"; //Console.WriteLine(sql); connection.Open(); cmd = new MySqlCommand(sql, connection); int n = cmd.ExecuteNonQuery(); //关闭连接 closeConnection(); return n; }
private void button1_Click(object sender, EventArgs e) { if (Util.checkTeacherId(textBox1.Text.ToString().Trim()) == false) return; else mTeacher = new TeacherDB().selectTeacherById(textBox1.Text.ToString().Trim()); textBox2.Text = (mTeacher.BaseSalary + mTeacher.Allowance).ToString(); textBox3.Text = (mTeacher.Fund + mTeacher.Sanitary + mTeacher.IncomeTax).ToString(); textBox4.Text = (Double.Parse(textBox2.Text.ToString().Trim()) - Double.Parse(textBox3.Text.ToString().Trim())).ToString(); }
private void button1_Click(object sender, EventArgs e) { //判断教工号【是否符合条件,是否被修改】 if (!mTeacher.Id.Equals(textBox1.Text.ToString().Trim())) { if (Util.checkTeacherId(textBox1.Text.ToString().Trim())) mTeacher = new TeacherDB().selectTeacherById(textBox1.Text.ToString().Trim());//如果教工号改变则重新获取mTeacher else { textBox1.Select(); return; } } //如果控件已经存在就删除重建; Util.checkView(this); //基本工资 lb2 = new Label(); lb2.Text = "基本工资:"; lb2.Top = label1.Top + 40; lb2.Left = label1.Left; lb2.Width = 59; this.Controls.Add(lb2); textBox2 = new TextBox(); textBox2.Top = lb2.Top; textBox2.Left = textBox1.Left; textBox2.Width = 100; textBox2.Height = 21; textBox2.Text = mTeacher.BaseSalary.ToString(); this.Controls.Add(textBox2); //津贴 lb3 = new Label(); lb3.Text = "津贴:"; lb3.Top = lb2.Top + 40; lb3.Left = lb2.Left; lb3.Width = 59; this.Controls.Add(lb3); textBox3 = new TextBox(); textBox3.Top = lb3.Top; textBox3.Left = textBox1.Left; textBox3.Width = 100; textBox3.Height = 21; textBox3.Text = mTeacher.Allowance.ToString(); this.Controls.Add(textBox3); //公积金 lb4 = new Label(); lb4.Text = "公积金:"; lb4.Top = lb3.Top + 40; lb4.Left = lb3.Left; lb4.Width = 59; this.Controls.Add(lb4); textBox4 = new TextBox(); textBox4.Top = lb4.Top; textBox4.Left = textBox1.Left; textBox4.Width = 100; textBox4.Height = 21; textBox4.Text = mTeacher.Fund.ToString(); this.Controls.Add(textBox4); //生活费 lb5 = new Label(); lb5.Text = "生活费:"; lb5.Top = lb4.Top + 40; lb5.Left = lb2.Left; lb5.Width = 59; this.Controls.Add(lb5); textBox5 = new TextBox(); textBox5.Top = lb5.Top; textBox5.Left = textBox1.Left; textBox5.Width = 100; textBox5.Height = 21; textBox5.Text = mTeacher.Sanitary.ToString(); this.Controls.Add(textBox5); //所得税 lb6 = new Label(); lb6.Text = "所得税:"; lb6.Top = lb5.Top + 40; lb6.Left = lb2.Left; lb6.Width = 59; this.Controls.Add(lb6); textBox6 = new TextBox(); textBox6.Top = lb6.Top; textBox6.Left = textBox1.Left; textBox6.Width = 100; textBox6.Height = 21; textBox6.Text = mTeacher.IncomeTax.ToString(); this.Controls.Add(textBox6); b = true; }
private void button1_Click(object sender, EventArgs e) { //判断教工号【是否符合条件,是否被修改】 if (!mTeacher.Id.Equals(textBox1.Text.ToString().Trim())) { if (Util.checkTeacherId(textBox1.Text.ToString().Trim())) mTeacher = new TeacherDB().selectTeacherById(textBox1.Text.ToString().Trim());//如果教工号改变则重新获取mTeacher else { textBox1.Select(); return; } } //如果控件已经存在就删除重建; Util.checkView(this); //姓名 lb2 = new Label(); lb2.Name = "lb2"; lb2.Text = "教师姓名:"; lb2.Top = label1.Top + 40; lb2.Left = label1.Left; lb2.Width = 59; this.Controls.Add(lb2); textBox2 = new TextBox(); textBox2.Top = lb2.Top; textBox2.Left = textBox1.Left; textBox2.Width = 100; textBox2.Height = 21; textBox2.Text = mTeacher.Name.ToString(); this.Controls.Add(textBox2); //性别控件 lb3 = new Label(); lb3.Name = "lb3"; lb3.Text = "性别:"; lb3.Top = lb2.Top + 40; lb3.Left = lb2.Left; lb3.Width = 50; this.Controls.Add(lb3); pl = new Panel(); pl.Top = lb3.Top; pl.Left = textBox2.Left; pl.Width=130; pl.Height = 28; rb1 = new RadioButton(); rb1.Text = "男"; rb1.Width = 35; rb1.Height = 16; rb1.Left = 15; rb2 = new RadioButton(); rb2.Text = "女"; rb2.Width = 35; rb2.Height = 16; rb2.Left = rb1.Left+50; if (mTeacher.Sex.Equals("男")) rb1.Checked = true; else rb2.Checked = true; pl.Controls.Add(rb2); pl.Controls.Add(rb1); this.Controls.Add(pl); //单位名称 lb4 = new Label(); lb4.Name = "lb4"; lb4.Text="单位名称:"; lb4.Top = lb3.Top + 40; lb4.Left = lb3.Left; lb4.Width = 59; this.Controls.Add(lb4); textBox3 = new TextBox(); textBox3.Top = lb4.Top; textBox3.Left = textBox2.Left; textBox3.Width = 100; textBox3.Height = 21; textBox3.Text = mTeacher.Organization.ToString(); this.Controls.Add(textBox3); //家庭地址 lb5 = new Label(); lb5.Name = "lb5"; lb5.Text = "家庭地址:"; lb5.Top = lb4.Top + 40; lb5.Left = lb3.Left; lb5.Width = 59; this.Controls.Add(lb5); textBox4 = new TextBox(); textBox4.Top = lb5.Top; textBox4.Left = textBox2.Left; textBox4.Width = 135; textBox4.Height = 21; textBox4.Text = mTeacher.Address.ToString(); this.Controls.Add(textBox4); //联系电话 lb6 = new Label(); lb6.Name = "lb6"; lb6.Text = "联系电话:"; lb6.Top = lb5.Top + 40; lb6.Left = lb3.Left; lb6.Width = 59; this.Controls.Add(lb6); textBox5 = new TextBox(); textBox5.Top = lb6.Top; textBox5.Left = textBox2.Left; textBox5.Width = 135; textBox5.Height = 21; textBox5.Text = mTeacher.Phone.ToString(); this.Controls.Add(textBox5); b = true;//查询完成 }
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 = ""; } }
/** * * 根据teacher.id更新teacher,失败返回0 * */ public int updata(Teacher teacher) { String sql = "update teachers set" + " teacher_name='" + teacher.Name + "'," + " teacher_sex='" + teacher.Sex + "'," + " teacher_organization='" + teacher.Organization + "'," + " teacher_address='" + teacher.Address + "'," + " teacher_phone='" + teacher.Phone + "'," + " salary_base=" + teacher.BaseSalary + "," + " salary_allowance=" + teacher.Allowance + "," + " salary_fund=" + teacher.Fund + "," + " expenses_sanitary=" + teacher.Sanitary + "," + " expenses_incomeTax=" + teacher.IncomeTax + " where teacher_id='" + teacher.Id + "'"; //Console.WriteLine(sql); connection.Open(); cmd = new MySqlCommand(sql, connection); int n = cmd.ExecuteNonQuery(); //关闭连接 closeConnection(); return n; }
/** * * 通过teacherid查询teacher * */ public Teacher selectTeacherById(String teacherId) { String sql = "select * from teachers where teacher_id='" + teacherId + "'"; //Console.WriteLine(sql); connection.Open(); cmd = new MySqlCommand(sql, connection); MySqlDataReader dataReader = cmd.ExecuteReader(); if (dataReader.Read()) { Teacher teacher = new Teacher(); try { teacher.Id = dataReader.GetString(0); } catch (SqlNullValueException e) { teacher.Id = ""; } try { teacher.Name = dataReader.GetString(1); } catch (SqlNullValueException e) { teacher.Name = ""; } try { teacher.Sex = dataReader.GetString(2); } catch (SqlNullValueException e) { teacher.Sex = ""; } try { teacher.Organization = dataReader.GetString(3); } catch (SqlNullValueException e) { teacher.Organization = ""; } try { teacher.Address = dataReader.GetString(4); } catch (SqlNullValueException e) { teacher.Address = ""; } try { teacher.Phone = dataReader.GetString(5); } catch (SqlNullValueException e) { teacher.Phone = ""; } try { teacher.BaseSalary = dataReader.GetFloat(6); } catch (SqlNullValueException e) { teacher.BaseSalary = 0; } try { teacher.Allowance = dataReader.GetFloat(7); } catch (SqlNullValueException e) { teacher.Allowance = 0; } try { teacher.Fund = dataReader.GetFloat(8); } catch (SqlNullValueException e) { teacher.Fund = 0; } try { teacher.Sanitary = dataReader.GetFloat(9); } catch (SqlNullValueException e) { teacher.Sanitary = 0; } try { teacher.IncomeTax = dataReader.GetFloat(10); } catch (SqlNullValueException e) { teacher.IncomeTax = 0; } //关闭连接 dataReader.Close(); closeConnection(); return teacher; } //关闭连接 dataReader.Close(); closeConnection(); return null; }
/** * * 查找全部teacher,返回List<Teacher>; * */ public List<Teacher> selectAll() { List<Teacher> all=new List<Teacher>(); String sql = "select * from teachers"; connection.Open(); cmd = new MySqlCommand(sql, connection); MySqlDataReader dataReader= cmd.ExecuteReader(); while (dataReader.Read()) { Teacher teacher = new Teacher(); try { teacher.Id = dataReader.GetString(0); } catch(SqlNullValueException e) { teacher.Id=""; } try { teacher.Name = dataReader.GetString(1); } catch (SqlNullValueException e) { teacher.Name = ""; } try { teacher.Sex = dataReader.GetString(2); } catch (SqlNullValueException e) { teacher.Sex = ""; } try { teacher.Organization = dataReader.GetString(3); } catch (SqlNullValueException e) { teacher.Organization = ""; } try { teacher.Address = dataReader.GetString(4); } catch (SqlNullValueException e) { teacher.Address = ""; } try { teacher.Phone = dataReader.GetString(5); } catch (SqlNullValueException e) { teacher.Phone = ""; } try { teacher.BaseSalary = dataReader.GetFloat(6); } catch (SqlNullValueException e) { teacher.BaseSalary = 0; } try { teacher.Allowance = dataReader.GetFloat(7); } catch (SqlNullValueException e) { teacher.Allowance = 0; } try { teacher.Fund = dataReader.GetFloat(8); } catch (SqlNullValueException e) { teacher.Fund = 0; } try { teacher.Sanitary = dataReader.GetFloat(9); } catch (SqlNullValueException e) { teacher.Sanitary = 0; } try { teacher.IncomeTax = dataReader.GetFloat(10); } catch (SqlNullValueException e) { teacher.IncomeTax = 0; } all.Add(teacher); } //关闭连接 dataReader.Close(); closeConnection(); return all; }