| | |
| | | + " a.isStartupPriceSubsystem,a.PriceSubsystemMemberLevels,a.isStartupBalancePay,\n" |
| | | + " a.isShowBuyingButton,a.isShowElectronicVoucherButton,a.PersonalAuthenticationAmount,a.PaymentCountdown, \n" |
| | | + " a.FeeRateForWxPay,a.PlatformOperatorCommissionRatio,a.WithdrawalExpiryHours,a.HelpUrl,a.isShowPreSendDate,a.ShowKeFuTelephone, \n" |
| | | + " a.isShowSurvey,a.isShowRepairRequest,a.isShowFeedBack \n" |
| | | + " a.isShowSurvey,a.isShowRepairRequest,a.isShowFeedBack,a.isShowInstallationService,a.isShowReplacementService \n" |
| | | + " from t714001 a left join t110601 b on a.DefaultShopCcCode = b.CcCode \n" |
| | | + " left join t714030 c on a.CountryId = c.CountryId \n" |
| | | + " left join t110202 d on a.ProvinceZoneId = d.ZoneId \n" |
| | |
| | | set.setShowSurvey(map.get("isShowSurvey") == null||((Integer)map.get("isShowSurvey")).equals(0) ? false :true); |
| | | set.setShowRepairRequest(map.get("isShowRepairRequest") == null||((Integer)map.get("isShowRepairRequest")).equals(0) ? false :true); |
| | | set.setShowFeedBack(map.get("isShowFeedBack") == null||((Integer)map.get("isShowFeedBack")).equals(0) ? false :true); |
| | | set.setShowInstallationService(map.get("isShowInstallationService") == null||((Integer)map.get("isShowInstallationService")).equals(0) ? false :true); |
| | | set.setShowReplacementService(map.get("isShowReplacementService") == null||((Integer)map.get("isShowReplacementService")).equals(0) ? false :true); |
| | | |
| | | //取小程序订单提醒消息 |
| | | sql = " set nocount on \n" |