private void createAisle(Product product, LoadCarrierType lct, double sourceQty, double targetQty)
{
QtyExchange qtyExchange = View.ObjectSpace.CreateObject <QtyExchange>();
qtyExchange.Product = product;
qtyExchange.LcType = lct;
qtyExchange.SourceQty = sourceQty;
qtyExchange.TargetUnit = unitType;
qtyExchange.TargetQty = targetQty;
qtyExchange.In = true;
qtyExchange.Out = false;
}
private void LogX_TarhelyGeneralas_Execute(object sender, SimpleActionExecuteEventArgs e)
{
numberOfAisle = 2;
numberOfColumn = 50;
numberOFRow = 10;
abcType = View.ObjectSpace.FindObject <AbcType>(new BinaryOperator("Code", "A"));
LcT = View.ObjectSpace.FindObject <LoadCarrierType>(new BinaryOperator("Name", "MAGAS"));
for (int i = 0; i < numberOfAisle; i++)
{
CriteriaOperator criteria = CriteriaOperator.Parse("Oid = ?", i + 1);
Aisle aisle = View.ObjectSpace.FindObject <Aisle>(criteria);
for (int j = 0; j < numberOfLine; j++)
{
tomb++;
for (int k = 0; k < numberOfColumn; k++)
{
for (int l = 0; l < numberOFRow; l++)
{
//Láda létrehozása
loadCarriers = View.ObjectSpace.CreateObject <LoadCarrier>();
barCode++;
loadCarriers.BarCode = barCode;
loadCarriers.RFID1 = Convert.ToString(1000 + barCode);
loadCarriers.RFID2 = Convert.ToString(2000 + barCode);
loadCarriers.LcType = LcT;
//Tárolóhely létrehozása
storageLocation = View.ObjectSpace.CreateObject <StorageLocation>();
storageLocation.Aisle = aisle;
storageLocation.Block = tomb;
storageLocation.Column = Convert.ToUInt16(k + 1);
storageLocation.Row = Convert.ToByte(l + 1);
storageLocation.Name = storageLocation.Aisle.Name + "_" + storageLocation.Block + "_" + storageLocation.Column + "_" + storageLocation.Row;
storageLocation.AbcClass = abcType;;
storageLocation.LHU1X = 10;
storageLocation.LHU1Y = 10;
storageLocation.LHU2X = 10;
storageLocation.LHU2Y = 10;
storageLocation.LoadCarrier = loadCarriers;
storageLocation.LcIsEmpty = true;
}
}
}
}
//View.ObjectSpace.CommitChanges();
MessageBox.Show("Finished!" + ciklus.ToString());
}
private void createQexchange(Product product, LoadCarrierType lct, double sourceQty, double targetQty, bool io, bool def, UInt32 width, UInt32 length, UInt32 height, double weight)
{
QtyExchange qtyExchange = View.ObjectSpace.CreateObject <QtyExchange>();
qtyExchange.Product = product;
qtyExchange.LcType = lct;
qtyExchange.SourceQty = sourceQty;
qtyExchange.TargetUnit = unitType;
qtyExchange.TargetQty = targetQty;
qtyExchange.In = io;
qtyExchange.Out = !io;
qtyExchange.Default = def;
qtyExchange.PackageWidth = width;
qtyExchange.PackageLength = length;
qtyExchange.PackageHeight = height;
qtyExchange.PackageWeight = weight;
}
private void Import_LoadCarrier()
{
int rekord = 0;
using (var fileStream = new FileStream(@"C:\Users\Halász Alexandra\OneDrive\LogX\halaszalexandra\LOGX\Imports\LogX_LoadCarrier.csv", FileMode.Open, FileAccess.Read))
{
StreamReader reader = new StreamReader(fileStream);
while (!reader.EndOfStream)
{
string line = reader.ReadLine();
var values = line.Split(';');
if (rekord > 0)
{
CriteriaOperator criteriaLctType = new BinaryOperator("Types", values[1]);
LoadCarrierType lct = (LoadCarrierType)View.ObjectSpace.FindObject(typeof(LoadCarrierType), criteriaLctType, true);
if (values[0] != "")
{
LoadCarrier lc = View.ObjectSpace.CreateObject <LoadCarrier>();
lc.BarCode = Convert.ToDecimal(values[0]);
lc.LcType = lct;
lc.RFID1 = Convert.ToString(values[2]);
lc.RFID2 = Convert.ToString(values[3]);
lc.StatusCode = 0;
lc.isEmpty = true;
lc.Save();
}
}
rekord++;
}
View.ObjectSpace.CommitChanges();
}
}
private void Import_LoadCarrier_Type()
{
int rekord = 0;
using (var fileStream = new FileStream(@"C:\Projects\LogXExplorer\Imports\LogX_LoadCarrierType.csv", FileMode.Open, FileAccess.Read))
{
StreamReader reader = new StreamReader(fileStream);
while (!reader.EndOfStream)
{
string line = reader.ReadLine();
var values = line.Split(';');
if (rekord > 0)
{
CriteriaOperator criteria = CriteriaOperator.Parse("Name=?", values[0]);
LoadCarrierType existedLct = (LoadCarrierType)View.ObjectSpace.FindObject(typeof(LoadCarrierType), criteria, true);
if (existedLct == null)
{
LoadCarrierType lct = View.ObjectSpace.CreateObject <LoadCarrierType>();
lct.Name = values[0];
lct.Types = values[0];
lct.Length = Convert.ToInt32(values[2]);
lct.Width = Convert.ToInt32(values[3]);
lct.Height = Convert.ToInt32(values[4]);
lct.Weight = Convert.ToInt32(values[5]);
lct.Save();
}
}
rekord++;
}
View.ObjectSpace.CommitChanges();
}
}
/// <summary>
/// Initializes a new instance of the <see cref="LoadCarrierData" /> class.
/// </summary>
/// <param name="carrierType">
/// The carrier Type.
/// </param>
/// <param name="data">
/// The data.
/// </param>
public LoadCarrierData(LoadCarrierType carrierType, BaseCarrierData data)
{
CarrierType = carrierType;
Data = data;
}
private void Import_Product()
{
int rekord = 0;
//ProgressBarControl progressBarControl1 = new ProgressBarControl();
//Session prSession = new Session();
using (var fileStream = new FileStream(@"C:\Projects\LogXExplorer\Imports\LogX_Product.csv", FileMode.Open, FileAccess.Read))
{
StreamReader reader = new StreamReader(fileStream);
abcType = View.ObjectSpace.FindObject <AbcType>(new BinaryOperator("Code", "A"));
while (!reader.EndOfStream)
{
string line = reader.ReadLine();
var values = line.Split(';');
if (rekord > 0)
{
CriteriaOperator criteria = CriteriaOperator.Parse("Identifier=?", values[0]);
Product existedProduct = (Product)View.ObjectSpace.FindObject(typeof(Product), criteria, true);
unitType = View.ObjectSpace.FindObject <UnitType>(new BinaryOperator("Name", "Doboz"));
if (values[1] != "" && (existedProduct == null || values[0] == ""))
{
UInt32 seged = GetparsedValue(values[2]);
Product product = View.ObjectSpace.CreateObject <Product>();
product.Identifier = values[0];
product.Name = values[1];
product.Weight = Convert.ToInt32(seged);
product.AbcClass = abcType;
Aisle aisle = View.ObjectSpace.FindObject <Aisle>(new BinaryOperator("Name", values[12]));
product.DefaultAisle = aisle;
//product.Aisles.Add(aisle);
ProductGroup productGroup = View.ObjectSpace.FindObject <ProductGroup>(new BinaryOperator("Name", values[26]));
product.ProductGroup = productGroup;
product.Save();
lctIn = View.ObjectSpace.FindObject <LoadCarrierType>(new BinaryOperator("Name", values[8]));
lctOut = View.ObjectSpace.FindObject <LoadCarrierType>(new BinaryOperator("Name", values[10]));
//ObjectSpace.CommitChanges();
w = GetparsedValue(values[5]);
l = GetparsedValue(values[4]);
h = GetparsedValue(values[6]);
we = GetparsedValue(values[14]);
// Betárolási láda QuexChange
if (lctIn != null)
{
UInt32 seged1 = GetparsedValue(values[9]);
createQexchange(product, lctIn, 1, Convert.ToDouble(seged1), true, true, w, l, h, we);
}
// Kitárolási láda QuexChange
if (lctOut == null)
{
UInt32 seged2 = GetparsedValue(values[11]);
createQexchange(product, lctOut, 1, Convert.ToDouble(seged2), false, true, w, l, h, we);
}
}
}
rekord++;
}
SplashScreenManager.Default.SendCommand(Splash.SplashScreenCommand.SetProgress, 90);
View.ObjectSpace.CommitChanges();
}
}
