public void FillUSR_PRD_MOVFASIByBarcode(string Barcode, PreserieDS ds)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.FillUSR_PRD_MOVFASIByBarcode(Barcode, ds);
a.FillUSR_PRD_FASIByBarcode(Barcode, ds);
a.FillUSR_PRD_LANCIODByBarcode(Barcode, ds);
}
public void FillMetalliBase(PreserieDS ds)
{
string select = @"SELECT * FROM GRUPPO.MAGAZZ WHERE IDTABSETT = '0000000015'";
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.MAGAZZ);
}
}
public void FillRW_PR_PACKAGING(PreserieDS ds)
{
string query = @"SELECT * FROM RW_PR_PACKAGING ORDER BY IDPACKAGING";
using (DbDataAdapter da = BuildDataAdapter(query))
{
da.Fill(ds.RW_PR_PACKAGING);
}
}
public void FillRW_PR_LAVORAZIONE(PreserieDS ds)
{
string query = @"SELECT * FROM RW_PR_LAVORAZIONE ORDER BY REPARTO,CODICE";
using (DbDataAdapter da = BuildDataAdapter(query))
{
da.Fill(ds.RW_PR_LAVORAZIONE);
}
}
public void FillRW_PR_MATERIALE(PreserieDS ds)
{
string select = @"SELECT * FROM RW_PR_MATERIALE";
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.RW_PR_MATERIALE);
}
}
public void FillUSR_PRD_RESOURCESF(PreserieDS ds)
{
string select = @"SELECT * FROM GRUPPO.USR_PRD_RESOURCESF";
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.USR_PRD_RESOURCESF);
}
}
public void FillTABFAS(PreserieDS ds)
{
string select = @"SELECT * FROM GRUPPO.TABFAS ";
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.TABFAS);
}
}
public void FillCLIFO(PreserieDS ds)
{
string select = @"SELECT * FROM GRUPPO.CLIFO";
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.CLIFO);
}
}
public void FillRW_PR_DETTAGLIO(string Barcode, PreserieDS ds)
{
string query = @"SELECT * FROM RW_PR_DETTAGLIO WHERE BARCODE = $P{BARCODE1}";
ParamSet ps = new ParamSet();
ps.AddParam("BARCODE1", DbType.String, Barcode);
using (DbDataAdapter da = BuildDataAdapter(query, ps))
{
da.Fill(ds.RW_PR_DETTAGLIO);
}
}
public void UpdatePREDTable(string tablename, PreserieDS ds)
{
string query = string.Format(CultureInfo.InvariantCulture, "SELECT * FROM {0}", tablename);
using (DbDataAdapter a = BuildDataAdapter(query))
{
a.ContinueUpdateOnError = false;
DataTable dt = ds.Tables[tablename];
DbCommandBuilder cmd = BuildCommandBuilder(a);
a.UpdateCommand = cmd.GetUpdateCommand();
a.DeleteCommand = cmd.GetDeleteCommand();
a.InsertCommand = cmd.GetInsertCommand();
a.Update(dt);
}
}
public void FillUSR_PDM_FILES(PreserieDS ds, string IDMAGAZZ)
{
string select = @" select FI.*, IM.IDMAGAZZ from gruppo.USR_PDM_FILES FI
INNER JOIN GRUPPO.USR_PDM_IMG_MAGAZZ IM ON IM.IDPDMFILE = FI.IDPDMFILE
where IM.idmagazz = $P{IDMAGAZZ}";
ParamSet ps = new ParamSet();
ps.AddParam("IDMAGAZZ", DbType.String, IDMAGAZZ);
using (DbDataAdapter da = BuildDataAdapter(select, ps))
{
da.Fill(ds.USR_PDM_FILES);
}
}
public void FillUSR_PRD_FASI(string IDLANCIOD, PreserieDS ds)
{
string query = @"SELECT * FROM DITTA1.USR_PRD_FASI WHERE IDLANCIOD = $P{IDLANCIOD1}
UNION ALL
SELECT * FROM DITTA2.USR_PRD_FASI WHERE IDLANCIOD = $P{IDLANCIOD2}";
ParamSet ps = new ParamSet();
ps.AddParam("IDLANCIOD1", DbType.String, IDLANCIOD);
ps.AddParam("IDLANCIOD2", DbType.String, IDLANCIOD);
using (DbDataAdapter da = BuildDataAdapter(query, ps))
{
da.Fill(ds.USR_PRD_FASI);
}
}
public void FillDettaglioReparto(PreserieDS ds, DataTable dt, string barcode)
{
string query = @"SELECT VI.* FROM {0} VI
INNER JOIN RW_PR_DETTAGLIO DT ON DT.IDDETTAGLIO = VI.IDDETTAGLIO
WHERE DT.BARCODE = $P<BARCODE>";
query = string.Format(query, dt.TableName);
ParamSet ps = new ParamSet();
ps.AddParam("BARCODE", DbType.String, barcode);
using (DbDataAdapter da = BuildDataAdapter(query, ps))
{
da.Fill(dt);
}
}
public void FillUSR_PRD_MOVFASIByBarcode(string Barcode, PreserieDS ds)
{
string query = @"SELECT * FROM DITTA1.USR_PRD_MOVFASI WHERE BARCODE = $P{BARCODE1}
UNION ALL
SELECT * FROM DITTA2.USR_PRD_MOVFASI WHERE BARCODE = $P{BARCODE2}";
ParamSet ps = new ParamSet();
ps.AddParam("BARCODE1", DbType.String, Barcode);
ps.AddParam("BARCODE2", DbType.String, Barcode);
using (DbDataAdapter da = BuildDataAdapter(query, ps))
{
da.Fill(ds.USR_PRD_MOVFASI);
}
}
public void FillRW_PR_DETTAGLIOByLancio(string IDLANCIOD, PreserieDS ds)
{
string query = @"SELECT PRE.* FROM RW_PR_DETTAGLIO PRE
INNER JOIN USR_PRD_MOVFASI MF ON MF.IDPRDMOVFASE = PRE.IDPRDMOVFASE
INNER JOIN USR_PRD_FASI FA ON FA.IDPRDFASE = MF.IDPRDFASE
WHERE FA.IDLANCIOD = $P{IDLANCIOD1}";
ParamSet ps = new ParamSet();
ps.AddParam("IDLANCIOD1", DbType.String, IDLANCIOD);
using (DbDataAdapter da = BuildDataAdapter(query, ps))
{
da.Fill(ds.RW_PR_DETTAGLIO);
}
}
public void FillUSR_PRD_LANCIODByBarcode(string Barcode, PreserieDS ds)
{
string query = @"SELECT LA.* FROM DITTA1.USR_PRD_FASI FA INNER JOIN DITTA1.USR_PRD_MOVFASI MF ON MF.IDPRDFASE = FA.IDPRDFASE INNER JOIN DITTA1.USR_PRD_LANCIOD LA ON LA.IDLANCIOD = FA.IDLANCIOD WHERE MF.BARCODE = $P{BARCODE1}
UNION ALL
SELECT LA.* FROM DITTA2.USR_PRD_FASI FA INNER JOIN DITTA2.USR_PRD_MOVFASI MF ON MF.IDPRDFASE = FA.IDPRDFASE INNER JOIN DITTA2.USR_PRD_LANCIOD LA ON LA.IDLANCIOD = FA.IDLANCIOD WHERE MF.BARCODE = $P{BARCODE2}";
ParamSet ps = new ParamSet();
ps.AddParam("BARCODE1", DbType.String, Barcode);
ps.AddParam("BARCODE2", DbType.String, Barcode);
using (DbDataAdapter da = BuildDataAdapter(query, ps))
{
da.Fill(ds.USR_PRD_LANCIOD);
}
}
public void FillMAGAZZ(PreserieDS ds, List <string> IDMAGAZZ)
{
if (IDMAGAZZ.Count == 0)
{
return;
}
string selezione = ConvertToStringForInCondition(IDMAGAZZ);
string select = @" SELECT * FROM GRUPPO.MAGAZZ WHERE IDMAGAZZ IN ({0})";
select = string.Format(select, selezione);
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.MAGAZZ);
}
}
public void TrovaCommessaPerNome(string nomeCommessa, PreserieDS ds)
{
if (string.IsNullOrEmpty(nomeCommessa))
{
return;
}
string query = @"SELECT * FROM DITTA1.USR_PRD_LANCIOD WHERE NOMECOMMESSA LIKE '%{0}%'
UNION ALL
SELECT * FROM DITTA2.USR_PRD_LANCIOD WHERE NOMECOMMESSA LIKE '%{1}%'";
query = string.Format(query, nomeCommessa, nomeCommessa);
using (DbDataAdapter da = BuildDataAdapter(query))
{
da.Fill(ds.USR_PRD_LANCIOD);
}
}
public void TrovaCommessaPerModello(string Modello, PreserieDS ds)
{
if (string.IsNullOrEmpty(Modello))
{
return;
}
string query = @"SELECT LA.* FROM DITTA1.USR_PRD_LANCIOD LA
INNER JOIN GRUPPO.MAGAZZ MA ON MA.IDMAGAZZ = LA.IDMAGAZZ
WHERE MA.MODELLO LIKE '{0}%'
UNION ALL
SELECT LA.* FROM DITTA2.USR_PRD_LANCIOD LA
INNER JOIN GRUPPO.MAGAZZ MA ON MA.IDMAGAZZ = LA.IDMAGAZZ
WHERE MA.MODELLO LIKE '{1}%'";
query = string.Format(query, Modello, Modello);
using (DbDataAdapter da = BuildDataAdapter(query))
{
da.Fill(ds.USR_PRD_LANCIOD);
}
}
public void CaricaDettagliPreserie(string tabella, PreserieDS ds, string IDLANCIOD)
{
string query = @"SELECT * FROM {0} SPEC
INNER JOIN RW_PR_DETTAGLIO DET ON DET.IDDETTAGLIO = SPEC.IDDETTAGLIO
INNER JOIN USR_PRD_MOVFASI MF ON MF.IDPRDMOVFASE = DET.IDPRDMOVFASE
INNER JOIN USR_PRD_FASI FA ON FA.IDPRDFASE = MF.IDPRDFASE
WHERE FA.IDLANCIOD = $P<IDLANCIOD1>";
query = string.Format(query, tabella);
ParamSet ps = new ParamSet();
ps.AddParam("IDLANCIOD1", DbType.String, IDLANCIOD);
DataTable dt = ds.Tables[tabella];
if (dt == null)
{
return;
}
using (DbDataAdapter da = BuildDataAdapter(query, ps))
{
da.Fill(dt);
}
}
public void UpdateRW_PR(string tablename, PreserieDS ds)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.UpdatePREDTable(tablename, ds);
}
public void CaricaDettagliPreserie(string tabella, PreserieDS ds, string IDLANCIOD)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.CaricaDettagliPreserie(tabella, ds, IDLANCIOD);
}
public void TrovaCommessaPerNome(string nomeCommessa, PreserieDS ds)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.TrovaCommessaPerNome(nomeCommessa, ds);
}
public void FillMAGAZZ(PreserieDS ds, List <string> IDMAGAZZ)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.FillMAGAZZ(ds, IDMAGAZZ);
}
public void TrovaCommessaPerModello(string Modello, PreserieDS ds)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.TrovaCommessaPerModello(Modello, ds);
}
public void FillRW_PR_DETTAGLIOByLancio(string IDLANCIOD, PreserieDS ds)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.FillRW_PR_DETTAGLIOByLancio(IDLANCIOD, ds);
}
public void FillUSR_PRD_FASI(string IDLANCIOD, PreserieDS ds)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.FillUSR_PRD_FASI(IDLANCIOD, ds);
}
public void FillCLIFO(PreserieDS ds)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.FillCLIFO(ds);
}
public void FillUSR_PDM_FILES(PreserieDS ds, string IDMAGAZZ)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.FillUSR_PDM_FILES(ds, IDMAGAZZ);
}
public void FillDettaglioReparto(PreserieDS ds, DataTable dt, string barcode)
{
PreserieAdapter a = new PreserieAdapter(DbConnection, DbTransaction);
a.FillDettaglioReparto(ds, dt, barcode);
}
