public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Conn.GetQueryHelper();
GetData.CacheTable(DS.mandatekind, null, "description", true);
Meta.CanInsert = false;
Meta.CanInsertCopy = false;
Meta.CanCancel = false;
//Meta.CanSave = false;
DataAccess.SetTableForReading(DS.sorting1, "sorting");
DataAccess.SetTableForReading(DS.sorting2, "sorting");
DataAccess.SetTableForReading(DS.sorting3, "sorting");
DataAccess.SetTableForReading(DS.expense_imponibile, "expense");
DataAccess.SetTableForReading(DS.expense_iva, "expense");
DataAccess.SetTableForReading(DS.accmotiveannulment, "accmotive");
DataAccess.SetTableForReading(DS.upb_iva, "upb");
//string filterEpOperation = QHS.CmpEq("idepoperation", "fatacq");
//DS.accmotiveapplied.ExtendedProperties[MetaData.ExtraParams] = filterEpOperation;
//GetData.SetStaticFilter(DS.accmotiveapplied, filterEpOperation);
DataTable tExpSetup = Conn.RUN_SELECT("config", "*", null,
QHS.CmpEq("ayear", Meta.GetSys("esercizio")), null, null, true);
if ((tExpSetup != null) && (tExpSetup.Rows.Count > 0))
{
DataRow r = tExpSetup.Rows[0];
object idsorkind1 = r["idsortingkind1"];
object idsorkind2 = r["idsortingkind2"];
object idsorkind3 = r["idsortingkind3"];
SetGBoxClass(1, idsorkind1);
SetGBoxClass(2, idsorkind2);
SetGBoxClass(3, idsorkind3);
if (idsorkind1 == DBNull.Value && idsorkind2 == DBNull.Value && idsorkind3 == DBNull.Value)
{
tabControl1.TabPages.Remove(tabAnalitico);
}
}
int countList = CfgFn.GetNoNullInt32(Conn.DO_READ_VALUE("list", null, "count(*)"));
if (countList == 0)
{
gboxListino.Visible = false;
//MakeSpaceFrom(gboxListino);
}
else
{
gboxListino.Visible = true;
}
DataAccess.SetTableForReading(DS.sorting_siope, "sorting");
object idsorkind = Conn.DO_READ_VALUE("sortingkind", QHS.CmpEq("codesorkind", Meta.GetSys("codesorkind_siopedprds")), "idsorkind");
GetData.SetStaticFilter(DS.sorting_siope, QHS.CmpEq("idsorkind", idsorkind));
SiopeObj = new siope_helper(this, txtCodSiope, txtDescSiope, btnSiope, grpBoxSiopeEP, true, DS.sorting_siope);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Conn.GetQueryHelper();
GetData.CacheTable(DS.estimatekind, null, "description", true);
Meta.CanInsert = false;
Meta.CanInsertCopy = false;
Meta.CanCancel = false;
Meta.CanSave = false;
DataAccess.SetTableForReading(DS.finmotive_income, "finmotive");
DataAccess.SetTableForReading(DS.sorting1, "sorting");
DataAccess.SetTableForReading(DS.sorting2, "sorting");
DataAccess.SetTableForReading(DS.sorting3, "sorting");
DataAccess.SetTableForReading(DS.income_imponibile, "income");
DataAccess.SetTableForReading(DS.income_iva, "income");
DataAccess.SetTableForReading(DS.accmotiveannulment, "accmotive");
DataAccess.SetTableForReading(DS.upb_iva, "upb");
//string filterEpOperation = QHS.CmpEq("idepoperation", "fatven");
//DS.accmotiveapplied.ExtendedProperties[MetaData.ExtraParams] = filterEpOperation;
//GetData.SetStaticFilter(DS.accmotiveapplied, filterEpOperation);
DataTable tExpSetup = Conn.RUN_SELECT("config", "*", null,
QHS.CmpEq("ayear", Meta.GetSys("esercizio")), null, null, true);
if ((tExpSetup != null) && (tExpSetup.Rows.Count > 0))
{
DataRow R = tExpSetup.Rows[0];
object idsorkind1 = R["idsortingkind1"];
object idsorkind2 = R["idsortingkind2"];
object idsorkind3 = R["idsortingkind3"];
SetGBoxClass(1, idsorkind1);
SetGBoxClass(2, idsorkind2);
SetGBoxClass(3, idsorkind3);
if (idsorkind1 == DBNull.Value && idsorkind2 == DBNull.Value && idsorkind3 == DBNull.Value)
{
tabControl1.TabPages.Remove(tabAnalitico);
}
bool removeIvaTab = true;
foreach (string COL in new string[] { "agencycode", "deferredexpensephase", "deferredincomephase",
"flagpayment", "flagrefund", "idfinivapayment", "idfinivarefund", "idivapayperiodicity", "minpayment",
"minrefund", "paymentagency", "refundagency" })
{
if (R[COL] == DBNull.Value)
{
continue;
}
removeIvaTab = false;
break;
}
if (removeIvaTab)
{
tabControl1.TabPages.Remove(tabFatturazione);
}
}
DataAccess.SetTableForReading(DS.sorting_siope, "sorting");
object idsorkind = Conn.DO_READ_VALUE("sortingkind", QHS.CmpEq("codesorkind", Meta.GetSys("codesorkind_siopeentrate")), "idsorkind");
GetData.SetStaticFilter(DS.sorting_siope, QHS.CmpEq("idsorkind", idsorkind));
SiopeObj = new siope_helper(this, txtCodSiope, txtDescSiope, btnSiope, grpBoxSiopeEP, false, DS.sorting_siope);
}
