public static void CreateAndFillMaterialsNeeds2Table(MaterialsNeeds2Row[] data)
{
CreateMaterialsNeeds2Table();
FillMaterialsNeeds2Table(data);
}
public static DatabaseLib.ParametersCollection[] ConvertMaterialsNeeds2RowToParameters(MaterialsNeeds2Row[] 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("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 FillMaterialsNeeds2Table(MaterialsNeeds2Row[] data)
{
DatabaseLib.ParametersCollection[] pars = Converter.ConvertMaterialsNeeds2RowToParameters(data);
dbf.InsertMany("MaterialsNeeds2", pars);
}