level 1
JuiltyF
楼主
想做一个查询
将表数据做成以下格式的xml
<tables>
<tableName="Emp_Info_Master"Action="update">
<FieldKey="emp_code"OldValue="crazykaka1011"NewValue="crazykaka1011" />
<FieldKey="gender"OldValue="0001"NewValue="0001" />
<FieldKey="nationality"OldValue=""NewValue="CN"/>
<FieldKey="is_foreign_emp"OldValue="false"NewValue="false" />
<FieldKey="passport_number"OldValue=""NewValue="" />
<FieldKey="passport_invalid_date"OldValue=""NewValue="" />
<FieldKey="identity_card"OldValue=""NewValue="" />
<FieldKey="date_of_birth"OldValue="2015/03/29"NewValue="2015/03/29" />
<FieldKey="chn_name"OldValue="crazykaka1011"NewValue="crazykaka1011" />
<FieldKey="eng_name"OldValue="crazykaka1011"NewValue="crazykaka1011" />
<FieldKey="nation"OldValue=""NewValue="" />
<FieldKey="marriage_type_id"OldValue=""NewValue="" />
<FieldKey="state"OldValue=""NewValue="" />
<FieldKey="city"OldValue="SH"NewValue="SH" />
<FieldKey="living_address"OldValue=""NewValue="中华人名共和国" />
<FieldKey="hukou_address"OldValue=""NewValue="" />
<FieldKey="living_zipcode"OldValue=""NewValue="" />
<FieldKey="hukou_zipcode"OldValue=""NewValue="" />
<FieldKey="biz_phone"OldValue=""NewValue="" />
<FieldKey="home_phone"OldValue=""NewValue="" />
<FieldKey="mobile_phone"OldValue=""NewValue="" />
<FieldKey="email"OldValue="[email protected]"NewValue="[email protected]" />
<FieldKey="emp_id"OldValue="6E6C6D1E-9201-4398-B9A1-81B1E095B291"NewValue="6E6C6D1E-9201-4398-B9A1-81B1E095B291"IsKeyID="1" />
</table>
</tables>
比如表名:Emp_Info_Master 字段是:fieldkey的值
在线等。。。急求
2015年11月24日 04点11分
1
将表数据做成以下格式的xml
<tables>
<tableName="Emp_Info_Master"Action="update">
<FieldKey="emp_code"OldValue="crazykaka1011"NewValue="crazykaka1011" />
<FieldKey="gender"OldValue="0001"NewValue="0001" />
<FieldKey="nationality"OldValue=""NewValue="CN"/>
<FieldKey="is_foreign_emp"OldValue="false"NewValue="false" />
<FieldKey="passport_number"OldValue=""NewValue="" />
<FieldKey="passport_invalid_date"OldValue=""NewValue="" />
<FieldKey="identity_card"OldValue=""NewValue="" />
<FieldKey="date_of_birth"OldValue="2015/03/29"NewValue="2015/03/29" />
<FieldKey="chn_name"OldValue="crazykaka1011"NewValue="crazykaka1011" />
<FieldKey="eng_name"OldValue="crazykaka1011"NewValue="crazykaka1011" />
<FieldKey="nation"OldValue=""NewValue="" />
<FieldKey="marriage_type_id"OldValue=""NewValue="" />
<FieldKey="state"OldValue=""NewValue="" />
<FieldKey="city"OldValue="SH"NewValue="SH" />
<FieldKey="living_address"OldValue=""NewValue="中华人名共和国" />
<FieldKey="hukou_address"OldValue=""NewValue="" />
<FieldKey="living_zipcode"OldValue=""NewValue="" />
<FieldKey="hukou_zipcode"OldValue=""NewValue="" />
<FieldKey="biz_phone"OldValue=""NewValue="" />
<FieldKey="home_phone"OldValue=""NewValue="" />
<FieldKey="mobile_phone"OldValue=""NewValue="" />
<FieldKey="email"OldValue="[email protected]"NewValue="[email protected]" />
<FieldKey="emp_id"OldValue="6E6C6D1E-9201-4398-B9A1-81B1E095B291"NewValue="6E6C6D1E-9201-4398-B9A1-81B1E095B291"IsKeyID="1" />
</table>
</tables>
比如表名:Emp_Info_Master 字段是:fieldkey的值
在线等。。。急求