Method Directive > InsProcessing > GetRows > Post Processing
Custom Code
‘’‘try
{
var dbRMARcpt = Db.RMARcpt.Where(g => g.Company == Session.CompanyID && g.RequestMove);
var dbNonConf = Db.NonConf.Where(g => g.Company == Session.CompanyID && g.RequestMove && g.InspectionPending);
foreach(var row in result.InspProcList)
{
if(row.PONum > 0 && row.ReceiptDate.HasValue)
{
row.AQMNCMNum = Convert.ToDateTime(row.ReceiptDate).ToString(“yyyy-MM-dd”);
}
else if(row.NonConfTranID > 0)
{
var nonConfRow = dbNonConf.Where(g => g.TranID == row.NonConfTranID).FirstOrDefault();
if(nonConfRow != null)
{
if(!string.IsNullOrEmpty(nonConfRow.SysDate.ToString()))
row.AQMNCMNum = Convert.ToDateTime(nonConfRow.SysDate).ToString(“yyyy-MM-dd”);
}
}
else if(row.RMANum > 0)
{
var rmaRow = dbRMARcpt.Where(g => g.RMANum == row.RMANum && g.RMALine == row.RMALine).FirstOrDefault();
if(rmaRow != null)
{
if(!string.IsNullOrEmpty(rmaRow.RcvDate.ToString()))
row.AQMNCMNum = Convert.ToDateTime(rmaRow.RcvDate).ToString(“yyyy-MM-dd”);
}
}
else
row.AQMNCMNum = “”;
}
}
catch(Exception e)
{
}’‘’