protected void OnBtnLoginClicked(object sender, EventArgs e) { String path = System.IO.Directory.GetCurrentDirectory() + "/"; String dbName = "sigomDb.db"; String dbPathFile = path + dbName; DbLite dbl = new DbLite(); dbl.showMessage(dbPathFile); String tableName = "Login"; etrUser.Text = etrUser.Text.Trim(); etrPsw.Text = etrPsw.Text.Trim(); if ((etrUser.Text != "") && (etrPsw.Text != "")) { String getData = dbl.dbGetCommand(dbPathFile, tableName, "Nome", "Nome", etrUser.Text); if (etrUser.Text == getData) { getData = dbl.dbGetCommand(dbPathFile, tableName, "Senha", "Senha", etrPsw.Text); if (etrPsw.Text == getData) { sigom.WorkshopWindow ww = new sigom.WorkshopWindow(); ww.Show(); this.Destroy(); } else { dbl.showMessage("Usuário e/ou Senha incorreto!"); } } else { dbl.showMessage("Usuário e/ou Senha incorreto!"); } } else { dbl.showMessage("Usuário e/ou Senha é obrigatório!"); } }
protected void OnBtnOsAbertasClicked(object sender, EventArgs e) { String path = System.IO.Directory.GetCurrentDirectory() + "/"; String dbName = "sigomDb.db"; String dbPathFile = path + dbName; DbLite dbl = new DbLite(); List <String> getData = new List <String>(); String tableName = "OrdemServico"; getData = dbl.dbGetCommand(dbPathFile, tableName, "numOs", "Status", "ABERTO"); sigom.fifoService fs = new fifoService(getData); }