恩信ERP7.10安装、定制和二次开发 (2)

第六部分、数据移植（从6.3到7.10）。 把恩信6.3数据库ondemand1导入到恩信7.0数据库所在的mysql中，由于我的新版ERP数据库已经改成了rely_db，所以两个数据库可以同时存在。 use rely_db; 1、移植design_file: INSERT INTO DESIGN_FILE(PRODUCT_ID,PRODUCT_NAME,PRODUCT_NICK,PRODUCT_CLASS,type,PRODUCT_DESCRIBE,FACTORY_NAME,FACTORY_ID,AMOUNT_UNIT,PROVIDER_GROUP,PHOTO1,PHOTO2,WARRANTY,LIST_PRICE,COST_PRICE,REAL_COST_PRICE,LIFECYCLE,PERSONAL_UNIT,PERSONAL_VALUE,TWIN_NAME,TWIN_ID,REMARK,CHECK_TAG,ACHIEVEMENT_SUM,ATTACHMENT_NAME,RETURN_SUM,RETURN_AMOUNT,FILE_CHANGE_AMOUNT,USED_PRODUCT_NAME,RESPONSIBLE_PERSON_NAME,RESPONSIBLE_PERSON_ID,REGISTER,CHECKER,CHANGER,REGISTER_ID,CHECKER_ID,CHANGER_ID,REGISTER_TIME,CHECK_TIME,CHANGE_TIME,LATELY_CHANGE_TIME,LATELY_TRADE_TIME,DELETE_TIME,RECOVERY_TIME,MODIFY_TAG,EXCEL_TAG,EXCEL_TAG2,EXCEL_TAG3,EXCEL_TAG4,DESIGN_MODULE_TAG,DESIGN_PROCEDURE_TAG,DESIGN_CELL_TAG,RECOMMEND_PROVIDER_TAG,PRICE_CHANGE_TAG,PRICE_ALARM_TAG,ORDER_SALE_BONUS_RATE,ORDER_PROFIT_BONUS_RATE,RETAIL_SALE_BONUS_RATE,RETAIL_PROFIT_BONUS_RATE,COST_CALCULATE_TYPE,SERIAL_NUMBER_TAG,CALCULATE_BONUS_SN_TAG,QCS_TAG,QCS_APPLY_TAG,CHAIN_ID,CHAIN_NAME) SELECT PRODUCT_ID,PRODUCT_NAME,PRODUCT_NICK,PRODUCT_CLASS,type,PRODUCT_DESCRIBE,FACTORY_NAME,FACTORY_ID,AMOUNT_UNIT,PROVIDER_GROUP,PHOTO1,PHOTO2,WARRANTY,LIST_PRICE,COST_PRICE,REAL_COST_PRICE,LIFECYCLE,PERSONAL_UNIT,PERSONAL_VALUE,TWIN_NAME,TWIN_ID,REMARK,CHECK_TAG,ACHIEVEMENT_SUM,ATTACHMENT_NAME,RETURN_SUM,RETURN_AMOUNT,FILE_CHANGE_AMOUNT,USED_PRODUCT_NAME,RESPONSIBLE_PERSON_NAME,RESPONSIBLE_PERSON_ID,REGISTER,CHECKER,CHANGER,REGISTER_ID,CHECKER_ID,CHANGER_ID,REGISTER_TIME,CHECK_TIME,CHANGE_TIME,LATELY_CHANGE_TIME,LATELY_TRADE_TIME,DELETE_TIME,RECOVERY_TIME,MODIFY_TAG,EXCEL_TAG,1,1,1,DESIGN_MODULE_TAG,DESIGN_PROCEDURE_TAG,DESIGN_CELL_TAG,RECOMMEND_PROVIDER_TAG,PRICE_CHANGE_TAG,PRICE_ALARM_TAG,ORDER_SALE_BONUS_RATE,ORDER_PROFIT_BONUS_RATE,RETAIL_SALE_BONUS_RATE,RETAIL_PROFIT_BONUS_RATE,COST_CALCULATE_TYPE,SERIAL_NUMBER_TAG,CALCULATE_BONUS_SN_TAG,0,0,CONCAT(FIRST_KIND_ID,SECOND_KIND_ID,THIRD_KIND_ID),CONCAT(FIRST_KIND_NAME,'-',SECOND_KIND_NAME,'-',THIRD_KIND_NAME) FROM ondemand1.design_file where check_tag<'2' 2、移植design_file_dig: INSERT INTO DESIGN_FILE_dig(PRODUCT_ID,PRODUCT_NAME,PRODUCT_NICK,PRODUCT_CLASS,type,PRODUCT_DESCRIBE,FACTORY_NAME,FACTORY_ID,AMOUNT_UNIT,PROVIDER_GROUP,PHOTO1,PHOTO2,WARRANTY,LIST_PRICE,COST_PRICE,REAL_COST_PRICE,LIFECYCLE,PERSONAL_UNIT,PERSONAL_VALUE,TWIN_NAME,TWIN_ID,REMARK,CHECK_TAG,ACHIEVEMENT_SUM,ATTACHMENT_NAME,RETURN_SUM,RETURN_AMOUNT,FILE_CHANGE_AMOUNT,USED_PRODUCT_NAME,RESPONSIBLE_PERSON_NAME,RESPONSIBLE_PERSON_ID,REGISTER,CHECKER,CHANGER,REGISTER_ID,CHECKER_ID,CHANGER_ID,REGISTER_TIME,CHECK_TIME,CHANGE_TIME,LATELY_CHANGE_TIME,LATELY_TRADE_TIME,DELETE_TIME,RECOVERY_TIME,MODIFY_TAG,EXCEL_TAG,EXCEL_TAG2,EXCEL_TAG3,EXCEL_TAG4,DESIGN_MODULE_TAG,DESIGN_PROCEDURE_TAG,DESIGN_CELL_TAG,RECOMMEND_PROVIDER_TAG,PRICE_CHANGE_TAG,PRICE_ALARM_TAG,ORDER_SALE_BONUS_RATE,ORDER_PROFIT_BONUS_RATE,RETAIL_SALE_BONUS_RATE,RETAIL_PROFIT_BONUS_RATE,COST_CALCULATE_TYPE,SERIAL_NUMBER_TAG,CALCULATE_BONUS_SN_TAG,QCS_TAG,QCS_APPLY_TAG,CHAIN_ID,CHAIN_NAME) SELECT PRODUCT_ID,PRODUCT_NAME,PRODUCT_NICK,PRODUCT_CLASS,type,PRODUCT_DESCRIBE,FACTORY_NAME,FACTORY_ID,AMOUNT_UNIT,PROVIDER_GROUP,PHOTO1,PHOTO2,WARRANTY,LIST_PRICE,COST_PRICE,REAL_COST_PRICE,LIFECYCLE,PERSONAL_UNIT,PERSONAL_VALUE,TWIN_NAME,TWIN_ID,REMARK,CHECK_TAG,ACHIEVEMENT_SUM,ATTACHMENT_NAME,RETURN_SUM,RETURN_AMOUNT,FILE_CHANGE_AMOUNT,USED_PRODUCT_NAME,RESPONSIBLE_PERSON_NAME,RESPONSIBLE_PERSON_ID,REGISTER,CHECKER,CHANGER,REGISTER_ID,CHECKER_ID,CHANGER_ID,REGISTER_TIME,CHECK_TIME,CHANGE_TIME,LATELY_CHANGE_TIME,LATELY_TRADE_TIME,DELETE_TIME,RECOVERY_TIME,MODIFY_TAG,EXCEL_TAG,excel_tag2,excel_tag3,excel_tag4,DESIGN_MODULE_TAG,DESIGN_PROCEDURE_TAG,DESIGN_CELL_TAG,RECOMMEND_PROVIDER_TAG,PRICE_CHANGE_TAG,PRICE_ALARM_TAG,ORDER_SALE_BONUS_RATE,ORDER_PROFIT_BONUS_RATE,RETAIL_SALE_BONUS_RATE,RETAIL_PROFIT_BONUS_RATE,COST_CALCULATE_TYPE,SERIAL_NUMBER_TAG,CALCULATE_BONUS_SN_TAG,0,0,CONCAT(FIRST_KIND_ID,SECOND_KIND_ID,THIRD_KIND_ID),CONCAT(FIRST_KIND_NAME,'-',SECOND_KIND_NAME,'-',THIRD_KIND_NAME) FROM ondemand1.design_file_dig 3、移植design_workflow(for design_file): insert into design_workflow(config_id,object_id,describe1,describe2,type_id) select '14',product_id,'09020001010100100000','admin','01' from design_file where check_tag='0' and excel_tag!='0' order by register_time; insert into design_workflow(config_id,object_id,describe1,describe2,checker,check_time,check_tag,type_id) select '14',product_id,'09020001010100100000','admin',checker,check_time,'1','01' from design_file where check_tag='1' and excel_tag!='0' order by register_time; 4、移植design_module: INSERT INTO DESIGN_MODULE(DESIGN_ID,PRODUCT_ID,PRODUCT_NAME,MODULE_DESCRIBE,COST_PRICE_SUM,DESIGNER,DESIGNER_ID,REGISTER,REGISTER_ID,REGISTER_TIME,CHECKER,CHANGER,CHECKER_ID,CHANGER_ID,CHECK_TIME,CHANGE_TIME,CHECK_TAG,CHANGE_TAG,EXCEL_TAG,CHAIN_ID,CHAIN_NAME) SELECT DESIGN_ID,PRODUCT_ID,PRODUCT_NAME,MODULE_DESCRIBE,COST_PRICE_SUM,DESIGNER,DESIGNER_ID,REGISTER,REGISTER_ID,REGISTER_TIME,CHECKER,CHANGER,CHECKER_ID,CHANGER_ID,CHECK_TIME,CHANGE_TIME,CHECK_TAG,CHANGE_TAG,EXCEL_TAG,CONCAT(FIRST_KIND_ID,SECOND_KIND_ID,THIRD_KIND_ID),CONCAT(FIRST_KIND_NAME,'-',SECOND_KIND_NAME,'-',THIRD_KIND_NAME) FROM ondemand1.design_module; 5、移植design_workflow(for design_module): insert into `design_workflow`(config_id,object_id, describe1,describe2,check_tag,type_id) select '13',design_id,'09020001010100100000','admin','0','03' from design_module where check_tag='0' and excel_tag='2'; 6、移植design_workflow(for design_price_change): insert into `design_workflow`(config_id,object_id, describe1,describe2,check_tag,type_id) select '4',product_id,'09020001010100100000','admin','0','02' from design_file where check_tag='1' and price_change_tag='1'; 7、移植design_module_details: insert into 'design_module_details' select * from ondemand1.design_module_details; 8、移植design_config_file_kind： 老版本用三个表来存放产品分类设置信息，而新版只用一个表存放，所以这个表的移植是最复杂的，建议如果记录数不多直接通过菜单重建一次，但要绝对注意：分类编号 一定要与旧版本的一致，因为产品档案表记录（上面已经移植）的分类编号已经固定了。 insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('5', '4', '0208 电容', '0208', '电容', 'dr', '0', '1', '0208', 'PCB控制板-电容'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('6', '4', '0209 电阻', '0209', '电阻', 'dz', '0', '1', '0209', 'PCB控制板-电阻'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('7', '4', '0210 PCB板', '0210', 'PCB板', 'PCBB', '0', '1', '0210', 'PCB控制板-PCB板'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('8', '4', '0211 继电器', '0211', '继电器', 'jdq', '0', '1', '0211', 'PCB控制板-继电器'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('9', '4', '0212 开关', '0212', '开关', 'kg', '0', '1', '0212', 'PCB控制板-开关'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('10', '4', '0213 三极管', '0213', '三极管', 'sjg', '0', '1', '0213', 'PCB控制板-三极管'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('11', '4', '0214 二极管', '0214', '二极管', 'ejg', '0', '1', '0214', 'PCB控制板-二极管'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('12', '4', '0215 数码管', '0215', '数码管', 'smg', '0', '1', '0215', 'PCB控制板-数码管'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('13', '4', '0216 LED', '0216', 'LED', 'LED', '0', '1', '0216', 'PCB控制板-LED'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('14', '4', '0217 可控硅', '0217', '可控硅', 'kkg', '0', '1', '0217', 'PCB控制板-可控硅'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('15', '4', '0218 IC', '0218', 'IC', 'ic', '0', '1', '0218', 'PCB控制板-IC'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('16', '4', '0219 跳线', '0219', '跳线', 'tx', '0', '1', '0219', 'PCB控制板-跳线'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('17', '4', '0220 IC插座', '0220', 'IC插座', 'iccz', '0', '1', '0220', 'PCB控制板-IC插座'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('18', '4', '0221 LCD支架扣', '0221', 'LCD支架扣', 'lcdzjk', '0', '1', '0221', 'PCB控制板-LCD支架扣'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('19', '4', '0222 LED柱', '0222', 'LED柱', 'ledz', '0', '1', '0222', 'PCB控制板-LED柱'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('20', '4', '0223 USB接口', '0223', 'USB接口', 'usbjk', '0', '1', '0223', 'PCB控制板-USB接口'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('21', '4', '0224 UV灯', '0224', 'UV灯', 'uvd', '0', '1', '0224', 'PCB控制板-UV灯'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('22', '4', '0225 保护套', '0225', '保护套', 'bht', '0', '1', '0225', 'PCB控制板-保护套'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('23', '4', '0226 保险丝', '0226', '保险丝', 'bxs', '0', '1', '0226', 'PCB控制板-保险丝'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('24', '4', '0227 保险丝座', '0227', '保险丝座', 'bxsz', '0', '1', '0227', 'PCB控制板-保险丝座'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('25', '4', '0228 背光板', '0228', '背光板', 'bgb', '0', '1', '0228', 'PCB控制板-背光板'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('26', '4', '0229 变换器', '0229', '变换器', 'bhq', '0', '1', '0229', 'PCB控制板-变换器'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('27', '4', '0230 变压器', '0230', '变压器', 'byq', '0', '1', '0230', 'PCB控制板-变压器'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('28', '4', '0231 插座', '0231', '插座', 'cz', '0', '1', '0231', 'PCB控制板-插座'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('29', '4', '0232 场效应管', '0232', '场效应管', 'cxyg', '0', '1', '0232', 'PCB控制板-场效应管'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('30', '4', '0233 电池壳盖', '0233', '电池壳盖', 'dckg', '0', '1', '0233', 'PCB控制板-电池壳盖'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('31', '4', '0234 电感', '0234', '电感', 'dg', '0', '1', '0234', 'PCB控制板-电感'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('32', '4', '0235 电位器', '0235', '电位器', 'dwq', '0', '1', '0235', 'PCB控制板-电位器'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('33', '4', '0236 垫片', '0236', '垫片', 'dp', '0', '1', '0236', 'PCB控制板-垫片'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('34', '4', '0237 端子', '0237', '端子', 'dz', '0', '1', '0237', 'PCB控制板-端子'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('35', '4', '0238 发光二极管', '0238', '发光二极管', 'fgejg', '0', '1', '0238', 'PCB控制板-发光二极管'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('36', '4', '0239 发射二极管', '0239', '发射二极管', 'fsejg', '0', '1', '0239', 'PCB控制板-发射二极管'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('37', '4', '0240 蜂鸣器', '0240', '蜂鸣器', 'fmq', '0', '1', '0240', 'PCB控制板-蜂鸣器'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('38', '4', '0241 高温套管', '0241', '高温套管', 'gwtg', '0', '1', '0241', 'PCB控制板-高温套管'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('39', '4', '0242 硅堆', '0242', '硅堆', 'gd', '0', '1', '0242', 'PCB控制板-硅堆'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('40', '4', '0243 接收器', '0243', '接收器', 'jsq', '0', '1', '0243', 'PCB控制板-接收器'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('41', '4', '0245 螺母', '0245', '螺母', 'lm', '0', '1', '0245', 'PCB控制板-螺母'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('42', '4', '0246 螺丝', '0246', '螺丝', 'ls', '0', '1', '0246', 'PCB控制板-螺丝'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('43', '4', '0247 氖灯', '0247', '氖灯', 'nd', '0', '1', '0247', 'PCB控制板-氖灯'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('44', '4', '0248 排线', '0248', '排线', 'px', '0', '1', '0248', 'PCB控制板-排线'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('45', '4', '0249 热敏电阻', '0249', '热敏电阻', 'rmdz', '0', '1', '0249', 'PCB控制板-热敏电阻'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('46', '4', '0250 热缩套管', '0250', '热缩套管', 'rstg', '0', '1', '0250', 'PCB控制板-热缩套管'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('47', '4', '0251 散热片', '0251', '散热片', 'srp', '0', '1', '0251', 'PCB控制板-散热片'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('48', '4', '0252 双面背胶', '0252', '双面背胶', 'smbj', '0', '1', '0252', 'PCB控制板-双面背胶'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('49', '4', '0253 套管', '0253', '套管', 'tg', '0', '1', '0253', 'PCB控制板-套管'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('50', '4', '0254 温度传感器', '0254', '温度传感器', 'wdcgq', '0', '1', '0254', 'PCB控制板-温度传感器'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('51', '4', '0255 线材', '0255', '线材', 'xc', '0', '1', '0255', 'PCB控制板-线材'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('52', '4', '0256 压敏电阻', '0256', '压敏电阻', 'ymdz', '0', '1', '0256', 'PCB控制板-压敏电阻'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('53', '4', '0257 遥控器', '0257', '遥控器', 'ygq', '0', '1', '0257', 'PCB控制板-遥控器'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('54', '4', '0258 液晶片', '0258', '液晶片', 'yjp', '0', '1', '0258', 'PCB控制板-液晶片'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('55', '4', '0259 针插', '0259', '针插', 'zc', '0', '1', '0259', 'PCB控制板-针插'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('56', '4', '0260 针座', '0260', '针座', 'zz', '0', '1', '0260', 'PCB控制板-针座'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('57', '4', '0261 振荡器', '0261', '振荡器', 'zdq', '0', '1', '0261', 'PCB控制板-振荡器'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('58', '4', '0262 包装袋', '0262', '包装袋', 'bzd', '0', '1', '0262', 'PCB控制板-包装袋'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('59', '4', '0263 QC PASS纸', '0263', 'QC PASS纸', 'passz', '0', '1', '0263', 'PCB控制板-QC PASS纸'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('60', '4', '0264 黄胶', '0264', '黄胶', 'hj', '0', '1', '0264', 'PCB控制板-黄胶'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('61', '4', '0265 扎带', '0265', '扎带', 'zd', '0', '1', '0265', 'PCB控制板-扎带'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('62', '4', '0266 热熔胶', '0266', '热熔胶', 'rrj', '0', '1', '0266', 'PCB控制板-热熔胶'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('63', '4', '0267 绝缘油', '0267', '绝缘油', 'jyy', '0', '1', '0267', 'PCB控制板-绝缘油'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('64', '4', '0268 散热油', '0268', '散热油', 'sry', '0', '1', '0268', 'PCB控制板-散热油'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('65', '4', '0269 无铅标签纸', '0269', '无铅标签纸', 'wqbqz', '0', '1', '0269', 'PCB控制板-无铅标签纸'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('66', '4', '0270 防潮漆', '0270', '防潮漆', 'fcq', '0', '1', '0270', 'PCB控制板-防潮漆'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('67', '4', '0271 QC LABEL', '0271', 'QC LABEL', 'qclabel', '0', '1', '0271', 'PCB控制板-QC LABEL'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('68', '4', '0272 防潮油', '0272', '防潮油', 'fcy', '0', '1', '0272', 'PCB控制板-防潮油'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('69', '4', '0273 导电胶条', '0273', '导电胶条', 'ddjt', '0', '1', '0273', 'PCB控制板-导电胶条'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('70', '4', '0274 白胶', '0274', '白胶', 'bj', '0', '1', '0274', 'PCB控制板-白胶'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('71', '4', '0275 弹片', '0275', '弹片', 'tp', '0', '1', '0275', 'PCB控制板-弹片'); insert into design_config_file_kind(category_id,parent_category_id,category_name,file_id,file_name,nick_name,delete_tag,details_tag,chain_id,chain_name) values('72', '4', '0276 金属弹片柱', '0276', '金属弹片柱', 'jstpz', '0', '1', '0276', 'PCB控制板-金属弹片柱'); 第七部分、常见问题处理。 　　整个恩信ERP运行环境比较复杂，涉及tomcat服务器、Mysql数据库、JRE、JDK、浏览器等，出现的问题各种各样，下面把我遇到的一些问题罗列出来，供大家参考： 　　１·恢复原先的代码，但登陆ＥＲＰ后仍然是恢复代码之前的界面。 　　原因：这是因为ｔｏｍｃａｔ服务器的缓冲导致的，ｔｏｍｃａｔ根据代码的修改时间戳来决定要不要更新缓冲，如果你早先备份的代码修改时间戳更早，那么ｔｏｍｃａｔ就不更新缓冲了，这样你的ＥＲＰ界面没有变化。 　　处理：无非就是修改代码文件的修改时间戳了。１）如果你是从压缩包解压恢复代码文件，那么这样做：鼠标右击压缩包——＞解压文件——＞点击“高级”选项卡——＞去掉“保存修改时间”前面的勾——＞确定。这样解压出来的文件的修改时间全部是当前的时间，然后重启ｔｏｍｃａｔ服务即可。２）如果你是通过文件拷贝恢复，那么也课参照上面的方法，只不过是先压缩成一个包，然后再：鼠标右击压缩包——＞解压文件——＞点击“高级”选项卡——＞去掉“保存修改时间”前面的勾——＞确定。 　　２·二次开发修改了代码，但登陆ＥＲＰ后进入相应的模块总是报“对不起，附件容量受到限制”。这个只是说明的代码中存在语法错误，仔细检查你修改的程序代码。