public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHS = Meta.Conn.GetQueryHelper();
GetData.SetStaticFilter(DS.taxablekind, QHS.CmpEq("ayear", Meta.GetSys("esercizio")));
if (Meta.GetSys("manage_prestazioni") != null)
{
IsAdmin = (Meta.GetSys("manage_prestazioni").ToString() == "S");
}
Meta.CanSave = true;
Meta.CanInsert = IsAdmin;
Meta.CanInsertCopy = IsAdmin;
Meta.CanCancel = IsAdmin;
HelpForm.SetDenyNull(DS.tax.Columns["active"], true);
string filterEpOperation = QHS.CmpEq("idepoperation", "apprit");
DS.accmotiveapplied.ExtendedProperties[MetaData.ExtraParams] = filterEpOperation;
GetData.SetStaticFilter(DS.accmotiveapplied, filterEpOperation);
filterEpOperation = QHS.CmpEq("idepoperation", "appcontrib");
DS.accmotiveapplied_cost.ExtendedProperties[MetaData.ExtraParams] = filterEpOperation;
GetData.SetStaticFilter(DS.accmotiveapplied_cost, filterEpOperation);
filterEpOperation = QHS.CmpEq("idepoperation", "liqrit");
DS.accmotiveapplied_pay.ExtendedProperties[MetaData.ExtraParams] = filterEpOperation;
GetData.SetStaticFilter(DS.accmotiveapplied_pay, filterEpOperation);
GetData.CacheTable(DS.maintax, null, null, true);
GetData.SetStaticFilter(DS.maintax, QHS.IsNull("maintaxcode"));
GetData.SetSorting(DS.maintax, "description asc");
GetData.SetStaticFilter(DS.taxmotiveyear, QHS.CmpEq("ayear", Meta.GetSys("esercizio")));
EnableDisableMainCtrl();
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
GetData.CacheTable(DS.customobject, "(isreal='S')", "objectname", true);
if ((Meta.ExtraParameter != null) && (Meta.ExtraParameter.ToString() != ""))
{
cmbRuleID.Enabled = false;
DS.auditcheck.Columns["idaudit"].DefaultValue = Meta.ExtraParameter;
}
if (Meta.GetSys("FlagMenuAdmin") != null)
{
IsAdmin = (Meta.GetSys("FlagMenuAdmin").ToString() == "S");
}
gboxSql.Visible = IsAdmin;
HelpForm.SetDenyNull(DS.auditcheck.Columns["precheck"], true);
HelpForm.SetDenyNull(DS.auditcheck.Columns["flag_comp"], true);
HelpForm.SetDenyNull(DS.auditcheck.Columns["flag_cash"], true);
HelpForm.SetDenyNull(DS.auditcheck.Columns["flag_both"], true);
HelpForm.SetDenyNull(DS.auditcheck.Columns["flag_credit"], true);
HelpForm.SetDenyNull(DS.auditcheck.Columns["flag_proceeds"], true);
Meta.CanCancel = IsAdmin;
Meta.CanInsert = IsAdmin;
Meta.CanInsertCopy = IsAdmin;
Meta.CanSave = IsAdmin;
abilitaODisabilita(IsAdmin);
}
public Frm_csa_contractkind_default()
{
InitializeComponent();
HelpForm.SetDenyNull(DS.csa_contractkind.Columns["flagcr"], true);
HelpForm.SetDenyNull(DS.csa_contractkind.Columns["active"], true);
DS.csa_contractkinddata.ExtendedProperties["ViewTable"] = DS.csa_contractkinddataview;
DS.sorting.ExtendedProperties["ViewTable"] = DS.csa_contractkinddataview;
DS.fin.ExtendedProperties["ViewTable"] = DS.csa_contractkinddataview;
DS.account.ExtendedProperties["ViewTable"] = DS.csa_contractkinddataview;
DS.upb1.ExtendedProperties["ViewTable"] = DS.csa_contractkinddataview;
DS.csa_contractkinddataview.ExtendedProperties["RealTable"] = DS.csa_contractkinddata;
foreach (DataColumn C in DS.csa_contractkinddata.Columns)
{
if (C.ColumnName.StartsWith("!"))
{
continue;
}
DS.csa_contractkinddataview.Columns[C.ColumnName].ExtendedProperties["ViewSource"] = "csa_contractkinddata." + C.ColumnName;
}
DS.csa_contractkinddataview.Columns["sortcode_siope"].ExtendedProperties["ViewSource"] = "sorting.sortcode";
DS.csa_contractkinddataview.Columns["codefin"].ExtendedProperties["ViewSource"] = "fin.codefin";
DS.csa_contractkinddataview.Columns["codeupb"].ExtendedProperties["ViewSource"] = "upb1.codeupb";
DS.csa_contractkinddataview.Columns["codeacc"].ExtendedProperties["ViewSource"] = "account.codeacc";
}
public Frm_stamphandling_lista()
{
InitializeComponent();
HelpForm.SetDenyNull(DS.stamphandling.flagdefaultColumn, true);
HelpForm.SetDenyNull(DS.stamphandling.Columns["flag"], true);
HelpForm.SetDenyNull(DS.stamphandling.Columns["active"], true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
GetData.CacheTable(DS.stocklocationlevel, null, null, true);
DataAccess.SetTableForReading(DS.sorting01, "sorting");
DataAccess.SetTableForReading(DS.sorting02, "sorting");
DataAccess.SetTableForReading(DS.sorting03, "sorting");
DataAccess.SetTableForReading(DS.sorting04, "sorting");
DataAccess.SetTableForReading(DS.sorting05, "sorting");
HelpForm.SetDenyNull(DS.stocklocation.Columns["active"], true);
DataTable tUniConfig = Meta.Conn.RUN_SELECT("uniconfig", "*", null, null, null, null, true);
if ((tUniConfig != null) && (tUniConfig.Rows.Count > 0))
{
DataRow r = tUniConfig.Rows[0];
object idsorkind1 = r["idsorkind01"];
object idsorkind2 = r["idsorkind02"];
object idsorkind3 = r["idsorkind03"];
object idsorkind4 = r["idsorkind04"];
object idsorkind5 = r["idsorkind05"];
CfgFn.SetGBoxClass0(this, 1, idsorkind1);
CfgFn.SetGBoxClass0(this, 2, idsorkind2);
CfgFn.SetGBoxClass0(this, 3, idsorkind3);
CfgFn.SetGBoxClass0(this, 4, idsorkind4);
CfgFn.SetGBoxClass0(this, 5, idsorkind5);
if (idsorkind1 == DBNull.Value && idsorkind2 == DBNull.Value &&
idsorkind3 == DBNull.Value && idsorkind4 == DBNull.Value && idsorkind5 == DBNull.Value)
{
MetaDataDetail.TabPages.Remove(tabAttributi);
}
}
AbilitaAttributi(false);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
HelpForm.SetDenyNull(DS.registrydurc.Columns["flagirregular"], true);
}
public Frm_cabview_lista_anag()
{
InitializeComponent();
QueryCreator.SetTableForPosting(DS.cabview, "cab");
QueryCreator.SetColumnNameForPosting(DS.cabview.Columns["city"], "");
QueryCreator.SetColumnNameForPosting(DS.cabview.Columns["country"], "");
HelpForm.SetDenyNull(DS.cabview.Columns["flagusable"], true);
}
public Frm_pettycashsetup_default()
{
InitializeComponent();
DataAccess.SetTableForReading(DS.bilancioentrata, "finview");
DataAccess.SetTableForReading(DS.bilanciospesa, "finview");
HelpForm.SetDenyNull(DS.pettycashsetup.Columns["autoclassify"], true);
HelpForm.SetDenyNull(DS.pettycashsetup.Columns["flag"], true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
HelpForm.SetDenyNull(DS.servicepayment.Columns["is_delivered"], true);
HelpForm.SetDenyNull(DS.servicepayment.Columns["is_changed"], true);
HelpForm.SetDenyNull(DS.servicepayment.Columns["is_blocked"], true);
}
public Frm_casualcontractexemption_default()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
HelpForm.SetDenyNull(DS.casualcontractexemption.Columns["active"], true);
}
public Frm_profrefund_default()
{
InitializeComponent();
HelpForm.SetDenyNull(DS.Tables["profrefund"].Columns["flagfiscaldeduction"], true);
HelpForm.SetDenyNull(DS.Tables["profrefund"].Columns["flagivadeduction"], true);
HelpForm.SetDenyNull(DS.Tables["profrefund"].Columns["flagsecuritydeduction"], true);
HelpForm.SetDenyNull(DS.Tables["profrefund"].Columns["active"], true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
HelpForm.SetDenyNull(DS.registryaddress.Columns["flagforeign"], true);
VisualizzaCampiGeo();
}
public Frm_registryclass_anagrafica()
{
InitializeComponent();
HelpForm.SetDenyNull(DS.registryclass.Columns["flagcfbutton"], true);
HelpForm.SetDenyNull(DS.registryclass.Columns["flaginfofromcfbutton"], true);
HelpForm.SetDenyNull(DS.registryclass.Columns["flaghuman"], true);
HelpForm.SetDenyNull(DS.registryclass.Columns["active"], true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
GetData.MarkSkipSecurity(DS.treasurerdest);
Conn = Meta.Conn;
HelpForm.SetDenyNull(DS.moneytransfer.Columns["transferkind"], true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Conn.GetQueryHelper();
HelpForm.SetDenyNull(DS.stock.Columns["flagto_unload"], true);
HelpForm.SetDenyNull(DS.stock.Columns["amount"], true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHS = Meta.Conn.GetQueryHelper();
QHC = new CQueryHelper();
DataAccess.SetTableForReading(DS.sorting01, "sorting");
DataAccess.SetTableForReading(DS.sorting02, "sorting");
DataAccess.SetTableForReading(DS.sorting03, "sorting");
DataAccess.SetTableForReading(DS.sorting04, "sorting");
DataAccess.SetTableForReading(DS.sorting05, "sorting");
EPM = new EP_Manager(Meta, btnGeneraEpExp, btnVisualizzaEpExp, btnGeneraPreimpegni, btnVisualizzaPreimpegni,
btnGeneraEP, btnVisualizzaEP,
labEP, labAltroEsercizio, "provision");
DataTable tUniConfig = Conn.RUN_SELECT("uniconfig", "*", null, null, null, null, true);
if ((tUniConfig != null) && (tUniConfig.Rows.Count > 0))
{
DataRow r = tUniConfig.Rows[0];
object idsorkind1 = r["idsorkind01"];
object idsorkind2 = r["idsorkind02"];
object idsorkind3 = r["idsorkind03"];
object idsorkind4 = r["idsorkind04"];
object idsorkind5 = r["idsorkind05"];
CfgFn.SetGBoxClass0(this, 1, idsorkind1);
CfgFn.SetGBoxClass0(this, 2, idsorkind2);
CfgFn.SetGBoxClass0(this, 3, idsorkind3);
CfgFn.SetGBoxClass0(this, 4, idsorkind4);
CfgFn.SetGBoxClass0(this, 5, idsorkind5);
if (idsorkind1 == DBNull.Value && idsorkind2 == DBNull.Value &&
idsorkind3 == DBNull.Value && idsorkind4 == DBNull.Value && idsorkind5 == DBNull.Value)
{
MetaDataDetail.TabPages.Remove(tabAttributi);
}
}
HelpForm.SetDenyNull(DS.provision.Columns["description"], true);
string filterEpOperationPatrim = QHS.CmpEq("idepoperation", "fondo_accantonamento");
string filterEpOperationCosto = QHS.CmpEq("idepoperation", "costo_accantonamento");
string filterEpOperationRicavo = QHS.CmpEq("idepoperation", "ric_accantonamento");
DS.accmotiveapplied.ExtendedProperties[MetaData.ExtraParams] = filterEpOperationCosto;
DS.accmotiveapplied_patrim.ExtendedProperties[MetaData.ExtraParams] = filterEpOperationPatrim;
DS.accmotiveapplied_ricavo.ExtendedProperties[MetaData.ExtraParams] = filterEpOperationRicavo;
GetData.SetStaticFilter(DS.accmotiveapplied, filterEpOperationCosto);
GetData.SetStaticFilter(DS.accmotiveapplied_patrim, filterEpOperationPatrim);
GetData.SetStaticFilter(DS.accmotiveapplied_ricavo, filterEpOperationRicavo);
DataAccess.SetTableForReading(DS.accmotiveapplied_patrim, "accmotiveapplied");
DataAccess.SetTableForReading(DS.accmotiveapplied_ricavo, "accmotiveapplied");
//GetData.SetStaticFilter(DS.provisiondetail,QHS.CmpEq("ydetail",Conn.GetEsercizio()));
}
public Frm_maintenancekind_default()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
HelpForm.SetDenyNull(DS.maintenancekind.Columns["active"], true);
//
// TODO: Add any constructor code after InitializeComponent call
//
}
public Frm_cab_default_anag()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
HelpForm.SetDenyNull(DS.cab.Columns["flagusable"], true);
//
// TODO: Add any constructor code after InitializeComponent call
//
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
GetData.CacheTable(DS.expensephase, QHS.AppAnd(QHS.CmpNe("nphase", Meta.GetSys("maxexpensephase")),
QHS.CmpGe("nphase", Meta.GetSys("expensefinphase"))), "nphase", true);
HelpForm.SetDenyNull(DS.csa_contracttaxexpense.Columns["idexp"], true);
}
public Frm_assetconsignee_lista()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
HelpForm.SetDenyNull(DS.assetconsignee.Columns["active"], true);
//
// TODO: Add any constructor code after InitializeComponent call
//
}
public void MetaData_AfterLink()
{
meta = MetaData.GetMetaData(this);
int numrighe = meta.Conn.RUN_SELECT_COUNT("mod770_socialsecuritycode", null, true);
int esercizio = (int)meta.Conn.GetEsercizio();
GetData.SetStaticFilter(DS.mod770_socialsecuritycode, "(ayear=" + esercizio + ")");
HelpForm.SetDenyNull(DS.mod770_socialsecuritycode.Columns["description"], true);
}
void AfterLinkBody()
{
QHS = Meta.Conn.GetQueryHelper();
QHC = new CQueryHelper();
Meta.DontWarnOnInsertCancel = true;
string filteresercizio = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.CacheTable(DS.config, filteresercizio, null, false);
DS.Tables["incomephase"].ExtendedProperties["sort_by"] = "nphase";
GetData.CacheTable(DS.incomephase);
GetData.SetStaticFilter(DS.incomelastview, QHS.CmpEq("ymov", Meta.GetSys("esercizio")));
HelpForm.SetDenyNull(DS.proceeds.Columns["idtreasurer"], true);
}
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose(bool disposing)
{
if (disposing)
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose(disposing);
HelpForm.SetDenyNull(DS.positionworkcontract.Columns["flagforcedlength"], true);
HelpForm.SetDenyNull(DS.positionworkcontract.Columns["flagforcedtime"], true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
HelpForm.SetDenyNull(DS.csa_contractepexp.Columns["idepexp"], true);
PostData.MarkAsTemporaryTable(DS.fase_epexp, false);
GetData.MarkToAddBlankRow(DS.fase_epexp);
GetData.Add_Blank_Row(DS.fase_epexp);
EnableFaseImpegnoBudget(1, "Preimpegno di Budget");
EnableFaseImpegnoBudget(2, "Impegno di Budget");
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
chkItaliano.Checked = true;
grpEstero.Visible = false;
grpItaliano.Visible = true;
lblComuneStato.Text = "Comune di Nascita";
// Questa gestione va spostata nel metadato
//HelpForm.SetDenyNull(DS.paydispositiondetail.Columns["gender"], true);
HelpForm.SetDenyNull(DS.paydispositiondetail.Columns["flaghuman"], true);
HelpForm.SetDenyNull(DS.paydispositiondetail.Columns["flagtaxrefund"], true);
DataAccess.SetTableForReading(DS.payment1, "payment");
}
public void MetaData_AfterLink()
{
_conn = this.getInstance <IDataAccess>();
_security = this.getInstance <ISecurity>();
_controller = this.getInstance <IFormController>();
_dispatcher = this.getInstance <IMetaDataDispatcher>();
_meta = this.getInstance <IMetaData>();
QHC = new CQueryHelper();
QHS = _conn.GetQueryHelper();
GetData.CacheTable(DS.expensephase, QHS.AppAnd(QHS.CmpNe("nphase", _security.GetSys("maxexpensephase")),
QHS.CmpGe("nphase", _security.GetSys("expensefinphase"))), "nphase", true);
HelpForm.SetDenyNull(DS.csa_contractexpense.Columns["idexp"], true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
bool IsAdmin = false;
if (Meta.GetSys("manage_prestazioni") != null)
{
IsAdmin = (Meta.GetSys("manage_prestazioni").ToString() == "S");
}
Meta.CanSave = IsAdmin;
Meta.CanInsert = IsAdmin;
Meta.CanInsertCopy = IsAdmin;
Meta.CanCancel = IsAdmin;
HelpForm.SetDenyNull(DS.authagency.Columns["ismanager"], true);
}
public void MetaData_AfterLink()
{
bool IsAdmin = false;
Meta = MetaData.GetMetaData(this);
if (Meta.GetSys("FlagMenuAdmin") != null)
{
IsAdmin = (Meta.GetSys("FlagMenuAdmin").ToString() == "S");
}
Meta.CanSave = IsAdmin;
Meta.CanInsert = IsAdmin;
Meta.CanInsertCopy = IsAdmin;
Meta.CanCancel = IsAdmin;
HelpForm.SetDenyNull(DS.Tables["alert"].Columns["alertcode"], true);
}
public Frm_tax_default()
{
InitializeComponent();
DataAccess.SetTableForReading(DS.accmotiveapplied_pay, "accmotiveapplied");
DataAccess.SetTableForReading(DS.accmotiveapplied_cost, "accmotiveapplied");
DataAccess.SetTableForReading(DS.finmotive_incomeintra, "finmotive");
DataAccess.SetTableForReading(DS.finmotive_admintax, "finmotive");
DataAccess.SetTableForReading(DS.finmotive_incomeemploy, "finmotive");
DataAccess.SetTableForReading(DS.finmotive_expensecontra, "finmotive");
DataAccess.SetTableForReading(DS.finmotive_expenseemploy, "finmotive");
DataAccess.SetTableForReading(DS.service1, "service");
DataAccess.SetTableForReading(DS.maintax, "tax");
GetData.MarkToAddBlankRow(DS.maintax);
HelpForm.SetDenyNull(DS.tax.Columns["flagunabatable"], true);
}
public Frm_entrysetup_default()
{
InitializeComponent();
DataAccess.SetTableForReading(DS.account_customer, "account");
DataAccess.SetTableForReading(DS.account_supplier, "account");
DataAccess.SetTableForReading(DS.account_ivapayment, "account");
DataAccess.SetTableForReading(DS.account_ivarefund, "account");
DataAccess.SetTableForReading(DS.account_accruedcost, "account");
DataAccess.SetTableForReading(DS.account_accruedrevenue, "account");
DataAccess.SetTableForReading(DS.account_deferredcost, "account");
DataAccess.SetTableForReading(DS.account_deferredrevenue, "account");
DataAccess.SetTableForReading(DS.account_pl, "account");
DataAccess.SetTableForReading(DS.account_pat, "account");
HelpForm.SetDenyNull(DS.entrysetup.Columns["flagepexp"], true);
}
