From 0a4f165eec7585da85a0bd58444efb5eac06d35f Mon Sep 17 00:00:00 2001
From: fs-danaus <danaus314@qq.com>
Date: 星期三, 21 二月 2024 17:53:34 +0800
Subject: [PATCH] 优化多附件上传功能及业绩宝接口代码更新
---
src/com/yc/open/yejibao/service/YeJiBaoImpl.java | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/com/yc/open/yejibao/service/YeJiBaoImpl.java b/src/com/yc/open/yejibao/service/YeJiBaoImpl.java
index 27ff955..197d1df 100644
--- a/src/com/yc/open/yejibao/service/YeJiBaoImpl.java
+++ b/src/com/yc/open/yejibao/service/YeJiBaoImpl.java
@@ -693,7 +693,7 @@
" c.discount, c.cv2, c.unsubscribeDoccode\n" +
- " from t120201H b join t120201D c on b.doccode = c.doccode \n" ;
+ " from t120201H b left join t120201D c on b.doccode = c.doccode \n";
sql += " where isnull(b.cccode,'') <> '' \n"+
@@ -748,13 +748,13 @@
" end \n" +
" close mycurDeli\n" +
" deallocate mycurDeli \n" +
- " select sumtotalmoney2,docCode,convert(varchar(10),preSendDate,120) as preSendDate,docType,\n" +
+ " select isnull(sumtotalmoney2,0) as sumtotalmoney2,docCode,convert(varchar(10),preSendDate,120) as preSendDate,docType,\n" +
" cltCode,cltName,linkMan,ccCode,ccName,hDMemo, tel, \n" +
" tel2, propertyAddress,sellerName, shopGuideName,serviceName, \n" +
" dengjiname, referralsName,docStatus, docStatusName,convert(varchar(10),docDate,120) as docDate, \n" +
" actname,refCode, EnterName,companyId ,companyName,shopGuideCode,\n" +
" rowid,DocItem,MatCode ,MatName , special ,\n" +
- " uom,digit,price,totalmoney,stcode,stname,ItemMemo, \n" +
+ " uom,isnull(digit,0) as digit,isnull(price,0) as price,isnull(totalmoney,0) as totalmoney,stcode,stname,ItemMemo, \n" +
" locationName, brand, trademarkPrice, \n" +
" discount, cv2, unsubscribeDoccode\n" +
@@ -1033,7 +1033,7 @@
" declare mycurDeli cursor for\n" +
" select a.docDate,a.docCode,a.cltCode,a.cltName,a.companyID,a.companyName,a.ccCode,a.ccName,a.amount as sumAmount,a.hdMemo,b.soDoccode,b.amount,a.docType\n" +
- " from t150181H a join t150181D b on a.doccode = b.doccode \n" +
+ " from t150181H a left join t150181D b on a.doccode = b.doccode \n" +
" where a.docStatus=@mydocStatus \n" +
" and a.docCode=@myDocCode \n" +
" order by a.DocCode\n" +
--
Gitblit v1.8.0