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