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
}
