预置基础资料同步供应商插件

admin

执行储存过程

1. CREATE PROCEDURE SP_jczi
   
2. AS
   
3. BEGIN
   
4. TRUNCATE TABLE  T_BAS_PREBDONE
   
5. TRUNCATE TABLE T_BAS_PREBDONE_L
   
6. --插入编码基础资料
   
7. insert into T_BAS_PREBDONE (FID,FMasterId,FCREATEORGID,FUSEORGID,FNUMBER,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FFORBIDSTATUS,FDOCUMENTSTATUS)
   
8. select FSUPPLIERID AS FID,FMasterId,FCREATEORGID,FUSEORGID,FNUMBER,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FFORBIDSTATUS,FDOCUMENTSTATUS from t_BD_Supplier
   
9. --插入基础资料名称
   
10. insert into T_BAS_PREBDONE_L(FPKID,FID,FLocaleID,FNAME)
    
11. select FPKID,FSUPPLIERID AS FID,FLocaleID,FNAME from T_BD_SUPPLIER_L
    
12. END

复制代码

执行Python代码

1. # 引入 clr 运行库
   
2. import clr
   
3. clr.AddReference("Kingdee.BOS.Core")
   
4. clr.AddReference("Kingdee.BOS.App")
   
5. clr.AddReference("Kingdee.BOS")
   
6. 
   
7. # 添加对 cloud 插件开发的常用组件的引用
   
8. from Kingdee.BOS.Core.Bill.PlugIn import *
   
9. from Kingdee.BOS.Core.Bill.PlugIn.Args import *
   
10. from Kingdee.BOS.Core.DynamicForm.PlugIn.Args import *
    
11. from Kingdee.BOS.App.Data import *
    
12. 
    
13. def AfterBarItemClick(e):
    
14.     # 判断点击审核按钮（菜单和列表一致）
    
15.     if e.BarItemKey == "tbSplitApprove" or e.BarItemKey == "tbApprove":
    
16.         # 执行 MSSQL 存储过程
    
17.         DBUtils.Execute(this.Context, "/*dialect*/exec SP_jczi")

复制代码