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