数据源编辑界面添加一个字段PaymentMethod （在线支付）

xinyb_

2021-10-12 25c8e4b3b144c1e2792d2455bed29994b9ca55be

数据源编辑界面添加一个字段PaymentMethod （在线支付）

 WebRoot/demo/update1.jsp

@@ -211,6 +211,20 @@
    </div>
 </div>
<fieldset class="layui-elem-field layui-field-title">
    <legend>在线支付</legend>
</fieldset>
    <div class="layui-form-item">
        <label class="layui-form-label">支付方式</label>
        <div class="layui-input-block">
            <select name="PaymentMethod" lay-filter="pay">
                <option value="">&nbsp;</option>
                <option value="PaymentOnlineForABC">江苏农行e收款</option>
                <option value="QuickPaymentForABC">全国农行商易付</option>
                <option value="UseWeChatAlipayIndependently">独立使用微信支付宝</option>
            </select>
        </div>
    </div>
<fieldset class="layui-elem-field layui-field-title">
  <legend>其他选项</legend>
</fieldset>
 <div class="layui-form-item">

 src/com/yc/entity/DataSourceEntity.java

@@ -69,7 +69,17 @@
    private String protocol = null ;  //传输协议： http  or https  , 用于 手机 移动端使用 
    private boolean isAutoGenerateFormId = false ;  //是否自动生成功能号
    private String tengXunMapLocationServiceKey = null ; //腾讯位置服务地图选点
	

    private String PaymentMethod;//在线支付 xin 2021-10-12 11:29:06

    public String getPaymentMethod() {
        return PaymentMethod;
    }

    public void setPaymentMethod(String paymentMethod) {
        PaymentMethod = paymentMethod;
    }

    public String getTengXunMapLocationServiceKey() {
        return tengXunMapLocationServiceKey;
    }

 src/com/yc/service/demo/DemoImpl.java

@@ -35,7 +35,7 @@
            + " a.MpMchId,a.MpMchName,a.MpMchKey,a.isDisabledOpenNextPeriodId,a.InvitationCode,\n"
            + " a.SystemAccessKey,a.SystemSecretKey,a.DockingSystem,a.isUseAPP,a.isShowInLoginPage,\n"
            + " case when a.LogoIcon is null then 0 else 1 end as hasLogoIcon,a.Protocol,a.isAutoGenerateFormId, \n"
            + " a.TengXunMapLocationServiceKey \n";
            + " a.TengXunMapLocationServiceKey,a.PaymentMethod \n";

    public int getComPanyId(String cltSN) {

@@ -210,6 +210,7 @@
        dataSourceEntity.setProtocol(map.get("Protocol") == null ? "" : (String)map.get("Protocol") );
        dataSourceEntity.setAutoGenerateFormId(map.get("isAutoGenerateFormId") != null &&map.get("isAutoGenerateFormId").equals(1)?true:false );
        dataSourceEntity.setTengXunMapLocationServiceKey(map.get("TengXunMapLocationServiceKey") == null?"": (String)map.get("TengXunMapLocationServiceKey"));
        dataSourceEntity.setPaymentMethod(map.get("PaymentMethod") == null?"":(String)map.get("PaymentMethod"));
        return dataSourceEntity ;
    }

@@ -230,6 +231,7 @@
                + " @MpMchKey varchar(50) = ? , @GeoWebApiKey varchar(200) =? ,@isDisabledOpenNextPeriodId int = ?,@InvitationCode varchar(20) =? , \n"
                + " @SystemAccessKey varchar(150) = ?,@SystemSecretKey varchar(150) = ?,@DockingSystem varchar(50) = ?,@isUseAPP int = ?,\n"
                + " @isShowInLoginPage int = ?, @LogoIcon varbinary(max) = ?,@isAutoGenerateFormId int = ?,@TengXunMapLocationServiceKey varchar(50) = ? \n"
                + " @PaymentMethod varchar(50) = ? \n"
                + " if isnull(@dbid,0) = 0  \n"
                + " begin \n"
                + "    select @dbid = id  from gsystem where systemid= @systemID  \n"
@@ -253,7 +255,7 @@
                + "       isAutoGenerateFormId = @isAutoGenerateFormId,isUseAPP = @isUseAPP \n"
                //+ "       isShowInLoginPage = @isShowInLoginPage \n"
                + "       " + (dataSourceEntity.isHasLogoIcon() ? "" : ",LogoIcon = @LogoIcon") + " \n"
                + "       , TengXunMapLocationServiceKey = @TengXunMapLocationServiceKey \n"
                + "       , TengXunMapLocationServiceKey = @TengXunMapLocationServiceKey,PaymentMethod=@PaymentMethod \n"
                + "    where id= @dbid ;  \n"
                + "    select @@rowcount ; \n"
                + "    return ;  \n"
@@ -277,7 +279,7 @@
                        dataSourceEntity.getGeoWebApiKey(),dataSourceEntity.isDisabledOpenNextPeriodId()?1:0,dataSourceEntity.getInvitationCode(),
                        dataSourceEntity.getSystemAccessKey(),dataSourceEntity.getSystemSecretKey(),
                        dataSourceEntity.getDockingSystem(),dataSourceEntity.isUseAPP()?1:0,dataSourceEntity.isShowInLoginPage()?1:0,dataSourceEntity.getLogoIcon(),
                        dataSourceEntity.isAutoGenerateFormId()?1:0,dataSourceEntity.getTengXunMapLocationServiceKey()
                        dataSourceEntity.isAutoGenerateFormId()?1:0,dataSourceEntity.getTengXunMapLocationServiceKey(),dataSourceEntity.getPaymentMethod()
                }) ;
    
        return ret ; 
