public void ProcessPayment(String MEMBER_NO, String COOP_ID, String ACCOUNT_NO, Decimal ITEM_AMT, DateTime CCS_OPERATE_DATE, String SYSTEM_CODE, String OPERATE_CODE, String CASH_TYPE, String ATM_NO, String ATM_SEQNO, String SAVING_ACC, LogMessage LogMessage, Sta ta) { try { if (SYSTEM_CODE == "01") //เงินกู้ { String SqlUpdateATMLOAN = "UPDATE ATMLOAN SET PAY_AMT=PAY_AMT + {0} WHERE ATMLOAN.MEMBER_NO={1} AND ATMLOAN.COOP_ID={2} AND ATMLOAN.LOANCONTRACT_NO={3}"; SqlUpdateATMLOAN = WebUtil.SQLFormat(SqlUpdateATMLOAN, ITEM_AMT, MEMBER_NO, COOP_ID, ACCOUNT_NO); LogMessage.WriteLog("UPDATE ATMLOAN", SqlUpdateATMLOAN); ta.Exe(SqlUpdateATMLOAN); } else if (SYSTEM_CODE == "02") //เงินฝาก { String SqlUpdateATMDEPT = "UPDATE ATMDEPT SET PAY_AMT=PAY_AMT + {0} WHERE ATMDEPT.MEMBER_NO={1} AND ATMDEPT.COOP_ID={2} AND ATMDEPT.DEPTACCOUNT_NO={3}"; SqlUpdateATMDEPT = WebUtil.SQLFormat(SqlUpdateATMDEPT, ITEM_AMT, MEMBER_NO, COOP_ID, ACCOUNT_NO); LogMessage.WriteLog("UPDATE ATMDEPT", SqlUpdateATMDEPT); ta.Exe(SqlUpdateATMDEPT); } else { throw new Exception("SYSTEM_CODE NOT VALUE (ไม่ถูกต้อง)"); } String SqlInsertATMTRANSACTION = @"INSERT INTO ATMTRANSACTION ( MEMBER_NO, COOP_ID, ACCOUNT_NO, CCS_OPERATE_DATE, SYSTEM_CODE, OPERATE_CODE, CASH_TYPE, ITEM_AMT, ATM_NO, ATM_SEQNO, SAVING_ACC ) VALUES ( {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10})"; SqlInsertATMTRANSACTION = WebUtil.SQLFormat(SqlInsertATMTRANSACTION, MEMBER_NO, COOP_ID, ACCOUNT_NO, CCS_OPERATE_DATE, SYSTEM_CODE, OPERATE_CODE, CASH_TYPE, ITEM_AMT, ATM_NO, ATM_SEQNO, SAVING_ACC); LogMessage.WriteLog("INSERT ATMTRAN", SqlInsertATMTRANSACTION); ta.Exe(SqlInsertATMTRANSACTION); } catch (Exception ex) { throw ex; } }
public void ProcessCancelPayment(String MEMBER_NO, String COOP_ID, String ACCOUNT_NO, Decimal ITEM_AMT, DateTime CCS_OPERATE_DATE, String SYSTEM_CODE, String OPERATE_CODE, String CASH_TYPE, String ATM_NO, String ATM_SEQNO, String SAVING_ACC, LogMessage LogMessage, Sta ta) { try { String SqlInsertATMTRANSACTIONCANCEL = @"INSERT INTO ATMTRANSACTIONCANCEL ( MEMBER_NO, COOP_ID, ACCOUNT_NO, CCS_OPERATE_DATE, SYSTEM_CODE, OPERATE_CODE, CASH_TYPE, ITEM_AMT, ATM_NO, ATM_SEQNO, SAVING_ACC ) VALUES ( {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10})"; SqlInsertATMTRANSACTIONCANCEL = WebUtil.SQLFormat(SqlInsertATMTRANSACTIONCANCEL, MEMBER_NO, COOP_ID, ACCOUNT_NO, CCS_OPERATE_DATE, SYSTEM_CODE, OPERATE_CODE, CASH_TYPE, ITEM_AMT, ATM_NO, ATM_SEQNO, SAVING_ACC); LogMessage.WriteLog("INSERT TRNCANCEL", SqlInsertATMTRANSACTIONCANCEL); ta.Exe(SqlInsertATMTRANSACTIONCANCEL); } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { String SqlRequest = String.Empty; String SqlResponse = String.Empty; Sta ta = new Sta(); Sta taCommit = new Sta(); String LogFileName = DateTime.Now.ToString("yyyyMMdd") + ".txt"; try { String DataMessage = Request["DataMassage"]; try { LogFileName = DateTime.Now.ToString("yyyyMMdd") + DataMessage.Substring(157, 10) + ".txt"; } catch { } LogMessage = new LogMessage(LogFileName); LogMessage.WriteLog("Request", DataMessage); //เชค Online ใน AppTest if (DataMessage == "TestWCF") { Result = "1"; return; } //ตรวจสอบข้อมูล CheckLength(ref DataMessage); //จัดการข้อมูล DataEncode DataRequest = new DataEncode(DataMessage); DataEncode DataResponse = new DataEncode(DataMessage); try { taCommit.Transection(); ta.Transection(); } catch (Exception ex) { DataResponse.ResponseCode = ResponseCode.DatabaseProblem; Result = DataResponse.DataMassage; LogMessage.WriteLog("Database Problem", ""); throw ex; } //############################################################################# DataResponse.ResponseCode = ResponseCode.SystemError; //ป้องกันการ Error Exception SqlResponse = DataResponse.GetInsertATMACT(); Result = DataResponse.DataMassage; DataResponse.ResponseCode = ResponseCode.Approve; //############################################################################# SqlRequest = DataRequest.GetInsertATMACT();//บันทึกลงตาราง ATMACT เก็บ LOG การ Request LogMessage.WriteLog("LOGREQ SQL", SqlRequest); taCommit.Exe(SqlRequest); //############################################################################# try { //ตรวจสอบ Request switch (DataRequest.TransactionMessageCode) { case "0100": // Account Name Inquiry [ถามชื่อบัญชี] AccountNameInquiry(DataRequest, ref DataResponse, ta, LogMessage); break; case "0700": //Balance Inquiry BalanceInquiry(DataRequest, ref DataResponse, ta, LogMessage); break; case "0200": // Fund Transfer //Money Withdraw Transaction(DataRequest, ref DataResponse, ta, LogMessage); break; case "0400": //Fund Transfer/ Cash Withdraw Reversal Request[ยกเลิกรายการทันที] CancelTransaction(DataRequest, ref DataResponse, ta, LogMessage); break; default: break; } } catch (Exception ex) { if (DataResponse.ResponseCode == 0) { DataResponse.ResponseCode = ResponseCode.SystemError; } LogMessage.WriteLog("ResponseCode", "[" + DataResponse.ResponseCode + "]"); Result = DataResponse.DataMassage; SqlResponse = DataResponse.GetInsertATMACT(); throw ex; } Result = DataResponse.DataMassage; SqlResponse = DataResponse.GetInsertATMACT();//บันทึกลงตาราง ATMACT เก็บ LOG การ Response LogMessage.WriteLog("LOGRES SQL", SqlResponse); taCommit.Exe(SqlResponse); taCommit.Commit(); ta.Commit(); taCommit.Close(); ta.Close(); } catch (Exception ex) { LogMessage.WriteLog("ExceptionErr", ex.Message.Trim()); try { ta.RollBack(); ta.Close(); } catch { } try { try { LogMessage.WriteLog("LOGRES SQL", SqlResponse); taCommit.Exe(SqlResponse); } catch { } taCommit.Commit(); taCommit.Close(); } catch { } } LogMessage.WriteLog("Response", Result); LogMessage.WriteLog("", "-------------------------------------------------------------------------------\r\n"); }