You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
35 lines
1.2 KiB
35 lines
1.2 KiB
3 months ago
|
alter table Reagt_Reagent add Unit varchar(30)
|
||
|
|
alter TABLE Reagt_Reagent ALTER COLUMN UnitPrice DECIMAL(11,2)
|
||
|
|
alter TABLE Reagt_Reagent ALTER COLUMN SellingPrice DECIMAL(11,2)
|
||
|
|
alter TABLE Reagt_Entry ALTER COLUMN UnitPrice DECIMAL(11,2)
|
||
|
|
alter TABLE Reagt_Entry ALTER COLUMN SellingPrice DECIMAL(11,2)
|
||
|
|
alter TABLE Reagt_Reagent ADD Ratio int
|
||
|
|
ALTER TABLE Reagt_Entry Add Ratio int
|
||
|
|
alter TABLE Reagt_Reagent ADD SmallestUnit VARCHAR(20)
|
||
|
|
ALTER TABLE Reagt_Entry Add SmallestUnit VARCHAR(20)
|
||
|
|
|
||
|
|
--扫码出库
|
||
|
|
alter table Reagt_Stock add BarCode varchar(15)
|
||
|
|
alter table Reagt_Log add BarCode varchar(15)
|
||
|
|
|
||
|
|
|
||
|
|
--删除改为停用 -- 2022/01/26
|
||
|
|
ALTER TABLE Reagt_Reagent ADD Using BIT
|
||
|
|
|
||
|
|
|
||
|
|
--出库日志新增领用人
|
||
|
|
ALTER TABLE Reagt_Log add Receiver varchar(20)
|
||
|
|
|
||
|
|
--试剂新增对应组别以及项目
|
||
|
|
CREATE TABLE [dbo].[Reagt_Group] (
|
||
|
|
[GroupId] int IDENTITY(1,1) NOT NULL,
|
||
|
|
[GroupName] varchar(200) COLLATE Chinese_PRC_CI_AS NULL,
|
||
|
|
[GroupCode] varchar(100) COLLATE Chinese_PRC_CI_AS NULL
|
||
|
|
)
|
||
|
|
GO
|
||
|
|
|
||
|
|
|
||
|
|
ALTER TABLE Reagt_Reagent ADD GroupName varchar(200)
|
||
|
|
ALTER TABLE Reagt_Reagent ADD ReportItem varchar(200)
|
||
|
|
ALTER TABLE Reagt_Reagent ADD ReportItemCode varchar(100)
|
||
|
|
ALTER TABLE Reagt_Reagent ADD ReagentMark varchar(100)
|