TASK#33312 收货入库管理-收货入库管理页面-01 / 技术研发中心 12月第1版本（2022年）

任务描述

完成收货入库管理页面和导出功能

需求描述

背景

改造收货入库，提升收货状态跟进，便于仓库精细化管理

需求

本地链接：

页面1：product-doc-wan.zhcxkj.com:9000/产品三组/田子豪/收货入库管理1/收货入库管理流程图.html

页面2：product-doc-wan.zhcxkj.com:9000/产品三组/田子豪/收货入库管理2/收货入库管理-12月1版本.html

页面3：product-doc-wan.zhcxkj.com:9000/产品三组/田子豪/收货入库管理3/收货入库管理-12月1版本.html

外部链接（供业务方查看）：

页面1：收货入库管理流程 (axshare.com)

页面2：收货入库管理-12月1版本 (axshare.com)

页面3：收货入库管理-12月1版本 (axshare.com)

注：需求点太多，1个页面放不下，本地链接和外部链接均有3个页面，不要漏掉

验收标准

暂无

历史记录

2022-12-01 11:43:25, 由程伟创建。
2022-12-01 18:42:38, 由 谢业福 编辑。
修改了 开发组，旧值为 ""，新值为 "1"。

表结构的设计和字段的更改和公共方法的编写

2022-12-01 18:46:14, 由 谢业福 添加备注。

1.添加字段

---- RB_Procurement_Detail_SingleList  添加字段 PrepareBuyTime
IF OBJECT_ID('RB_Procurement_Detail_SingleList ') IS NULL PRINT 'Error:Table RB_Procurement_Detail_SingleList  don''t exists!' 
ELSE 
IF not EXISTS(SELECT 1 FROM SYSOBJECTS T1 JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID WHERE T1.NAME='RB_Procurement_Detail_SingleList ' AND T2.NAME='PrepareBuyTime ')
begin
  ALTER TABLE RB_Procurement_Detail_SingleList  ADD PrepareBuyTime  DATETIME 
  EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预销单时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_Detail_SingleList ', @level2type=N'COLUMN',@level2name=N'PrepareBuyTime '
end
IF @@ERROR>0 PRINT 'Error:Failed to add column PrepareBuyTime  on table RB_Procurement_Detail_SingleList !' 
GO

---- RB_Procurement_Detail_SingleList_Detail  添加字段 PrepareBuyTime
IF OBJECT_ID('RB_Procurement_Detail_SingleList_Detail ') IS NULL PRINT 'Error:Table RB_Procurement_Detail_SingleList_Detail  don''t exists!' 
ELSE 
IF not EXISTS(SELECT 1 FROM SYSOBJECTS T1 JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID WHERE T1.NAME='RB_Procurement_Detail_SingleList_Detail ' AND T2.NAME='PrepareBuyTime ')
begin
  ALTER TABLE RB_Procurement_Detail_SingleList_Detail  ADD PrepareBuyTime  DATETIME 
  EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预销单时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_Detail_SingleList_Detail ', @level2type=N'COLUMN',@level2name=N'PrepareBuyTime '
end
IF @@ERROR>0 PRINT 'Error:Failed to add column PrepareBuyTime  on table RB_Procurement_Detail_SingleList_Detail !' 
GO
---- RB_Procurement_Detail_SingleList_Detail  添加字段 PrepareBuyAdminId
IF OBJECT_ID('RB_Procurement_Detail_SingleList_Detail ') IS NULL PRINT 'Error:Table RB_Procurement_Detail_SingleList_Detail  don''t exists!' 
ELSE 
IF not EXISTS(SELECT 1 FROM SYSOBJECTS T1 JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID WHERE T1.NAME='RB_Procurement_Detail_SingleList_Detail ' AND T2.NAME='PrepareBuyAdminId ')
begin
  ALTER TABLE RB_Procurement_Detail_SingleList_Detail  ADD PrepareBuyAdminId  int 
  EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预销单人id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_Detail_SingleList_Detail ', @level2type=N'COLUMN',@level2name=N'PrepareBuyAdminId '
