gusucode.com > 精典源码Delphi036：思雷特(sunnet)物业管理信息系统源码程序 > 精典源码Delphi036：思雷特(sunnet)物业管理信息系统源码程序/精典源码Delphi036：思雷特(sunnet)物业管理信息系统/小区物业管理文档/文档/脚本/6.0最高版本脚本/小区库结构修改完整版.txt

    alter table M_FeeItem add 
FeeUnit varchar(10) NULL,
FeeDayNum varchar(15) NULL,
FeeType VARCHAR(30) NULL,
CostBeginMonth integer,
CostEndMonth integer,
CostBeginDay integer,
CostEndDay integer
go

alter table M_Fee_Corp add 
FeeType VARCHAR(30) NULL,
CostDuring VARCHAR(30) NULL
go

alter table M_Fee_Individual add 
FeeType VARCHAR(30) NULL,
CostDuring VARCHAR(30) NULL
go

alter table M_Fee_Corp_His add 
FeeType VARCHAR(30) NULL,
CostDuring VARCHAR(30) NULL

alter table M_Fee_Individual_His add 
FeeType VARCHAR(30) NULL,
CostDuring VARCHAR(30) NULL
go
-------------

alter table M_Contract_OnceItem
add
   FeeType varchar(30) null,
   CostDuring varchar(30) null
go
alter table M_Contract_cycleitem add 
FeeUnit varchar(10) NULL,
FeeDayNum varchar(15) NULL,
FeeType VARCHAR(30) NULL,
CostBeginMonth integer,
CostEndMonth integer,
CostBeginDay integer,
CostEndDay integer,
CostDuring varchar(30) null
go
create view  VIEW_AllFeeName
as 
select '普通收费' leixing,id,danjia from M_feeItem
union
select '合同(一次性)' leixing,id,danjia from M_Contract_OnceItem
union
select '合同（定期）' leixing,id,danjia from M_Contract_CycleItem
go

-----------
insert into s_module values(50,'库存台帐','库存管理')
GO
insert into s_module values(51,'入库管理','库存管理')
GO
insert into s_module values(52,'出库管理','库存管理')
GO
insert into s_module values(53,'损益管理','库存管理')
GO
delete from s_module where subsystem='保洁管理'
go
insert into s_module values(54,'保洁信息','保洁管理')
go
insert into s_module values(55,'保洁项目','保洁管理')
go
insert into s_module values(56,'保洁人员管理','保洁管理')
go
insert into s_module values(57,'保洁工作记录表','保洁管理')
go
insert into s_module values(58,'保洁检查表','保洁管理')
go
delete from s_module where subsystem='环卫绿化'
go
insert into s_module values(59,'环卫绿化信息','绿化管理')
go
insert into s_module values(60,'绿化项目','绿化管理')
go
insert into s_module values(61,'绿化人员管理','绿化管理')
go
insert into s_module values(62,'绿化工作记录表','绿化管理')
go
insert into s_module values(63,'绿化检查表','绿化管理')
go

insert into s_module values(64,'公司概貌','公司概貌')
go

-----------增加出库单价-----------------
alter table  D_Repertory_Out add 
  Price float
go
alter table  D_SunYi add 
  Price float
go
alter table D_Repertory_Out add
  bumen varchar(30) NULL
alter table D_Repertory_Out add
  Pingzhenghao varchar(30) NULL
alter table D_Repertory_In add
  Pingzhenghao varchar(30) NULL
insert into S_CodeSort values(107,'领用部门')
insert into S_CodeItem values(215,107,'工程部门')


修改处
charge\dTodaymoney.dll(区段现金报表)
charge\dRDebitNote.dll
charge\dFeeSetup.dll
charge\dContract.dll
bin\dRepertory.dll（库存价格问题）
bin\pwuye.exe(权限)
bin\dcharge.dll

alter table d_plan_baoan add
 banci varchar(30) NULL 
alter table s_systeminfo add
 serial varchar(200) NULL