private void load_items() { OracleHandler oh = new OracleHandler(); string sql = "select dj.KDBRG, dj.KDGOL, dj.KDSUPP, dj.HBELI, dj.HJUAL, " + " dj.QTY, dj.DISC, dj.DISCRP, dj.LOKASI, dj.NM_UPDATE, " + " dj.TG_UPDATE, dj.TGL_INSERT, dj.SPID, dj.TXT, nvl(v.T,'N') " + "from d_jual dj, vendor v " + "where dj.kdsupp = v.vendor_code " + " and nobukti = '" + this.base_data.nobukti + "'"; if (!oh.connect()) { return; } if (!oh.DoQuery(sql)) { return; } if (oh.getRowCount() >= 1) { OracleDataReader odr = oh.odr; while (odr.Read()) { saleItem tmp_si = new saleItem(); tmp_si.item_code_kdbrg = odr.GetString(0); tmp_si.category_kdgol = odr.GetString(1); tmp_si.vendor_code_kdsupp = odr.GetString(2); tmp_si.item_price_hjual = double.Parse(odr.GetString(4)); tmp_si.quantity_qty = Int32.Parse(odr.GetString(5)); tmp_si.t = odr.GetString(14); this.sales_items.Add(tmp_si); // tmpTs.nmkas = odr.GetString(2); // tmpTs.total = double.Parse(odr.GetString(3)); // tmpTs.jnsbyr = odr.GetString(4); // tmpTs.tvch = double.Parse(odr.GetString(5)); // tmpTs.tbyr = double.Parse(odr.GetString(6)); // tmpTs.tdbt = double.Parse(odr.GetString(7)); // tmpTs.tccd = double.Parse(odr.GetString(8)); // tmpTs.tpiutang = double.Parse(odr.GetString(9)); // tmpTs.kembali = double.Parse(odr.GetString(10)); // tmpTs.tother = double.Parse(odr.GetString(11)); // tmpTs.total_quantity = Int32.Parse(odr.GetString(12)); } odr.Dispose(); } oh.disconnect(); }
public void loadItemRec(Object[] a_rec) { //the array of objects is set in stone. Any changes will need changed everywhere saleItem si = new saleItem(); si.item_code_kdbrg = a_rec[23].ToString(); si.category_kdgol = a_rec[24].ToString(); si.vendor_code_kdsupp = a_rec[25].ToString(); si.hbeli = double.Parse(a_rec[26].ToString()); si.item_price_hjual = double.Parse(a_rec[27].ToString()); si.quantity_qty = int.Parse(a_rec[28].ToString()); si.disc = double.Parse(a_rec[29].ToString()); si.discrp = double.Parse(a_rec[30].ToString()); si.location_lokasi = a_rec[31].ToString(); si.t = a_rec[33].ToString(); si.description = a_rec[34].ToString(); this.sales_items.Add(si); }