UPDATE `sys006` SET `s006_date_create` = '2019-07-22 11:11:52', `s006_id_creater` = 'c186b3da-1f9e-11e9-a0dc-02004c4f4f50', `s006_flag_state` = '正常', `s006_int_line` = 1, `s006_id_table` = NULL, `s006_id_audit` = NULL, `s006_date_audit` = '2019-07-22 11:11:52', `s006_id_dept` = '186db301-7002-11e9-aa44-00163e13f083', `s006_id_com` = '0e4ca95c-8c60-46f5-8c94-46ab44d9da28', `s006_id_main` = NULL, `s006_id_qry` = 'weight_info_qry', `s006_var_qry` = '根据流水号下载数据', `s006_var_sql` = 'SELECT w01_id,w01_date_create,w01_id_creater,w01_flag_state,w01_int_line,\nw01_date_bill,w01_id_clerk,w01_id_source_table,w01_id_source,w01_bill_no,\nw01_id_table,w01_int_year,w01_id_audit,w01_date_audit,w01_int_month,\nw01_id_dept,w01_id_com,w01_id_main,w01_id_flow,w01_date_audit_act,\nw01_id_item,c102_id_item as ext_c102_id_item__w01_id_item,c102_var_item as ext_c102_var_item__w01_id_item,w01_dec_weight,w01_id_terminal,\nw01_id_unit,w01_id_supp,w01_var_scale,w01_flag_scale,w01_id_pr011,\nw01_dec_batch,w01_dec_min_w,w01_dec_max_w,w01_var_phase,w01_id_prop,\nw01_id_pr21,w01_var_task,w01_id_task,w01_var_batch,w01_var_serial,\nw01_var_item_batch,w01_dec_tare,w01_id_container,w01_var_item_serial,w01_TBTotalRecord,\nw01_dec_bag_qty,w01_id_pack,w01_id_process,w01_dec_stand,w01_process_name,\nw01_process_code,w01_dec_w,w01_id_unit_w,i31_id_supp,i31_var_supp,\ni31_var_batch_prod\nFROM weight01\nLEFT JOIN ctlm102 ON w01_id_item = c102_id\nLEFT JOIN inv31 ON i31_id = w01_var_item_serial\nWHERE var_task_supple = (SELECT var_task_supple FROM weight01 WHERE \nw01_var_serial = :var_Serial)\nAND w01_flag_valid <> \'作废\'\nAND w01_id_prop <> \'\'', `s006_var_param` = NULL, `s006_flag_ret` = 'json' WHERE `s006_id` = '736f9858-ac2e-11e9-aa0b-00163e13f083';
