public static void CreateAndFillMaterialsNeedsTable(MaterialsNeedsRow[] data)
{
CreateMaterialsNeedsTable();
FillMaterialsNeedsTable(data);
}
public static DatabaseLib.ParametersCollection[] ConvertMaterialsNeedsRowToParameters(MaterialsNeedsRow[] rows)
{
DatabaseLib.ParametersCollection[] par = new DatabaseLib.ParametersCollection[rows.Length];
for (int i = 0; i < rows.Length; i++)
{
par[i] = new DatabaseLib.ParametersCollection();
par[i].Add("ProductCode", rows[i].ProductCode, DbType.UInt64);
par[i].Add("MaterialCode", rows[i].MaterialCode, DbType.UInt64);
par[i].Add("PlanCount", rows[i].PlanCount, DbType.Single);
par[i].Add("Month", rows[i].Month, DbType.UInt32);
par[i].Add("Year", rows[i].Year, DbType.UInt32);
}
return par;
}
public static void FillMaterialsNeedsTable(MaterialsNeedsRow[] data)
{
DatabaseLib.ParametersCollection[] pars = Converter.ConvertMaterialsNeedsRowToParameters(data);
dbf.InsertMany("MaterialsNeeds", pars);
}
