// Listagem Widget
public (List <Aplicativos_Widgets>, WidgetsListConfig) ListarWidget(FormCollection form = null)
{
try
{
List <Aplicativos_Widgets> list = new List <Aplicativos_Widgets>();
WidgetsListConfig control = new WidgetsListConfig();
string filter = "";
// Parametros de pesquisa
int page = 1;
int registers = 10;
string order = "w.txwidget";
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)
{
// Aplicativo
if (form.AllKeys.Contains("filter_txaplicativo"))
{
string filter_txaplicativo = Utils.ClearText(form["filter_txaplicativo"], 20);
if (filter_txaplicativo.Length > 0)
{
filter += "AND a.txaplicativo LIKE '%" + filter_txaplicativo.Replace(" ", "%") + "%' ";
}
}
// Action
if (form.AllKeys.Contains("filter_txwidget"))
{
string filter_txaction = Utils.ClearText(form["filter_txwidget"], 20);
if (filter_txaction.Length > 0)
{
filter += "AND w.txwidget LIKE '%" + filter_txaction.Replace(" ", "%") + "%' ";
}
}
// 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[13] {
0, 0, 16, 0, 16, 8, 8, 8, 8, 8, 12, 8, 8
};
control.show = new int[13] {
0, 0, 1, 0, 1, 1, 1, 1, 1, 0, 1, 0, 0
};
control.headers = new string[13] {
"289", "229", "230", "265", "267", "262", "263", "231", "232", "294", "291", "292", "293"
};
control.orderfields = new string[13] {
"aw.idaplicativo_widget", "aw.idaplicativo", "a.txaplicativo", "aw.idwidget", "w.txwidget", "aw.nrxpos", "aw.nrypos", "aw.txaction", "aw.txcontroller", "aw.idcodigoidioma", "aw.txappaction", "aw.txclass", "aw.txmethod"
};
control.fields = new string[13] {
"idaplicativo_widget", "idaplicativo", "txaplicativo", "idwidget", "txwidget", "nrxpos", "nrypos", "txaction", "txcontroller", "idcodigoidioma", "txappaction", "txclass", "txmethod"
};
control.formatFields = new string[13] {
"master", "", "", "", "", "", "", "", "", "language", "", "", ""
};
// Query
string qry = "";
qry += "SELECT COUNT (*) OVER () AS ROW_COUNT, aw.idaplicativo_widget, aw.idaplicativo, a.txaplicativo, aw.idwidget, w.txwidget, aw.nrxpos, aw.nrypos, ";
qry += "aw.txaction, aw.txcontroller, aw.idcodigoidioma, aw.txappaction, aw.txclass, aw.txmethod ";
qry += "FROM Aplicativos_Widgets aw ";
qry += "INNER JOIN Aplicativos a ON a.idaplicativo = aw.idaplicativo ";
qry += "INNER JOIN Widgets w ON w.idwidget = aw.idwidget ";
qry += "WHERE 1=1 " + filter;
qry += "ORDER BY " + Utils.Null(order, "w.txwidget") + " " + 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_Widgets temp = new Aplicativos_Widgets();
temp.idaplicativo_widget.value = Convert.ToInt32(reader["idaplicativo_widget"]);
temp.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
temp.idwidget.value = Convert.ToInt32(reader["idwidget"]);
temp.nrxpos.value = Convert.ToInt32(reader["nrxpos"]);
temp.nrypos.value = Convert.ToInt32(reader["nrypos"]);
temp.txaction.value = Convert.ToString(reader["txaction"]);
temp.txcontroller.value = Convert.ToString(reader["txcontroller"]);
temp.idcodigoidioma.value = Convert.ToInt32(reader["idcodigoidioma"]);
temp.txappaction.value = Convert.ToString(reader["txappaction"]);
temp.txclass.value = Convert.ToString(reader["txclass"]);
temp.txmethod.value = Convert.ToString(reader["txmethod"]);
temp.txwidget.value = Convert.ToString(reader["txwidget"]);
temp.txaplicativo.value = Convert.ToString(reader["txaplicativo"]);
list.Add(temp);
}
reader.Close();
session.Close();
return(list, control);
}
catch (Exception error)
{
throw error;
}
}
// Listagem Widget
public (List <Aplicativos>, WidgetsListConfig) ListarWidget(FormCollection form = null)
{
try
{
List <Aplicativos> list = new List <Aplicativos>();
WidgetsListConfig control = new WidgetsListConfig();
string filter = "";
// Parametros de pesquisa
int page = 1;
int registers = 10;
string order = "a.txaplicativo";
string direction = "asc";
// Filtro de resultados
if (form != null)
{
// Aplicativo
if (form.AllKeys.Contains("filter_txaplicativo"))
{
string filter_txaplicativo = Utils.ClearText(form["filter_txaplicativo"], 20);
if (filter_txaplicativo.Length > 0)
{
filter += "AND a.txaplicativo LIKE '%" + filter_txaplicativo.Replace(" ", "%") + "%' ";
}
}
// Action
if (form.AllKeys.Contains("filter_txaction"))
{
string filter_txaction = Utils.ClearText(form["filter_txaction"], 20);
if (filter_txaction.Length > 0)
{
filter += "AND a.txaction LIKE '%" + filter_txaction.Replace(" ", "%") + "%' ";
}
}
// Controller
if (form.AllKeys.Contains("filter_txcontroller"))
{
string filter_txcontroller = Utils.ClearText(form["filter_txcontroller"], 20);
if (filter_txcontroller.Length > 0)
{
filter += "AND a.txcontroller LIKE '%" + filter_txcontroller.Replace(" ", "%") + "%' ";
}
}
// 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[9] {
0, 28, 12, 12, 0, 12, 12, 12, 12
};
control.show = new int[9] {
0, 1, 1, 1, 0, 1, 1, 1, 1
};
control.headers = new string[9] {
"199", "230", "231", "232", "143", "144", "272", "280", "281"
};
control.orderfields = new string[9] {
"a.idaplicativo", "a.txaplicativo", "a.txaction", "a.txcontroller", "a.idtabela", "t.txtabela", "a.txmainaction", "a.txpasta", "a.flscript"
};
control.fields = new string[9] {
"idaplicativo", "txaplicativo", "txaction", "txcontroller", "idtabela", "txtabela", "txmainaction", "txpasta", "flscript"
};
control.formatFields = new string[9] {
"master", "", "", "", "", "", "", "", "boolean"
};
// Query
string qry = "";
qry += "SELECT COUNT (*) OVER () AS ROW_COUNT, a.idaplicativo, a.txaplicativo, a.txaction, a.txcontroller, a.idtabela, t.txtabela, a.txmainaction, a.txpasta, a.flscript ";
qry += "FROM Aplicativos a ";
qry += "LEFT JOIN Tabelas t ON t.idtabela = a.idtabela ";
qry += "WHERE 1=1 " + filter;
qry += "ORDER BY " + Utils.Null(order, "a.txaplicativo") + " " + 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 temp = new Aplicativos();
temp.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
temp.txaplicativo.value = Convert.ToString(reader["txaplicativo"]);
temp.txaction.value = Convert.ToString(reader["txaction"]);
temp.txcontroller.value = Convert.ToString(reader["txcontroller"]);
temp.idtabela.value = Convert.ToInt32(reader["idtabela"]);
temp.txtabela.value = Convert.ToString(reader["txtabela"]);
temp.txmainaction.value = Convert.ToString(reader["txmainaction"]);
temp.txpasta.value = Convert.ToString(reader["txpasta"]);
temp.flscript.value = Convert.ToInt32(reader["flscript"]);
list.Add(temp);
}
reader.Close();
session.Close();
return(list, control);
}
catch (Exception error)
{
throw error;
}
}
// Listagem
public (List <Menus>, WidgetsListConfig) ListarWidget(FormCollection form = null)
{
try
{
List <Menus> list = new List <Menus>();
WidgetsListConfig control = new WidgetsListConfig();
string filter = "";
// Parametros de pesquisa
int page = 1;
int registers = 10;
string order = "m.idmenu";
string direction = "asc";
// Filtro de resultados
if (form != null)
{
// Aplicativo
if (form.AllKeys.Contains("filter_aplicativo"))
{
string filter_aplicativo = Utils.ClearText(form["filter_aplicativo"], 50);
if (filter_aplicativo.Length > 0)
{
filter += "AND a.txaplicativo LIKE '%" + filter_aplicativo.Replace(" ", "%") + "%' ";
}
}
// Ativo
if (form.AllKeys.Contains("filter_flativo"))
{
filter += "AND m.flativo = " + Convert.ToInt32(Utils.Null(form["filter_flativo"], "0")) + " ";
}
// Master
if (form.AllKeys.Contains("filter_flmaster"))
{
filter += "AND m.flmaster = " + Convert.ToInt32(Utils.Null(form["filter_flmaster"], "0")) + " ";
}
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, 20, 20, 20, 10, 10, 10, 10
};
control.show = new int[8] {
0, 1, 1, 1, 1, 1, 1, 1
};
control.headers = new string[8] {
"244", "28", "245", "230", "247", "246", "33", "34"
};
control.orderfields = new string[8] {
"m.idmenu", "m.idcodigoidioma", "m.idmenupai", "a.txaplicativo", "", "m.nrordem", "m.flativo", "m.flmaster"
};
control.fields = new string[8] {
"idmenu", "idcodigoidioma", "menupai", "aplicativo", "txicone", "nrordem", "flativo", "flmaster"
};
control.formatFields = new string[8] {
"master", "language", "language", "", "", "", "boolean", "boolean"
};
// Query
string qry = "";
qry += "SELECT COUNT (*) OVER () AS ROW_COUNT, m.idmenu, m.idcodigoidioma, m.idmenupai, m.idaplicativo, m.txicone, m.nrordem, ";
qry += "m.flativo, m.flmaster, ISNULL(mp.idcodigoidioma, 0) as idcodigoidioma_pai, a.txaplicativo ";
qry += "FROM Menus m ";
qry += "LEFT JOIN menus mp ON mp.idmenu = m.idmenupai ";
qry += "LEFT JOIN aplicativos a ON a.idaplicativo = m.idaplicativo ";
qry += "WHERE 1=1 " + filter;
qry += "ORDER BY " + Utils.Null(order, "m.idmenu") + " " + 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"]);
Menus temp = new Menus();
temp.idmenu.value = Convert.ToInt32(reader["idmenu"]);
temp.idmenupai.value = Convert.ToInt32(reader["idmenupai"]);
temp.idcodigoidioma.value = Convert.ToInt32(reader["idcodigoidioma"]);
temp.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
temp.txicone.value = Convert.ToString(reader["txicone"]);
temp.nrordem.value = Convert.ToInt32(reader["nrordem"]);
temp.flativo.value = Convert.ToInt32(reader["flativo"]);
temp.flmaster.value = Convert.ToInt32(reader["flmaster"]);
temp.menupai.value = Convert.ToInt32(reader["idcodigoidioma_pai"]);
temp.aplicativo.value = Convert.ToString(reader["txaplicativo"]);
temp.menu_nome.value = Language.XmlLang(Convert.ToInt32(Utils.Null(Convert.ToString(reader["idcodigoidioma"]), "0")), 2).Text;
temp.menupai_nome.value = Language.XmlLang(Convert.ToInt32(Utils.Null(Convert.ToString(reader["idcodigoidioma_pai"]), "0")), 2).Text;
list.Add(temp);
}
reader.Close();
session.Close();
return(list, control);
}
catch (Exception error)
{
throw error;
}
}
// Listagem
public (List <Widgets>, WidgetsListConfig) ListarWidget(FormCollection form = null)
{
try
{
List <Widgets> list = new List <Widgets>();
WidgetsListConfig control = new WidgetsListConfig();
string filter = "";
// Parametros de pesquisa
int page = 1;
int registers = 10;
string order = "txwidget";
string direction = "asc";
// 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[7] {
0, 40, 10, 15, 10, 15, 10
};
control.show = new int[7] {
0, 1, 1, 1, 1, 1, 1
};
control.headers = new string[7] {
"199", "264", "257", "259", "258", "260", "261"
};
control.orderfields = new string[7] {
"idwidget", "txwidget", "nrwidth", "nrminwidth", "nrheight", "nrminheight", "flresize"
};
control.fields = new string[7] {
"idwidget", "txwidget", "nrwidth", "nrminwidth", "nrheight", "nrminheight", "flresize"
};
control.formatFields = new string[7] {
"master", "", "", "", "", "", "boolean"
};
// Query
string qry = "";
qry += "SELECT COUNT (*) OVER () AS ROW_COUNT, idwidget, txwidget, nrwidth, nrminwidth, nrheight, nrminheight, flresize ";
qry += "FROM Widgets ";
qry += "WHERE 1=1 " + filter;
qry += "ORDER BY " + Utils.Null(order, "idwidget") + " " + 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"]);
Widgets widgets = new Widgets();
widgets.idwidget.value = Convert.ToInt32(reader["idwidget"]);
widgets.txwidget.value = Convert.ToString(reader["txwidget"]);
widgets.nrwidth.value = Convert.ToInt32(reader["nrwidth"]);
widgets.nrheight.value = Convert.ToInt32(reader["nrheight"]);
widgets.nrminwidth.value = Convert.ToInt32(reader["nrminwidth"]);
widgets.nrminheight.value = Convert.ToInt32(reader["nrminheight"]);
widgets.flresize.value = Convert.ToInt32(reader["flresize"]);
list.Add(widgets);
}
reader.Close();
session.Close();
return(list, control);
}
catch (Exception error)
{
throw error;
}
}
// Listagem
public (List <Tabelas>, WidgetsListConfig) ListarWidget(FormCollection form = null)
{
try
{
List <Tabelas> list = new List <Tabelas>();
WidgetsListConfig control = new WidgetsListConfig();
string filter = "";
// Parametros de pesquisa
int page = 1;
int registers = 10;
string order = "txtabela";
string direction = "asc";
// Filtro de resultados
if (form != null)
{
if (form.AllKeys.Contains("filter_txtabela"))
{
string filter_txtabela = Utils.ClearText(form["filter_txtabela"], 50);
if (filter_txtabela.Length > 0)
{
filter += "AND txtabela LIKE '%" + filter_txtabela.Replace(" ", "%") + "%' ";
}
}
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[4] {
0, 34, 33, 34
};
control.show = new int[4] {
0, 1, 1, 1
};
control.headers = new string[4] {
"199", "144", "141", "139"
};
control.orderfields = new string[4] {
"idtabela", "txtabela", "flauditoria", "idcodigoidioma"
};
control.fields = new string[4] {
"idtabela", "txtabela", "flauditoria", "idcodigoidioma"
};
control.formatFields = new string[4] {
"master", "", "boolean", "language"
};
// Query
string qry = "";
qry += "SELECT COUNT (*) OVER () AS ROW_COUNT, idtabela, txtabela, flauditoria, idcodigoidioma ";
qry += "FROM Tabelas ";
qry += "WHERE 1=1 " + filter;
qry += "ORDER BY " + Utils.Null(order, "txtabela") + " " + 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"]);
Tabelas temp = new Tabelas();
temp.idtabela.value = Convert.ToInt32(reader["idtabela"]);
temp.txtabela.value = Convert.ToString(reader["txtabela"]);
temp.flauditoria.value = Convert.ToInt32(reader["flauditoria"]);
temp.idcodigoidioma.value = Convert.ToInt32(reader["idcodigoidioma"]);
list.Add(temp);
}
reader.Close();
session.Close();
return(list, control);
}
catch (Exception error)
{
throw error;
}
}
// 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;
}
}
// Listagem
public (List <Modulos>, WidgetsListConfig) ListarWidget(FormCollection form = null)
{
try
{
List <Modulos> list = new List <Modulos>();
WidgetsListConfig control = new WidgetsListConfig();
string filter = "";
// Parametros de pesquisa
int page = 1;
int registers = 10;
string order = "txmodulo";
string direction = "asc";
// Filtro de resultados
if (form != null)
{
if (form.AllKeys.Contains("filter_txmodulo"))
{
string filter_txmodulo = Utils.ClearText(form["filter_txmodulo"], 50);
if (filter_txmodulo.Length > 0)
{
filter += "AND txmodulo LIKE '%" + filter_txmodulo.Replace(" ", "%") + "%' ";
}
}
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[6] {
0, 30, 30, 10, 10, 10
};
control.show = new int[6] {
0, 1, 1, 1, 1, 1
};
control.headers = new string[6] {
"244", "255", "230", "254", "147", "148"
};
control.orderfields = new string[6] {
"m.idmodulo", "m.txmodulo", "a.txaplicativo", "m.flinserir", "m.flalterar", "m.flexcluir"
};
control.fields = new string[6] {
"idmodulo", "txmodulo", "aplicativo", "flinserir", "flalterar", "flexcluir"
};
control.formatFields = new string[6] {
"master", "", "", "boolean", "boolean", "boolean"
};
// Query
string qry = "";
qry += "SELECT COUNT (*) OVER () AS ROW_COUNT, m.idmodulo, m.txmodulo, m.idaplicativo, m.flinserir, m.flalterar, m.flexcluir, a.txaplicativo ";
qry += "FROM modulos m ";
qry += "LEFT JOIN aplicativos a ON a.idaplicativo = m.idaplicativo ";
qry += "WHERE 1=1 " + filter;
qry += "ORDER BY " + Utils.Null(order, "m.idmodulo") + " " + 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"]);
Modulos temp = new Modulos();
temp.idmodulo.value = Convert.ToInt32(reader["idmodulo"]);
temp.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
temp.txmodulo.value = Convert.ToString(reader["txmodulo"]);
temp.flinserir.value = Convert.ToInt32(reader["flinserir"]);
temp.flalterar.value = Convert.ToInt32(reader["flalterar"]);
temp.flexcluir.value = Convert.ToInt32(reader["flexcluir"]);
temp.aplicativo.value = Convert.ToString(reader["txaplicativo"]);
list.Add(temp);
}
reader.Close();
session.Close();
return(list, control);
}
catch (Exception error)
{
throw error;
}
}