新增文章

文章标题分类内容

DECLARE @TableItem TABLE
   (
      FItemID      INT,
      FIsConfig    TINYINT NOT NULL DEFAULT(0),
      FBomInterID  INT NOT NULL DEFAULT(0),
      FBOMNumber   NVARCHAR(200) NOT NULL DEFAULT(''),
      FERPClsID    INT NOT NULL DEFAULT(0)
   )
                     
   INSERT INTO @TableItem ( FItemID )
   
   SELECT 0 
   UNION SELECT 1296
   
   UPDATE t1 SET t1.FErpClsID=t2.FErpClsID
     FROM @TableItem t1 INNER JOIN t_ICItemBase t2 ON t1.FItemID = t2.FItemID
     
   UPDATE t1 SET t1.FIsConfig = 1,t1.FBOMInterID = t3.FInterID,t1.FBomNumber = t3.FBOMNumber
     FROM @TableItem t1 INNER JOIN ICPlan_CharConfig t2 ON t1.FItemID = t2.FItemID INNER JOIN ICBOM t3 ON t2.FSourceItemID=t3.FItemID and t3.FInterID=t2.FBOMInterID
    WHERE t1.FBomInterID = 0 AND t1.FErpClsID IN (2,3)
    
   UPDATE t1 SET t1.FBOMInterID = t2.FInterID,t1.FBomNumber = t2.FBOMNumber
     FROM @TableItem t1 INNER JOIN ICBOM t2 ON t1.FItemID = t2.FItemID
    WHERE t1.FBomInterID = 0 AND t2.FUseStatus = 1072 AND t1.FErpClsID IN (2,3)
    
   SELECT * FROM @TableItem WHERE FItemID > 0