private SqlLiteHelper GetSqlLiteHelper() { if (sqlLiteHelper == null) { sqlLiteHelper = SqlLiteHelper.GetInstance(); } return(sqlLiteHelper); }
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(); }
private Boolean IsAccountValid(string name, string pwd) { Boolean result = false; if (Properties.Settings.Default.user.Equals(name) && Properties.Settings.Default.pwd.Equals(pwd)) { return(true); } try { SqlLiteHelper sqlLiteHelper = SqlLiteHelper.GetInstance(); string query = "select * from account where 账号=" + "'" + name + "'" + " and 密码=" + "'" + pwd + "'"; SQLiteDataReader dataReader = sqlLiteHelper.ExecuteQuery(query); if (dataReader.HasRows) { result = true; } } catch (Exception e) { Console.WriteLine(e.Message); } return(result); }