From 374ce4ffd0c459bb4067e8d5765f972668aff9b1 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期四, 02 三月 2023 14:56:23 +0800
Subject: [PATCH] 变更oracle访问组件

---
 web/web/GwOrderComplete.aspx |  107 ++++++++++++++++++++++++++++++++++++++++-------------
 1 files changed, 81 insertions(+), 26 deletions(-)

diff --git a/web/web/GwOrderComplete.aspx b/web/web/GwOrderComplete.aspx
index 4db6f61..4696107 100644
--- a/web/web/GwOrderComplete.aspx
+++ b/web/web/GwOrderComplete.aspx
@@ -9,14 +9,14 @@
 
         function loadPageList() {
             var clientId = $("#ClientId").val();
-            var clientName = $("#ClientName").val();
+            var compay = $("#Compay").val();
             var spId = $("#SpId").val();
             var startDate = $("#StartTime").val();
             var endDate = $("#EndTime").val();
             $.ajax({
                 url: "GwOrder.ashx",
                 type: "POST",
-                data: { action: "listComplete", clientId: clientId, clientName: clientName, spId: spId, startDate: startDate, endDate: endDate, flag: 1, pageIndex: pagination.getPageIndex(), pageSize: pagination.getPageSize() },
+                data: { action: "listComplete", clientId: clientId, compay: compay, spId: spId, startDate: startDate, endDate: endDate, flag: 1, pageIndex: pagination.getPageIndex(), pageSize: pagination.getPageSize() },
                 success: function(result) {
                     if (result.OK) {
                         $("#orderTable tbody").html(result.Message.Table);
@@ -32,19 +32,49 @@
 
         $(".input-daterange").datepicker({ keyboardNavigation: !1, forceParse: !1, autoclose: !0 });
 
+        //鐘舵�佽浆鎹㈠悕绉�
+        function statusToName(status) {
+            if (status == "") {
+                return "";
+            }
+            else if (status == 0) {
+                return "寰呭鏍�";
+            }
+            else if (status == 1) {
+                return "瀹℃牳涓�";
+            }
+            else if (status == 2) {
+                return "瀹℃牳閫氳繃";
+            }
+            else if (status == 3) {
+                return "瀹℃牳涓嶉�氳繃";
+            }
+            else if (status == 4) {
+                return "鍙栨秷";
+            }
+            else {
+                return status;
+            }
+        }
+
         $(document).on("click", ".action-modal-detail", function () {
+
             var orderId = $(this).data("orderid");
             $("#orderDialog .modal-title").text("璁㈠崟鏄庣粏");
 
             $.get("gwOrder.ashx", { "action": "get", orderId: orderId }, function (r) {
 
-                //$("#orderDialog .modal-title").text("璁㈠崟鏄庣粏");
-                //$("#orderDialog #action").val("detail");
+                ////$("#orderDialog .modal-title").text("璁㈠崟鏄庣粏");
+                ////$("#orderDialog #action").val("detail");
                 $("#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 #clientId").val(r.Message.ClientId).attr("disabled", "disabled");
+                $("#orderDialog #clientId").val(r.Message.ClientId);
+                $("#orderDialog #clientCompany").val(r.Message.Company).attr("disabled", "disabled");  //杞崲鍚嶇О
+                //$("#orderDialog #productId").val(r.Message.ProductId).attr("disabled", "disabled");
+                $("#orderDialog #productId").val(r.Message.ProductId);
+                $("#orderDialog #productName").val(r.Message.ProductName).attr("disabled", "disabled");  //杞崲鍚嶇О
+                ////$("#orderDialog #comboId").val(r.Message.ComboId);
                 $("#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");
@@ -54,7 +84,9 @@
                 $("#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 #status").val(r.Message.Status).attr("disabled", "disabled");
+                //$("#orderDialog #status").val(r.Message.Status).attr("disabled", "disabled");
+                $("#orderDialog #status").val(r.Message.Status);
+                $("#orderDialog #statusName").val(statusToName(r.Message.Status)).attr("disabled", "disabled");  //杞崲鍚嶇О
                 $("#orderDialog #remark").val(r.Message.Remark).attr("disabled", "disabled");
 
                 $("#orderDialog").modal("show");
@@ -93,19 +125,19 @@
         <div class="m-b">
             <div class="form-group">
                 <div class="input-group m-b">
-                    <span class="input-group-addon">浠g悊鍟嗗鎴疯处鎴�</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">浠g悊鍟嗗鎴峰悕绉�</span>
-                    <input type="text" name="ClientName" id="ClientName" class="form-control col-md-2" />
+                    <span class="input-group-addon">鍏徃鍚嶇О</span>
+                    <input type="text" name="Compay" id="Compay" class="form-control col-md-2" />
                 </div>
             </div>
             <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>
@@ -122,7 +154,7 @@
                 </div>
             </div>
             <div class="form-group">
-                <div class="input-group">
+                <div class="input-group  m-b">
                     <input type="button" value="鏌ヨ" class="btn btn-primary action-btn-GwOrderQuery" />
                 </div>
             </div>
@@ -130,24 +162,28 @@
         <table class="table table-striped table-bordered table-hover" id="orderTable">
             <thead>
                 <tr class="header">
+                    
                     <th>璁㈠崟ID
                     </th>
-                    <th>璐﹀彿ID
+                    
+                    <th>鐭俊璐﹀彿
                     </th>
-                    <th>瀹㈡埛ID
+                    <th>瀹㈡埛璐︽埛
                     </th>
-                    <th>浜у搧ID
+                    <th>鍏徃鍚嶇О
+                    </th>
+                    <th>浜у搧鍚嶇О
                     </th>
                     <%--<th>濂楅ID
                     </th>
                          --%>
-                    <th>璁㈠崟鍩烘湰鏉℃暟
+                    <th>璁㈠崟鍩烘湰鏉℃暟锛堟潯锛�
                     </th>
-                    <th>璁㈠崟璧犻�佹潯鏁�
+                    <th>璁㈠崟璧犻�佹潯鏁帮紙鏉★級
                     </th>
                     <th>鍗曚环锛堝厓/鏉★級
                     </th>
-                    <th>璁㈠崟鎬绘潯鏁�
+                    <th>璁㈠崟鎬绘潯鏁帮紙鏉★級
                     </th>
                     <th>璁㈠崟鎬婚噾棰濓紙鍏冿級
                     </th>
@@ -155,13 +191,15 @@
                     </th>
                     <th>鍏呭�煎墠璐﹀彿浣欓锛堟潯锛�
                     </th>
+                    <th>瀹℃牳浜�(澶氱骇鎸夆��,鈥濆垎闅�)
+                    </th>
                     <th>鍒涘缓浜�
                     </th>
                     <th>鍒涘缓鏃堕棿
                     </th>
                     <th>鐘舵��
                     </th>
-                    <th class="text-right">鎿嶄綔
+                    <th class="text-center">鎿嶄綔
                     </th>
                 </tr>
             </thead>
@@ -172,7 +210,6 @@
     <div id="pagination">
     </div>
     <div class="footBar">
-      
     </div>
 
     <div class="modal inmodal fade" id="orderDialog" tabindex="-1" role="dialog" aria-hidden="true">
@@ -195,27 +232,41 @@
                         </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")%>
+                                    <!%=GetClientOptions("0")%>
                                 </select>
+                                -->
+                                <input type="text" class="form-control" name="clientId" id="clientId" value="" readonly="readonly" />
                             </div>
                         </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="clientCompany" id="clientCompany" value="" readonly="readonly" />
+                            </div>
+                        </div>
+                        <div class="form-group">
+                            <label class="col-sm-2 control-label">
+                                浜у搧鍚嶇О</label>
+                            <div class="col-sm-4 ">
+                                <!--
                                 <select name="productId" id="productId" class="form-control">
-                                    <%=GetProductOptions("0")%>
+                                    <!%=GetProductOptions("0")%>
                                 </select>
+                                -->
+                                <input type="text" class="form-control" name="productName" id="productName" value="" readonly="readonly" />
+                                <input type="hidden" class="form-control" name="productId" id="productId" value="" />
                             </div>
                         </div>
                         <%--
@@ -322,6 +373,7 @@
                             <label class="col-sm-2 control-label">
                                 鐘舵��</label>
                             <div class="col-sm-4 ">
+                                <!--
                                 <select name="status" id="status" class="form-control">
                                     <option value=""></option>
                                     <option value="0">寰呭鏍�</option>
@@ -330,6 +382,9 @@
                                     <option value="3">瀹℃牳涓嶉�氳繃</option>
                                     <option value="4">鍙栨秷</option>
                                 </select>
+                                -->
+                                <input type="text" class="form-control" name="statusName" id="statusName" value="" />
+                                <input type="hidden" class="form-control" name="status" id="status" value="" />
                             </div>
                         </div>
                         <div class="form-group">

--
Gitblit v1.9.1