| | |
| | | + " @RestrictBuyingQuantity money=?,@FreeId int = ?,@TransCosts money = ?,@Description varchar(max) = ?,@Images varchar(200) = ? \n" |
| | | + " declare @UserCode varchar(50) = ?,@CltCode varchar(20) = ?,@CltName varchar(80),@cccode varchar(20) ,@Rowid varchar(20),@DocItem int\n" |
| | | + " declare @OpenId varchar(200) = ? \n" |
| | | + " declare @SellerId int,@SellerOpenId varchar(200),@SellerNickName nvarchar(400) , @SellerWeiXinAvatarUnid varchar(50) \n" |
| | | + " declare @CompanyId varchar(20),@CompanyName varchar(80),@DefaultCcCode varchar(20) \n" |
| | | + " select @DefaultCcCode = cccode from t714001 \n" |
| | | + " select top 1 @CompanyId = a.CompanyId,@CompanyName = a.CompanyName from ocompany a \n" |
| | |
| | | for (int i = 0;panicBuyingEntity.getSellerList()!=null&& i < panicBuyingEntity.getSellerList().size(); i++) { |
| | | sql += " begin \n" |
| | | + " exec getXXXX @rowid output\n" |
| | | + " select @DocItem = isnull(@DocItem,0) + 10 \n" |
| | | + " insert into t710802D(DocCode,Rowid,DocItem,SellerId,SellerName,Telephone,isDefaultSellerName) \n" |
| | | + " values(@DocCode,@RowId,@DocItem," +panicBuyingEntity.getSellerList().get(i).getSellerId() + ",'" +panicBuyingEntity.getSellerList().get(i).getSellerName()+"','"+panicBuyingEntity.getSellerList().get(i).getTelephone() + "',"+ (panicBuyingEntity.getSellerList().get(i).getIsDefaultSellerName()?1:0) + ") \n" |
| | | + " select @DocItem = isnull(@DocItem,0) + 10 ,@SellerId = " + panicBuyingEntity.getSellerList().get(i).getSellerId() +" \n" |
| | | + " select @SellerOpenId = a.SellerOpenId,@SellerNickName = a.SellerNickName , @SellerWeiXinAvatarUnid = a.SellerWeiXinAvatarUnid \n" |
| | | + " from t710801 a where a.SellerId = @SellerId \n" |
| | | + " insert into t710802D(DocCode,Rowid,DocItem,SellerId,SellerName,Telephone,isDefaultSellerName,SellerOpenId,SellerNickName,SellerWeiXinAvatarUnid) \n" |
| | | + " values(@DocCode,@RowId,@DocItem," +panicBuyingEntity.getSellerList().get(i).getSellerId() + ",'" +panicBuyingEntity.getSellerList().get(i).getSellerName()+"','"+panicBuyingEntity.getSellerList().get(i).getTelephone() + "',"+ (panicBuyingEntity.getSellerList().get(i).getIsDefaultSellerName()?1:0) + ",@SellerOpenId,@SellerNickName,@SellerWeiXinAvatarUnid) \n" |
| | | + " end \n" ; |
| | | } |
| | | sql += " exec p710802Save @DocCode \n" |
| | |
| | | |
| | | orderEntity.setCltCode(map.get("CltCode")== null?"":(String)map.get("CltCode") ); |
| | | orderEntity.setCltName(map.get("CltName")== null?"":(String)map.get("CltName") ); |
| | | orderEntity.setTelephone(map.get("Telephone")== null?"":(String)map.get("Telephone") ); |
| | | orderEntity.setCcCode(map.get("CcCode")== null?"":(String)map.get("CcCode") ); |
| | | orderEntity.setCcName(map.get("CcName")== null?"":(String)map.get("CcName") ); |
| | | orderEntity.setLinkMan(map.get("LinkMan")== null?"":(String)map.get("LinkMan") ); |
| | |
| | | @Override |
| | | public Integer deletePayingExpiredOrder(String docCode) { |
| | | String sql = " set nocount on \n" |
| | | + " declare @DocCode varchar(20) = ?,@DocStatus int \n" |
| | | + " declare @DocCode varchar(20) = ?,@DocStatus int,@myrowcount int \n" |
| | | + " declare @RefCode varchar(20),@RefFormId int,@Digit money , @PayableSecondBalance bigint \n" |
| | | + " select @RefCode = a.RefCode,@RefFormId = a.RefFormId,@Digit = a.Digit , @DocStatus = a.DocStatus, \n" |
| | | + " @PayableSecondBalance = DATEDIFF(SECOND,getdate(), a.PayingExpiredDate ) \n" |
| | |
| | | + " declare @DocCode varchar(20) = ? ,@CltCode varchar(50)\n" |
| | | + " declare @currency varchar(20),@BalancePayAmount money,@CompanyId varchar(20) \n" |
| | | + " declare @AccountsReceivableAcctCode varchar(20),@FeeAmountAcctCode varchar(20)\n" |
| | | + " declare @Balance money ,@msg varchar(2000)\n" |
| | | + " declare @Balance money ,@msg varchar(2000)\n" |
| | | + " declare @PayableSecondBalance bigint \n" |
| | | + " declare @myrowcount int ,@myerror int \n" |
| | | + " select @AccountsReceivableAcctCode = AccountsReceivableAcctCode ,\n" |
| | | + " @FeeAmountAcctCode=BankCostAcctCode \n" |