barcode.txt

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

CREATE TABLE [BarCode_^YearSeason] (
	[cType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[cBarCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cYearSeason] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL 
        CHECK ([cYearSeason]='^YearSeason'),
	[dDate] [datetime] NULL ,
	[cMarker] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_BarCode_^YearSeason] PRIMARY KEY  CLUSTERED 
	(
		[cBarCode],
		[cYearSeason]
	)  ON [PRIMARY] 
) ON [PRIMARY]