From 29c58a44a8f725637e7b18fbfc2dc826ba430561 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期五, 19 九月 2025 23:15:22 +0800
Subject: [PATCH] 1.委外领料申请（未完成） 2.物料分区
---
service/JJGZ/OaToMesRecordManager.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/service/JJGZ/OaToMesRecordManager.cs b/service/JJGZ/OaToMesRecordManager.cs
index d0c5129..8ddc4fa 100644
--- a/service/JJGZ/OaToMesRecordManager.cs
+++ b/service/JJGZ/OaToMesRecordManager.cs
@@ -168,12 +168,13 @@
if (exists)
{
// 鏇存柊
- var updateSql = @"UPDATE OA_DEPARTMENT SET name = @Name, Parentid = @Parentid WHERE Id = @Id";
+ var updateSql = @"UPDATE OA_DEPARTMENT SET name = @Name, Parentid = @Parentid, OrgId = @OrgId WHERE Id = @Id";
using (var updateCmd = new SqlCommand(updateSql, conn, tran))
{
updateCmd.Parameters.AddWithValue("@Id", item.Id);
updateCmd.Parameters.AddWithValue("@Name", item.Name ?? (object)DBNull.Value);
updateCmd.Parameters.AddWithValue("@Parentid", item.Parentid ?? (object)DBNull.Value);
+ updateCmd.Parameters.AddWithValue("@OrgId", item.OrgId ?? (object)DBNull.Value);
int rows = updateCmd.ExecuteNonQuery();
if (rows > 0) updateCount++;
}
@@ -181,12 +182,13 @@
else
{
// 鎻掑叆
- var insertSql = @"INSERT INTO OA_DEPARTMENT (id, name, Parentid) VALUES (@Id, @Name, @Parentid)";
+ var insertSql = @"INSERT INTO OA_DEPARTMENT (id, name, Parentid, OrgId) VALUES (@Id, @Name, @Parentid, @OrgId)";
using (var insertCmd = new SqlCommand(insertSql, conn, tran))
{
insertCmd.Parameters.AddWithValue("@Id", item.Id);
insertCmd.Parameters.AddWithValue("@Name", item.Name ?? (object)DBNull.Value);
insertCmd.Parameters.AddWithValue("@Parentid", item.Parentid ?? (object)DBNull.Value);
+ insertCmd.Parameters.AddWithValue("@OrgId", item.OrgId ?? (object)DBNull.Value);
int rows = insertCmd.ExecuteNonQuery();
if (rows > 0) insertCount++;
}
--
Gitblit v1.9.3