# 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文檔
# 訂單狀態關系考慮

# 完善系統考慮
用戶每次操作,最好寫日志,這樣系統才完善
## 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