以维护日期的不同而改变显示内容. 如今天是 21 号. 维护了七天的数据即 21-- 28 . 当在 22 号打开维护界面的时候,维护内容显示为 22 -- 29 号的数据以及日期.
创建维护表:..

-----------------创建数据记录表-------------------------

if exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[Pdl_WeekProcedure]'''') and OBJECTPROPERTY(id, N''''IsUserTable'''') = 1)

drop table Pdl_WeekProcedure

GO 

if not exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[Pdl_WeekProcedure]'''') and OBJECTPROPERTY(id, N''''IsUserTable'''') = 1)

 BEGIN

        Create Table Pdl_WeekProcedure (

        [Id] int Identity(1,1) Not Null,

        [DateId] datetime Not Null ,

        [Partnum] varchar(20) Null ,

        [Revision] varchar(5) Null DEFAULT(''''0''''),

        [Todate] datetime Null,

        [Qnty1] int Null Default(0),

        [Qnty2] int Null Default(0),

        [Qnty3] int Null Default(0),

        [Qnty4] int Null Default(0),

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ...  下一页 >>