From 4266249facaf325f71deb203bddf6f2c8a864048 Mon Sep 17 00:00:00 2001
From: xinyb <574600396@qq.com>
Date: 星期四, 06 六月 2024 16:26:33 +0800
Subject: [PATCH] 售后管理postName值获取
---
src/com/yc/sdk/weixincp3rd/service/AfterSalesImpl.java | 16 ++++++----------
1 files changed, 6 insertions(+), 10 deletions(-)
diff --git a/src/com/yc/sdk/weixincp3rd/service/AfterSalesImpl.java b/src/com/yc/sdk/weixincp3rd/service/AfterSalesImpl.java
index b9b0d0f..c7ea2e8 100644
--- a/src/com/yc/sdk/weixincp3rd/service/AfterSalesImpl.java
+++ b/src/com/yc/sdk/weixincp3rd/service/AfterSalesImpl.java
@@ -34,11 +34,9 @@
"@companyId varchar(10),@companyName varchar(100),@seq int =" + param.getSeq() + "," +
"@ccCode varchar(50),@ccName varchar(50),"+
"@Longitude varchar(50),@Latitude varchar(50),@FullAddressName varchar(200)," +
- "@FullAddress varchar(300),@Street varchar(200)," +
- "@postCode varchar(50),@postName varchar(50)\n";
+ "@FullAddress varchar(300),@Street varchar(200)\n";
if (StringUtils.isNotBlank(param.getOpenId())) {
- sql += "select @cltCode=cltCode,@cltName=cltName,@postCode=postCode," +
- "@postName=postName,@ccCode=ccCode,@ccName=ccName," +
+ sql += "select @cltCode=cltCode,@cltName=cltName,@ccCode=ccCode,@ccName=ccName," +
"@companyId=companyId,@companyName=companyName from t110203 where MiniAppOpenId=" + GridUtils.prossSqlParm(param.getOpenId()) + "\n";
sql += " if isnull(@cltCode,'') = '' \n " +
" begin \n" +
@@ -53,7 +51,7 @@
sql += " exec sp_newdoccode 640210,'SYSTEM',@docCode output\n";
sql += "insert into t640210H(docCode,formId,docDate,periodID,ccCode,ccName,DocStatus,LastDocStatus,PostCode,PostName,companyId,companyName,AcceptSource,cltCode,cltName,tel," +
"PropertyAddress,PreSendDate,Memo,enterDate,UploadFiles,seq,Longitude,Latitude,FullAddressName,Street)" +
- " values (@docCode," + param.getFormId() + ",convert(varchar(10),getdate(),120),convert(varchar(7),getdate(),120),@ccCode,@ccName,0,0,@postCode,@postName,@companyId,@companyName,'鎶ヤ慨',@cltCode," +
+ " values (@docCode," + param.getFormId() + ",convert(varchar(10),getdate(),120),convert(varchar(7),getdate(),120),@ccCode,@ccName,0,0,'system','灏忕▼搴忕',@companyId,@companyName,'鎶ヤ慨',@cltCode," +
GridUtils.prossSqlParm(param.getCltName()) + "," + GridUtils.prossSqlParm(param.getTel()) + ",@FullAddress," +
GridUtils.prossSqlParm(param.getPreSendDate()) + "," +
GridUtils.prossSqlParm(param.getMemo()) + ",getdate()," + GridUtils.prossSqlParm(param.getUploadFiles()) + "," +
@@ -118,11 +116,9 @@
sql += "declare @docCode varchar(50) ,@cltCode varchar(50)='',@cltName varchar(200)='',@tel varchar(50)=''," +
"@ccCode varchar(50),@ccName varchar(50),"+
- "@propertyAddress varchar(200),@companyId varchar(10),@companyName varchar(100)," +
- "@postCode varchar(50),@postName varchar(50)\n";
+ "@propertyAddress varchar(200),@companyId varchar(10),@companyName varchar(100)\n";
if (StringUtils.isNotBlank(param.getOpenId())) {
- sql += "select @cltCode=cltCode,@cltName=cltName,@postCode=postCode," +
- "@postName=postName,@ccCode=ccCode,@ccName=ccName,@tel=tel," +
+ sql += "select @cltCode=cltCode,@cltName=cltName,@ccCode=ccCode,@ccName=ccName,@tel=tel," +
"@propertyAddress=PropertyAddress,@companyId=companyId,@companyName=companyName from t110203 where MiniAppOpenId=" + GridUtils.prossSqlParm(param.getOpenId()) + "\n";
sql+=" if isnull(@cltCode,'') = '' \n " +
" begin \n" +
@@ -132,7 +128,7 @@
}
sql += " exec sp_newdoccode 640210,'SYSTEM',@docCode output\n";
sql += "insert into t640210H(docCode,formId,ccCode,ccName,DocStatus,LastDocStatus,PostCode,PostName,docDate,periodID,companyId,companyName,AcceptSource,cltCode,cltName,tel,PropertyAddress,Memo,enterDate,UploadFiles)" +
- " values (@docCode," + param.getFormId() + ",@ccCode,@ccName,0,0,@postCode,@postName,convert(varchar(10),getdate(),120),convert(varchar(7),getdate(),120),@companyId,@companyName,'鎶曡瘔',@cltCode,@cltName,@tel,@propertyAddress," +
+ " values (@docCode," + param.getFormId() + ",@ccCode,@ccName,0,0,'system','灏忕▼搴忕',convert(varchar(10),getdate(),120),convert(varchar(7),getdate(),120),@companyId,@companyName,'鎶曡瘔',@cltCode,@cltName,@tel,@propertyAddress," +
GridUtils.prossSqlParm(param.getMemo()) + ",getdate()," + GridUtils.prossSqlParm(param.getUploadFiles()) + ") \n";
sql+=" exec dbo.p640210post 'SYSTEM','绯荤粺绠＄悊鍛�',@docCode,640210,0,'鎻愪氦','','','' \n";
if(StringUtils.isNotBlank(param.getUploadFiles())){
--
Gitblit v1.8.0