예제 #1
0
        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();
        }
예제 #2
0
        private void load_base()
        {
            OracleHandler oh = new OracleHandler();
//            OracleDataReader odr;

            string sql = "select NOBUKTI, TGL, JAM, NMKAS, TOTAL, JNSBYR, TVCH, TBYR, " +
                         " TDBT, TCCD, KEMBALI, NOCARD, PEMILIK, NMCARD, KET, LOKASI, " +
                         " NM_UPDATE, TG_UPDATE, TGL_INSERT, TPIUTANG, TOTHER, MEMBERID, TXT " +
                         "from  ERP.H_JUAL " +
                         "where 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())
                {
//already have nobukti so skip that one
                    this.base_data.tgl   = odr.GetDateTime(1);
                    this.base_data.jam   = odr.GetDateTime(2);
                    this.base_data.nmkas = odr.GetString(3);
                    base_data.total      = double.Parse(odr.GetString(4));
                }
                odr.Dispose();
            }
            oh.disconnect();
        }