将小程序物料编号长度改为50个位长

johnswang

2024-05-06 69a4b80c94a4880b1cdf8ecc8ec7dc12b06764f1

将小程序物料编号长度改为50个位长

 src/com/yc/sdk/shopping/service/CartImpl.java

@@ -262,7 +262,7 @@
    public List<CartEntity> getMatCodesByGroupBuying(String matCode,Double quantity,SkuMatCodeEntity skuMatCodeEntity) {
        if (matCode==null||"".equals(matCode)) return null ;
        String sql = " set nocount on ; \n"
                + " declare @MatCode varchar(20) = " + GridUtils.prossSqlParm(matCode) + " ,@Quantity money = " + quantity +" \n;"
                + " declare @MatCode varchar(50) = " + GridUtils.prossSqlParm(matCode) + " ,@Quantity money = " + quantity +" \n;"
                + " declare @TotalQuantity money,@TotalAmount money,@TotalWeight money \n"
                + " declare @MaxPreSendDateTime datetime = getdate() ,@MaxPreSendMinutes int; \n"
                + " declare @table table(CartId int,UserCode varchar(20),UserName varchar(50), \n"

 src/com/yc/sdk/shopping/service/CouponImpl.java

@@ -357,7 +357,7 @@
                + " declare @cartIds varchar(max) = "+GridUtils.prossSqlParm(cartIds)+" , @CltCode varchar(50) = "+GridUtils.prossSqlParm(cltCode)+" \n;"
                + " declare @ShopCcCode varchar(50) = "+GridUtils.prossSqlParm(shopCcCode)+ "\n"
                + " declare @TotalQuantity money,@TotalAmount money ; \n"
                + " declare @table table (MatCode varchar(20),MatGroup varchar(50),Brand varchar(50), \n"
                + " declare @table table (MatCode varchar(50),MatGroup varchar(50),Brand varchar(50), \n"
                + "     Quantity money,Price money,Amount money,TotalQuantity money,TotalAmount money) \n"
                + " insert into @table(    MatCode,MatGroup,Brand,Quantity,Price,Amount )  \n"
                + " select a.MatCode,b.MatGroup,b.Brand,a.Quantity,a.Price,a.Amount \n"

 src/com/yc/sdk/shopping/service/confirm/ConfirmImpl.java

@@ -34,7 +34,7 @@
                + "    @PreSendDate varchar(20) = "+GridUtils.prossSqlParm(confirmEntity.getPreSendDate() ==null?null:sdf.format(confirmEntity.getPreSendDate() ))+",@SelectedCartIds varchar(max) = "+GridUtils.prossSqlParm(confirmEntity.getSelectedCartIds())+" , @Comment varchar(2000) = "+GridUtils.prossSqlParm(confirmEntity.getComment())+",@Points int = "+confirmEntity.getPoints()+",@BalancePayAmount money ="+confirmEntity.getBalancePayAmount()+", \n"
                + "    @WeiXinPayAmount money = "+confirmEntity.getWeiXinPayAmount()+",@DocCode varchar(50) = null,@DocStatus int = null ,@isAllowPayable int =null,\n"
                + "    @DeliveryMethod varchar(50) ="+GridUtils.prossSqlParm(confirmEntity.getDeliveryMethod())+",@FromUserId varchar(50) = "+GridUtils.prossSqlParm(confirmEntity.getFromUserId())+",@FromOpenId varchar(200) = "+GridUtils.prossSqlParm(confirmEntity.getFromOpenId())+" ,@DocType varchar(50) = '微信团购订单',@GroupBuyingDocCode varchar(20) = "+GridUtils.prossSqlParm(confirmEntity.getGroupBuyingDocCode())+", \n"
                + "    @MatCode varchar(20) = "+GridUtils.prossSqlParm(confirmEntity.getMatCode())+",@Quantity money = "+confirmEntity.getQuantity()+" , @CartId int ,@myRowCount int \n"
                + "    @MatCode varchar(50) = "+GridUtils.prossSqlParm(confirmEntity.getMatCode())+",@Quantity money = "+confirmEntity.getQuantity()+" , @CartId int ,@myRowCount int \n"
                + " declare @skuId1 int = "+skuMatCodeEntity.getSkuId1()+",@skuId2 int = "+skuMatCodeEntity.getSkuId2()+",@skuId3 int = "+skuMatCodeEntity.getSkuId3()+",@skuId4 int = "+skuMatCodeEntity.getSkuId4()+", \n"
                + "   @skuId5 int = "+skuMatCodeEntity.getSkuId5()+",@skuId6 int = "+skuMatCodeEntity.getSkuId6()+",@skuId7 int = "+skuMatCodeEntity.getSkuId7()+",@skuId8 int = "+skuMatCodeEntity.getSkuId8()+",@skuId9 int = "+skuMatCodeEntity.getSkuId9()+",@skuId10 int = "+skuMatCodeEntity.getSkuId10()+" \n"
                + " declare @skuName1 varchar(50),@skuName2 varchar(50),@skuName3 varchar(50),@skuName4 varchar(50),@skuName5 varchar(50), \n"

 src/com/yc/sdk/shopping/service/order/OrderImpl.java

@@ -366,7 +366,7 @@
    @Override
    public List<GroupBuyingEntity> getGroupBuyingOrderSummarry(String matCode) {
        String sql = " set nocount on \n"
                + " declare @MatCode varchar(20) = "+GridUtils.prossSqlParm(matCode)+" ,@GroupBuyingMembers int,@FoundGroupBuyingMembers int, \n"
                + " declare @MatCode varchar(50) = "+GridUtils.prossSqlParm(matCode)+" ,@GroupBuyingMembers int,@FoundGroupBuyingMembers int, \n"
                + "     @OpenId varchar(200),@GroupBuyingStartTime datetime,@GroupBuyingEndTime datetime,@GroupBuyingDocCode varchar(20) \n"
                + " declare @table table(GroupBuyingDocCode varchar(20) Primary Key,OpenId varchar(200),FoundGroupBuyingMembers int,index index1(OpenId)) \n"
                + " select @GroupBuyingMembers = a.GroupBuyingMembers,@GroupBuyingStartTime =a.GroupBuyingStartTime, \n"

 src/com/yc/sdk/shopping/service/reward/RewardImpl.java

@@ -85,7 +85,7 @@
                + " declare @table table(NO int,TotalRowCount int,CltCode varchar(20),CltName varchar(80), \n"
                + "       FormId int,FormName varchar(120),DocCode varchar(20),PointsItem varchar(20), \n"
                + "       PointsName varchar(50),DocType varchar(50),DocDate datetime,DcFlag varchar(20), \n"
                + "       InPoints money,OutPoints money ,MatCode varchar(20),MatName varchar(120),\n"
                + "       InPoints money,OutPoints money ,MatCode varchar(50),MatName varchar(120),\n"
                + "       Special varchar(120),Uom varchar(20),Digit money ,InsertTime datetime,seq int,Balance money,\n"
                + "       SubCltCode varchar(50),SubCltName varchar(80) ) ; \n"