Пример #1
0
        private void printOutReturPermintaan()
        {
            string returNo     = noReturTextBox.Text;
            string sqlCommandx = "";
            string moduleType  = "RETUR PEMBELIAN";

            GUTIL.setPaper(comboBox1.SelectedIndex + 1);

            if (originModuleID == globalConstants.RETUR_PEMBELIAN_KE_SUPPLIER)
            {
                moduleType = "RETUR PEMBELIAN";
            }
            else
            {
                moduleType = "RETUR PERMINTAAN";
            }

            sqlCommandx = "SELECT '" + moduleType + "' AS MODULE_TYPE, RPH.RP_ID as 'NO_RETUR', IFNULL(MS.SUPPLIER_FULL_NAME, 'HQ PUSAT') AS 'NAME', RPH.RP_DATE AS 'RETUR_DATE', RPH.RP_TOTAL AS 'RETUR_TOTAL', MP.PRODUCT_NAME AS 'PRODUCT_NAME', RPD.PRODUCT_BASEPRICE AS 'PRICE', RPD.PRODUCT_QTY AS 'QTY', RPD.RP_DESCRIPTION AS 'DESC', RPD.RP_SUBTOTAL AS 'SUBTOTAL' " +
                          "FROM RETURN_PURCHASE_HEADER RPH LEFT OUTER JOIN MASTER_SUPPLIER MS ON RPH.SUPPLIER_ID = MS.SUPPLIER_ID, MASTER_PRODUCT MP, RETURN_PURCHASE_DETAIL RPD " +
                          "WHERE RPD.RP_ID = RPH.RP_ID AND RPD.PRODUCT_ID = MP.PRODUCT_ID AND RPH.RP_ID = '" + returNo + "'";

            DS.writeXML(sqlCommandx, globalConstants.returPermintaanXML);
            dataReturPermintaanPrintOutForm displayForm = new dataReturPermintaanPrintOutForm();

            displayForm.ShowDialog(this);
        }
Пример #2
0
        private void printOutReturPenjualan(string noRetur)
        {
            string returNo     = noRetur;
            string sqlCommandx = "";

            sqlCommandx = "SELECT 'RETUR PENJUALAN' AS MODULE_TYPE, RSH.RS_INVOICE AS 'NO_RETUR', IFNULL(MC.CUSTOMER_FULL_NAME, '') AS 'NAME', RSH.RS_DATETIME AS 'RETUR_DATE', RSH.RS_TOTAL AS 'RETUR_TOTAL', MP.PRODUCT_NAME AS 'PRODUCT_NAME', RSD.PRODUCT_SALES_PRICE AS 'PRICE', RSD.PRODUCT_RETURN_QTY AS 'QTY', RSD.RS_DESCRIPTION AS 'DESC', RSD.RS_SUBTOTAL AS 'SUBTOTAL' " +
                          "FROM RETURN_SALES_HEADER RSH LEFT OUTER JOIN MASTER_CUSTOMER MC ON RSH.CUSTOMER_ID = MC.CUSTOMER_ID, MASTER_PRODUCT MP, RETURN_SALES_DETAIL RSD " +
                          "WHERE RSD.RS_INVOICE = RSH.RS_INVOICE AND RSD.PRODUCT_ID = MP.PRODUCT_ID AND RSH.RS_INVOICE = '" + returNo + "'";

            DS.writeXML(sqlCommandx, globalConstants.returPermintaanXML);
            dataReturPermintaanPrintOutForm displayForm = new dataReturPermintaanPrintOutForm();

            displayForm.ShowDialog(this);
        }
Пример #3
0
        private void printOutReturPermintaan(string noRetur)
        {
            string returNo     = noRetur;
            string sqlCommandx = "";

            sqlCommandx = "SELECT 'RETUR PERMINTAAN' AS MODULE_TYPE, RPH.RP_ID AS 'NO_RETUR', IFNULL(MS.SUPPLIER_FULL_NAME, 'HQ PUSAT') AS 'NAME', RPH.RP_DATE AS 'RETUR_DATE', RPH.RP_TOTAL AS 'RETUR_TOTAL', MP.PRODUCT_NAME AS 'PRODUCT_NAME', RPD.PRODUCT_BASEPRICE AS 'PRICE', RPD.PRODUCT_QTY AS 'QTY', RPD.RP_DESCRIPTION AS 'DESC', RPD.RP_SUBTOTAL AS 'SUBTOTAL' " +
                          "FROM RETURN_PURCHASE_HEADER RPH LEFT OUTER JOIN MASTER_SUPPLIER MS ON RPH.SUPPLIER_ID = MS.SUPPLIER_ID, MASTER_PRODUCT MP, RETURN_PURCHASE_DETAIL RPD " +
                          "WHERE RPD.RP_ID = RPH.RP_ID AND RPD.PRODUCT_ID = MP.PRODUCT_ID AND RPH.RP_ID = '" + returNo + "'";

            DS.writeXML(sqlCommandx, globalConstants.returPermintaanXML);
            dataReturPermintaanPrintOutForm displayForm = new dataReturPermintaanPrintOutForm();

            displayForm.ShowDialog(this);
        }