542 lines
26 KiB
C#
542 lines
26 KiB
C#
//------------------------------------------------------------------------------
|
|
// <auto-generated>
|
|
// Codice generato da un modello.
|
|
//
|
|
// Le modifiche manuali a questo file potrebbero causare un comportamento imprevisto dell'applicazione.
|
|
// Se il codice viene rigenerato, le modifiche manuali al file verranno sovrascritte.
|
|
// </auto-generated>
|
|
//------------------------------------------------------------------------------
|
|
|
|
namespace MedAP_data
|
|
{
|
|
using System;
|
|
using System.Data.Entity;
|
|
using System.Data.Entity.Infrastructure;
|
|
using System.Data.Entity.Core.Objects;
|
|
using System.Linq;
|
|
|
|
public partial class MAPEntities : DbContext
|
|
{
|
|
public MAPEntities()
|
|
: base("name=MAPEntities")
|
|
{
|
|
}
|
|
|
|
protected override void OnModelCreating(DbModelBuilder modelBuilder)
|
|
{
|
|
throw new UnintentionalCodeFirstException();
|
|
}
|
|
|
|
public virtual DbSet<Documenti> Documenti { get; set; }
|
|
public virtual DbSet<DocTemplate> DocTemplate { get; set; }
|
|
public virtual DbSet<RigheDoc> RigheDoc { get; set; }
|
|
public virtual DbSet<Clienti> Clienti { get; set; }
|
|
public virtual DbSet<RowTemplate> RowTemplate { get; set; }
|
|
public virtual DbSet<ResocontoIvaFatt> ResocontoIvaFatt { get; set; }
|
|
public virtual DbSet<VAT> VAT { get; set; }
|
|
public virtual DbSet<KVPlist> KVPlist { get; set; }
|
|
public virtual DbSet<ResGiorn> ResGiorn { get; set; }
|
|
public virtual DbSet<ResMens> ResMens { get; set; }
|
|
|
|
public virtual int stp_docRows_deleteQuery(Nullable<int> original_id)
|
|
{
|
|
var original_idParameter = original_id.HasValue ?
|
|
new ObjectParameter("Original_id", original_id) :
|
|
new ObjectParameter("Original_id", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_deleteQuery", original_idParameter);
|
|
}
|
|
|
|
public virtual int stp_docRows_updateQuery(Nullable<int> original_id, string descrizione, string um, Nullable<decimal> prezzoUm, Nullable<float> qta, Nullable<float> sconto, Nullable<int> c_iva)
|
|
{
|
|
var original_idParameter = original_id.HasValue ?
|
|
new ObjectParameter("Original_id", original_id) :
|
|
new ObjectParameter("Original_id", typeof(int));
|
|
|
|
var descrizioneParameter = descrizione != null ?
|
|
new ObjectParameter("Descrizione", descrizione) :
|
|
new ObjectParameter("Descrizione", typeof(string));
|
|
|
|
var umParameter = um != null ?
|
|
new ObjectParameter("um", um) :
|
|
new ObjectParameter("um", typeof(string));
|
|
|
|
var prezzoUmParameter = prezzoUm.HasValue ?
|
|
new ObjectParameter("prezzoUm", prezzoUm) :
|
|
new ObjectParameter("prezzoUm", typeof(decimal));
|
|
|
|
var qtaParameter = qta.HasValue ?
|
|
new ObjectParameter("qta", qta) :
|
|
new ObjectParameter("qta", typeof(float));
|
|
|
|
var scontoParameter = sconto.HasValue ?
|
|
new ObjectParameter("sconto", sconto) :
|
|
new ObjectParameter("sconto", typeof(float));
|
|
|
|
var c_ivaParameter = c_iva.HasValue ?
|
|
new ObjectParameter("c_iva", c_iva) :
|
|
new ObjectParameter("c_iva", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_updateQuery", original_idParameter, descrizioneParameter, umParameter, prezzoUmParameter, qtaParameter, scontoParameter, c_ivaParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<RigheDoc> stp_docRows_getByIdxDoc(Nullable<int> idxDoc)
|
|
{
|
|
var idxDocParameter = idxDoc.HasValue ?
|
|
new ObjectParameter("idxDoc", idxDoc) :
|
|
new ObjectParameter("idxDoc", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<RigheDoc>("stp_docRows_getByIdxDoc", idxDocParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<RigheDoc> stp_docRows_getByIdxDoc(Nullable<int> idxDoc, MergeOption mergeOption)
|
|
{
|
|
var idxDocParameter = idxDoc.HasValue ?
|
|
new ObjectParameter("idxDoc", idxDoc) :
|
|
new ObjectParameter("idxDoc", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<RigheDoc>("stp_docRows_getByIdxDoc", mergeOption, idxDocParameter);
|
|
}
|
|
|
|
public virtual int stp_clienti_delete(Nullable<int> original_idxCli)
|
|
{
|
|
var original_idxCliParameter = original_idxCli.HasValue ?
|
|
new ObjectParameter("Original_idxCli", original_idxCli) :
|
|
new ObjectParameter("Original_idxCli", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_clienti_delete", original_idxCliParameter);
|
|
}
|
|
|
|
public virtual int stp_clienti_insert(string ragSoc, string sesso, string pOBirth, Nullable<System.DateTime> dOBirth, string p_iva, string c_Fisc, string via, string localita, string cap, string provincia, string pagamento, string note, string idxGruppo)
|
|
{
|
|
var ragSocParameter = ragSoc != null ?
|
|
new ObjectParameter("RagSoc", ragSoc) :
|
|
new ObjectParameter("RagSoc", typeof(string));
|
|
|
|
var sessoParameter = sesso != null ?
|
|
new ObjectParameter("Sesso", sesso) :
|
|
new ObjectParameter("Sesso", typeof(string));
|
|
|
|
var pOBirthParameter = pOBirth != null ?
|
|
new ObjectParameter("POBirth", pOBirth) :
|
|
new ObjectParameter("POBirth", typeof(string));
|
|
|
|
var dOBirthParameter = dOBirth.HasValue ?
|
|
new ObjectParameter("DOBirth", dOBirth) :
|
|
new ObjectParameter("DOBirth", typeof(System.DateTime));
|
|
|
|
var p_ivaParameter = p_iva != null ?
|
|
new ObjectParameter("P_iva", p_iva) :
|
|
new ObjectParameter("P_iva", typeof(string));
|
|
|
|
var c_FiscParameter = c_Fisc != null ?
|
|
new ObjectParameter("C_Fisc", c_Fisc) :
|
|
new ObjectParameter("C_Fisc", typeof(string));
|
|
|
|
var viaParameter = via != null ?
|
|
new ObjectParameter("Via", via) :
|
|
new ObjectParameter("Via", typeof(string));
|
|
|
|
var localitaParameter = localita != null ?
|
|
new ObjectParameter("Localita", localita) :
|
|
new ObjectParameter("Localita", typeof(string));
|
|
|
|
var capParameter = cap != null ?
|
|
new ObjectParameter("Cap", cap) :
|
|
new ObjectParameter("Cap", typeof(string));
|
|
|
|
var provinciaParameter = provincia != null ?
|
|
new ObjectParameter("Provincia", provincia) :
|
|
new ObjectParameter("Provincia", typeof(string));
|
|
|
|
var pagamentoParameter = pagamento != null ?
|
|
new ObjectParameter("Pagamento", pagamento) :
|
|
new ObjectParameter("Pagamento", typeof(string));
|
|
|
|
var noteParameter = note != null ?
|
|
new ObjectParameter("Note", note) :
|
|
new ObjectParameter("Note", typeof(string));
|
|
|
|
var idxGruppoParameter = idxGruppo != null ?
|
|
new ObjectParameter("idxGruppo", idxGruppo) :
|
|
new ObjectParameter("idxGruppo", typeof(string));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_clienti_insert", ragSocParameter, sessoParameter, pOBirthParameter, dOBirthParameter, p_ivaParameter, c_FiscParameter, viaParameter, localitaParameter, capParameter, provinciaParameter, pagamentoParameter, noteParameter, idxGruppoParameter);
|
|
}
|
|
|
|
public virtual int stp_clienti_update(Nullable<int> original_idxCli, string ragSoc, string sesso, string pOBirth, Nullable<System.DateTime> dOBirth, string p_iva, string c_Fisc, string via, string localita, string cap, string provincia, string pagamento, string email, string tel, string note, string idxGruppo)
|
|
{
|
|
var original_idxCliParameter = original_idxCli.HasValue ?
|
|
new ObjectParameter("Original_idxCli", original_idxCli) :
|
|
new ObjectParameter("Original_idxCli", typeof(int));
|
|
|
|
var ragSocParameter = ragSoc != null ?
|
|
new ObjectParameter("RagSoc", ragSoc) :
|
|
new ObjectParameter("RagSoc", typeof(string));
|
|
|
|
var sessoParameter = sesso != null ?
|
|
new ObjectParameter("Sesso", sesso) :
|
|
new ObjectParameter("Sesso", typeof(string));
|
|
|
|
var pOBirthParameter = pOBirth != null ?
|
|
new ObjectParameter("POBirth", pOBirth) :
|
|
new ObjectParameter("POBirth", typeof(string));
|
|
|
|
var dOBirthParameter = dOBirth.HasValue ?
|
|
new ObjectParameter("DOBirth", dOBirth) :
|
|
new ObjectParameter("DOBirth", typeof(System.DateTime));
|
|
|
|
var p_ivaParameter = p_iva != null ?
|
|
new ObjectParameter("P_iva", p_iva) :
|
|
new ObjectParameter("P_iva", typeof(string));
|
|
|
|
var c_FiscParameter = c_Fisc != null ?
|
|
new ObjectParameter("C_Fisc", c_Fisc) :
|
|
new ObjectParameter("C_Fisc", typeof(string));
|
|
|
|
var viaParameter = via != null ?
|
|
new ObjectParameter("Via", via) :
|
|
new ObjectParameter("Via", typeof(string));
|
|
|
|
var localitaParameter = localita != null ?
|
|
new ObjectParameter("Localita", localita) :
|
|
new ObjectParameter("Localita", typeof(string));
|
|
|
|
var capParameter = cap != null ?
|
|
new ObjectParameter("Cap", cap) :
|
|
new ObjectParameter("Cap", typeof(string));
|
|
|
|
var provinciaParameter = provincia != null ?
|
|
new ObjectParameter("Provincia", provincia) :
|
|
new ObjectParameter("Provincia", typeof(string));
|
|
|
|
var pagamentoParameter = pagamento != null ?
|
|
new ObjectParameter("Pagamento", pagamento) :
|
|
new ObjectParameter("Pagamento", typeof(string));
|
|
|
|
var emailParameter = email != null ?
|
|
new ObjectParameter("email", email) :
|
|
new ObjectParameter("email", typeof(string));
|
|
|
|
var telParameter = tel != null ?
|
|
new ObjectParameter("tel", tel) :
|
|
new ObjectParameter("tel", typeof(string));
|
|
|
|
var noteParameter = note != null ?
|
|
new ObjectParameter("Note", note) :
|
|
new ObjectParameter("Note", typeof(string));
|
|
|
|
var idxGruppoParameter = idxGruppo != null ?
|
|
new ObjectParameter("idxGruppo", idxGruppo) :
|
|
new ObjectParameter("idxGruppo", typeof(string));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_clienti_update", original_idxCliParameter, ragSocParameter, sessoParameter, pOBirthParameter, dOBirthParameter, p_ivaParameter, c_FiscParameter, viaParameter, localitaParameter, capParameter, provinciaParameter, pagamentoParameter, emailParameter, telParameter, noteParameter, idxGruppoParameter);
|
|
}
|
|
|
|
public virtual int stp_docs_clone(Nullable<int> idxFatt)
|
|
{
|
|
var idxFattParameter = idxFatt.HasValue ?
|
|
new ObjectParameter("IdxFatt", idxFatt) :
|
|
new ObjectParameter("IdxFatt", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_clone", idxFattParameter);
|
|
}
|
|
|
|
public virtual int stp_docs_delete(Nullable<int> original_idxDoc)
|
|
{
|
|
var original_idxDocParameter = original_idxDoc.HasValue ?
|
|
new ObjectParameter("Original_idxDoc", original_idxDoc) :
|
|
new ObjectParameter("Original_idxDoc", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_delete", original_idxDocParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<stp_docs_getByKey_Result> stp_docs_getByKey(Nullable<int> idxDoc)
|
|
{
|
|
var idxDocParameter = idxDoc.HasValue ?
|
|
new ObjectParameter("idxDoc", idxDoc) :
|
|
new ObjectParameter("idxDoc", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<stp_docs_getByKey_Result>("stp_docs_getByKey", idxDocParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<stp_docs_getFilt_Result> stp_docs_getFilt(Nullable<int> anno, Nullable<int> idxCli, string tipo, string gruppo, string ragSoc, Nullable<System.DateTime> inizio, Nullable<System.DateTime> fine, Nullable<int> aperta, string search)
|
|
{
|
|
var annoParameter = anno.HasValue ?
|
|
new ObjectParameter("anno", anno) :
|
|
new ObjectParameter("anno", typeof(int));
|
|
|
|
var idxCliParameter = idxCli.HasValue ?
|
|
new ObjectParameter("idxCli", idxCli) :
|
|
new ObjectParameter("idxCli", typeof(int));
|
|
|
|
var tipoParameter = tipo != null ?
|
|
new ObjectParameter("tipo", tipo) :
|
|
new ObjectParameter("tipo", typeof(string));
|
|
|
|
var gruppoParameter = gruppo != null ?
|
|
new ObjectParameter("gruppo", gruppo) :
|
|
new ObjectParameter("gruppo", typeof(string));
|
|
|
|
var ragSocParameter = ragSoc != null ?
|
|
new ObjectParameter("ragSoc", ragSoc) :
|
|
new ObjectParameter("ragSoc", typeof(string));
|
|
|
|
var inizioParameter = inizio.HasValue ?
|
|
new ObjectParameter("inizio", inizio) :
|
|
new ObjectParameter("inizio", typeof(System.DateTime));
|
|
|
|
var fineParameter = fine.HasValue ?
|
|
new ObjectParameter("fine", fine) :
|
|
new ObjectParameter("fine", typeof(System.DateTime));
|
|
|
|
var apertaParameter = aperta.HasValue ?
|
|
new ObjectParameter("aperta", aperta) :
|
|
new ObjectParameter("aperta", typeof(int));
|
|
|
|
var searchParameter = search != null ?
|
|
new ObjectParameter("search", search) :
|
|
new ObjectParameter("search", typeof(string));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<stp_docs_getFilt_Result>("stp_docs_getFilt", annoParameter, idxCliParameter, tipoParameter, gruppoParameter, ragSocParameter, inizioParameter, fineParameter, apertaParameter, searchParameter);
|
|
}
|
|
|
|
public virtual int stp_docs_insert(Nullable<int> anno, Nullable<int> num, Nullable<int> idxCli, string tipo, Nullable<System.DateTime> emesso, Nullable<double> ritenuta)
|
|
{
|
|
var annoParameter = anno.HasValue ?
|
|
new ObjectParameter("anno", anno) :
|
|
new ObjectParameter("anno", typeof(int));
|
|
|
|
var numParameter = num.HasValue ?
|
|
new ObjectParameter("num", num) :
|
|
new ObjectParameter("num", typeof(int));
|
|
|
|
var idxCliParameter = idxCli.HasValue ?
|
|
new ObjectParameter("idxCli", idxCli) :
|
|
new ObjectParameter("idxCli", typeof(int));
|
|
|
|
var tipoParameter = tipo != null ?
|
|
new ObjectParameter("tipo", tipo) :
|
|
new ObjectParameter("tipo", typeof(string));
|
|
|
|
var emessoParameter = emesso.HasValue ?
|
|
new ObjectParameter("emesso", emesso) :
|
|
new ObjectParameter("emesso", typeof(System.DateTime));
|
|
|
|
var ritenutaParameter = ritenuta.HasValue ?
|
|
new ObjectParameter("ritenuta", ritenuta) :
|
|
new ObjectParameter("ritenuta", typeof(double));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_insert", annoParameter, numParameter, idxCliParameter, tipoParameter, emessoParameter, ritenutaParameter);
|
|
}
|
|
|
|
public virtual int stp_docs_update(Nullable<int> original_idxDoc, Nullable<int> anno, Nullable<int> num, Nullable<int> idxCli, string tipo, Nullable<System.DateTime> emesso, Nullable<double> ritenuta)
|
|
{
|
|
var original_idxDocParameter = original_idxDoc.HasValue ?
|
|
new ObjectParameter("Original_idxDoc", original_idxDoc) :
|
|
new ObjectParameter("Original_idxDoc", typeof(int));
|
|
|
|
var annoParameter = anno.HasValue ?
|
|
new ObjectParameter("anno", anno) :
|
|
new ObjectParameter("anno", typeof(int));
|
|
|
|
var numParameter = num.HasValue ?
|
|
new ObjectParameter("num", num) :
|
|
new ObjectParameter("num", typeof(int));
|
|
|
|
var idxCliParameter = idxCli.HasValue ?
|
|
new ObjectParameter("idxCli", idxCli) :
|
|
new ObjectParameter("idxCli", typeof(int));
|
|
|
|
var tipoParameter = tipo != null ?
|
|
new ObjectParameter("tipo", tipo) :
|
|
new ObjectParameter("tipo", typeof(string));
|
|
|
|
var emessoParameter = emesso.HasValue ?
|
|
new ObjectParameter("emesso", emesso) :
|
|
new ObjectParameter("emesso", typeof(System.DateTime));
|
|
|
|
var ritenutaParameter = ritenuta.HasValue ?
|
|
new ObjectParameter("ritenuta", ritenuta) :
|
|
new ObjectParameter("ritenuta", typeof(double));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_update", original_idxDocParameter, annoParameter, numParameter, idxCliParameter, tipoParameter, emessoParameter, ritenutaParameter);
|
|
}
|
|
|
|
public virtual int stp_docRows_addNew(Nullable<int> idxDoc, string descrizione, string um, Nullable<decimal> prezzoUm, Nullable<float> qta, Nullable<int> cIva)
|
|
{
|
|
var idxDocParameter = idxDoc.HasValue ?
|
|
new ObjectParameter("idxDoc", idxDoc) :
|
|
new ObjectParameter("idxDoc", typeof(int));
|
|
|
|
var descrizioneParameter = descrizione != null ?
|
|
new ObjectParameter("Descrizione", descrizione) :
|
|
new ObjectParameter("Descrizione", typeof(string));
|
|
|
|
var umParameter = um != null ?
|
|
new ObjectParameter("um", um) :
|
|
new ObjectParameter("um", typeof(string));
|
|
|
|
var prezzoUmParameter = prezzoUm.HasValue ?
|
|
new ObjectParameter("prezzoUm", prezzoUm) :
|
|
new ObjectParameter("prezzoUm", typeof(decimal));
|
|
|
|
var qtaParameter = qta.HasValue ?
|
|
new ObjectParameter("qta", qta) :
|
|
new ObjectParameter("qta", typeof(float));
|
|
|
|
var cIvaParameter = cIva.HasValue ?
|
|
new ObjectParameter("cIva", cIva) :
|
|
new ObjectParameter("cIva", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_addNew", idxDocParameter, descrizioneParameter, umParameter, prezzoUmParameter, qtaParameter, cIvaParameter);
|
|
}
|
|
|
|
public virtual int stp_docRows_copy2doc(Nullable<int> idxDoc, Nullable<int> idxRow)
|
|
{
|
|
var idxDocParameter = idxDoc.HasValue ?
|
|
new ObjectParameter("idxDoc", idxDoc) :
|
|
new ObjectParameter("idxDoc", typeof(int));
|
|
|
|
var idxRowParameter = idxRow.HasValue ?
|
|
new ObjectParameter("idxRow", idxRow) :
|
|
new ObjectParameter("idxRow", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_copy2doc", idxDocParameter, idxRowParameter);
|
|
}
|
|
|
|
public virtual int stp_docs_cloneTemplate(Nullable<int> idxFatt, Nullable<int> idxCli)
|
|
{
|
|
var idxFattParameter = idxFatt.HasValue ?
|
|
new ObjectParameter("IdxFatt", idxFatt) :
|
|
new ObjectParameter("IdxFatt", typeof(int));
|
|
|
|
var idxCliParameter = idxCli.HasValue ?
|
|
new ObjectParameter("idxCli", idxCli) :
|
|
new ObjectParameter("idxCli", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_cloneTemplate", idxFattParameter, idxCliParameter);
|
|
}
|
|
|
|
public virtual int stp_VAT_deleteQuery(Nullable<int> original_C_iva)
|
|
{
|
|
var original_C_ivaParameter = original_C_iva.HasValue ?
|
|
new ObjectParameter("Original_C_iva", original_C_iva) :
|
|
new ObjectParameter("Original_C_iva", typeof(int));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_VAT_deleteQuery", original_C_ivaParameter);
|
|
}
|
|
|
|
public virtual int stp_VAT_updateQuery(Nullable<int> original_C_iva, Nullable<double> iva, string descrizione, Nullable<bool> enabled, Nullable<bool> splitPay)
|
|
{
|
|
var original_C_ivaParameter = original_C_iva.HasValue ?
|
|
new ObjectParameter("Original_C_iva", original_C_iva) :
|
|
new ObjectParameter("Original_C_iva", typeof(int));
|
|
|
|
var ivaParameter = iva.HasValue ?
|
|
new ObjectParameter("iva", iva) :
|
|
new ObjectParameter("iva", typeof(double));
|
|
|
|
var descrizioneParameter = descrizione != null ?
|
|
new ObjectParameter("descrizione", descrizione) :
|
|
new ObjectParameter("descrizione", typeof(string));
|
|
|
|
var enabledParameter = enabled.HasValue ?
|
|
new ObjectParameter("enabled", enabled) :
|
|
new ObjectParameter("enabled", typeof(bool));
|
|
|
|
var splitPayParameter = splitPay.HasValue ?
|
|
new ObjectParameter("splitPay", splitPay) :
|
|
new ObjectParameter("splitPay", typeof(bool));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_VAT_updateQuery", original_C_ivaParameter, ivaParameter, descrizioneParameter, enabledParameter, splitPayParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<KVPlist> stp_listValues_getValidValuesTrad(string tableName, string fieldName, string lingua)
|
|
{
|
|
var tableNameParameter = tableName != null ?
|
|
new ObjectParameter("TableName", tableName) :
|
|
new ObjectParameter("TableName", typeof(string));
|
|
|
|
var fieldNameParameter = fieldName != null ?
|
|
new ObjectParameter("FieldName", fieldName) :
|
|
new ObjectParameter("FieldName", typeof(string));
|
|
|
|
var linguaParameter = lingua != null ?
|
|
new ObjectParameter("Lingua", lingua) :
|
|
new ObjectParameter("Lingua", typeof(string));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<KVPlist>("stp_listValues_getValidValuesTrad", tableNameParameter, fieldNameParameter, linguaParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<KVPlist> stp_listValues_getValidValuesTrad(string tableName, string fieldName, string lingua, MergeOption mergeOption)
|
|
{
|
|
var tableNameParameter = tableName != null ?
|
|
new ObjectParameter("TableName", tableName) :
|
|
new ObjectParameter("TableName", typeof(string));
|
|
|
|
var fieldNameParameter = fieldName != null ?
|
|
new ObjectParameter("FieldName", fieldName) :
|
|
new ObjectParameter("FieldName", typeof(string));
|
|
|
|
var linguaParameter = lingua != null ?
|
|
new ObjectParameter("Lingua", lingua) :
|
|
new ObjectParameter("Lingua", typeof(string));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<KVPlist>("stp_listValues_getValidValuesTrad", mergeOption, tableNameParameter, fieldNameParameter, linguaParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<ResGiorn> stp_ResGiornFilt(Nullable<System.DateTime> inizio, Nullable<System.DateTime> fine)
|
|
{
|
|
var inizioParameter = inizio.HasValue ?
|
|
new ObjectParameter("inizio", inizio) :
|
|
new ObjectParameter("inizio", typeof(System.DateTime));
|
|
|
|
var fineParameter = fine.HasValue ?
|
|
new ObjectParameter("fine", fine) :
|
|
new ObjectParameter("fine", typeof(System.DateTime));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ResGiorn>("stp_ResGiornFilt", inizioParameter, fineParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<ResGiorn> stp_ResGiornFilt(Nullable<System.DateTime> inizio, Nullable<System.DateTime> fine, MergeOption mergeOption)
|
|
{
|
|
var inizioParameter = inizio.HasValue ?
|
|
new ObjectParameter("inizio", inizio) :
|
|
new ObjectParameter("inizio", typeof(System.DateTime));
|
|
|
|
var fineParameter = fine.HasValue ?
|
|
new ObjectParameter("fine", fine) :
|
|
new ObjectParameter("fine", typeof(System.DateTime));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ResGiorn>("stp_ResGiornFilt", mergeOption, inizioParameter, fineParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<ResMens> stp_ResMensFilt(Nullable<System.DateTime> inizio, Nullable<System.DateTime> fine)
|
|
{
|
|
var inizioParameter = inizio.HasValue ?
|
|
new ObjectParameter("inizio", inizio) :
|
|
new ObjectParameter("inizio", typeof(System.DateTime));
|
|
|
|
var fineParameter = fine.HasValue ?
|
|
new ObjectParameter("fine", fine) :
|
|
new ObjectParameter("fine", typeof(System.DateTime));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ResMens>("stp_ResMensFilt", inizioParameter, fineParameter);
|
|
}
|
|
|
|
public virtual ObjectResult<ResMens> stp_ResMensFilt(Nullable<System.DateTime> inizio, Nullable<System.DateTime> fine, MergeOption mergeOption)
|
|
{
|
|
var inizioParameter = inizio.HasValue ?
|
|
new ObjectParameter("inizio", inizio) :
|
|
new ObjectParameter("inizio", typeof(System.DateTime));
|
|
|
|
var fineParameter = fine.HasValue ?
|
|
new ObjectParameter("fine", fine) :
|
|
new ObjectParameter("fine", typeof(System.DateTime));
|
|
|
|
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ResMens>("stp_ResMensFilt", mergeOption, inizioParameter, fineParameter);
|
|
}
|
|
}
|
|
}
|