//выбор элемента для переноса private void dgv_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e) { _currentBreaker = bs_ProjectCbr.Current as ProjectCbr; _currentBreaker.Title = ConfigServices.GetCbrTitle(bs_ProjectCbr.Current as ProjectCbr); dgvProjectCbr.DoDragDrop(_currentBreaker.Title, DragDropEffects.Copy); }
//получить связанный трансформатор тока public List <ProjectCtr> GetBindedCurTrans(ProjectCbr peCbr) { using (DataEntities db = new DataEntities()) { var listPrCtr = (from ctr in db.CurrentTransforms join pe in db.ProjectEquipments on ctr.Id equals pe.IdCtr join en in db.EquipNotes on pe.IdNote equals en.Id where pe.IdNote == peCbr.IdNote && pe.IdProjectNumber == peCbr.IdProjectNumber select new ProjectCtr { Id = ctr.Id, IdProjectNumber = peCbr.IdProjectNumber, IdProjectEquip = pe.Id, IdNote = pe.IdNote, ConNum = en.Text, IdManufacturer = ctr.IdManufacturer, TypeSize = ctr.TypeSize, TransFactor = ctr.TransFactor, MeasureClass = ctr.MeasureClass, Power = ctr.Power }).ToList(); return(listPrCtr); } }
//код производителя public string GetManufLiter(ProjectCbr peCbr) { using (DataEntities db = new DataEntities()) { string code = (from m in db.Manufacturers where m.Id == peCbr.IdManufacturer select m.Literal).SingleOrDefault().ToString(); return(code); } }
//получить обозначение выключателя public string GetCbrTitle(ProjectCbr peCbr) { using (DataEntities db = new DataEntities()) { string pcbrTitle = (from cbr in db.CurrentBreakers join sr in db.Serias on cbr.IdSeria equals sr.Id join cbc in db.CbCurrents on cbr.IdCbCurrent equals cbc.Id join icl in db.IcuLiterals on cbr.IdIcuLiteral equals icl.Id join dm in db.DisModels on cbr.IdDisModel equals dm.Id join dcr in db.DisCurrents on cbr.IdDisCurrent equals dcr.Id where cbr.Id == peCbr.Id select new ProjectCbr { Title = sr.Name + " " + cbc.Value + icl.Literal + " " + dm.Name + " " + dcr.Value }).SingleOrDefault().Title; return(pcbrTitle); } }
//список размеров public List <VerticalSize> GetAllVertSizes(ProjectCbr peCbr, Schema sch) { List <VerticalSize> list = new List <VerticalSize>(); using (DataEntities db = new DataEntities()) { var sql = from vs in db.VSizes where vs.IdManuf == peCbr.IdManufacturer && vs.IdSeria == peCbr.IdSeria && vs.IdPoleNumber == peCbr.IdPoleNumber && vs.IdCbrCurrent == peCbr.IdCbCurrent && vs.IdSchema == sch.Id select vs; foreach (VSize v in sql) { list.Add(new VerticalSize() { Id = v.Id, SizeName = v.SizeName + v.Fraction }); } return(list); } }
//получить связанный контактор public ProjectCnt GetBindedCont(ProjectCbr peCbr) { using (DataEntities db = new DataEntities()) { ProjectCnt prCont = (from cnt in db.Contactors join pe in db.ProjectEquipments on cnt.Id equals pe.IdCont join en in db.EquipNotes on pe.IdNote equals en.Id where pe.IdNote == peCbr.IdNote && pe.IdProjectNumber == peCbr.IdProjectNumber select new ProjectCnt { Id = cnt.Id, IdProjectNumber = peCbr.IdProjectNumber, IdProjectEquip = pe.Id, IdNote = pe.IdNote, ConNum = en.Text, IdManufacturer = cnt.IdManufacturer, IdSeria = cnt.IdSeria, ContCatNumber = cnt.ContCatNumber, RelayCabNumber = cnt.RelayCabNumber }).SingleOrDefault(); return(prCont); } }
//получить связанный контактор public static ProjectCnt GetBindedCont(ProjectCbr peCbr) { return(confobject.GetBindedCont(peCbr)); }
//получить связанный трансформатор тока public static List <ProjectCtr> GetBindedCurTrans(ProjectCbr peCbr) { return(confobject.GetBindedCurTrans(peCbr)); }
//список размеров public static List <VerticalSize> GetAllVertSizes(ProjectCbr cbr, Schema sch) { return(confobject.GetAllVertSizes(cbr, sch)); }
//код производителя public static string GetManufLiter(ProjectCbr cbr) { return(confobject.GetManufLiter(cbr)); }
//получить обозначение выключателя public static string GetCbrTitle(ProjectCbr cbr) { return(confobject.GetCbrTitle(cbr)); }