现在的位置: 首页 > 综合 > 正文

视图与XML

2013年10月09日 ⁄ 综合 ⁄ 共 2068字 ⁄ 字号 评论关闭

XML相关:
4个参数:
type=owner
actionid=data.xmlupdatecityunit
addUnit=addUnit
id=${unitid}

select LogicalX,LogicalY,singleormore from
kangaroo_unit where  UnitID=5499

 LogicalX = 6311
 LogicalY = 4264
做除法:
  x = 24
  y = 16
//获得拥有的实体,其实是靠近新添加的实体对象
SELECT *
FROM kangaroo_VW_UnitView
WHERE (modifytype <> 3) AND (logicalx >= 24 * 256) AND (logicalx < (24 +

1) * 256) AND
      (logicaly >= 16 * 256) AND (logicaly < (16 + 1) * 256)
ORDER BY unitid
===============================================
if(ownerInfoFirst.getCompanyname()==null){
  companystr =   null;
}else
{
  companystr = ownerInfoFirst.getCompanynam()

+,ownerInfoFirst.getCompanyid();
}
 if(companystr.indexOf(companystr )){

}   
===============================================
//原来是数据库视图缺少2列companyId,companyName,所以生成的xml文件一直为空

.
//更新实体临时表
insert into kangaroo.dbo.kangaroo_unittemp (unittype, unitname, logopic,

logicalx, logicaly, width, height, modifytype, paneltype, panel, adress,

telephone, lineid, visit, service, quality, environment, performance,

cost, discription, star, characteristicvachar, tag, scorenum,

newstmodifytime, recommend, weight, lineweight, showno, unittypecode,

longitude, latitude, introduction, trafficinfo, coordpoint, ownertype,

discription_level, singleormore) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?)

1. unittemp临时表有问题
   当删除实体标注后,临时表的记录没被delete

2. 添加一个实体标注(比如:天然居),把公司(HP)和它进行绑定后,           

   实体标注后,公司依然存在,到不是按照实体ID删除的,有疑问??
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
新添加一个实体标注(实体名称--[多公司]):结果,
    <UnitID>5492</UnitID>
    <UnitName><![CDATA[er]]></UnitName>
    <Panel><![CDATA[wer]]></Panel>
    <Panel_type>0</Panel_type>
    <LogicalX>10667</LogicalX>
    <LogicalY>9054</LogicalY>

     <UnitID>5502</UnitID>
     <UnitName><![CDATA[多公司]></UnitName>
    <Panel><![CDATA[23]]></Panel>
    <Panel_type>0</Panel_type>
    <LogicalX>10525</LogicalX>
    <LogicalY>8976</LogicalY>

SELECT *
FROM kangaroo_VW_UnitView
WHERE (modifytype <> 3) AND (logicalx >= 41 * 256) AND (logicalx < (41 +

1) * 256) AND
      (logicaly >= 35 * 256) AND (logicaly < (35 + 1) * 256)
ORDER BY unitid
结论:在视图中自动会把与添加的实体的logicalx,logicaly通过计算,符合在这个

区间范围内的实体也写入创建的XML文件中。
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

抱歉!评论已关闭.