SIM卡管理维护需求.docVIP

SIM卡管理需求说明 档案录入 涉及表计mobil 充值记录录入、修改 涉及表计mobil_chongzhinew 余额综合查询需求 查询方式： 查询方案用户中GSM采集器余额 select a.usernumber,a.name,a.phonenumber,CZ.money_date,CZ.money,m.bureau from aterminal a,mobil_chongzhinew cz,mobil m,plandeta p1,plantota p2 where a.powertype =1 and ltrim(a.phonenumber)=ltrim(m.mobil) and a.code=p1.code and p1.plancode=p2.plancode and p2.plancode=xx SELECT top 1 a.usernumber, a.name, a.phonenumber, cz.Money_date, cz.Money, m.Bureau FROM dbo.aterminal a INNER JOIN dbo.mobil m ON LTRIM(a.phonenumber) = LTRIM(m.mobil) INNER JOIN dbo.plandeta p1 ON a.code = p1.code INNER