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