private void InitSystem()
{
UserKeys.Add("root", "root");
SimpleSqlite sqlite = new SimpleSqlite("personal", "Database");
sqlite.QueryColumnsNumber("SimpleUI.db3", "UPS");
if (sqlite.CreateDatabase("simpleUI.db3"))
{
sqlite.CreateTable("simpleUI.db3", "UPS",
new Dictionary <string, string>()
{
{ "USER", "VARCHAR(20)" },
{ "PASSWORD", "VARCHAR(20)" }
});
sqlite.InsertInto("SimpleUI.db3", "UPS", new List <string>()
{
"root", "root"
});
sqlite.InsertInto("SimpleUI.db3", "UPS", new List <string>()
{
"root2", "root2"
});
}
}
private bool Access(string User, string Password)
{
SimpleSqlite sqlite = new SimpleSqlite("personal", "Database");
List <Dictionary <string, string> > result
= sqlite.QueryFrom("simpleUI.db3", "UPS", new List <string>()
{
"*"
}, String.Format("USER='******'", User));
if (result == null)
{ //数据库出错
return(false);
}
if (result.Count == 0)
{ //不存在该用户
return(false);
}
string correctPassword = null;
result[0].TryGetValue("PASSWORD", out correctPassword);
if (correctPassword == null)
{ //数据库出错
return(false);
}
if (correctPassword != Password)
{ //密码错误
return(false);
}
return(true);
}
private void SureEvent(object sender, EventArgs e)
{
string user = UserName.Text;
string password = Password.Text;
string twice = TwicePassword.Text;
//check input
if (user.Equals("") || password.Equals("") || twice.Equals(""))
{
SimpleAlert.Show("错误", "请输入完整", "确定");
return;
}
if (!password.Equals(twice))
{
SimpleAlert.Show("错误", "两次密码应该一样", "确定");
return;
}
//finish
SimpleSqlite.InsertInto("personal", "Database", "SimpleUI.db3", "UPS", new List <string>()
{
user, password
});
this.NavigationController.PopViewController(true);
}
