WebApi.案例.查询单据转换规则

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

WebApi.案例.查询单据转换规则

【场景】WebApi 查询单据转换规则 【案例】 表单标识 单据转换规则 BOS_ConverRule <1>根据名称查询 ```json { "FormId": "BOS_ConvertRule", "FieldKeys": "FNumber,FName", "FilterString": [ { "Left": "(", "FieldName": "FName", "Compare": "=", "Value": "采购申请单至采购订单-仅携带", "Right": ")", "Logic": "and" } ], "OrderString": "", "TopRowCount": 0, "StartRow": 0, "Limit": 2000, "SubSystemId": "" } ``` ![image.webp](/download/010095ea6249e0694b42afdff7983e7ad053.webp) ![Image_20230208104140.webp](/download/01006e8f40d95c20495cac3bfca8439c979b.webp) <2>根据源单标识和目标单标识查询 a)打开设计器,表单BOS_ConverRule,扩展增加两个文本字段,字段名指向fsourceformid, ftargetformid (需要修改字段的存储类型为varchar) ![Image_20230208104441.webp](/download/0100421d247b7ca24a49ad1edcf8c1007091.webp) ![Image_20230208104555.webp](/download/01006914f15e34d64009959251678bb4d6b8.webp) ```json { "FormId": "BOS_ConvertRule", "FieldKeys": "FNumber,FName", "FilterString": [ { "Left": "(", "FieldName": "F_Jac_TextSrc", "Compare": "=", "Value": "PUR_Requisition", "Right": ")", "Logic": "and" }, { "Left": "(", "FieldName": "F_Jac_TextTgt", "Compare": "=", "Value": "PUR_PurchaseOrder", "Right": ")", "Logic": "and" }, ], "OrderString": "", "TopRowCount": 0, "StartRow": 0, "Limit": 2000, "SubSystemId": "" } ``` ![Image_20230208105058.webp](/download/0100c66bbdece5d549b188c987c764cc8e6b.webp) 【备注】其他字段查询的逻辑同<2>,需要自行增加字段,物理表t_meta_convertrule

WebApi.案例.查询单据转换规则

【场景】WebApi 查询单据转换规则【案例】表单标识 单据转换规则 BOS_ConverRule<1>根据名称查询```json{ "FormId": "BOS_Conve...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息