You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
202 lines
7.5 KiB
202 lines
7.5 KiB
1 week ago
|
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="QualifiedTrendExcel.aspx.cs" Inherits="MESWebSite.Manage.QualifiedTrendExcel" %>
|
||
|
|
|
||
|
|
<!DOCTYPE html>
|
||
|
|
|
||
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
||
|
|
<head runat="server">
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<link href="/CSS/Basics.css" rel="stylesheet" />
|
||
|
|
<link href="/Scripts/jquery-easyui-1.4.3/themes/metro/easyui.css" rel="stylesheet" type="text/css" />
|
||
|
|
<link href="/Scripts/jquery-easyui-1.4.3/themes/icon.css" rel="stylesheet" type="text/css" />
|
||
|
|
<link href="/Scripts/jquery-easyui-1.4.3/themes/color.css" rel="stylesheet" type="text/css" />
|
||
|
|
<script src="/Scripts/jquery-easyui-1.4.3/jquery.min.js" type="text/javascript"></script>
|
||
|
|
<script src="/Scripts/jquery-easyui-1.4.3/jquery.easyui.min.js" type="text/javascript"></script>
|
||
|
|
<script src="/Scripts/jquery-easyui-1.4.3/locale/easyui-lang-zh_CN.js" type="text/javascript"></script>
|
||
|
|
<script src="/Scripts/MyJs.js" type="text/javascript"></script>
|
||
|
|
<style>
|
||
|
|
#w td {
|
||
|
|
padding: 5px 5px;
|
||
|
|
text-align: left;
|
||
|
|
vertical-align: middle;
|
||
|
|
}
|
||
|
|
|
||
|
|
#w .title {
|
||
|
|
vertical-align: middle;
|
||
|
|
text-align: right;
|
||
|
|
width: 80px;
|
||
|
|
height: 40px;
|
||
|
|
padding: 0px;
|
||
|
|
}
|
||
|
|
|
||
|
|
p {
|
||
|
|
padding: 0px 5px;
|
||
|
|
font-size: small;
|
||
|
|
font-family: 微软雅黑;
|
||
|
|
margin: 0px;
|
||
|
|
}
|
||
|
|
|
||
|
|
.tree-folder-open, .tree-folder, .tree-file {
|
||
|
|
display: none;
|
||
|
|
}
|
||
|
|
|
||
|
|
.datagrid {
|
||
|
|
text-align: center;
|
||
|
|
}
|
||
|
|
|
||
|
|
.ttb {
|
||
|
|
width: 180px;
|
||
|
|
display: block;
|
||
|
|
}
|
||
|
|
|
||
|
|
#ReportTable_div table {
|
||
|
|
border: 1px solid #000000;
|
||
|
|
border-collapse: collapse;
|
||
|
|
}
|
||
|
|
</style>
|
||
|
|
<title>合格率趋势报表</title>
|
||
|
|
<script>
|
||
|
|
|
||
|
|
|
||
|
|
</script>
|
||
|
|
</head>
|
||
|
|
<body>
|
||
|
|
<form id="form1" runat="server">
|
||
|
|
<div class="top">
|
||
|
|
<table cellpadding="0" cellspacing="0" style="width: 100%">
|
||
|
|
<thead>
|
||
|
|
<tr>
|
||
|
|
<td><span class="title">合格率趋势报表</span></td>
|
||
|
|
</tr>
|
||
|
|
</thead>
|
||
|
|
|
||
|
|
<tbody>
|
||
|
|
<tr>
|
||
|
|
<td style="width: 415px;">产品：<select name="product" id="product" class="easyui-combobox">
|
||
|
|
<option value="全部">全部</option>
|
||
|
|
<option value="保险杠">保险杠</option>
|
||
|
|
|
||
|
|
</select>
|
||
|
|
|
||
|
|
位置：<select name="side" id="side" class="easyui-combobox">
|
||
|
|
<option value="A/B双侧">A/B双侧</option>
|
||
|
|
<option value="A侧">A侧</option>
|
||
|
|
<option value="B侧">B侧</option>
|
||
|
|
</select>
|
||
|
|
|
||
|
|
时间：
|
||
|
|
<%-- <input id="start_time" class="easyui-datebox" style="width: 130px;" /> 至
|
||
|
|
<input id="end_time" class="easyui-datebox" style="width: 130px;" />--%>
|
||
|
|
<input id="StartTime" class="easyui-datetimebox" data-options="onShowPanel:function(){ $(this).datetimebox('spinner').timespinner('setValue','00:00:00');}" /> 至
|
||
|
|
<input id="EndTime" class="easyui-datetimebox" data-options="onShowPanel:function(){ $(this).datetimebox('spinner').timespinner('setValue','23:59:59');}" />
|
||
|
|
|
||
|
|
<a class="topsearchBtn">查询</a>
|
||
|
|
|
||
|
|
<a class="topexcelBtn" id="exportbtn">导出</a>
|
||
|
|
</td>
|
||
|
|
<td style="width: 75px;"></td>
|
||
|
|
<td style="width: 75px;"></td>
|
||
|
|
</tr>
|
||
|
|
</tbody>
|
||
|
|
</table>
|
||
|
|
</div>
|
||
|
|
<div id="ReportTable_div" style="float: left; margin-top: 20px;">
|
||
|
|
</div>
|
||
|
|
<script>
|
||
|
|
|
||
|
|
$(function () {
|
||
|
|
|
||
|
|
var curr_time = new Date();
|
||
|
|
var str = curr_time.getFullYear() + "-";
|
||
|
|
str += curr_time.getMonth() + 1 + "-";
|
||
|
|
str += curr_time.getDate()
|
||
|
|
|
||
|
|
$('#StartTime').datetimebox('setValue', str + " 00:00:00");
|
||
|
|
$('#EndTime').datetimebox('setValue', str + " 23:59:59");
|
||
|
|
|
||
|
|
|
||
|
|
//搜索按钮
|
||
|
|
$('.topsearchBtn').first().click(function () {
|
||
|
|
SearchInfo();
|
||
|
|
});
|
||
|
|
|
||
|
|
$.ajaxSetup({
|
||
|
|
cache: false //关闭AJAX缓存
|
||
|
|
});
|
||
|
|
|
||
|
|
|
||
|
|
$("#exportbtn").bind('click', function () {
|
||
|
|
|
||
|
|
var product = $('#product').combobox('getValue');
|
||
|
|
var side = $('#side').combobox('getValue');
|
||
|
|
//var StartTime = $('#start_time').datetimebox('getValue');
|
||
|
|
//var EndTime = $('#end_time').datetimebox('getValue');
|
||
|
|
var StartTime = $('#StartTime').datetimebox('getValue');
|
||
|
|
var EndTime = $('#EndTime').datetimebox('getValue');
|
||
|
|
var queryParams = {
|
||
|
|
product: product,
|
||
|
|
side: side,
|
||
|
|
StartTime: StartTime,
|
||
|
|
EndTime: EndTime
|
||
|
|
};
|
||
|
|
|
||
|
|
post('<%=ResolveUrl("~/HttpHandlers/QualifiedTrendExcelHandler.ashx?method=QueryExcel") %>', queryParams);
|
||
|
|
});
|
||
|
|
|
||
|
|
});
|
||
|
|
|
||
|
|
function SearchInfo() {
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
var product = $('#product').combobox('getValue');
|
||
|
|
var side = $('#side').combobox('getValue');
|
||
|
|
//var StartTime = $('#start_time').datetimebox('getValue');
|
||
|
|
//var EndTime = $('#end_time').datetimebox('getValue');
|
||
|
|
|
||
|
|
var StartTime = $('#StartTime').datetimebox('getValue');
|
||
|
|
var EndTime = $('#EndTime').datetimebox('getValue');
|
||
|
|
|
||
|
|
$.ajax({
|
||
|
|
url: "QualifiedTrendExcel.aspx/GetDate",
|
||
|
|
datatype: 'json',
|
||
|
|
type: "Post",
|
||
|
|
data: "{'StartTime':'" + StartTime + "','EndTime':'" + EndTime + "','side':'" + side + "','product':'" + product + "'}",
|
||
|
|
contentType: "application/json; charset=utf-8",
|
||
|
|
success: function (data) {
|
||
|
|
if (data != null && data.d != "") {
|
||
|
|
$('#ReportTable_div').html(data.d);
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
$('#ReportTable_div').html('');
|
||
|
|
}
|
||
|
|
}
|
||
|
|
});
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
function post(url, PARAMS) {
|
||
|
|
var temp_form = document.createElement("form");
|
||
|
|
temp_form.action = url;
|
||
|
|
temp_form.target = "_blank";
|
||
|
|
temp_form.method = "post";
|
||
|
|
temp_form.style.display = "none"; for (var x in PARAMS) {
|
||
|
|
var opt = document.createElement("textarea");
|
||
|
|
opt.name = x;
|
||
|
|
opt.value = PARAMS[x];
|
||
|
|
temp_form.appendChild(opt);
|
||
|
|
}
|
||
|
|
document.body.appendChild(temp_form);
|
||
|
|
temp_form.submit();
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</script>
|
||
|
|
</form>
|
||
|
|
</body>
|
||
|
|
</html>
|