Web打印

来源:互联网 发布:考研政治题库软件 编辑:程序博客网 时间:2024/06/09 15:37

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Print1.aspx.cs" Inherits="logisticsmg_Print1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>打印1</title>
    <link href="../Include/style2.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
       
         <table cellspacing="0" cellpadding="0" width="100%" border="0">
         <tr>
         <td valign="top" align="center">
         <FONT  Class="ftitle"><b>保定网城DRP分销系统</b><br/>客户订货申请单</FONT><br/><br/>
         </td>
         </tr>
         <tr><td align="center">
        
             <table border="1" cellpadding="0" cellspacing="0" style="width: 100%">
                 <tr>
                     <td style="width: 10%; height: 25px" align="right">
                     申请区域/单位:</td>
                     <td style="width: 40%" align="left">
                     保定网城DRP分销系统
                     </td>
                     <td style="width: 10%" align="right">
                     申请日期:</td>
                     <td style="width: 40%" align="left"><%=datetime%>&nbsp;<%=BillCode%>
                     </td>
                 </tr>
                 <tr>
                     <td style="width: 120px; height: 25px" align="right">
                     联系人:</td>
                     <td style="width: 100px">
                         212121212121</td>
                     <td style="width: 100px" align="right">
                     联系电话:</td>
                     <td style="width: 100px" align="left" >
                     0312--1231 1231</td>
                 </tr>
                 <tr>
                     <td style="width: 120px; height: 25px" align="right">
                     供应商名称:</td>
                     <td style="width:40%" align="left">
                     <%=ProviderName%>
                     </td>
                     <td style="width: 100px" align="right">
                     电话/传真:</td>
                     <td style="width: 100px" align="left">
                         1231 1231</td>
                 </tr>
             </table>
         </td> </tr>  </table>
      
        <asp:Repeater ID="Repeater1" runat="server" OnItemDataBound="Repeater1_ItemDataBound">
       
     
       <ItemTemplate>
         <center></center>
       
        <asp:GridView ID="GridView1" DataKeyNames="iID" CssClass="noPrint" PagerSettings-Visible="false" runat="server" AutoGenerateColumns="False" Width="100%"  BorderWidth="1px" BorderColor="Silver" ShowFooter="false" AllowPaging="true" PageSize="2">
            <Columns>
               <asp:TemplateField HeaderText="序号">
                <ItemTemplate>
                <%=bianhao+=1%>
                </ItemTemplate>
                <ItemStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:TemplateField>
               
                <asp:BoundField HeaderText="商品货号" DataField="ID">
                 <ItemStyle  BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:BoundField>
               
                <asp:BoundField HeaderText="型号品全名" DataField="Name" >
                <ItemStyle  BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:BoundField>
               
                <asp:BoundField HeaderText="包装数" DataField="sex" >
                <ItemStyle  BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:BoundField>
               
                <asp:BoundField HeaderText="数量"  DataField="birthday">
                <ItemStyle  BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:BoundField>
               
                <asp:BoundField HeaderText="件数"  DataField="iID">
                <ItemStyle  BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:BoundField>
               
                <asp:BoundField HeaderText="现有库" DataField="ID" >
                <ItemStyle  BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:BoundField>
               
                <asp:BoundField HeaderText="单价"  DataField="name">
                <ItemStyle  BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:BoundField>
               
                <asp:BoundField HeaderText="金额" DataField="sex">
                <ItemStyle  BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:BoundField>
               
                <asp:BoundField HeaderText="条码说明或其它" DataField="birthday">
                <ItemStyle  BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                    <HeaderStyle BorderColor="Silver" BorderWidth="1px" HorizontalAlign="center" VerticalAlign="middle" />
                </asp:BoundField>
               
            </Columns>
            <EmptyDataTemplate>
                <table  border="1px" cellpadding="0px" cellspacing="0px" width="100%">
                    <tr><td>序号</td>
                        <td >商品货号</td>
                        <td >型号品全名</td>
                        <td>包装数</td>
                        <td >数量</td>
                        <td>件数</td>
                        <td>现有库</td>
                        <td>单价</td>
                        <td>金额</td>
                        <td >条码说明或其它</td>
                     </tr>
                  </table>
            </EmptyDataTemplate>
            <EmptyDataRowStyle BorderWidth ="0px" />
        </asp:GridView>
        <center>
         <div style="text-align: left">
            <table border="0" cellpadding="0" cellspacing="0" style="width: 100%">
                <tr>
                    <td style="width: 200px">
                        制单人:管理员</td>
                    <td style="width: 200px">
                        确认人:</td>
                    <td style="width: 200px">
                        经手人:</td>
                </tr>
              
            </table>
         
        </div>
        </center>
        </ItemTemplate>
      <SeparatorTemplate><div class="pageBreak"></div></SeparatorTemplate>
        </asp:Repeater>
     
         <TABLE cellSpacing="0" cellPadding="0" width="100%" align="center" border="0">
        <TBODY>
         <tr>
                    <td style="width: 100%">
                    <B>请携此订单尽快发货!</B>
                    </td>
                  
                </tr>
        <TR align=left>
          <TD class=f12 vAlign=top width=80 height=30><B>备 注:</B></TD>
          </TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
        <TBODY>
        <TR align=left>
          <TD class=f12  height=30><B><BR><BR><BR>申请单位法人或授权负责人盖章(签字):        </B></TD></TR></TBODY></TABLE>
   </div>
    </form>
