public EditSold(DBProvider db, string tableName, string code, bool exh) { InitializeComponent(); this.db = db; this.Exhibition = exh; if (!Exhibition) txtExhibition.Enabled = false; else { txtSellDate.Enabled = false; txtSellPrice.Enabled = false; } if (code == null) { MessageBox.Show(this, "Code is missing!", "Edit sold", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { string sExh = string.Empty; if (Exhibition) sExh = ", EXHIBITIONNAME"; else sExh = ", A.SELLDATE, A.SELLPRICE"; var ds = db.ExecuteQuery(string.Format("select B.CODE, B.ITEMNAME, B.COUNTRY, B.SUPPLIER, B.LENGTH, B.WIDTH, B.VK_NETTO, B.DATE {3} from {0} A join {1} B on A.CODE = B.CODE where A.code = {2}", tableName, DBProvider.TableNames[(int)TABS.MAIN], code, sExh)); if (ds != null && ds.Tables.Count > 0) { var vals = ds.Tables[0].Rows[0].ItemArray; txtCode.Text = vals[0].ToString(); txtName.Text = vals[1].ToString(); txtCountry.Text = vals[2].ToString(); txtSupplier.Text = vals[3].ToString(); txtLegnth.Text = vals[4].ToString(); txtWidth.Text = vals[5].ToString(); txtItemPrice.Text = vals[6].ToString(); txtDate.Text = vals[7].ToString(); if (Exhibition) txtExhibition.Text = vals[8].ToString(); else { txtSellDate.Text = vals[8].ToString(); txtSellPrice.Text = vals[9].ToString(); } } } }
public InventoryResult(DBProvider db, List<string> missingMain, List<string> missingInv) { InitializeComponent(); var table = new DataTable("inventory"); table.Columns.Add("Code"); missingMain.ForEach(s => table.Rows.Add(s)); gridMissingMain.DataSource = table; var table2 = db.ExecuteQuery(DBProvider.TableNames[0], string.Format(" where code in ({0})", string.Join(",", missingInv.ToArray())), " order by code desc ").Tables[0]; gridMissingInv.DataSource = table2; lblMissingMain.Text = lblMissingMain.Text.Replace("XXX", table.Rows.Count.ToString()); lblMissingInv.Text = lblMissingInv.Text.Replace("XXX", table2.Rows.Count.ToString()); }
public AddEditMain(DBProvider db, string tableName, string code, EditMode mode) { InitializeComponent(); this.mode = mode; this.db = db; if (code == null) { txtCode.Text = (db.LoadMaxCode(false) + 1).ToString(); } else { var ds = db.ExecuteQuery(tableName, " where code = " + code, ""); if (ds != null && ds.Tables.Count > 0) { var vals = ds.Tables[0].Rows[0].ItemArray; txtCode.Text = vals[0].ToString(); txtName.Text = vals[1].ToString(); txtCountry.Text = vals[2].ToString(); txtSupplier.Text = vals[3].ToString(); txtSupplierNr.Text = vals[4].ToString(); txtLength.Text = vals[5].ToString(); txtWidth.Text = vals[6].ToString(); txtEKNetto.Text = vals[7].ToString(); txtVKNetto.Text = vals[8].ToString(); txtQuantity.Text = vals[9].ToString(); txtQMPrice.Text = vals[10].ToString(); txtDate.Text = vals[11].ToString(); txtMVDate.Text = vals[12].ToString(); txtInvoice.Text = vals[13].ToString(); txtColor.Text = vals[14].ToString(); txtMaterial.Text = vals[15].ToString(); txtComment.Text = vals[16].ToString(); txtInfo.Text = vals[17].ToString(); txtEuroStuck.Text = vals[18].ToString(); txtPaid.Text = vals[19].ToString(); } } }
private string CreateDBSoldTXT() { DBProvider dbp = new DBProvider(Properties.Settings.Default.PtcommDir + @"\arena.db"); var data = dbp.ExecuteQuery(DBProvider.TableNames[1], " where VALID = 1 ", ""); if (data.Tables != null && data.Tables.Count == 1) { var res = new List<string>(); foreach (DataRow r in data.Tables[0].Rows) { res.Add(r[0].ToString()); res.Add(r[1].ToString()); res.Add(r[2].ToString()); } var ret = Properties.Settings.Default.PtcommDir + @"\DBSOLD.TXT"; File.WriteAllLines(ret, res.ToArray()); return ret; } return null; }