/// <summary>
/// Get AcctSchema Defaults
/// </summary>
/// <returns>defaults</returns>
public MAcctSchemaDefault GetAcctSchemaDefault()
{
if (_default == null)
{
_default = MAcctSchemaDefault.Get(GetCtx(), GetC_AcctSchema_ID());
}
if (_default == null)
{
throw new Exception("No Default Definition for C_AcctSchema_ID=" + GetC_AcctSchema_ID());
}
return(_default);
}
/// <summary>
/// Get Accounting Schema Default Info
/// </summary>
/// <param name="ctx">context</param>
/// <param name="C_AcctSchema_ID">id</param>
/// <returns>defaults</returns>
public static MAcctSchemaDefault Get(Ctx ctx, int C_AcctSchema_ID)
{
MAcctSchemaDefault retValue = null;
String sql = "SELECT * FROM C_AcctSchema_Default WHERE C_AcctSchema_ID=@Param1";
SqlParameter[] Param = new SqlParameter[1];
IDataReader idr = null;
DataTable dt = null;
//PreparedStatement pstmt = null;
try
{
Param[0] = new SqlParameter("@Param1", C_AcctSchema_ID);
//pstmt = DataBase.prepareStatement(sql, null);
//pstmt.setInt(1, C_AcctSchema_ID);
//ResultSet rs = pstmt.executeQuery();
idr = DataBase.DB.ExecuteReader(sql, Param, null);
dt = new DataTable();
dt.Load(idr);
idr.Close();
foreach (DataRow dr in dt.Rows)
{
retValue = new MAcctSchemaDefault(ctx, dr, null);
}
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
_log.Log(Level.SEVERE, sql, e);
}
finally
{
if (idr != null)
{
idr.Close();
}
dt = null;
}
return(retValue);
} // get
/// <summary>
/// Get Currency Account for Currency
/// </summary>
/// <param name="a"> accounting schema default</param>
/// <param name="C_Currency_ID">currency</param>
/// <returns>Currency Account or null</returns>
public static MCurrencyAcct Get(MAcctSchemaDefault a, int C_Currency_ID)
{
MCurrencyAcct retValue = null;
String sql = "SELECT * FROM C_Currency_Acct "
+ "WHERE C_AcctSchema_ID=@Param1 AND C_Currency_ID=@Param2";
SqlParameter[] Param = new SqlParameter[2];
IDataReader idr = null;
DataTable dt = null;
//PreparedStatement pstmt = null;
try
{
Param[0] = new SqlParameter("@Param1", a.GetC_AcctSchema_ID());
//pstmt = DataBase.prepareStatement(sql, null);
//pstmt.setInt(1, as.getC_AcctSchema_ID());
//pstmt.setInt(2, C_Currency_ID);
Param[1] = new SqlParameter("@Param1", a.GetC_AcctSchema_ID());
//ResultSet rs = pstmt.executeQuery();
idr = DataBase.DB.ExecuteReader(sql, Param, null);
dt = new DataTable();
dt.Load(idr);
idr.Close();
foreach (DataRow dr in dt.Rows)
{
retValue = new MCurrencyAcct(a.GetCtx(), dr, null);
}
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
_log.Log(Level.SEVERE, "get", e);
}
finally
{
dt = null;
}
return(retValue);
} // get
