| | |
| | | "@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" + |
| | |
| | | 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()) + "," + |
| | |
| | | |
| | | 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" + |
| | |
| | | } |
| | | 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())){ |