public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHS = Meta.Conn.GetQueryHelper();
QHC = new CQueryHelper();
DataRow Source = Meta.SourceRow;
DataTable TEpaccParent = Source.Table.DataSet.Tables["epacc"];
if (TEpaccParent == null)
{
TEpaccParent = Source.Table.DataSet.Tables["epaccview"];
}
DataRow ParEpacc = TEpaccParent.Select(QHC.CmpEq("idepacc", Source["idepacc"]))[0];
int nphase = CfgFn.GetNoNullInt32(ParEpacc["nphase"]);
string s_table = "epacc";
if (nphase == 1)
{
s_table = "epacc1";
}
string filterCT = QHS.CmpEq("tablename", s_table);
GetData.CacheTable(DS.sortingapplicabilityview, filterCT, null, true);
string filterActive = QHS.DoPar(QHS.AppOr(QHS.NullOrEq("active", 'S'), QHS.CmpEq("active", "")));
string filterI = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive, filterCT)), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingapplicabilityview, filterI);
cmbTipo.DataSource = DS.sortingapplicabilityview;
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Conn.GetQueryHelper();
string filtereserc = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.SetStaticFilter(DS.fin, QHS.AppAnd(filtereserc, QHS.BitClear("flag", 0)));
GetData.SetStaticFilter(DS.sortingincomefilter, filtereserc);
GetData.SetStaticFilter(DS.sortingincomefilterview, filtereserc);
GetData.CacheTable(DS.upb);
string filterCT = QHS.CmpEq("tablename", "registry");
GetData.CacheTable(DS.sortingapplicabilityview, filterCT, null, true);
string filterActive = QHS.DoPar(QHS.AppOr(QHS.NullOrEq("active", 'S'), QHS.CmpEq("active", "")));
string filterI = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive, filterCT)), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingapplicabilityview, filterI);
string filterI_SK = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive,
QHS.IsNotNull("nphaseincome"))), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingapplicabilityview, filterI_SK);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Conn.GetQueryHelper();
string filtereserc = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
string filter = QHS.NullOrEq("flagdalia", "S");
GetData.SetStaticFilter(DS.service, filter);
//GetData.CacheTable(DS.service);
GetData.MarkToAddBlankRow(DS.service);
GetData.Add_Blank_Row(DS.service);
string filterActive = QHS.DoPar(QHS.AppOr(QHS.NullOrEq("active", 'S'), QHS.CmpEq("active", "")));
string filterI = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive)), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingapplicabilityview, filterI);
string filterI_SK = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive)), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingkind, filterI_SK);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
string filterCT = QHS.CmpEq("tablename", "banktransaction");
DataTable t = DataAccess.RUN_SELECT(Meta.Conn, "sortingapplicability", null, null, filterCT, null, null, true);
string filtroSorting = QHC.FieldIn("idsorkind", t.Select());
DataRow rBankTransaction = Meta.SourceRow.Table.DataSet.Tables["banktransaction"].Rows[0];
bool isSpesa = rBankTransaction["idexp"] != DBNull.Value;
bool isEntrata = rBankTransaction["idinc"] != DBNull.Value;
if (isSpesa && !isEntrata)
{
filtroTipoMov = "(movkind='S')";
}
if (isEntrata && !isSpesa)
{
filtroTipoMov = "(movkind='E')";
}
GetData.SetStaticFilter(DS.sortingapplicabilityview, filtroSorting);
string filterActive = QHS.DoPar(QHS.AppOr(QHS.NullOrEq("active", 'S'), QHS.CmpEq("active", "")));
string filterI = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive, filterCT)), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingapplicabilityview, filterI);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHS = Meta.Conn.GetQueryHelper();
string filterCT = QHS.CmpEq("tablename", "mandate");
GetData.CacheTable(DS.sortingapplicabilityview, filterCT, null, true);
string filterActive = QHS.DoPar(QHS.AppOr(QHS.NullOrEq("active", 'S'), QHS.CmpEq("active", "")));
string filterI = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive, filterCT)), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingapplicabilityview, filterI);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
GetData.SetSorting(DS.registrysortingview, "idreg");
string filterCT = QHS.CmpEq("tablename", "registry");
GetData.CacheTable(DS.sortingapplicabilityview, filterCT, null, true);
string filterActive = QHS.DoPar(QHS.AppOr(QHS.NullOrEq("active", 'S'), QHS.CmpEq("active", "")));
string filterI = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive, filterCT)), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingapplicabilityview, filterI);
//DataAccess.SetTableForReading(DS.cdruolo_alias,"cdruolo");
//HelpForm.SetDenyNull(DS.cdposruolo.flagattivoColumn,true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Conn.GetQueryHelper();
string filtereserc = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.SetStaticFilter(DS.autoclawbacksorting, filtereserc);
GetData.SetStaticFilter(DS.autoclawbacksortingview, filtereserc);
string filterActive = QHS.DoPar(QHS.AppOr(QHS.NullOrEq("active", 'S'), QHS.CmpEq("active", "")));
string filterI_SK = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive)), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingkind, filterI_SK);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
Conn = Meta.Conn;
string filtereserc = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
DataRow ParentRow = Meta.SourceRow;
//string filterupb = QHS.CmpEq("idupb", ParentRow["idupb"]);
//string filter = QHS.AppAnd(QHS.IsNull("idfin"), QHS.IsNull("idman"), QHS.IsNull("idsorreg"), QHS.IsNull("idsorkindreg"));
//filter = QHS.AppAnd(filter, filtereserc, filterupb);
//GetData.SetStaticFilter(DS.sortingexpensefilter, filter);
//GetData.SetStaticFilter(DS.sortingexpensefilterview, filter);
string filterActive = QHS.DoPar(QHS.AppOr(QHS.NullOrEq("active", 'S'), QHS.CmpEq("active", "")));
string filterI_SK = QHS.DoPar(QHS.AppOr(QHS.DoPar(QHS.AppAnd(QHS.NullOrLe("start", Meta.GetSys("esercizio")),
QHS.NullOrGe("stop", Meta.GetSys("esercizio")), filterActive,
QHS.IsNotNull("nphaseexpense"))), QHS.CmpEq("idsorkind", 0)));
QueryCreator.SetFilterForInsert(DS.sortingkind, filterI_SK);
}
