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();
}
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();
}
}