/** -- ========================= 系统升级SQL (为了方便系统升级代码写入的问题,增加该SQL) 目的是为了方便JFlow CCFlow 的统一版本升级. **/ -- 升级旧版本，删除连接线, 如果升级到这里有错误，就需要删除重复的连接线.; UPDATE WF_Direction set mypk=replace(mypk, '_0','') ; -- 更新数据类型. ALTER TABLE Sys_MapExt MODIFY COLUMN DoWay varchar(50) NULL; -- ALTER TABLE Sys_MapExt MODIFY column DoWay VARCHAR(100); DELETE FROM Sys_Enum where enumkey='SearchUrlOpenType'; DELETE FROM Sys_MapAttr WHERE KeyOfEn='MyNum'; UPDATE Sys_MapAttr SET IsSupperText=1 WHERE (IsSupperText=0 OR IsSupperText IS NULL ) AND MyDataType=7; UPDATE Sys_MapData SET FK_FormTree='' WHERE No LIKE 'ND%'; DELETE FROM Sys_Enum WHERE EnumKey ='RefMethodType'; DELETE FROM Sys_Enum WHERE EnumKey ='RunModel'; DELETE FROM Sys_Enum WHERE EnumKey ='RefMethodWinOpenModel'; DELETE FROM Sys_Enum WHERE EnumKey ='FrmType'; DELETE FROM Sys_Enum WHERE EnumKey ='ShowWhere'; DELETE FROM Sys_Enum WHERE EnumKey ='OpenModel'; DELETE FROM Sys_Enum WHERE EnumKey ='SelectorModel'; DELETE FROM Sys_Enum WHERE EnumKey ='SrcType'; DELETE FROM Sys_Enum WHERE EnumKey ='CondModel'; DELETE FROM Sys_Enum WHERE EnumKey ='FrmTrackSta'; DELETE FROM Sys_Enum WHERE EnumKey ='EventDoType'; DELETE FROM Sys_Enum WHERE EnumKey ='EditModel'; DELETE FROM Sys_Enum WHERE EnumKey ='AthRunModel'; -- 更新枚举值; DELETE FROM Sys_Enum WHERE EnumKey ='CodeStruct'; DELETE FROM Sys_Enum WHERE EnumKey ='DBSrcType'; DELETE FROM Sys_Enum WHERE EnumKey ='TBModel'; DELETE FROM Sys_Enum WHERE EnumKey ='FrmType'; DELETE FROM Sys_Enum WHERE EnumKey ='WebOfficeEnable'; DELETE FROM Sys_Enum WHERE EnumKey ='FrmEnableRole'; DELETE FROM Sys_Enum WHERE EnumKey ='BlockModel'; DELETE FROM Sys_Enum WHERE EnumKey ='FWCType'; DELETE FROM Sys_Enum WHERE EnumKey ='SelectAccepterEnable'; DELETE FROM Sys_Enum WHERE EnumKey ='NodeFormType'; DELETE FROM Sys_Enum WHERE EnumKey ='StartGuideWay'; DELETE FROM Sys_Enum WHERE EnumKey ='StartLimitRole'; DELETE FROM Sys_Enum WHERE EnumKey ='BillFileType'; DELETE FROM Sys_Enum WHERE EnumKey ='EventDoType'; DELETE FROM Sys_Enum WHERE EnumKey ='FormType'; DELETE FROM Sys_Enum WHERE EnumKey ='BatchRole'; DELETE FROM Sys_Enum WHERE EnumKey ='StartGuideWay'; DELETE FROM Sys_Enum WHERE EnumKey ='NodeFormType'; DELETE FROM Sys_Enum WHERE EnumKey ='FrmType'; DELETE FROM Sys_Enum WHERE EnumKey ='FTCSta'; DELETE FROM Sys_Enum WHERE EnumKey ='SrcType'; DELETE FROM Sys_Enum WHERE EnumKey IN ('TodolistModel','CCStaWay','TWay' ); DELETE FROM Sys_GloVar WHERE GroupKey='DefVal'; INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('0','选择系统约定默认值','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.No','登陆人员账号','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.Name','登陆人员名称','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.FK_Dept','登陆人员部门编号','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.FK_DeptName','登陆人员部门名称','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.FK_DeptFullName','登陆人员部门全称','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@yyyy年MM月dd日','当前日期(yyyy年MM月dd日)','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@yyyy年MM月dd日HH时mm分','当前日期(yyyy年MM月dd日HH时mm分)','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@yy年MM月dd日','当前日期(yy年MM月dd日)','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@yy年MM月dd日HH时mm分','当前日期(yy年MM月dd日HH时mm分)','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@FK_ND','当前年度','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@FK_YF','当前月份','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.OrgNo','登录人员组织','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.OrgName','登录人员组织名称','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.EmpLeader','直属领导EmpLeader','DefVal'); INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.DeptLeader','部门领导DeptLeader','DefVal'); -- 更新日期长度.; UPDATE SYS_MAPATTR SET UIWidth=125 WHERE MYDATATYPE=6; UPDATE SYS_MAPATTR SET UIWidth=145 WHERE MYDATATYPE=7; -- 2020.10.27 为enCfg设置页面设置分组; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%.Sys.EnCfg'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.Sys.EnCfg','@No=基础信息,基础信息权限信息.@BtnsShowLeft=工具栏按钮@SearchUrlOpenType=双击/单击弹窗@'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.Sys.EnCfg','@No=基础信息,基础信息权限信息.@BtnsShowLeft=工具栏按钮@SearchUrlOpenType=双击/单击弹窗@'); -- 2016.11.18 升级维护附件属性.; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%.FrmAttachmentExt'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.Sys.FrmUI.FrmAttachmentExt','@MyPK=基础信息,附件的基本配置.@DeleteWay=权限控制,控制附件的下载与上传权限.@IsToHeLiuHZ=流程相关,控制节点附件的分合流.@IsEnableTemplate=附件模板,附件模板下载是否启用？.'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.Sys.FrmUI.FrmAttachmentExt','@MyPK=基础信息,附件的基本配置.@DeleteWay=权限控制,控制附件的下载与上传权限.@IsToHeLiuHZ=流程相关,控制节点附件的分合流.@IsEnableTemplate=附件模板,附件模板下载是否启用？.'); -- 2020.02.25 升级明细表维护分组.; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%.MapDtlExt'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.Frm.MapDtlExt','@No=基础信息,基础信息权限信息.@IsEnableLink=超链接,显示在从表的右边.@IsCopyNDData=流程相关,与流程相关的配置非流程可以忽略.'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.WF.Template.Frm.MapDtlExt','@No=基础信息,基础信息权限信息.@IsEnableLink=超链接,显示在从表的右边.@IsCopyNDData=流程相关,与流程相关的配置非流程可以忽略.'); -- DELETE FROM Sys_EnCfg WHERE No LIKE '%.FrmNodeComponent'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.FrmNodeComponent','@NodeID=审核组件,适用于sdk表单审核组件与ccform上的审核组件属性设置.@SFLab=父子流程组件,在该节点上配置与显示父子流程.@FrmThreadLab=子线程组件,对合流节点有效，用于配置与现实子线程运行的情况。@FrmTrackLab=轨迹组件,用于显示流程运行的轨迹图.@FTCLab=流转自定义,在每个节点上自己控制节点的处理人.'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.WF.Template.FrmNodeComponent','@NodeID=审核组件,适用于sdk表单审核组件与ccform上的审核组件属性设置.@SFLab=父子流程组件,在该节点上配置与显示父子流程.@FrmThreadLab=子线程组件,对合流节点有效，用于配置与现实子线程运行的情况。@FrmTrackLab=轨迹组件,用于显示流程运行的轨迹图.@FTCLab=流转自定义,在每个节点上自己控制节点的处理人.'); -- 傻瓜表单属性; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%.MapFrmFool'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.Frm.MapFrmFool','@No=基础属性,基础属性.@Designer=设计者信息,设计者的单位信息，人员信息，可以上传到表单云.'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.WF.Template.Frm.MapFrmFool','@No=基础属性,基础属性.@Designer=设计者信息,设计者的单位信息，人员信息，可以上传到表单云.'); -- 字段属性 String ; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%MapAttrString'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.Sys.FrmUI.MapAttrString','@MyPK=基础,基础属性，数据属性.@ColSpan=外观,傻瓜表单属性，外观.'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.Sys.FrmUI.MapAttrString','@MyPK=基础,基础属性，数据属性.@ColSpan=外观,傻瓜表单属性，外观.'); -- 字段属性 Num ; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%MapAttrNum'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.Sys.FrmUI.MapAttrNum','@MyPK=基础,基础属性，数据属性.@ColSpan=外观,傻瓜表单属性，外观.'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.Sys.FrmUI.MapAttrNum','@MyPK=基础,基础属性，数据属性.@ColSpan=外观,傻瓜表单属性，外观.'); -- 枚举; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%MapAttrEnum'; I-- NSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.Sys.FrmUI.MapAttrEnum','@MyPK=基础,基础属性，数据属性.@ColSpan=外观,傻瓜表单属性，外观.'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.Sys.FrmUI.MapAttrEnum','@MyPK=基础,基础属性，数据属性.@ColSpan=外观,傻瓜表单属性，外观.'); -- 2018.07.24 @FlowDTSWay=流程数据与业务数据同步; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%FlowExt'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.FlowExt','@No=基础信息,基础信息权限信息.@IsBatchStart=数据&表单,数据导入导出.@IsFrmEnable=轨迹'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.WF.Template.FlowExt','@No=基础信息,基础信息权限信息.@IsBatchStart=数据&表单,数据导入导出.@IsFrmEnable=轨迹'); -- 按钮权限; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%BtnLab'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.BtnLab', -- '@NodeID=按钮权限,控制工作节点可操作按钮.@ReturnLab=退回规则,退回规则设置.@PrintHtmlLab=打印按钮,常用的打印设置.@HuiQianLab=会签按钮,设置会签模式一般与审核组件一起工作.'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.WF.Template.BtnLab', -- '@NodeID=按钮权限,控制工作节点可操作按钮.@ReturnLab=退回规则,退回规则设置.@PrintHtmlLab=打印按钮,常用的打印设置.@HuiQianLab=会签按钮,设置会签模式一般与审核组件一起工作.'); -- 新版本的流程属性,节点属性; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%NodeExt'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.NodeExt', -- '@NodeID=基本配置,基础属性配置.@RunModel=运行模式@AutoJumpRole0=跳转,自动跳转规则当遇到该节点时如何让其自动的执行下一步.@SendLab=按钮权限,控制工作节点可操作按钮.@ReturnLab=退回规则,退回规则设置.@PrintHtmlLab=打印按钮,常用的打印设置.@HuiQianLab=会签按钮,设置会签模式一般与审核组件一起工作.'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.WF.Template.NodeExt', -- '@NodeID=基本配置,基础属性配置.@RunModel=运行模式@AutoJumpRole0=跳转,自动跳转规则当遇到该节点时如何让其自动的执行下一步.@SendLab=按钮权限,控制工作节点可操作按钮.@ReturnLab=退回规则,退回规则设置.@PrintHtmlLab=打印按钮,常用的打印设置.@HuiQianLab=会签按钮,设置会签模式一般与审核组件一起工作.'); -- DELETE FROM Sys_EnCfg WHERE No LIKE '%MapDataExt'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.Frm.MapDataExt','@No=基本属性@Designer=设计者信息'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.WF.Template.Frm.MapDataExt','@No=基本属性@Designer=设计者信息'); UPDATE Sys_MapData SET AppType=0 WHERE No NOT LIKE 'ND%'; -- 旧版本的流程属性; -- DELETE FROM Sys_EnCfg WHERE No='BP.WF.Template.NodeSheet'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.NodeSheet','@NodeID=基本配置@FormType=表单@FWCSta=审核组件,适用于sdk表单审核组件与ccform上的审核组件属性设置.@SFSta=父子流程,对启动，查看父子流程的控件设置.@SendLab=按钮权限,控制工作节点可操作按钮.@RunModel=运行模式,分合流,父子流程@AutoJumpRole0=跳转,自动跳转规则当遇到该节点时如何让其自动的执行下一步.@MPhone_WorkModel=移动,与手机平板电脑相关的应用设置.@OfficeOpen=公文按钮,只有当该节点是公文流程时候有效'); -- DELETE FROM Sys_EnCfg WHERE No='BP.WF.Template.FlowSheet'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.FlowSheet','@No=基本配置@FlowRunWay=启动方式,配置工作流程如何自动发起，该选项要与流程服务一起工作才有效.@StartLimitRole=启动限制规则@StartGuideWay=发起前置导航@CFlowWay=延续流程@DTSWay=流程数据与业务数据同步@PStarter=轨迹查看权限'); -- 2016.07 升级数据源; UPDATE Sys_SFTable SET FK_SFDBSrc='local' WHERE FK_SFDBSrc IS NULL OR FK_SFDBSrc=''; -- UPDATE Sys_SFTable SET SrcType=0 WHERE SrcType IS NULL ; -- UPDATE Sys_MapAttr SET ColSpan=4 WHERE ColSpan>=3; -- 2019.03.10 ; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%.FrmBill'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.CCBill.FrmBill','@No=基础信息,单据基础配置信息.@Designer=设计者,流程开发设计者信息'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.CCBill.FrmBill','@No=基础信息,单据基础配置信息.@Designer=设计者,流程开发设计者信息'); -- 2019.05.15 ; -- DELETE FROM Sys_EnCfg WHERE No LIKE '%.FrmDict'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.CCBill.FrmDict','@No=基础信息,单据基础配置信息.@Designer=设计者,流程开发设计者信息'); -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('TS.CCBill.FrmDict','@No=基础信息,单据基础配置信息.@Designer=设计者,流程开发设计者信息'); -- 2020.04.27 -- DELETE FROM Sys_EnCfg WHERE No='BP.WF.Template.FrmNodeExt'; -- INSERT INTO Sys_EnCfg(No,GroupTitle) VALUES ('BP.WF.Template.FrmNodeExt','@MyPK=基础信息,表单关系配置.@IsEnableFWC=流程组件'); -- 2019.5.23; DELETE FROM Sys_Enum WHERE EnumKey ='CondModel'; INSERT INTO Sys_Enum(MyPK,Lab,EnumKey,IntKey,Lang) VALUES('CondModel_CH_0','由连接线条件控制','CondModel',0,'CH'); INSERT INTO Sys_Enum(MyPK,Lab,EnumKey,IntKey,Lang) VALUES('CondModel_CH_1','按照用户选择计算','CondModel',1,'CH'); INSERT INTO Sys_Enum(MyPK,Lab,EnumKey,IntKey,Lang) VALUES('CondModel_CH_2','发送按钮旁下拉框选择','CondModel',2,'CH');