// Gravar nova tab de aplicativo public int Gravar(Aplicativos_Tabs rs) { try { int idtab = 0; string qry = ""; qry += "INSERT INTO Aplicativos_Tabs (idaplicativo, txaction, txcontroller, txicone, idcodigoidioma, nrordem) "; qry += "VALUES (" + rs.idaplicativo.value + ", '" + rs.txaction.value + "', '" + rs.txcontroller.value + "', '" + rs.txicone.value + "', "; qry += rs.idcodigoidioma.value + ", " + rs.nrordem.value + ")"; Connection session = new Connection(); Query query = session.CreateQuery(qry); // Retorna o identificador idtab = query.ExecuteScalar(); // Atualizar registro para registro de auditoria rs.idtab.value = idtab; session.Close(); // Auditoria Audit.Check("Aplicativos_Tabs", "I", idtab, rs); return(idtab); } catch (Exception erro) { throw erro; } }
// Busca pelo código public Aplicativos_Tabs Buscar(int idtab = 0) { try { Aplicativos_Tabs tabs = new Aplicativos_Tabs(); string qry = ""; qry += "SELECT at.*, a.txaplicativo FROM Aplicativos_Tabs at "; qry += "INNER JOIN Aplicativos a ON a.idaplicativo = at.idaplicativo WHERE at.idtab = " + idtab; Connection session = new Connection(); Query query = session.CreateQuery(qry); IDataReader reader = query.ExecuteQuery(); if (reader.Read()) { tabs.idtab.value = Convert.ToInt32(reader["idtab"]); tabs.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]); tabs.txaction.value = Convert.ToString(reader["txaction"]); tabs.txcontroller.value = Convert.ToString(reader["txcontroller"]); tabs.txicone.value = Convert.ToString(reader["txicone"]); tabs.idcodigoidioma.value = Convert.ToInt32(reader["idcodigoidioma"]); tabs.nrordem.value = Convert.ToInt32(reader["nrordem"]); tabs.txaplicativo.value = Convert.ToString(reader["txaplicativo"]); } reader.Close(); session.Close(); return(tabs); } catch (Exception error) { throw error; } }
// Excluir widget public void Excluir(Aplicativos_Tabs rs) { try { string qry = ""; qry += "DELETE FROM Aplicativos_Tabs "; qry += "WHERE idtab = " + rs.idtab.value; Connection session = new Connection(); Query query = session.CreateQuery(qry); query.ExecuteUpdate(); // Auditoria Audit.Check("Aplicativos_Tabs", "D", rs.idtab.value, rs); session.Close(); } catch (Exception erro) { throw erro; } }
// Lista Tabs public List <Aplicativos_Tabs> ListarTabsApp(int aplicativo = 0) { try { List <Aplicativos_Tabs> tabs = new List <Aplicativos_Tabs>(); string qry = ""; qry += "SELECT at.*, a.txpasta, a.flscript, a.txaplicativo FROM Aplicativos_Tabs at INNER JOIN Aplicativos a ON a.idaplicativo = at.idaplicativo "; qry += "WHERE at.idaplicativo = " + aplicativo + " ORDER BY at.nrordem"; Connection session = new Connection(); Query query = session.CreateQuery(qry); IDataReader reader = query.ExecuteQuery(); while (reader.Read()) { Aplicativos_Tabs temp = new Aplicativos_Tabs(); temp.idtab.value = Convert.ToInt32(reader["idtab"]); temp.idaplicativo.value = Convert.ToString(reader["idaplicativo"]); temp.txaction.value = Convert.ToString(reader["txaction"]); temp.txcontroller.value = Convert.ToString(reader["txcontroller"]); temp.txicone.value = Convert.ToString(reader["txicone"]); temp.idcodigoidioma.value = Convert.ToInt32(reader["idcodigoidioma"]); temp.nrordem.value = Convert.ToInt32(reader["nrordem"]); temp.txpasta.value = Convert.ToString(reader["txpasta"]); temp.flscript.value = Convert.ToInt32(reader["flscript"]); temp.txaplicativo.value = Convert.ToString(reader["txaplicativo"]); tabs.Add(temp); } reader.Close(); session.Close(); return(tabs); } catch (Exception error) { throw error; } }
// Alterar tab de aplicativo public void Alterar(Aplicativos_Tabs rs, Aplicativos_Tabs temp) { try { string qry = ""; qry += "UPDATE Aplicativos_Tabs "; qry += "SET idaplicativo = " + rs.idaplicativo.value + ", txaction = '" + rs.txaction.value + "', txcontroller = '" + rs.txcontroller.value + "', "; qry += "txicone = '" + rs.txicone.value + "', idcodigoidioma = " + rs.idcodigoidioma.value + ", nrordem = " + rs.nrordem.value + " "; qry += "WHERE idtab = " + rs.idtab.value; Connection session = new Connection(); Query query = session.CreateQuery(qry); query.ExecuteUpdate(); // Auditoria Audit.Check("Aplicativos_Tabs", "U", rs.idtab.value, rs, temp); session.Close(); } catch (Exception erro) { throw erro; } }
// Listagem Widget public (List <Aplicativos_Tabs>, WidgetsListConfig) ListarWidget(FormCollection form = null) { try { List <Aplicativos_Tabs> list = new List <Aplicativos_Tabs>(); WidgetsListConfig control = new WidgetsListConfig(); string filter = ""; // Parametros de pesquisa int page = 1; int registers = 10; string order = "at.idtab"; string direction = "asc"; // Filtra somente os widgets do aplicativo filter += "AND aw.idaplicativo = " + Convert.ToInt32(form["widget_temp_main_id"]) + ""; // Filtro de resultados if (form != null) { // Variáveis de controle if (form.AllKeys.Contains("widget_temp_page")) { page = Convert.ToInt32(form["widget_temp_page"]); } if (form.AllKeys.Contains("widget_temp_registers")) { registers = Convert.ToInt32(form["widget_temp_registers"]); } if (form.AllKeys.Contains("widget_temp_order")) { order = form["widget_temp_order"]; } if (form.AllKeys.Contains("widget_temp_direction")) { direction = form["widget_temp_direction"]; } } // Controle de widget control.count = 0; control.registers = registers; control.page = page; control.order = order; control.direction = direction; control.columns = new int[8] { 0, 0, 20, 20, 20, 10, 20, 10 }; control.show = new int[8] { 0, 0, 1, 1, 1, 1, 1, 1 }; control.headers = new string[8] { "268", "229", "230", "231", "232", "247", "145", "246" }; control.orderfields = new string[8] { "at.idtab", "at.idaplicativo", "a.txaplicativo", "at.txaction", "at.txcontroller", "at.txicone", "at.idcodigoidioma", "at.nrordem" }; control.fields = new string[8] { "idtab", "idaplicativo", "txaplicativo", "txaction", "txcontroller", "txicone", "idcodigoidioma", "nrordem" }; control.formatFields = new string[8] { "master", "", "", "", "", "", "language", "" }; // Query string qry = ""; qry += "SELECT COUNT (*) OVER () AS ROW_COUNT, at.idtab, at.idaplicativo, a.txaplicativo, at.txaction, at.txcontroller, at.txicone, at.idcodigoidioma, at.nrordem "; qry += "FROM Aplicativos_Tabs at "; qry += "INNER JOIN Aplicativos a ON a.idaplicativo = at.idaplicativo "; qry += "WHERE 1=1 " + filter; qry += "ORDER BY " + Utils.Null(order, "at.idtab") + " " + direction + " "; qry += "OFFSET " + ((page - 1) * registers) + " ROWS FETCH NEXT " + registers + " ROWS ONLY"; Connection session = new Connection(); Query query = session.CreateQuery(qry); IDataReader reader = query.ExecuteQuery(); while (reader.Read()) { control.count = Convert.ToInt32(reader["ROW_COUNT"]); Aplicativos_Tabs temp = new Aplicativos_Tabs(); temp.idtab.value = Convert.ToInt32(reader["idtab"]); temp.idaplicativo.value = Convert.ToString(reader["idaplicativo"]); temp.txaction.value = Convert.ToString(reader["txaction"]); temp.txcontroller.value = Convert.ToString(reader["txcontroller"]); temp.txicone.value = Convert.ToString(reader["txicone"]); temp.idcodigoidioma.value = Convert.ToInt32(reader["idcodigoidioma"]); temp.nrordem.value = Convert.ToInt32(reader["nrordem"]); temp.txaplicativo.value = Convert.ToString(reader["txaplicativo"]); list.Add(temp); } reader.Close(); session.Close(); return(list, control); } catch (Exception error) { throw error; } }