临保项目人员导入 __DXZvc8mnEmDqMARhK7G __DXZvc8mnEmDqMARhK7G 16 2048 1536 rollback 1730372147228 人员名单 0 468 324 142 34 project_person 1730372176441 姓名 0 364 221 142 34 name false 1730372176884 性别 0 524 218 142 34 sex false 1730372177161 手机号 0 678 221 142 34 phone false 1730372178803 证件类型 0 761 321 142 34 id_number_type false 1730372179313 证件号码 0 741 421 142 34 id_number false //在表单控件值脚本中获取当前文档对象 (function(){ var process = getDocumentProcess(); var doc=getCurrentDocument(); doc.findItem(@quot;project_id@quot;).setValue(getRelateDocument().getId()) var person_type = doc.findItem(@quot;person_type@quot;).getValue() var domain_name = doc.findItem(@quot;domain_name@quot;).getValue() var id_number = doc.findItem(@quot;id_number@quot;).getValue() if(!@quot;外部人员@quot;.equals(person_type)){ var item_userID=@quot;@quot;; var sql=@quot;select item_userID from vw_employee where item_documentID='@quot;+id_number+@quot;' and ITEM_companyName='@quot;+domain_name+@quot;' @quot; var datas = queryByDSName(@quot;baibaodunFlow@quot;,sql); if(datas.size()@gt;0){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 item_userID= map1.get(@quot;item_userID@quot;); } } doc.findItem(@quot;person_id@quot;).setValue(item_userID) } })() 1730372179733 人员类型 0 503 450 142 34 person_type false 1730372180611 所属公司 0 341 421 142 34 domain_name false 1730372221951 是否持证 0 261 347 142 34 is_certified false 1730372242051 职业类型 0 266 274 142 34 occupation_type false 1730372176884 1730372147228 false false 468;324;524;218 1730372380802 1730372177161 1730372147228 false false 468;324;678;221 1730372383037 1730372178803 1730372147228 false false 468;324;761;321 1730372386839 1730372179313 1730372147228 false false 468;324;741;421 1730372389111 1730372179733 1730372147228 false false 468;324;503;450 1730372391728 1730372180611 1730372147228 false false 468;324;341;421 1730372394295 1730372221951 1730372147228 false false 468;324;261;347 1730372396439 1730372242051 1730372147228 false false 468;324;266;274 1730372398809 1730372176441 1730372147228 false false 468;324;364;221 1730372400939 ]]> /uploads/exceltemplate/项目人员导入.xlsx