public override DataRow SelectByCondition(string filter, string searchtable)
{
if (edit_type == "treeall")
{
return(base.SelectByCondition(filter, "account"));
}
int ResultCount = 0;
if (edit_type == "treeminusable")
{
string filterenablebudgetprev = QHS.NullOrEq("flagenablebudgetprev", "S");
filter = QHS.AppAnd(filter, filterenablebudgetprev);
ResultCount = Conn.RUN_SELECT_COUNT("accountminusable", filter, true);
}
else
{
ResultCount = Conn.RUN_SELECT_COUNT("accountusable", filter, true);
}
if (ResultCount != 1)
{
return(null);
}
DataTable T2 = Conn.RUN_SELECT("account", null, null, filter, null, true);
if (T2 == null)
{
return(null);
}
if (T2.Rows.Count == 0)
{
return(null);
}
return(CheckSelectRow(T2.Rows[0]));
}
public override void DescribeTree(System.Windows.Forms.TreeView tree, DataTable T, string ListingType)
{
bool all = false;
//Aggiorno le intestazioni del DataGrid
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");
}
base.DescribeTree(tree, T, 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");
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"));
string filterAccountLevel = filteresercizio;
if (ListingType == "treeminusable")
{
maxlevel = minlevelop;
string filterenablebudgetprev = QHS.NullOrEq("flagenablebudgetprev", "S");
filterAccountLevel = QHS.AppAnd(QHS.CmpEq("ayear", esercizionew), QHS.CmpLe("nlevel", minlevelop), filterenablebudgetprev);
}
// TreeViewAccount M = new TreeViewAccount(Conn, T, tree, filter, maxlevel);
// myGetData.SetStaticFilter("accountevel","(ayear='"+GetSys("esercizio").ToString()+"')");
//
if (ListingType == "treeall")
{
all = true;
}
if (ListingType == "treenew")
{
//string livsupid = esercizionew.ToString().Substring(2);
//filter = "(paridacc is null + QueryCreator.quotedstrvalue(livsupid, true) + ")";
filterAccountLevel = QHS.CmpEq("ayear", esercizionew);
all = true;
}
TreeViewAccount M = new TreeViewAccount(Conn, T, tree, filterc, filtersql, all, maxlevel);
myGetData.SetStaticFilter("accountlevel", filterAccountLevel);
}
public void FillShowcases()
{
DataTable TStore = Conn.RUN_SELECT("store", "*", null,
QHS.AppAnd(QHS.NullOrEq("active", "S"), Conn.Security.SelectCondition("store", true)),
null, false);
//DataTable DT = DataAccess.RUN_SELECT(Conn, "showcase", "*", "title asc", null, false);
string Query = " SELECT showcase.idshowcase as idshowcase, showcase.idstore as idstore, showcase.title as title FROM showcase JOIN store ";
Query += " on (showcase.idstore = store.idstore) WHERE store.active='S'";
DataTable DT = Conn.SQLRunner(Query);
if (DT == null || DT.Rows.Count == 0)
{
return;
}
//Cancella le vetrine non associate a magazzini autorizzati
foreach (DataRow r in DT.Select())
{
string search = QHS.CmpEq("idstore", r["idstore"]);
if (TStore.Select(search).Length > 0)
{
continue;
}
r.Delete();
}
DT.AcceptChanges();
foreach (DataRow DR in DT.Rows)
{
string Label = DR["title"].ToString();
string id = DR["idshowcase"].ToString();
string idstore = DR["idstore"].ToString();
hwButton HB = new hwButton();
HB.ID = "btnShowcase_" + id + "_" + idstore;
HB.CssClass = "showcasebutton";
/*
* HB.Style.Add("border", "0px");
* HB.Style.Add("background-color", "white");
* HB.Style.Add("cursor", "hand");
* HB.Style.Add();
*/
HB.Tag = "showcase." + id + "." + idstore;
HB.Text = Label;
showcases.Controls.Add(HB);
HtmlGenericControl br = new HtmlGenericControl("br");
showcases.Controls.Add(br);
}
}
public override string GetStaticFilter(string ListingType)
{
int eserc = CfgFn.GetNoNullInt32(GetSys("esercizio"));
return(QHS.NullOrEq("ayear", eserc));
}
