From 65d64a3359b31dd71ea2a18df8b08d05b1232970 Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期五, 12 十二月 2025 14:54:30 +0800
Subject: [PATCH] 数据库添加字段用于区分部门表与工作中心信息
---
MES.Service/service/BasicData/SysDepartmentManager.cs | 7 ++++---
1 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/MES.Service/service/BasicData/SysDepartmentManager.cs b/MES.Service/service/BasicData/SysDepartmentManager.cs
index dd8c947..700d796 100644
--- a/MES.Service/service/BasicData/SysDepartmentManager.cs
+++ b/MES.Service/service/BasicData/SysDepartmentManager.cs
@@ -53,7 +53,7 @@
{
var result = db.Updateable<SysDepartment>()
.SetColumns(s => s.Depextr4 == status)
- .Where(s => s.Id == departmentId).ExecuteCommand();
+ .Where(s => s.Id == departmentId && s.TypeByTable==0).ExecuteCommand();
if (result > 0)
return true;
@@ -75,7 +75,7 @@
private bool DeleteDepartment(SqlSugarScope db, decimal departmentId)
{
var deleteById = db.Deleteable<SysDepartment>()
- .Where(s => s.Id == departmentId).ExecuteCommand();
+ .Where(s => s.Id == departmentId && s.TypeByTable==0).ExecuteCommand();
if (deleteById > 0)
return true;
@@ -128,11 +128,12 @@
{
// 鏌ユ壘鏄惁宸插瓨鍦ㄧ浉鍚岀紪鐮佺殑璁板綍銆�
var existingCustomer = Db.Queryable<SysDepartment>()
- .Where(s => s.Departmentcode == department.FNumber)
+ .Where(s => s.Departmentcode == department.FNumber && s.TypeByTable==0)
.First();
var entity = new SysDepartment
{
+ TypeByTable=0,//鐢ㄤ簬鍖哄垎閮ㄩ棬琛ㄤ笌宸ヤ綔涓績淇℃伅锛�0/1锛�
// 濡傛灉瀛樺湪锛屼娇鐢ㄧ幇鏈夌殑ID锛屽悗缁皢鍒犻櫎鍚庨噸鏂版彃鍏�
// 濡傛灉涓嶅瓨鍦紝璁句负0锛孖nsertOrUpdate鏂规硶灏嗙敓鎴愭柊ID
Id = existingCustomer?.Id ?? 0,
--
Gitblit v1.9.3