</body>
</html>

 

 

 

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using yawang;

public partial class logisticsmg_Print1 : System.Web.UI.Page
{
 public string BillCode = "RK08091015552940";
    public string ProviderName = "";
    yawang.dataBase yw = new dataBase();
    public string datetime="";
    private int pageSize = 2;
    public int bianhao=0;
    protected void Page_Load(object sender, EventArgs e)
    {
       // if (Request.QueryString["BillCode"]!=null)
       //{
       //    BillCode = Request.QueryString["BillCode"].ToString();
            ProviderName = yw.Row1Colum1("select sPName from xBillIndexSupp bis join xProvider p on  bis.iProID=p.iID where bis.BillCode='"+BillCode.ToString()+"'");
     // }
        if (!IsPostBack)
        {
            datetime = DateTime.Now.ToString("yyyy-MM-dd");
         
                  int Page;
                  ArrayList pages = new ArrayList();    //构造页集合
                  Page = Convert.ToInt32(yw.Row1Colum1("select count(*) from exp")) / pageSize;
                  for (int i = 1; i <= Page; i++)
                      pages.Add(i.ToString());
                  Repeater1.DataSource = pages;         //绑定到Repeater
                  Repeater1.DataBind();

        }
     
       // tableHead();
        //PrintDetail();
      
    }
    #region 打印表头
    protected void tableHead()
    {
       // string datatime=DateTime.Now.ToString("yyyy-MM-dd");
    //    Response.Write("<table border=0 cellpadding=0 cellspacing=0 width=100%><tr><td width=100%> <table border=0 cellpadding=0 cellspcing=0 width=100%><tr><td align=center><table cellSpacing=0 cellPadding=0 width=100% align=center border=0><tr><td valign=top align=center><FONT  Class=ftitle><b>保定网城DRP分销系统</b><br/>客户订货申请单</FONT><br/><br/></td></tr><tr><td align=center><table border=1 cellpadding=0 cellspacing=0  align=center width= 100%><tr height=25px Class=f12><td width=120px align=right>申请区域/单位:</td><td   align=left>保定网城DRP分销系统</td> <td  width=100px align=left>  申请日期:</td> <td  align=left>" + datatime.ToString() + "&nbsp;" + BillCode.ToString() + "</td></tr>       <tr  height=25px Class=f12> <td  width=120px align=right>      联系人:</td>  <td  align=left>        1212121212121</td>  <td  width=100px align=left>  联系电话:</td>   <td  align=left>            0312--1231 1231</td> </tr><tr height=25px Class=f12><td  width=120px align=right> 供应商名称:</td><td  align=left>" + ProviderName.ToString() + "</td><td  width=100px align=left>    电话/传真:</td>  <td  align=left>  1231 1231</td>        </tr>     </table> </td> </tr>  </table> </td></tr></table>");
    }
    #endregion

    #region 打印具体内容
  
#endregion

    protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            GridView grid = (GridView)e.Item.FindControl("GridView1");
           // grid.PageSize = 2;
            grid.PageIndex = e.Item.ItemIndex;
            //bianhao = Convert.ToInt32(e.Item.ItemIndex);
           DataTable dt = yw.ExecuteSQL("select * from exp");
           // DataTable dt = new DataTable();
          //  dt = null;
            grid.DataSource = dt;
            grid.DataBind();
        }

    }

}

原创粉丝点击