ThinkChat2.0新版上线,更智能更精彩,支持会话、画图、阅读、搜索等,送10W Token,即刻开启你的AI之旅 广告
# 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,片,盒,�,批,单张,个·,份,对,把,单张单位,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 ```