public static A2ZTRNVALIDDTO GetShareMinAmt(Int16 AccType) { DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZCSPARAM WHERE AccType = '" + AccType + "'", "A2ZCSMCUS"); var p = new A2ZTRNVALIDDTO(); if (dt.Rows.Count > 0) { p.LogicAmount = Converter.GetDecimal(dt.Rows[0]["PrmMinDeposit"]); p.NoRecord = Converter.GetSmallInteger(1); return(p); } else { p.NoRecord = 0; } return(p); }
public static A2ZTRNVALIDDTO GetLoanDisbursementAmt(Int16 CuType, int CreditNo, int MemberNo, Int16 AccType, int AccountNo) { DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE AccType = '" + AccType + "' and AccNo = '" + AccountNo + "' and CuType='" + CuType + "' and CuNo='" + CreditNo + "' and MemNo='" + MemberNo + "'", "A2ZCSMCUS"); var p = new A2ZTRNVALIDDTO(); if (dt.Rows.Count > 0) { p.LogicAmount = Converter.GetDecimal(dt.Rows[0]["AccLoanAmt"]); p.NoRecord = Converter.GetSmallInteger(1); return(p); } else { p.NoRecord = 0; } return(p); }