1、首先在列表页面增加以下代码
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CertificateSearch.aspx.cs" Inherits="DTMIS.Web.StudentMG.CertificateSearch" %> <!DOCTYPE html> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>StudentSearch</title> <script src="../js/jquery-1.4.4.min.js" type="text/javascript"></script> <script src="../js/My97DatePicker/WdatePicker.js"></script> <link href="../Include/StyleFile.css" type="text/css" rel="stylesheet"> <script type="text/javascript"> function SelectAll(tempControl) { var theBox = tempControl; xState = theBox.checked; elem = theBox.form.elements; for (i = 0; i < elem.length; i++) { if (elem[i].type == "checkbox" && elem[i].id != theBox.id) { if (elem[i].checked != xState) { elem[i].click(); } } } } function changecolor(cbo, o) { var theBox = cbo; var tr = document.getElementById(o); if (theBox.checked) { tr.style.backgroundColor = "#E0E0E0"; } else { tr.style.backgroundColor = "Transparent"; } } //批量打印 function PrintUrl() { var canshu = "<%= canshu%>"; var canshuUrl = ""; var canshus = canshu.split('|'); var chks = document.getElementsByName("DataGrid1_CheckSingle"); if (chks != null && chks.length != 0) { var len = chks.length; for (var i = 0; i < len; i++) { var chk = chks[i] if (chk.checked) { canshuUrl += canshus[i] + ","; } } } if (canshuUrl != "") { var canshusub = canshuUrl.substr(0, canshuUrl.length - 1); window.open("CertificatePrintNew.aspx?canshu=" + canshusub); } else { alert("请选择需打印学员!"); } } </script> </head> <body ms_positioning="GridLayout" bottommargin="0" leftmargin="0" topmargin="0" rightmargin="0" background="../Images/BackGround.gif"> <form id="Form1" method="post" runat="server"> <table height="100%" cellspacing="0" cellpadding="0" width="100%" border="0"> <tr> <td valign="top" width="100%" background="../Images/BackGround.gif"> <table cellspacing="1" cellpadding="0" width="98%" align="center" border="0"> <tr> <td bgcolor="#cccccc" height="23" width="70%"> 学员管理 -- 学员信息</td> <td bgcolor="#cccccc" align="center" width="30%"> </td> </tr> <tr> <td valign="top" colspan="2"> <br> <asp:Panel ID="SearchPanel" runat="server" Width="100%"> <table cellspacing="0" cellpadding="0" width="100%" align="center" border="0"> <tr> <td bgcolor="#006d4a"> <table cellspacing="1" cellpadding="1" width="100%" align="center" border="0"> <tr> <td class="tr" align="center" colspan="4" height="22"> 学员信息查询</td> </tr> <tr> <td class="BDTD"> 所属驾校</td> <td class="WHITETD"> <asp:DropDownList ID="ddlDrvNo" runat="server"> </asp:DropDownList></td> <td class="BDTD" width="15%"> 学员姓名</td> <td class="WHITETD" width="35%"> <asp:TextBox ID="txtS_Name" runat="server" Width="100px"></asp:TextBox></td> <%-- <td class="WHITETD"> </td>--%> </tr> <tr> <td class="BDTD"> 证件号</td> <td class="WHITETD"> <asp:TextBox ID="txtS_IDCardNo" runat="server" Width="160px"></asp:TextBox> </td> <td class="BDTD">报名日期</td> <td class="WHITETD"> <input runat="server" readonly="readonly" id="BgDate" onfocus="WdatePicker({Date:'%y-%M-{%d}'})" /> 至 <input runat="server" readonly="readonly" id="EdDate" onfocus="WdatePicker({Date:'%y-%M-{%d}'})" /> </td> </tr> <tr> <td class="BDTD"> 打印状态</td> <td class="WHITETD"> <asp:DropDownList ID="ddlPrintStatus" runat="server"> <asp:ListItem Value="">全部记录</asp:ListItem> <asp:ListItem Value="1">已打印</asp:ListItem> <asp:ListItem Selected="True" Value="0">未打印</asp:ListItem> </asp:DropDownList> </td> <td class="BDTD"> </td> <td class="WHITETD"> </td> </tr> <%-- <tr> <td class="BDTD" width="15%"> 学员编号</td> <td class="WHITETD" width="35%"> <asp:TextBox ID="txtS_No" runat="server" Width="160px"></asp:TextBox></td> <td class="BDTD" width="15%"> 学员姓名</td> <td class="WHITETD" width="35%"> <asp:TextBox ID="txtS_Name" runat="server" Width="100px"></asp:TextBox></td> </tr>--%> <%-- <tr> <td class="BDTD"> 审批状态</td> <td class="WHITETD"> <asp:DropDownList id="ddlAuditStatus" runat="server"> <asp:ListItem Selected="True"> </asp:ListItem> <asp:ListItem>通过</asp:ListItem> <asp:ListItem>未通过</asp:ListItem> <asp:ListItem>未审核</asp:ListItem> </asp:DropDownList> </td> <td class="BDTD"> 批量编号</td> <td class="WHITETD"> <asp:DropDownList ID="ddlS_Batch" runat="server" Enabled="false"> </asp:DropDownList></td> </tr>--%> <%-- <tr> <td class="BDTD"> 证件类型</td> <td class="WHITETD"> <asp:DropDownList ID="ddlPaType" runat="server"> </asp:DropDownList> </td> </tr>--%> <%-- <tr> <td class="BDTD"> 学员状态</td> <td class="WHITETD"> <asp:DropDownList ID="ddlS_Status" runat="server"> </asp:DropDownList> </td> <td class="BDTD"> 学车类型</td> <td class="WHITETD"> <asp:DropDownList ID="ddlS_StudyVehicleType" runat="server"> <asp:ListItem Value=" "></asp:ListItem> </asp:DropDownList> </td> </tr>--%> <tr bgcolor="#cccccc"> <td align="center" colspan="4" height="30"> <asp:Button ID="Button1" runat="server" Width="60PX" Text="搜索" Height="22px" Font-Size="12px" OnClick="Button1_Click"></asp:Button> <%-- <asp:Button ID="Button5" runat="server" Font-Size="12px" Height="22px" Text="导出" Width="60PX" onclick="Button5_Click" />--%> </td> </tr> <tr> <td colspan="4" height="30" > <input id="btnPrint" runat="server" type="button" onclick="PrintUrl();" value="批量打印" style="float:right;" /> </td> </tr> </table> </td> </tr> </table> </asp:Panel> <%-- <asp:Panel ID="pAudit" Width="100%" runat="server"> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"> <tr bgcolor="#cccccc"> <td align="right" height="25px"> 审批操作: <asp:DropDownList ID="ddlAudit" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlAudit_SelectedIndexChanged"> <asp:ListItem Selected="True"> </asp:ListItem> <asp:ListItem>通过</asp:ListItem> <asp:ListItem>未通过</asp:ListItem> </asp:DropDownList> </td> </tr> </table> </asp:Panel>--%> <asp:Panel ID="ResultPanel" runat="server" Width="100%"> <table cellspacing="1" cellpadding="1" width="100%" align="center" border="0"> <tr> <td align="center"> <asp:DataGrid ID="DataGrid1" runat="Server" Width="100%" BorderColor="#006D4A" BorderWidth="1px" PageSize="15" AutoGenerateColumns="False" OnItemDataBound="DataGrid1_ItemDataBound" > <AlternatingItemStyle BackColor="#F7F7F7"></AlternatingItemStyle> <ItemStyle HorizontalAlign="Center" Height="20px"></ItemStyle> <HeaderStyle HorizontalAlign="Center" Height="22px" ForeColor="White" VerticalAlign="Middle" BackColor="#006D4A"></HeaderStyle> <Columns> <asp:TemplateColumn HeaderText="序号" ItemStyle-Width="6%"> <ItemTemplate><%# Container.ItemIndex + 1%></ItemTemplate> </asp:TemplateColumn> <asp:BoundColumn DataField="D_Name" HeaderText=" 所属驾校" ItemStyle-Width="7%"></asp:BoundColumn> <%-- <asp:BoundColumn DataField="RS_Name" HeaderText="招生点" ItemStyle-Width="7%" Visible="False"></asp:BoundColumn>--%> <%-- <asp:BoundColumn DataField="S_No" HeaderText="学员编号" ItemStyle-Width="7%"></asp:BoundColumn>--%> <asp:BoundColumn DataField="S_Name" HeaderText="学员姓名" ItemStyle-Width="7%"></asp:BoundColumn> <%-- <asp:BoundColumn DataField="S_PaType" HeaderText="证件类型" ItemStyle-Width="7%"></asp:BoundColumn>--%> <asp:BoundColumn DataField="S_IDCardNo" HeaderText="证件号" ItemStyle-Width="7%"></asp:BoundColumn> <%--<asp:BoundColumn DataField="S_Tel" HeaderText="联系电话" ItemStyle-Width="7%"></asp:BoundColumn>--%> <asp:BoundColumn DataField="S_StudyVehicleType" HeaderText="学车类型" ItemStyle-Width="7%"></asp:BoundColumn> <%--<asp:BoundColumn DataField="S_ContractNo" HeaderText="合同编号"></asp:BoundColumn>--%> <asp:BoundColumn DataField="S_RegisterDate" HeaderText="报名日期" ItemStyle-Width="7%" DataFormatString="{0:yyyy-MM-dd}" ></asp:BoundColumn> <%--<asp:BoundColumn DataField="S_ActiveTime" HeaderText="激活日期" ItemStyle-Width="7%"></asp:BoundColumn>--%> <%--<asp:BoundColumn DataField="S_Status" HeaderText="学员状态" ItemStyle-Width="7%"></asp:BoundColumn>--%> <%--<asp:BoundColumn DataField="S_Flag" HeaderText="审批状态" ItemStyle-Width="6%"></asp:BoundColumn>--%> <%-- <asp:TemplateColumn HeaderText="学习进度" ItemStyle-Width="6%"> <ItemTemplate> <a href='w_studentStudyResultYC.aspx?SNo=<%# (DataBinder.Eval(Container,"DataItem.S_No"))%>'>学习进度</a> </ItemTemplate> </asp:TemplateColumn>--%> <asp:TemplateColumn HeaderText="操作" ItemStyle-Width="6%"> <ItemTemplate> <a target="_blank" style=" color:Blue;"href='CertificatePrint.aspx?ID=<%# (DataBinder.Eval(Container,"DataItem.ID"))%>'>结业证打印</a> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="选择" ItemStyle-Width="6%" > <HeaderTemplate> <asp:CheckBox ID="check1" runat="server" onclick="javascript:SelectAll(this);" /> </HeaderTemplate> <ItemTemplate> <asp:Label ID="lbid" runat="server" Text='<%# DataBinder.Eval(Container,"DataItem.ID")%>' Visible="False"></asp:Label> <input id="CheckSingle" type="checkbox" name="<%#DataGrid1.ClientID%>_CheckSingle" /> </ItemTemplate> </asp:TemplateColumn> </Columns> </asp:DataGrid> </td> </tr> <tr> <td bgcolor="#CCCCCC" align="right"> <asp:LinkButton ID="lbFirst" runat="server" OnClick="lbFirst_Click" Enabled="false">首页</asp:LinkButton> <asp:LinkButton ID="lbBack" runat="server" OnClick="lbBack_Click" Enabled="false">上一页</asp:LinkButton> <asp:LinkButton ID="lbNext" runat="server" OnClick="lbNext_Click" Enabled="false">下一页</asp:LinkButton> <asp:LinkButton ID="lbLast" runat="server" OnClick="lbLast_Click" Enabled="false">末页</asp:LinkButton> 第<asp:DropDownList ID="ddlPageSelect" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlPageSelect_SelectedIndexChanged"> <asp:ListItem Value="1">1/1</asp:ListItem> </asp:DropDownList>页 共有<asp:Label ID="lbTotal" runat="server"></asp:Label>个记录 每页<input id="tbPageSize" runat="server" style="35px;" value="15" />个记录 </td> </tr> </table> </asp:Panel> </td> </tr> </table> </td> </tr> </table> </form> </body> </html>
2、打印页面(前台)
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CertificatePrint.aspx.cs" Inherits="DTMIS.Web.StudentMG.CertificatePrint" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=8" /> <title></title> <script src="../js/jquery-1.7.2.min.js"></script> <script src="../js/LodopFuncs.js"></script> <object id="LODOP_OB" classid="clsid:2105C259-1E0C-4534-8141-A753534CB4CA" width="0" height="0"> <embed id="LODOP_EM" type="application/x-print-lodop" width="0" height="0" pluginspage="install_lodop.exe"></embed> </object> <script> function ClosePrintPage() { window.opener = null; window.open('', '_self', ''); window.close(); } var LODOP; //声明为全局变量 function showPrint() { var stuid = '<%=iStudentID%>'; CreatePage(); LODOP.SET_SHOW_MODE("BKIMG_IN_PREVIEW", 1); //注:"BKIMG_IN_PREVIEW"-预览包含背景图 "BKIMG_IN_FIRSTPAGE"- 仅首页包含背景图 LODOP.SET_SHOW_MODE("HIDE_SBUTTIN_PREVIEW", 1); var printCount = LODOP.PREVIEW(); //LODOP.PRINT_DESIGN(); if (printCount > 0) { //DTMIS.Web.StudentMG.w_studentGradPa.UpdatePrintStatus(); $.ajax({ type: "post", url: "CertificatePrint.aspx/UpdatePrintStatus", dataType: "json", data: "{'stuid':" + stuid + "}", contentType: "application/json;charsert=utf-8;", success: function (data) { } }); } ClosePrintPage(); } function CreatePage() { LODOP = getLodop(document.getElementById('LODOP_OB'), document.getElementById('LODOP_EM')); LODOP.SET_PRINT_MODE("PRINT_PAGE_PERCENT", "100%");// //LODOP.PRINT_INITA(0, 0, 3800, 3600, "廊坊驾培结业证书打印");//参数说明:(距上,距左,打印区宽度,打印区高度) LODOP.PRINT_INITA(0, 0, 1123, 756, "廊坊驾培结业证书打印"); LODOP.SET_PRINT_PAGESIZE(1, 1850, 2680, "A4"); LODOP.SET_SHOW_MODE("HIDE_PAPER_BOARD", 1); //隐藏背景条文 LODOP.SET_SHOW_MODE("HIDE_SBUTTIN_PREVIEW", 1); LODOP.SET_SHOW_MODE("LANDSCAPE_DEFROTATED", 1); //注:"BKIMG_IN_PREVIEW"-预览包含背景图 "BKIMG_IN_FIRSTPAGE"- 仅首页包含背景图 //LODOP.ADD_PRINT_IMAGE(8, 15, 2000, 1760, "<img border='0' src='../Images/001.jpg' />");//设置背景图片 LODOP.ADD_PRINT_TEXT(85, 70, 280, 50, "<%=S_GraduateNo %>");//证件编号 LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); //LODOP.ADD_PRINT_IMAGE(100, 400, 132, 185, "<img border='0' src='<%= S_Pic%>' />");//照片 LODOP.ADD_PRINT_TEXT(165, 55, 200, 50, "<%=S_Name %>");//学员名称 LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(165, 165, 100, 50, "<%=S_Sex %>");//性别 LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(190, 245, 100, 50, "<%=S_StudyVehicleType %>");//准驾车型 LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(165, 230, 100, 50, "<%=sRegYear %>");//报名时间(年) LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(165, 310, 100, 50, "<%=sRegMonth %>");//报名时间(月) LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(165, 350, 100, 50, "<%=sRegDay %>");//报名时间(日) LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(190, 15, 100, 50, "<%=gRYear %>");//结业时间(年) LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(190, 88, 100, 50, "<%=gRMonth %>");//结业时间(月) LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(190, 130, 100, 50, "<%=gRDay %>");//结业时间(日) LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(240, 245, 500, 50, "<%=D_Name %>");//培训机构 LODOP.SET_PRINT_STYLEA(0, "FontSize", 16); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(265, 215, 100, 50, "<%=sPrintYear %>");//打印时间(年) LODOP.SET_PRINT_STYLEA(0, "FontSize", 12); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(265, 295, 100, 50, "<%=sPrintMonth %>");//打印时间(月) LODOP.SET_PRINT_STYLEA(0, "FontSize", 12); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); LODOP.ADD_PRINT_TEXT(265, 348, 100, 50, "<%=sPrintDay %>");//打印时间(日) LODOP.SET_PRINT_STYLEA(0, "FontSize", 12); LODOP.SET_PRINT_STYLEA(0, "Bold", 1); LODOP.SET_PRINT_STYLEA(0, "FontName", "楷体"); } </script> </head> <body onload="showPrint()"> <form id="form1" style="margin: 0px; padding: 0px; text-align: left;" runat="server"> <div id="div_PrintDown"> <input type="button" value="打印预览" name="B3" onclick="showPrint()" /> </div> </form> </body> </html>
3、后台代码
using AjaxPro; using DTMIS.BLL; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.Services; using System.Web.UI; using System.Web.UI.WebControls; namespace DTMIS.Web.StudentMG { public partial class CertificatePrint : System.Web.UI.Page { private string ModuleDir = "StudentMG/"; private string ModulePage = "CertificatePrint.aspx"; public static int iStudentID;//学员编号 public string S_GraduateNo;//资格证号 public string S_Name;//姓名 public string S_Sex;//性别 public DateTime S_RegisterDate;//报名日期 public string S_Pic;//照片 public string S_StudyVehicleType;//准驾车型 public string D_Name;//驾校 protected string sRegYear; protected string sRegMonth; protected string sRegDay; protected string gRYear; protected string gRMonth; protected string gRDay; protected string sPrintYear; protected string sPrintMonth; protected string sPrintDay; protected void Page_Load(object sender, EventArgs e) { //if (!Common.canAccess(this.ModuleDir + this.ModulePage)) //{ // base.Response.Redirect("../NoPower.html"); //} if (!IsPostBack) { Utility.RegisterTypeForAjax(typeof(CertificatePrint)); iStudentID = Convert.ToInt32(base.Request.QueryString["ID"]); DataSet set = BLL.T_Student_Base.getStudentData(iStudentID); if (set.Tables.Count > 0) { foreach (DataRow item in set.Tables[0].Rows) { DateTime time; DateTime time1; S_GraduateNo = item["S_GraduateNo"].ToString().Trim(); S_Name = item["S_Name"].ToString().Trim(); S_Sex = item["S_Sex"].ToString().Trim(); S_Pic = ConvertUrl(item["S_Pic"].ToString().Trim()); S_StudyVehicleType = item["S_StudyVehicleType"].ToString().Trim(); D_Name = item["D_Name"].ToString().Trim(); //报名日期 if (item["S_RegisterDate"].ToString() != "") { time = Convert.ToDateTime(item["S_RegisterDate"].ToString()); sRegYear = time.Year.ToString(); sRegMonth = time.Month.ToString(); sRegDay = time.Day.ToString(); } //结业日期 if (item["A_AddTime"].ToString() != "") { time1 = Convert.ToDateTime(item["A_AddTime"].ToString()); gRYear = time1.Year.ToString(); gRMonth = time1.Month.ToString(); gRDay = time1.Day.ToString(); } //打印时间 DateTime now = DateTime.Now; sPrintYear = now.Year.ToString(); sPrintMonth = now.Month.ToString(); sPrintDay = now.Day.ToString(); } } } } //[AjaxMethod] [WebMethod] public static string UpdatePrintStatus(string stuid) { string msg = string.Empty; int result = Common.Update("T_Student_Base", "IsGraducatePrint=1", "ID=" + stuid); if (result > 0) { msg = "ok"; } else { msg = "error"; } return msg; } private string ConvertUrl(string imgUrl) { if (!string.IsNullOrEmpty(imgUrl)) { imgUrl = imgUrl.Substring(1, imgUrl.Length - 1); string strDomain = "http://" + HttpContext.Current.Request.Url.Host; int iPort = HttpContext.Current.Request.Url.Port; string imgPath = strDomain + ":" + iPort.ToString() + "/" + imgUrl.Replace(Server.MapPath("/"), "").Replace(@"", "/"); return imgPath; } else { return ""; } } } }
以上三步即可实现lodop打印