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