public static DatabaseLib.ParametersCollection[] ConverеProductMaterialStandartsRowToParameters(DataTable dt)
{
DatabaseLib.ParametersCollection[] par = new DatabaseLib.ParametersCollection[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
par[i] = new DatabaseLib.ParametersCollection();
par[i].Add("ProductCode", dt.Rows[i].ItemArray[0], DbType.UInt64);
par[i].Add("MaterialCode", dt.Rows[i].ItemArray[1], DbType.UInt64);
par[i].Add("Consumption", dt.Rows[i].ItemArray[2], DbType.Single);
par[i].Add("Wastes", dt.Rows[i].ItemArray[3], DbType.Single);
}
return par;
}
public static DatabaseLib.ParametersCollection ConvertUnitRowToParameters(UnitRow row)
{
DatabaseLib.ParametersCollection par = new DatabaseLib.ParametersCollection();
par.Add("FullName", row.FullName, DbType.String);
par.Add("SmallName", row.SmallName, DbType.String);
return par;
}
public static DatabaseLib.ParametersCollection ConverеProductMaterialStandartsRowToParameters(ProductMaterialStandartsRow row)
{
DatabaseLib.ParametersCollection par = new DatabaseLib.ParametersCollection();
par.Add("ProductCode", row.ProductCode, DbType.UInt64);
par.Add("MaterialCode", row.MaterialCode, DbType.UInt64);
par.Add("Consumption", row.Comsumption, DbType.Single);
par.Add("Wastes", row.Waste, DbType.Single);
return par;
}
public static DatabaseLib.ParametersCollection ConvertStandartRowToParameters(StandartRow row)
{
DatabaseLib.ParametersCollection par = new DatabaseLib.ParametersCollection();
par.Add("ProductCode", row.ProductCode, DbType.UInt64);
par.Add("MaterialCode", row.MaterialCode, DbType.UInt64);
par.Add("ConsumptionRate", row.ConsumptionRate, DbType.Single);
par.Add("RateOfWaste", row.RateOfWaste, DbType.Single);
return par;
}
public static DatabaseLib.ParametersCollection ConvertTypeRowToParameters(TypeRow row)
{
DatabaseLib.ParametersCollection par = new DatabaseLib.ParametersCollection();
par.Add("Name", row.Name, DbType.String);
return par;
}
public static DatabaseLib.ParametersCollection ConvertProductNameRowToParameters(ProductNameRow row)
{
DatabaseLib.ParametersCollection par = new DatabaseLib.ParametersCollection();
par.Add("ProductKey", row.Code, DbType.UInt64);
par.Add("Name", row.Name, DbType.String);
par.Add("Designation", row.Designation, DbType.String);
par.Add("ViewCode", row.ProductCode, DbType.Byte);
par.Add("TypeCode", row.TypeCode, DbType.Byte);
par.Add("SignCode", row.SignCode, DbType.Byte);
return par;
}
public static ParametersCollection ConvertShopsReferenceRowToParameter(ShopsReferenceRow shops)
{
ParametersCollection par = new ParametersCollection();
par.Add("ShopCode", shops.ShopCode, DbType.UInt32);
par.Add("Name", shops.Name, DbType.String);
par.Add("ProductionCode", shops.ProductionCode, DbType.UInt32);
return par;
}
public static DatabaseLib.ParametersCollection ConvertPlanProductsRowToParameters(PlanProductsRow row)
{
DatabaseLib.ParametersCollection par = new DatabaseLib.ParametersCollection();
par.Add("ProductCode", row.ProductCode, DbType.UInt64);
par.Add("PlanCount", row.PlanCount, DbType.UInt64);
par.Add("Month", row.Month, DbType.Single);
par.Add("Year", row.Year, DbType.Single);
return par;
}
public static ParametersCollection ConvertProductionReferenceRowToParameter(ProductionReferenceRow prodref)
{
ParametersCollection par = new ParametersCollection();
par.Add("Name", prodref.Name, DbType.String);
return par;
}
public static DatabaseLib.ParametersCollection ConvertMaterialRowToParameters(MaterialsRow row)
{
DatabaseLib.ParametersCollection par = new DatabaseLib.ParametersCollection();
par.Add("MaterialCode", row.Code, DbType.UInt64);
par.Add("Name", row.Designation, DbType.String);
par.Add("UnitType", row.UnitCode, DbType.Byte);
return par;
}
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 ParametersCollection[] ConvertMaterialNeedsDataTableToParameters(DataTable dt)
{
DatabaseLib.ParametersCollection[] par = new DatabaseLib.ParametersCollection[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
par[i] = new DatabaseLib.ParametersCollection();
par[i].Add("ProductCode", dt.Rows[i].ItemArray[0], DbType.UInt64);
par[i].Add("MaterialCode", dt.Rows[i].ItemArray[1], DbType.UInt64);
par[i].Add("PlanCount", dt.Rows[i].ItemArray[2], DbType.Single);
par[i].Add("Month", dt.Rows[i].ItemArray[3], DbType.UInt64);
par[i].Add("Year", dt.Rows[i].ItemArray[4], DbType.UInt32);
}
return par;
}
public static DatabaseLib.ParametersCollection ConvertFullApplicationRowToParameters(FullApplicationRow row)
{
DatabaseLib.ParametersCollection par = new DatabaseLib.ParametersCollection();
par.Add("ProductCode", row.ProductCode, DbType.UInt64);
par.Add("PackageDetails", row.PackageDetails, DbType.UInt64);
par.Add("Count", row.Count, DbType.UInt32);
return par;
}
public static DatabaseLib.ParametersCollection ConvertCompositionRowToParameters(CompositionRow row)
{
DatabaseLib.ParametersCollection par = new DatabaseLib.ParametersCollection();
par.Add("RootCode", row.RootCode, DbType.UInt64);
par.Add("WhereCode", row.WhereCode, DbType.UInt64);
par.Add("WhatCode", row.WhatCode, DbType.UInt64);
par.Add("Count", row.Count, DbType.UInt32);
return par;
}
public static DatabaseLib.ParametersCollection[] ConvertComplexityShopRowToParameters(ComplexityShopRow[] 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("ShopCode", rows[i].ShopCode, DbType.UInt64);
par[i].Add("T0", rows[i].To, DbType.Single);
par[i].Add("Tv", rows[i].Tv, DbType.Single);
par[i].Add("Tpz", rows[i].Tpz, DbType.Single);
par[i].Add("Totl", rows[i].Totl, DbType.Single);
par[i].Add("Tpt", rows[i].Tpt, DbType.Single);
par[i].Add("Tobs", rows[i].Tobs, DbType.Single);
}
return par;
}
public static ParametersCollection[] ConvertComplexityShopDataTableToParameters(DataTable dt)
{
DatabaseLib.ParametersCollection[] par = new DatabaseLib.ParametersCollection[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
par[i] = new DatabaseLib.ParametersCollection();
par[i].Add("ProductCode", dt.Rows[i].ItemArray[0], DbType.UInt64);
par[i].Add("ShopCode", dt.Rows[i].ItemArray[1], DbType.UInt64);
par[i].Add("T0", dt.Rows[i].ItemArray[2], DbType.Single);
par[i].Add("Tv", dt.Rows[i].ItemArray[3], DbType.Single);
par[i].Add("Tpz", dt.Rows[i].ItemArray[4], DbType.Single);
par[i].Add("Totl", dt.Rows[i].ItemArray[5], DbType.Single);
par[i].Add("Tpt", dt.Rows[i].ItemArray[6], DbType.Single);
par[i].Add("Tobs", dt.Rows[i].ItemArray[7], DbType.Single);
}
return par;
}
