private void TSMIManagerAccount_Click(object sender, EventArgs e) { this.mainPanel.Controls.Clear(); this.mainPanel.Controls.Add(formAccountMgr); formAccountMgr.Show(); formAccountMgr.UpdateData(); }
private void BtnAdd_Click(object sender, EventArgs e) { if (tbUserName.Text.Length == 0) { MessageBox.Show("请输入账号"); return; } if (tbPwd.Text.Length == 0) { MessageBox.Show("请输入密码"); return; } SqlLiteHelper sqlLiteHelper = SqlLiteHelper.GetInstance(); if (_modifyModel) { SQLiteDataReader dataReader = sqlLiteHelper.ReadTable(_tableName, new string[] { "*" }, new string[] { "账号" }, new string[] { "=" }, new string[] { tbUserName.Text.ToString() }); if (dataReader.Read() && !dataReader.GetString(dataReader.GetOrdinal("账号")).Equals(_name))//判断账号是否已经存在且不是当前账号 { MessageBox.Show("账户已经存在"); return; } else { sqlLiteHelper.UpdateValues(_tableName, new string[] { "账号", "密码", "权限" }, new string[] { tbUserName.Text.ToString(), tbPwd.Text.ToString(), cbAccountPermission.Text.ToString() }, "id", _id + ""); } } else { SQLiteDataReader dataReader = sqlLiteHelper.ReadTable(_tableName, new string[] { "*" }, new string[] { "账号" }, new string[] { "=" }, new string[] { tbUserName.Text.ToString() }); if (dataReader.HasRows)//判断账号是否已经存在 { MessageBox.Show("账户已经存在"); return; } else { sqlLiteHelper.InsertValues(_tableName, new string[] { tbUserName.Text.ToString(), tbPwd.Text.ToString(), cbAccountPermission.Text.ToString() }); } } if (_fatherForm != null) { _fatherForm.UpdateData(); } Close(); }