//判断是否存在相同Model和Type的记录 //Boolean IsExistPrintInfo(string model, string type) //IF EXISTS(SELECT * FROM PilotRunPrintInfo WHERE Model = @Model AND Type = @Type) //返回true //否则false //INSERT INTO [PilotRunPrintInfo]([Family],[Model],[Build],[SKU],[Type],[Descr],[Editor],[Cdt],[Udt]) // VALUES (@Family, @Model, @Build, @SKU, @Type, @Description, @Editor, GETDATE(), GETDATE()) //需要在返回的ITEM的ID中填上当前新加入的记录的ID public string AddPrintInfo(PilotRunPrintInfo item) { string result = ""; try { IMiscRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IMiscRepository>(); Boolean isExistBuild = itemRepository.IsBuildExist(item.Build); if (isExistBuild != true) { //选择的Build在数据库中已不存在 List<string> erpara = new List<string>(); FisException ex; ex = new FisException("DMT046", erpara); throw ex; } Boolean isExistType = itemRepository.IsPrintTypeExist(item.Type); if (isExistType != true) { //选择的Type在数据库中已不存在 List<string> erpara = new List<string>(); FisException ex; ex = new FisException("DMT047", erpara); throw ex; } Boolean isExistPrintInfo = itemRepository.IsExistPrintInfo(item.Model,item.Type); if (isExistPrintInfo == true) { //已经存在具有相同Model、Type的PilotRunPrintInfo记录 List<string> erpara = new List<string>(); FisException ex; ex = new FisException("DMT048", erpara); throw ex; } item.Cdt = DateTime.Now; item.Udt = DateTime.Now; UnitOfWork uow = new UnitOfWork(); itemRepository.AddPrintInfoDefered(uow,item); itemRepository.BSUpdateDefered(uow,item.Family, item.Build, item.SKU, item.Model, item.Editor); uow.Commit(); result = item.ID.ToString(); } catch (Exception) { throw; } return result; }
//UPDATE PilotRunPrintInfo SET Descr = @Description, Editor = @Editor, Udt = GETDATE() // WHERE ID=id public void UpdatePrintInfo(PilotRunPrintInfo item) { try { IMiscRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IMiscRepository>(); Boolean isExistBuild = itemRepository.IsBuildExist(item.Build); if (isExistBuild != true) { //选择的Build在数据库中已不存在 List<string> erpara = new List<string>(); FisException ex; ex = new FisException("DMT046", erpara); throw ex; } Boolean isExistType = itemRepository.IsPrintTypeExist(item.Type); if (isExistType != true) { //选择的Type在数据库中已不存在 List<string> erpara = new List<string>(); FisException ex; ex = new FisException("DMT047", erpara); throw ex; } UnitOfWork uow = new UnitOfWork(); itemRepository.UpdatePrintInfoDefered(uow, item.ID, item.Descr, item.Editor); itemRepository.BSUpdateDefered(uow,item.Family, item.Build, item.SKU, item.Model, item.Editor); uow.Commit(); } catch (Exception) { throw; } }