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();
}
