视图与XML

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文件中。
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值