end
IF @@ERROR>0 PRINT 'Error:Failed to add column PrepareBuyAdminId  on table RB_Procurement_Detail_SingleList_Detail !' 
GO
---- RB_Procurement_Detail_SingleList_Detail  添加字段 PrepareBuyUserName
IF OBJECT_ID('RB_Procurement_Detail_SingleList_Detail ') IS NULL PRINT 'Error:Table RB_Procurement_Detail_SingleList_Detail  don''t exists!' 
ELSE 
IF not EXISTS(SELECT 1 FROM SYSOBJECTS T1 JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID WHERE T1.NAME='RB_Procurement_Detail_SingleList_Detail ' AND T2.NAME='PrepareBuyUserName ')
begin
  ALTER TABLE RB_Procurement_Detail_SingleList_Detail  ADD PrepareBuyUserName  NVARCHAR(50) 
  EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预销单人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_Detail_SingleList_Detail ', @level2type=N'COLUMN',@level2name=N'PrepareBuyUserName '
end
IF @@ERROR>0 PRINT 'Error:Failed to add column PrepareBuyUserName  on table RB_Procurement_Detail_SingleList_Detail !' 
GO
---- RB_Customer_Setting_Extend  添加字段 ReceiptAndStorageWareHouseIds
IF OBJECT_ID('RB_Customer_Setting_Extend ') IS NULL PRINT 'Error:Table RB_Customer_Setting_Extend  don''t exists!' 
ELSE 
IF not EXISTS(SELECT 1 FROM SYSOBJECTS T1 JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID WHERE T1.NAME='RB_Customer_Setting_Extend ' AND T2.NAME='ReceiptAndStorageWareHouseIds ')
begin
  ALTER TABLE RB_Customer_Setting_Extend  ADD ReceiptAndStorageWareHouseIds  VARCHAR(500) 
  EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开启了收货入库功能的仓库,分割' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Customer_Setting_Extend ', @level2type=N'COLUMN',@level2name=N'ReceiptAndStorageWareHouseIds '
end
IF @@ERROR>0 PRINT 'Error:Failed to add column ReceiptAndStorageWareHouseIds  on table RB_Customer_Setting_Extend !' 
GO
--初始化线上的仓库
UPDATE RB_Customer_Setting_Extend SET ReceiptAndStorageWareHouseIds='5312' WHERE CustomerID=1

2022-12-01 18:46:48, 由 谢业福 添加备注。

2.添加表

-- 添加表 RB_Procurement_ReceiptAndStorage 
IF OBJECT_ID('RB_Procurement_ReceiptAndStorage') IS NULL 
BEGIN
CREATE TABLE [dbo].[RB_Procurement_ReceiptAndStorage](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[CustomerId] [int] NOT NULL,
	[WarehouseId] [int] NOT NULL,
	[P_Code] [varchar](50) NOT NULL,
	[ListNo] [varchar](50) NOT NULL,
	[SKU] [varchar](50) NOT NULL,
	[SingleDetailID] [int] NOT NULL,
	[NeedToPackType] [int] NOT NULL,
	[Single_NO] [varchar](50) NOT NULL,
	[IsSHJF] [bit] NOT NULL,
	[CourierNum] [nvarchar](100) NULL,
	[ReceiptTimeType] [int] NOT NULL,
	[ReceiptTime] [datetime] NOT NULL,
	[ReceiptAdminId] [int] NOT NULL,
	[ReceiptUserNmae] [nvarchar](50) NOT NULL,
	[AddTime] [datetime] NOT NULL,
	[AddAdminId] [int] NOT NULL,
	[AddUserName] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_RB_Procurement_ReceiptAndStorage] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_IsSHJF]  DEFAULT ((0)) FOR [IsSHJF]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_ReceiptTimeType]  DEFAULT ((0)) FOR [ReceiptTimeType]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'采购收货入库表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'ID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'CustomerId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仓库id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'WarehouseId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'采购单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'P_Code'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'销单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'ListNo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SKU' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'SKU'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下单详情ID：下单条码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'SingleDetailID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'打包类型，枚举：NeedToPackType' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'NeedToPackType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'Single_NO'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否是收货即发' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'IsSHJF'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'快递单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'CourierNum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0匹配时间：即销单的时候采购收货对应的快递单没有数据 1：精准匹配时间：销单的时候采购收货对应的快递单有有数据 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'ReceiptTimeType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'采购收货时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'ReceiptTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'采购收货人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'ReceiptUserNmae'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加人名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage', @level2type=N'COLUMN',@level2name=N'AddUserName'
