示例#1
0
 private void button1_Click(object sender, EventArgs e)
 {
     //View Success
     if (isNumber(tbSwim.Text.Trim()))
     {
         string sql = "", err = "";
         sql = "select bn.record_seq, ''''||bn.cardnbr as cardnbr, bn.acctnbr, bn.amt, bn.hold_amount,bn.hold_date, bn.release_date, bn.txn_code, bn.transaction_datetime, bn.merchant_desc" +
                 " from " + Businessbp.executedb.owner + "card_swim_bnk bn" +
                 " where bn.swim_id = "+tbSwim.Text.Trim()+
                 " and bn.status = 'Y'"+
                 " and bn.islg is null"+
                 " and bn.swim_file is not null"+
                 " and bn.can_swim = 'Y'"+
                 " union all"+
                 " select count(*), null, null, sum(bn.amt), sum(bn.hold_amount), null, null, null, null, null"+
                 " from " + Businessbp.executedb.owner + "card_swim_bnk bn" +
                 " where bn.swim_id = "+tbSwim.Text.Trim()+
                 " and bn.status = 'Y'"+
                 " and bn.islg is null"+
                 " and bn.swim_file is not null"+
                 " and bn.can_swim = 'Y'"+
                 " group by bn.swim_id   ";
         frmView a = new frmView();
         a.SQL = sql;
         a.ShowDialog();
     }
 }
 private void button1_Click(object sender, EventArgs e)
 {
     //View Match
     if (isNumber(tbSwim.Text.Trim()))
     {
         string sql = "", err = "";
         sql = "select bn.record_seq, ''''||bn.arn as arn, ''''||bn.card_number as card_number, bn.account_number, bn.account_currency, bn.txnamt, bn.txn_currency, bn.billing_amt, bn.billing_currency," +
                        " bn.txn_code, bn.merchant_name, bn.transaction_datetime, bn.autho_status, bn.acqid, bn.reversalyn, bn.autho_reference_number," +
                        " bn.trace_audit_number, bn.terminal_id, bn.processing_date, bn.authorization_number " +
                 " from " + Businessbp.executedb.owner + "card_bnk_detail bn" +
                 " where bn.swim_id = " + tbSwim.Text.Trim() +
                 " and bn.autho_status = 1"+
                 " and bn.status <> 'H'"+
                 " union all" +
                 " select count(*), null, null, null, null, sum(bn.txnamt), null, sum(bn.billing_amt),  null," +
                         " null,  null,  null,  null,  null,  null,  null," +
                         " null,  null,  null,  null " +
                 " from " + Businessbp.executedb.owner + "card_bnk_detail bn" +
                 " where bn.swim_id = " + tbSwim.Text.Trim() +
                 " and bn.autho_status = 1" +
                 " and bn.status <> 'H'" +
                 " group by bn.swim_id  ";
         frmView a = new frmView();
         a.SQL = sql;
         a.ShowDialog();
     }
 }
 private void button5_Click(object sender, EventArgs e)
 {
     //View release
     if (isNumber(tbSwimBatch.Text.Trim()))
     {
         string sql = "", err = "";
         sql = "select aa.swim_id, aa.record_seq, ''''||aa.cardnbr as cardnbr, aa.acctnbr, aa.amt, aa.hold_amount, aa.hold_date, aa.txndesc" +
                 " from " + Businessbp.executedb.owner + "card_swimrepeat_bnk aa" +
                 " where aa.batch_id = " + tbSwimBatch.Text.Trim() +
                 " and nvl(aa.islg,'N') ='N'" +
                 " and aa.release_date is not null"+
                 " union all" +
                 " select count(*), null, null, null, sum(amt), sum(hold_amount), null, null" +
                 " from " + Businessbp.executedb.owner + "card_swimrepeat_bnk aa" +
                 " where aa.batch_id = " + tbSwimBatch.Text.Trim() +
                 " and nvl(aa.islg,'N') ='N'" +
                 " and aa.release_date is not null" +
                 " group by aa.batch_id";
         frmView a = new frmView();
         a.SQL = sql;
         a.ShowDialog();
     }
 }