123.txt

仓储系统

--select * from StroeRoom
--delete from StroeRoom
insert into StroeRoom(Storeroom_zip,Storeroom_name) values('01','关东')
insert into StroeRoom(Storeroom_zip,Storeroom_name) values('02','微型')



select * from StroeRoom
select * from StroePosition
--delete from StroePosition
--sp_help StroePosition
insert into StroePosition(Stroeroom_zip,Stroeplace_zip,Stroeplace_name) values('01','01','1号库位')
insert into StroePosition(Stroeroom_zip,Stroeplace_zip,Stroeplace_name) values('01','02','2号库位')
insert into StroePosition(Stroeroom_zip,Stroeplace_zip,Stroeplace_name) values('02','01','1号库位')
insert into StroePosition(Stroeroom_zip,Stroeplace_zip,Stroeplace_name) values('02','02','2号库位')


insert into Department(Dept_id,Dept_Name,Dept_place,Dept_Leader,Dept_Job,Dept_Memo) values('01','机械部','01','01','01','01')
insert into Department(Dept_id,Dept_Name,Dept_place,Dept_Leader,Dept_Job,Dept_Memo) values('02','电装部','02','02','02','02')
insert into Department(Dept_id,Dept_Name,Dept_place,Dept_Leader,Dept_Job,Dept_Memo) values('03','人事部','03','03','03','03')
insert into Department(Dept_id,Dept_Name,Dept_place,Dept_Leader,Dept_Job,Dept_Memo) values('04','结构部','04','04','04','04')
insert into Department(Dept_id,Dept_Name,Dept_place,Dept_Leader,Dept_Job,Dept_Memo) values('05','仓库部','05','05','05','05')
insert into Department(Dept_id,Dept_Name,Dept_place,Dept_Leader,Dept_Job,Dept_Memo) values('06','市场部','06','06','06','06')





--select * from InOutClass
--delete from InOutClass
insert into InOutClass(InOut_ClassNo,InOut_ClassName) values('101','采购入库')
insert into InOutClass(InOut_ClassNo,InOut_ClassName) values('102','产成品入库')
insert into InOutClass(InOut_ClassNo,InOut_ClassName) values('201','材料领用')
insert into InOutClass(InOut_ClassNo,InOut_ClassName) values('202','销售成品入库')




insert into MateQuality(QualityNo,Quality) values('01','正品')
insert into MateQuality(QualityNo,Quality) values('02','次品')




insert into GysArchives(Gys_code,Gys_name,Gys_Add,Gys_Lxr,Gys_Tel,Gys_Zip,Gys_Tax,Gys_Khbank,Gys_Account,Gys_Credit,Gys_memo) 
   values('01','01','01','01','01','01','01','01','01','01','01')
insert into GysArchives(Gys_code,Gys_name,Gys_Add,Gys_Lxr,Gys_Tel,Gys_Zip,Gys_Tax,Gys_Khbank,Gys_Account,Gys_Credit,Gys_memo) 
   values('02','02','v','02','02','02','02','02','02','02','02')




insert into materielclass(mclass_no,mclass_name) values('101','元器件')
insert into materielclass(mclass_no,mclass_name) values('102','金属')
insert into materielclass(mclass_no,mclass_name) values('103','塑胶材料')
insert into materielclass(mclass_no,mclass_name) values('104','电镀材料')
insert into materielclass(mclass_no,mclass_name) values('105','油漆材料')
insert into materielclass(mclass_no,mclass_name) values('106','包装材料')
insert into materielclass(mclass_no,mclass_name) values('107','辅助材料')


insert into materielclass(mclass_no,mclass_name) values('201','日用品')
insert into materielclass(mclass_no,mclass_name) values('202','防护品')
insert into materielclass(mclass_no,mclass_name) values('203','其他劳保')

insert into materielclass(mclass_no,mclass_name) values('301','印刷品')
insert into materielclass(mclass_no,mclass_name) values('302','文具')
insert into materielclass(mclass_no,mclass_name) values('303','办公家具')

insert into materielclass(mclass_no,mclass_name) values('401','工具类')
insert into materielclass(mclass_no,mclass_name) values('402','量具类')
insert into materielclass(mclass_no,mclass_name) values('403','夹具类')

--delete from materielclassateriel_cl'工具类'
--delete from materielclassateriel_cl'量具类'
--delete from materielclassateriel_cl'夹具类'

insert into materielclass(mclass_no,mclass_name) values('501','机械设备')
insert into materielclass(mclass_no,mclass_name) values('502','测量设备')
insert into materielclass(mclass_no,mclass_name) values('503','电器设备')
insert into materielclass(mclass_no,mclass_name) values('501','运输设备')

insert into materielclass(mclass_no,mclass_name) values('601','电工类')
insert into materielclass(mclass_no,mclass_name) values('602','生产类')
insert into materielclass(mclass_no,mclass_name) values('603','杂件类')