Esempio n. 1
0
        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;
                }
            }
        }