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); }