From 430f4df6519253ffaf49f2d098ac1df77aa5891e Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期四, 11 九月 2025 14:43:02 +0800
Subject: [PATCH] 销售出库添加一行'制单人'
---
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