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.
66 lines
2.1 KiB
66 lines
2.1 KiB
------------------------------------
|
|
--用途：修改一???
|
|
--?目名?：
|
|
--?明：
|
|
--??：2015/11/2 下午 05:38:35
|
|
------------------------------------
|
|
ALTER PROCEDURE [dbo].[OSP_OTB_SAL_BusinessChance_Update]
|
|
@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
|
|
UPDATE [OTB_SAL_BusinessChance]
|
|
SET [ProjectName] = @ProjectName ,
|
|
[Department] = @Department ,
|
|
[Person] = @Person ,
|
|
[ContractCustomers] = @ContractCustomers ,
|
|
[ActualCustomer] = @ActualCustomer ,
|
|
[ProjectContent] = @ProjectContent ,
|
|
[OpenTo] = @OpenTo ,
|
|
[OpenToAuthority] = @OpenToAuthority ,
|
|
[PartDeptName] = @PartDeptName ,
|
|
[Status] = @Status ,
|
|
[UndoneReason] = @UndoneReason ,
|
|
[GetOrderDate] = @GetOrderDate ,
|
|
[DeliveryDate] = @DeliveryDate ,
|
|
[AcceptanceDate] = @AcceptanceDate ,
|
|
[Confidence] = @Confidence ,
|
|
[AllAmounts] = @AllAmounts ,
|
|
[OutCosts] = @OutCosts ,
|
|
[InsideCosts] = @InsideCosts ,
|
|
[Profit] = @Profit ,
|
|
[Memo] = @Memo ,
|
|
[AttachmentID] = @AttachmentID ,
|
|
[ModifyUser] = @ModifyUser ,
|
|
[ModifyDate] = GETDATE(),
|
|
CustomerID=@CustomerID,
|
|
PrjType=@PrjType
|
|
WHERE OrganizationID = @OrganizationID
|
|
AND CaseID = @CaseID
|
|
|