功能是根據ProductsId從Base_Gx_ProductsInfo表中獲取ProductsTypeId,Sales的值，然后根據獲取到的ProductsTypeId，在從表Base_SmallTypeInfo獲取SaleValue進行比較。如果Sales小于SaleValue則更新表update Base_Gx_ProductsInfo set Status= 3 ,ProcessStatus=1? Where ProductsId=@ProductsId否則更新為 Status= 1 ,ProcessStatus=1，然后再比較下面的ALTER PROCEDURE [dbo].[Check_productStatus]@ProductsId int,@out_msg nvarchar(20) output,@out_result int output?AS? ?BEGIN? /*變量定義*/? DECLARE? @VCOUNT INT,? ? @VCARDSN INT,? ? @VOPCOUNT INT,? ? @VProductsTypeId INT,? @VSales VARCHAR(30),@VSaleValue VARCHAR(30),? ? @VEMPCODE VARCHAR(30)? ?SELECT ProductsTypeId,Sales? into VProductsTypeIdFROM [Base_Gx_ProductsInfo]WHERE ProductsId=@ProductsId;? SELECT SaleValue? into VSaleValueFROM Base_SmallTypeInfoWHERE ProductsTypeId=@VProductsTypeId;IF convert(int,@VSales)>convert(int,@VSaleValue)BEGIN? update Base_Gx_ProductsInfo set Status= 3 ,ProcessStatus=1? Where ProductsId=@ProductsId? SET @out_msg = '更新狀態成功'? SET @out_result = 101? ?ENDElseSELECT @VCOUNT = ISNULL(COUNT_BIG(*), 0)FROM [Base_Gx_ProductsInfo]WHERE ProductsId=@ProductsId and ProcessStatus<>1;?if @VCOUNT > 0? BEGIN? ? update Base_Gx_ProductsInfo set Status= 3 ,ProcessStatus=1? Where ProductsId=@ProductsIdupdate Base_Gx_ProductsInfo set Base_Gx_ProductsInfo.ProcessStatus=1, Base_Gx_ProductsInfo.Status = case when b.ProductsName is null then 0 else 1 end from Base_Gx_ProductsInfo as ainner join Base_CustomerInfo as c on a.customerId=c.customerIdleft join Base_State_ProductsInfo as b on a.ProductsName=b.ProductsName and c.CompanyName=b.CompanyName? Where A.ProductsId=@ProductsId? SET @out_msg = '提交成功！'? SET @out_result = 100 ? ? ENDELSE?BEGIN? SET @out_msg = '未找到記錄或產品已提交過！'? SET @out_result = 99? ?ENDEnd