Java基础 - XML解析转成Bean以及Bean转成XML(附带案例)
文章目录1. JAXB - Java Architecturefor XML Binding - 面向XML绑定的Java体系结构1.1 注解1.2 使用**测试1 - 反序列化xml文件成JavaBean对象****测试2 - 序列化普通JavaBean对象****测试3 - 序列化JavaBean对象字段中含有容器Collection -> xml字符串****测试4 - 序列化容器对象
·
文章目录
1. JAXB - Java Architecturefor XML Binding - 面向XML绑定的Java体系结构
1.1 注解
// 1. 需要解析什么访问权限的javaBean字段 == 如果是私有字段,类上必须加上此注解
@XmlAccessorType(XmlAccessType.FIELD)
// 2. 使用什么标签名包裹该类的全部属性
@XmlRootElement(name="student")
// 3. 该类的属性字段的值需要什么标签进行包裹
@XmlElement(name="name",required = true)
// 4. 属性字段是容器对象如Collection,需要什么标签包裹该字段遍历的元素
@XmlElementWrapper(name = "students")
@XmlElement(name="name") // 遍历的每个JavaBean的属性值由该 定义的标签进行包裹
// 5. 可以迭代容器字段
@XmlAnyElement
// 4. 定义属性字段序列化、反序列化的顺序
@XmlType(propOrder = {"id", "name"})
//在XmlRootElement根这个节点添加属性
@XmlAttribute(name = "xx", required = true)
1.2 使用
Student.java
@Data
@NoArgsConstructor
@AllArgsConstructor
@XmlAccessorType(XmlAccessType.FIELD) //定义xml序列化的字段类型
@XmlRootElement(name="student") //定义xml中跟属性
public class Student {
//xml属性映射
@XmlElement(name="name",required = true)
private String name;
@XmlElement(name="year",required = true)
private Integer year;
}
student.xml
<?xml version="1.0"?>
<student>
<name>lrc</name>
<year>22</year>
</student>
测试1 - 反序列化xml文件成JavaBean对象
@Test
public void test1() throws Exception {
Class clazz = Student.class;
//实参中包含需要解析的类
JAXBContext jaxbContext = JAXBContext.newInstance(clazz);
//xml文件解析成JavaBean对象器
Unmarshaller unmarshaller = jaxbContext.createUnmarshaller();
//序列化
File file = new File("C:\\Users\\Administrator\\Desktop\\student.xml");
Object student = unmarshaller.unmarshal(file);
System.out.println(student);
System.out.println(student.getClass().getName());
}
测试2 - 序列化普通JavaBean对象
@Test
public void test2() throws JAXBException {
Class clazz = Student.class;
//实参中包含需要解析的类
JAXBContext jaxbContext = JAXBContext.newInstance(clazz);
//javaBean序列化xml文件器
Marshaller marshaller = jaxbContext.createMarshaller();
//是否格式化xml文件
marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT,true);
//序列化
Student student = new Student("lcj", 25);
marshaller.marshal(student, new File("C:\\Users\\Administrator\\Desktop\\student2.xml"));
}
测试3 - 序列化JavaBean对象字段中含有容器Collection -> xml字符串
Student.java
@Data
@NoArgsConstructor
@AllArgsConstructor
@EqualsAndHashCode(callSuper = true)
@ToString(callSuper = true)
@XmlAccessorType(XmlAccessType.FIELD)
@XmlRootElement(name="studentxx")
public class Student extends BaseDomain implements Play{
@XmlElement(name="name",required = true)
private String name;
@XmlElement(name="year",required = true)
private Integer year;
@Override
public void play() {
System.out.println(name + ":正在玩游戏");
}
}
Teacher.java
@Data
@NoArgsConstructor
@AllArgsConstructor
@XmlRootElement(name = "teacher")
@XmlAccessorType(XmlAccessType.FIELD)
public class Teacher {
@XmlElement(name = "teacherName")
String name;
@XmlElement(name = "teacherSubject")
String subject;
@XmlElementWrapper(name = "students") //将该字段的内容写在<students>节点里面
@XmlElement(name = "student") //指定每个Student对象的父标签,并且Student的@XmlRootElement属性失效
List<Student> students;
}
测试JavaBean中含有容器字段
@Test
public void test6() throws JAXBException {
//1. 序列化的对象
List<Student> students = new ArrayList<>();
students.add(new Student("lrc", 20));
students.add(new Student("lcj", 25));
Teacher teacher = new Teacher("昌老师", "数学", students);
JAXBContext jaxbContext = JAXBContext.newInstance(Teacher.class);
// 2. xml序列化器
Marshaller marshaller = jaxbContext.createMarshaller();
//序列化后的xml是否需要格式化输出
marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);
//取消这个标签的显示<?xml version="1.0" encoding="utf-8" standalone="yes"?>
marshaller.setProperty(Marshaller.JAXB_FRAGMENT,true);
//编码格式
marshaller.setProperty(Marshaller.JAXB_ENCODING,"utf-8");
// 3. 序列化
StringWriter sw = new StringWriter();
marshaller.marshal(teacher, sw);
//4.打印
System.out.println(sw.toString());
}
测试4 - 序列化容器对象
@Test
public void test7() throws JAXBException {
//必须使用包装类 - 否则输出不了任何东西
List<Student> students = new ArrayList<>();
students.add(new Student("lrc", 20));
students.add(new Student("lcj", 25));
QName tagName = new QName("myStudents");
JAXBElement<ListWrapper> jaxbElement = new JAXBElement<>(tagName, ListWrapper.class, new ListWrapper(students));
//生成xml上下文 - 定义解析的类型
JAXBContext jaxbContext = JAXBContext.newInstance(Student.class, ListWrapper.class);
// 2. xml序列化器
Marshaller marshaller = jaxbContext.createMarshaller();
marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);
// 3. 序列化
StringWriter sw = new StringWriter();
marshaller.marshal(jaxbElement, sw);
//4.打印
System.out.println(sw.toString());
}
//内部类必须是静态 - list包装类
@AllArgsConstructor
static class ListWrapper {
@XmlAnyElement //必须使用这个注解 - 可以迭代容器元素 - 可以生效Student的@XmlRootElement(name="studentxx")注解
//@XmlElement(name = "student") - 上面的注解可以替换成这个 - 取代了Student的@XmlRootElement(name="studentxx")注解
List<Student> students;
}
测试5 - 复杂报文解析
参考文章:https://blog.csdn.net/wn084/article/details/80853587
//@XmlAccessorType(XmlAccessType.FIELD)
如果你得字段是private类型且将@XmlElement放在属性上面,则必须在类上添加这个注解
RowCrmResult.java
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@Accessors(chain = true)
@XmlAccessorType(XmlAccessType.FIELD) //定义xml序列化的字段类型
@XmlRootElement(name = "outputdatas")
public class RowCrmResult {
/**
* 结果里面的状态码
*/
@XmlElement(name = "resultcode", nillable = true)
public String resultcode;
/**
* 结果里面的失败原因
*/
@XmlElement(name = "reason", nillable = true)
public String reason;
@XmlElementWrapper(name = "results")
@XmlElement(name = "result", nillable = true)
public List<Result> results;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@Accessors(chain = true)
@XmlAccessorType(XmlAccessType.FIELD)
@XmlRootElement(name = "result")
public static class Result {
@XmlAttribute(name = "set_id")
private String setId;
@XmlAttribute(name = "rows")
private Integer rowNum;
@XmlAttribute(name = "cols")
private Integer colNum;
@XmlElement(name = "row", nillable = true)
private List<Row> rows;
}
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@Accessors(chain = true)
@XmlRootElement
@XmlAccessorType(XmlAccessType.FIELD)
public static class Row {
@XmlAttribute(name = "rownum")
private Integer rownum;
@XmlElement(name = "col", nillable = true)
private List<Col> cols;
}
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@Accessors(chain = true)
@XmlAccessorType(XmlAccessType.FIELD)
@XmlRootElement
public static class Col {
@XmlAttribute(name = "colnum")
private String colnum;
@XmlAttribute(name = "param_id")
private String paramId;
@XmlAttribute(name = "param_name")
private String paramName;
@XmlValue
private String content;
}
}
开始解析
Test.java
/**
* 格式化响应内容 == 去除其他没用的字符,并格式化XML
* 使用的是hutool工具包
* @param content
* @return
*/
public static String formatResponseContent(String content) {
content = StrUtil.replace(content, "<![CDATA[", "");
content = StrUtil.replace(content, "]]>", "");
content = StrUtil.subBetween(content, "<osb:recvData xmlns:osb=\"mboss-esb/osb\">", "</osb:recvData>");
content= StrUtil.replace(content,"\\", "");
content = XmlUtil.format(content);
return content;
}
@SneakyThrows
public static void main(String[] args) {
String content = "XML内容 == 即下面的【解析前的XML】";
content = formatResponseContent(content);
System.out.println(content);
JAXBContext jaxbContext = JAXBContext.newInstance(RowCrmResult.class);
//xml文件解析成JavaBean对象器
Unmarshaller unmarshaller = jaxbContext.createUnmarshaller();
RowCrmResult rowCrmResult = (RowCrmResult) unmarshaller.unmarshal(new ByteArrayInputStream(content.getBytes()));
System.out.println(rowCrmResult);
}
解析前的XML
<?xml version="1.0" encoding="utf-8"?>
<mbos:callResponse xmlns:mbos="mboss-esb">
<osb:recvData xmlns:osb="mboss-esb/osb">
<outputdatas>
<resultcode>0</resultcode>
<reason>OK</reason>
<results sets="2">
<result rows="5" cols="28" set_id="201">
<row rownum="1">
<col colnum="1" param_id="2157001" param_name="申请单标识">3000010101960</col>
<col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210912950057232</col>
<col colnum="3" param_id="2157003" param_name="申请单状态">200000</col>
<col colnum="4" param_id="2157004" param_name="订单标识">3500018696696</col>
<col colnum="5" param_id="2157005" param_name="订单编码">752210912410694015</col>
<col colnum="6" param_id="2157006" param_name="订单状态">201300</col>
<col colnum="7" param_id="2157007" param_name="订单状态说明">开通中</col>
<col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
<col colnum="9" param_id="2157009" param_name="订单类型">000</col>
<col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
<col colnum="11" param_id="2157011" param_name="受理时间">20210912093601</col>
<col colnum="12" param_id="2157012" param_name="受理机构">752000000</col>
<col colnum="13" param_id="2157013" param_name="受理工位">752</col>
<col colnum="14" param_id="2157014" param_name="套餐名称" />
<col colnum="15" param_id="2157015" param_name="服务标识">3500005312442</col>
<col colnum="16" param_id="2157016" param_name="业务号码">CZCZKD2294432695</col>
<col colnum="17" param_id="2157017" param_name="产品标识">2340</col>
<col colnum="18" param_id="2157018" param_name="产品名称">快捷宽带</col>
<col colnum="19" param_id="2157019" param_name="状态时间">未竣工</col>
<col colnum="20" param_id="2157020" param_name="业务编码">CZCZKD_001</col>
<col colnum="21" param_id="2157021" param_name="业务名称">快捷宽带订购</col>
<col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
<col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
<col colnum="24" param_id="2157024" param_name="受理工位名称">惠州本地一级管理工位</col>
<col colnum="25" param_id="2157025" param_name="受理机构名称">惠州分公司</col>
<col colnum="26" param_id="2157026" param_name="订单来源">600101_ESBWSYYT</col>
<col colnum="27" param_id="2157027" param_name="套餐编码" />
<col colnum="28" param_id="2157028" param_name="来源系统">网厅ESB来源订单</col>
</row>
<row rownum="2">
<col colnum="1" param_id="2157001" param_name="申请单标识">3000010101960</col>
<col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210912950057232</col>
<col colnum="3" param_id="2157003" param_name="申请单状态">200000</col>
<col colnum="4" param_id="2157004" param_name="订单标识">3500018696706</col>
<col colnum="5" param_id="2157005" param_name="订单编码">752210912410694016</col>
<col colnum="6" param_id="2157006" param_name="订单状态">201300</col>
<col colnum="7" param_id="2157007" param_name="订单状态说明">开通中</col>
<col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
<col colnum="9" param_id="2157009" param_name="订单类型">002</col>
<col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
<col colnum="11" param_id="2157011" param_name="受理时间">20210912093604</col>
<col colnum="12" param_id="2157012" param_name="受理机构">752000000</col>
<col colnum="13" param_id="2157013" param_name="受理工位">752</col>
<col colnum="14" param_id="2157014" param_name="套餐名称">快捷宽带套餐(50元)50M</col>
<col colnum="15" param_id="2157015" param_name="服务标识" />
<col colnum="16" param_id="2157016" param_name="业务号码" />
<col colnum="17" param_id="2157017" param_name="产品标识">500046219</col>
<col colnum="18" param_id="2157018" param_name="产品名称" />
<col colnum="19" param_id="2157019" param_name="状态时间">未竣工</col>
<col colnum="20" param_id="2157020" param_name="业务编码">YH001</col>
<col colnum="21" param_id="2157021" param_name="业务名称">销售品订购(快捷宽带套餐(50元)50M)</col>
<col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
<col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
<col colnum="24" param_id="2157024" param_name="受理工位名称">惠州本地一级管理工位</col>
<col colnum="25" param_id="2157025" param_name="受理机构名称">惠州分公司</col>
<col colnum="26" param_id="2157026" param_name="订单来源">600101_ESBWSYYT</col>
<col colnum="27" param_id="2157027" param_name="套餐编码">DM0001-677-1-1</col>
<col colnum="28" param_id="2157028" param_name="来源系统">网厅ESB来源订单</col>
</row>
<row rownum="3">
<col colnum="1" param_id="2157001" param_name="申请单标识">3000010101960</col>
<col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210912950057232</col>
<col colnum="3" param_id="2157003" param_name="申请单状态">200000</col>
<col colnum="4" param_id="2157004" param_name="订单标识">3500018696707</col>
<col colnum="5" param_id="2157005" param_name="订单编码">752210912410694017</col>
<col colnum="6" param_id="2157006" param_name="订单状态">201300</col>
<col colnum="7" param_id="2157007" param_name="订单状态说明">开通中</col>
<col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
<col colnum="9" param_id="2157009" param_name="订单类型">000</col>
<col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
<col colnum="11" param_id="2157011" param_name="受理时间">20210912093607</col>
<col colnum="12" param_id="2157012" param_name="受理机构">752000000</col>
<col colnum="13" param_id="2157013" param_name="受理工位">752</col>
<col colnum="14" param_id="2157014" param_name="套餐名称" />
<col colnum="15" param_id="2157015" param_name="服务标识">3500005312442</col>
<col colnum="16" param_id="2157016" param_name="业务号码">CZCZKD2294432695</col>
<col colnum="17" param_id="2157017" param_name="产品标识">2340</col>
<col colnum="18" param_id="2157018" param_name="产品名称">快捷宽带</col>
<col colnum="19" param_id="2157019" param_name="状态时间">未竣工</col>
<col colnum="20" param_id="2157020" param_name="业务编码">CZCZKD_011</col>
<col colnum="21" param_id="2157021" param_name="业务名称">快捷宽带变更(改速率)</col>
<col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
<col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
<col colnum="24" param_id="2157024" param_name="受理工位名称">惠州本地一级管理工位</col>
<col colnum="25" param_id="2157025" param_name="受理机构名称">惠州分公司</col>
<col colnum="26" param_id="2157026" param_name="订单来源">ibssderv</col>
<col colnum="27" param_id="2157027" param_name="套餐编码" />
<col colnum="28" param_id="2157028" param_name="来源系统">CRM后台-派生订单</col>
</row>
<row rownum="4">
<col colnum="1" param_id="2157001" param_name="申请单标识">3000010101960</col>
<col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210912950057232</col>
<col colnum="3" param_id="2157003" param_name="申请单状态">200000</col>
<col colnum="4" param_id="2157004" param_name="订单标识">3500018696708</col>
<col colnum="5" param_id="2157005" param_name="订单编码">752210912410694018</col>
<col colnum="6" param_id="2157006" param_name="订单状态">201300</col>
<col colnum="7" param_id="2157007" param_name="订单状态说明">开通中</col>
<col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
<col colnum="9" param_id="2157009" param_name="订单类型">000</col>
<col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
<col colnum="11" param_id="2157011" param_name="受理时间">20210912093609</col>
<col colnum="12" param_id="2157012" param_name="受理机构">752000000</col>
<col colnum="13" param_id="2157013" param_name="受理工位">752</col>
<col colnum="14" param_id="2157014" param_name="套餐名称" />
<col colnum="15" param_id="2157015" param_name="服务标识">3500005312442</col>
<col colnum="16" param_id="2157016" param_name="业务号码">CZCZKD2294432695</col>
<col colnum="17" param_id="2157017" param_name="产品标识">2340</col>
<col colnum="18" param_id="2157018" param_name="产品名称">快捷宽带</col>
<col colnum="19" param_id="2157019" param_name="状态时间">未竣工</col>
<col colnum="20" param_id="2157020" param_name="业务编码">CZCZKD_021</col>
<col colnum="21" param_id="2157021" param_name="业务名称">快捷宽带变更(改专网)</col>
<col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
<col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
<col colnum="24" param_id="2157024" param_name="受理工位名称">惠州本地一级管理工位</col>
<col colnum="25" param_id="2157025" param_name="受理机构名称">惠州分公司</col>
<col colnum="26" param_id="2157026" param_name="订单来源">ibssderv</col>
<col colnum="27" param_id="2157027" param_name="套餐编码" />
<col colnum="28" param_id="2157028" param_name="来源系统">CRM后台-派生订单</col>
</row>
<row rownum="5">
<col colnum="1" param_id="2157001" param_name="申请单标识">3000010101443</col>
<col colnum="2" param_id="2157002" param_name="申请单编码">HZ20210911950057192</col>
<col colnum="3" param_id="2157003" param_name="申请单状态">301200</col>
<col colnum="4" param_id="2157004" param_name="订单标识">3500018695761</col>
<col colnum="5" param_id="2157005" param_name="订单编码">752210911410693935</col>
<col colnum="6" param_id="2157006" param_name="订单状态">301200</col>
<col colnum="7" param_id="2157007" param_name="订单状态说明">完工</col>
<col colnum="8" param_id="2157008" param_name="状态原因">1000</col>
<col colnum="9" param_id="2157009" param_name="订单类型">000</col>
<col colnum="10" param_id="2157010" param_name="受理工号">90000000671</col>
<col colnum="11" param_id="2157011" param_name="受理时间">20210911160332</col>
<col colnum="12" param_id="2157012" param_name="受理机构">1</col>
<col colnum="13" param_id="2157013" param_name="受理工位">200</col>
<col colnum="14" param_id="2157014" param_name="套餐名称" />
<col colnum="15" param_id="2157015" param_name="服务标识" />
<col colnum="16" param_id="2157016" param_name="业务号码" />
<col colnum="17" param_id="2157017" param_name="产品标识">0</col>
<col colnum="18" param_id="2157018" param_name="产品名称" />
<col colnum="19" param_id="2157019" param_name="状态时间">20210911160340</col>
<col colnum="20" param_id="2157020" param_name="业务编码">NEW_CUST</col>
<col colnum="21" param_id="2157021" param_name="业务名称">客户创建</col>
<col colnum="22" param_id="2157022" param_name="客户名称">何志聪</col>
<col colnum="23" param_id="2157023" param_name="称受理工号名称">【ESB】广东电信统一通信平台</col>
<col colnum="24" param_id="2157024" param_name="受理工位名称">广州本地一级管理工位</col>
<col colnum="25" param_id="2157025" param_name="受理机构名称">广东公司</col>
<col colnum="26" param_id="2157026" param_name="订单来源">600101_ESBGDUC</col>
<col colnum="27" param_id="2157027" param_name="套餐编码" />
<col colnum="28" param_id="2157028" param_name="来源系统">广东电信统一通信平台来源订单</col>
</row>
</result>
<result rows="4" cols="4" set_id="202">
<row rownum="1">
<col colnum="1" param_id="2157041" param_name="申请单标识">3000010101960</col>
<col colnum="2" param_id="2157042" param_name="主订单标识">3500018696706</col>
<col colnum="3" param_id="2157043" param_name="从订单标识">3500018696707</col>
<col colnum="4" param_id="2157044" param_name="依赖关系">1100</col>
</row>
<row rownum="2">
<col colnum="1" param_id="2157041" param_name="申请单标识">3000010101960</col>
<col colnum="2" param_id="2157042" param_name="主订单标识">3500018696696</col>
<col colnum="3" param_id="2157043" param_name="从订单标识">3500018696707</col>
<col colnum="4" param_id="2157044" param_name="依赖关系">1100</col>
</row>
<row rownum="3">
<col colnum="1" param_id="2157041" param_name="申请单标识">3000010101960</col>
<col colnum="2" param_id="2157042" param_name="主订单标识">3500018696706</col>
<col colnum="3" param_id="2157043" param_name="从订单标识">3500018696708</col>
<col colnum="4" param_id="2157044" param_name="依赖关系">1100</col>
</row>
<row rownum="4">
<col colnum="1" param_id="2157041" param_name="申请单标识">3000010101960</col>
<col colnum="2" param_id="2157042" param_name="主订单标识">3500018696707</col>
<col colnum="3" param_id="2157043" param_name="从订单标识">3500018696708</col>
<col colnum="4" param_id="2157044" param_name="依赖关系">1100</col>
</row>
</result>
</results>
</outputdatas>
</osb:recvData>
</mbos:callResponse>
解析后的内容
RowCrmResult
resultcode=0,
reason=OK,
results=[
RowCrmResult.Result(setId=201, rowNum=5, colNum=28, rows=[
RowCrmResult.Row(rownum=1, cols=[
RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101960),
RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210912950057232),
RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=200000), RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018696696), RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210912410694015), RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=201300), RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=开通中), RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000), RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=000), RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671), RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210912093601), RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=752000000), RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=752), RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=), RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=3500005312442), RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=CZCZKD2294432695), RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=2340), RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=快捷宽带), RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=未竣工), RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=CZCZKD_001), RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=快捷宽带订购), RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪), RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台), RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=惠州本地一级管理工位), RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=惠州分公司), RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=600101_ESBWSYYT), RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=), RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=网厅ESB来源订单)]),
RowCrmResult.Row(rownum=2, cols=[
RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101960),
RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210912950057232),
RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=200000),
RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018696706),
RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210912410694016),
RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=201300),
RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=开通中),
RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000),
RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=002),
RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671),
RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210912093604),
RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=752000000),
RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=752),
RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=快捷宽带套餐(50元)50M),
RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=),
RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=),
RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=500046219),
RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=),
RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=未竣工),
RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=YH001),
RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=销售品订购(快捷宽带套餐(50元)50M)),
RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪),
RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台),
RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=惠州本地一级管理工位),
RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=惠州分公司),
RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=600101_ESBWSYYT),
RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=DM0001-677-1-1),
RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=网厅ESB来源订单)]),
RowCrmResult.Row(rownum=3, cols=[RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101960), RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210912950057232), RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=200000), RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018696707), RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210912410694017), RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=201300), RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=开通中), RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000), RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=000), RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671), RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210912093607), RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=752000000), RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=752), RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=), RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=3500005312442), RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=CZCZKD2294432695), RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=2340), RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=快捷宽带), RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=未竣工), RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=CZCZKD_011), RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=快捷宽带变更(改速率)), RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪), RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台), RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=惠州本地一级管理工位), RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=惠州分公司), RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=ibssderv), RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=), RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=CRM后台-派生订单)]),
RowCrmResult.Row(rownum=4, cols=[RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101960), RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210912950057232), RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=200000), RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018696708), RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210912410694018), RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=201300), RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=开通中), RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000), RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=000), RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671), RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210912093609), RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=752000000), RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=752), RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=), RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=3500005312442), RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=CZCZKD2294432695), RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=2340), RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=快捷宽带), RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=未竣工), RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=CZCZKD_021), RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=快捷宽带变更(改专网)), RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪), RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台), RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=惠州本地一级管理工位), RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=惠州分公司), RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=ibssderv), RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=), RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=CRM后台-派生订单)]),
RowCrmResult.Row(rownum=5, cols=[RowCrmResult.Col(colnum=1, paramId=2157001, paramName=申请单标识, content=3000010101443), RowCrmResult.Col(colnum=2, paramId=2157002, paramName=申请单编码, content=HZ20210911950057192), RowCrmResult.Col(colnum=3, paramId=2157003, paramName=申请单状态, content=301200), RowCrmResult.Col(colnum=4, paramId=2157004, paramName=订单标识, content=3500018695761), RowCrmResult.Col(colnum=5, paramId=2157005, paramName=订单编码, content=752210911410693935), RowCrmResult.Col(colnum=6, paramId=2157006, paramName=订单状态, content=301200), RowCrmResult.Col(colnum=7, paramId=2157007, paramName=订单状态说明, content=完工), RowCrmResult.Col(colnum=8, paramId=2157008, paramName=状态原因, content=1000), RowCrmResult.Col(colnum=9, paramId=2157009, paramName=订单类型, content=000), RowCrmResult.Col(colnum=10, paramId=2157010, paramName=受理工号, content=90000000671), RowCrmResult.Col(colnum=11, paramId=2157011, paramName=受理时间, content=20210911160332), RowCrmResult.Col(colnum=12, paramId=2157012, paramName=受理机构, content=1), RowCrmResult.Col(colnum=13, paramId=2157013, paramName=受理工位, content=200), RowCrmResult.Col(colnum=14, paramId=2157014, paramName=套餐名称, content=), RowCrmResult.Col(colnum=15, paramId=2157015, paramName=服务标识, content=), RowCrmResult.Col(colnum=16, paramId=2157016, paramName=业务号码, content=), RowCrmResult.Col(colnum=17, paramId=2157017, paramName=产品标识, content=0), RowCrmResult.Col(colnum=18, paramId=2157018, paramName=产品名称, content=), RowCrmResult.Col(colnum=19, paramId=2157019, paramName=状态时间, content=20210911160340), RowCrmResult.Col(colnum=20, paramId=2157020, paramName=业务编码, content=NEW_CUST), RowCrmResult.Col(colnum=21, paramId=2157021, paramName=业务名称, content=客户创建), RowCrmResult.Col(colnum=22, paramId=2157022, paramName=客户名称, content=何志聪), RowCrmResult.Col(colnum=23, paramId=2157023, paramName=称受理工号名称, content=【ESB】广东电信统一通信平台), RowCrmResult.Col(colnum=24, paramId=2157024, paramName=受理工位名称, content=广州本地一级管理工位), RowCrmResult.Col(colnum=25, paramId=2157025, paramName=受理机构名称, content=广东公司), RowCrmResult.Col(colnum=26, paramId=2157026, paramName=订单来源, content=600101_ESBGDUC), RowCrmResult.Col(colnum=27, paramId=2157027, paramName=套餐编码, content=), RowCrmResult.Col(colnum=28, paramId=2157028, paramName=来源系统, content=广东电信统一通信平台来源订单)])]),
RowCrmResult.Result(setId=202, rowNum=4, colNum=4, rows=[
RowCrmResult.Row(rownum=1, cols=[
RowCrmResult.Col(colnum=1, paramId=2157041, paramName=申请单标识, content=3000010101960),
RowCrmResult.Col(colnum=2, paramId=2157042, paramName=主订单标识, content=3500018696706),
RowCrmResult.Col(colnum=3, paramId=2157043, paramName=从订单标识, content=3500018696707),
RowCrmResult.Col(colnum=4, paramId=2157044, paramName=依赖关系, content=1100)]),
RowCrmResult.Row(rownum=2, cols=[
RowCrmResult.Col(colnum=1, paramId=2157041, paramName=申请单标识, content=3000010101960),
RowCrmResult.Col(colnum=2, paramId=2157042, paramName=主订单标识, content=3500018696696),
RowCrmResult.Col(colnum=3, paramId=2157043, paramName=从订单标识, content=3500018696707),
RowCrmResult.Col(colnum=4, paramId=2157044, paramName=依赖关系, content=1100)]),
RowCrmResult.Row(rownum=3, cols=[
RowCrmResult.Col(colnum=1, paramId=2157041, paramName=申请单标识, content=3000010101960),
RowCrmResult.Col(colnum=2, paramId=2157042, paramName=主订单标识, content=3500018696706), RowCrmResult.Col(colnum=3, paramId=2157043, paramName=从订单标识, content=3500018696708), RowCrmResult.Col(colnum=4, paramId=2157044, paramName=依赖关系, content=1100)]),
RowCrmResult.Row(rownum=4, cols=[
RowCrmResult.Col(colnum=1, paramId=2157041, paramName=申请单标识, content=3000010101960),
RowCrmResult.Col(colnum=2, paramId=2157042, paramName=主订单标识, content=3500018696707), RowCrmResult.Col(colnum=3, paramId=2157043, paramName=从订单标识, content=3500018696708), RowCrmResult.Col(colnum=4, paramId=2157044, paramName=依赖关系, content=1100)])])
])
更多推荐
已为社区贡献1条内容
所有评论(0)