End  
IF @@ERROR>0 PRINT 'Error:Failed to create table RB_Procurement_ReceiptAndStorage!'
GO
-- 添加表 RB_Procurement_ReceiptAndStorage_Details
IF OBJECT_ID('RB_Procurement_ReceiptAndStorage_Details') IS NULL 
BEGIN
CREATE TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[CustomerId] [int] NOT NULL,
	[ReceiptAndStorageId] [int] NOT NULL,
	[TurnoverBoxNo] [varchar](50) NULL,
	[SingleDetailID] [int] NOT NULL,
	[SourceType] [int] NOT NULL,
	[ProductType] [int] NOT NULL,
	[TaskState] [int] NOT NULL,
	[ActualBuyNum] [int] NOT NULL,
	[BuyTime] [datetime] NULL,
	[BuyAdminId] [int] NULL,
	[BuyUserName] [nvarchar](50) NULL,
	[ProcessNum] [int] NULL,
	[ProcessTime] [datetime] NULL,
	[ProcessAdminId] [int] NULL,
	[ProcessUserName] [nvarchar](50) NULL,
	[CheckNum] [int] NOT NULL,
	[CheckTime] [datetime] NULL,
	[CheckAdminId] [int] NULL,
	[CheckUserName] [nvarchar](50) NULL,
	[TallyNum] [int] NOT NULL,
	[TallyTime] [datetime] NULL,
	[TallyAdminId] [int] NULL,
	[TallyUserName] [nvarchar](50) NULL,
	[BadNum] [int] NOT NULL,
	[AddTime] [datetime] NULL,
	[AddAdminId] [int] NULL,
	[AddUserName] [nvarchar](50) NULL,
	[PutInNum] [int] NOT NULL,
	[PutInTime] [datetime] NULL,
	[PutInAdminId] [int] NULL,
	[PutInUserName] [nvarchar](50) NULL,
	[IsReturnToGood] [bit] NOT NULL,
 CONSTRAINT [PK_RB_Procurement_ReceiptAndStorage_Details] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_Details_SourceType]  DEFAULT ((0)) FOR [SourceType]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_Details_ProductType]  DEFAULT ((0)) FOR [ProductType]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_Details_TaskState]  DEFAULT ((0)) FOR [TaskState]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_Details_ActualBuyNum]  DEFAULT ((0)) FOR [ActualBuyNum]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_Details_CheckNum]  DEFAULT ((0)) FOR [CheckNum]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_Details_TallyNum]  DEFAULT ((0)) FOR [TallyNum]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_Details_BadNum]  DEFAULT ((0)) FOR [BadNum]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_Details_PutInNum]  DEFAULT ((0)) FOR [PutInNum]
