From 17e4c7e3e7b3ef60d9da6de3b2a39a14a53c38a0 Mon Sep 17 00:00:00 2001
From: z8018 <1282578289@qq.com>
Date: 星期三, 12 三月 2025 14:11:33 +0800
Subject: [PATCH] 1
---
WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Seed/QuartzJobCreateDataTabel.cs | 16 ++++++++++++----
1 files changed, 12 insertions(+), 4 deletions(-)
diff --git a/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Seed/QuartzJobCreateDataTabel.cs b/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Seed/QuartzJobCreateDataTabel.cs
index 8fddbce..e96cc65 100644
--- a/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Seed/QuartzJobCreateDataTabel.cs
+++ b/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Seed/QuartzJobCreateDataTabel.cs
@@ -111,13 +111,21 @@
else
dic[i].Add("CreateDate", DateTime.Now);
}
- string str = $"SET IDENTITY_INSERT {t.Name} ON;";
+ string str = "";
+ if (DBContext.DbType == SqlSugar.DbType.SqlServer)
+ {
+ str += $"SET IDENTITY_INSERT {t.Name} ON;";
- str += dbContext.Db.Insertable(dic).AS(t.Name).ToSqlString();
+ str += dbContext.Db.Insertable(dic).AS(t.Name).ToSqlString();
- str += ($"SET IDENTITY_INSERT {t.Name} OFF;");
+ str += ($"SET IDENTITY_INSERT {t.Name} OFF;");
- dbContext.Db.Ado.ExecuteCommand(str);
+ dbContext.Db.Ado.ExecuteCommand(str);
+ }
+ else
+ {
+ dbContext.Db.Insertable(dic).AS(t.Name).ExecuteCommand();
+ }
ConsoleHelper.WriteSuccessLine($"Table [{t.Name}] SeedData Added Successfully");
}
--
Gitblit v1.9.3