|
老师好!
1.在JAVA中,调用了queryInsuredAction查询服务,得到了TABLE数据。
查询语句,和一些字典表做了关联,查询出的TABLE信息中,也包含了这些信息。
2.对TABLE数据进行修改后,再调用saveInsuredAction,就报告以下错误,但在界面中查询和保存就不会报告错误。
编码: JUSTEP150159; 提示: 保存的列必须包含主语, 要保存的列"[ChinaCity.CityName, Occ.OccName, BaseCode[3].CodeDescription, BaseCode[1].CodeDescription, BaseCode[4].CodeDescription, BaseCode[8].CodeDescription, BaseCode[10].CodeDescription, BaseCode[6].CodeDescription, OccSubcls.OccSubclsName, BaseCode.CodeDescription, BaseCode[2].CodeDescription, OccClass.OccClassName, Insured, BaseCode[7].CodeDescription, BaseCode[9].CodeDescription, BaseCode[5].CodeDescription]", 主语"[Insured]"
JAVA代码:
Table insuredTable=(Table)ActionUtils.invokeAction("/IS/NewBusiness/process/StandardNewBusiness/newBusinessProcess",
"CheckActivity",
"queryInsuredAction",
ContextHelper.getActionContext().getExecutor(),
ContextHelper.getActionContext().getExecuteContext(),
params);
Row insuredRow=insuredTable.iterator().next();
insuredRow.setString("CustId", custId);
params.put("table",insuredTable);
ActionUtils.invokeAction("/IS/NewBusiness/process/StandardNewBusiness/newBusinessProcess",
"CheckActivity",
"saveInsuredAction",
ContextHelper.getActionContext().getExecutor(),
ContextHelper.getActionContext().getExecuteContext(),
params);
查询语句:
select Insured.*,tCnty.CodeDescription as CntyName,tIdType.CodeDescription as IdTypeName,tOccTitile.CodeDescription as OccTitleName,tOccClass.OccClassName as OccClassName,tOccSubcls.OccSubclsName as OccSubclsName,tOcc.OccName as OccName,tProvince.CodeDescription as ProvinceName,tChinaCity.CityName as CityName,tSex.CodeDescription as SexName,tIpsnType.CodeDescription as IpsnTypeName,tRelToMstIpsn.CodeDescription as RelToMstIpsnName,tRelToHldr.CodeDescription as RelToHldrName,tMarriageStat.CodeDescription as MarriageStatName,tChildrenStat.CodeDescription as ChildrenStatName,tContactWay.CodeDescription as PrimContactWayName
from Insured Insured
optional join BaseCode tCnty on Insured.CntyCode = tCnty.CodeValue AND tCnty.CodeType = 'CntyCode'
optional join BaseCode tIdType on Insured.IdType = tIdType.CodeValue AND tIdType.CodeType = 'IdType'
optional join BaseCode tOccTitile on Insured.OccTitle = tOccTitile.CodeValue AND tOccTitile.CodeType = 'OccTitle'
optional join OccClass tOccClass on Insured.OccClassCode = tOccClass.OccClassCode
optional join OccSubcls tOccSubcls on Insured.OccSubclsCode = tOccSubcls.OccSubclsCode AND Insured.OccClassCode = tOccSubcls.OccClassCode
optional join Occ tOcc on Insured.OccDtlCode = tOcc.OccCode AND Insured.OccClassCode = tOcc.OccClassCode AND Insured.OccSubclsCode = tOcc.OccSubclsCode
optional join BaseCode tProvince on Insured.Province = tProvince.CodeValue AND tProvince.CodeType = 'Province'
optional join ChinaCity tChinaCity on Insured.Province = tChinaCity.ProvinceCode
optional join BaseCode tSex on Insured.Sex = tSex.CodeValue AND tSex.CodeType = 'Sex'
optional join BaseCode tIpsnType on Insured.IpsnType = tIpsnType.CodeValue AND tIpsnType.CodeType = 'IpsnType'
optional join BaseCode tRelToMstIpsn on Insured.RelToMstIpsn = tRelToMstIpsn.CodeValue AND tRelToMstIpsn.CodeType = 'PsnRelation'
optional join BaseCode tRelToHldr on Insured.RelToHldr = tRelToHldr.CodeValue AND tRelToHldr.CodeType = 'PsnRelation'
optional join BaseCode tMarriageStat on Insured.MarriageStat = tMarriageStat.CodeValue AND tMarriageStat.CodeType = 'MarriageStat'
optional join BaseCode tChildrenStat on Insured.ChildrenStat = tChildrenStat.CodeValue AND tChildrenStat.CodeType = 'ChildrenStat'
optional join BaseCode tContactWay on Insured.PrimContactWay = tContactWay.CodeValue AND tContactWay.CodeType = 'ContactWay'
|
|