//若Family为空,则将当前Customer保存到记录中的Family栏位 //GetExistQCRatio(String customer, string QCRatioId) //SELECT [IMES_FA].[dbo].[QCRatio].[Family] // FROM [IMES_FA].[dbo].[QCRatio] inner join //[IMES_GetData].[dbo].[Family] on [IMES_FA].[dbo].[QCRatio].[Family]=[IMES_GetData].[dbo].[Family].[Family] //WHERE [IMES_GetData].[dbo].[Family].[CustomerID]='customer' //AND [IMES_FA].[dbo].[QCRatio].[Family]='QCRatioId' //change to: // SELECT [IMES_FA_Datamaintain].[dbo].[QCRatio].[Family] // FROM [IMES_FA_Datamaintain].[dbo].[QCRatio] inner join // (select [IMES_GetData_Datamaintain].[dbo].[Family].Family from [IMES_GetData_Datamaintain].[dbo].[Family] // WHERE [IMES_GetData_Datamaintain].[dbo].[Family].[CustomerID]='customer' union // select [IMES_GetData_Datamaintain].dbo.Customer.Customer AS [Family] from [IMES_GetData_Datamaintain].dbo.Customer // WHERE [IMES_GetData_Datamaintain].dbo.Customer.Customer='customer' // ) AS C //on [IMES_FA_Datamaintain].[dbo].[QCRatio].[Family]=C.[Family] // WHERE [IMES_FA_Datamaintain].[dbo].[QCRatio].[Family]='QCRatioId' //change to: //SELECT [Family] // FROM [QCRatio] //WHERE [QCRatio].[Family]=@ QCRatioFamily public string AddQCRatio(QCRatioDef item) { String result = ""; try { IFamilyRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IFamilyRepository>(); DataTable exists=itemRepository.GetExistQCRatio(item.Family); if (exists != null && exists.Rows.Count > 0) { //已经存在具有相同Customer和Family的QCRatio记录 List<string> erpara = new List<string>(); FisException ex; ex = new FisException("DMT007", erpara); throw ex; } int intQCRatio; int intEOQCRatio; int intPAQCRatio; int intRPAQCRatio; if (item.QCRatio == "") { intQCRatio = Int32.MinValue; } else { intQCRatio = Int32.Parse(item.QCRatio); } if (item.EOQCRatio == "") { intEOQCRatio = Int32.MinValue; } else { intEOQCRatio = Int32.Parse(item.EOQCRatio); } if (item.PAQCRatio == "") { intPAQCRatio = Int32.MinValue; } else { intPAQCRatio = Int32.Parse(item.PAQCRatio); } if (item.RPAQCRatio == "") { intRPAQCRatio = Int32.MinValue; } else { intRPAQCRatio = Int32.Parse(item.RPAQCRatio); } QCRatio itemQCRatio=new QCRatio( item.Family, intQCRatio, intEOQCRatio, intPAQCRatio, item.Editor, DateTime.Now, DateTime.Now, intRPAQCRatio ); itemRepository.AddQCRatio(itemQCRatio); result = itemQCRatio.Family; } catch (Exception) { throw; } return result; }
public void DeleteQCRatio(QCRatioDef item) { try { IFamilyRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IFamilyRepository>(); QCRatio itemQCRatio = new QCRatio( item.Family, 0, 0, 0, "", DateTime.Now, DateTime.Now, 0); itemRepository.DeleteQCRatio(itemQCRatio); } catch (Exception) { throw; } }