public void FillCDC_CONFORMITA(CDCDS ds, List <decimal> IDDETTAGLIO)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_CONFORMITA(ds, IDDETTAGLIO);
a.FillCDC_CONFORMITA_DETTAGLIO(ds, IDDETTAGLIO);
}
public void UpdateCDC_EXCEL(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
//a.UpdateTable(ds.CDC_EXCEL.TableName, ds);
a.Update_EXCEL_Table(ds);
}
public void UpdateDimensioni(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_DIMEMSIONI.TableName, ds);
a.UpdateTable(ds.CDC_DIMEMSIONI_MISURE.TableName, ds);
}
public void UpdateConformita(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_CONFORMITA.TableName, ds);
a.UpdateTable(ds.CDC_CONFORMITA_DETTAGLIO.TableName, ds);
}
public void UpdateTabelleSpessore(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_GALVANICA.TableName, ds);
a.UpdateTable(ds.CDC_SPESSORE.TableName, ds);
a.UpdateTable(ds.CDC_MISURE.TableName, ds);
a.UpdateTable(ds.CDC_APPLICAZIONE.TableName, ds);
}
public void FillCDC_CON_DESCRIZIONE_STR(CDCDS ds, string DATARIFERIMENTO, string Brand)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
//a.FillCDC_EXCEL(ds, DATARIFERIMENTO, Azienda);
//List<decimal> IDEXCEL = ds.CDC_EXCEL.Select(x => x.IDEXCEL).Distinct().ToList();
a.FillCDC_DETTAGLIO_CON_DESCRIZIONE_STR(ds, DATARIFERIMENTO, Brand);
}
public long InsertCDC_CERTIFICATOPIOMBO(string ELEMENTO, string CODICE, string MATERIALE,
string LOTTO, decimal?LUNGHEZZA, decimal?LARGHEZZA, decimal?SPESSORE, string METODO, decimal PESOCAMPIONE, decimal MATRACCIOLO, decimal CONCENTRAZIONE,
decimal PBPPM, decimal CDPPM, string ESITO, DateTime DATACERTIFICATO, string UTENTE, DateTime DATAINSERIMENTO, string PATHFILE)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
return(a.InsertCDC_CERTIFICATOPIOMBO(ELEMENTO, CODICE, MATERIALE,
LOTTO, LUNGHEZZA, LARGHEZZA, SPESSORE, METODO, PESOCAMPIONE, MATRACCIOLO, CONCENTRAZIONE,
PBPPM, CDPPM, ESITO, DATACERTIFICATO, UTENTE, DATAINSERIMENTO, PATHFILE));
}
public void FillCDC(CDCDS ds, DataCollaudo DATARIFERIMENTO)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_EXCEL(ds, DATARIFERIMENTO.Data, DATARIFERIMENTO.Brand);
List <decimal> IDEXCEL = ds.CDC_EXCEL.Select(x => x.IDEXCEL).Distinct().ToList();
a.FillCDC_DETTAGLIO(ds, IDEXCEL);
}
public void FillCDC_ASSOCIAZIONEPIOMBO(CDCDS ds, List <decimal> IDDETTAGLIO)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_ASSOCIAZIONEPIOMBO(ds, IDDETTAGLIO);
}
public void FillCDC_MATERIAPRIMA(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_MATERIAPRIMA(ds);
}
public void FillCDC_APPLICAZIONE(CDCDS ds, string tipoCertificato)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_APPLICAZIONE(ds, tipoCertificato);
}
public void FillCDC_MISURE(CDCDS ds, List <decimal> IDDETTAGLIO)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_MISURE(ds, IDDETTAGLIO);
}
public void FillCDC_GALVANICA(CDCDS ds, List <decimal> IDDETTAGLIO, string tipoCertificato)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_GALVANICA(ds, IDDETTAGLIO, tipoCertificato);
}
public void FillCDC_NUMEROCAMPIONI(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_NUMEROCAMPIONI(ds);
}
public void LeggiUtente(CDCDS ds, string User)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.LeggiUtente(ds, User);
}
public void UpdateCDC_DETTAGLIO(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_DETTAGLIO.TableName, ds);
}
public void FillCDC_BRANDS(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_BRANDS(ds);
}
public void UpdateCDC_TENUTACIDONITRICO(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_TENUTACIDONITRICO.TableName, ds);
}
public void FillCDC_TENUTACIDONITRICO(CDCDS ds, List <decimal> IDDETTAGLIO)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_TENUTACIDONITRICO(ds, IDDETTAGLIO);
}
public void FillCDC_VERNICICOPRENTI(CDCDS ds, List <decimal> IDDETTAGLIO)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_VERNICICOPRENTI(ds, IDDETTAGLIO);
}
public void CDC_PDF(CDCDS ds, List <decimal> IDDETTAGLIO)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.CDC_PDF(ds, IDDETTAGLIO);
}
public void UpdateCertificatiPiombo(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_CERTIFICATIPIOMBO.TableName, ds);
}
public void UpdateCDC_ASSOCIAZIONEPIOMBO(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_ASSOCIAZIONEPIOMBO.TableName, ds);
}
public void UpdateMateriaprima(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_MATERIAPRIMA.TableName, ds);
}
public void FillCDC_CERTIFICATIPIOMBO(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_CERTIFICATIPIOMBO(ds);
}
public void UpdateCDC_ANTIALLERGICO(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_ANTIALLERGICO.TableName, ds);
}
public List <DataCollaudo> LeggiDateRiferimento()
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
return(a.LeggiDateRiferimento());
}
public void FillCDC_DETTAGLIO(List <decimal> IDPRENOTAZIONE, CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_DETTAGLIO(IDPRENOTAZIONE, ds);
}
public void UpdateCDC_VERNICICOPRENTI(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.UpdateTable(ds.CDC_VERNICICOPRENTI.TableName, ds);
}
public void FillCDC_ARTICOLI_SPESSORI(CDCDS ds)
{
CDCMetalAdapter a = new CDCMetalAdapter(DbConnection, DbTransaction);
a.FillCDC_ARTICOLI_SPESSORI(ds);
}