Delete from t_AP_DeskItem where FName='APPFC001' and FUserID=16394

insert into t_AP_DeskItem 

(FUserID, FIndex, FName, FCaption, FFuncID, FImage, FInfo, FLeft, FTop, FOpenAction, FOpenParam)

values

(16394,'100','APPFC001','成本核算','APPFC001','',

'FID=APPFC001|FProductCode=APPFC001|FDownloadURL=|FOpenAction=2|FOpenParam=FileType=3;FileClass=D:成本核算2022$APPFC001.ico',

'','',2,'FileType=3;FileClass=D:成本核算2022;ExeName=成本核算.exe')

Delete from t_AP_Application where FName='APPFC001' 

insert into t_AP_Application 

(FID, FName, FCaption,  FUpdateDate, FCurrentDate,  FFlag, FIsFree, FIsBuy, FGroupID, FOpenAction, FOpenParam, 

FSortIndex, FBuyUrl, FAppType, FAddType, FAppPosition)

values

('APPFC001','APPFC001','成本核算','2022-01-01 00:00:00','2022-01-01 00:00:00',0,1,0,0,2,

'FileType=3;FileClass=D:成本核算2022;ExeName=成本核算.exe',0,

'http://pay.cmcloud.cn/app/showProduct.do?action=buy&shelfId=79489269145',3,0,1)

--把EXE文件增加到软件里

【成本核算2022 】 为文件夹名，放在D盘下，【 成本核算.exe 】为 执行文件名 把两个替换下自己程序的名称在执行语句

Delete from t_ObjectType where FObjectType=100000 AND FObjectID=6

insert into t_ObjectType 

(FObjectType, FObjectID, FName, FDescription, FName_cht, FName_en,  FIsdefined, FAppID)

values

(100000,6,'成本核算','成本核算','成本核算','Defined Report',1,'APPFC001')

--增加授权表权限

Delete from t_ObjectAccessType where FObjectID=6

insert into t_ObjectAccessType 

(FObjectType, FObjectID, FIndex, FAccessMask, FAccessUse, FName, FDescription, FName_cht, FName_en,  FDescription_cht, FDescription_en, FIsdefined)

values

(100000,6,0,1048576,0,'查看','可查看信息','查看','View','可查看信息','Can View Information',1)

insert into t_ObjectAccessType 

(FObjectType, FObjectID, FIndex, FAccessMask, FAccessUse, FName, FDescription, FName_cht, FName_en,  FDescription_cht, FDescription_en, FIsdefined)

values

(100000,6,1,8192,1048576,'打印','可打印对象','列印','Print','可列印對象','Can Print Object',1)

insert into t_ObjectAccessType 

(FObjectType, FObjectID, FIndex, FAccessMask, FAccessUse, FName, FDescription, FName_cht, FName_en,  FDescription_cht, FDescription_en, FIsdefined)

values

(100000,6,2,16384,1048576,'引出','可引出数据','引出','Export','可引出數據','Can Export data',1)

--增加授权表权限明细