excel导入，如何置为某些列的值

江苏院-吴昊

jishuang 发表于 2019-9-9 13:43
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=40966&pid=165049439

<?xml version="1.0" encoding="utf-8"?>

<rows>
  <userdata name="model">/DWGHK/common/data</userdata>
  <userdata name="id-column-name">gh_project</userdata>
  <userdata name="id-column-type">String</userdata>
  <userdata name="id-column-define">gh_project</userdata>
  <userdata name="userdata">whereVersion</userdata>
  <userdata name="relations">gh_project.capacity,gh_project.construction_plan,gh_project.create_time,gh_project.creator,gh_project.id,gh_project.length,gh_project.order_code,gh_project.plan_time,gh_project.production_time,gh_project.project_area,gh_project.project_code,gh_project.project_name,gh_project.project_name_order,gh_project.project_status,gh_project.static_investment,gh_project.update_time,gh_project.version,gh_project.voltage_level</userdata>
  <userdata name="relation-types">Integer,String,DateTime,String,String,Decimal,String,String,String,String,String,String,Integer,String,Decimal,DateTime,Integer,Integer</userdata>
  <userdata name="relation-alias">capacity,construction_plan,create_time,creator,id,length,order_code,plan_time,production_time,project_area,project_code,project_name,project_name_order,project_status,static_investment,update_time,version,voltage_level</userdata>
  <userdata name="sys.rowid">gh_project</userdata>
  <row id="DC12D7979DB24E338E1A951EBF0C0C9D">
    <userdata name="recordState">new</userdata>
    <cell changed="1"><![CDATA[360]]></cell>
    <cell changed="1"><![CDATA[。]]></cell>
    <cell changed="1"><![CDATA[2019-09-11T11:19:55.499Z]]></cell>
    <cell changed="1"/>
    <cell changed="1"><![CDATA[DC12D7979DB24E338E1A951EBF0C0C9D]]></cell>
    <cell changed="1"><![CDATA[22.4]]></cell>
    <cell changed="1"/>
    <cell changed="1"><![CDATA[2019]]></cell>
    <cell changed="1"><![CDATA[2021]]></cell>
    <cell changed="1"><![CDATA[]]></cell>
    <cell changed="1"/>
    <cell changed="1"><![CDATA[]]></cell>
    <cell changed="1"/>
    <cell changed="1"><![CDATA[规划]]></cell>
    <cell changed="1"><![CDATA[]]></cell>
    <cell changed="1"/>
    <cell changed="1"><![CDATA[0]]></cell>
    <cell changed="1"><![CDATA[]]></cell>
  </row>
</rows>

江苏院-吴昊

jishuang 发表于 2019-9-9 13:43
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=40966&pid=165049439

这是按代码修改主键后的table
<?xml version="1.0" encoding="utf-8"?>

<rows>
  <userdata name="model">/DWGHK/common/data</userdata>
  <userdata name="id-column-name">gh_project</userdata>
  <userdata name="id-column-type">String</userdata>
  <userdata name="id-column-define">gh_project</userdata>
  <userdata name="userdata">whereVersion</userdata>
  <userdata name="relations">gh_project.capacity,gh_project.construction_plan,gh_project.create_time,gh_project.creator,gh_project.id,gh_project.length,gh_project.order_code,gh_project.plan_time,gh_project.production_time,gh_project.project_area,gh_project.project_code,gh_project.project_name,gh_project.project_name_order,gh_project.project_status,gh_project.static_investment,gh_project.update_time,gh_project.version,gh_project.voltage_level</userdata>
  <userdata name="relation-types">Integer,String,DateTime,String,String,Decimal,String,String,String,String,String,String,Integer,String,Decimal,DateTime,Integer,Integer</userdata>
  <userdata name="relation-alias">capacity,construction_plan,create_time,creator,id,length,order_code,plan_time,production_time,project_area,project_code,project_name,project_name_order,project_status,static_investment,update_time,version,voltage_level</userdata>
  <userdata name="sys.rowid">gh_project</userdata>
  <row id="7F119A57048743CC98CE52F47B426434">
    <userdata name="recordState">edit</userdata>
    <cell><![CDATA[360]]></cell>
    <cell><![CDATA[]]></cell>
    <cell><![CDATA[2019-09-11T11:25:34.264Z]]></cell>
    <cell/>
    <cell><![CDATA[4F10CDE1EA124A87935E364CDD85B6CA]]></cell>
    <cell><![CDATA[22.4]]></cell>
    <cell/>
    <cell><![CDATA[2019]]></cell>
    <cell><![CDATA[]]></cell>
    <cell><![CDATA[]]></cell>
    <cell/>
    <cell><![CDATA[]]></cell>
    <cell/>
    <cell><![CDATA[规划]]></cell>
    <cell><![CDATA[33924.0]]></cell>
    <cell/>
    <cell><![CDATA[0]]></cell>
    <cell><![CDATA[220]]></cell>
  </row>
</rows>

江苏院-吴昊

但是我发现，把状态设置为edit后，<cell changed="1"> 的changed=1 就消失了，导致平台认为关系的值没有修改，所以excel中的新值覆盖 数据库中的旧值，就无法生效了。

jishuang

直接修改数据，不需要自己修改状态

江苏院-吴昊

jishuang 发表于 2019-9-11 13:11
直接修改数据，不需要自己修改状态

不修改状态的话，就是新增行啊。

我现在要实现，名称相同时，覆盖旧数据。

所以遍历每行的时候，根据名称查询，数据库里是否存在，如果存在的话，要把当前行的主键修改为跟数据库一直，这样就可以实现覆盖了。

jishuang

那就自己用sql去执行update

江苏院-吴昊

jishuang 发表于 2019-9-11 15:27
那就自己用sql去执行update

可以用上面的实现，结贴吧。