# 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
```
- 翼通长租公寓管理系统
- 版本升级
- 操作手册
- 添加新店
- 给新店分配管理员(店长)
- 新店必须完成的基础信息
- 常见问题
- 翼通经销商管理系统
- 版本升级
- 聚源达印刷管理系统
- 0、升级说明及重要问题注意
- 1、订单状态说明(兼容老系统)
- 四月显示之僵尸产品
- 打印
- Html5中localStorage存储JSON数据并读取JSON数据的实现方法
- 功能说明
- 2.各种操作说明
- 升级说明
- 物联网
- CentosARM
- 树莓派(RPi) CentOS7扩展内存卡剩余空间
- 翼通管理系统快速开发框架LayUI版
- layui模块使用方法
- 默认显示自定义排序方法
- linq查询输出json小例子
- layui json格式
- treetable借鉴
- layui表单验证
- layui图标
- 第一书记信息管理系统
- 多条件查询搜索
- 年龄计算
- 家庭数据打印
- 数据打印框架
- 后台处理获取需打印数据
- js打印方法
- 图片上传
- 单图上传
- 多图上传
- 多图上传CSS样式
- 图片保存
- 高级大招
- SqlServer
- sqlserver 去重复并查询的一列数据拼接用逗号隔开显示
- 修复SqlServer孤立用户
- VS2017提高开发效率的几大技巧看过终生受用,错过继续盲目忙碌。
- 微信开发
- 微信开发基础
- 1、微信公众平台测试帐号的注册与使用
- 2、NuGet引用Senparc微信开发类
- 3、微信接入应答问文件
- 微信开发进阶
- 1、绑定用户把openid、用户头像、昵称绑定到数据库
- 2、阿里大鱼发送验证短信
- 3、测试用户是否关注公众号
- 人人商城
- 1、公众号接入配置
- 2、公众号支付配置
- 3、手机短信配置
- 4、小程序配置
- 5、店铺可视化装修
- 6、三级分销配置
- MarkDown
- 1、markdown写流程图帮助文档
- 阿里短信
- 常用短信模板
- 中国翼通基类库
- 一、说明
- 二、基类库代码(用法索引)
- 1、阿里大鱼短信
- 2、阿里云短信类
- 3、web.config操作类
- 4、字符操作类
- 5、随机数
- 6、拼音类
- 7、身份证类
- 8、SqlServer数据库操作sqleasy
- 9、JSON类
- 999、日志调试类
- 10、QRCode生成二维码
- 11、保存远程图片到本地
- 12、Session类
- 13、ip类
- 14、验证码
- 15、base64类
- 翼通CMS版本升级
- 昆明市公安局政治部
- 3D打印
- 老挝消费机
- 帮助文档
- 工作流开发
- 工作流数据库结构
- 工作流借鉴
- 思想
- 设计工作流要注意的问题
- 编译错误
- 缺少编译器要求的成员“Microsoft.CSharp.RuntimeBinder.CSharpArgumentInfo.Create"
- EasyUI操作例子
- combogrid绑定
- linq
- 建立linqToSqlServer连接
- 公租房管理系统
- 改进升级更新
- 云南民间工艺传承协会
- 思路
- 问题
- 云南麦根科技有限公司
- 月嫂多APP
- 嫂多点APP
- 管理后台
- Laravel
- 一、开发环境搭建
- 二、如何正确使用 Composer 安装 Laravel 扩展包
- 三、修改数据库连接
- 四、创建一个简单的Laravel例子
- 五. laravel维护日记
- 六、nginx下伪静态配置
- 七、增删查改知识点
- 腾讯借贷反欺诈开发
- ThinkPHP
- 0、ThinkPHP安装
- 2、Zend Studio 13.6.1 的安装和破解
- 1、thinkphp自由查询语句分页
- 3、thinkphp M R 方法详解
- 4、前台循环
- 5、laiui提交表单
- 翼通云官方网站(里面有内容)
- 开发过程中各种问题
- 小鸟云系统的坑
- 更新日志
- 单页面模板
- 翼通智慧网站策划
- 4.05到4.10升级
- phpstom
- 一、设置字体、外观
- 二、phpstom运行php教程
- 三、phpstom debug调试
- 四、PHPStorm 提示502 Bad Gateway
- vscode
- vscode常用插件
- vscode使用git翼通教程
- Git忽略提交规则 - .gitignore配置运维总结
- Git忽略文件不起作用解决方案
- vscode添加新建文件头部注释和函数注释
- git命令
- git命令大全
- vscode每次打开都会覆盖窗口
- git忽略文件格式
- ios au 更新APP store教程
- iOS APP版本更新升级教程
- 上传ipa常见错误解决方案
- 上传ipa报错版本号重复问题解决教程
- hbuider
- Hbuider制作app升级包的简单办法 (升级官方提供的案例)
- linux
- wdcp后台访问安全设置即限制域名/IP访问设置及清除方法
- MSSQL数据库
- 恢复
- SqlServer将没有log文件的数据库文件附加到服务器中
- 1、mssql2019报18456不能登录
- [简易版]幼儿园新生入学报名管理系统
- 物流园电子出门条系统
- 电脑自选超市开发
- 服务商操作手册
- 管理员操作手册
- EcShop
- 一、EcShop5.3升级5.6遇到问题
- 2、ECShop 时间相差8小时、时间不对的问题
- 3、数据库操作
- 3、嵌入类的方法
- 4、入驻商列表sql