public DTCBS_Switch ViewSwitch(string tungay,string denngay) { string strSQL,ConnectStr ; DTCBS_Switch DSWitch =new DTCBS_Switch(); try { //----------------------------SQL truy van cac giao dich trong ngay tren tung may ATM------------------------- //a.processing_code as TypeTrans, strSQL="select to_char(a.card_number) as cardnbr, a.account_number as acctnbr, a.transaction_amount as tranamt,c.aut_iso_43 as ATM, a.transaction_local_date as localtime,a.trace_audit_number as systrace "; strSQL+=" from autho_activity a , pg_automates c"; strSQL+=" where a.code_action ='000'"; strSQL+=" and a.message_type = '1200'"; strSQL+=" and substr(a.card_acceptor_term_id,1,4) = c.aut_numlogique"; strSQL+=" and substr(a.processing_code,1,2) = '17'"; strSQL+=" and a.date_create>= to_date('" + tungay + "','yyyy-mm-dd HH24:MI')"; strSQL+=" and a.date_create <= to_date('" + denngay + "','yyyy-mm-dd HH24:MI')"; strSQL+=" and not exists (select *"; strSQL+=" from autho_activity b"; strSQL+=" where b.card_number = a.card_number"; strSQL+=" and b.reference_number = a.reference_number"; strSQL+=" and b.code_action = '000'"; strSQL+=" and b.message_type = '1420')"; //-------------------------------End of SQL-------------------------------------------------------------------- //oleDbConnection1.ConnectionString="Provider=OraOLEDB.Oracle.1;User ID=acbprod;Password=acbprod1;Data Source=Electra.world;Extended Properties=;Persist Security Info=False"; System.IO.StreamReader str=new System.IO.StreamReader("ConnectStr.txt"); ConnectStr=str.ReadLine(); str.Close(); ConnectStr = ConnectStr.Substring(0, 44) + FrmMain.pass + ConnectStr.Substring(44, 74); oleDbConnection1.ConnectionString=ConnectStr; oleDbConnection1.Open(); oleDbDataAdapter1.SelectCommand.CommandText=strSQL; oleDbDataAdapter1.SelectCommand.ExecuteNonQuery(); oleDbDataAdapter1.Fill(DSWitch.Tables["Switch"]); oleDbConnection1.Close(); return DSWitch; } catch(Exception ex) { MessageBox.Show(ex.Message); } return DSWitch; }
public DTCBS_Switch ViewTCBS(string tungay,string denngay) { string strSQL,ConnectStr ; DTCBS_Switch DSTCBS =new DTCBS_Switch(); try { //----------------------------SQL truy van cac giao dich trong ngay tren tung may ATM------------------------- strSQL="select a.cardnbr as cardnbr, a.fromacctnbr as acctnbr,a.tranamount as tranamt, a.merchantname as ATM, a.datelastmaint as localtime,substr(IN_MESSAGE,76,6) as systrace "; strSQL+=" from card_transaction_atm a"; strSQL+=" where a.transactiontypcd='ACW'"; strSQL+=" and a.currstatuscd = 'OK'"; strSQL+=" and a.datelastmaint >=to_date('" + tungay + "','yyyy-mm-dd HH24:MI')"; strSQL+=" and a.datelastmaint <= to_date('" + denngay + "','yyyy-mm-dd HH24:MI')"; //-------------------------------End of SQL-------------------------------------------------------------------- //oleDbConnection1.ConnectionString="Provider=OraOLEDB.Oracle.1;User ID=acbprod;Password=acbprod1;Data Source=Electra.world;Extended Properties=;Persist Security Info=False"; System.IO.StreamReader str=new System.IO.StreamReader("ConnectStrTCBS.txt"); ConnectStr=str.ReadLine(); str.Close(); oleDbConnection2.ConnectionString=ConnectStr; oleDbConnection2.Open(); oleDbDataAdapter2.SelectCommand.CommandText=strSQL; oleDbDataAdapter2.SelectCommand.ExecuteNonQuery(); oleDbDataAdapter2.Fill(DSTCBS.Tables["TCBS"]); oleDbConnection2.Close(); return DSTCBS; } catch(Exception ex) { MessageBox.Show(ex.Message); } return DSTCBS; }