Python实现报表联查单据
一、【使用场景】: 二开一张简单账表,双击明细行,通过python脚本实现联查单据
二、【代码示例】:
import clr clr.AddReference("System") clr.AddReference("System.Core") clr.AddReference("Kingdee.BOS") clr.AddReference("Kingdee.BOS.Core") clr.AddReference("Kingdee.BOS.DataEntity") clr.AddReference("Kingdee.BOS.ServiceHelper") from System import * from System.Collections.Generic import * from System.ComponentModel import * from Kingdee.BOS.Core.Bill import * from Kingdee.BOS.Core.DynamicForm import * from Kingdee.BOS.Core.DynamicForm.PlugIn.Args import * from Kingdee.BOS.Core.Metadata import * from Kingdee.BOS.Core.Metadata.FormElement import * from Kingdee.BOS.Core.Permission import * from Kingdee.BOS.Core.Report import * from Kingdee.BOS.Core.Report.PlugIn import * from Kingdee.BOS.Core.Report.PlugIn.Args import * from Kingdee.BOS.Core.SqlBuilder import * from Kingdee.BOS.Orm.DataEntity import * from Kingdee.BOS.ServiceHelper import * from Kingdee.BOS.Resource import * def CellDbClick(e): fbillNo = str(this.View.GetCurrentRowValue("FBILLNO")) formId = str(this.View.GetCurrentRowValue("FFORMID")) fm = MetaDataServiceHelper.GetFormMetaData(this.View.Context, formId) form = fm.BusinessInfo.GetForm() param = QueryBuilderParemeter() param.FormId = formId param.FilterClauseWihtKey = "FBILLNO = '" + fbillNo + "'" # 获取到单据内码 param.BusinessInfo = fm.BusinessInfo tolist = List[SelectorItemInfo]() tolist.Add(SelectorItemInfo(form.PkFieldName)) param.SelectItems = tolist dynObjs = QueryServiceHelper.GetDynamicObjectCollection(this.View.Context, param) # 联查单据展示 para = BillShowParameter() para.OpenStyle.ShowType = ShowType.MainNewTabPage para.FormId = formId para.Status = OperationStatus.VIEW para.PKey = str(dynObjs[0]["FID"]) this.View.ShowForm(para)
二、【实现效果】:
以上分析及处理方案是一些个人的理解,如有不对之处,还请指正。
Python实现报表联查单据
一、【使用场景】: 二开一张简单账表,双击明细行,通过python脚本实现联查单据二、【代码示例】:import clrclr.AddReference("System")c...
点击下载文档
本文2024-09-23 02:55:21发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-155556.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
- 鼎捷API-T100-5.生产信息API-查询当站下线单列表数据-t100.oapi.wo.report.stockin.list.data.query.get-wssp00301CN02_s.pdf
- 鼎捷API-T100-4.物流信息API-审核杂收单-t100.oapi.other.in.inventory.data.approve-wssp00230CN02_s.pdf
- 鼎捷API-T100-2.采购信息API-更新采购变更单数据-t100.oapi.purchase.change.data.update-wssp00086CN02_s.pdf
- 鼎捷API-T100-1.企业基础API-更新员工数据-t100.oapi.employee.data.update-wssp00005CN02_s.pdf
- 鼎捷API-T100-1.企业基础API-创建BOM数据-t100.oapi.bom.data.create-wssp00348CN02_s.pdf
- 鼎捷API-T100-1.企业基础API-取消确认机器数据-t100.oapi.machine.data.disapprove-wssp00047CN02_s.pdf
- 鼎捷API-T100-1.企业基础API-删除付款条件数据-t100.oapi.payment.condition.data.delete-wssp00337CN02_s.pdf
- 鼎捷API-T100-5.生产信息API-撤销审核工单当站入库数据-t100.oapi.wo.report.stockin.data.disapprove-wssp00304CN02_s.pdf
- 鼎捷API-T100-1.企业基础API-查询机器列表数据-t100.oapi.machine.list.data.query.get-wssp00044CN02_s.pdf
- 鼎捷API-T100-2.采购信息API-查询采购单列表数据-t100.oapi.purchase.order.list.data.query.get-wssp00157CN02_s.pdf
热门文章