Index.cshtml 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  1. @{
  2. ViewBag.Title = "订单管理";
  3. Layout = "~/Views/Shared/_LayoutIndex.cshtml";
  4. }
  5. <script>
  6. $(function () {
  7. GetGrid();
  8. })
  9. function GetGrid() {
  10. var $gridTable = $('#gridTable');
  11. $gridTable.jqGrid({
  12. url: "../../WeChatManage/Refund/GetPayMentInfoJson",
  13. datatype: "json",
  14. height: $(window).height() - 50.5,
  15. autowidth: true,
  16. colModel: [
  17. { name: "CustomerCode", label: "客户编号", width: 80, align: "center" },
  18. { name: "Username", label: "客户名称", width: 150, align: "center" },
  19. { name: "PlanMoney", label: "应缴金额", width: 100, align: "center" },
  20. { name: "GetMoney", label: "实缴金额", width: 100, align: "center" },
  21. { name: "CreateDT", label: "缴费时间", width: 130, align: "center" },
  22. { name: "InvoiceCode", label: "发表编号", width: 130, align: "center" },
  23. { name: "Transaction_id", label: "商户订单号", width: 130, align: "center" },//, hidden: true
  24. { name: "Out_trade_no", label: "微信支付订单号", width: 130, align: "center" },
  25. { name: "ISPaySuccess", label: "处理状态", width: 130, align: "center" },
  26. {
  27. name: "IsAllow", label: "操作", width: 100, align: "center",
  28. //formatter: function (cellvalue, options, rowObject) {
  29. // var temp = '';
  30. // if (cellvalue == 0) {
  31. // temp = '退款';
  32. // } else {
  33. // temp = '允许';
  34. // }
  35. // return temp;
  36. //}
  37. }
  38. ],
  39. viewrecords: true,
  40. rowNum: 1000,
  41. footerrow: true,
  42. gridComplete: function () {
  43. var ids = $gridTable.jqGrid('getDataIDs');
  44. for (var i = 0; i < ids.length; i++) {
  45. var cl = ids[i];
  46. var str = $gridTable.jqGrid('getCell', cl, 'ISPaySuccess');
  47. console.log(str);
  48. be = "";
  49. se = "<input style='height:22px;width:80px;line-height:14px' type='button' value='退款' onclick=\"RefundFee("
  50. + cl + ");\" />";
  51. var ss = se;
  52. if (str == '退款成功') {
  53. ss = '';
  54. }
  55. $gridTable.jqGrid('setRowData', ids[i],
  56. {
  57. IsAllow: ss
  58. });
  59. }
  60. //var totalamount = $(this).getCol("amount", false, "sum");
  61. ////合计
  62. //$(this).footerData("set", {
  63. // "location": "合计:",
  64. // "amount": totalamount,
  65. //});
  66. $('table.ui-jqgrid-ftable td').prevUntil().css("border-right-color", "#fff");
  67. }
  68. }).trigger('reloadGrid');
  69. //查询条件
  70. $("#queryCondition .dropdown-menu li").click(function () {
  71. var text = $(this).find('a').html();
  72. var value = $(this).find('a').attr('data-value');
  73. $("#queryCondition .dropdown-text").html(text).attr('data-value', value)
  74. });
  75. //查询事件
  76. $("#btn_Search").click(function () {
  77. var queryJson = {
  78. condition: $("#queryCondition").find('.dropdown-text').attr('data-value'),
  79. keyword: $("#txt_Keyword").val()
  80. }
  81. $gridTable.jqGrid('setGridParam', {
  82. postData: { queryJson: JSON.stringify(queryJson) },
  83. page: 1
  84. }).trigger('reloadGrid');
  85. });
  86. //查询回车
  87. $('#txt_Keyword').bind('keypress', function (event) {
  88. if (event.keyCode == "13") {
  89. $('#btn_Search').trigger("click");
  90. }
  91. });
  92. }
  93. //打印
  94. function btn_print() {
  95. $("#gridPanel").printTable();
  96. }
  97. //导出
  98. function btn_export() {
  99. dialogOpen({
  100. id: "ExcelIExportDialog",
  101. title: '导出销售报表',
  102. url: '/Utility/ExcelExportForm?gridId=gridTable',
  103. width: "500px",
  104. height: "380px",
  105. callBack: function (iframeId) {
  106. top.frames[iframeId].AcceptClick();
  107. }, btn: ['导出Excel', '关闭']
  108. });
  109. }
  110. function RefundFee(id) {
  111. //alert(id);
  112. $.ajax({
  113. url: '../../WeChatManage/Refund/RefundFee',//../../WeChatManage/Refund/GetPayMentInfoJson
  114. data: {
  115. Id: id
  116. },
  117. datatype: 'json',
  118. success: function (data) {
  119. console.log(data.code);
  120. var json = JSON.parse(data);
  121. if (json.code == 1) {
  122. alert("退款成功!");
  123. GetGrid();
  124. }
  125. else {
  126. alert("退款失败!")
  127. }
  128. },
  129. complete: function (data) {
  130. GetGrid();
  131. },
  132. error: function (data) { }
  133. });
  134. }
  135. </script>
  136. <div class="ui-report">
  137. <div class="gridPanel" id="gridPanel">
  138. <div class="printArea">
  139. <div class="grid-title">订单管理</div>
  140. <div class="grid-subtitle"></div>
  141. <table id="gridTable"></table>
  142. </div>
  143. </div>
  144. </div>