You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
99 lines
2.7 KiB
99 lines
2.7 KiB
------------------------------------
|
|
--用途：增加一???
|
|
--?目名?：
|
|
--?明：
|
|
--??：2015/11/2 下午 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
|
|
)
|
|
|