private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (barButtonItem2.Down) { var row = MatTreeList.GetDataRecordByNode(MatTreeList.FocusedNode) as GetMatTree_Result; if (row.Id < 0) { var grp = MatTreeList.DataSource as List <GetMatTree_Result>; var grp_ids = _db.GetMatGroupTree(row.Id * -1).ToList().Select(s => s.GrpId * -1).ToList(); foreach (var item in grp.Where(w => grp_ids.Contains(w.Pid))) { AddMat(item); } } else { AddMat(row); } } if (barButtonItem3.Down) { var row = MatTreeList.GetDataRecordByNode(MatTreeList.FocusedNode) as GetSvcTree_Result; if (row.Id < 0) { var grp = MatTreeList.DataSource as List <GetSvcTree_Result>; foreach (var item in grp.Where(w => w.Pid == row.Id)) { AddSvc(item); } } else { AddSvc(row); } } _db.SaveChanges(); GetDetail(); }
private void GetMatTree() { var sql = @" select mats.matid as Id, -1*mats.grpid as Pid, mats.Name, mats.Artikul as art, msr.shortname as MsrName, 0 as ImgIndex, 0.00 Price from materials mats, measures msr where msr.mid=mats.mid and mats.deleted=0 union all select -1*mg.grpid as id, -1*mg.pid as pid, mg.name ,'', '', 2 , 0 from matgroup mg where mg.deleted=0"; int?p_type = PTypeEdit.EditValue == null || PTypeEdit.EditValue == DBNull.Value ? null : (int?)PTypeEdit.EditValue; var list = _db.GetMatTree(p_type, 2).ToList(); // var list = _db.Database.SqlQuery<GetMatTree_Result>(sql).ToList(); MatTreeList.BeginUpdate(); MatTreeList.DataSource = list; MatTreeList.EndUpdate(); }
private void textEdit1_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == 13 && AddMaterialBtn.Enabled && !String.IsNullOrEmpty(BarCodeEdit.Text)) { var BarCodeText = BarCodeEdit.Text.Split('+'); string kod = BarCodeText[0]; var item = _db.Materials.Where(w => w.BarCode == kod || w.Name.Contains(kod)).Select(s => s.MatId).FirstOrDefault(); if (item > 0) { BarCodeEdit.BackColor = Color.PaleGreen; MatTreeList.FocusedNode = MatTreeList.FindNodeByFieldValue("Id", item); barButtonItem5.PerformClick(); } else { BarCodeEdit.BackColor = Color.Pink; } BarCodeEdit.Text = ""; } }