//根据索引删除检测设备
public static int DeleteDetectEuipmentById(int Id)
{
using (HullShellContainer hs = new HullShellContainer())
{
DetectEquipment de = hs.DetectEquipmentSet.Where(d => d.Id == Id).FirstOrDefault();
hs.DeleteObject(de);
return(hs.SaveChanges());
}
}
//修改
public static int ModifyDetectEquipmentById(DetectEquipmentCls dec)
{
using (HullShellContainer hs = new HullShellContainer())
{
DetectEquipment de = hs.DetectEquipmentSet.Where(d => d.Id == dec.Id).FirstOrDefault();
de.DetectEquipmentName = dec.MeasureDeviceName;
de.CameraResolution = dec.CameraResolution;
de.PixelSize = dec.PixelSize;
de.StdPrecision = dec.StdPrecision;
return(hs.SaveChanges());
}
}
//查询,根据名字
public static DetectEquipmentCls QueryDetectEquipmentByName(string _name)
{
using (HullShellContainer hs = new HullShellContainer())
{
DetectEquipment de = hs.DetectEquipmentSet.Where(d => d.DetectEquipmentName == _name).FirstOrDefault();
DetectEquipmentCls dec = new DetectEquipmentCls();
dec.Id = de.Id;
dec.MeasureDeviceName = de.DetectEquipmentName;
dec.CameraResolution = de.CameraResolution;
dec.PixelSize = de.PixelSize;
dec.StdPrecision = de.StdPrecision;
return(dec);
}
}
//增加检测设备信息
public static int AddDetectEquipment(DetectEquipmentCls dec)
{
using (HullShellContainer hs = new HullShellContainer())
{
DetectEquipment de = new DetectEquipment
{
DetectEquipmentName = dec.MeasureDeviceName,
CameraResolution = dec.CameraResolution,
PixelSize = dec.PixelSize,
StdPrecision = dec.StdPrecision
};
hs.AddToDetectEquipmentSet(de);
return(hs.SaveChanges());
}
}
