/** -- ========================= 系统升级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','直属领导','DefVal');
INSERT INTO Sys_GloVar (No,Name,GroupKey) VALUES ('@WebUser.DeptLeader','部门领导','DefVal');

 
-- 升级数据源 2016.;
UPDATE Sys_SFTable SET SrcType=0 WHERE No LIKE '%.%';
UPDATE Sys_SFTable SET SrcType=1 WHERE No NOT LIKE '%.%' AND SrcType=0;

-- 更新日期长度.;
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');