ALTER TABLE [dbo].[RB_Procurement_ReceiptAndStorage_Details] ADD  CONSTRAINT [DF_RB_Procurement_ReceiptAndStorage_Details_IsReturnToGood]  DEFAULT ((0)) FOR [IsReturnToGood]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'采购收货入库详情表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'ID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'CustomerId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主表：RB_Procurement_ReceiptAndStorage的ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'ReceiptAndStorageId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'周转箱号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'TurnoverBoxNo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下单详情ID：下单条码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'SingleDetailID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'绑定来源  ：0：销单，1是采购打包，2，不良品' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'SourceType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品类型：0 正常产品，1：不良品' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'ProductType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务状态：0 待质检，1待入库，2部分入库，3已完成' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'TaskState'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'销单数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'ActualBuyNum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'销单时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'BuyTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'销单人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'BuyAdminId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'销单人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'BuyUserName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加工数量：PDA采购打包' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'ProcessNum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加工时间：PDA采购打包' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'ProcessTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加工人id：PDA采购打包' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'ProcessAdminId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加工人名：PDA采购打包' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'ProcessUserName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质检数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'CheckNum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质检时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'CheckTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质检人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'CheckAdminId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质检人名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'CheckUserName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'理货数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'TallyNum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'理货时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'TallyTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'理货人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'TallyAdminId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'理货人名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'TallyUserName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'不了品数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'BadNum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'AddTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'AddAdminId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加人名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'AddUserName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'PutInNum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'PutInTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'PutInAdminId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库人名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'PutInUserName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否是返良：质检时的不良品，不良品返回' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RB_Procurement_ReceiptAndStorage_Details', @level2type=N'COLUMN',@level2name=N'IsReturnToGood'

End  
IF @@ERROR>0 PRINT 'Error:Failed to create table RB_Procurement_ReceiptAndStorage!'
GO

2022-12-01 18:47:31, 由 谢业福 添加备注。

3.公共方法编写

2022-12-01 19:01:11, 由 谢业福 添加备注。

4.公共枚举

#region 采购收货入库枚举

        /// <summary>
        /// 采购收货绑定周转箱来源 
        /// </summary>
        public enum ReceiptAndStorageSourceType        
        {
            销单=0,
            采购打包=1,
            不良品=2
        }

        /// <summary>
        /// 采购收货任务状态
        /// </summary>
        public enum ReceiptAndStorageTaskState
        {
            待质检 = 0,
            待入库 = 1,
            部分入库 = 2,
            已完成 = 3
        }
        #endregion

2022-12-01 19:01:56, 由 谢业福 完成。
修改了 总计消耗，旧值为 "0"，新值为 "8"。
修改了 实际完成，旧值为 ""，新值为 "2022-12-01 19:01:49"。
修改了 任务状态，旧值为 "wait"，新值为 "done"。
修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2022-12-01 19:01:56"。
修改了 预计剩余，旧值为 "8"，新值为 "0"。
修改了 由谁完成，旧值为 ""，新值为 "xieyefu"。
2022-12-28 09:14:39, 由 zhengqiao 关闭。
修改了 任务状态，旧值为 "done"，新值为 "closed"。
修改了 指派给 ，旧值为 "xieyefu"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "zhengqiao"。
修改了 关闭时间，旧值为 "0000-00-00 00:00:00"，新值为 "2022-12-28 09:14:39"。
修改了 关闭原因，旧值为 ""，新值为 "done"。

基本信息
任务的一生

所属迭代	技术研发中心 12月第1版本（2022年）
所属模块	/
相关需求	收货入库管理
指派给	Closed 于 2022-12-28 09:14:39
任务类型	后端
任务标签	初始
开发组	百货开发组
任务状态	已关闭
进度	100%
优先级	P2
关键词
抄送给

由谁创建	程伟于 2022-12-01 11:43:25
由谁完成	谢业福于 2022-12-01 19:01:49
由谁取消	暂无
由谁关闭	zhengqiao 于 2022-12-28 09:14:39
关闭原因	已完成
最后编辑	zhengqiao 于 2022-12-28 09:14:39

团队	最初预计	总计消耗	预计剩余

工时信息

最初预计	8工时
总计消耗	8工时
预计剩余	0工时
预计开始	0000-00-00
实际开始	2022-12-01
截止日期	0000-00-00