public String GetAccountName(String Member_No, LogMessage LogMessage, Sta ta)
{
String ACCOUNT_NAME = String.Empty; //[***ห้ามเป็นภาษาไทย]
try
{
String SqlGetName = "SELECT MEMB_ENAME||' '||MEMB_ESURNAME AS ACCOUNT_NAME FROM MBMEMBMASTER WHERE MEMBER_NO = {0}";
SqlGetName = WebUtil.SQLFormat(SqlGetName, Member_No);
LogMessage.WriteLog("DeptAccount SQL", SqlGetName);
Sdt dt = ta.Query(SqlGetName);
if (dt.Next())
{
ACCOUNT_NAME = dt.GetString("ACCOUNT_NAME").ToUpper();
LogMessage.WriteLog("", "ACCOUNT_NAME = " + ACCOUNT_NAME);
if (ACCOUNT_NAME.Trim() == "")
{
ACCOUNT_NAME = "N/A";
}
}
else
{
ACCOUNT_NAME = "";
}
}
catch (Exception ex)
{
throw ex;
}
return(ACCOUNT_NAME);
}
public void LoanInquiry(String COOP_FIID, String Member_ID, LogMessage LogMessage, Sta ta)
{
try
{
MemberNo = Member_ID;
Decimal RECEIVE_AMT = 0;
Decimal PAY_AMT = 0;
Decimal SEQUEST_AMT = 0;
String SqlGetAccount = "SELECT TRIM(LOANCONTRACT_NO) AS LOANCONTRACT_NO, RECEIVE_AMT, PAY_AMT, SEQUEST_AMT, ACCOUNT_HOLD FROM ATMLOAN WHERE ACCOUNT_STATUS = 1 AND MEMBER_NO = {0} AND COOP_ID = {1}";
SqlGetAccount = WebUtil.SQLFormat(SqlGetAccount, Member_ID, COOP_FIID);
LogMessage.WriteLog("LoanCont SQL", SqlGetAccount);
Sdt dt = ta.Query(SqlGetAccount);
int RowCount = dt.GetRowCount();
if (RowCount != 1)
{
LedgerBal = 0;
AvailableBal = 0;
Loan_Hold = 1;
LogMessage.WriteLog("", "พบจำนวนสัญญาเงินกู้ ATM ของเลขที่สมาชิก " + Member_ID + " ที่ผูกกับ ATM [" + RowCount + " Row]");
return;
}
else if (dt.Next())
{
LOANCONTRACT_NO = dt.GetString("LOANCONTRACT_NO");
RECEIVE_AMT = dt.GetDecimal("RECEIVE_AMT");
PAY_AMT = dt.GetDecimal("PAY_AMT");
SEQUEST_AMT = dt.GetDecimal("SEQUEST_AMT");
ACCOUNT_HOLD = dt.GetDecimal("ACCOUNT_HOLD");
LogMessage.WriteLog("", "LOANCONTRACT_NO = " + LOANCONTRACT_NO + " , RECEIVE_AMT = " + RECEIVE_AMT.ToString("#,##0.00") + " , PAY_AMT = " + PAY_AMT.ToString("#,##0.00") + " , ACCOUNT_HOLD = " + ACCOUNT_HOLD.ToString("#0") + " , SEQUEST_AMT = " + SEQUEST_AMT.ToString("#,##0.00"));
}
String SqlString = "SELECT (NVL(LN.LOANAPPROVE_AMT, 0) - NVL(LN.PRINCIPAL_BALANCE, 0)) AS LEDGER_AMT, (NVL(LN.LOANAPPROVE_AMT, 0) - NVL(LN.PRINCIPAL_BALANCE, 0) - NVL(AC.LOANSEQUEST_AMT,0)) AS AVAILABLE_AMT, AC.LOAN_HOLD AS LOAN_HOLD FROM LNCONTMASTER LN, ATMCOOP AC WHERE LN.CONTRACT_STATUS = 1 AND TRIM(AC.COOP_ID) = {0} AND LN.MEMBER_NO = {1} AND LN.LOANCONTRACT_NO = {2}";
SqlString = WebUtil.SQLFormat(SqlString, COOP_FIID, Member_ID, LOANCONTRACT_NO);
LogMessage.WriteLog("LoanInquiry SQL", SqlString);
dt = ta.Query(SqlString);
RowCount = dt.GetRowCount();
if (RowCount != 1)
{
LedgerBal = 0;
AvailableBal = 0;
Dept_Hold = 1;
LogMessage.WriteLog("", "พบจำนวนสัญญาเงินกู้ ATM เลขที่ " + LOANCONTRACT_NO + " ของเลขที่สมาชิก " + Member_ID + " ที่ผูกกับ ATM [" + RowCount + " Row]");
return;
}
else if (dt.Next())
{
LedgerBal = dt.GetDecimal("LEDGER_AMT");
AvailableBal = dt.GetDecimal("AVAILABLE_AMT");
Loan_Hold = dt.GetDecimal("LOAN_HOLD");
LogMessage.WriteLog("", "LEDGER_AMT = " + LedgerBal.ToString("#,##0.00") + " , AVAILABLE_AMT = " + AvailableBal.ToString("#,##0.00") + " , LOAN_HOLD = " + Loan_Hold);
LedgerBal = LedgerBal - RECEIVE_AMT + PAY_AMT;
AvailableBal = AvailableBal - RECEIVE_AMT + PAY_AMT - SEQUEST_AMT;
}
LogMessage.WriteLog("", "LedgerBalance = " + LedgerBal.ToString("#,##0.00"));
LogMessage.WriteLog("", "AvailableBalance = " + AvailableBal.ToString("#,##0.00"));
if (AvailableBal < 0)
{
AvailableBal = 0;
LogMessage.WriteLog("", "[ChangBalance] AvailableBalance = " + AvailableBal.ToString("#,##0.00"));
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeptInquiry(String COOP_FIID, String Member_ID, LogMessage LogMessage, Sta ta)
{
try
{
MemberNo = Member_ID;
Decimal RECEIVE_AMT = 0;
Decimal PAY_AMT = 0;
Decimal SEQUEST_AMT = 0;
String SqlGetAccount = "SELECT TRIM(DEPTACCOUNT_NO) AS DEPTACCOUNT_NO, RECEIVE_AMT, PAY_AMT, SEQUEST_AMT, ACCOUNT_HOLD FROM ATMDEPT WHERE ACCOUNT_STATUS = 1 AND MEMBER_NO = {0} AND COOP_ID = {1}";
SqlGetAccount = WebUtil.SQLFormat(SqlGetAccount, Member_ID, COOP_FIID);
LogMessage.WriteLog("DeptAccount SQL", SqlGetAccount);
Sdt dt = ta.Query(SqlGetAccount);
int RowCount = dt.GetRowCount();
if (RowCount != 1)
{
LedgerBal = 0;
AvailableBal = 0;
Dept_Hold = 1;
LogMessage.WriteLog("", "พบจำนวนบัญชีเงินฝากของเลขที่สมาชิก " + Member_ID + " ที่ผูกกับ ATM [" + RowCount + " Row]");
return;
}
else if (dt.Next())
{
DEPTACCOUNT_NO = dt.GetString("DEPTACCOUNT_NO");
RECEIVE_AMT = dt.GetDecimal("RECEIVE_AMT");
PAY_AMT = dt.GetDecimal("PAY_AMT");
SEQUEST_AMT = dt.GetDecimal("SEQUEST_AMT");
ACCOUNT_HOLD = dt.GetDecimal("ACCOUNT_HOLD");
LogMessage.WriteLog("", "DEPTACCOUNT_NO = " + DEPTACCOUNT_NO + " , RECEIVE_AMT = " + RECEIVE_AMT.ToString("#,##0.00") + " , PAY_AMT = " + PAY_AMT.ToString("#,##0.00") + " , SEQUEST_AMT = " + SEQUEST_AMT.ToString("#,##0.00") + " , ACCOUNT_HOLD = " + ACCOUNT_HOLD);
}
String SqlString = "SELECT NVL(DP.PRNCBAL,0) AS LEDGER_AMT, (NVL(DP.PRNCBAL,0) - NVL(DP.SEQUEST_AMOUNT,0) - NVL(DP.CHECKPEND_AMT,0) - NVL(AC.DEPTSEQUEST_AMT,0)) AS AVAILABLE_AMT, AC.DEPT_HOLD AS DEPT_HOLD FROM DPDEPTMASTER DP, ATMCOOP AC WHERE DP.DEPTCLOSE_STATUS = 0 AND TRIM(AC.COOP_ID) = {0} AND MEMBER_NO = {1} AND DP.DEPTACCOUNT_NO = {2}";
SqlString = WebUtil.SQLFormat(SqlString, COOP_FIID, Member_ID, DEPTACCOUNT_NO);
LogMessage.WriteLog("DeptInquiry SQL", SqlString);
dt = ta.Query(SqlString);
RowCount = dt.GetRowCount();
if (RowCount != 1)
{
LedgerBal = 0;
AvailableBal = 0;
Dept_Hold = 1;
LogMessage.WriteLog("", "พบจำนวนบัญชีเงินฝากของเลขที่สมาชิก " + Member_ID + " ที่ผูกกับ ATM [" + RowCount + " Row]");
return;
}
else if (dt.Next())
{
LedgerBal = dt.GetDecimal("LEDGER_AMT");
AvailableBal = dt.GetDecimal("AVAILABLE_AMT") - SEQUEST_AMT;
Dept_Hold = dt.GetDecimal("DEPT_HOLD");
LogMessage.WriteLog("", "LEDGER_AMT = " + LedgerBal.ToString("#,##0.00") + " , AVAILABLE_AMT = " + AvailableBal.ToString("#,##0.00") + " , DEPT_HOLD = " + Dept_Hold);
LedgerBal = LedgerBal - RECEIVE_AMT + PAY_AMT;
AvailableBal = AvailableBal - RECEIVE_AMT + PAY_AMT;
}
LogMessage.WriteLog("", "LedgerBalance = " + LedgerBal.ToString("#,##0.00"));
LogMessage.WriteLog("", "AvailableBalance = " + AvailableBal.ToString("#,##0.00"));
if (AvailableBal < 0)
{
AvailableBal = 0;
LogMessage.WriteLog("", "[ChangBalance] AvailableBalance = " + AvailableBal.ToString("#,##0.00"));
}
}
catch (Exception ex)
{
throw ex;
}
}
public override string ToStringFile()
{
string s = ",";
return(ID.PadRight(10, ' ') + s + HoTen.PadRight(22, ' ') + s + GioiTinh.PadRight(11, ' ') + s + NgayThangNamSinh.ToString("dd/MM/yyyy").PadRight(13, ' ') + s + Sdt.ToString().PadRight(12, ' ') + s + Email.PadRight(20, ' ') + s + ViTri.PadRight(10) +
s + LuongCoBan.ToString().PadRight(14, ' ') + s + HoaHong.ToString().PadRight(12, ' ') + s + Luong);
}
