合同会签流程SQL

2019-09-29 0 条评论 10 次阅读 0 人点赞

--项目流程发起SQL
UPDATE CT_Countersign SET Status='处理中',StatusId=1 WHERE SysId = '[EntityID]';

--总部流程发起SQL
UPDATE CT_Countersign SET Status='处理中',StatusId=1,ToHeadquarters='1' WHERE SysId = '[EntityID]';

--项目流程走总部审批SQL
UPDATE CT_Countersign SET ToHeadquarters='1' WHERE SysId = '[EntityID]';

--流程结束SQL
UPDATE CT_Countersign SET ApprovalEnd = GETDATE(),Status='会签结束',StatusId=99 WHERE SysId = '[EntityID]';
EXEC Proc_CT_ExportToCTIO '[EntityID]';

ALTER TABLE CT_Countersign ADD ApprovalEnd [datetime] NULL
EXEC sp_addextendedproperty N'MS_Description', N'审批结束时间', 'SCHEMA', N'dbo', 'TABLE', N'CT_Countersign', 'COLUMN', N'ApprovalEnd'

ALTER TABLE CT_Countersign ADD ToHeadquarters [datetime] NULL
EXEC sp_addextendedproperty N'MS_Description', N'是否到总部', 'SCHEMA', N'dbo', 'TABLE', N'CT_Countersign', 'COLUMN', N'ToHeadquarters'

ALTER TABLE CT_Countersign ALTER COLUMN CoTargetName varchar(100)

JS
CT\CTO

XML
D:\SVN\HLSVN_030\trunk\HiPortal\BusinessApp\service\CT\CT_Countersign_Custom.xml

BOID
CT_Countersign

root

这个人太懒什么东西都没留下

文章评论(0)