public void UpdateTable(string tablename, EtichetteDS ds) { string query = "SELECT * FROM ETICHETTELV"; using (DbDataAdapter a = BuildDataAdapter(query)) { try { a.ContinueUpdateOnError = false; DataTable dt = ds.Tables["ETI_ARTICOLI"]; DbCommandBuilder cmd = BuildCommandBuilder(a); a.UpdateCommand = cmd.GetUpdateCommand(); a.DeleteCommand = cmd.GetDeleteCommand(); a.InsertCommand = cmd.GetInsertCommand(); a.Update(dt); } catch (DBConcurrencyException ex) { } catch { throw; } } }
public void FillETI_ARTICOLI(EtichetteDS ds, string IDMAGAZZ) { string select = @"SELECT * FROM ETI_ARTICOLI WHERE IDMAGAZZ= $P<IDMAGAZZ>"; ParamSet ps = new ParamSet(); ps.AddParam("IDMAGAZZ", DbType.String, IDMAGAZZ); using (DbDataAdapter da = BuildDataAdapter(select, ps)) { da.Fill(ds.ETI_ARTICOLI); } }
public void TrovaArticolo(EtichetteDS ds, string Modello) { string select = @"SELECT * FROM GRUPPO.MAGAZZ WHERE MODELLO like $P<MODELLO>"; ParamSet ps = new ParamSet(); string MODELLO = string.Format("%{0}%", Modello); ps.AddParam("MODELLO", DbType.String, MODELLO); using (DbDataAdapter da = BuildDataAdapter(select, ps)) { da.Fill(ds.MAGAZZ); } }
public void FillMAGAZZSQL(EtichetteDS ds, string IDMAGAZZ) { string select = @"SELECT * FROM CROSSREFERENCE where [Cross-Reference Type]=1 and [Cross-Reference Type No_]in('C00197','C00422','C00443','C00463','C00481') AND [Cross-Reference No_] like '$P<IDMAGAZZ>' "; ParamSet ps = new ParamSet(); ps.AddParam("IDMAGAZZ", DbType.String, IDMAGAZZ); using (DbDataAdapter da = BuildDataAdapter(select, ps)) { da.Fill(ds.MAGAZZ); } }
public void TrovaArticoloSQL(EtichetteDS ds, string Modello) { string select = @"SELECT [Item No_] IDMAGAZZ,[Cross-Reference No_] MODELLO,[DESCRIPTION]DESMAGAZZ FROM CROSSREFERENCE where [Cross-Reference Type]=1 and [Cross-Reference Type No_]in('C00197','C00422','C00443','C00463','C00481') "; // AND [Cross-Reference No_] like '$P<MODELLO>"; ParamSet ps = new ParamSet(); AddConditionAndParam(ref select, "[Cross-Reference No_]", "MODELLO", Modello, ps, true); using (DbDataAdapter da = BuildDataAdapter(select, ps)) { da.Fill(ds.MAGAZZ); } }
public void FillTEMP_COMMESSA(EtichetteDS ds, string IDMAGAZZ) { string select = @"SELECT trim(CLI.RAGIONESOC) as RAGIONESOC,trim(DT.RIFERIMENTO) as RIFERIMENTO,trim(DD.NRRIGA) as NRRIGA from DITTA1.USR_VENDITED DD INNER JOIN DITTA1.USR_VENDITET DT ON DT.IDVENDITET = DD.IDVENDITET INNER JOIN GRUPPO.CLIFO CLI ON DT.CODICECLIFO = CLI.CODICE WHERE DD.IDMAGAZZ= $P<IDMAGAZZ> AND DT.IDTABTIPDOC='0000000022' order by DT.RIFERIMENTO, dd.nrriga "; ParamSet ps = new ParamSet(); ps.AddParam("IDMAGAZZ", DbType.String, IDMAGAZZ); using (DbDataAdapter da = BuildDataAdapter(select, ps)) { da.Fill(ds.TEMP_COMMESSA); } }
public void FillUSR_IMPORT_MAGAZZ(EtichetteDS ds, string IDMAGAZZ) { string select = @"SELECT * FROM DITTA1.USR_IMPORT_MAGAZZ WHERE IDMAGAZZ= $P<IDMAGAZZ>"; ParamSet ps = new ParamSet(); ps.AddParam("IDMAGAZZ", DbType.String, IDMAGAZZ); using (DbDataAdapter da = BuildDataAdapter(select, ps)) { da.Fill(ds.USR_IMPORT_MAGAZZ); } select = @"SELECT * FROM DITTA2.USR_IMPORT_MAGAZZ WHERE IDMAGAZZ= $P<IDMAGAZZ>"; ps = new ParamSet(); ps.AddParam("IDMAGAZZ", DbType.String, IDMAGAZZ); using (DbDataAdapter da = BuildDataAdapter(select, ps)) { da.Fill(ds.USR_IMPORT_MAGAZZ); } }
private void btnTrova_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtModelloRicerca.Text)) { return; } string modelloDaTrovare = txtModelloRicerca.Text.Trim().ToUpper(); _ds = new EtichetteDS(); if (chkBC.Checked) { using (CreaEtichetteBusinesSQL bEtichetta = new CreaEtichetteBusinesSQL()) { bEtichetta.TrovaArticolo(_ds, modelloDaTrovare); } } else { using (CreaEtichetteBusiness bEtichetta = new CreaEtichetteBusiness()) { bEtichetta.TrovaArticolo(_ds, modelloDaTrovare); } } dgvArticoli.AutoGenerateColumns = true; dgvArticoli.DataSource = _ds; dgvArticoli.DataMember = _ds.MAGAZZ.TableName; for (int i = 0; i < dgvArticoli.Columns.Count; i++) { dgvArticoli.Columns[i].Visible = false; } dgvArticoli.Columns[1].Visible = true; dgvArticoli.Columns[1].Width = 180; dgvArticoli.Columns[2].Visible = true; dgvArticoli.Columns[2].Width = 400; System.Drawing.Font font = new System.Drawing.Font(dgvArticoli.Font.FontFamily, 8); dgvArticoli.Font = font; }
public void FillTEMP_COMMESSA(EtichetteDS ds, string IDMAGAZZ) { CreaEtichetteAdapter a = new CreaEtichetteAdapter(DbConnection, DbTransaction); a.FillTEMP_COMMESSA(ds, IDMAGAZZ); }
public void UpdateETI_ARTICOLI(EtichetteDS ds) { CreaEtichetteAdapter a = new CreaEtichetteAdapter(DbConnection, DbTransaction); a.UpdateTable(ds.ETI_ARTICOLI.TableName, ds); }
public void FillETI_ARTICOLI(EtichetteDS ds, string IDMAGAZZ) { CreaEtichetteAdapter a = new CreaEtichetteAdapter(DbConnection, DbTransaction); a.FillETI_ARTICOLI(ds, IDMAGAZZ); }
public void FillUSR_IMPORT_MAGAZZ(EtichetteDS ds, string IDMAGAZZ) { CreaEtichetteAdapter a = new CreaEtichetteAdapter(DbConnection, DbTransaction); a.FillUSR_IMPORT_MAGAZZ(ds, IDMAGAZZ); }
public void TrovaArticolo(EtichetteDS ds, string Modello) { CreaEtichetteAdapter a = new CreaEtichetteAdapter(DbConnection, DbTransaction); a.TrovaArticolo(ds, Modello); }
public void UpdateETI_ARTICOLI(EtichetteDS ds) { CreaEtichetteAdapter a = new CreaEtichetteAdapter(DbConnection, DbTransaction); a.UpdateTable("ETICHETTELV", ds); }