private void AddBtn_Click(object sender, EventArgs e) { userid = IDtextBox.Text.Trim(); username = NametextBox.Text.Trim(); password = PWtextBox.Text.Trim(); if (username == "" || password == "" || userid == "" || comboBox角色.SelectedIndex == -1) { MessageBox.Show("员工信息不能为空", "错误"); return; } else { int uid; if (!Int32.TryParse(userid, out uid)) { MessageBox.Show("员工ID必须为数字", "提示"); return; } bool idbool = isIDExist(); if (!idbool) { String tblName = "users"; //List<String> insertCols = new List<String>(new String[] { "角色ID", "姓名", "密码", "角色", "用户ID", "班次", "班次开始时间", "班次结束时间", "部门", "岗位" }); //List<Object> insertVals = new List<Object>(new Object[] { role_id, username, password, role, userid, "", DateTime.Now, DateTime.Now, "", "" }); List <String> insertCols = new List <String>(new String[] { "角色ID", "姓名", "密码", "角色", "用户ID" }); List <Object> insertVals = new List <Object>(new Object[] { role_id, username, password, role, userid }); Boolean b = Utility.insertAccess(mySystem.Parameter.connUser, tblName, insertCols, insertVals); if (b) { MessageBox.Show("用户添加成功", "success"); myparent.BindUser(); this.Close(); this.Dispose(); return; } else { MessageBox.Show("用户添加失败", "错误"); return; } } else { MessageBox.Show("该员工ID已经存在,请重新输入!", "警告"); return; } } }