private void button1_Click(object sender, EventArgs e) { if (Number.Text == "") { MessageBox.Show("员工编码不能为空!"); } else if (Name1.Text == "") { MessageBox.Show("员工名称不能为空!"); } else if (Phone.Text == "") { MessageBox.Show("手机号不能为空!"); } else if (Encoding.Default.GetByteCount(Phone.Text) != 11) { MessageBox.Show("手机号长度不为11!"); } else { string number = Number.Text; string name = Name1.Text; string phone = Phone.Text; model.employee r = new model.employee(); employeeDaoz c = new employeeDaoz(); c.addEmployee(number, name, phone); Console.Write(c.kehu + "!!"); if (c.kehu == 0) { } else { int node = k.dataGridView1.Rows.Count; k.dt.Rows.Add(node + 1, number, name, phone); k.dataGridView1.DataSource = k.dt; this.Close(); } } }
public static List <model.employee> selectAll(String number) { MySqlConnection conn = Util.Util.getConn(); MySqlDataReader dataReader = null; MySqlCommand command = null; List <model.employee> kehus = new List <model.employee>(); model.employee r = new model.employee(); try { command = conn.CreateCommand(); command.CommandText = "SELECT * FROM employee where employee_number='" + number + "'"; dataReader = command.ExecuteReader(); Console.WriteLine(); while (dataReader.Read()) { r.Id = dataReader.GetInt16(0); r.Employee_number = dataReader.GetString(1); r.Employee_name = dataReader.GetString(2); r.Phone = dataReader.GetString(3); kehus.Add(r); } } catch (Exception) { MessageBox.Show("查询出错!"); } finally { if (!dataReader.IsClosed) { dataReader.Close(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(kehus); }
public static List <model.employee> find_all()//查询出所有客户 { MySqlConnection conn = Util.Util.getConn(); String sql = "select * from employee"; MySqlDataAdapter da = new MySqlDataAdapter(sql, conn); DataSet ds = new DataSet(); Console.WriteLine("ds:" + ds); da.Fill(ds); conn.Close(); //获得DataSet里的数据 List <model.employee> rs = new List <model.employee>(); try { if (ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)//判断DataSet里是否有值 { rs = new List <model.employee>(); int count = ds.Tables[0].Rows.Count;//获得表的行数 for (int i = 0; i < count; i++) { model.employee r = new model.employee(); r.Id = (int)ds.Tables[0].Rows[i]["id"]; r.Employee_name = (string)ds.Tables[0].Rows[i]["employee_name"]; r.Employee_number = (string)ds.Tables[0].Rows[i]["employee_number"]; r.Phone = (string)ds.Tables[0].Rows[i]["phone"]; rs.Add(r); } } } catch { MessageBox.Show("查询出错!"); } return(rs); }
private void employee_update_Load(object sender, EventArgs e) { Console.Write("!!!!!" + kehuguanli.number); model.employee r = dao.employeeDaoz.select(number); Number.Text = r.Employee_number; }