//выбор элемента для переноса
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));
}
