|
|
DELETE [LANGUAGE] where name='FormAuthPassword';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'FormAuthPassword', N'Confirm Manager PassWord ', N'管理员密码确认');
|
GO
|
DELETE [LANGUAGE] where name='lbl_FormPlaceAddOrUpdate_Title';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbl_FormPlaceAddOrUpdate_Title', N'Please Input Manager PassWord ', N'请输入管理员密码!!!');
|
GO
|
DELETE [LANGUAGE] where name='lbl_FormPlaceAddOrUpdate_PLACEID';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbl_FormPlaceAddOrUpdate_PLACEID', N'Pass Word:', N'密 码 :');
|
GO
|
DELETE [LANGUAGE] where name='btn_FAP_Save';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'btn_FAP_Save', N'Please Input Manager PassWord ', N' 密 码 确 认 ');
|
GO
|
DELETE [LANGUAGE] where name='btn_FAP_Cancel';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'btn_FAP_Cancel', N'Close', N' 关 闭 ');
|
GO
|
|
|
|
|
DELETE [LANGUAGE] where name='dgvNoFinOd_TASKID';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'dgvNoFinOd_TASKID', N'task id', N'任务号');
|
GO
|
|
DELETE [LANGUAGE] where name='dgvNoFinOd_SOURCEPLACE';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'dgvNoFinOd_SOURCEPLACE', N'source place', N'起始位置');
|
GO
|
DELETE [LANGUAGE] where name='dgvNoFinOd_TOPLACE';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'dgvNoFinOd_TOPLACE', N'to place', N'目标位');
|
GO
|
DELETE [LANGUAGE] where name='dgvNoFinOd_TASKTYPEDESCRIPTION';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'dgvNoFinOd_TASKTYPEDESCRIPTION', N'task type', N'任务类别');
|
GO
|
DELETE [LANGUAGE] where name='dgvNoFinOd_RELEASESTATUS';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'dgvNoFinOd_RELEASESTATUS', N'had released', N'已下发');
|
GO
|
DELETE [LANGUAGE] where name='dgvNoFinOd_HADFINISH';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'dgvNoFinOd_HADFINISH', N'had finished', N'已完成');
|
GO
|
DELETE [LANGUAGE] where name='dgvNoFinOd_UPDATETIME';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'dgvNoFinOd_UPDATETIME', N'update time', N'更新时间');
|
GO
|
|
|
|
|
|
|
DELETE [LANGUAGE] where name='FrmSendOut_dGVUnLoadItems_CarNo';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'FrmSendOut_dGVUnLoadItems_CarNo', N'car no', N'小车编号');
|
GO
|
DELETE [LANGUAGE] where name='FrmSendOut_dGVItemQuery_CarNo';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'FrmSendOut_dGVItemQuery_CarNo', N'car no', N'小车编号');
|
GO
|
DELETE [LANGUAGE] where name='WMS_FIOR_CONTAINERNO';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WMS_FIOR_CONTAINERNO', N'car no', N'小车编号');
|
GO
|
DELETE [LANGUAGE] where name='WMS_FPVC_CONTAINERNO';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WMS_FPVC_CONTAINERNO', N'car no', N'小车编号');
|
GO
|
|
|
|
|
|
|
DELETE [LANGUAGE] where name='lbDestination';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbDestination', N'Action:', N'动作：');
|
GO
|
|
|
DELETE [LANGUAGE] where name='lbDes';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbDes', N'Action:', N'动作：');
|
GO
|
|
DELETE [LANGUAGE] where name='btn_WCS_ContinueSrmTask';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'btn_WCS_ContinueSrmTask', N'Continue Task', N'继续堆垛机任务');
|
GO
|
|
DELETE [LANGUAGE] where name='WCS_groupbox_Notice';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WCS_groupbox_Notice', N'Explain', N'说明');
|
GO
|
|
|
DELETE [LANGUAGE] where name='FrmCVIInfo_MouldId';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'FrmCVIInfo_MouldId', N'mould id', N'模具ID');
|
GO
|
|
|
|
DELETE [LANGUAGE] where name='WMS_FIOR_ITEMNO';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WMS_FIOR_ITEMNO', N'item name', N'零件名称');
|
GO
|
|
|
DELETE [LANGUAGE] where name='WMS_FIOR_ID';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WMS_FIOR_ID', N'task no', N'任务号');
|
GO
|
|
DELETE [LANGUAGE] where name='WMS_FIOR_TYPE';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WMS_FIOR_TYPE', N'car type', N'车型');
|
GO
|
|
DELETE [LANGUAGE] where name='WMS_FIOR_DelFlag_Text';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WMS_FIOR_DelFlag_Text', N'delete flag', N'是否删除');
|
GO
|
|
DELETE [LANGUAGE] where name='dGVPvcInfo_partName';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'dGVPvcInfo_partName', N'part name', N'零件名称');
|
GO
|
|
DELETE [LANGUAGE] where name='btn_Edit';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'btn_Edit', N'Edit', N'修改');
|
GO
|
|
DELETE [LANGUAGE] where name='WMS_FA_UPDATETIME';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WMS_FA_UPDATETIME', N'create time', N'发生时间');
|
GO
|
|
|
DELETE [LANGUAGE] where name='WMS_FCII_StoreId';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WMS_FCII_StoreId', N'StoreId', N'仓库号');
|
GO
|
|
|
DELETE [LANGUAGE] where name='btnEdit';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'btnEdit', N'Edit', N'编辑');
|
GO
|
|
DELETE [LANGUAGE] where name='WMS_FCI_btnAddNew';
|
INSERT INTO LANGUAGE([NAME], [ENGLISH], [CHINESE]) VALUES ( N'WMS_FCI_btnAddNew', N'Add', N'添加');
|
|
/* 初始化 WMS-库位任务显示 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='WMS_FSI_Label_Type';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FSI_Label_Type','Task Type:','任务类型:');
|
go
|
delete [LANGUAGE] where name='WMS_FSI_Label_CarType';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FSI_Label_CarType','Car Type:','车型:');
|
go
|
delete [LANGUAGE] where name='WMS_FSI_Label_SourcePlace';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FSI_Label_SourcePlace','Place:','库位:');
|
go
|
delete [LANGUAGE] where name='WMS_FSI_Label_MouldeID';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FSI_Label_MouldeID','Mould Id:','模具ID:');
|
go
|
delete [LANGUAGE] where name='WMS_FSI_Label_PartId';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FSI_Label_PartId','Part Id:','零件号:');
|
go
|
delete [LANGUAGE] where name='WMS_FSI_Label_PartName';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FSI_Label_PartName','Part Name:','零件名:');
|
go
|
delete [LANGUAGE] where name='WMS_FSI_Label_Weight';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FSI_Label_Weight','Weight:','重量:');
|
go
|
|
|
/* 初始化 WMS-人工入库-提示 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='WMS_FSI_Label_Tips';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FSI_Label_Tips','Place Push [Enter] Key For Search Info When You Input This Car Number ','输入完托盘/小车号后，请回车用以查找其绑定的零件信息');
|
go
|
|
/* 初始化 WMS-库位维护 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='WMS_FPS_ISFULL';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FPS_ISFULL','IsFull','有货');
|
go
|
delete [LANGUAGE] where name='WMS_FPS_HASTASKDOING';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FPS_HASTASKDOING','HasTaskDoing','有任务');
|
go
|
|
|
/* 初始化 WCS-删除输送线任务 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='btn_DeleteTransTask';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('btn_DeleteTransTask','Delete Task','删除任务');
|
go
|
|
/* 初始化 出入库记录-创建时间 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='FIOR_CreateTime';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('FIOR_CreateTime','create time','创建时间');
|
go
|
|
/* 初始化 记住我 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='cb_RemberPassWord';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('cb_RemberPassWord','remember me','记住我');
|
go
|
/* 初始化 全屏 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='btnFullSrceen';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('btnFullSrceen','full screen','全屏');
|
go
|
|
/* 初始化 重量 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='lbl_WCS_Weight';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('lbl_WCS_Weight','Weight:','重量:');
|
go
|
|
/* 初始化 进出库 重量 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='IOR_C_Weight';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('IOR_C_Weight','weight','重量');
|
go
|
|
/* 初始化 任务号 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='lbl_WCS_TransTaskNO';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('lbl_WCS_TransTaskNO','TaskNo：','任务号：');
|
go
|
delete [LANGUAGE] where name='lbl_WCS_SrmTaskNO';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('lbl_WCS_SrmTaskNO','TaskNo：','任务号：');
|
go
|
|
/* 初始化 WCS 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='toolStripMenuItem_ChangeLanuage';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('toolStripMenuItem_ChangeLanuage','Change Language','语言切换');
|
go
|
delete [LANGUAGE] where name='中文ToolStripMenuItem';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('中文ToolStripMenuItem','Chinese','中文');
|
go
|
delete [LANGUAGE] where name='英文ToolStripMenuItem';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('英文ToolStripMenuItem','English','英文');
|
go
|
|
/* 初始化页面【库位维护】 是否有任务执行 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='lbl_FormPlaceAddOrUpdate_HasTaskDoing';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('lbl_FormPlaceAddOrUpdate_HasTaskDoing','Has Task Doing','是否有任务');
|
go
|
|
/* 初始化页面【清理库存日志查询】 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='清理库存日志查询';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('清理库存日志查询','Stock Clear Log','清理库存日志查询');
|
go
|
delete [LANGUAGE] where name='SCL_StoreNo';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('SCL_StoreNo','store no','仓库');
|
go
|
delete [LANGUAGE] where name='SCL_PlaceNo';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('SCL_PlaceNo','place no','库位');
|
go
|
delete [LANGUAGE] where name='SCL_CarType';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('SCL_CarType','car type','车型');
|
go
|
delete [LANGUAGE] where name='SCL_ITEMNO';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('SCL_ITEMNO','item no','模具ID-零件名称');
|
go
|
delete [LANGUAGE] where name='SCL_Creator';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('SCL_Creator','creator','操作人');
|
go
|
delete [LANGUAGE] where name='SCL_CreateTime';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('SCL_CreateTime','create time','操作时间');
|
go
|
delete [LANGUAGE] where name='SCL_Remark';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('SCL_Remark','remark','说明');
|
go
|
|
|
/* 【出入库记录】增加 操作人 语言 [EditBy shaocx,2021-02-24] */
|
delete [LANGUAGE] where name='IOR_OperatorUser';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('IOR_OperatorUser','creator','创建人');
|
go
|
delete [LANGUAGE] where name='IOR_LastModifier';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('IOR_LastModifier','operator','操作人');
|
go
|
|
|
/* 增加菜单【清理库存日志查询】 [EditBy shaocx,2021-02-24] */
|
DELETE PERMISSION where PERMISSIONNAME='清理库存日志查询';
|
GO
|
INSERT INTO PERMISSION ([PERMISSIONNAME], [PERMISSIONNAMEENG]) VALUES (N'清理库存日志查询', N'Store Clear Record Query');
|
GO
|
|
|
update [LANGUAGE] set CHINESE='出库' where name='一般出库';
|
update [LANGUAGE] set CHINESE='入库' where name='一般入库';
|
update [PERMISSION] set PERMISSIONNAME='出库' where PERMISSIONNAME='一般出库';
|
update [PERMISSION] set PERMISSIONNAME='入库' where PERMISSIONNAME='一般入库';
|
|
update [LANGUAGE] set name='出库' where name='一般出库';
|
update [LANGUAGE] set name='入库' where name='一般入库';
|
|
|
delete [LANGUAGE] where name='WMS_FPS_Btn_DelStore';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FPS_Btn_DelStore','clear store','清库存');
|
go
|
|
|
TRUNCATE TABLE COLOR_VS_TYPE;
|
GO
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES ( N'X247', N'#FFFF80');
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES (N'V295', N'#80FF80');
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES ( N'v294', N'#FF0080');
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES ( N't004', N'Purple');
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES (N'PP4', N'#000040');
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES (N'凯迪拉克CTS', N'#80FF00');
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES (N'预留车型1', N'');
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES (N'预留车型2', N'');
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES (N'预留车型3', N'');
|
INSERT INTO COLOR_VS_TYPE ([TYPE], [COLOR]) VALUES (N'预留车型4', N'');
|
GO
|
|
|
|
|
DELETE [LANGUAGE] where name='btnChangeColor7';
|
GO
|
INSERT INTO LANGUAGE ([NAME], [ENGLISH], [CHINESE]) VALUES (N'btnChangeColor7', N'change color', N'修改颜色');
|
DELETE [LANGUAGE] where name='btnChangeColor8';
|
GO
|
INSERT INTO LANGUAGE ([NAME], [ENGLISH], [CHINESE]) VALUES (N'btnChangeColor8', N'change color', N'修改颜色');
|
DELETE [LANGUAGE] where name='btnChangeColor9';
|
GO
|
INSERT INTO LANGUAGE ([NAME], [ENGLISH], [CHINESE]) VALUES (N'btnChangeColor9', N'change color', N'修改颜色');
|
DELETE [LANGUAGE] where name='btnChangeColor10';
|
GO
|
INSERT INTO LANGUAGE ([NAME], [ENGLISH], [CHINESE]) VALUES (N'btnChangeColor10', N'change color', N'修改颜色');
|
|
|
DELETE [LANGUAGE] where name='lbColor7';
|
GO
|
INSERT INTO LANGUAGE ( [NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbColor7', N'color', N'颜色');
|
DELETE [LANGUAGE] where name='lbColor8';
|
GO
|
INSERT INTO LANGUAGE ( [NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbColor8', N'color', N'颜色');
|
DELETE [LANGUAGE] where name='lbColor9';
|
GO
|
INSERT INTO LANGUAGE ( [NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbColor9', N'color', N'颜色');
|
DELETE [LANGUAGE] where name='lbColor10';
|
GO
|
INSERT INTO LANGUAGE ( [NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbColor10', N'color', N'颜色');
|
DELETE [LANGUAGE] where name='lbType7';
|
GO
|
INSERT INTO LANGUAGE ([NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbType7', N'type', N'车型');
|
DELETE [LANGUAGE] where name='lbType8';
|
GO
|
INSERT INTO LANGUAGE ([NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbType8', N'type', N'车型');
|
DELETE [LANGUAGE] where name='lbType9';
|
GO
|
INSERT INTO LANGUAGE ([NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbType9', N'type', N'车型');
|
DELETE [LANGUAGE] where name='lbType10';
|
GO
|
INSERT INTO LANGUAGE ([NAME], [ENGLISH], [CHINESE]) VALUES ( N'lbType10', N'type', N'车型');
|
GO
|
|
/* 库存查询 */
|
delete [LANGUAGE] where name='dGVPvcInfo_Type';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('dGVPvcInfo_Type','car type','车型');
|
go
|
delete [LANGUAGE] where name='dGVPvcInfo_mouldId';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('dGVPvcInfo_mouldId','mould id','模具ID');
|
go
|
delete [LANGUAGE] where name='dGVPvcInfo_PartId';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('dGVPvcInfo_PartId','part id','零件号');
|
go
|
delete [LANGUAGE] where name='WMS_FPVC_PLACENO';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('WMS_FPVC_PLACENO','place no','库位号');
|
go
|
delete [LANGUAGE] where name='ISLOCK';
|
insert into [LANGUAGE](name,ENGLISH,CHINESE)values('ISLOCK','is locked','锁定');
|
go
|
