来源功能务的日志信息)
pull 拉取(其它表数据更新到本表)
push 推送(本表数据推送到其它表)
sync 同步(本表数据同步到其它服务接口)
task 任务(执行特定的定时任务或周期事务)
process 进度(事务的执行进度)
log 日志(事务的日志信息)务的日志信息)
功能使用配置
/// <summary>
/// 来源功能 pull 拉取(其它表数据更新到本表) push 推送(本表数据推送到其它表) sync 同步(本表数据同步到其它服务接口) task 任务(执行特定的定时任务或周期事务)
/// </summary>
public string FromExecAction { get; set; }
/// <summary>
/// 忽略替换的关键字 a.project_id=@projectId and
/// </summary>
public string FromIgnoreWord { get; set; }
/// <summary>
/// 执行一次 once:true 设置isOnleExecOnce=true 忽略:need:false 设置 need=[]
/// </summary>
public string FromIgnoreNeed { get; set; }
/// <summary>
/// 忽略的字段, projectId 逗号分割
/// </summary>
public string FromIgnoreField { get; set; }
"saveSqlExtand": {
"pm-project-info-update-ht-hk": {
"fromExecAction":"push",
"fromIgnoreWord":"a.project_id=@projectId and",
"fromIgnoreNeed":"",
"fromIgnoreField":"",
"target":"项目订单/合同",
"need": [
{
"field": "projectId",
"value": ""
}
],
"sortId": 30,
"sqlUpdate": "UPDATE pm_project_ht_hk_info a,pm_project_info b SET a.project_name =b.project_name,a.invoice_cycle =b.invoice_cycle,a.ht_status =b.ht_status where a.project_id=@projectId and a.project_id=b.project_id",
"sqlInsert": null,
"connName": "ConnPM"
}
},
文档更新时间: 2025-04-05 20:11 作者:admin