--在仓存模块取值

insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','rkdate','',1,'MES月末特定日期的单据归集到下月1号'  --19默认值
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES月末特定日期的单据归集到下月','CYY','rkdate','','','' from ICSystemProfile

insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','fcpbg','许晓华',1,'MES产品入库单验收保管'  --19默认值
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES产品入库单验收保管','CYY','fcpbg','','','' from ICSystemProfile

insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','FZPrwdfbzd','彭厚琴',1,'MES装配组任务单汇报制单审核人'  --19默认值
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES装配组任务单汇报制单审核人','CYY','FZPrwdfbzd','','','' from ICSystemProfile
  insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','FFZPrwdfbzd','刘惠玉',1,'MES非装配组任务单汇报制单审核人'  --19默认值
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES非装配组任务单汇报制单审核人','CYY','FFZPrwdfbzd','','','' from ICSystemProfile

insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','Fzpstock','整机下线库',1,'MES装配组仓库'  
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES装配组仓库','CYY','Fzpstock','','','' from ICSystemProfile
  insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','Ffzpstock','涂装库',1,'MES非装配组仓库'  
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES非装配组仓库','CYY','Ffzpstock','','','' from ICSystemProfile

  insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','Fzpstockzd','刘惠玉',1,'MES装配组产品入库单制单人'  
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES装配组产品入库单制单人','CYY','Fzpstockzd','','','' from ICSystemProfile
  insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','Ffzpstockzd','彭厚琴',1,'MES非装配组产品入库单制单人'  
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES非装配组产品入库单制单人','CYY','Ffzpstockzd','','','' from ICSystemProfile

   insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','Fzpstocksh','范新昌',1,'MES装配组产品入库单审核人'  
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES装配组产品入库单审核人','CYY','Fzpstocksh','','','' from ICSystemProfile
  insert into t_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription)
select 'CYY','Ffzpstocksh','黄艳婷',1,'MES非装配组产品入库单审核人'  
insert into ICSystemProfile(fid,findex,FPropertyID,FCaption,FCategory,fkey,fvalue,FCaption_CHT,FCaption_EN)
select 2,max(findex)+1,3,'MES非装配组产品入库单审核人','CYY','Ffzpstocksh','','','' from ICSystemProfile

-- delete t_SystemProfile
--where fcategory='cyy'