From bfa0a4079b2ac3f363826b7e329115f88b4bf0f5 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 22 十一月 2023 10:49:20 +0800
Subject: [PATCH] 生产开报工查询增加销售单号查询
---
VueWebApi/DLL/DAL/ErpSyncMesDAL.cs | 29 +++++++++++++++++++++++++++--
1 files changed, 27 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs b/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs
index 144322d..2002ae7 100644
--- a/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs
+++ b/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs
@@ -1,6 +1,7 @@
锘縰sing Dapper;
using System;
using System.Collections.Generic;
+using System.Data;
using System.Linq;
using System.Web;
using VueWebApi.Tools;
@@ -196,15 +197,39 @@
#endregion
#region[鐢熶骇绠＄悊锛氱敓浜ц鍗曞悓姝
- public static ToMessage SeaveSearchErpOrder()
+ public static ToMessage SeaveSearchErpOrder(string stu_torgcode,string stu_torgtypecode)
{
var sql = "";
var dynamicParams = new DynamicParameters();
try
{
+ if (stu_torgcode == "" || stu_torgcode == null)
+ {
+ stu_torgcode = "";
+ }
+ if (stu_torgtypecode == "D")
+ {
+ sql = @" with CTE as (
+ select id, org_code,org_name, parent_id
+ from TOrganization A
+ where org_code =@stu_torgcode
+ union all
+ select A.id,A.org_code,A.org_name,A.parent_id
+ from TOrganization A
+ inner join CTE on A.parent_id = CTE.id
+ )
+ select org_code,org_name from CTE";
+ dynamicParams.Add("@stu_torgcode", stu_torgcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ stu_torgcode=string.Join(",", data.AsEnumerable().Select(row => row.Field<string>("org_code")));
+ //stu_torgcode = string.Join(",", data.AsEnumerable().Select(row => $"'{row.Field<string>("org_code")}'"));
+ //LogHelper.WriteLogData("鑾峰彇杞﹂棿缂栫爜锛�"+stu_torgcode);
+ }
//瀛樺偍杩囩▼鍚�
sql = @"h_p_IFCLD_ERPMO";
- bool a = DapperHelper.IsProcedureNo(sql);
+ dynamicParams.Add("@stu_torgcode", stu_torgcode);
+ dynamicParams.Add("@stu_torgtypecode", stu_torgtypecode);
+ bool a = DapperHelper.IsProcedure(sql, dynamicParams);
if (a)
{
mes.code = "200";
--
Gitblit v1.9.3