变更oracle访问组件

wzp

2023-03-02 374ce4ffd0c459bb4067e8d5765f972668aff9b1

 web/web/GwSp.aspx

@@ -2,7 +2,7 @@
<asp:Content runat="server" ID="Content1" ContentPlaceHolderID="head">
    <link href="../static/select2/select2.css" type="text/css" rel="stylesheet" />
    <script src="../static/select2/select2.js" language="javascript" type="text/javascript"></script>
 
    <script type="text/javascript" src="/web/js/jquery.min.js?v=2.1.4"></script>
    
    <script type="text/javascript" language="javascript">
        $(document).ready(function() {
@@ -17,14 +17,14 @@
                var clientID = $("#clientID").val();
                var opID = $("#opID").val();
                var routerType = $("#routerType").val();
                var clientName = $("#clientName").val();
                var company = $("#company").val();
                var chargeType = $("#chargeType").val();
                var resendStatus = $("#RESEND_STATUS").val();
                var productId = $("#productId").val();
                $.ajax({
                    url: "GwSp.ashx",
                    type: "POST",
                    data: { action: "loadGwSpAccountPageList", spID: spID, apID: apID, opID: opID, routerType: routerType, clientID: clientID, clientName: clientName, chargeType: chargeType, pageIndex: pagination.getPageIndex(), pageSize: pagination.getPageSize(), resendStatus: resendStatus, productId: productId },
                    data: { action: "loadGwSpAccountPageList", spID: spID, apID: apID, opID: opID, routerType: routerType, clientID: clientID, company: company, chargeType: chargeType, pageIndex: pagination.getPageIndex(), pageSize: pagination.getPageSize(), resendStatus: resendStatus, productId: productId },
                    success: function(result) {
                        if (result.OK) {
                            $("#gwspTable tbody").html(result.Message.Table);
@@ -89,7 +89,8 @@
                    method: "POST",
                    data: { idArray: $.toJSON(idArray), cmopID: cmopID, ctopID: ctopID, unopID: unopID, cmGroupID: cmGroupID, cuGroupID: cuGroupID, ctGroupID: ctGroupID, action: "batchUpdateOp" },
                    success: function(result) {
                        mytek.alert(result.Message, result.OK, function() {
                        mytek.alert(result.Message, result.OK, function () {
                            $("#opDialog").modal("hide");
                            loadPageList();
                        });
                    }
@@ -124,7 +125,7 @@

            //充值
            $(document).on("click", ".action-modal-charge", function () {
                var spID = $(this).data("id");  //账号ID
                var spID = $(this).data("id");  //短信账号
                //window.open("gwOrderCreate.aspx?spId=" + spID, 'gwOrderCreate');
                window.location.href = "gwOrderCreate.aspx?spId=" + spID;
            });
@@ -142,8 +143,15 @@
          //新加  
            $(document).on("click", ".action-updateStatus", function () {
                var spid = $(this).attr("data-spid");
                var status=$(this).attr("data-status");
                mytek.confirm("是否需要修改该账户状态？", "是否操作！", function (b) {
                var status = $(this).attr("data-status");
                var statusMsg = "";
                if (status == 0) {
                    statusMsg = "【停用】";
                }
                else {
                    statusMsg = "【启用】";
                }
                mytek.confirm("是否需要" + statusMsg + "该账号状态？", "是否操作！", function (b) {
                    if (b) {
                        $.post("gwsp.ashx", { action: "updateSpStatus", spid: spid,status:status }, function (r) {
                            mytek.alert(r.Message, r.OK, function () {
@@ -382,7 +390,7 @@
        <div class="ibox">
            <div class="form-group">
                <div class="input-group m-b">
                    <span class="input-group-addon">SP账号</span>
                    <span class="input-group-addon">短信账号</span>
                    <input type="text" name="spID" id="spID" class="form-control col-md-2" />
                </div>
            </div>
@@ -396,14 +404,14 @@
            -->
            <div class="form-group">
                <div class="input-group m-b">
                    <span class="input-group-addon">代理商客户账号</span>
                    <span class="input-group-addon">客户账户</span>
                    <input type="text" name="clientID" id="clientID" class="form-control col-md-2" />
                </div>
            </div>
            <div class="form-group">
                <div class="input-group m-b">
                    <span class="input-group-addon">代理商客户名称</span>
                    <input type="text" name="clientName" id="clientName" class="form-control col-md-2" />
                    <span class="input-group-addon">公司名称</span>
                    <input type="text" name="company" id="company" class="form-control col-md-2" />
                </div>
            </div>
            
@@ -416,7 +424,7 @@

            <div class="form-group">
                <div class="input-group m-b">
                    <span class="input-group-addon">关联产品ID</span>
                    <span class="input-group-addon">关联产品名称</span>
                        <select name="productId" id="productId" class="form-control">
                            <%=GetProductOptions("")%>
                        </select>
@@ -427,7 +435,7 @@
            <div class="form-group">
                <div class="input-group m-b">
                    <select name="routerType" class="form-control" id="routerType">
                        <option value="">路由模式</option>
                        <option value="">--路由模式--</option>
                        <option value="1">通道点路由</option>
                        <option value="3">通道组路由</option>
                    </select>
@@ -436,7 +444,7 @@
            <div class="form-group">
                <div class="input-group m-b">
                    <select name="chargeType" class="form-control" id="chargeType">
                        <option value="">付费方式</option>
                        <option value="">--付费方式--</option>
                        <option value="1">预付费</option>
                        <option value="2">后付费</option>
                    </select>
@@ -445,7 +453,7 @@
            <div class="form-group">
                <div class="input-group m-b">
                    <select name="apID" class="form-control" id="apID">
                        <option value="">接入协议</option>
                        <option value="">--接入协议--</option>
                        <option value="230001">CMPP</option>
                        <option value="230002">HTTP</option>
                    </select>
@@ -453,8 +461,8 @@
            </div>
             <div class="form-group">
                <div class="input-group m-b">
                    <select name="apID" class="form-control" id="RESEND_STATUS">
                        <option value="3">自动补发</option>
                    <select name="RESEND_STATUS" class="form-control" id="RESEND_STATUS">
                        <option value="3">--补发设置--</option>
                        <option value="1">启用补发</option>
                        <option value="0">停用补发</option>
                    </select>
@@ -463,9 +471,9 @@
            <div class="form-group">
                <div class="input-group m-b">
                    <input type="button" value="查询" class="btn btn-primary action-query" />&nbsp;&nbsp;
                    <input class="btn btn-warning  action-create" value="创建新账号" type="button" />&nbsp;&nbsp;
                    <input type="button" value="批量修改通道" class="btn btn-danger action-modal-op" />&nbsp;&nbsp;
                    <input type="button" class="btn btn-info action-export" value="导出数据" />&nbsp;&nbsp;
                    <input class="btn btn-warning  action-create" value="创建新账号" type="button" />
                </div>
            </div>
        </div>
@@ -479,21 +487,40 @@
                        <input type='checkbox' name='checkAll' id='checkAll' />
                    </th>
                    <th>
                        SP账号/接入协议/归属客户
                        短信账号
                    </th>
                    <th>
                        关联产品
                    </th>
                    <th>
                        客户账户
                    </th>
                    <th>
                        公司名称
                    </th>
                    <th>
                        接入协议
                    </th>
                    <th>
                        通道
                    </th>
                    <!--
                    <th>
                        失败补发
                    </th>
                    -->
                    <th>
                        付费方式
                    </th>
                    <th>
                        单价(元/条)
                    </th>
                    <th>
                        余额（总条数/基本条数/赠送条数）
                    </th>
                        <!-- add: yangzh by 2022-03-14 start
                        条数/余额/付费方式/单价/告警
                         -->
                    <th>
                        //条数/余额/付费方式/单价/告警
                        剩余总条数/基本条数/赠送条数/付费方式/单价/告警
                    </th>
                    <th>
@@ -502,13 +529,17 @@
                    <th>
                        扩展号
                    </th>
                    <th>
                         -->
                    <%--<th>
                        客户IP
                    </th>
                    </th>--%>
                    <th>
                        状态
                    </th>
                    <th colspan="4">
                    <th>
                        激活时间
                    </th>
                    <th class="text-center" width="150px">
                        操作
                    </th>
                </tr>
@@ -526,7 +557,7 @@
                <div class="modal-header">
                    <h3>
                        批量修改通道</h3>
                    </span><a class="close" data-dismiss="modal" aria-hidden="true">×</a> <span class="text-muted">
                    <a class="close" data-dismiss="modal" aria-hidden="true">×</a> <span class="text-muted">
                        批量更改通道[组]将会更新所有选中的账号的通道[组]，<br />
                        如果移动、联通或电信 没有设置通道[组]，所选账号通道[组]都将被清空，请谨慎操作！ </span>
                </div>
@@ -698,5 +729,5 @@
        <div id="mask" class="mask">
            <span></span>
            <img src="img/spinning-circles.svg" alt="载入中..." /></div>
    </div>
    
   </asp:Content>