python获取选中行,执行sql或存储过程批量处理数据

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

python获取选中行,执行sql或存储过程批量处理数据

引入clr运行库
import clr
#添加对cloud插件开发的常用组件的引用
clr.AddReference(‘System’)
clr.AddReference(‘System.Data’)
clr.AddReference(‘Kingdee.BOS’)
clr.AddReference(‘Kingdee.BOS.Core’)
clr.AddReference(‘Kingdee.BOS.App’)
clr.AddReference(‘Kingdee.BOS.ServiceHelper’)
#导入cloud基础库中的常用实体对象
from Kingdee.BOS import *
from Kingdee.BOS.Core import *
from Kingdee.BOS.Core.Bill import *
from Kingdee.BOS.Core.DynamicForm.PlugIn import *
from Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel import *
from System import *
from System.Data import *
from Kingdee.BOS.App.Data import *
from Kingdee.BOS.ServiceHelper import *

def BarItemClick(e):
    btnKey = e.BarItemKey.ToUpper();
    if (btnKey == “TBUPDATED”):
    selectRows = this.ListView.SelectedRowsInfo;
    ID = selectRows.GetPrimaryKeyValues();
    if (ID.Length == 0):
    this.View.ShowMessage(“请选择单据!”, MessageBoxType.Notice);
    return;

    DBUtils.Execute(this.Context, str.Format(Sql, str.Join(",", ID)));


python获取选中行,执行sql或存储过程批量处理数据

引入clr运行库 import clr #添加对cloud插件开发的常用组件的引用 clr.AddReference(‘System’) clr.AddReference(‘System.Data’)...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息