燃气安检的模板代码

• 1. SQL语句
• 2. 创建数据库的操作

SQL语句

select SP_id from Task_entity group by sp_id --计划分组
--根据计划查询全部 
select * from Task_entity  where SP_Id=13  
 根据小区分组 
select RenWuId from Task_entity where SP_Id=13 group by XiaoQuId 

select * from Task_entity a ,TaskListEntity b where a.XiaoQuId=Id and a.SP_Id=13 and a.XiaoQuId=1

数据库数据的筛选
select * from Task_entity   where address2="益民园101" and address3=1 and address4=102 and 
AnJianCiShu="2次" and LeiBie=0

select * from Task_entity   where SP_Id="P20161205251"

创建数据库的操作

创建数据库的操作
创建网址的列表
create table BaseUrl (id INTEGER primary key,[BaseUrl] text);
创建日志的列表
create table RiZhi (id INTEGER primary key autoincrement,[U_Id] text,[Date] text,[IT_Number] 
text,[Content] text);
创建多个小区的列表
create table TaskListEntity (id INTEGER primary key autoincrement,[SP_Id] text NOT NULL,[XiaoQuId] 
text NOT NULL, name text not null , state text ,operation text,time text,[LouHaoList] 
VARCHAR(50),[LeiBie] VARCHAR(50),[UserId] VARCHAR(50));
创建多个安检项的列表
create table SecurityItemEntity (id text primary key,content text,RectificationGrade text);
创建多个安检状况的列表
create table SecurityStatus (id INTEGER primary key autoincrement,RenWuId text,IT_Number 
text,AnJianXiangId text,AnJianMiaoShu text,AnJianZhaoPian text);
创建多个住户的列表
create table Task_entity ([RenWuId] INTEGER PRIMARY KEY autoincrement,[SP_Id] text NOT 
NULL,[YonghuId] text NOT NULL,[DisNumber] text NOT NULL,[XiaoQuId] text NOT NULL,[AnJianXiangId] 
VARCHAR(200),[AnJianZhuangKuangId] VARCHAR(200),[state] TEXT,[RectificationGrade] 
TEXT,[AnJianZhuangTai] text,[operation] VARCHAR(50),[address2] VARCHAR(50),[address3] 
VARCHAR(50),[address4] VARCHAR(50),[category] VARCHAR(50),[LeiBie] 
VARCHAR(50),[DanTiao] VARCHAR(50),[StopTime] VARCHAR(50),[IT_Number] VARCHAR(50),[BoHuiLiYou] 
VARCHAR(50),[UserId] VARCHAR(50),[AnJianCiShu] VARCHAR(50),[IT_Reject] VARCHAR(50),[IT_State] text 
DEFAULT '0',[AD_Name] text DEFAULT '',[AD_Phone] text DEFAULT '');