public void Join(ChainRec row) { if (SourceMethod != row.SourceMethod) SourceMethod.State = ValueStates.Various; if (SourceWh != row.SourceWh) SourceWh.State = ValueStates.Various; if (SourceMethodNew != row.SourceMethodNew) SourceMethodNew.State = ValueStates.Various; if (SourceWhNew != row.SourceWhNew) SourceWhNew.State = ValueStates.Various; if (Supplier != row.Supplier) Supplier.State = ValueStates.Various; if (SupplierDesc.Equals(row.SupplierDesc) == false) SupplierDesc.State = ValueStates.Various; if (SupplierNew != row.SupplierNew) SupplierNew.State = ValueStates.Various; if (SupplierDescNew.Equals(row.SupplierDescNew) == false) SupplierDescNew.State = ValueStates.Various; if (Status != row.Status) Status.State = ValueStates.Various; if (StatusNew != row.StatusNew) StatusNew.State = ValueStates.Various; if (Action != row.Action) Action.State = ValueStates.Various; }
public Chain LogisticChainGet(string item, int loc, int wh) { var chain = new Chain { Item = item, Loc = loc, Wh = wh }; AssortmentProcedure.LogisticChainGet.Parameters["i_item"].Value = item; AssortmentProcedure.LogisticChainGet.Parameters["i_loc"].Value = loc; AssortmentProcedure.LogisticChainGet.Parameters["i_wh"].Value = wh; var parameters = CallProcedure(AssortmentProcedure.LogisticChainGet); var chains = parameters["o_recordset"] as List<Dictionary<string, object>>; for (var i = 0; i < chains.Count; i++) { var rec = new ChainRec { Id = 1, Seq = chain.Nodes.Count + 1, Item = item, Loc = Convert.ToInt32(chains[i]["LOC"].ToString()), SourceMethod = new ChainValue { State = ValueStates.Valid, Value = (chains[i][ "DIM_ITEMLOC_SOURCEMETHOD"] != DBNull.Value ? chains[i][ "DIM_ITEMLOC_SOURCEMETHOD"] : null) }, SourceWh = new ChainValue { State = ValueStates.Valid, Value = (chains[i]["DIM_ITEMLOC_SOURCEWH"] != DBNull.Value ? chains[i][ "DIM_ITEMLOC_SOURCEWH"] : null) }, SourceMethodNew = new ChainValue { State = (chains[i][ "DIM_ITEMLOC_SOURCEMETHOD_NEW"] != DBNull.Value ? ValueStates.Valid : ValueStates.NotValid), Value = (chains[i][ "DIM_ITEMLOC_SOURCEMETHOD_NEW"] != DBNull.Value ? chains[i][ "DIM_ITEMLOC_SOURCEMETHOD_NEW"] : null) }, SourceWhNew = new ChainValue { State = (chains[i][ "DIM_ITEMLOC_SOURCEWH_NEW"] != DBNull.Value || (chains[i][ "DIM_ITEMLOC_SOURCEMETHOD_NEW"] != DBNull.Value && Convert.ToChar( chains[i][ "DIM_ITEMLOC_SOURCEMETHOD_NEW"].ToString()) == (char)SourceMethods.S) ? ValueStates.Valid : ValueStates.NotValid), Value = (chains[i][ "DIM_ITEMLOC_SOURCEWH_NEW"] != DBNull.Value ? chains[i][ "DIM_ITEMLOC_SOURCEWH_NEW"] : null) }, Supplier = new ChainValue { State = ValueStates.Valid, Value = (chains[i]["DIM_ITEMLOC_SUPPLIER"] != DBNull.Value ? chains[i][ "DIM_ITEMLOC_SUPPLIER"] : null) }, SupplierDesc = new ChainValue { State = ValueStates.Valid, Value = (chains[i][ "DIM_ITEMLOC_SUPPLIER_DESC"] != DBNull.Value ? chains[i][ "DIM_ITEMLOC_SUPPLIER_DESC"] : null) }, SupplierNew = new ChainValue { State = (chains[i][ "DIM_ITEMLOC_SUPPLIER_NEW"] != DBNull.Value ? ValueStates.Valid : ValueStates.NotValid), Value = (chains[i][ "DIM_ITEMLOC_SUPPLIER_NEW"] != DBNull.Value ? chains[i][ "DIM_ITEMLOC_SUPPLIER_NEW"] : null) }, SupplierDescNew = new ChainValue { State = (chains[i][ "DIM_ITEMLOC_SUPPLIER_DESC_NEW"] != DBNull.Value ? ValueStates.Valid : ValueStates.NotValid), Value = (chains[i][ "DIM_ITEMLOC_SUPPLIER_DESC_NEW"] != DBNull.Value ? chains[i][ "DIM_ITEMLOC_SUPPLIER_DESC_NEW"] : null) }, Status = new ChainValue { State = ValueStates.Valid, Value = chains[i]["MEASURE_STATUS"] }, StatusNew = new ChainValue { //State = (Actions)Convert.ToInt32(dr["ACTION"]) != Actions.NoAction ? ValueState.Valid : ValueState.NotValid, State = ValueStates.Valid, Value = chains[i]["MEASURE_STATUS_NEW"] }, Action = new ChainValue { State = (Actions) Convert.ToInt32(chains[i]["ACTION"]) != Actions.NoAction ? ValueStates.Valid : ValueStates.NotValid, Value = (Actions) Convert.ToInt32(chains[i]["ACTION"]) } }; chain.Nodes.Add(rec); } return chain; }
public ChainRec LogisticChainGetRec(string item, int loc) { var rec = new ChainRec(); AssortmentProcedure.LogisticChainGetRec.Parameters["i_item"].Value = item; AssortmentProcedure.LogisticChainGetRec.Parameters["i_loc"].Value = loc; var parameters = CallProcedure(AssortmentProcedure.LogisticChainGetRec); var recs = parameters["o_recordset"] as List<Dictionary<string, object>>; if (recs == null) throw new ArgumentNullException("recs"); foreach (var t in recs) { rec.Id = 1; rec.Seq = 1; rec.Item = item; rec.Loc = Convert.ToInt32(t["LOC"].ToString()); rec.SourceMethod = new ChainValue { State = ValueStates.Valid, Value = (t["DIM_ITEMLOC_SOURCEMETHOD"] != DBNull.Value ? t["DIM_ITEMLOC_SOURCEMETHOD"] : null) }; rec.SourceWh = new ChainValue { State = ValueStates.Valid, Value = (t["DIM_ITEMLOC_SOURCEWH"] != DBNull.Value ? t["DIM_ITEMLOC_SOURCEWH"] : null) }; rec.SourceMethodNew = new ChainValue { State = (t["DIM_ITEMLOC_SOURCEMETHOD_NEW"] != DBNull.Value ? ValueStates.Valid : ValueStates.NotValid), Value = (t["DIM_ITEMLOC_SOURCEMETHOD_NEW"] != DBNull.Value ? t["DIM_ITEMLOC_SOURCEMETHOD_NEW"] : null) }; rec.SourceWhNew = new ChainValue { State = (t["DIM_ITEMLOC_SOURCEWH_NEW"] != DBNull.Value || (t["DIM_ITEMLOC_SOURCEMETHOD_NEW"] != DBNull.Value && Convert.ToChar(t["DIM_ITEMLOC_SOURCEMETHOD_NEW"]) == (char)SourceMethods.S) ? ValueStates.Valid : ValueStates.NotValid), Value = (t["DIM_ITEMLOC_SOURCEWH_NEW"] != DBNull.Value ? t["DIM_ITEMLOC_SOURCEWH_NEW"] : null) }; rec.Supplier = new ChainValue { State = ValueStates.Valid, Value = (t["DIM_ITEMLOC_SUPPLIER"] != DBNull.Value ? t["DIM_ITEMLOC_SUPPLIER"] : null) }; rec.SupplierDesc = new ChainValue { State = ValueStates.Valid, Value = (t["DIM_ITEMLOC_SUPPLIER_DESC"] != DBNull.Value ? t["DIM_ITEMLOC_SUPPLIER_DESC"] : null) }; rec.SupplierNew = new ChainValue { State = (t["DIM_ITEMLOC_SUPPLIER_NEW"] != DBNull.Value ? ValueStates.Valid : ValueStates.NotValid), Value = (t["DIM_ITEMLOC_SUPPLIER_NEW"] != DBNull.Value ? t["DIM_ITEMLOC_SUPPLIER_NEW"] : null) }; rec.SupplierDescNew = new ChainValue { State = (t["DIM_ITEMLOC_SUPPLIER_DESC_NEW"] != DBNull.Value ? ValueStates.Valid : ValueStates.NotValid), Value = (t["DIM_ITEMLOC_SUPPLIER_DESC_NEW"] != DBNull.Value ? t["DIM_ITEMLOC_SUPPLIER_DESC_NEW"] : null) }; rec.Status = new ChainValue { State = ValueStates.Valid, Value = t["MEASURE_STATUS"] }; rec.StatusNew = new ChainValue { State = ValueStates.Valid, Value = t["MEASURE_STATUS_NEW"] }; rec.Action = new ChainValue { State = (Actions)Convert.ToInt32(t["ACTION"]) != Actions.NoAction ? ValueStates.Valid : ValueStates.NotValid, Value = (Actions)Convert.ToInt32(t["ACTION"]) }; } return rec; }
public static void Group(List<Chain> chainGroup) { for (int i = 0; i < chainGroup.Count; i++) { for (int j = i + 1; j < chainGroup.Count; j++) { if (chainGroup[i] != null || chainGroup[j] != null) { if (chainGroup[i].Equals(chainGroup[j])) { chainGroup[i].Join(chainGroup[j]); chainGroup.Remove(chainGroup[j]); j--; } } } } if (GroupIsEmpty(chainGroup)) { var chain = new ChainRec(); chain.Default(chainGroup[0].Item, chainGroup[0].Wh); chainGroup[0].Nodes = new List<ChainRec> { chain }; } for (int i = 0; i < chainGroup.Count; i++) { for (int j = 0; j < chainGroup[i].Nodes.Count; j++) { chainGroup[i].Nodes[j].Id = i + 1; } } }
public WindowWhRowEdit(Object dbobject, ChainRec row) { InitializeComponent(); _db = (DBManager)dbobject; _row = row; try { _db.FillDataTableCustom(Table.TableSupplier.Name, Table.TableSupplier.SelectClause, Table.TableSupplier.KeyFields, false); } catch (AssortmentException ex) { MessageBox.Show(Table.TableSupplier + ": " + ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error); return; } /* if (_db.FillDataTableCustom(Table.TableSupplier.Name, Table.TableSupplier.SelectClause, Table.TableSupplier.KeyFields, false) == false) { MessageBox.Show("Ошибка при формировании источника: "+_db.Error,"Ошибка",MessageBoxButton.OK,MessageBoxImage.Error); } */ #region Initialize Events sourceMethodNew.SelectionChanged += SourceMethodNewSelectionChanged; cancel.Click += CancelClick; supplierNewSelect.Click += SupplierNewSelectClick; border1.MouseEnter += BorderMouseEnter; border1.MouseLeave += BorderMouseLeave; border2.MouseEnter += BorderMouseEnter; border2.MouseLeave += BorderMouseLeave; border3.MouseEnter += BorderMouseEnter; border3.MouseLeave += BorderMouseLeave; #endregion #region Initialize Controls sourceMethodNew.Items.Add((char)SourceMethods.S); sourceMethodNew.Items.Add((char)SourceMethods.W); for (var i = 0; i < _db.UserWhList.Count; i++) { sourceWhNew.Items.Add(_db.UserWhList[i]); } //sourceWhNew.Items.Add(44); //sourceWhNew.Items.Add(121); //sourceWhNew.Items.Add(174); //sourceMethod.Text = row.SourceMethod.ToString(); //sourceWh.Text = row.SourceWh.ToString(); //sourceMethodNew.SelectedItem = row.SourceMethodNew; //sourceWhNew.SelectedItem = row.SourceWhNew; //supplier.Text = row.Supplier.ToString(); //supplierDesc.Text = row.SupplierDesc; //supplierNew.Text = row.SupplierNew.ToString(); //supplierDescNew.Text = row.SupplierDescNew; //status.Text = row.Status.ToString(); //statusNew.Text = row.StatusNew.ToString(); #endregion }