One time runnable job for production with deployable package
Class NGUpdateFixedAsNoRunnableJob
{
/// <summary>
/// Class entry point. The system will call this method when a designated menu
/// is selected or when execution starts and this class is set as the startup class.
/// --> Update the fixed asset number in US30 & Uk30 <--
/// </summary>
/// <param name = "_args">The specified arguments.</param>
public static void main(Args _args)
{
ProjTable projTable;
Container con =["US30","UK30"];
while select projTable //crosscompany:con
where (projTable.ProjId == 'C004436-01')
|| (projTable.ProjId == 'PJUS000245_01') || (projTable.ProjId == 'PJUS000245_02')
|| (projTable.ProjId == 'PJUS000245_03') || (projTable.ProjId == 'PJUS000245_04')
|| (projTable.ProjId == 'C002907-01')
{
ttsbegin;
projTable.selectForUpdate(true);
if(projTable.ProjId == 'C004436-01')
{
projTable.AssetId = "FA00004277";
}
if(projTable.ProjId == 'PJUS000245_01')
{
projTable.AssetId = "FA00004473";
}
if(projTable.ProjId == 'PJUS000245_02')
{
projTable.AssetId = "FA00004474";
}
if(projTable.ProjId == 'PJUS000245_03')
{
projTable.AssetId = "FA00004475";
}
if(projTable.ProjId == 'PJUS000245_04')
{
projTable.AssetId = "FA00004476";
}
if(projTable.ProjId == 'C002907-01')
{
projTable.AssetId = "FA00001805";
}
projTable.update();
ttscommit;
Info(strFmt("Updated Fixed asset on Project %1 to %2", projTable.ProjId, projTable.AssetId));
}
}
}
Comments
Post a Comment