box.txt

二次开发模块 一、条形码的批量生成

CREATE TABLE [Box_^cYearMonth] (
	[BoxCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cYearMonth] [varchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL 
         CHECK ([cYearMonth] = '^cYearMonth'),
	[BDCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cBarCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dDate] [datetime] NULL ,
	[cMaker] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Box_^cYearMonth] PRIMARY KEY  CLUSTERED 
	(
		[BoxCode],
                [BDCode],
                [cBarCode],
		[cYearMonth]
	)  ON [PRIMARY] ,

) ON [PRIMARY]