} // get_Trx
public void AddLog(int id, DateTime?date, Decimal?number, String msg)
{
if (_pi != null)
{
_pi.AddLog(id, date, number, msg);
}
log.Info(id + " - " + date + " - " + number + " - " + msg);
} // addLog
} // setParameterFromDB
public static void SetLogFromDB(ProcessInfo pi)
{
String sql = "SELECT Log_ID, P_ID, P_Date, P_Number, P_Msg "
+ "FROM AD_PInstance_Log "
+ "WHERE AD_PInstance_ID=@instanceid "
+ "ORDER BY Log_ID";
IDataReader dr = null;
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@instanceid", pi.GetAD_PInstance_ID());
dr = DataBase.DB.ExecuteReader(sql, param);
int?ival;
while (dr.Read())
{
if (dr[1].ToString() == "")
{
ival = null;
}
else
{
ival = (int?)Utility.Util.GetValueOfInt(dr[1]);
}
pi.AddLog(Utility.Util.GetValueOfInt(dr[0]), ival, Utility.Util.GetValueOfDateTime(dr[2]), Utility.Util.GetValueOfDecimal(dr[3]), dr[4].ToString());
}
dr.Close();
}
catch (Exception e)
{
if (dr != null)
{
dr.Close();
}
_log.Log(Level.SEVERE, "setLogFromDB", e);
}
}
