OPMS/02-系統分析、設計階段/DBScript/20151123/OSP_OTB_SAL_BusinessChance_ADD.sql

------------------------------------
--�γ~�G�W�[�@??? 
--?�ئW?�G
--?���G
--??�G2015/11/2 �U�� 05:38:35
------------------------------------
ALTER PROCEDURE [dbo].[OSP_OTB_SAL_BusinessChance_ADD]
    @OrganizationID VARCHAR(50) ,
    @CaseID VARCHAR(10) ,
    @ProjectName NVARCHAR(200) ,
    @Department VARCHAR(10) ,
    @Person VARCHAR(50) ,
    @ContractCustomers NVARCHAR(100) ,
    @ActualCustomer NVARCHAR(100) ,
    @ProjectContent NVARCHAR(MAX) ,
    @OpenTo CHAR(1) ,
    @OpenToAuthority VARCHAR(100) ,
    @PartDeptName NVARCHAR(MAX) ,
    @Status VARCHAR(20) ,
    @UndoneReason NVARCHAR(200) ,
    @GetOrderDate DATETIME ,
    @DeliveryDate DATETIME ,
    @AcceptanceDate DATETIME ,
    @Confidence INT ,
    @AllAmounts INT ,
    @OutCosts INT ,
    @InsideCosts INT ,
    @Profit INT ,
    @Memo NTEXT ,
    @AttachmentID VARCHAR(36) ,
    @CreateUser VARCHAR(50) ,
    @CreateDate DATETIME ,
    @ModifyUser VARCHAR(50) ,
    @ModifyDate DATETIME,
    @CustomerID VARCHAR(50),
    @PrjType NVARCHAR(50)
AS 
    INSERT  INTO [OTB_SAL_BusinessChance]
            ( [OrganizationID] ,
              [CaseID] ,
              [ProjectName] ,
              [Department] ,
              [Person] ,
              [ContractCustomers] ,
              [ActualCustomer] ,
              [ProjectContent] ,
              [OpenTo] ,
              [OpenToAuthority] ,
              [PartDeptName] ,
              [Status] ,
              [UndoneReason] ,
              [GetOrderDate] ,
              [DeliveryDate] ,
              [AcceptanceDate] ,
              [Confidence] ,
              [AllAmounts] ,
              [OutCosts] ,
              [InsideCosts] ,
              [Profit] ,
              [Memo] ,
              [AttachmentID] ,
              [CreateUser] ,
              [CreateDate] ,
              [ModifyUser] ,
              [ModifyDate],
              CustomerID,
              PrjType
	        )
    VALUES  ( @OrganizationID ,
              @CaseID ,
              @ProjectName ,
              @Department ,
              @Person ,
              @ContractCustomers ,
              @ActualCustomer ,
              @ProjectContent ,
              @OpenTo ,
              @OpenToAuthority ,
              @PartDeptName ,
              @Status ,
              @UndoneReason ,
              @GetOrderDate ,
              @DeliveryDate ,
              @AcceptanceDate ,
              @Confidence ,
              @AllAmounts ,
              @OutCosts ,
              @InsideCosts ,
              @Profit ,
              @Memo ,
              @AttachmentID ,
              @CreateUser ,
              GETDATE() ,
              @CreateUser ,
              GETDATE(),
              @CustomerID,
              @PrjType
	        )