客户信息导出

yzh

2022-06-08 9c98f5d15e35587b7bcd9d7c8a506c467e758632

 web/web/GwOrderList.aspx

@@ -19,7 +19,7 @@
            function loadPageList() {

                var clientId = $("#ClientID").val();
                var clientName = $("#ClientName").val();
                var company = $("#Company").val();
                var spId = $("#SpID").val();
                var startDate = $("#sDate").val();
                var endDate = $("#eDate").val();
@@ -28,7 +28,7 @@
                    url: "GwOrder.ashx",
                    type: "POST",
                    //data: { action: "gwOrderList", SpID: SpID, ClientID: ClientID, ClientName: ClientName, sDate: sDate, EndTime: EndTime, pageSize: $("#pager").Pager("getPageSize"), pageIndex: $("#pager").Pager("getPageIndex") },
                    data: { action: "gwOrderList", clientId: clientId, clientName: clientName, spId: spId, startDate: startDate, endDate: endDate, flag: -1, pageIndex: pagination.getPageIndex(), pageSize: pagination.getPageSize() },
                    data: { action: "gwOrderList", clientId: clientId, company: company, spId: spId, startDate: startDate, endDate: endDate, flag: -1, pageIndex: pagination.getPageIndex(), pageSize: pagination.getPageSize() },
                success: function (result) {
                        if (result.OK) {
                            $("#orderListTable tbody").html(result.Message.Table);
@@ -51,23 +51,24 @@

                    //$("#orderDialog .modal-title").text("订单明细");
                    //$("#orderDialog #action").val("detail");
                    $("#orderDialog #orderId").val(r.Message.OrderId).attr("readonly", false);
                    $("#orderDialog #spId").val(r.Message.SpId);
                    $("#orderDialog #clientId").val(r.Message.ClientId);
                    $("#orderDialog #productId").val(r.Message.ProductId);
                    $("#orderDialog #orderId").val(r.Message.OrderId).attr("readonly", "readonly");
                    $("#orderDialog #spId").val(r.Message.SpId).attr("readonly", "readonly");
                    $("#orderDialog #clientId").val(r.Message.ClientId).attr("disabled", "disabled");
                    $("#orderDialog #productId").val(r.Message.ProductId).attr("disabled", "disabled");
                    //$("#orderDialog #comboId").val(r.Message.ComboId);
                    $("#orderDialog #basicNum").val(r.Message.BasicNum, 0);
                    $("#orderDialog #givingNum").val(r.Message.GivingNum, 0);
                    $("#orderDialog #price").val(r.Message.Price / 1000, 0.00);
                    $("#orderDialog #orderNumTotal").val(r.Message.OrderNumTotal, 0);
                    $("#orderDialog #orderAmountTotal").val(r.Message.OrderAmountTotal / 1000, 0);
                    $("#orderDialog #beforeBalanceNum").val(r.Message.BeforeBalanceNum, 0);
                    $("#orderDialog #creator").val(r.Message.Creator);
                    $("#orderDialog #createTime").val(r.Message.CreateTime);
                    $("#orderDialog #basicNum").val(r.Message.BasicNum, 0).attr("readonly", "readonly");
                    $("#orderDialog #givingNum").val(r.Message.GivingNum, 0).attr("readonly", "readonly");
                    $("#orderDialog #price").val(r.Message.Price / 1000, 0.00).attr("readonly", "readonly");
                    $("#orderDialog #orderNumTotal").val(r.Message.OrderNumTotal, 0).attr("readonly", "readonly");
                    $("#orderDialog #orderAmountTotal").val(r.Message.OrderAmountTotal / 1000, 0).attr("readonly", "readonly");
                    $("#orderDialog #payAmount").val(r.Message.PayAmount / 1000, 0).attr("readonly", "readonly");
                    $("#orderDialog #beforeBalanceNum").val(r.Message.BeforeBalanceNum, 0).attr("readonly", "readonly");
                    $("#orderDialog #creator").val(r.Message.Creator).attr("readonly", "readonly");
                    $("#orderDialog #createTime").val(r.Message.CreateTime).attr("readonly", "readonly");
                    //$("#orderDialog #auditor").valval(r.Message.Auditor);
                    //$("#orderDialog #auditTime").val(r.Message.AuditTime);
                    $("#orderDialog #status").val(r.Message.Status);
                    $("#orderDialog #remark").val(r.Message.Remark);
                    $("#orderDialog #status").val(r.Message.Status).attr("disabled", "disabled");
                    $("#orderDialog #remark").val(r.Message.Remark).attr("disabled", "disabled");

                    $("#orderDialog").modal("show");
                }, "json");
@@ -99,16 +100,16 @@
    class="form-inline">
    <div class="ibox">
        <div class="input-group m-b">
            <span class="input-group-addon">SPID</span>
            <input type="text" name="SpID" id="SpID" value="<%=SpID %>"" class="form-control" />
            <span class="input-group-addon">客户账号</span>
            <input type="text" name="ClientID" id="ClientID" value="<%=ClientId %>" class="form-control" />
        </div>
        <div class="input-group m-b">
            <span class="input-group-addon">客户ID</span>
            <input type="text" name="ClientID" id="ClientID" class="form-control" />
            <span class="input-group-addon">公司名称</span>
            <input type="text" name="Company" id="Company" class="form-control " />
        </div>
        <div class="input-group m-b">
            <span class="input-group-addon">客户名称</span>
            <input type="text" name="ClientName" id="ClientName" class="form-control " />
            <span class="input-group-addon">短信账号</span>
            <input type="text" name="SpID" id="SpID" value="<%=SpID %>" class="form-control" />
        </div>
        <div class="input-group m-b">
            <div class="input-daterange input-group " id="datepicker">
@@ -129,26 +130,30 @@
                <tr class="header">
                    <th>订单ID
                    </th>
                    <th>账号ID
                    <th>短信账号
                    </th>
                    <th>客户ID
                    <th>客户账号
                    </th>
                    <th>产品ID
                    <th>产品名称
                    </th>
                    <%--<th>套餐ID
                    </th>
                         --%>
                    <th>订单基本条数
                    <th>订单基本条数(条)
                    </th>
                    <th>订单赠送条数
                    <th>订单赠送条数(条)
                    </th>
                    <th>单价（元/条）
                    </th>
                    <th>订单总条数
                    <th>订单总条数(条)
                    </th>
                    <th>订单总金额（元）
                    </th>
                    <th>充值金额（元）
                    </th>
                    <th>充值前账号余额（条）
                    </th>
                    <th>审核人(多级按“,”分隔)
                    </th>
                    <th>创建人
                    </th>
@@ -156,7 +161,7 @@
                    </th>
                    <th>状态
                    </th>
                    <th class="text-right">操作
                    <th class="text-center">操作
                    </th>
                </tr>
            </thead>
@@ -195,14 +200,14 @@
                        </div>
                        <div class="form-group">
                            <label class="col-sm-2 control-label">
                                账号ID</label>
                                短信账号</label>
                            <div class="col-sm-4 ">
                                <input type="text" class="form-control" name="spId" id="spId" value="" />
                            </div>
                        </div>
                        <div class="form-group">
                            <label class="col-sm-2 control-label">
                                客户ID</label>
                                客户账号</label>
                            <div class="col-sm-4 ">
                                <select name="clientId" id="clientId" class="form-control">
                                    <%=GetClientOptions("0")%>
@@ -211,7 +216,7 @@
                        </div>
                        <div class="form-group">
                            <label class="col-sm-2 control-label">
                                产品ID</label>
                                产品名称</label>
                            <div class="col-sm-4 ">
                                <select name="productId" id="productId" class="form-control">
                                    <%=GetProductOptions("0")%>
@@ -284,6 +289,17 @@
                        </div>
                        <div class="form-group">
                            <label class="col-sm-2 control-label">
                                充值金额</label>
                            <div class="col-sm-4">
                                <div class="input-group">
                                <input type="text" class="form-control" name="payAmount" id="payAmount" value="" maxlength="10"
                                    onkeyup="value=value.replace(/[^\d\.]/g,'')" onpaste="value=value.replace(/[^\d\.]/g,'')"
                                    oncontextmenu="return false" /><span class="input-group-addon">元 </span>
                                </div>
                            </div>
                        </div>
                        <div class="form-group">
                            <label class="col-sm-2 control-label">
                                充值前账号余额</label>
                            <div class="col-sm-4">
                                <div class="input-group">