打印
若此页有一个打印按钮：
<input type=”button” id=”btnPrint” class=”button_sm7″ value=”打印” onclick=”PrintDep();” />
JS连接到打印页问号后边是传参数，是在此页的查询条件：
function PrintDep() {
window.open(‘Print.aspx?txtUName=’ + escape($(“#txtUName”).val()) + ‘&ddlDep=’ + escape($(“#ddlDep”).val()) + ‘&ddlClass=’ + escape($(“#ddlClass”).val()) + ‘&ddlIYear=’ + escape($(“#ddlIYear”).val()), ‘_blank’)
}
Print.aspx（显示的是要打印的数据）：
<head id=”Head1″ runat=”server”>
<title>。。。。打印</title>
<script type=”text/javascript” src=”../Page/js/jquery-1.7.2.min.js”></script>
<script type=”text/javascript” src=”../Page/js/hide_show.js”></script>
<link href=”../Page/css/layout.css” rel=”stylesheet” type=”text/css” />
<link href=”../Page/css/Dialog.css” rel=”stylesheet” type=”text/css” />
<script type=”text/javascript” src=”../Page/js/jQuery_Dialog.js”></script>
<script type=”text/javascript” src=”../Page/js/function.js”></script>
<script type=”text/javascript” src=”../Page/js/jquery.easydrag.js”></script>
<link href=”../Page/css/style01.css” rel=”stylesheet” type=”text/css” />
</head>
<body>
<form id=”form1″ runat=”server”>
<div class=”div_page_bottom_operation” style=”text-align: center; display: ”;”>
<input type=”button” class=”button_sm7″ value=”打印” onclick=”PrintSalary();” />
</div>
<div style=”width: 96%; margin: 0 auto;font-size:24px;” align=”center” >
。。查询
</div>
<div style=”overflow: auto; width: 96%; margin: 0 auto;”>
<table class=”table”>
<thead>
<tr>
<th style=”width: 60px” rowspan=”2″>
序号
</th>
<th rowspan=”2″>
。。
</th>
<th rowspan=”2″>
。。
</th>
<th rowspan=”2″>
。。
</th>
<th rowspan=”2″>
。。
</th>
<th rowspan=”2″>
。。
</th>
<th rowspan=”2″>
。。
</th>
<th rowspan=”2″>
。。
</th>
<th colspan=”4″ style=”text-align: center;”>
。。
</th>
</tr>
<tr>
<th>
。。
</th>
<th>
。。
</th>
<th>
。。
</th>
<th>
。。
</th>
</tr>
</thead>
<tbody>
<asp:Repeater ID=”rptStudentFee” runat=”server”>
<ItemTemplate>
<tr>
<td>
<%#Eval(“r_n”) %>
</td>
<td>
<%#Eval(“Department”) %>
</td>
<td>
<%#Eval(“CName”) %>
</td>
<td>
<%#Eval(“TTCard”) %>
</td>
<td>
<%#Eval(“UName”) %>
</td>
<td>
<%#DigitalCampus.Web.Common.pfunction.getPBCName(DigitalCampus.Web.Common.clsDictionaryData.Gender.ToString(),Eval(“Gender”).ToString()) %>
</td>
<td>
<%#DigitalCampus.Web.Common.pfunction.GetStrToShortDate(Eval(“AdmissionDate”).ToString())%>
</td>
<td>
<%#Eval(“UName”) %>
</td>
<td>
<%#Eval(“SubYear”)%>
</td>
<td>
<%#Eval(“ShouldPayment”)%>
</td>
<td>
<%#Eval(“ActualPayment”)%>
</td>
<td>
<%#Decimal.Parse(Eval(“ShouldPayment”).ToString()) – Decimal.Parse(Eval(“ActualPayment”).ToString())%>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>
<asp:Repeater runat=”server” ID=”rptCount”>
<ItemTemplate>
<tr style=”font-weight: bold;”>
<td>
合计
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
￥ <%#Eval(“ShouldPayment”) %>
</td>
<td>
￥ <%#Eval(“ActualPayment”)%>
</td>
<td>
￥ <%#Decimal.Parse(Eval(“ShouldPayment”).ToString()) – Decimal.Parse(Eval(“ActualPayment”).ToString())%>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>
</tbody>
</table>
</div>
<script type=”text/javascript” language=”javascript”>
function PrintSalary() {
$(“.div_page_bottom_operation”).hide();
window.print();
}
</script>
</form>
</body>
</html>
Print.aspx.cs（后台查询出数据）：
//查询参数
public string txtUName = string.Empty;
public string ddlDep = string.Empty;
public string ddlClass = string.Empty;
public string ddlIYear = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
txtUName = Request.QueryString[“txtUName”];
ddlDep = Request.QueryString[“ddlDep”];
ddlClass = Request.QueryString[“ddlClass”];
ddlIYear = Request.QueryString[“ddlIYear”];
if (!IsPostBack)
{
GetFilesList();
}
}
private void GetFilesList()
{
string sort = “”;
string strWhere = ” where 1=1 “;
if (!string.IsNullOrEmpty(txtUName) && txtUName != “。。”)
{
strWhere += ” and (vw.UName like ‘%” + txtUName+ “%’ or vw.IdentityCard like ‘%” + txtUName + “%’ or vw.TTCard like ‘%” + txtUName + “%’)”;
}
if (ddlDep != “-1”)
{
strWhere += ” and vw.DepName='” + ddlDep + “‘”;
}
if (ddlClass != “-1”)
{
strWhere += ” and vw.ClassName='” + ddlClass + “‘”;
}
if (ddlIYear != “-1”)
{
strWhere += ” and sp.SubYear='” + ddlIYear + “‘”;
}
string strSql = @”select row_number() over(order by sp.SubYear,vw.DepName,vw.ClassName,vw.UName) as r_n,sp.*,vw.*
from (select StuID,SubYear,isnull(sum(ShouldPayment),0) ShouldPayment,isnull(sum(ActualPayment),0)
ActualPayment from StudentShouldpay group by StuID,SubYear) sp inner join dbo.vw_StudentInfo vw on sp.StuID=vw.ID ” + strWhere;
DataTable dt = sys.GetRecordByPage(strSql, pNum, pSize, sort, out rCount, out pCount).Tables[0];
rptStudentFee.DataSource = dt;
rptStudentFee.DataBind();
if (dt.Rows.Count > 0)
{
DataTable dt2 = new DataTable();
dt2 = DbHelperSQL.Query(@”select isnull(sum(ShouldPayment),0) ShouldPayment,isnull(sum(ActualPayment),0) ActualPayment from (select StuID,SubYear,isnull(sum(ShouldPayment),0) ShouldPayment,isnull(sum(ActualPayment),0) ActualPayment from StudentShouldpay group by StuID,SubYear) sp inner join dbo.vw_StudentInfo vw on sp.StuID=vw.ID ” + strWhere).Tables[0];
rptCount.DataSource = dt2;
rptCount.DataBind();
}
}
点击Print.aspx页的打印就可打印出