@@ -299,7 +301,8 @@
                + " @MpMchId varchar(50) = ?,@MpMchName varchar(50) = ?, \n"
                + " @MpMchKey varchar(50) = ? , @GeoWebApiKey varchar(200) =? ,@isDisabledOpenNextPeriodId int = ?,@InvitationCode varchar(20) =?, \n"
                + " @SystemAccessKey varchar(150) = ?,@SystemSecretKey varchar(150) = ?,@DockingSystem varchar(50) = ?,@isUseAPP int = ?,@isShowInLoginPage int = ?,\n"
                + " @LogoIcon varbinary(max) = ? , @Protocol varchar(20) = ?,@isAutoGenerateFormId int = ?,@TengXunMapLocationServiceKey varchar(50) = ? \n"
                + " @LogoIcon varbinary(max) = ? , @Protocol varchar(20) = ?,@isAutoGenerateFormId int = ?,@TengXunMapLocationServiceKey varchar(50) = ?,\n"
                + " @PaymentMethod varchar(50) = ?\n"
                + " if isnull(@dbid,0) = 0  \n"
                + " begin \n"
                + "    select @dbid = id  from gsystem where systemid= @systemID  \n"
@@ -319,7 +322,8 @@
                + "       isDisabledOpenNextPeriodId = @isDisabledOpenNextPeriodId,InvitationCode = @InvitationCode, \n"
                + "       SystemAccessKey = @SystemAccessKey,SystemSecretKey = @SystemSecretKey,DockingSystem = @DockingSystem,isUseAPP = @isUseAPP, \n"
                + "       isShowInLoginPage = @isShowInLoginPage,"+(dataSourceEntity.isHasLogoIcon()?"":"LogoIcon = @LogoIcon, ") + "\n"
                + "       Protocol = @Protocol,isAutoGenerateFormId = @isAutoGenerateFormId,TengXunMapLocationServiceKey = @TengXunMapLocationServiceKey \n"
                + "       Protocol = @Protocol,isAutoGenerateFormId = @isAutoGenerateFormId,TengXunMapLocationServiceKey = @TengXunMapLocationServiceKey, \n"
                + "       PaymentMethod = @PaymentMethod \n"
                + "    where id= @dbid ;  \n"
                + "    select @dbid ; \n"
                + " end else \n"
@@ -330,14 +334,14 @@
                + "       CorpURL,MpAppId,MpSecret,MpToken,MpAesKey,MpOrgId,\n"
                + "       MiniAppId,MiniAppSecret,MiniAppToken,MiniAppAesKey,MiniAppOrgId,\n"
                + "       MpMchId,MpMchName,MpMchKey,GeoWebApiKey,isDisabledOpenNextPeriodId,InvitationCode,\n"
                + "       SystemAccessKey,SystemSecretKey,DockingSystem,isUseAPP,isShowInLoginPage,LogoIcon ,Protocol,isAutoGenerateFormId,TengXunMapLocationServiceKey)\n"
                + "       SystemAccessKey,SystemSecretKey,DockingSystem,isUseAPP,isShowInLoginPage,LogoIcon ,Protocol,isAutoGenerateFormId,TengXunMapLocationServiceKey,PaymentMethod)\n"
                + "   values (@systemID,@systemDescribe,@host,@userid,@password,@db,@port,@actived,@domain,@smsUid,@smsKey, \n"
                + "       @isShowAttendanceButton,@LimitUserNumber,@systemType,@expiredDate,@LimitDepartmentNumber, \n"
                + "       @Remarks,@DataCheckPageNum,@CorpId,\n"
                + "       @CorpURL,@MpAppId,@MpSecret,@MpToken,@MpAesKey,@MpOrgId,\n"
                + "       @MiniAppId,@MiniAppSecret,@MiniAppToken,@MiniAppAesKey,@MiniAppOrgId,\n"
                + "       @MpMchId,@MpMchName,@MpMchKey,@GeoWebApiKey,@isDisabledOpenNextPeriodId,@InvitationCode, \n"
                + "       @SystemAccessKey,@SystemSecretKey,@DockingSystem,@isUseAPP,@isShowInLoginPage,@LogoIcon,@Protocol,@isAutoGenerateFormId,@TengXunMapLocationServiceKey) \n"
                + "       @SystemAccessKey,@SystemSecretKey,@DockingSystem,@isUseAPP,@isShowInLoginPage,@LogoIcon,@Protocol,@isAutoGenerateFormId,@TengXunMapLocationServiceKey,@PaymentMethod) \n"

                + "   select @@IDENTITY  \n"
                + " end  \n";
@@ -360,7 +364,7 @@
                        dataSourceEntity.getSystemAccessKey(),dataSourceEntity.getSystemSecretKey(),
                        dataSourceEntity.getDockingSystem(),dataSourceEntity.isUseAPP()?1:0,dataSourceEntity.isShowInLoginPage()?1:0,
                        dataSourceEntity.getLogoIcon(),dataSourceEntity.getProtocol() ,dataSourceEntity.isAutoGenerateFormId()?1:0,
                        dataSourceEntity.getTengXunMapLocationServiceKey()
                        dataSourceEntity.getTengXunMapLocationServiceKey(),dataSourceEntity.getPaymentMethod()
                 }) ;
    
        return ret ;