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 ParametersCollection ConvertProductionReferenceRowToParameter(ProductionReferenceRow prodref)
{
ParametersCollection par = new ParametersCollection();
par.Add("Name", prodref.Name, DbType.String);
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 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 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;
}
