WebSite/Handlers/update.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/******2.1******/
if exists (SELECT TOP 1 ID FROM TCWL_Tree where TextShow='日志管理' and parentID='187DA6B4-CDED-4BE5-BAEE-1FB5E098CC99')
begin
	update TCWL_Tree set parentID='7AC54B65-BAA6-4ABA-9782-B38A63A60800' where TextShow='日志管理'
end
if exists (SELECT TOP 1 ID FROM TCWL_Tree where TextShow='批注日志' and parentID='187DA6B4-CDED-4BE5-BAEE-1FB5E098CC99')
begin
	update TCWL_Tree set parentID='7AC54B65-BAA6-4ABA-9782-B38A63A60800'  where TextShow='批注日志'
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_UnitOfProduct)
begin
INSERT [TCWL_All_Dic_UnitOfProduct] ([ID], [Familiar], [Complex], [English], [Name], [AddPeople], [Belong], [ServerID]) VALUES (N'1B42B5EE-5D12-44C6-BED9-7B22B16357A7', N'个', NULL, NULL, NULL, N'0', N'0', N'')
INSERT [TCWL_All_Dic_UnitOfProduct] ([ID], [Familiar], [Complex], [English], [Name], [AddPeople], [Belong], [ServerID]) VALUES (N'1FD298F5-339A-4C2B-82CD-6AA19AB15724', N'件', NULL, NULL, NULL, N'0', N'0', N'')
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_Stock)
begin
INSERT [TCWL_All_Dic_Stock] ([ID], [Familiar],  [Belong], [ServerID]) VALUES (N'18134C6E-88FB-44EE-B1D8-56177D10FB10', N'郑州仓',  N'0', N'')
INSERT [TCWL_All_Dic_Stock] ([ID], [Familiar],  [Belong], [ServerID]) VALUES(N'1AC4860A-67BB-445B-956E-179B15B43941', N'厂仓库', N'0', N'')
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_SalesStage)
begin
INSERT [TCWL_All_Dic_SalesStage] ([ID], [Familiar], [Complex], [English], [Name], [AddPeople], [ServerID], [Belong]) VALUES (N'05013C14-296B-42D0-AAC0-722332EF510D', N'合同签约', NULL, NULL, NULL, NULL, N'', N'0')
INSERT [TCWL_All_Dic_SalesStage] ([ID], [Familiar], [Complex], [English], [Name], [AddPeople], [ServerID], [Belong]) VALUES (N'1376847E-7B23-4A74-A388-99F4950D03B5', N'初期沟通', NULL, NULL, NULL, NULL, N'', N'0')
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_Reimburse)
begin
INSERT [TCWL_All_Dic_Reimburse] ([ID], [Familiar],  [Belong], [ServerID]) VALUES (N'6FC6E195-5E7A-4CBB-A827-734086096AE6', N'管理费用',  N'0', N'')
INSERT [TCWL_All_Dic_Reimburse] ([ID], [Familiar],  [Belong], [ServerID]) VALUES (N'9A0659B1-A674-4D00-AA32-25F7CB09D089', N'办公费用',  N'0', N'')
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_ProductCategories)
begin
INSERT [TCWL_All_Dic_ProductCategories] ([ID], [Familiar], [Complex], [English], [Name],  [AddPeople], [Belong], [ServerID]) VALUES (N'07AFE143-F6C4-40D0-86CE-39628A991E5D', N'衣服', NULL, NULL, NULL,N'0', N'0', N'')
INSERT [TCWL_All_Dic_ProductCategories] ([ID], [Familiar], [Complex], [English], [Name],  [AddPeople], [Belong], [ServerID]) VALUES (N'0B85662F-7BC3-47B8-877F-26D69C4E4362', N'裤子', NULL, NULL, NULL, N'0', N'0', N'')
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_Position)
begin
INSERT [TCWL_All_Dic_Position] ([ID], [Familiar], [Name],  [Belong], [ServerID], [Complex], [English], [Paixu]) VALUES (N'0290D219-ED0A-42E3-9199-E93A5A49B342', N'总经理 ', NULL, N'0', N'', NULL, NULL, 0)
INSERT [TCWL_All_Dic_Position] ([ID], [Familiar], [Name], [Belong], [ServerID], [Complex], [English], [Paixu]) VALUES (N'05ABDB8E-E811-4F71-BB4D-2D3E554EC7F8', N'项目主管', NULL,  N'0', N'', NULL, NULL, 0)
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_Overtime)
begin
INSERT [TCWL_All_Dic_Overtime] ([ID], [Familiar],  [Belong], [ServerID]) VALUES (N'50E5E8DE-97CE-4E2F-8BE5-75012B2CB55E', N'休息日', N'0', N'')
INSERT [TCWL_All_Dic_Overtime] ([ID], [Familiar],  [Belong], [ServerID]) VALUES (N'87BAC4C4-7565-4CF6-9514-CFB2346F37C5', N'工作日', N'0', N'')
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_OpportunityType)
begin
INSERT [TCWL_All_Dic_OpportunityType] ([ID], [Familiar], [Complex], [English], [Name], [TimeStr], [AddPeople], [ServerID], [Belong]) VALUES (N'0F7C23A9-1EE8-4FA9-9244-FA87B85C26E1', N'重要', NULL, NULL, NULL, CAST(0x0000A3FB012325C9 AS DateTime), NULL, N'', N'0')
INSERT [TCWL_All_Dic_OpportunityType] ([ID], [Familiar], [Complex], [English], [Name], [TimeStr], [AddPeople], [ServerID], [Belong]) VALUES (N'2E329B2E-D9C6-4C46-A524-EF95BF4E2C50', N'一般', NULL, NULL, NULL, CAST(0x0000A45E0098C4AF AS DateTime), NULL, N'', N'0')
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_GongGaoType)
begin
INSERT [TCWL_All_Dic_GongGaoType] ([ID], [Familiar], [AddPeople], [TimeStr], [Belong], [ServerID]) VALUES (N'0220CAF8-1913-44EC-90D5-CFCA8869785A', N'行业新闻', NULL, NULL, N'0', N'')
INSERT [TCWL_All_Dic_GongGaoType] ([ID], [Familiar], [AddPeople], [TimeStr], [Belong], [ServerID]) VALUES (N'04583662-6660-42ED-98FB-254ABD5DCC8B', N'公司新闻', NULL, NULL, N'0', N'')
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_CustomerStatus)
begin
INSERT [TCWL_All_Dic_CustomerStatus] ([ID], [Familiar], [Complex], [English], [Name], [TimeStr], [AddPeople], [ServerID], [Belong]) VALUES (N'0076F192-FCC6-4E43-AE6E-1E602FBEE1B6', N'新客户', NULL, NULL, NULL, CAST(0x0000A46C013F5CD5 AS DateTime), NULL, N'', N'0')
INSERT [TCWL_All_Dic_CustomerStatus] ([ID], [Familiar], [Complex], [English], [Name], [TimeStr], [AddPeople], [ServerID], [Belong]) VALUES (N'018C914F-7814-4509-A8B8-1D31FF6F33E4', N'洽谈中', NULL, NULL, NULL, CAST(0x0000A4920004A593 AS DateTime), NULL, N'', N'0')
end
if not exists (SELECT TOP 1 ID FROM TCWL_All_Dic_CustomerPriority)