private void Import_AbcTypes()
{
int rekord = 0;
using (var fileStream = new FileStream(@"C:\Users\Halász Alexandra\OneDrive\LogX\halaszalexandra\LOGX\Imports\LogX_AbcType.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("Code", values[0]);
AbcType existedAbcType = (AbcType)View.ObjectSpace.FindObject(typeof(AbcType), criteria, true);
if (values[0] != "")
{
AbcType abctype = View.ObjectSpace.CreateObject <AbcType>();
abctype.Code = values[0];
abctype.Name = values[1];
abctype.Save();
}
}
rekord++;
}
View.ObjectSpace.CommitChanges();
}
}
private void LogX_abcKat_Execute(object sender, SimpleActionExecuteEventArgs e)
{
IList <StorageLocation> slList = View.ObjectSpace.GetObjects <StorageLocation>();
aType = View.ObjectSpace.FindObject <AbcType>(new BinaryOperator("Code", "A"));
bType = View.ObjectSpace.FindObject <AbcType>(new BinaryOperator("Code", "B"));
cType = View.ObjectSpace.FindObject <AbcType>(new BinaryOperator("Code", "C"));
foreach (StorageLocation sl in slList)
{
if (sl.Oid > 0 && sl.Oid <= 300 || sl.Oid > 500 && sl.Oid <= 800 || sl.Oid > 1000 && sl.Oid <= 1300 || sl.Oid > 1500 && sl.Oid <= 1800)
{
sl.AbcClass = aType;
}
else if (sl.Oid > 300 && sl.Oid <= 450 || sl.Oid > 800 && sl.Oid <= 950 || sl.Oid > 1300 && sl.Oid <= 1450 || sl.Oid > 1800 && sl.Oid <= 1950)
{
sl.AbcClass = bType;
}
else
{
sl.AbcClass = cType;
}
if (sl.LoadCarrier != null)
{
sl.StatusCode = 1;
}
}
View.ObjectSpace.CommitChanges();
View.ObjectSpace.Refresh();
MessageBox.Show("Finished!");
}
/****************************************************************************************************************************************
* PUBLIC PARTS
*****************************************************************************************************************************************/
#region Abc osztály nevének visszaadása (Teszteléshez)
public string GetAbcClassName(string classCode)
{
string ret = "item not found";
Session session = new Session();
AbcType abc = session.FindObject <AbcType>(new BinaryOperator("Code", classCode));
//if (ret != null)
{
ret = abc.Name;
}
return(ret);
}
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());
}
//#region Státuszok beolvasása / Status
//private void Import_Status()
//{
// var fileContent = string.Empty;
// var filePath = string.Empty;
// int rekord = 0;
// using (var fileStream = new FileStream(@"C:\Projects\LogXExplorer\Imports\LogX_Status.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("Code", values[0]);
// Status existedStatus = (Status)View.ObjectSpace.FindObject(typeof(Status), criteria, true);
// if (values[0] != "")
// {
// Status status = View.ObjectSpace.CreateObject<Status>();
// status.Code = values[0];
// status.Name = values[1];
// status.Save();
// }
// }
// rekord++;
// }
// View.ObjectSpace.CommitChanges();
// }
//}
//#endregion
#region Tárhelyek beolvasása / StorageLocation
private void Import_StorageLocation()
{
int rekord = 0;
using (var fileStream = new FileStream(@"C:\Projects\LogXExplorer\Imports\LogX_StorageLocation.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 criteriaAisle = new BinaryOperator("Name", values[0]);
Aisle aisle = (Aisle)View.ObjectSpace.FindObject(typeof(Aisle), criteriaAisle, true);
if (aisle == null)
{
CreateAisle(values[0]);
}
CriteriaOperator criteriaAbc = new BinaryOperator("Code", values[5]);
AbcType abc = (AbcType)View.ObjectSpace.FindObject(typeof(AbcType), criteriaAbc, true);
if (values[0] != "")
{
StorageLocation storage = View.ObjectSpace.CreateObject <StorageLocation>();
storage.Aisle = aisle;
storage.Block = Convert.ToByte(values[1]);
storage.Column = Convert.ToInt32(values[2]);
storage.Row = Convert.ToByte(values[3]);
storage.Name = values[4];
storage.AbcClass = abc;
storage.LHU1X = Convert.ToInt32(values[6]);
storage.LHU1Y = Convert.ToInt32(values[7]);
storage.LHU2X = Convert.ToInt32(values[8]);
storage.LHU2Y = Convert.ToInt32(values[9]);
storage.Height = Convert.ToInt32(values[10]);
storage.StatusCode = 0;
storage.Save();
}
}
rekord++;
}
View.ObjectSpace.CommitChanges();
}
}
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();
}
}
