MajorQuoteTrendHighCharts.cshtml 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527
  1. 
  2. @{
  3. Layout = null;
  4. }
  5. <!DOCTYPE html>
  6. <html>
  7. <head>
  8. <meta name="viewport" content="width=device-width" />
  9. <title>MajorQuoteTrendHighCharts</title>
  10. <link href="~/easyui/themes/default/easyui.css" rel="stylesheet" />
  11. <link rel="stylesheet" type="text/css" href="~/easyui/themes/icon.css" />
  12. <link href="~/Content/css/bootstrap.min.css" rel="stylesheet" />
  13. <link href="~/Content/js/plugins/layer/skin/layer.css" rel="stylesheet" />
  14. <script src="~/Content/js/jquery.min.js"></script>
  15. <script src="~/Content/js/bootstrap.min.js"></script>
  16. <script src="~/easyui/jquery.easyui.min.js"></script>
  17. <script src="~/easyui/jquery.easyui.mobile.js"></script>
  18. <script src="~/easyui/locale/easyui-lang-zh_CN.js"></script>
  19. <script src="~/Content/js/plugins/layer/laydate/laydate.js"></script>
  20. <script src="~/Content/js/plugins/layer/layer.min.js"></script>
  21. <script src="~/js/Utils.js"></script>
  22. <link href="~/Content/css/Style/Markets.css" rel="stylesheet" />
  23. <link href="~/Content/css/Styles.css" rel="stylesheet" />
  24. <script src="~/Content/js/js/MarketJs.js"></script>
  25. <script src="~/Content/plugins/highcharts/highcharts5.0.14.js"></script>
  26. <script type="text/javascript" src="~/Content/plugins/highcharts/modules/exporting.js"></script>
  27. </head>
  28. <body>
  29. <section class="hidden">
  30. <input id="hid_RegionID" name="hid_RegionID" type="hidden" value="@ViewBag.RegionID" />
  31. <input type="hidden" id="hid_ReportTitle" value="@ViewBag.ReportTitle" />
  32. <input id="hid_IsMarketSysAccount" name="hid_IsMarketSysAccount" type="hidden" value="@ViewBag.IsMarketSysAccount" />
  33. <input id="hid_IsSystem" name="hid_IsSystem" type="hidden" value="@ViewBag.IsSystem" />
  34. <input id="hid_MarketID" name="hid_MarketID" type="hidden" value="@ViewBag.MarketID" />
  35. <input id="hid_ChartType" name="hid_ChartType" type="hidden" value="LINE" />
  36. <input id="hid_NumberFormat" name="hid_NumberFormat" type="hidden" value="0" />
  37. <input id="hid_IsExportImage" name="hid_IsExportImage" type="hidden" value="N" />
  38. </section>
  39. <section id="Search_Panel">
  40. <table class="tableStyle1" style="Z-INDEX:101;LEFT:5px;WIDTH:1000px;TOP:20px;POSITION:absolute;">
  41. <tr>
  42. <td class="td1"><img alt="" src="../Images/icon_1.gif" />辖区工商:</td>
  43. <td class="td2">
  44. @*<input class="easyui-combotree" id="SearchRegionID" data-options="url:'/BaseInfo/GetTreeRegion',method:'post',loadFilter: function (rows) {
  45. return convert(rows);
  46. },onChange:function(newValue, oldValue){GetMarketSelStr()}" style="width:200px;height:20px" />*@
  47. <select class="easyui-combobox" id="SearchRegionID" style="width:200px;height:20px" data-options="onChange:function(newValue, oldValue){GetMarketSelStr()}">
  48. @Html.Raw(ViewBag.SelRegionID)
  49. </select>
  50. </td>
  51. <td class="td1"><img alt="" src="../Images/icon_1.gif" />隶属市场:</td>
  52. <td class="td2">
  53. <select class="easyui-combobox" style="height: 25px; width: 200px" id="SearchMarketID" name="SearchMarketID" data-options="">
  54. <option value="">全部</option>
  55. @Html.Raw(ViewBag.SelMarketInfo)
  56. </select>
  57. </td>
  58. <td class="td1"><img alt="" src="../Images/icon_1.gif" />商品名称:</td>
  59. <td class="td2">
  60. <select class="easyui-combobox" id="MajorGoods" style="height: 25px; width: 200px">
  61. @Html.Raw(ViewBag.SelMajorGoods)
  62. </select>
  63. </td>
  64. </tr>
  65. <tr>
  66. <td class="td1"><img alt="" src="../Images/icon_1.gif" />日期:</td>
  67. <td class="td2">
  68. <input class="laydate-icon layer-date" type="text" id="SearchStartTime" name="SearchStartTime" style="height: 25px; width: 200px" data-options="" placeholder="开始日期" />
  69. </td>
  70. <td class="td1">到:</td>
  71. <td class="td2">
  72. <input class="laydate-icon layer-date" type="text" id="SearchEndTime" name="SearchEndTime" style="height: 25px; width: 200px" data-options="" placeholder="截止日期" />
  73. </td>
  74. <td class="td1"><img alt="" src="../Images/icon_1.gif" />周期:</td>
  75. <td class="td2">
  76. <select style="height: 25px; width: 200px" id="cmbQueryCycle" name="cmbQueryCycle" onchange="f_CycleSelChanged()">
  77. <option value="1" selected>日</option>
  78. <option value="2">月</option>
  79. <option value="3">季</option>
  80. <option value="4">年</option>
  81. </select>
  82. </td>
  83. </tr>
  84. <tr>
  85. <td class="td1">
  86. <input type="radio" name="ChartType" value="LINE" style="margin: 5px 3px 0 0" checked="checked" /> 趋势图
  87. </td>
  88. <td class="td1" colspan="5">
  89. <div align="center">
  90. <a href="#" class="easyui-linkbutton" iconCls="icon-search" style="width: 90%; height: 25px" onclick="LoadChart();">查询</a>&nbsp;&nbsp;
  91. <input id="BtnPrintChart" type="button" onclick="PrintBtnClk()" style="width:60px" class="but1" value="打印图片" />&nbsp;&nbsp;
  92. <input id="BtnExportChart" type="button" onclick="ExportChartBtnClk()" style="width:60px" class="but1" value="导出图片" />
  93. </div>
  94. </td>
  95. </tr>
  96. </table>
  97. <div id="container" style="Z-INDEX: 103; LEFT: 5px; WIDTH: 1000px; POSITION: absolute; TOP: 120px; HEIGHT: 400px"></div>
  98. </section>
  99. <script>
  100. //根据辖区获取市场下拉框的option
  101. function GetMarketSelStr() {
  102. $.ajax({
  103. url: "/GetResult/GetMarketSelStrResult",
  104. type: "post",
  105. async:false,
  106. dataType: "json",
  107. //data: { RegionID: $("input.combobox-value[name='SearchRegionID']").val() },
  108. data: { RegionID: $("#SearchRegionID").combobox("getValue") },
  109. success: function (data) {
  110. //console.log(msg);
  111. if (CheckAajxData(data) === false) return;
  112. var rows = data.rows;
  113. var first = "{\"MarketID\":\"\",\"Names\":\"全部\"}";
  114. //var last = "{\"MarketID\":\"Other\",\"Names\":\"其他\"}";
  115. var firstJson = JSON.parse(first);
  116. //var lastJson = JSON.parse(last);
  117. rows.unshift(firstJson);
  118. //rows.push(lastJson);
  119. //console.log(rows);
  120. $('#SearchMarketID').combobox("clear").combobox({
  121. data: rows,
  122. valueField: 'MarketID',
  123. textField: 'Names',
  124. onLoadSuccess: function () {
  125. var val = $(this).combobox('getData');
  126. // ReSharper disable once MissingHasOwnPropertyInForeach
  127. for (var item in val[0]) {
  128. if (item === 'MarketID') {
  129. $(this).combobox('select', val[0][item]);
  130. }
  131. }
  132. }
  133. });
  134. }
  135. });
  136. }
  137. var chart;
  138. function LoadChart() {
  139. var chartType = $("#hid_ChartType").val();
  140. if (chartType == 'LINE') {
  141. chart = new Highcharts.Chart({
  142. chart: {
  143. renderTo: 'container',
  144. defaultSeriesType: 'spline',
  145. events: {
  146. load: ChartQry
  147. }
  148. },
  149. title: {
  150. text: $("#hid_ReportTitle").val()
  151. },
  152. xAxis: {
  153. categories: [],
  154. tickWidth: 3,
  155. tickmarkPlacement: 'on',
  156. labels: {
  157. rotation: 0,
  158. align: 'center',
  159. formatter: function() {
  160. // x轴的日期进行格式化
  161. var days = this.value.split('/');
  162. if (days.length == 3)
  163. return days[1] + '/' + days[2];
  164. else
  165. return this.value;
  166. }
  167. }
  168. },
  169. yAxis: {
  170. title: {
  171. text: ''
  172. }
  173. },
  174. tooltip: {
  175. enabled: true,
  176. formatter: function() {
  177. return '<b>' + this.series.name + '</b><br/>' +
  178. this.x + ': ' + Highcharts.numberFormat(this.y, 2) + '元';
  179. }
  180. },
  181. exporting: {
  182. buttons: {
  183. printButton: {
  184. enabled: false
  185. },
  186. exportButton: {
  187. enabled: false,
  188. menuItems: [{
  189. text: 'PNG格式',
  190. onclick: function() {
  191. this.exportChart({
  192. type: 'image/png',
  193. width: 1200
  194. });
  195. }
  196. }, {
  197. text: 'JPG格式',
  198. onclick: function() {
  199. this.exportChart({
  200. type: 'image/jpeg',
  201. width: 1200
  202. });
  203. }
  204. },
  205. null,
  206. null]
  207. }
  208. },
  209. //url: '../HighchartsExport.aspx',
  210. url: 'http://export.highcharts.com.cn',
  211. filename: 'MyChart',
  212. width: 1200
  213. },
  214. plotOptions: {
  215. spline: {
  216. dataLabels: {
  217. enabled: true, // 是否在线上各点标注y轴数值
  218. formatter: function() {
  219. return Highcharts.numberFormat(this.y, 2);
  220. }
  221. },
  222. enableMouseTracking: true
  223. }
  224. },
  225. credits: {
  226. enabled: false
  227. },
  228. series: [{
  229. name: '最高价',
  230. color: '#C85B6F',
  231. data: []
  232. }, {
  233. name: '最低价',
  234. color: '#15AE67',
  235. data: []
  236. }, {
  237. name: '平均价',
  238. //color: '#59C3E2',
  239. color: 'gray',
  240. dashStyle: 'longdash',
  241. data: []
  242. }]
  243. });
  244. }
  245. }
  246. //返回两个时间的天数:要求比较的时间的格式为:YYYY-MM-DD
  247. function better_time(strDateStart, strDateEnd) {
  248. strDateStart = strDateStart.replace("/", "-").replace("/", "-");
  249. strDateEnd = strDateEnd.replace("/", "-").replace("/", "-");
  250. var strSeparator = "-"; //日期分隔符
  251. var strDateArrayStart;
  252. var strDateArrayEnd;
  253. var intDay;
  254. if (strDateStart == "" || strDateEnd == "") {
  255. //alert("ddddddd");
  256. }
  257. strDateArrayStart = strDateStart.split(strSeparator);
  258. strDateArrayEnd = strDateEnd.split(strSeparator);
  259. var strDateS = new Date(strDateArrayStart[0] + "/" + strDateArrayStart[1] + "/" + strDateArrayStart[2]);
  260. var strDateE = new Date(strDateArrayEnd[0] + "/" + strDateArrayEnd[1] + "/" + strDateArrayEnd[2]);
  261. intDay = (strDateS - strDateE) / (1000 * 3600 * 24);
  262. return intDay;
  263. }
  264. var _IsExportImage = 'N';
  265. function ChartQry() {
  266. var sDate, eDate;
  267. sDate = document.getElementById("SearchStartTime").value;
  268. eDate = document.getElementById("SearchEndTime").value;
  269. var days = better_time(eDate, sDate);
  270. if (days <= 0) {
  271. alert("时间间隔无效,请确保结束时间 大于 开始时间!");
  272. return false;
  273. }
  274. var cycle = document.getElementById("cmbQueryCycle").value;
  275. if (cycle == '1') {
  276. if (days >= 60) {
  277. alert("时间间隔最大为60天!");
  278. return false;
  279. }
  280. }
  281. else if (cycle == '2') {
  282. if (days >= 730) {
  283. alert("时间间隔最大为24个月!");
  284. return false;
  285. }
  286. }
  287. else if (cycle == '3') {
  288. if (days >= 1095) {
  289. alert("时间间隔最大为16个季度!");
  290. return false;
  291. }
  292. }
  293. $("#SearchRegionID").combobox("setValue", $('#hid_RegionID').val())
  294. var regionId = $("#SearchRegionID").combobox("getValue"),
  295. marketId = $("#SearchMarketID").combobox("getValue"),
  296. MajorGoods = $("#MajorGoods").combobox("getValue")
  297. startTime = $('#SearchStartTime').val(),
  298. endTime = $('#SearchEndTime').val(),
  299. chartType = $("#hid_ChartType").val(),
  300. reportType = $("#hid_ReportType").val(),
  301. cmbQueryCycle = $("#cmbQueryCycle").val();
  302. $.ajax({
  303. url: '@Url.Action("ShowChartMajorQuoteTrendHighCharts", "DataCharts")', // 查询接口
  304. type: 'post',
  305. dataType: 'json', // 查询接口返回的数据类型
  306. timeout: 1000000, // 单位=毫秒。为了测试写成1000秒,正式环境下可改为20秒
  307. data: {
  308. RegionID: regionId,
  309. MarketID: marketId,
  310. StartTime: startTime,
  311. EndTime: endTime,
  312. ChartType: chartType,
  313. ReportType: reportType,
  314. cmbQueryCycle:cmbQueryCycle,
  315. MajorGoods: MajorGoods,
  316. IsExportImage:_IsExportImage
  317. },
  318. success: function(srv_resp, textStatus) {
  319. // 查询接口无数据返回
  320. var count = eval(srv_resp.__totalcount);
  321. if (count == "" || count == null || count == "undefined" || count <= 0) {
  322. return;
  323. }
  324. if ($("#hid_ChartType").val() == 'LINE') {
  325. chart.xAxis[0].setCategories(srv_resp.__categories);
  326. if (srv_resp.__series.length == 3) {
  327. // 设置x轴label间隔,否则可能因为数据量而过密
  328. var step = Math.ceil(count / 10.0);
  329. if (step < 1) { step = 1; }
  330. //chart.xAxis[0].options.labels.step = step;
  331. chart.xAxis[0].options.tickInterval = step;
  332. // 设置各series的数据
  333. chart.series[0].setData(srv_resp.__series[0], false);
  334. chart.series[1].setData(srv_resp.__series[1], false);
  335. chart.series[2].setData(srv_resp.__series[2], false);
  336. chart.redraw();
  337. }
  338. }
  339. },
  340. // 捕获出错信息(服务器应答超时、返回数据不是json格式等,用于调试)
  341. error: function(xmlHttpRequest, textStatus) {
  342. layer.alert(textStatus, {icon:2, title: '提示信息' });
  343. },
  344. cache: false
  345. });
  346. };
  347. //function ChartType()
  348. //{
  349. // var val=$('input[name="ChartType"]:checked').val();
  350. // if (val === "LINE") {
  351. // $("#hid_ChartType").val("LINE");
  352. // $("#hid_NumberFormat").val("2");
  353. // }
  354. // LoadChart();
  355. //}
  356. var start = {
  357. elem: "#SearchStartTime",
  358. format: "YYYY-MM-DD",
  359. min: "2010-01-01",
  360. event: "focus",
  361. choose: function (datas) {
  362. end.min = datas; //开始日选好后,重置结束日的最小日期
  363. end.start = datas; //将结束日的初始值设定为开始日
  364. $('#SearchStartTime').val(datas);
  365. }
  366. },
  367. end = {
  368. elem: "#SearchEndTime",
  369. format: "YYYY-MM-DD",
  370. min: "2010-01-01",
  371. event: "focus",
  372. choose: function (datas) {
  373. start.max = datas; //结束日选好后,重置开始日的最大日期
  374. $('#SearchEndTime').val(datas);
  375. }
  376. };
  377. $(function () {
  378. if ($("#hid_IsMarketSysAccount").val() === "0") {
  379. $("#SearchRegionID").combobox("setValue", $('#hid_RegionID').val()).combobox("disable");
  380. $("#SearchMarketID").combobox("setValue", $("#hid_MarketID").val()).combobox("disable");
  381. }
  382. GetMarketSelStr();
  383. //GetLittleKindSelStr();
  384. //GetCheckProjectSelStr();
  385. //加载图表数据
  386. //加载日历控件
  387. laydate(start);
  388. laydate(end);
  389. f_CycleSelChanged();
  390. $("#hid_ChartType").val("LINE");
  391. $("#SearchRegionID").combobox("setValue", $('#hid_RegionID').val());
  392. LoadChart();
  393. });
  394. // 打印图片
  395. function PrintBtnClk() {
  396. //$("#container").printArea();
  397. chart.print();
  398. }
  399. // 导出图片
  400. function ExportChartBtnClk() {
  401. _IsExportImage = 'Y';
  402. chart.exportChart({ type: 'image/png', width: 1200 });
  403. _IsExportImage = 'N';
  404. }
  405. // 格式化Date类型的数据为yyyy-mm-dd
  406. function FormatDate(d)
  407. {
  408. // 获取年份
  409. s = d.getFullYear();
  410. // 获取月份
  411. c = d.getMonth() + 1;
  412. if (c < 10) {
  413. s += "-0" + c;
  414. }
  415. else {
  416. s += "-" + c;
  417. }
  418. // 获取日
  419. e = d.getDate();
  420. if (e < 10) {
  421. s += "-0" + e;
  422. }
  423. else {
  424. s += "-" + e;
  425. }
  426. return s;
  427. }
  428. // '查询周期'选择变化
  429. function f_CycleSelChanged()
  430. {
  431. var obj = $('#cmbQueryCycle').val();
  432. // 结束日期
  433. var dateE = new Date();
  434. document.getElementById("SearchEndTime").value = FormatDate(dateE);
  435. // 开始日期
  436. var dateB = new Date();
  437. if (obj== "1") {
  438. dateB.setDate(dateE.getDate() - 30);
  439. }
  440. else if (obj== "2") {
  441. dateB.setMonth(dateE.getMonth() - 6);
  442. }
  443. else if (obj == "3") {
  444. dateB.setMonth(dateE.getMonth() - 16);
  445. }
  446. else {
  447. dateB.setYear(dateE.getFullYear() - 6);
  448. }
  449. document.getElementById("SearchStartTime").value = FormatDate(dateB);
  450. }
  451. function convert(rows) {
  452. function exists(rows, parentId) {
  453. for (var i = 0; i < rows.length; i++) {
  454. if (rows[i].id == parentId) return true;
  455. }
  456. return false;
  457. }
  458. var nodes = [];
  459. // get the top level nodes
  460. for (var i = 0; i < rows.length; i++) {
  461. var row = rows[i];
  462. if (!exists(rows, row.parentId)) {
  463. nodes.push({
  464. id: row.id,
  465. text: row.name
  466. });
  467. }
  468. }
  469. var toDo = [];
  470. for (var i = 0; i < nodes.length; i++) {
  471. toDo.push(nodes[i]);
  472. }
  473. while (toDo.length) {
  474. var node = toDo.shift(); // the parent node
  475. // get the children nodes
  476. for (var i = 0; i < rows.length; i++) {
  477. var row = rows[i];
  478. if (row.parentId == node.id) {
  479. var child = { id: row.id, text: row.name };
  480. if (node.children) {
  481. node.children.push(child);
  482. } else {
  483. node.children = [child];
  484. }
  485. toDo.push(child);
  486. }
  487. }
  488. }
  489. return nodes;
  490. }
  491. </script>
  492. </body>
  493. </html>