private void btnChiTiet_Click(object sender, EventArgs e)
        {
            frmShowThanhToanDL a = new frmShowThanhToanDL();
            string sql = "", err = "";
            a.type = "Dai ly";
            if (merchantno == "")
            {
                MessageBox.Show("Please choose merchant number before.");
                return;
            }
            else
            {
                sql = "select b.transaction_date trans_date,b.authorization_number auth_number,b.trace_audit_number trace_number,a.transaction_amount trans_amount,a.net_amount,a.discount_amount discount_amount,"+
                             "decode(substr(lpad(b.processing_code,6,'0'),1,2),'00','Sale/Purchase','01','Cash Advance','02',decode(b.function_code,'401','Adjustment','200','Void'),'20','Refund','31','Balance Inquiry') trans_type," +
                             "a.transaction_currency currency " +
                      "from  " + Businessbp.executedb.owner + "merchant_stmt_txn_details a,  " + Businessbp.executedb.owner + "transaction_hist b,  " + Businessbp.executedb.owner + "merchant_stmt_details c,  " + Businessbp.executedb.owner + "merchant d " +
                      "where a.outlet_number = b.outlet_number " +
                            "and a.microfilm_ref_number = b.microfilm_ref_number " +
                            "and a.sequence_number = b.sequence_number " +
                            "and a.transaction_code = b.transaction_code " +
                            "and a.statement_no = c.statement_no " +
                            "and c.merchant_number = d.merchant_number " +
                            "and trunc(a.date_create) >= to_date('" + dtFrom.Text.Trim() + "','mm/dd/yyyy') " +
                            "and trunc(a.date_create) <= to_date('" + dtTo.Text.Trim() + "','mm/dd/yyyy') " +
                            "and c.merchant_number = '" + merchantno + "'";

                DataTable dtt = Businessbp.executedb.getTable(sql, ref err);
                if (err != "")
                {
                    MessageBox.Show(err);
                    return;
                }
                a.dt = dtt;
                a.fromtime = dtFrom.Text;
                a.totime = dtTo.Text;
                a.thoiGian = DateTime.Now.ToShortDateString();
                a.merchantno = merchantno;
                a.merchantname = merchantname;
                a.ShowDialog();
            }
        }
        private void btnBaoCao_Click(object sender, EventArgs e)
        {
            // dung showthanhtoandl
            frmShowThanhToanDL a = new frmShowThanhToanDL();
            string sql = "",err = "";
            string dieukien = "";

            a.type = "Khu vuc";
            dieukien = PrepareDK();
            sql = "select c.merchant_number,d.company_name merchant_name,b.terminal_id,nvl(sum(to_char(a.transaction_amount)),0) as Doanhso,"+
                        "d.date_create,d.account1 account " +
                  "from  " + Businessbp.executedb.owner + "merchant_stmt_txn_details a,  " + Businessbp.executedb.owner + "transaction_hist b,  " + Businessbp.executedb.owner + "merchant_stmt_details c,"+
                        " " + Businessbp.executedb.owner + "merchant d ,  " + Businessbp.executedb.owner + "city e "+
                  "where a.outlet_number = b.outlet_number "+
                        "and a.microfilm_ref_number = b.microfilm_ref_number "+
                        "and a.sequence_number = b.sequence_number "+
                        "and a.transaction_code = b.transaction_code "+
                        "and a.statement_no = c.statement_no "+
                        "and c.merchant_number = d.merchant_number "+
                        "and d.city_code = e.city_code "+
                        "and trunc(a.date_create) >= to_date('" + dtFrom.Text.Trim() + "','mm/dd/yyyy') "+
                        "and trunc(a.date_create) <= to_date('" + dtTo.Text.Trim() + "','mm/dd/yyyy') "+
                        dieukien +
                  "group by c.merchant_number,d.company_name,d.account1,b.terminal_id,d.date_create";

            DataTable dtt = Businessbp.executedb.getTable(sql, ref err);
            if (err != "")
            {
                MessageBox.Show(err);
                return;
            }
            a.dt = dtt;
            a.fromtime = dtFrom.Text;
            a.totime = dtTo.Text;
            a.thoiGian = DateTime.Now.ToShortDateString();
            a.ShowDialog();
        }