public IHttpActionResult QueryBadTypeByUIDAPI(int uuid) { var dto = new ExceptionTypeVM(); dto = AutoMapper.Mapper.Map <ExceptionTypeVM>(QualityService.QueryBadTypeByUID(uuid)); return(Ok(dto)); }
public string AddExceptionType(ExceptionTypeVM newType) { string result = ""; try { string fatherNode = ""; if (!string.IsNullOrEmpty(newType.Second_Type)) { fatherNode = newType.Second_Type; } else if (!string.IsNullOrEmpty(newType.First_Type)) { fatherNode = newType.First_Type; } string sql = string.Format(@" IF EXISTS ( SELECT TOP 1 1 FROM dbo.QualityAssurance_ExceptionType WHERE TypeName=N'{0}' AND Flowchart_Master_UID = N'{6}') BEGIN SELECT N'已存在同名的类型,请检查。' AS Message END ELSE BEGIN DECLARE @NewOrgCode NVARCHAR(50), @fatherCode NVARCHAR(50), @NowMaxCode INT SET @fatherCode='{1}' IF NOT EXISTS (SELECT TOP 1 1 FROM dbo.QualityAssurance_ExceptionType WHERE Project=N'{5}' AND EnableFlag=1 ) BEGIN SET @NewOrgCode='001000000' END ELSE IF ISNULL(@fatherCode,'')='' BEGIN SELECT @NowMaxCode =MAX(CONVERT(INT,Org_TypeCode)) FROM dbo.QualityAssurance_ExceptionType WHERE Project=N'{5}' and Org_TypeCode LIKE '%000000' SET @NewOrgCode=CONVERT(NVARCHAR(50),@NowMaxCode+1000000) END ElSE IF @fatherCode LIKE '%000000' BEGIN SELECT @NowMaxCode=MAX(CONVERT(INT,Org_TypeCode)) FROM dbo.QualityAssurance_ExceptionType WHERE Project=N'{5}' and Org_TypeCode LIKE SUBSTRING(@fatherCode,1,3)+'%000' SET @NewOrgCode=CONVERT(NVARCHAR(50),@NowMaxCode+1000) END ELSE IF @fatherCode LIKE '%000' BEGIN SELECT @NowMaxCode=MAX(CONVERT(INT,Org_TypeCode)) FROM dbo.QualityAssurance_ExceptionType WHERE Project=N'{5}' and Org_TypeCode LIKE SUBSTRING(@fatherCode,1,6)+'%' SET @NewOrgCode=CONVERT(NVARCHAR(50),@NowMaxCode+1) END IF LEN(@NewOrgCode)=7 BEGIN SET @NewOrgCode='00'+@NewOrgCode END ELSE IF LEN(@NewOrgCode)=8 BEGIN SET @NewOrgCode='0'+@NewOrgCode END INSERT INTO dbo.QualityAssurance_ExceptionType ( TypeName , ShortName , EnableFlag , Creator_UID , Create_Date , Modified_UID , Modified_Date , Org_TypeCode , TypeClassify, Project, Flowchart_Master_UID ) VALUES ( N'{0}' , -- TypeName - nvarchar(50) N'{2}' , -- ShortName - nvarchar(20) 1 , -- EnableFlag - bit {3} , -- Creator_UID - int GETDATE() , -- Create_Date - datetime {3} , -- Modified_UID - int GETDATE() , -- Modified_Date - datetime @NewOrgCode , -- Org_TypeCode - nvarchar(50) N'{4}' , -- TypeClassify - nvarchar(50), N'{5}', {6} ) SELECT 'Success' AS Message END", newType.TypeName.Trim(), fatherNode, newType.ShortName, newType.Creator_UID, newType.TypeClassify, newType.Project, newType.Flowchart_Master_UID); result = DataContext.Database.SqlQuery <string>(sql).ToArray()[0]; } catch (Exception ex) { result = "Error"; log.Error(ex); } return(result); }