void GetDiscountList() { _db.SaveChanges(); var list = _db.DiscountList(_ka.KaId).ToList(); DiscountGridControl.DataSource = list; tree.RemoveAll(r => r.ParentId == 4); foreach (var item in list) { tree.Add(new CatalogTreeList { Id = tree.Max(m => m.Id) + 1, ParentId = 4, Text = item.Name, ImgIdx = item.ImgIdx == 0 ? 7 : 8, TabIdx = item.ImgIdx == 0 ? 10 : 11, DataSetId = item.DiscId }); } DirTreeList.DataSource = null; DirTreeList.DataSource = TreeListBS; DirTreeList.RefreshDataSource(); DirTreeList.ExpandAll(); }
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { var focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as CatalogTreeList; switch (focused_tree_node.Id) { case 1: case 3: UserTreeAccessBS.DataSource = _db.GetUserAccessTree(_user_id).ToList(); xtraTabControl2.SelectedTabPageIndex = 0; break; case 4: UserAccessWhGridControl.DataSource = _db.GetUserAccessWh(_user_id).ToList(); xtraTabControl2.SelectedTabPageIndex = 1; break; case 5: xtraTabControl2.SelectedTabPageIndex = 2; break; case 6: RefreshUserAccessCashDesks(); xtraTabControl2.SelectedTabPageIndex = 3; break; } xtraTabControl1.SelectedTabPageIndex = focused_tree_node.TabIdx; }
private void GetPersons() { var list = _db.BanksPersons.Where(w => w.BankId == bank.BankId).Select(s => new { s.PersonId, s.Name, s.Job, }).ToList(); BanksPersonsGridControl.DataSource = list; tree.RemoveAll(r => r.ParentId == 0); foreach (var item in list) { tree.Add(new CatalogTreeList { Id = tree.Count + 1, ParentId = 0, Text = item.Name, ImgIdx = 2, TabIdx = 2, DataSetId = item.PersonId }); } DirTreeList.RefreshDataSource(); DirTreeList.ExpandAll(); }
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { xtraTabControl1.SelectedTabPageIndex = 11; var mat_grp_disc = _db.KAMatGroupDiscount.Add(new KAMatGroupDiscount { DiscId = Guid.NewGuid(), KAId = _ka.KaId, OnValue = 0, GrpId = DB.SkladBase().MatGroup.FirstOrDefault().GrpId }); KAMatGroupDiscountDS.DataSource = mat_grp_disc; _db.SaveChanges(); GetDiscountList(); DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", mat_grp_disc.DiscId); /* * DiscountList->Append(); * DiscountListIMG_IDX->Value = 1; * MemTableEh1->Append(); * MemTableEh1ImgIdx->Value = 8; * MemTableEh1Parent_ID->Value = 3; * // MemTableEh1Text->Value = " ("+DiscountListONVALUE->AsString+"%) "+DiscountListNAME->Value ; * MemTableEh1TabIdx->Value = 11; * MemTableEh1DataSetID->Value = DiscountListDISCID->Value; * MemTableEh1->Post();*/ }
private void GetMatChange() { var result = _db.GetMatChange(_mat_id).ToList(); GetMatChangeBS.DataSource = result; tree.RemoveAll(r => r.ParentId == 3); foreach (var item in result) { var node = new CatalogTreeList { Id = tree.Max(m => m.Id) + 1, ParentId = 4, Text = item.MatChangeName, ImgIdx = 14, TabIdx = 3, DataSetId = item.ChangeId }; TreeListBS.Add(node); } DirTreeList.RefreshDataSource(); DirTreeList.ExpandAll(); }
private void GetTechProcDetail() { var list = _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(); MatRecTechProcGridControl.DataSource = list; tree.RemoveAll(r => r.ParentId == 1); foreach (var item in list) { tree.Add(new CatalogTreeList { Id = tree.Max(m => m.Id) + 1, ParentId = 1, Text = item.Name, ImgIdx = 2, TabIdx = 4, DataSetId = item.Id }); } DirTreeList.DataSource = null; DirTreeList.DataSource = TreeListBindingSource; DirTreeList.RefreshDataSource(); DirTreeList.ExpandAll(); }
private void simpleButton12_Click(object sender, EventArgs e) { _db.KAgentAccount.Remove(KAgentAccountBS.DataSource as KAgentAccount); _db.SaveChanges(); GetAccounts(); DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("Id")) == 7); }
private void GetRecDetail() { var list = _db.MatRecDet.Where(w => w.RecId == _mr.RecId).Select(s => new { s.DetId, s.Materials.Name, s.Materials.Measures.ShortName, s.Amount, s.Coefficient }).ToList(); MatRecDetGridControl.DataSource = list; 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 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 simpleButton11_Click(object sender, EventArgs e) { _db.KAgentPersons.Remove(PersonBS.DataSource as KAgentPersons); _db.SaveChanges(); GetPersons(); DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("Id", 6); }
private void frmMatGroupEdit_Load(object sender, EventArgs e) { xtraTabControl1.ShowTabHeader = DevExpress.Utils.DefaultBoolean.False; TreeListBS.Add(new CatalogTreeList { Id = 0, ParentId = 255, Text = "Основна інформація", ImgIdx = 0, TabIdx = 0 }); TreeListBS.Add(new CatalogTreeList { Id = 1, ParentId = 255, Text = "Ціноутворення ", ImgIdx = 1, TabIdx = 1 }); TreeListBS.Add(new CatalogTreeList { Id = 2, ParentId = 255, Text = "Оподаткування", ImgIdx = 2, TabIdx = 2 }); TreeListBS.Add(new CatalogTreeList { Id = 3, ParentId = 255, Text = "Примітка", ImgIdx = 3, TabIdx = 3 }); if (_grp_id == null) { _mg = _db.MatGroup.Add(new MatGroup { Deleted = 0, Nds = 0, PId = 0, Name = "" }); _db.SaveChanges(); _grp_id = _mg.GrpId; _mg.PId = _pid ?? _mg.GrpId; } else { _mg = _db.MatGroup.Find(_grp_id); } if (_mg != null) { checkEdit4.Checked = (_mg.GrpId == _mg.PId); GrpIdEdit.Properties.TreeList.DataSource = DB.SkladBase().MatGroup.Select(s => new { s.GrpId, s.PId, s.Name, ImageIndex = 7 }).ToList(); MatGroupDS.DataSource = _mg; } GetTreeMatPrices(); #region Init checkEdit3_CheckedChanged(sender, e); PricePanel.Enabled = false; NdsEdit.EditValue = _mg.Nds == -1 ? null : _mg.Nds; #endregion DirTreeList.ExpandAll(); }
private void AddRecDetBtn_Click(object sender, EventArgs e) { xtraTabControl1.SelectedTabPageIndex = 2; var new_det = _db.BanksPersons.Add(new BanksPersons { BankId = bank.BankId, Name = "" }); BanksPersonsBS.DataSource = new_det; _db.SaveChanges(); GetPersons(); DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == new_det.PersonId); }
private void EditTecProcDetBtn_Click(object sender, EventArgs e) { dynamic det_item = MatRecTechProcGridView.GetFocusedRow(); if (det_item == null) { return; } xtraTabControl1.SelectedTabPageIndex = 4; MatRecipeTechProcDetBS.DataSource = _db.MatRecipeTechProcDet.Find(det_item.Id); DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == det_item.Id && Convert.ToInt32(w.GetValue("ParentId")) == 1); }
private void ChangeName() { var rd = MatRecDetBS.DataSource as MatRecDet; rd.MatId = Convert.ToInt32(MatLookUpEdit.EditValue); _db.SaveChanges(); var det = tree.FirstOrDefault(w => Convert.ToInt32(w.DataSetId) == rd.DetId); if (det != null) { det.Text = _db.Materials.Find(rd.MatId).Name; DirTreeList.RefreshDataSource(); } }
private void EditRecDetBtn_Click(object sender, EventArgs e) { dynamic det_item = BanksPersonsGridView.GetFocusedRow(); if (det_item == null) { return; } xtraTabControl1.SelectedTabPageIndex = 2; BanksPersonsBS.DataSource = _db.BanksPersons.Find(det_item.PersonId); DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == det_item.PersonId); }
private void EditPersonBtn_Click(object sender, EventArgs e) { dynamic det_item = KAgentPersonsGridView.GetFocusedRow(); if (det_item == null) { return; } xtraTabControl1.SelectedTabPageIndex = 8; PersonBS.DataSource = _db.KAgentPersons.Find(det_item.PersonId); DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", det_item.PersonId); }
private void ReportUserControl_Load(object sender, EventArgs e) { mainContentTab.ShowTabHeader = DevExpress.Utils.DefaultBoolean.False; if (!DesignMode) { using (var db = new BaseEntities()) { // repositoryItemLookUpEdit1.DataSource = DBHelper.WhList; DirTreeList.DataSource = db.GetReportTree(DBHelper.CurrentUser.UserId).ToList(); DirTreeList.ExpandToLevel(1); } } }
private void AddPersonBtn_Click(object sender, EventArgs e) { xtraTabControl1.SelectedTabPageIndex = 8; var new_det = _db.KAgentPersons.Add(new KAgentPersons { KAId = _ka.KaId, Name = "" }); PersonBS.DataSource = new_det; _db.SaveChanges(); GetPersons(); DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", new_det.PersonId); }
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 AddRecDetBtn_Click(object sender, EventArgs e) { xtraTabControl1.SelectedTabPageIndex = 2; var new_det = _db.MatRecDet.Add(new MatRecDet { RecId = _mr.RecId, Amount = 0, Coefficient = 0, MatId = DB.SkladBase().MaterialsList.FirstOrDefault().MatId }); MatRecDetBS.DataSource = new_det; _db.SaveChanges(); GetRecDetail(); DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == new_det.DetId); }
private void AddTecProcDetBtn_Click(object sender, EventArgs e) { xtraTabControl1.SelectedTabPageIndex = 4; var new_det = _db.MatRecipeTechProcDet.Add(new MatRecipeTechProcDet { RecId = _mr.RecId, Num = _db.MatRecipeTechProcDet.Count(w => w.RecId == _mr.RecId) + 1, ExpectedOut = 100, ProcId = DB.SkladBase().TechProcess.FirstOrDefault().ProcId }); MatRecipeTechProcDetBS.DataSource = new_det; _db.SaveChanges(); GetTechProcDetail(); DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == new_det.Id); }
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as GetReportTree_Result; using (var db = DB.SkladBase()) { RepGridControl.DataSource = null; RepGridControl.DataSource = db.Reports.Where(w => w.GrpId == focused_tree_node.Id && w.Fil == 1) .Join(db.RepLng.Where(r => r.LangId == 2), rep => rep.RepId, lng => lng.RepId, (rep, lng) => new { ImgIndex = 23, rep.RepId, lng.Name, lng.Notes, rep.Num }).OrderBy(o => o.Num).ToList(); } }
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { _db.SaveChanges(); var focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as CatalogTreeList; if (_ka != null && focused_tree_node.Id == 4) { DiscountGridControl.DataSource = _db.DiscountList(_ka.KaId).ToList(); } if (focused_tree_node.ParentId == 4) { if (focused_tree_node.ImgIdx == 7) //Товар { MatDiscountDS.DataSource = _db.KAMatDiscount.Find(focused_tree_node.DataSetId); } else { KAMatGroupDiscountDS.DataSource = _db.KAMatGroupDiscount.Find(focused_tree_node.DataSetId); } } if (focused_tree_node.ParentId == 7) { KAgentAccountBS.DataSource = _db.KAgentAccount.Find(focused_tree_node.DataSetId); } if (focused_tree_node.Id == 7) { GetAcc(); } if (focused_tree_node.Id == 6) { KAgentPersonsBS.DataSource = _db.KAgentPersons.AsNoTracking().Where(w => w.KAId == _ka.KaId).ToList(); } if (focused_tree_node.ParentId == 6) { PersonBS.DataSource = _db.KAgentPersons.Find(focused_tree_node.DataSetId); } xtraTabControl1.SelectedTabPageIndex = focused_tree_node.TabIdx; }
private void AddAccBtn_Click(object sender, EventArgs e) { xtraTabControl1.SelectedTabPageIndex = 9; var new_det = _db.KAgentAccount.Add(new KAgentAccount { KAId = _ka.KaId, AccNum = "", TypeId = _db.AccountType.FirstOrDefault().TypeId, BankId = _db.Banks.FirstOrDefault().BankId, Def = _db.KAgentAccount.Any(a => a.KAId == _ka.KaId) ? 0 : 1 }); KAgentAccountBS.DataSource = new_det; _db.SaveChanges(); GetAccounts(); DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", new_det.AccId); }
private void GetAccounts() { tree.RemoveAll(r => r.ParentId == 7); foreach (var item in GetAcc()) { tree.Add(new CatalogTreeList { Id = tree.Max(m => m.Id) + 1, ParentId = 7, Text = item.AccNum, ImgIdx = 6, TabIdx = 9, DataSetId = item.AccId }); } DirTreeList.RefreshDataSource(); DirTreeList.ExpandAll(); }
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as GetServiceTree_Result; RefrechItemBtn.PerformClick(); mainContentTab.SelectedTabPageIndex = focused_tree_node.GType.Value; if (focused_tree_node.FunId != null) { History.AddEntry(new HistoryEntity { FunId = focused_tree_node.FunId.Value, MainTabs = 6 }); if (DirTreeList.ContainsFocus) { Settings.Default.LastFunId = focused_tree_node.FunId.Value; } } }
private void ServiceUserControl_Load(object sender, EventArgs e) { mainContentTab.ShowTabHeader = DevExpress.Utils.DefaultBoolean.False; delTurnDate.DateTime = DateTime.Now; if (!DesignMode) { using (var db = new BaseEntities()) { // repositoryItemLookUpEdit1.DataSource = DBHelper.WhList; DirTreeList.DataSource = db.GetServiceTree(DBHelper.CurrentUser.UserId).ToList(); DirTreeList.ExpandToLevel(1); wbStartDate.DateTime = DateTime.Now.Date; //DateTimeDayOfMonthExtensions.FirstDayOfMonth(DateTime.Now); wbEndDate.DateTime = DateTime.Now.Date.AddDays(1); UserComboBox.Properties.DataSource = new List <object>() { new { UserId = -1, Name = "Усі" } }.Concat(new BaseEntities().Users.Select(s => new { s.UserId, s.Name })).ToList(); UserComboBox.EditValue = -1; wTypeList.Properties.DataSource = new List <object>() { new { FunId = (int?)-1, Name = "Усі" } } .Concat(new BaseEntities().ViewLng.Where(w => w.LangId == 2 && (w.UserTreeView.Functions.TabId == 24 || w.UserTreeView.Functions.TabId == 27 || w.UserTreeView.Functions.TabId == 51)).Select(s => new { s.UserTreeView.FunId, s.Name })).ToList(); wTypeList.EditValue = -1; } /* using (var s = new UserSettingsRepository(UserSession.UserId)) * { * ComPortNameEdit.Text = s.ComPortName; * ComPortSpeedEdit.Text = s.ComPortSpeed; * }*/ } DeviceNameRMKTextEdit.Text = Settings.Default.barcode_scanner_name; }
private void simpleButton7_Click(object sender, EventArgs e) { var row = DiscountGridView.GetFocusedRow() as DiscountList_Result; if (row == null) { return; } if (row.ImgIdx == 0) { MatDiscountDS.DataSource = _db.KAMatDiscount.FirstOrDefault(w => w.DiscId == row.DiscId); xtraTabControl1.SelectedTabPageIndex = 10; } else { KAMatGroupDiscountDS.DataSource = _db.KAMatGroupDiscount.FirstOrDefault(w => w.DiscId == row.DiscId); xtraTabControl1.SelectedTabPageIndex = 11; } DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", row.DiscId); }
private void GetPersons() { var list = _db.KAgentPersons.AsNoTracking().Where(w => w.KAId == _ka.KaId).ToList(); KAgentPersonsBS.DataSource = list; tree.RemoveAll(r => r.ParentId == 6); foreach (var item in list) { tree.Add(new CatalogTreeList { Id = tree.Max(m => m.Id) + 1, ParentId = 6, Text = item.Name, ImgIdx = 6, TabIdx = 8, DataSetId = item.PersonId }); } DirTreeList.RefreshDataSource(); DirTreeList.ExpandAll(); }
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) { BanksPersonsBS.DataSource = _db.BanksPersons.Find(focused_tree_node.DataSetId); } if (focused_tree_node.Id == 0) { var list = _db.BanksPersons.Where(w => w.BankId == bank.BankId).Select(s => new { s.PersonId, s.Name, s.Job, }).ToList(); BanksPersonsGridControl.DataSource = list; } xtraTabControl1.SelectedTabPageIndex = focused_tree_node.TabIdx; }