namespace namespace
{
[IDOExtensionClass("ue_IdoName")]
public class PurchasingFlowdowns : ExtensionClassBase
{
public override void SetContext(IIDOExtensionClassContext context)
{
base.SetContext(context);
}
[IDOMethod(MethodFlags.CustomLoad,"infobar")]
public DataTable IDO_PreloadCollection(string material)
{
//create datatable
DataTable dt = new DataTable();
dt.Columns.Add("cust_po");
dt.Columns.Add("LineItem");
dt.Columns.Add("LineDueDate");
dt.Columns.Add("CustomerName");
dt.Columns.Add("CNum");
dt.Columns.Add("co_num");
dt.Columns.Add("PAS");
dt.Columns.Add("material");
// Load the datatable with the data from the IDO
try
{
DataRow row;
string filter = $"material = {material}";
var flowDown = this.Context.Commands.LoadCollection(
"ue_IdoName"
, "cust_po,LineItem,LineDueDate,CustomerName,CNum,co_num,PAS,material"
, $"{filter}"
, ""
, 0);
for (int index = 0; index < flowDown.Items.Count; index++)
{
row = dt.NewRow();
row["cust_po"] = flowDown[index, "cust_po"].Value;
row["LineItem"] = flowDown[index, "LineItem"].Value;
row["LineDueDate"] = flowDown[index, "LineDueDate"].Value;
row["CustomerName"] = flowDown[index, "CustomerName"].Value;
row["CNum"] = flowDown[index, "CNum"].Value;
row["co_num"] = flowDown[index, "co_num"].Value;
row["PAS"] = flowDown[index, "PAS"].Value;
row["material"] = flowDown[index, "material"].Value;
dt.Rows.Add(row);
}
}
catch (Exception ex)
{
string Infobar = ex.Message;
}
return dt;
}
}
}