public FrmAskDescr(MetaDataDispatcher Disp)
{
InitializeComponent();
this.Disp = Disp;
this.Conn = Disp.Conn;
QHC = new CQueryHelper();
QHS = Conn.GetQueryHelper();
D = new DataSet();
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
string filter = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.SetStaticFilter(DS.csa_contractregistry, filter);
}
public void MetaData_AfterLink()
{
meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = meta.Conn.GetQueryHelper();
HelpForm.SetAllowMultiSelection(DS.paymentview, true);
GetData.SetSorting(DS.paymentview, "npay");
MetaData.SetDefault(DS.banktransaction, "kind", "D");
MetaData.SetDefault(DS.banktransaction, "yban", meta.GetSys("esercizio"));
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
//GetData.CacheTable(DS.currency);
bool FlagEsenteBanca = LeggiFlagEsenteBancaPredefinita();
chkEsenteSpese.Visible = FlagEsenteBanca;
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
string filter = Meta.QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.SetStaticFilter(DS.flussoincassi, filter);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Conn = Meta.Conn;
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
DataAccess.SetTableForReading(DS.sorting1, "sorting");
DataAccess.SetTableForReading(DS.sorting2, "sorting");
DataAccess.SetTableForReading(DS.sorting3, "sorting");
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
string filter = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.SetStaticFilter(DS.finmotivedetail, filter);
GetData.SetStaticFilter(DS.finmotivedetailview, filter);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
Meta.CanCancel = false;
Meta.CanInsert = false;
Meta.CanInsertCopy = false;
Meta.CanSave = false;
Meta.SearchEnabled = false;
}
public static decimal IF_TotQuoteImponibiliSpese(DataTable Spese, DataTable TipoSpese, CfgItineration Cfg)
{
decimal SUM = 0;
CQueryHelper QHC = new CQueryHelper();
foreach (DataRow Spesa in Spese.Select())
{
SUM += IF_ImponibileSpesa(Spesa, TipoSpese, Cfg);
}
return(SUM);
}
public FrmAskDescr(MetaDataDispatcher Disp, object CodiceInventario)
{
InitializeComponent();
this.Disp = Disp;
this.Conn = Disp.Conn;
QHC = new CQueryHelper();
QHS = Conn.GetQueryHelper();
CodInv = CodiceInventario;
D = new DataSet();
FormInit();
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
string filteresercizio = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.SetStaticFilter(DS.fin, QHS.AppAnd(filteresercizio, QHS.BitClear("flag", 0)));
GetData.SetStaticFilter(DS.fin1, QHS.AppAnd(filteresercizio, QHS.BitSet("flag", 0)));
}
public void MetaData_AfterLink()
{
meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = meta.Conn.GetQueryHelper();
esercizio = (int)meta.GetSys("esercizio");
HelpForm.SetAllowMultiSelection(DS.expenseview, true);
GetData.SetSorting(DS.expenseview, "ymov, nmov");
MetaData.SetDefault(DS.banktransaction, "kind", "D");
MetaData.SetDefault(DS.banktransaction, "yban", esercizio);
}
public void MetaData_AfterLink()
{
meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = meta.Conn.GetQueryHelper();
if (meta.edit_type == "readonly")
{
meta.CanSave = false;
rendiDiSolaLettura(this);
}
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
filteresercizio = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.SetStaticFilter(DS.placcount, filteresercizio);
GetData.SetStaticFilter(DS.placcountview, filteresercizio);
GetData.SetSorting(DS.placcount, "printingorder");
GetData.CacheTable(DS.placcountlevel, filteresercizio, null, true);
}
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 void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
string filter = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.SetStaticFilter(DS.accmotivedetail, filter);
GetData.SetStaticFilter(DS.accmotivedetailview, filter);
GetData.CacheTable(DS.epoperation, null, "title", false);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
inizializzaVar();
visualizzaEtichetta();
GetData.CacheTable(DS.sortingkind, null, null, false);
string filtersercizio = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
GetData.CacheTable(DS.config, filtersercizio, null, false);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
GetData.SetSorting(DS.payrollview, "idcon, fiscalyear, npayroll");
GetData.SetStaticFilter(DS.payrollview, QHS.AppAnd(QHS.CmpEq("flagcomputed", 'N'),
QHS.CmpEq("fiscalyear", Meta.GetSys("esercizio")), QHS.CmpLe("start", Meta.GetSys("datacontabile")),
QHS.CmpEq("year(stop)", Meta.GetSys("esercizio")),
QHS.CmpEq("flagbalance", 'N')));
HelpForm.SetAllowMultiSelection(DS.payrollview, true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
filteresercizio = QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
Meta.additional_search_condition = filteresercizio;
GetData.SetStaticFilter(DS.patrimony, filteresercizio);
//GetData.SetStaticFilter(DS.patrimonyview,filteresercizio);
GetData.SetSorting(DS.patrimony, "printingorder");
GetData.CacheTable(DS.patrimonylevel, filteresercizio, null, true);
}
private static int GetMaxNpay_Treasurer(DataRow R, DataAccess Conn)
{
QueryHelper QHS;
QHS = Conn.GetQueryHelper();
var qhc = new CQueryHelper();
object idtreasurer = R["idtreasurer"];
if ((idtreasurer == DBNull.Value) || (CfgFn.GetNoNullInt32(idtreasurer) == 0))
{
return(-1);
}
object flagautondoc_treasurer = null;
if (enable_ndoc_treasurers.ContainsKey((int)idtreasurer))
{
flagautondoc_treasurer = enable_ndoc_treasurers[(int)idtreasurer];
}
else
{
if (R.Table.DataSet.Tables.Contains("treasurer") &&
R.Table.DataSet.Tables["treasurer"].Columns.Contains("enable_ndoc_treasurer")
)
{
DataTable ttr = R.Table.DataSet.Tables["treasurer"];
var foundTr = ttr.Select(qhc.CmpEq("idtreasurer", idtreasurer));
if (foundTr.Length > 0)
{
flagautondoc_treasurer = foundTr[0]["enable_ndoc_treasurer"];
enable_ndoc_treasurers[(int)idtreasurer] = flagautondoc_treasurer;
}
}
}
if (flagautondoc_treasurer == null)
{
flagautondoc_treasurer = Conn.DO_READ_VALUE("treasurer", QHS.CmpEq("idtreasurer", idtreasurer),
"enable_ndoc_treasurer");
enable_ndoc_treasurers[(int)idtreasurer] = flagautondoc_treasurer;
}
if ((flagautondoc_treasurer != null) && (flagautondoc_treasurer != DBNull.Value) && (flagautondoc_treasurer.ToString().ToUpper() == "S"))
{
int numiniziale = 0;
string sqlmax = "SELECT ISNULL(MAX(npay_treasurer)," + numiniziale.ToString() + ") + 1 FROM payment WHERE "
+ QHS.AppAnd(QHS.CmpEq("idtreasurer", idtreasurer), QHS.CmpEq("ypay", R["ypay"]));
DataTable t = Conn.SQLRunner(sqlmax, true, 0);
return(CfgFn.GetNoNullInt32(t.Rows[0][0]));
}
return(-1);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
Meta.CanSave = false;
Meta.CanInsert = false;
Meta.CanInsertCopy = false;
Meta.CanCancel = false;
ayear = CfgFn.GetNoNullInt32(Meta.GetSys("esercizio"));
idsorkind = CfgFn.GetNoNullInt32(Meta.ExtraParameter);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
Meta.CanSave = false;
Conn = Meta.Conn as Easy_DataAccess;
QHC = new CQueryHelper();
QHS = Conn.GetQueryHelper();
department = Conn.GetSys("userdb").ToString();
}
public override bool CheckPreconditions(DataAccess Source, DataAccess Dest)
{
if (!base.CheckPreconditions(Source, Dest))
{
return(false);
}
if (Dest.RUN_SELECT_COUNT("fin", null, false) == 0)
{
istocopy = true;
DefinesPreTranslator("idfin", new IdentityTranslator());
//non c'è bisogno di definire un traslator per idfin
return(true);
}
QueryHelper QHS = Source.GetQueryHelper();
CQueryHelper QHC = new CQueryHelper();
string filter = QHS.AppAnd(QHS.CmpGe("ayear", 2006), QHS.CmpLe("ayear", 2012), QHS.BitClear("flag", 0));
DataTable S = Source.RUN_SELECT("fin", "*", null, filter, null, false);
DataTable D = Dest.RUN_SELECT("fin", "*", null, filter, null, false);
foreach (DataRow Rs in S.Rows)
{
filter = QHC.MCmp(Rs, "ayear", "codefin");
DataRow[] found = D.Select(filter);
if (found.Length == 0)
{
MessageBox.Show("Nessuna riga di bilancio trovata nel dip. di destinazione sodisfante il filtro " + filter, "Errore");
return(false);
}
H[Rs["idfin"]] = found[0]["idfin"];
}
filter = QHS.AppAnd(QHS.CmpGe("ayear", 2006), QHS.CmpLe("ayear", 2012), QHS.BitSet("flag", 0));
S = Source.RUN_SELECT("fin", "*", null, filter, null, false);
D = Dest.RUN_SELECT("fin", "*", null, filter, null, false);
foreach (DataRow Rs in S.Rows)
{
filter = QHC.MCmp(Rs, "ayear", "codefin");
DataRow[] found = D.Select(filter);
if (found.Length == 0)
{
MessageBox.Show("Nessuna riga di bilancio trovata nel dip. di destinazione sodisfante il filtro " + filter, "Errore");
return(false);
}
H[Rs["idfin"]] = found[0]["idfin"];
}
DefinesPreTranslator("idfin", new ManualTranslator(H));
SetExternalCode("paridfin", "idfin");
return(true);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
Meta.CanCancel = false;
Meta.CanInsert = false;
Meta.CanInsertCopy = false;
Meta.CanSave = false;
Meta.SearchEnabled = false;
PostData.MarkAsTemporaryTable(DS.cliente, false);
PostData.MarkAsTemporaryTable(DS.fornitore, false);
}
public FrmSelectDetails(MetaData Meta, string filtersql, DataSet DS)
{
InitializeComponent();
this.Meta = Meta;
this.Conn = Meta.Conn;
this.filtersql = filtersql;
this.DS = DS;
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
RiempiGrid();
FormInit();
}
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);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
string filter = Meta.QHS.CmpEq("ayear", Meta.GetSys("esercizio"));
string filterupb = QHS.CmpEq("idupb", "0001");
filter = GetData.MergeFilters(filter, filterupb);
GetData.SetStaticFilter(DS.finview, filter);
GetData.SetStaticFilter(DS.finview, filter);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
Meta.CanInsert = false;
Meta.CanSave = false;
Meta.CanCancel = false;
Meta.CanInsertCopy = false;
string filter = "(ymov = '" + Meta.GetSys("esercizio") + "')";
GetData.SetStaticFilter(DS.expensetaxcorrigeview, filter);
}
public void MetaData_AfterLink()
{
Meta = MetaData.GetMetaData(this);
esercizio = (int)Meta.GetSys("esercizio");
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
Meta.CanCancel = false;
Meta.CanInsert = false;
Meta.CanInsertCopy = false;
Meta.SearchEnabled = false;
riempiContrattoNonTrasferibile();
}
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");
}
