public void AddDto(HardwareDto hardwareDto) { Hardware hardwareDomain = new Hardware(); hardwareDomain.ID = hardwareDto.ID; hardwareDomain.Name = hardwareDto.Name; hardwareDomain.Number = hardwareDto.Number; hardwareDomain.CreateTime = hardwareDto.CreateTime; hardwareDomain.CreateUser = hardwareDto.CreateUser; //转换工程名为工程id var projects = from r in _dataContext.Set <Project>() where r.Name == hardwareDto.Project select r; foreach (var project in projects) { hardwareDomain.ProjectID = project.ID; } //添加到表hardware _hardwareRepository.AddEntity(hardwareDomain); //查出hardware获取id号 int id = 0; var hardwares = from r in _dataContext.Set <Hardware>() where r.Name == hardwareDto.Name select r; foreach (var hardware in hardwares) { id = hardware.ID; } //添加items到表itembaseonhardware for (int i = 0; i < hardwareDto.Items.Count; i++) { ItemBaseOnHardware itemBaseOnHardware = new ItemBaseOnHardware(); itemBaseOnHardware.Name = hardwareDto.Items[i]; itemBaseOnHardware.HardwareID = id; _itemBaseOnHardwareRepository.AddEntity(itemBaseOnHardware); } }
public void AddDto(ItemBaseOnHardwareDto dto, int HardwareID) { ItemBaseOnHardware itemBaseOnHardware = new ItemBaseOnHardware(); itemBaseOnHardware.Name = dto.Name; itemBaseOnHardware.HardwareID = HardwareID; _itemBaseOnHardwareRepository.AddEntity(itemBaseOnHardware); }
public void UpdateDto(ItemBaseOnHardwareDto dto, string CurrentUser, int HardwareID) { ItemBaseOnHardware itemBaseOnHardware = new ItemBaseOnHardware(); itemBaseOnHardware.ID = dto.ID; itemBaseOnHardware.Name = dto.Name; if (dto.Status == "未测试") { itemBaseOnHardware.Status = 0; } else if (dto.Status == "正常") { itemBaseOnHardware.Status = 1; } else if (dto.Status == "异常") { itemBaseOnHardware.Status = 2; } itemBaseOnHardware.UpdateTime = DateTime.Now.ToString(); itemBaseOnHardware.UpdateUser = CurrentUser; itemBaseOnHardware.Remark = dto.Remark; itemBaseOnHardware.HardwareID = HardwareID; //判断是否修改 var tem = _itemBaseOnHardwareRepository.GetEntityByIDNoTrack(dto.ID); //从数据库获取当前修改的对象 if (tem.Status != itemBaseOnHardware.Status || tem.Remark != itemBaseOnHardware.Remark) //当界面发生更改,则更新ItemBaseOnHardware表并写入Record表中 { _itemBaseOnHardwareRepository.UpdateEntity(itemBaseOnHardware); //更新到ItemBaseOnHardware表 Record record = new Record(); record.Status = itemBaseOnHardware.Status; record.UpdateTime = DateTime.Now.ToString(); record.UpdateUser = CurrentUser; record.Remark = dto.Remark; record.ItemBaseOnHardwareID = itemBaseOnHardware.ID; //record的外键 _recordRepository.AddEntity(record); //写入Record表 } }