public override void DescribeColumns(DataTable T, string listtype)
{
base.DescribeColumns(T, listtype);
if (listtype == "default")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "idmankind", ".idmankind", nPos++);
DescribeAColumn(T, "mandatekind", "Tipo Ordine", nPos++);
DescribeAColumn(T, "yman", "Eserc.", nPos++);
DescribeAColumn(T, "nman", "Num.", nPos++);
DescribeAColumn(T, "rownum", ".", nPos++);
DescribeAColumn(T, "idgroup", "Gruppo", nPos++);
DescribeAColumn(T, "detaildescription", "Descrizione", nPos++);
DescribeAColumn(T, "taxable", "Imponibile", nPos++);
HelpForm.SetFormatForColumn(T.Columns["taxable"], "n");
DescribeAColumn(T, "ordered", "Ordinata", nPos++);
HelpForm.SetFormatForColumn(T.Columns["ordered"], "n");
DescribeAColumn(T, "invoiced", "Fatturata", nPos++);
HelpForm.SetFormatForColumn(T.Columns["invoiced"], "n");
DescribeAColumn(T, "residual", "Da fatturare", nPos++);
HelpForm.SetFormatForColumn(T.Columns["residual"], "n");
DescribeAColumn(T, "competencystart", "Inizio Comp.", nPos++);
DescribeAColumn(T, "competencystop", "Fine Comp.", nPos++);
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "elenco")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "leveldescr", "Livello", nPos++);
DescribeAColumn(T, "codeinv", "Cod. Class. Inventariale", nPos++);
DescribeAColumn(T, "description", "Class. Inventariale", nPos++);
DescribeAColumn(T, "codeinventoryamortization", "Cod. Ammortamento", nPos++);
DescribeAColumn(T, "inventoryamortization", "Tipo Ammortamento", nPos++);
DescribeAColumn(T, "amortizationquota", "Quota");
DescribeAColumn(T, "official", "Ufficiale");
DescribeAColumn(T, "ammort_sval", "Ammortamento/Svalutazione");
DescribeAColumn(T, "age", "Età min");
DescribeAColumn(T, "agemax", "Età max");
DescribeAColumn(T, "valuemin", "Valore Min");
DescribeAColumn(T, "valuemax", "Valore Max");
HelpForm.SetFormatForColumn(T.Columns["amortizationquota"], "p");
}
}
public override void DescribeColumns(DataTable T, string listtype)
{
base.DescribeColumns(T, listtype);
int nPos = 1;
switch (listtype)
{
case "default": {
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
DescribeAColumn(T, "idstore", ".Cod. magazzino", nPos++);
DescribeAColumn(T, "idlist", ".Cod. listino", nPos++);
DescribeAColumn(T, "store", "Magazzino", nPos++);
DescribeAColumn(T, "list", "Voce Listino", nPos++);
DescribeAColumn(T, "intcode", "Codice interno", nPos++);
DescribeAColumn(T, "codelistclass", "Cod. classificazione", nPos++);
DescribeAColumn(T, "listclass", "Classificazione", nPos++);
DescribeAColumn(T, "number", "Quantità non evasa", nPos++);
HelpForm.SetFormatForColumn(T.Columns["number"], "n");
break;
}
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "idabatement", "");
DescribeAColumn(T, "abatementcode", "Codice Detrazione");
DescribeAColumn(T, "ayear", "Esercizio");
DescribeAColumn(T, "calculationkind", "Tipo di Calcolo");
DescribeAColumn(T, "taxref", "Codice Ritenuta");
DescribeAColumn(T, "description", "Descrizione");
DescribeAColumn(T, "longdescription", "Descrizione Estesa");
DescribeAColumn(T, "validitystart", "Data Inizio Validità");
DescribeAColumn(T, "validitystop", "Data Fine Validità");
DescribeAColumn(T, "evaluatesp", "SP di calcolo");
DescribeAColumn(T, "evaluationorder", "Ordine di Valutazione");
DescribeAColumn(T, "abatementtitle", "Descrizione Cod. Detrazione");
DescribeAColumn(T, "exemption", "Franchigia");
DescribeAColumn(T, "maximal", "Massimale");
DescribeAColumn(T, "rate", "Aliquota");
DescribeAColumn(T, "appliance", "Applicazione");
HelpForm.SetFormatForColumn(T.Columns["rate"], "p");
}
}
public override void DescribeColumns(DataTable T, string listtype)
{
base.DescribeColumns(T, listtype);
if (listtype == "dettaglio")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
//DescribeAColumn(T, "idstoreunloaddetail", "#", nPos++);
//DescribeAColumn(T, "idstock", "Stock", nPos++);
DescribeAColumn(T, "number", "Quant.", nPos++);
//DescribeAColumn(T, "!intcode", "Cod. Art.", "stockview.intcode", nPos++);
DescribeAColumn(T, "!list", "Art.", "stockview.list", nPos++);
HelpForm.SetFormatForColumn(T.Columns["number"], "n");
DescribeAColumn(T, "!surname", "Cognome", "booking.surname", nPos++);
DescribeAColumn(T, "!forename", "Nome", "bookig.forename", nPos++);
//DescribeAColumn(T, "!idstore", "", "stockview.idstore", -1);
DescribeAColumn(T, "!manager", "Respons.", "manager.title", nPos++);
DescribeAColumn(T, "!store", "Magazzino", "stockview.store", nPos++);
DescribeAColumn(T, "!ybooking", "Es.Pren.", "booking.ybooking", nPos++);
DescribeAColumn(T, "!nbooking", "N.Pren.", "booking.nbooking", nPos++);
//DescribeAColumn(T, "invkind", "Tipo Fatt.", nPos++);
//DescribeAColumn(T, "yinv", "Eserc. Fatt.", nPos++);
//DescribeAColumn(T, "ninv", "Num. Fatt.", nPos++);
//DescribeAColumn(T, "rownum", "Num. Dett. Fattura", nPos++);
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "ymainivapay", "Esercizio");
DescribeAColumn(T, "nmainivapay", "Numero");
DescribeAColumn(T, "paymentkind", "Tipo");
DescribeAColumn(T, "nmonth", "Mese");
DescribeAColumn(T, "referenceyear", "Eserc.di riferimento");
DescribeAColumn(T, "creditamount", "Importo credito");
DescribeAColumn(T, "debitamount", "Importo debito");
DescribeAColumn(T, "refundamount", "Importo rimborso");
DescribeAColumn(T, "paymentamount", "Importo versamento");
DescribeAColumn(T, "prorata", "% detraibilità");
DescribeAColumn(T, "mixed", "% promiscuità");
DescribeAColumn(T, "paymentdetails", "Estremi versamento");
DescribeAColumn(T, "datemainivapay", "Data liquidazione");
DescribeAColumn(T, "assesmentdate", "Data regolamento");
HelpForm.SetFormatForColumn(T.Columns["prorata"], "p");
HelpForm.SetFormatForColumn(T.Columns["mixed"], "p");
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "!taxref", "Codice Ritenuta", "tax.taxref", nPos++);
DescribeAColumn(T, "!descrizione", "Descrizione", "tax.description", nPos++);
//DescribeAColumn(T,"!imponibilenetto", "Imponibile Netto", nPos++);
DescribeAColumn(T, "taxablenet", "Imponibile Netto", nPos++);
DescribeAColumn(T, "!aliquotadip", "Aliquota c/dip", nPos++);
//DescribeAColumn(T,"employrate","Aliquota c/Dip.", nPos++);
DescribeAColumn(T, "employtax", "Rit. c/Dip.", nPos++);
//DescribeAColumn(T,"adminrate","Aliquota c/Ammin.", nPos++);
DescribeAColumn(T, "!aliquotaamm", "Aliquota c/amm", nPos++);
DescribeAColumn(T, "admintax", "Rit. c/Ammin.", nPos++);
DescribeAColumn(T, "!tiporitenuta", ".Tipo Ritenuta", "tax.taxkind", nPos++);
HelpForm.SetFormatForColumn(T.Columns["!imponibilenetto"], "c");
HelpForm.SetFormatForColumn(T.Columns["employrate"], "p");
HelpForm.SetFormatForColumn(T.Columns["adminrate"], "p");
HelpForm.SetFormatForColumn(T.Columns["!aliquotadip"], "p");
HelpForm.SetFormatForColumn(T.Columns["!aliquotaamm"], "p");
ComputeRowsAs(T, ListingType);
}
}
public void MetaData_AfterLink()
{
MetaData Meta = MetaData.GetMetaData(this);
HelpForm.SetFormatForColumn(DS.pat.Columns["adminrate"], "p");
HelpForm.SetFormatForColumn(DS.pat.Columns["employrate"], "p");
}
public override void DescribeColumns(DataTable T, string listtype)
{
base.DescribeColumns(T, listtype);
if (listtype == "dettaglio")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "estimkind", "Tipo", nPos++);
DescribeAColumn(T, "yestim", "Esercizio", nPos++);
DescribeAColumn(T, "nestim", "Numero", nPos++);
DescribeAColumn(T, "idgroup", "Num. riga", nPos++);
DescribeAColumn(T, "idinv", "Class. inventariale", nPos++);
DescribeAColumn(T, "detaildescription", "Descrizione", nPos++);
DescribeAColumn(T, "registry", "Versante", nPos++);
DescribeAColumn(T, "taxable", "Importo Unitario", nPos++);
DescribeAColumn(T, "taxable_euro", "Imponibile totale", nPos++);
DescribeAColumn(T, "ivakind", "Tipo IVA", nPos++);
DescribeAColumn(T, "iva_euro", "Iva", nPos++);
DescribeAColumn(T, "number", "Q.tà", nPos++);
DescribeAColumn(T, "start", "Inizio val.", nPos++);
DescribeAColumn(T, "stop", "Fine val.", nPos++);
HelpForm.SetFormatForColumn(T.Columns["number"], "n");
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "iditinerationrefundrule", "Id.regola", nPos++);
DescribeAColumn(T, "iddetail", "Id.dettaglio", nPos++);
DescribeAColumn(T, "itinerationrefundkindgroup", "Macro Classe", nPos++);
DescribeAColumn(T, "position", "Qualifica", nPos++);
DescribeAColumn(T, "minincomeclass", "Min.classe stip.", nPos++);
DescribeAColumn(T, "maxincomeclass", "Max.classe stip.", nPos++);
DescribeAColumn(T, "flag_italy", "Italia", nPos++);
DescribeAColumn(T, "flag_eu", "Unione Europea", nPos++);
DescribeAColumn(T, "flag_extraeu", "Extra UE", nPos++);
DescribeAColumn(T, "nhour_min", "Min. ore", nPos++);
DescribeAColumn(T, "nhour_max", "Max. ore", nPos++);
DescribeAColumn(T, "limit", "Limite", nPos++);
DescribeAColumn(T, "advancepercentage", "Perc.anticipo", nPos++);
HelpForm.SetFormatForColumn(T.Columns["advancepercentage"], "p");
}
return;
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType.StartsWith("lista"))
{
string[] splittedlistingtype = ListingType.Split(".".ToCharArray());
string idsorkind = splittedlistingtype[1];
DataTable TipoClass = Conn.RUN_SELECT("sortingkind", "*", null,
"(idsorkind=" + QueryCreator.quotedstrvalue(idsorkind, true) + ")",
null, true);
if (TipoClass.Rows.Count != 1)
{
return;
}
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "codesorkind", "Tipo", nPos++);
DescribeAColumn(T, "sortingkind", "Tipo", nPos++);
DescribeAColumn(T, "sortcode", "Codice", nPos++);
DescribeAColumn(T, "sorting", "Descrizione", nPos++);
DescribeAColumn(T, "idsor", "", nPos++);
DescribeAColumn(T, "finpart", "Parte Bil.", nPos++);
DescribeAColumn(T, "codefin", "Codice Bil.", nPos++);
DescribeAColumn(T, "quota", "Quota", nPos++);
HelpForm.SetFormatForColumn(T.Columns["quota"], "p");
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "ndetail", "#Riga", nPos++);
DescribeAColumn(T, "quota", "Quota", nPos++);
DescribeAColumn(T, "!phasemovfin", "Fase Mov. Fin.", "expenseview3.phase", nPos++);
DescribeAColumn(T, "!ymov", "Eserc. Mov. Fin.", "expenseview3.ymov", nPos++);
DescribeAColumn(T, "!nmov", "Num. Mov. Fin.", "expenseview3.nmov", nPos++);
DescribeAColumn(T, "!phaseimpbudg", "Fase Imp. Budg.", "epexpview3.phase", nPos++);
DescribeAColumn(T, "!yepexp", "Eserc. Imp.Budget", "epexpview3.yepexp", nPos++);
DescribeAColumn(T, "!nepexp", "Num. Imp. Budget", "epexpview3.nepexp", nPos++);
DescribeAColumn(T, "!codefin", "Cod. Bilancio", "fin2.codefin", nPos++);
DescribeAColumn(T, "!codeupb", "Cod. UPB", "upb2.codeupb", nPos++);
DescribeAColumn(T, "!codeacc", "Cod. Conto EP", "account2.codeacc", nPos++);
DescribeAColumn(T, "!sortcode", "Cod. SIOPE Spesa", "sorting1.sortcode", nPos++);
HelpForm.SetFormatForColumn(T.Columns["quota"], "p4");
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "lista")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, ".idexpensetaxofficial", "Dettaglio #", nPos++);
DescribeAColumn(T, ".taxcode", "#", nPos++);
DescribeAColumn(T, "!taxref", "Codice", "tax.taxref", nPos++);
DescribeAColumn(T, "!description", "Descrizione", "tax.description", nPos++);
DescribeAColumn(T, "employtax", "Rit. dip.", nPos++);
DescribeAColumn(T, "admintax", "Rit. amm.", nPos++);
DescribeAColumn(T, "ayear", "Anno di competenza", nPos++);
DescribeAColumn(T, "start", "Data Inizio", nPos++);
DescribeAColumn(T, "stop", "Data Fine", nPos++);
HelpForm.SetFormatForColumn(T.Columns["employrate"], "p");
HelpForm.SetFormatForColumn(T.Columns["adminrate"], "p");
HelpForm.SetFormatForColumn(T.Columns["employnumerator"], "n");
HelpForm.SetFormatForColumn(T.Columns["employdenominator"], "n");
HelpForm.SetFormatForColumn(T.Columns["adminnumerator"], "n");
HelpForm.SetFormatForColumn(T.Columns["admindenominator"], "n");
HelpForm.SetFormatForColumn(T.Columns["taxablenumerator"], "n");
HelpForm.SetFormatForColumn(T.Columns["taxabledenominator"], "n");
}
}
public override void AfterLink(bool firsttime, bool formToLink)
{
//HelpForm.SetFormatForColumn(DS.bookingdetail.Columns["number"], "N");
Meta.DefaultListType = "list";
SearchTable = "bookingdetailview";
HelpForm.SetFormatForColumn(DS.bookingdetailview.Columns["number"], "n");
DataAccess.SetTableForReading(DS.sorting1, "sorting");
DataAccess.SetTableForReading(DS.sorting2, "sorting");
DataAccess.SetTableForReading(DS.sorting3, "sorting");
Meta.CanInsert = false;
Meta.CanInsertCopy = false;
Meta.CanCancel = false;
QHS = Conn.GetQueryHelper();
QHC = new CQueryHelper();
int idman = CfgFn.GetNoNullInt32(Session["CodiceResponsabile"]);
if (idman == 0)
{
return;
}
string filter = QHS.AppAnd(QHS.CmpEq("idman", idman), QHS.IsNull("authorized"));
GetData.SetStaticFilter(DS.bookingdetailview, filter);
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
DescribeAColumn(T, "idsorkind", "Tipo");
DescribeAColumn(T, "idsor", "");
DescribeAColumn(T, "idser", "");
DescribeAColumn(T, "!codiceclass", "Codice", "sorting.sortcode");
DescribeAColumn(T, "!descrizione", "Descrizione", "sorting.description");
DescribeAColumn(T, "quota", "Quota");
HelpForm.SetFormatForColumn(T.Columns["quota"], "p");
}
public override void DescribeColumns(DataTable T, string listtype)
{
base.DescribeColumns(T, listtype);
if (listtype == "dettaglio")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "mankind", "Tipo", nPos++);
DescribeAColumn(T, "yman", "Esercizio", nPos++);
DescribeAColumn(T, "nman", "Numero", nPos++);
DescribeAColumn(T, "rownum", "Num. riga", nPos++);
DescribeAColumn(T, "description", "Descr. Contr. Pass.", nPos++);
DescribeAColumn(T, "codeinv", "Class. inventariale", nPos++);
DescribeAColumn(T, "detaildescription", "Descrizione", nPos++);
DescribeAColumn(T, "registry", "Percipiente", nPos++);
DescribeAColumn(T, "codeupb", "Cod. U.P.B.", nPos++);
DescribeAColumn(T, "number", "Q.tà", nPos++);
DescribeAColumn(T, "taxable", "Importo Unitario", nPos++);
DescribeAColumn(T, "taxable_euro", "Imponibile totale", nPos++);
DescribeAColumn(T, "ivakind", "Tipo IVA", nPos++);
DescribeAColumn(T, "iva_euro", "Iva", nPos++);
DescribeAColumn(T, "rowtotal", "Totale riga", nPos++);
DescribeAColumn(T, "start", "Inizio val.", nPos++);
DescribeAColumn(T, "stop", "Fine val.", nPos++);
DescribeAColumn(T, "codemotive", "Causale EP", nPos++);
DescribeAColumn(T, "competencystart", "Inizio comp.", nPos++);
DescribeAColumn(T, "competencystop", "Fine comp.", nPos++);
DescribeAColumn(T, "epkind", ".Tipo EP", nPos++);
DescribeAColumn(T, "notlinkedtoasset", "Q.tà da inventariare", nPos++);
DescribeAColumn(T, "linkedtoasset", "Q.tà inventariata", nPos++);
DescribeAColumn(T, "notlinkedtoinvoice", "Q.tà da fatturare", nPos++);
DescribeAColumn(T, "linkedtoinvoice", "Q.tà fatturata", nPos++);
DescribeAColumn(T, "cigcode", "CIG", nPos++);
DescribeAColumn(T, "yepexp", "Anno impegno di B.", nPos++);
DescribeAColumn(T, "nepexp", "N. impegno di B.", nPos++);
DescribeAColumn(T, "yexpimpo", "Anno impegno impon.", nPos++);
DescribeAColumn(T, "nexpimpo", "N. impegno impon.", nPos++);
DescribeAColumn(T, "yexpiva", "Anno impegno iva", nPos++);
DescribeAColumn(T, "nexpiva", "N. impegno iva", nPos++);
DescribeAColumn(T, "locationcode", "Codice Ubicazione", nPos++);
DescribeAColumn(T, "location", "Descrizione", nPos++);
HelpForm.SetFormatForColumn(T.Columns["number"], "n");
HelpForm.SetFormatForColumn(T.Columns["notlinkedtoasset"], "n");
HelpForm.SetFormatForColumn(T.Columns["linkedtoasset"], "n");
HelpForm.SetFormatForColumn(T.Columns["notlinkedtoinvoice"], "n");
HelpForm.SetFormatForColumn(T.Columns["linkedtoinvoice"], "n");
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "idlist", "#", nPos++);
DescribeAColumn(T, "intcode", "Codice", nPos++);
DescribeAColumn(T, "description", "Descrizione", nPos++);
DescribeAColumn(T, "unit", "Unità di misura", nPos++);
DescribeAColumn(T, "package", "Unità di misura per l'acquisto", nPos++);
DescribeAColumn(T, "unitsforpackage", "Coeff. di Conversione", nPos++);
DescribeAColumn(T, "validitystop", "Fine Validità", nPos++);
DescribeAColumn(T, "extcode", "Codice produttore", nPos++);
DescribeAColumn(T, "codelistclass", "Cod. Class.Mercelogica", nPos++);
DescribeAColumn(T, "listclass", "Class.Mercelogica", nPos++);
DescribeAColumn(T, "assetkinddescr", "Tipo Bene (da Class. Merc.)", nPos++);
DescribeAColumn(T, "codeinv", "Cod. Class. Invent.(da Class. Merc.)", nPos++);
DescribeAColumn(T, "inventorytree", "Class. Invent.(da Class. Merc.)", nPos++);
DescribeAColumn(T, "codemotive", "Cod. Causale Costo", nPos++);
DescribeAColumn(T, "accmotive", "Causale Costo", nPos++);
DescribeAColumn(T, "has_expiry", "Ha data scadenza", nPos++);
DescribeAColumn(T, "extbarcode", "Codice a Barre Produttore", nPos++);
DescribeAColumn(T, "intbarcode", "Codice a Barre interno", nPos++);
DescribeAColumn(T, "validitystop", "Data scadenza", nPos++);
DescribeAColumn(T, "active", "Attivo", nPos++);
DescribeAColumn(T, "price", "Prezzo unitario", nPos++);
HelpForm.SetFormatForColumn(T.Columns["price"], "n");
}
if (ListingType == "webdefault")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "idlist", "#", nPos++);
DescribeAColumn(T, "intcode", "Codice", nPos++);
DescribeAColumn(T, "description", "Descrizione", nPos++);
DescribeAColumn(T, "unit", "Unità di misura", nPos++);
DescribeAColumn(T, "package", "Unità di misura per l'acquisto", nPos++);
DescribeAColumn(T, "unitsforpackage", "Coeff. di Conversione", nPos++);
DescribeAColumn(T, "listclass", "Class.Mercelogica", nPos++);
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
int nPos = 1;
DescribeAColumn(T, "nassetacquire", "Num. carico", nPos++);
DescribeAColumn(T, "idmankind", "Tipo Contr. Passivo", nPos++);
DescribeAColumn(T, "yman", "Eserc. Contr. Passivo", nPos++);
DescribeAColumn(T, "nman", "Num. Contr. Passivo", nPos++);
DescribeAColumn(T, "rownum", "Num. Riga", nPos++);
DescribeAColumn(T, "registry", "Cedente", nPos++);
DescribeAColumn(T, "assetloadmotive", "Causale", nPos++);
DescribeAColumn(T, "codeinv", "Codice class.", nPos++);
DescribeAColumn(T, "description", "Descrizione", nPos++);
DescribeAColumn(T, "assetloadkind", "Tipo buono", nPos++);
DescribeAColumn(T, "yassetload", "Eserc. buono", nPos++);
DescribeAColumn(T, "nassetload", "Num. buono", nPos++);
DescribeAColumn(T, "number", "Q.tà", nPos++);
DescribeAColumn(T, "taxable", "Imponibile", nPos++);
DescribeAColumn(T, "taxrate", "Aliquota IVA", nPos++);
DescribeAColumn(T, "discount", "Sconto", nPos++);
DescribeAColumn(T, "startnumber", "Num. iniziale", nPos++);
DescribeAColumn(T, "adate", "Data cont.", nPos++);
HelpForm.SetFormatForColumn(T.Columns["discount"], "p");
HelpForm.SetFormatForColumn(T.Columns["taxrate"], "p");
}
if (ListingType == "carichifattura")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
int nPos = 1;
DescribeAColumn(T, "nassetacquire", "Num. carico", nPos++);
DescribeAColumn(T, "description", "Descrizione", nPos++);
DescribeAColumn(T, "number", "Q.tà", nPos++);
DescribeAColumn(T, "taxable", "Imponibile", nPos++);
DescribeAColumn(T, "taxrate", "Aliquota IVA", nPos++);
DescribeAColumn(T, "discount", "Sconto", nPos++);
DescribeAColumn(T, "startnumber", "Num. iniziale", nPos++);
DescribeAColumn(T, "adate", "Data cont.", nPos++);
HelpForm.SetFormatForColumn(T.Columns["discount"], "p");
HelpForm.SetFormatForColumn(T.Columns["taxrate"], "p");
DescribeAColumn(T, "invrownum", "Gruppo dettaglio fattura", nPos++);
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "nbracket", "Scaglione");
DescribeAColumn(T, "rate", "Aliquota");
DescribeAColumn(T, "minamount", "Importo minimo");
DescribeAColumn(T, "maxamount", "Importo massimo");
HelpForm.SetFormatForColumn(T.Columns["rate"], "p");
}
public override void DescribeColumns(DataTable T, string ListingType) {
base.DescribeColumns(T, ListingType);
if (ListingType=="dettaglioquota") {
foreach (DataColumn C in T.Columns)
DescribeAColumn(T, C.ColumnName, "");
DescribeAColumn(T, "!codeassetusagekind", "Codice", "assetusagekind.codeassetusagekind");
DescribeAColumn(T, "!description", "Descrizione", "assetusagekind.description");
DescribeAColumn(T, "usagequota", "Quota");
HelpForm.SetFormatForColumn(T.Columns["usagequota"], "p");
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
DescribeAColumn(T, "idreductionrule", "", -1);
DescribeAColumn(T, "iddetail", "", -1);
DescribeAColumn(T, "!description", "Riduzione", "reduction.description", 1);
DescribeAColumn(T, "idreduction", "", -1);
DescribeAColumn(T, "reductionpercentage", "Perc.riduzione", 2);
HelpForm.SetFormatForColumn(T.Columns["reductionpercentage"], "p4");
}
return;
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
DescribeAColumn(T, "idpayroll", "");
DescribeAColumn(T, "idpayrolltax", "");
DescribeAColumn(T, "nbracket", "Scaglione");
DescribeAColumn(T, "taxable", "Imponibile");
DescribeAColumn(T, "employrate", "Aliquota dip.");
DescribeAColumn(T, "employtax", "Ritenuta dip.");
DescribeAColumn(T, "adminrate", "Aliquota ammin.");
DescribeAColumn(T, "admintax", "Ritenuta ammin.");
HelpForm.SetFormatForColumn(T.Columns["employrate"], "p");
HelpForm.SetFormatForColumn(T.Columns["adminrate"], "p");
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
DescribeAColumn(T, "idforeignallowancerule", "Id.regola");
DescribeAColumn(T, "iddetail", "Id.dettaglio");
DescribeAColumn(T, "minforeigngroupnumber", "Min.gruppo");
DescribeAColumn(T, "maxforeigngroupnumber", "Max gruppo");
DescribeAColumn(T, "amount", "Importo");
DescribeAColumn(T, "advancepercentage", "Perc.anticipo");
HelpForm.SetFormatForColumn(T.Columns["advancepercentage"], "p");
}
return;
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
int nPos = 1;
DescribeAColumn(T, "!sortingkind", "Tipo", "sortingview.sortingkind", nPos++);
DescribeAColumn(T, "!codiceclass", "Codice", "sortingview.sortcode", nPos++);
DescribeAColumn(T, "!descrizione", "Descrizione", "sortingview.description", nPos++);
DescribeAColumn(T, "quota", "Quota", nPos++);
HelpForm.SetFormatForColumn(T.Columns["quota"], "p");
}
public override void DescribeColumns(System.Data.DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "nprorata", "Numero");
DescribeAColumn(T, "prorata", "Prorata");
HelpForm.SetFormatForColumn(T.Columns["prorata"], "p");
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
DescribeAColumn(T, "idsorkind", "Tipo");
DescribeAColumn(T, "idsor", "");
DescribeAColumn(T, "idfin", "");
DescribeAColumn(T, "!codiceclass", "Codice", "sortingview.sortcode");
DescribeAColumn(T, "!descrizione", "Descrizione", "sortingview.description");
DescribeAColumn(T, "!tipoclass", "Tipo", "sortingview.codesorkind");
DescribeAColumn(T, "quota", "Quota");
HelpForm.SetFormatForColumn(T.Columns["quota"], "p");
}
}
public override void DescribeColumns(DataTable T, string listtype)
{
base.DescribeColumns(T, listtype);
int nPos = 1;
switch (listtype)
{
case "default": {
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
DescribeAColumn(T, "idbooking", ".Cod. prenotazione", nPos++);
DescribeAColumn(T, "idlist", ".Cod. listino", nPos++);
DescribeAColumn(T, "idstore", ".Cod. magazzino", nPos++);
DescribeAColumn(T, "idstock", ".Cod. stock", nPos++);
DescribeAColumn(T, "manager", "Responsabile", nPos++);
DescribeAColumn(T, "list", "Voce Listino", nPos++);
DescribeAColumn(T, "allocated", "Q. disponibile", nPos++);
DescribeAColumn(T, "number", "Quantità inevasa", nPos++);
DescribeAColumn(T, "store", "Magazzino", nPos++);
//DescribeAColumn(T, "intcode", "Codice interno", nPos++);
//DescribeAColumn(T, "codelistclass", "Cod. classificazione", nPos++);
//DescribeAColumn(T, "listclass", "Classificazione", nPos++);
DescribeAColumn(T, "ybooking", "Eserc. prenotazione", nPos++);
DescribeAColumn(T, "nbooking", "Numero prenotazione", nPos++);
HelpForm.SetFormatForColumn(T.Columns["number"], "n");
HelpForm.SetFormatForColumn(T.Columns["allocated"], "n");
break;
}
case "list": {
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "", -1);
}
DescribeAColumn(T, "store", "Magazzino", nPos++);
DescribeAColumn(T, "manager", "Responsabile", nPos++);
DescribeAColumn(T, "number", "Quantità non evasa", nPos++);
HelpForm.SetFormatForColumn(T.Columns["number"], "n");
DescribeAColumn(T, "allocated", "Quantità allocata", nPos++);
HelpForm.SetFormatForColumn(T.Columns["allocated"], "n");
DescribeAColumn(T, "booked", "Quantità Richiesta", nPos++);
HelpForm.SetFormatForColumn(T.Columns["booked"], "n");
break;
}
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "enteesattore")
{
foreach (DataColumn C in T.Columns)
{
DescribeAColumn(T, C.ColumnName, "");
}
DescribeAColumn(T, "taxref", "Codice ritenuta");
DescribeAColumn(T, "registry", "Ente esattore");
DescribeAColumn(T, "percentage", "Percentuale");
HelpForm.SetFormatForColumn(T.Columns["percentage"], "p");
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
DescribeAColumn(T, "descrizioneritenuta", "Tipo ritenuta", "tax.description");
DescribeAColumn(T, "taxcode", "");
DescribeAColumn(T, "idregion", "");
DescribeAColumn(T, "validitystart", "Data");
DescribeAColumn(T, "nbracket", "Numero scaglione");
DescribeAColumn(T, "publishmentdate", "Data Pubblicazione");
DescribeAColumn(T, "ratestart", "Data decorrenza");
DescribeAColumn(T, "enforcement", "Tipo applicazione");
DescribeAColumn(T, "rate", "Aliquota");
HelpForm.SetFormatForColumn(T.Columns["rate"], "p");
}
}
public override void DescribeColumns(DataTable T, string ListingType)
{
base.DescribeColumns(T, ListingType);
if (ListingType == "default")
{
DescribeAColumn(T, "idallowancerule", "Id.regola");
DescribeAColumn(T, "iddetail", "Id.dettaglio");
DescribeAColumn(T, "idposition", "");
DescribeAColumn(T, "!qualifica", "Qualifica", "position.description");
DescribeAColumn(T, "minincomeclass", "Min.classe stip.");
DescribeAColumn(T, "maxincomeclass", "Max.classe stip.");
DescribeAColumn(T, "amount", "Importo");
DescribeAColumn(T, "advancepercentage", "Perc.anticipo");
HelpForm.SetFormatForColumn(T.Columns["advancepercentage"], "p");
}
return;
}
