0、升級說明及重要問題注意 · 翼通系統開發

# 2018-10-31 1、優化了進銷存進貨出貨強制關聯用戶ID（便于以后用戶來往對賬）， 2、財務記賬關閉了合計數（財務記賬時，沒有應付，只有實付）方便以后做統計匯總， 3、增加了財務報表（經銷商往來對賬表） # 2018-10-30 20:19 1、應付匯總表修改為"供應商往來對賬" 2、應收匯總表修改為"匯總表" # 2018-10-30 1、完善了工作流（手機版及PC版），工作流可自定義流程，工作流和其他不掛鉤，可以任意發起工作流。 2、新增表FlowInstance ``` /****** Object: Table [dbo].[FlowInstance] Script Date: 2018-10-30 09:42:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FlowInstance]( [KeyId] [int] IDENTITY(1,1) NOT NULL, [InstanceSchemeId] [int] NOT NULL, [Code] [varchar](200) NULL, [CustomName] [varchar](200) NULL, [ActivityId] [varchar](50) NOT NULL, [ActivityType] [int] NULL, [ActivityName] [varchar](200) NULL, [PreviousId] [varchar](50) NOT NULL, [SchemeContent] [varchar](max) NULL, [SchemeId] [int] NOT NULL, [DbName] [varchar](50) NULL, [FrmData] [text] NULL, [FrmType] [int] NOT NULL, [FrmContentData] [text] NULL, [FrmContentParse] [text] NULL, [FrmId] [int] NOT NULL, [SchemeType] [varchar](50) NULL, [Disabled] [int] NOT NULL, [CreateDate] [datetime] NULL, [CreateUserId] [int] NOT NULL, [CreateUserName] [varchar](50) NULL, [FlowLevel] [int] NOT NULL, [Description] [varchar](200) NULL, [IsFinish] [int] NOT NULL, [MakerList] [varchar](1000) NULL, CONSTRAINT [PK_FLOWINSTANCE] PRIMARY KEY NONCLUSTERED ( [KeyId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[FlowInstance] ADD CONSTRAINT [DF__FlowInsta__FrmTy__7A1D154F] DEFAULT ((0)) FOR [FrmType] GO ALTER TABLE [dbo].[FlowInstance] ADD CONSTRAINT [DF__FlowInsta__Disab__7B113988] DEFAULT ((0)) FOR [Disabled] GO ALTER TABLE [dbo].[FlowInstance] ADD CONSTRAINT [DF__FlowInsta__Creat__7C055DC1] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[FlowInstance] ADD CONSTRAINT [DF__FlowInsta__FlowL__7CF981FA] DEFAULT ((0)) FOR [FlowLevel] GO ALTER TABLE [dbo].[FlowInstance] ADD CONSTRAINT [DF__FlowInsta__IsFin__7DEDA633] DEFAULT ((0)) FOR [IsFinish] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主鍵Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'KeyId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程實例模板Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'InstanceSchemeId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'實例編號' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自定義名稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'CustomName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'當前節點ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'ActivityId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'當前節點類型（0會簽節點）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'ActivityType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'當前節點名稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'ActivityName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前一個ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'PreviousId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程模板內容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'SchemeContent' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程模板ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'SchemeId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'數據庫名稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'DbName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表單數據' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'FrmData' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表單類型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'FrmType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表單中的控件屬性描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'FrmContentData' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表單控件位置模板' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'FrmContentParse' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表單ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'FrmId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程類型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'SchemeType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效標志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'Disabled' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建用戶主鍵' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'CreateUserId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建用戶' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'CreateUserName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'等級' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'FlowLevel' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'實例備注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否完成' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'IsFinish' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'執行人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance', @level2type=N'COLUMN',@level2name=N'MakerList' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作流流程實例表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstance' GO ``` 3、FlowInstanceOperationHistory ``` /****** Object: Table [dbo].[FlowInstanceOperationHistory] Script Date: 2018-10-30 09:44:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FlowInstanceOperationHistory]( [KeyId] [int] IDENTITY(1,1) NOT NULL, [InstanceId] [int] NOT NULL, [Content] [nvarchar](200) NULL, [CreateDate] [datetime] NOT NULL, [CreateUserId] [int] NOT NULL, [CreateUserName] [varchar](50) NULL, [NodeName] [varchar](50) NULL, [VerificationFinally] [varchar](50) NULL, [VerificationOpinion] [varchar](500) NULL, CONSTRAINT [PK_FLOWINSTANCEOPERATIONHISTOR] PRIMARY KEY NONCLUSTERED ( [KeyId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[FlowInstanceOperationHistory] ADD CONSTRAINT [DF__FlowInsta__Creat__00CA12DE] DEFAULT (getdate()) FOR [CreateDate] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主鍵Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory', @level2type=N'COLUMN',@level2name=N'KeyId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'實例進程Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory', @level2type=N'COLUMN',@level2name=N'InstanceId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作內容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory', @level2type=N'COLUMN',@level2name=N'Content' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建用戶主鍵' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory', @level2type=N'COLUMN',@level2name=N'CreateUserId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建用戶' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory', @level2type=N'COLUMN',@level2name=N'CreateUserName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'節點名稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory', @level2type=N'COLUMN',@level2name=N'NodeName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'審核類型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory', @level2type=N'COLUMN',@level2name=N'VerificationFinally' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'審核結果' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory', @level2type=N'COLUMN',@level2name=N'VerificationOpinion' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作流實例操作記錄' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceOperationHistory' GO ``` 4、新增表 FlowInstanceTransitionHistory ``` /****** Object: Table [dbo].[FlowInstanceTransitionHistory] Script Date: 2018-10-30 09:44:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FlowInstanceTransitionHistory]( [KeyId] [int] IDENTITY(1,1) NOT NULL, [InstanceId] [int] NOT NULL, [FromNodeId] [varchar](50) NOT NULL, [FromNodeType] [int] NULL, [FromNodeName] [varchar](200) NULL, [ToNodeId] [varchar](50) NOT NULL, [ToNodeType] [int] NULL, [ToNodeName] [varchar](200) NULL, [TransitionSate] [int] NOT NULL, [IsFinish] [int] NOT NULL, [CreateDate] [datetime] NULL, [CreateUserId] [int] NOT NULL, [CreateUserName] [varchar](50) NULL, [VerificationFinally] [varchar](500) NULL, [VerificationOpinion] [varchar](500) NULL, CONSTRAINT [PK_FLOWINSTANCETRANSITIONHISTO] PRIMARY KEY NONCLUSTERED ( [KeyId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[FlowInstanceTransitionHistory] ADD CONSTRAINT [DF__FlowInsta__Trans__03A67F89] DEFAULT ((0)) FOR [TransitionSate] GO ALTER TABLE [dbo].[FlowInstanceTransitionHistory] ADD CONSTRAINT [DF__FlowInsta__IsFin__049AA3C2] DEFAULT ((0)) FOR [IsFinish] GO ALTER TABLE [dbo].[FlowInstanceTransitionHistory] ADD CONSTRAINT [DF__FlowInsta__Creat__058EC7FB] DEFAULT (getdate()) FOR [CreateDate] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主鍵Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'KeyId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'實例Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'InstanceId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'開始節點Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'FromNodeId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'開始節點類型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'FromNodeType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'開始節點名稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'FromNodeName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'結束節點Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'ToNodeId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'結束節點類型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'ToNodeType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'結束節點名稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'ToNodeName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轉化狀態' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'TransitionSate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否結束' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'IsFinish' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轉化時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作人Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'CreateUserId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作人名稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'CreateUserName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1:同意；2：不同意；3：駁回' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'VerificationFinally' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'意見' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory', @level2type=N'COLUMN',@level2name=N'VerificationOpinion' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作流實例流轉歷史記錄' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowInstanceTransitionHistory' GO ``` 5、增加導航菜單 ``` GO SET IDENTITY_INSERT [dbo].[Sys_Navigations] ON GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (188, N'工作流', N'#', 1, N'icon-chart_organisation', N'/css/icon/16/chart_organisation.png', 1, 0, N'flow', N'/css/icon/32/chart_organisation.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (189, N'工作流方案', N'/flow/FlowScheme.aspx', 1, N'icon-plugin_edit', N'/css/icon/16/plugin_edit.png', 1, 188, N'flowedit', N'/css/icon/32/plugin_edit.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (190, N'工作流實例', N'/flow/FlowInstance.aspx', 1, N'icon-chart_curve', N'/css/icon/16/chart_curve.png', 1, 188, N'FlowInstance_list', N'/css/icon/32/chart_curve.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (191, N'工作流操作記錄', N'/flow/FlowInstanceOperationHistory.aspx', 1, N'icon-date_edit', N'/css/icon/16/date_edit.png', 1, 188, N'FlowInstanceOperationHistory_list', N'/css/icon/32/date_edit.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (192, N'工作流流轉記錄', N'/flow/FlowInstanceTransitionHistory.aspx', 1, N'icon-arrow_branch', N'/css/icon/16/arrow_branch.png', 1, 188, N'FlowInstanceTransitionHistory_list', N'/css/icon/32/arrow_branch.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (193, N'所有流程', N'/flow/FlowList.aspx', 0, N'icon-plugin', N'/css/icon/16/plugin.png', 1, 188, N'allflow', N'/css/icon/32/plugin.png', 0, 400, 300) GO SET IDENTITY_INSERT [dbo].[Sys_Navigations] OFF GO ``` 6、FlowScheme ``` SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FlowScheme]( [KeyId] [int] IDENTITY(1,1) NOT NULL, [SchemeCode] [varchar](50) NULL, [SchemeName] [varchar](200) NULL, [SchemeType] [varchar](50) NULL, [SchemeVersion] [varchar](50) NULL, [SchemeCanUser] [varchar](max) NULL, [SchemeContent] [varchar](max) NULL, [FrmId] [int] NULL, [FrmType] [int] NOT NULL, [AuthorizeType] [int] NOT NULL, [SortCode] [int] NOT NULL, [DeleteMark] [int] NOT NULL, [Disabled] [int] NOT NULL, [Description] [varchar](200) NULL, [CreateDate] [datetime] NULL, [CreateUserId] [int] NULL, [CreateUserName] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [ModifyUserId] [int] NULL, [ModifyUserName] [varchar](50) NULL, CONSTRAINT [PK_FLOWSCHEME] PRIMARY KEY NONCLUSTERED ( [KeyId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[FlowScheme] ADD CONSTRAINT [DF__FlowSchem__FrmTy__6ADAD1BF] DEFAULT ((0)) FOR [FrmType] GO ALTER TABLE [dbo].[FlowScheme] ADD CONSTRAINT [DF__FlowSchem__Autho__6BCEF5F8] DEFAULT ((0)) FOR [AuthorizeType] GO ALTER TABLE [dbo].[FlowScheme] ADD CONSTRAINT [DF__FlowSchem__SortC__6CC31A31] DEFAULT ((0)) FOR [SortCode] GO ALTER TABLE [dbo].[FlowScheme] ADD CONSTRAINT [DF__FlowSchem__Delet__6DB73E6A] DEFAULT ((0)) FOR [DeleteMark] GO ALTER TABLE [dbo].[FlowScheme] ADD CONSTRAINT [DF__FlowSchem__Disab__6EAB62A3] DEFAULT ((0)) FOR [Disabled] GO ALTER TABLE [dbo].[FlowScheme] ADD CONSTRAINT [DF__FlowSchem__Creat__6F9F86DC] DEFAULT (getdate()) FOR [CreateDate] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主鍵Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'KeyId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程編號' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'SchemeCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程名稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'SchemeName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程分類' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'SchemeType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程內容版本' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'SchemeVersion' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程模板使用者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'SchemeCanUser' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程內容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'SchemeContent' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表單ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'FrmId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表單類型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'FrmType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模板權限類型：0完全公開,1指定部門/人員' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'AuthorizeType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序碼' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'SortCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'刪除標記' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'DeleteMark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'Disabled' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'備注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建用戶主鍵' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'CreateUserId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建用戶' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'CreateUserName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用戶主鍵' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'ModifyUserId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用戶' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme', @level2type=N'COLUMN',@level2name=N'ModifyUserName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作流模板信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FlowScheme' GO ``` 表jydOrder 增加字段 ywy ywyid 業務員及業務員ID 表jydOrderDetail 增加字段omainid 同主表KeyId # 無用字段 ### 1、表jydOrder name ### 2、表jydOrder address # 重要問題注意 ### 1、修改接件單接件數量不能增加,若用戶需要增加印刷品數量,只能重新下單 ### 2、為了兼容老系統，業務員不驗證，不然點擊編輯出不來 ### 3、老系統需與新系統形成統一規范，客戶名稱不能一個字 ### 4、開單印刷類型必須進行驗證 ### 5、為了兼容老系統,運輸和費用不必填 ### 6、印刷品單位已增加一個“本”和“1”（1是為了兼容老系統） ### 7、流程單開紙尺寸：正數、放數，翻版要求，必填 # BUG修正 ### 2018-10-09 ### 1、外加工匯總隱藏了導出和多選 ### 2、外加工匯總排序改為倒序 ### 3、接件辦理添加了業務員、開單員 ### 4、修改了后加工的金額大寫 ### 5、修改了后加工單的字體大小 ### 6、Psi_OrderMain.aspx 修正采購單位吧單位名稱和ID寫入數據庫 ### 7、進銷存和財務關聯付款金額為“-” Psi_Order 增加實付字段shifu ### 8、匯總表打印刪除客戶名稱及收款情況，增加頁眉打印時間，金額，預付款，欠款合計 ### 9、接件辦理加上時間篩選 ### 10、二維碼半兼容了老系統，要查看老系統的二維碼必須打開接件單或者流程單點擊確定之后才能生成二維碼，這樣二維碼才能生成,已作廢的和全單收款的不能生成, ### 11、后有boss二次進行改動利用base64內存存儲生成兼容了老系統,查看和打印都可用 ### 12、二次修改了匯總表結清按鈕 ### 13、修改了訂單來源不顯示 ### 14、“預警產品”修改商品管理低于當前時間四個月不用的商品單行變色{這是預警產品剛開始時做的鏈接,需要可加上/css/icon/32/exclamation.png} ### 15、修改了接件辦理訂單狀態篩選 ### 16、隱藏了手機版客戶提交訂單 ### 17、匯總計算欠款為空的時候報錯,已作廢的訂單不進行欠款匯總計算,作廢時修改訂單金額小計為0 ### 18、統計庫存總量做了一個空判斷 ### 19、匯總表修改了已結清的欠款為0 ### 20、PC版接件辦理所有操作進行了輸出日志 ***** ### 1、客戶comnameid沒有寫進主表jydOrder, ### 2、jydOrder表中字段jpm沒有寫進數據庫 ### 3、接件開單的時候印刷品名稱必填 ### 4、接件日期修改為當前日期 ### 5、業務員不能寫進數據庫的問題 ### 6、畫冊內頁單位必填 ### 7、修改接件單檢測到畫冊的時候自動彈出畫冊內頁 ### 8、搜索印刷品名稱不出來 # 老系統問題 ### 1、接件單位數值雜亂，現已統一，需在數據字典中進行統一規范添加（g個,條,只,漲,fgh,扇,個,平方, 張,箱,平米,頂,張.,臺,塊,枚,和,張, 本,=,米,公斤,粘,根,幅,11,片,盒,&#65533;,批,單張,個·,份,對,把,單張單位,tyu,P,l,賬,\\\-\\\-,\\\-,張f ,\\\-\\\-\\\-,奧術大師,冊,令,包,張·,套,經,串,畫冊單位,點,盒10,紙,種,各,z,咋好難過,本,tyy,勝多負少,平方米,捆,卷,1,付,桶,章,副,件） # 常見問題 ### 1、當開啟Ajax異步開啟時，工藝數據灌輸出錯，可關閉異步開啟同步 # 訂單狀態查詢說明 ``` select * from ks_order where 1=1 and status like '%4%' order by id desc 作廢單 select * from ks_order where 1=1 and status like '%2%' order by id desc 送貨簽收單 select * from ks_order where 1=1 and status like '%1%' order by id desc 流程單 select * from ks_order where 1=1 and status like '%0%' order by id desc 接件單如果status 為null 或者空狀態未知 ``` # 思考 ### 訂單來源微信,網絡，廠部 ### 增加一個外加工列表可以查可以打 ### 客戶綁定 1點鏈接---獲取手機驗證碼（庫里有的客戶才能綁定）-----綁定成功 openid 頭像昵稱 ### 員工綁定 1點鏈接獲取手機驗證碼（庫里有的客戶才能綁定）綁定成功 openid 頭像昵稱 ### 客戶催單催了之后整單背景變紅發送所有模板消息給管理員 ### 流程催單 1、掃二維碼后顯示訂單信息+工藝 2、點擊之后記錄操作人員+工藝完成時間反映工作做到哪一步+微信模板消息催促下一伙人(下一個工藝辦理) 訂單信息 1001 折頁完成-------------------------> 陳婷婷時間完成折頁燙金腹膜 # 手機界面 ## (用戶)訂單查詢 ## 用戶下單 ## 員工綁定 ## 我的訂單--->點了之后訂單列表客戶可以催 ## 訂單顏色說明粉色用戶手機提交黃色用戶催紅色物品超過4個月沒用 ### 做/weixin/error.aspx?title=只有我公司員工才能訪問本頁! 報錯頁面 ###查詢訂單放到我的訂單 ###loading改為weui的Toast ###域名下的iopenid如果沒有就更新一次數據庫數據,沒有就重新綁定,用手機號查openID有沒有綁定,如果綁定對比openID是否一樣,不一樣就用更新為現有的openID ###匯總表打印word文檔 # 訂單狀態關系考慮 ![](https://box.kancloud.cn/d6aace7c838b391d8174bf0c9bd116f8_776x683.png) # 完善系統考慮用戶每次操作,最好寫日志,這樣系統才完善 ## 2018-10-9數據庫升級腳本 ``` SET IDENTITY_INSERT [dbo].[Sys_DicCategory] ON INSERT [dbo].[Sys_DicCategory] ([KeyId], [Title], [Code], [Sortnum], [Remark]) VALUES (77, N'刪除標記', N'scbj', 1, N'') INSERT [dbo].[Sys_DicCategory] ([KeyId], [Title], [Code], [Sortnum], [Remark]) VALUES (78, N'科目類型', N'fylx', 1, N'') SET IDENTITY_INSERT [dbo].[Sys_DicCategory] OFF SET IDENTITY_INSERT [dbo].[Sys_Dics] ON INSERT [dbo].[Sys_Dics] ([KeyId], [Title], [Code], [Sortnum], [ParentId], [CategoryId], [Remark], [Status], [IsDefault]) VALUES (560, N'閑置', N'閑置', 1, 0, 76, N'', 1, 0) INSERT [dbo].[Sys_Dics] ([KeyId], [Title], [Code], [Sortnum], [ParentId], [CategoryId], [Remark], [Status], [IsDefault]) VALUES (561, N'使用', N'使用', 1, 0, 77, N'', 1, 0) INSERT [dbo].[Sys_Dics] ([KeyId], [Title], [Code], [Sortnum], [ParentId], [CategoryId], [Remark], [Status], [IsDefault]) VALUES (562, N'停用', N'停用', 1, 0, 77, N'', 1, 0) INSERT [dbo].[Sys_Dics] ([KeyId], [Title], [Code], [Sortnum], [ParentId], [CategoryId], [Remark], [Status], [IsDefault]) VALUES (563, N'收入', N'In', 1, 0, 78, N'', 1, 0) INSERT [dbo].[Sys_Dics] ([KeyId], [Title], [Code], [Sortnum], [ParentId], [CategoryId], [Remark], [Status], [IsDefault]) VALUES (564, N'支出', N'Out', 1, 0, 78, N'', 1, 0) SET IDENTITY_INSERT [dbo].[Sys_Dics] OFF ----增加字段---- go alter table MJaccountingSubjects add [usetype] [varchar](50) NULL --多個字段用,號隔開 go ----菜單升級----- GO SET IDENTITY_INSERT [dbo].[Sys_Navigations] ON GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (182, N'財務管理', N'/report/center.aspx', 1, N'icon-chart_curve', N'', 1, 0, N'caiwu', N'/css/icon/32/chart_curve.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (183, N'銀行賬戶設置', N'/MJBankAccount/MJBankAccount.aspx', 1, N'icon-application_tile_vertical', N'', 1, 182, N'bankset', N'/css/icon/32/application_tile_vertical.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (184, N'費用科目設置', N'/MJaccountingSubjects/MJaccountingSubjects.aspx', 1, N'icon-application_view_tile', N'', 1, 182, N'feiyong', N'/css/icon/32/application_view_tile.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (185, N'財務記賬', N'/mjfinancemain/mjfinance.aspx', 1, N'icon-calculator_edit', N'', 1, 182, N'financeedit', N'/css/icon/32/calculator_edit.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (186, N'財務明細', N'/mjfinancemain/mjfinanceInfo.aspx', 1, N'icon-chart_curve', N'', 1, 182, N'financeInfo', N'/css/icon/32/chart_curve.png', 0, 400, 300) GO INSERT [dbo].[Sys_Navigations] ([KeyId], [NavTitle], [Linkurl], [Sortnum], [iconCls], [iconUrl], [IsVisible], [ParentID], [NavTag], [BigImageUrl], [IsNewWindow], [WinWidth], [WinHeight]) VALUES (187, N'應付匯總表', N'/JydOrder/Jydyinfu.aspx', 1, N'icon-bricks', N'/css/icon/16/bricks.png', 1, 169, N'yingfu', N'/css/icon/32/bricks.png', 0, 400, 300) SET IDENTITY_INSERT [dbo].[Sys_Navigations] OFF GO ```