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); }