private void IniciarSesion()
{
ControlDB DBControl = new ControlDB(ControlDB.cPath, "dbQA.mdf");
string[] parameters = { "@id", "@pass" };
string[] elements = { TxtUserName.Text, TxtPsw.Text };
TxtUserName.Clear();
TxtPsw.Clear();
List <string> admins = new List <string> {
"Adm", "Dev"
};
if (DBControl.Buscar("select * from [User] where [Username]=@id and [Password]=@pass", parameters, elements))
{
string cat = DBControl.BuscarElemento("select [Tipo] from [User] where [UserName]=@id and [Password]=@pass", parameters, elements);
MainPage mainPage = new MainPage(cat);
this.Hide();
mainPage.ShowDialog();
this.Show();
TxtUserName.Focus();
}
else
{
MessageBox.Show("Usuario o contraseña inválidos");
TxtUserName.Focus();
TxtPsw.Text = "";
}
}
private void MaterialSingleLineTextField1_KeyDown(object sender, KeyEventArgs e)
{
if (Keys.Enter == e.KeyCode)
{
TxtPsw.Focus();
}
}
private void materialRaisedButton1_Click(object sender, EventArgs e)
{
if (TxtPsw.Text != TxtRepeatPsw.Text)
{
MessageBox.Show("Contraseña diferente", "Google LLC", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtPsw.Text = "";
TxtRepeatPsw.Text = "";
TxtPsw.Focus();
return;
}
try
{
if (TxtPsw.Text == TxtUsername.Text)
{
MessageBox.Show("El usuario y al contraseña no pueden ser iguales");
TxtUsername.Clear();
TxtPsw.Clear();
TxtRepeatPsw.Clear();
comboBox1.SelectedIndex = 0;
return;
}
ControlDB DBControl = new ControlDB(ControlDB.cPath, "dbQA.mdf");
string[] parameters = { "@name", "@Username", "@pass", "cat" };
string[] elements = { TxtName.Name, TxtUsername.Text, TxtPsw.Text, comboBox1.SelectedIndex.ToString() };
if (DBControl.Buscar("Select * from [User] where Username=@userName", parameters, elements))
{
MessageBox.Show("El usuario ya existe");
TxtUsername.Clear();
TxtPsw.Clear();
return;
}
if (DBControl.Insertar("insert into [User] values(@Name,@userName,@pass,@cat)", parameters, elements))
{
//MessageBox.Show("Usuario agregado");
}
else
{
MessageBox.Show("El usuario no pudo ser agregado");
DBControl.Close();
return;
}
DBControl.Close();
}
catch (Exception)
{
MessageBox.Show("Por favor, verifique los datos");
}
// Despues de Agregar Usuario
MessageBox.Show("Usuario agregado Correctamente", "Google LLC", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void devAdd()
{
try
{
if (TxtPsw.Text == TxtUserName.Text)
{
MessageBox.Show("El usuario y al contraseña no pueden ser iguales");
TxtUserName.Clear();
TxtPsw.Clear();
return;
}
ControlDB DBControl = new ControlDB(ControlDB.cPath, "dbQA.mdf");
string[] parameters = { "@name", "@Username", "@pass", "cat" };
string[] elements = { "No One", TxtUserName.Text, TxtPsw.Text, "Dev" };
if (DBControl.Buscar("Select * from [User] where Username=@userName", parameters, elements))
{
MessageBox.Show("El usuario ya existe");
TxtUserName.Clear();
TxtPsw.Clear();
return;
}
if (DBControl.Insertar("insert into [User] values(@Name,@userName,@pass,@cat)", parameters, elements))
{
MessageBox.Show("Usuario agregado");
}
else
{
MessageBox.Show("El usuario no pudo ser agregado");
}
DBControl.Close();
}
catch (Exception)
{
MessageBox.Show("Por favor, verifique los datos");
}
}
private void ButLogin_Click(object sender, EventArgs e)
{
if (comboId.Text != "" & TxtPsw.Text != "")
{
currentAccountNumber = comboId.Text.Trim(); // 用户编号
Boolean found = false;
// Check the password
if (isFirstLogin)
{
if (DEFAULT_ACCOUNT_PASSWORD.Equals(TxtPsw.Text.Trim()))
{
found = true;
currentAccountName = userAccounts[0].name;
// Insert to the database
String dStr = "insert into login(ID,code,name,password,permission,status) values ('"
+ "1" + "','" + userAccounts[0].number + "','" + userAccounts[0].name + "','"
+ DEFAULT_ACCOUNT_PASSWORD + "','" + userAccounts[0].permission.ToString() + "','"
+ Utils.Constants.ACCOUNT_STATUS_LOGIN.ToString() + "')";
Utils.DatabaseUtils.ExecuteSqlCommand(dStr);
}
}
else
{
foreach (Data.Account account in userAccounts)
{
if (account.number.Equals(comboId.Text.Trim()) && account.password.Equals(TxtPsw.Text.Trim()))
{
found = true;
currentAccountName = account.name;
String dStr = null;
// Find the last login account and update the status in database.
foreach (Data.Account account1 in userAccounts)
{
if (account1.status == Utils.Constants.ACCOUNT_STATUS_LOGIN)
{
dStr = "Update login set status='" + Utils.Constants.ACCOUNT_STATUS_LOGOUT.ToString()
+ "'" + " where code='" + account1.number + "'";
Utils.DatabaseUtils.ExecuteSqlCommand(dStr);
break;
}
}
// Update the account status in database.
dStr = "Update login set status='" + Utils.Constants.ACCOUNT_STATUS_LOGIN.ToString()
+ "'" + " where code='" + account.number + "'";
Utils.DatabaseUtils.ExecuteSqlCommand(dStr);
break;
}
}
}
if (found)
{
// 登录日志
string dStr = "insert into operationlog (code,name,operationtime,hardware,details) values ('"
+ currentAccountNumber + "','" + currentAccountName + "','" + DateTime.Now.ToString() + "','成品包装系统','系统登录')";
Utils.DatabaseUtils.ExecuteSqlCommand(dStr);
// TODO: Close this form.
this.Hide();
// this.Close();
frmMain frmMain1 = new frmMain(currentAccountNumber, currentAccountName);
frmMain1.ShowDialog();
}
else
{
MessageBox.Show("输入的用户名或者密码不正确！");
TxtPsw.Focus();
return;
}
}
else
{
MessageBox.Show("输入不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}