public WebTreeViewClassMovimenti(DataAccess Conn, DataTable T, hwTreeView tree, string filterc,
string filtersql, bool all, int maxlevel)
: //,int levelop):
base(T, tree,
(all?
new easy_node_dispatcher(
"sortinglevel",
"nlevel",
"description",
null,
"description",
"sortcode"
):
new sorting_node_dispatcher(
"sortinglevel", //level_table
"nlevel", //level_field
"description", //descr_level_field
//levelop,//selectable_level_field
"description", //descr_field
"sortcode", maxlevel, Conn
)
), filterc, filtersql)
{
this.maxlevel = maxlevel;
if (all)
{
base.DoubleClickForSelect = false;
}
}
public hwTreeViewBilancio(DataTable T, hwTreeView tree, string filterc,
string filtersql, string kind, bool all, int maxlevel, int levelop) :
base(T, tree,
(all?new easy_node_dispatcher(
"finlevel",
"nlevel",
"description",
null,
"title",
"codefin")
:new bilancio_node_dispatcher(
"finlevel",
"nlevel",
"description",
levelop,
"title",
"codefin",
maxlevel
)
), filterc, filtersql)
{
this.kind = kind;
//se all vale true disabilito il doppio click come selezione
if (all)
{
base.DoubleClickForSelect = false;
}
}
public WebTreeViewBilancio(DataAccess Conn, DataTable T, hwTreeView tree, string filterc, string filtersql,
string kind, bool all, int maxlevel, int levelop) :
base(T, tree,
(all?new easy_node_dispatcher(
"finlevel",
"nlevel",
"description",
null,
"title",
"codefin")
:new bilancio_node_dispatcher(
"finlevel",
"nlevel",
"description",
levelop,
"title",
"codefin",
maxlevel,
Conn
)
), filterc, filtersql)
{
this.kind = kind;
if (all)
{
base.DoubleClickForSelect = false;
}
}
//modifiche luigi 8179
public override void WebDescribeTree(hwTreeView tree, DataTable T, string ListingType)
{
int maxDepth = 9; bool withdescr = true;
if (ListingType == "default")
{
base.DescribeColumns(T, ListingType);
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "idlocation", "Id Ubicazione");
DescribeAColumn(T, "locationcode", "Codice Ubicazione");
DescribeAColumn(T, "description", "Ubicazione");
}
base.WebDescribeTree(tree, T, ListingType);
string filterc = QHC.CmpEq("nlevel", 1);
string filtersql = QHS.CmpEq("nlevel", 1);
easy_node_dispatcher D = new location_node_dispatcher(
"locationlevel",
"nlevel",
"description",
null,
"description",
"locationcode"
);
WebTreeViewlocation M = new WebTreeViewlocation(T, tree, filterc, filtersql, maxDepth, withdescr);
}
public hwTreeViewAccount(DataAccess Conn, DataTable T, hwTreeView tree, string filterc,
string filtersql, bool all, int maxlevel) :
base(T, tree,
(all ? new easy_node_dispatcher(
"accountlevel",
"nlevel",
"description",
null,
"title",
"codeacc")
: new account_node_dispatcher(
"accountlevel",
"nlevel",
"description",
"flagusable",
"title",
"codeacc", maxlevel, Conn
)
), filterc, filtersql)
{
//se all vale true disabilito il doppio click come selezione
this.maxlevel = maxlevel;
if (all)
{
base.DoubleClickForSelect = false;
}
}
public WebTreeViewlocation(DataTable T, hwTreeView tree, string filterc, string filtersql, int maxlevel, bool withdescr)
:
base(T, tree,
(withdescr ? new easy_node_dispatcher(null, null, null, null, "idlocation", "Ubicazione") :
new location_node_dispatcher(null, null, null, null, "idlocation", "Ubicazione")
), filterc, filtersql)
{
base.DoubleClickForSelect = false;
}
public hwTreeViewAccMotiveApplied(DataAccess Conn, DataTable T, hwTreeView tree, string filterc, string filtersql,
int maxlevel) :
base(T, tree, new accmotiveapplied_node_dispatcher(
null,
null,
null,
null,
"motive",
"codemotive",
maxlevel,
Conn
), filterc, filtersql)
{
this.maxlevel = maxlevel;
}
public override void WebDescribeTree(hwTreeView tree, DataTable T, string ListingType)
{
int esercizio = Convert.ToInt32(GetSys("esercizio"));
int esercizionew = esercizio + 1;
string filteresercizio = QHC.CmpEq("ayear", GetSys("esercizio"));
string filterc = QHC.CmpEq("nlevel", "1");
string filtersql = QHS.CmpEq("nlevel", "1");
if (ListingType == "tree" || ListingType == "treeall" || ListingType == "treenew" || ListingType == "treeminusable")
{
base.DescribeColumns(T, ListingType);
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "!livello", "Livello", "accountlevel.description");
DescribeAColumn(T, "codeacc", "Codice");
DescribeAColumn(T, "title", "Denominazione");
}
int maxlevel = 0;
object o = Conn.DO_READ_VALUE("accountlevel", filteresercizio, "max(nlevel)");
if ((o != null) && (o != DBNull.Value))
{
maxlevel = Convert.ToInt32(o);
}
int minlevelop = CfgFn.GetNoNullInt32(GetSys("accountusablelevel"));
if (ListingType == "treeminusable")
{
maxlevel = minlevelop;
}
//Aggiorno le intestazioni del DataGrid
if (ListingType == "tree")
{
base.DescribeColumns(T, ListingType);
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "codeacc", "Codice");
DescribeAColumn(T, "title", "Denominazione");
}
base.WebDescribeTree(tree, T, ListingType);
hwTreeViewAccount M = new hwTreeViewAccount(Conn, T, tree, filterc, filtersql, false, maxlevel);
}
public override void WebDescribeTree(hwTreeView tree, DataTable T, string ListingType)
{
int esercizio = Convert.ToInt32(GetSys("esercizio"));
if (ListingType == "tree")
{
DescribeColumns(T, ListingType);
}
base.WebDescribeTree(tree, T, ListingType);
int maxlevel = 9;
string filterc = QHC.IsNull("paridaccmotive");
string filtersql = QHS.IsNull("paridaccmotive");
hwTreeViewManager M = new hwTreeViewAccMotiveApplied(Conn, T, tree, filterc, filtersql, maxlevel);
}
public hwTreeViewListClass(DataAccess Conn, DataTable T, hwTreeView tree, string filterc,
string filtersql, bool all, int maxlevel) :
base(T, tree,
new easy_node_dispatcher(
null,
null,
null,
null,
"title",
"codelistclass"),
filterc, filtersql)
{
//se all vale true disabilito il doppio click come selezione
if (all)
{
base.DoubleClickForSelect = false;
}
}
public override void WebDescribeTree(hwTreeView tree, DataTable T, string ListingType)
{
base.WebDescribeTree(tree, T, ListingType);
string filterc = QHC.CmpEq("nlevel", "1");
string filtersql = QHS.CmpEq("nlevel", "1");
if (ListingType != "history")
{
int eserc = CfgFn.GetNoNullInt32(GetSys("esercizio"));
filterc = QHC.AppAnd(filterc, QHC.NullOrLe("start", eserc), QHC.NullOrGe("stop", eserc));
filtersql = QHC.AppAnd(filtersql, QHS.NullOrLe("start", eserc), QHS.NullOrGe("stop", eserc));
}
// if (ListingType=="tree"){
// string eserc = esercizio.ToString();
// filter=filter+"AND(esercizio='" + eserc + "')";
// }
//easy_node_dispatcher D = new easy_node_dispatcher(
// "sortinglevel",
// "nlevel",
// "description",
// "flagusable",
// "description",
// "sortcode"
// );
int maxlevel = 0;
if (ListingType == "tree5")
{
maxlevel = 5;
}
bool all = false;
if (ListingType == "treeall")
{
all = true;
}
//object o = T.ExtendedProperties["idsorkindFilter"];
//string filtro = o==null
// ? QHS.BitSet("flag", 1)
// : QHS.AppAnd(o.ToString(), QHS.BitSet("flag", 1));
//int levelop = CfgFn.GetNoNullInt32(Conn.DO_READ_VALUE("sortinglevel", filtro, "min(nlevel)"));
hwTreeViewManager M = new WebTreeViewClassMovimenti(Conn, T, tree, filterc, filtersql, all, maxlevel); //, levelop);
}
public override void WebDescribeTree(hwTreeView tree, DataTable T, string ListingType)
{
int maxDepth = 9;
if (ListingType == "tree")
{
base.DescribeColumns(T, ListingType);
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "codelistclass", "Codice");
DescribeAColumn(T, "title", "Denominazione");
}
base.WebDescribeTree(tree, T, ListingType);
string filterc = QHC.IsNull("paridlistclass");
string filtersql = QHS.IsNull("paridlistclass");
hwTreeViewListClass M = new hwTreeViewListClass(Conn, T, tree, filterc, filtersql, false, maxDepth);
}
public override void WebDescribeTree(hwTreeView tree, DataTable T, string ListingType)
{
int maxlev = 0;
CQueryHelper QHC = new CQueryHelper();
QueryHelper QHS = Conn.GetQueryHelper();
for (int i = 1; i <= 5; i++)
{
if (ListingType == "treee" + i.ToString())
{
ListingType = "treee";
maxlev = i;
}
}
for (int i = 1; i <= 5; i++)
{
if (ListingType == "trees" + i.ToString())
{
ListingType = "trees";
maxlev = i;
}
}
//Aggiorno le intestazioni del DataGrid
if (ListingType == "tree" || ListingType == "treee" || ListingType == "trees" || ListingType == "treees" ||
ListingType == "treealle" || ListingType == "treealls")
{
base.DescribeColumns(T, ListingType);
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "!livello", "Livello", "finlevel.description");
DescribeAColumn(T, "codefin", "Codice");
DescribeAColumn(T, "title", "Denominazione");
DescribeAColumn(T, "!responsabile", "Responsabile", "manager.title");
}
base.WebDescribeTree(tree, T, ListingType);
int esercizio = Convert.ToInt32(GetSys("esercizio"));
string filterC = QHC.CmpEq("nlevel", 1);
string filterSql = QHS.CmpEq("nlevel", 1);
string kind = "ES";
bool all = false;
if (ListingType == "treee")
{
filterSql = QHS.AppAnd(
QHS.BitClear("flag", 0),
QHS.AppAnd(QHS.CmpEq("ayear", esercizio), QHS.IsNull("paridfin")));
filterC = QHC.AppAnd(
QHC.BitClear("flag", 0),
QHC.AppAnd(QHC.CmpEq("ayear", esercizio), QHC.IsNull("paridfin")));
kind = "E";
}
if (ListingType == "trees")
{
filterSql = QHS.AppAnd(
QHS.BitSet("flag", 0),
QHS.AppAnd(QHS.CmpEq("ayear", esercizio), QHS.IsNull("paridfin")));
filterC = QHC.AppAnd(
QHC.BitSet("flag", 0),
QHC.AppAnd(QHC.CmpEq("ayear", esercizio), QHC.IsNull("paridfin")));
kind = "S";
}
if (ListingType == "treees")
{
filterSql = QHS.AppAnd(QHS.CmpEq("ayear", esercizio), QHS.IsNull("paridfin"));
filterC = QHC.AppAnd(QHC.CmpEq("ayear", esercizio), QHC.IsNull("paridfin"));
kind = "ES";
}
if (ListingType == "tree")
{
filterSql = QHS.AppAnd(QHS.CmpEq("ayear", esercizio), QHS.IsNull("paridfin"));
filterC = QHC.AppAnd(QHC.CmpEq("ayear", esercizio), QHC.IsNull("paridfin"));
kind = "ES";
}
if (ListingType == "treealle")
{
filterSql = QHS.AppAnd(
QHS.BitClear("flag", 0),
QHS.AppAnd(QHS.CmpEq("ayear", esercizio), QHS.IsNull("paridfin")));
filterC = QHC.AppAnd(
QHC.BitClear("flag", 0),
QHC.AppAnd(QHC.CmpEq("ayear", esercizio), QHC.IsNull("paridfin")));
kind = "E";
all = true;
}
if (ListingType == "treealls")
{
filterSql = QHS.AppAnd(
QHS.BitSet("flag", 0),
QHS.AppAnd(QHS.CmpEq("ayear", esercizio), QHS.IsNull("paridfin")));
filterC = QHC.AppAnd(
QHC.BitSet("flag", 0),
QHC.AppAnd(QHC.CmpEq("ayear", esercizio), QHC.IsNull("paridfin")));
kind = "S";
all = true;
}
if (maxlev > 0)
{
myGetData.SetStaticFilter("fin", QHS.CmpLe("nlevel", maxlev));
myGetData.SetStaticFilter("finview", QHS.CmpLe("nlevel", maxlev));
}
hwTreeViewBilancio M = new hwTreeViewBilancio(T, tree, filterC, filterSql, kind, all, maxlev,
CfgFn.GetNoNullInt32(GetSys("finusablelevel")));
myGetData.SetStaticFilter("finlevel", QHS.CmpEq("ayear", GetSys("esercizio")));
}
