From 124dd32a34ced09ae87935e953dec6401d86f9ac Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期四, 26 十二月 2024 15:14:45 +0800
Subject: [PATCH] PDA扫码模块，根据条码删除缓存列表中对应条码记录调用方法修改，增加根据托条码删除对应记录
---
WebAPI/Service/YqnDal.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/WebAPI/Service/YqnDal.cs b/WebAPI/Service/YqnDal.cs
index b5e1b93..06fe816 100644
--- a/WebAPI/Service/YqnDal.cs
+++ b/WebAPI/Service/YqnDal.cs
@@ -19,7 +19,7 @@
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("select top 1 HBillType,HInterID,HDate,HBillNo,HICMOBillNo,HEmpID,HProcID from Sc_StationInBillMain where HBillType='3790' ");
- sqlBuilder.Append(" and HICMOBillNo=@icmoBillNo ");
+ sqlBuilder.Append(" and HProcExchBillNo=@icmoBillNo ");
sqlBuilder.Append(" and HProcID=@hProcID");
var model = SqlPools.GetInstance("YqnConn").GetModel<Models.M_StationBillMail>(sqlBuilder.ToString(), new { icmoBillNo,hProcID });
return model;
@@ -34,7 +34,7 @@
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("select top 1 HBillType,HInterID,HDate,HBillNo,HICMOBillNo,HEmpID,HProcID from Sc_StationOutBillMain where HBillType in ('3791','4788') ");
- sqlBuilder.Append(" and HICMOBillNo=@icmoBillNo ");
+ sqlBuilder.Append(" and HProcExchBillNo=@icmoBillNo ");
sqlBuilder.Append(" and HProcID=@hProcID");
var model = SqlPools.GetInstance("YqnConn").GetModel<Models.M_StationBillMail>(sqlBuilder.ToString(), new { icmoBillNo, hProcID });
return model;
--
Gitblit v1.9.1