asp.net批量打印源碼
廣告：
private void printnoid(object noid)
{
conn.open();
string sqlp="";
sqlp="select noid,address,yb,company,linkman,imnkflx,tbimnkflx_2,printflag from kfzl where noid= "+noid+" order by noid desc";
SqlDataAdapter Adapter = new SqlDataAdapter(sqlp, conn.link);
DataSet myDs=new DataSet();
Adapter.Fill(myDs);
DataTable myTable=myDs.Tables[0];//重要
foreach(DataRow myRow in myTable.Rows)
{
if (myRow["printflag"].ToString() !="1")
{
Response.Write("<div class=PageNext></div>");
Response.Write("<p><br><br><br><br><br></p>");
Response.Write("<table width=92% border=0 align=center cellpadding=2 cellspacing=0><tr><td width=200 rowspan=6 class=tdp1> </td><td height=35 class=tdp1>"+myRow["yb"]+"</td></tr>");
Response.Write(" <tr><td height=32 class=tdp >寄："+myRow["address"]+" </td></tr>");
Response.Write(" <tr> <td height=32 class=tdp> "+myRow["company"]+"</td></tr>");
Response.Write(" <tr> <td height=46 class=tdp> "+myRow["linkman"]+" （收）</td></tr>");
Response.Write(" <tr><td height=376 > </td> </tr>");
Response.Write(" <tr> <td height=20 class=tdp2> 訂閱 "+myRow["imnkflx"]+" "+ myRow["tbimnkflx_2"]+" "+myRow["noid"]+"</td></tr>");
Response.Write(" </table>");
//Response.Write("<hr align=center width=90% size=1 noshade class=NOPRINT >");
string sqlupdate="";
sqlupdate="update kfzl set printflag=1 where noid="+noid;
SqlCommand command2=new SqlCommand(sqlupdate,conn.link);
command2.ExecuteNonQuery();
}
}
conn.link.Close();
}
private void haosubmit_Click(object sender, System.EventArgs e)
{
// 打印頁面
Response.Write(" <style media=print> .Noprint{display:none;} .PageNext{page-break-after: always;}</style>");
Response.Write("<style> #hao { position: absolute; top: 180px;right:215px; font-family: 宋體;font-size: 13px;color: 6BBA6B;letter-spacing: 2px;filter: alpha(opactiy=100);} .tdp2{ font-size: 11px; } .tdp{ font-size: 16px; } .tdp1{ font-size: 18px; letter-spacing: 23px;}");
Response.Write(" .NOPRINT { font-size: 13px; } </style>");
Response.Write("<center class=Noprint > <p><br> <input type=button =' 打 印 ' =all.WebBrowser.ExecWB(6,1)> <input type=button =直接打印 =all.WebBrowser.ExecWB(6,6)> ");
Response.Write(" <input type=button =頁面設置 =all.WebBrowser.ExecWB(8,1)></p> <p> <input type=button =打印預覽 =all.WebBrowser.ExecWB(7,1)> <input type=button =' 撤 銷 ' =all.WebBrowser.ExecWB(15,1)> 共 <font color=red>"+Khzl_DataGrid.Items.Count+"</font> 封 </p> <hr align=center width=90% size=1 noshade> <div id=hao > 請在頁面設置里選擇橫向打印，去掉頁眉、頁腳<em>！</em>打印300封以上時,需要耐心等待加載……<br><br><br> 打印中，本頁面請不要關閉 <em>！</em></div></center>");
Response.Write("<OBJECT id=WebBrowser classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 height=0 width=0></OBJECT>");
//輸出打印頁面開始
string pnoid="";
int j=0;
for (int i=0;i<Khzl_DataGrid.Items.Count; i++)
{
CheckBox printtemp=(CheckBox)Khzl_DataGrid.Items[i].FindControl("printtemp");
DataBoundLiteralControl haonoid=(DataBoundLiteralControl)Khzl_DataGrid.Items[i].Cells[0].Controls[0];
pnoid=haonoid.Text.ToString();
if (printtemp.Checked==true)//printtemp1=printtemp1+"hao"+i+pnoid;
{printnoid(pnoid);
j=j+1;
Session["printcount"]=j.ToString();
}
}
}
}
廣告：
