private void GetRecDetail()
{
var list = _db.MatRecDet.Where(w => w.RecId == _mr.RecId).Select(s => new MatRecDetList
{
DetId = s.DetId,
Name = s.Materials.Name,
ShortName = s.Materials.Measures.ShortName,
Amount = s.Amount,
Coefficient = s.Coefficient,
Deviation = s.Deviation,
MatGroupName = s.Materials.MatGroup.Name
}).ToList();
MatRecDetListBS.DataSource = list;
MatRecDetGridView.ExpandAllGroups();
tree.RemoveAll(r => r.ParentId == 0);
foreach (var item in list)
{
tree.Add(new CatalogTreeList
{
Id = tree.Max(m => m.Id) + 1,
ParentId = 0,
Text = item.Name,
ImgIdx = 2,
TabIdx = 2,
DataSetId = item.DetId
});
}
DirTreeList.RefreshDataSource();
DirTreeList.ExpandAll();
}
private void EditRecDetBtn_Click(object sender, EventArgs e)
{
dynamic det_item = MatRecDetGridView.GetFocusedRow();
if (det_item == null)
{
return;
}
xtraTabControl1.SelectedTabPageIndex = 2;
MatRecDetBS.DataSource = _db.MatRecDet.Find(det_item.DetId);
DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == det_item.DetId && Convert.ToInt32(w.GetValue("ParentId")) == 0);
}
private void DelRecDetBtn_Click(object sender, EventArgs e)
{
dynamic det_item = MatRecDetGridView.GetFocusedRow();
if (det_item == null)
{
return;
}
_db.MatRecDet.Remove(_db.MatRecDet.Find(det_item.DetId));
_db.SaveChanges();
GetRecDetail();
}
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
_db.SaveChanges();
var focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as CatalogTreeList;
if (focused_tree_node.ParentId == 0)
{
MatRecDetBS.DataSource = _db.MatRecDet.Find(focused_tree_node.DataSetId);
}
if (focused_tree_node.ParentId == 1)
{
MatRecipeTechProcDetBS.DataSource = _db.MatRecipeTechProcDet.Find(focused_tree_node.DataSetId);
}
if (focused_tree_node.Id == 0)
{
MatRecDetListBS.DataSource = _db.MatRecDet.Where(w => w.RecId == _mr.RecId).Select(s => new MatRecDetList
{
DetId = s.DetId,
Name = s.Materials.Name,
ShortName = s.Materials.Measures.ShortName,
Amount = s.Amount,
Coefficient = s.Coefficient,
Deviation = s.Deviation,
MatGroupName = s.Materials.MatGroup.Name
}).ToList();
MatRecDetGridView.ExpandAllGroups();
}
if (focused_tree_node.Id == 1)
{
MatRecTechProcGridControl.DataSource = _db.MatRecipeTechProcDet.Where(w => w.RecId == _mr.RecId).Select(s => new
{
s.Id,
s.Num,
s.ExpectedOut,
s.TechProcess.Name,
s.ProcId
}).OrderBy(o => o.Num).ToList();
}
xtraTabControl1.SelectedTabPageIndex = focused_tree_node.TabIdx;
}
private void MatRecDetGridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
dynamic det_item = MatRecDetGridView.GetFocusedRow();
if (det_item == null)
{
return;
}
var rec_det = _db.MatRecDet.Find(det_item.DetId);
if (e.Column.FieldName == "Amount")
{
rec_det.Amount = Convert.ToDecimal(e.Value);
}
else if (e.Column.FieldName == "Deviation")
{
rec_det.Deviation = Convert.ToDecimal(e.Value);
}
_db.SaveChanges();
}
