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