//检查添加的人员是否在总的用户表中 private Boolean checkPeopleExist() { Boolean b = true; string strCon = "server=" + Parameter.IP_port + ";database=user;MultipleActiveResultSets=true;Uid=" + Parameter.sql_user + ";Pwd=" + Parameter.sql_pwd; SqlConnection conn = new SqlConnection(strCon); conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; foreach (DataRow dr in dt人员.Rows) { //判断行状态 DataRowState state = dr.RowState; if (state.Equals(DataRowState.Deleted)) { continue; } else { String name = dr["用户名"].ToString(); comm.CommandText = "select * from [users] where 姓名 = " + "'" + name + "'"; SqlDataReader reader = comm.ExecuteReader(); if (!reader.HasRows) { b = false; MessageBox.Show("员工" + "“" + name + "”" + "不存在!"); } reader.Dispose(); } } comm.Dispose(); conn.Dispose(); return(b); }
private void salvarContatos(object sender, EventArgs e) { if (stt.Equals(DataRowState.Added)) { int id = RetornarIdContatos(); DataRow row = tbl.NewRow(); row["Id"] = id; row["Nome"] = textBox1.Text; row["Fone"] = textBox2.Text; row["Endereco"] = textBox3.Text; tbl.Rows.Add(row); Contact c = new Contact(); c.Id = id; c.Name = textBox1.Text; c.Phone = long.Parse(textBox2.Text); c.Adress = textBox3.Text; contatos.Add(c); } else if (stt.Equals(DataRowState.Modified)) { int idx = SelecionarIndex(); int indexLista = int.Parse(tbl.Rows[idx]["Id"].ToString()); tbl.Rows[idx]["Nome"] = textBox1.Text; tbl.Rows[idx]["Fone"] = textBox2.Text; tbl.Rows[idx]["Endereco"] = textBox3.Text; foreach (Contact c in contatos) { if (c.Id == indexLista) { c.Name = textBox1.Text; c.Phone = long.Parse(textBox2.Text); c.Adress = textBox3.Text; } } } HabilitarClick(sender, e); LimparCampos(); }