using System;
using System.Data;
using System.Web;
using System.Text;
using System.Collections;
using System.Web.UI;
using System.Data.SqlClient;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;
namespace baolong
{
/// <summary>
/// 这是一个完全利用IE自身对象实现Web打印的方案，主体数据来源于DataGrid控件绑定的数据
/// 同时，用户可以自定义标题、页眉、页脚、每页打印行数等一般报表的基本要素
/// 作者：KG
/// 日期：2005.1.1
/// 来源：www.domanage.com.
/// </summary>
public class clsPrint: System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button btnPrint;
protected System.Web.UI.WebControls.DataGrid MyDataGrid; //Page基本的URL
private static clsPrint m_clsPrint = new clsPrint();
private string[] sShoulderLeft;
private string[] sShoulderCenter;
private string[] sShoulderRight;
private string[] sFooterLeft;
private string[] sFooterCenter;
private string[] sFooterRight;
private string sPageTitle = "";
private string sSpanColumnList = "";
private int iPageNumber = 30;
//private DataGrid MyDataGrid;
private static string pageUrlBase;
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
BindGrid();
DisplayGrid();
}
}
public clsPrint()
{
try
{
string urlSuffix = Context.Request.Url.Host ;
urlSuffix = urlSuffix + (Context.Request.Url.Port.ToString()=="" ? "" : ":"+ Context.Request.Url.Port);
urlSuffix = urlSuffix + (Context.Request.ApplicationPath.ToString()=="/" ? "" :Context.Request.ApplicationPath);
pageUrlBase = @"http://" + urlSuffix;
}
catch
{
// for design time
}
}
private void BindGrid()
{
DataTable dTable = baolong.Components.BusApp.UnitApp.GetUnit();
DataView dv = dTable.DefaultView;
//dv.Sort = ViewState["SortExp"].ToString();
MyDataGrid.DataSource = dv;
MyDataGrid.DataBind();
//AspNetPager1.RecordCount = dTable.Rows.Count;
//this.PagerBindDate(dv,AspNetPager1,MyDataGrid,"UnitCode",15);
}
private void DisplayGrid()
{
MyDataGrid.DataBind();
m_clsPrint.dgDataGrid=MyDataGrid;
}
private void btnPrint_Click(object sender, System.EventArgs e)
{
//可使用方法和属性如下：
DisplayGrid();
m_clsPrint.PageTitle = "权限列表";
m_clsPrint.PageNumber = 30;
string[] sShoulderLeft = new string[3];
string[] sShoulderRight = new string[2];
string[] sShoulderCenter = new string[1];
sShoulderLeft[0] = "左页眉一";
sShoulderLeft[1] = "左页眉二";
sShoulderLeft[2] = "左页眉三";
sShoulderCenter[0] = "中页眉一 ";
sShoulderRight[0] = "右页眉一";
sShoulderRight[1] = "右页眉二（共计XXXX名）";
m_clsPrint.ShoulderLeft = sShoulderLeft;
m_clsPrint.ShoulderCenter = sShoulderCenter;
m_clsPrint.ShoulderRight = sShoulderRight;
string[] sFooterLeft = new string[3];
string[] sFooterCenter = new string[1];
string[] sFooterRight = new string[2];
sFooterLeft[0] = "左页脚一制表人：XXX 制表日期：";
sFooterLeft[1] = "左页脚二复核人：XXX 复核日期：";
sFooterLeft[2] = "左页脚三XXX教学服务站（中心）XXXX入学年级";
sFooterCenter[0] = "中页脚一";
sFooterRight[0] = "右页脚一2009年18月40";
sFooterRight[1] = "右页脚二（共计XXXX名）";
m_clsPrint.FooterLeft = sFooterLeft;
m_clsPrint.FooterCenter = sFooterCenter;
m_clsPrint.FooterRight = sFooterRight;
m_clsPrint.SpanColumnList="0,1";
m_clsPrint.PrintView();
Page.RegisterStartupScript("show", "<script languge='javascript'>window.open('printWindow.htm','_blank');</script>");
}
#region 每页显示的行数
/// <summary>
/// 每页显示的行数
/// </summary>
public int PageNumber
{
get
{
return iPageNumber;
}
set
{
iPageNumber =value;
}
}
#endregion
#region 页的标题
/// <summary>
/// 页的标题
/// </summary>
public string PageTitle
{
get
{
return sPageTitle;
}
set
{
sPageTitle =value;
}
}
#endregion
#region 网格控键要合并的列集合
/// <summary>
/// 网格控键要合并的列集合，格式如： 1,2,3,4...用逗号分割
/// </summary>
public string SpanColumnList
{
get
{
return sSpanColumnList;
}
set
{
sSpanColumnList =value;
}
}
#endregion
#region 左页眉标题，数组类型[0][1]... 显示顺序从上至下
/// <summary>
/// 页的标题
/// </summary>
public string[] ShoulderLeft
{
get
{
return sShoulderLeft;
}
set
{
sShoulderLeft =value;
}
}
#endregion
#region 中页眉标题，数组类型[0][1]... 显示顺序从上至下
/// <summary>
/// 页的标题
/// </summary>
public string[] ShoulderCenter
{
get
{
return sShoulderCenter;
}
set
{
sShoulderCenter =value;
}
}
#endregion
#region 右页眉标题，数组类型[0][1]... 显示顺序从上至下
/// <summary>
/// 页的标题
/// </summary>
public string[] ShoulderRight
{
get
{
return sShoulderRight;
}
set
{
sShoulderRight =value;
}
}
#endregion
#region 左页脚标题，数组类型[0][1]... 显示顺序从上至下
/// <summary>
/// 页的标题
/// </summary>
public string[] FooterLeft
{
get
{
return sFooterLeft;
}
set
{
sFooterLeft =value;
}
}
#endregion
#region 中页脚标题，数组类型[0][1]... 显示顺序从上至下
/// <summary>
/// 页的标题
/// </summary>
public string[] FooterCenter
{
get
{
return sFooterCenter;
}
set
{
sFooterCenter =value;
}
}
#endregion
#region 右页脚标题，数组类型[0][1]... 显示顺序从上至下
/// <summary>
/// 页的标题
/// </summary>
public string[] FooterRight
{
get
{
return sFooterRight;
}
set
{
sFooterRight =value;
}
}
#endregion
#region 打印的网格控件名称
/// <summary>
/// 打印的网格控件名称
/// </summary>
public DataGrid dgDataGrid
{
get
{
return MyDataGrid;
}
set
{
MyDataGrid =value;
}
}
#endregion
#region 修改模板文件的内容，构造打印数据，重写打印模板
/// <summary>
/// 修改模板文件的内容，构造打印数据，重写打印模板
/// </summary>
public void PrintView()
{
ClearView();
StringBuilder htmltext=new StringBuilder();
try
{
using (StreamReader sr = new StreamReader( Server.MapPath(Context.Request.ApplicationPath) + "//printWindow.htm"))
{
String line;
while ((line = sr.ReadLine()) != null)
{
htmltext.Append(line);
}
sr.Close();
}
}
catch
{
Response.Write("<Script>alert('读取文件错误')</Script>");
}
//----------替换htm里的标记为你想加的内容
htmltext.Replace("Model",PintPage());
//----------生成htm文件------------------――
try
{
using(StreamWriter sw=new StreamWriter( Server.MapPath(Context.Request.ApplicationPath) + "//printWindow.htm",false,System.Text.Encoding.GetEncoding("GB2312")))
{
sw.WriteLine(htmltext);
sw.Flush();
sw.Close();
//Response.Write("<script languge='javascript'>alert('111');window.open('"+pageUrlBase+"/printWindow.htm','_blank');</script>");
}
}
catch
{
Response.Write ("The file could not be wirte:");
}
//Response.Write("<script languge='javascript'>alert('111');window.open('"+pageUrlBase+"/printWindow.htm','_blank');</script>");
//Page.RegisterStartupScript("show111", "<script languge='javascript'>alert('"+pageUrlBase+"');window.open('"+pageUrlBase+"/printWindow.htm','_blank');</script>");
}
#endregion
#region 打印主函数，构造要打印的页面的所有打印项目（标题，列标题，网格数据，shoulder,footer）
/// <summary>
/// 打印主函数
/// </summary>
/// <returns></returns>
private string PintPage()
{
int iTableIndex = 1;
string[] ColumnList ;
string sTable="<object ID='WebBrowser' WIDTH=0 HEIGHT=0 CLASSID='CLSID:8856F961-340A-11D0-A96B-00C04FD705A2'></object>/n/n";
//添加页的标题
sTable = sTable + AddPageTitle();
//添加页眉
sTable = sTable + AddShoulder();
//添加网格数据第一页
sTable = sTable + "<table id=/"table1/" class=/"print-body/" cellspacing=/"0/" cellpadding=/"0/" border=/"0/" width=/"100%/">";
//添加该页的列标题
sTable = sTable + AddTableTitle();
//初始化行号
int iStartItemIndex = 0;
int iItemIndex = iStartItemIndex;
//主体数据
int i = 0;
DataTable dt = new DataTable();
if(this.MyDataGrid.DataSource is DataSet)
{
dt = ((DataSet)this.MyDataGrid.DataSource).Tables[0];
}
else if( this.MyDataGrid.DataSource is DataView)
{
dt=((DataView)this.MyDataGrid.DataSource).Table;
}
else if(this.MyDataGrid.DataSource is DataTable)
{
dt = ((DataTable)this.MyDataGrid.DataSource);
}
foreach(DataRow row in dt.Rows)
{
if(i > 0 && i%iPageNumber==0)
{
//上一页结束
sTable = sTable + "</table>";
if(sSpanColumnList!="")
{
ColumnList = sSpanColumnList.Split(',');
for(int ii = 0 ; ii < ColumnList.Length ; ii++)
{
sTable = sTable + "<script languge='javascript'>TableRowSpan(/"table"+iTableIndex.ToString()+"/","+ColumnList[ii].ToString()+");</script>/n/n";
}
}
sTable = sTable + AddFooter();
//换页
sTable = sTable + AddPageBreak();
//添加页的标题
sTable = sTable + AddPageTitle();
//添加页眉
sTable = sTable + AddShoulder();
iTableIndex++;
//创建新一轮的表格
sTable = sTable + "<table id=/"table"+iTableIndex.ToString()+"/" class=/"print-body/" cellspacing=/"0/" cellpadding=/"0/" border=/"0/" width=/"100%/">";
//添加该页的列标题
sTable = sTable + AddTableTitle();
}
//将记录添加到表格的一行中
sTable = sTable + AddItemToTable(row);
//行号加一
iItemIndex++;
i++;
}
sTable = sTable + "</table>/n/n";
if(sSpanColumnList!="")
{
ColumnList = sSpanColumnList.Split(',');
for(int ii = 0 ; ii < ColumnList.Length ; ii++)
{
sTable = sTable + "<script languge='javascript'>TableRowSpan(/"table"+iTableIndex.ToString()+"/","+ColumnList[ii].ToString()+");</script>/n/n";
//sTable = sTable + "<script languge='javascript'>TableRowSpan(/"table"+iTableIndex.ToString()+"/",0);</script>/n/n";
}
}
//添加页脚
sTable = sTable + AddFooter();
sTable = sTable + "<script languge='javascript'>WebBrowser.ExecWB(7,1); window.opener=null;window.close();</script>";
return sTable ;
}
#endregion
#region 增加一行数据到表格中，生成要打印网格数据的行数据
/// <summary>
/// 增加一行数据到表格中
/// </summary>
/// <param name="row">值</param>
private string AddItemToTable( DataRow row)
{
string sItem="<tr>/n";
for(int i = 0 ;i < MyDataGrid.Columns.Count ;i++)
{
if (MyDataGrid.Columns[i].Visible == true)
{
switch (MyDataGrid.Columns.GetType().Name.ToString())
{
case "BoundColumn" :
sItem = sItem + "<td class=/"print-row/"> "+row[((BoundColumn)(MyDataGrid.Columns[i])).DataField].ToString()+" </td>";
//cell.InnerText = row[((BoundColumn)(MyDataGrid.Columns)).DataField].ToString();
break;
case "ButtonColumn" :
sItem = sItem + "<td class=/"print-row/"> "+row[((ButtonColumn)(MyDataGrid.Columns[i])).DataTextField].ToString()+" </td>";
//cell.InnerText = row[((ButtonColumn)(MyDataGrid.Columns)).DataTextField].ToString();
break;
case "EditCommandColumn" :
//cell.InnerText = row[((EditCommandColumn)(MyDataGrid.Columns)).DataField].ToString();
break;
case "HyperLinkColumn" :
sItem = sItem + "<td class=/"print-row/"> "+row[((HyperLinkColumn)(MyDataGrid.Columns[i])).DataTextField].ToString()+"</td>";
//cell.InnerText = row[((HyperLinkColumn)(MyDataGrid.Columns)).DataTextField].ToString();
break;
case "TemplateColumn":
//cell.InnerText = row[((TemplateColumn)(MyDataGrid.Columns)).DataField].ToString();
break;
}
}
}
sItem = sItem + "</tr>/n";
return sItem;
}
#endregion
#region 添加打印网格数据的列标题
/// <summary>
/// 添加打印网格数据的列标题
/// </summary>
private string AddTableTitle()
{
string sTableTitle="<tr>/n";
for(int i = 0 ;i < MyDataGrid.Columns.Count ; i++)
{
if (MyDataGrid.Columns[i].Visible==true)
{
sTableTitle = sTableTitle + "<td class=/"print-coltitle/" width=/""+MyDataGrid.Columns[i].HeaderStyle.Width.Value.ToString()+"/"" ;
sTableTitle = sTableTitle + " height=/""+MyDataGrid.Columns[i].HeaderStyle.Height.Value.ToString()+"/"";
sTableTitle = sTableTitle + " > "+MyDataGrid.Columns[i].HeaderText.ToString()+"</td>";
}
}
sTableTitle = sTableTitle + "</tr>/n";
return sTableTitle;
}
#endregion
#region 添加页眉
/// <summary>
/// 添加打印网格数据的列标题
/// </summary>
private string AddShoulder()
{
string sShoulder = "";
int iLeftLength = (sShoulderLeft==null ? 0 : sShoulderLeft.Length);
int iCenterLength = (sShoulderCenter==null ? 0 : sShoulderCenter.Length);
int iRightLength = (sShoulderRight==null ? 0 : sShoulderRight.Length);
if(sShoulderLeft==null && sShoulderCenter==null && sShoulderRight==null)
{
//
}
else
{
sShoulder = sShoulder + "<table cellspacing=/"0/" cellpadding=/"0/" border=/"0/" width=/"100%/">/n";
sShoulder = sShoulder +"<tr>/n";
sShoulder = sShoulder +"<td valign=/"bottom/">/n";
sShoulder = sShoulder + "<table cellspacing=/"0/" cellpadding=/"0/" border=/"0/">/n";
for(int i=0 ; i < iLeftLength ; i++)
{
sShoulder = sShoulder + "<tr>/n";
sShoulder = sShoulder + "<td >"+( i < iLeftLength ? sShoulderLeft.ToString() : " ")+"</td>/n";
sShoulder = sShoulder + "</tr>/n";
}
sShoulder = sShoulder + "</table>/n";
sShoulder = sShoulder + "</td>/n";
if(sShoulderCenter!=null)
{
sShoulder = sShoulder +"<td valign=/"bottom/" align=/"left/">/n";
sShoulder = sShoulder + "<table cellspacing=/"0/" cellpadding=/"0/" border=/"0/">/n";
for(int i=0 ; i < iCenterLength ; i++)
{
sShoulder = sShoulder + "<tr>/n";
sShoulder = sShoulder + "<td >"+( i < iCenterLength ? sShoulderCenter.ToString() : " ")+"</td>/n";
sShoulder = sShoulder + "</tr>/n";
}
sShoulder = sShoulder + "</table>/n";
sShoulder = sShoulder + "</td>/n";
}
sShoulder = sShoulder +"<td valign=/"bottom/" align=/"right/">/n";
sShoulder = sShoulder + "<table cellspacing=/"0/" cellpadding=/"0/" border=/"0/" >/n";
for(int i=0 ; i < iRightLength ; i++)
{
sShoulder = sShoulder + "<tr>/n";
sShoulder = sShoulder + "<td >"+( i < iRightLength ? sShoulderRight.ToString() : " ")+"</td>/n";
sShoulder = sShoulder + "</tr>/n";
}
sShoulder = sShoulder + "</table>/n";
sShoulder = sShoulder + "</td>/n";
sShoulder = sShoulder + "</tr>/n";
sShoulder = sShoulder + "</table>/n";
}
return sShoulder;
}
#endregion
#region 添加页脚
/// <summary>
/// 添加打印网格数据的列标题
/// </summary>
private string AddFooter()
{
string sFooter = "";
int iLeftLength = (sFooterLeft==null ? 0 : sFooterLeft.Length);
int iCenterLength = (sFooterCenter==null ? 0 : sFooterCenter.Length);
int iRightLength = (sFooterRight==null ? 0 : sFooterRight.Length);
if(sFooterLeft==null && sFooterCenter==null && sFooterRight==null)
{
//
}
else
{
sFooter = sFooter + "<table cellspacing=/"0/" cellpadding=/"0/" border=/"0/" width=/"100%/">/n";
sFooter = sFooter +"<tr>/n";
sFooter = sFooter +"<td valign=/"top/">/n";
sFooter = sFooter + "<table cellspacing=/"0/" cellpadding=/"0/" border=/"0/">/n";
for(int i=0 ; i < iLeftLength ; i++)
{
sFooter = sFooter + "<tr>/n";
sFooter = sFooter + "<td >"+( i < iLeftLength ? sFooterLeft.ToString() : " ")+"</td>/n";
sFooter = sFooter + "</tr>/n";
}
sFooter = sFooter + "</table>/n";
sFooter = sFooter + "</td>/n";
if(sFooterCenter!=null)
{
sFooter = sFooter +"<td valign=/"top/" align=/"left/">/n";
sFooter = sFooter + "<table cellspacing=/"0/" cellpadding=/"0/" border=/"0/">/n";
for(int i=0 ; i < iCenterLength ; i++)
{
sFooter = sFooter + "<tr>/n";
sFooter = sFooter + "<td >"+( i < iCenterLength ? sFooterCenter.ToString() : " ")+"</td>/n";
sFooter = sFooter + "</tr>/n";
}
sFooter = sFooter + "</table>/n";
sFooter = sFooter + "</td>/n";
}
sFooter = sFooter +"<td valign=/"top/" align=/"right/">/n";
sFooter = sFooter + "<table cellspacing=/"0/" cellpadding=/"0/" border=/"0/" >/n";
for(int i=0 ; i < iRightLength ; i++)
{
sFooter = sFooter + "<tr>/n";
sFooter = sFooter + "<td >"+( i < iRightLength ? sFooterRight.ToString() : " ")+"</td>/n";
sFooter = sFooter + "</tr>/n";
}
sFooter = sFooter + "</table>/n";
sFooter = sFooter + "</td>/n";
sFooter = sFooter + "</tr>/n";
sFooter = sFooter + "</table>/n";
}
return sFooter;
}
#endregion
#region 添加页的标题
/// <summary>
/// 功能：添加页的标题
/// </summary>
private string AddPageTitle()
{
string sTitle="";
sTitle = sTitle + "/n<table border=/"0/" height=/"40/" width=/"100%/"><tr><td align=/"center/" class=/"print-title/" >"+sPageTitle+"</td></tr></table>/n";
return sTitle;
}
#endregion
#region 添加页的换页符，打印换页
/// <summary>
/// 功能：添加页的换页符
/// </summary>
private string AddPageBreak()
{
string sPageBreak="";
sPageBreak = sPageBreak + "/n<p style='page-break-before:always'>/n";
return sPageBreak;
}
#endregion
#region 重写模板文件，恢复打印模板样式
/// <summary>
/// 恢复打印模板
/// </summary>
public void ClearView()
{
StringBuilder htmltext=new StringBuilder();
try
{
if(!File.Exists(Server.MapPath(Context.Request.ApplicationPath) + "//printWindow.htm"))
{
FileStream fs = File.Create(Server.MapPath(Context.Request.ApplicationPath) + "//printWindow.htm");
fs.Close();
}
using (StreamWriter sw = new StreamWriter(Server.MapPath(Context.Request.ApplicationPath) + "//printWindow.htm"))
{
string sTableTitle="";
sTableTitle = sTableTitle + "<html>/n";
sTableTitle = sTableTitle + "<head>/n";
sTableTitle = sTableTitle + "<title></title>/n";
sTableTitle = sTableTitle + "<meta http-equiv=/"Content-Type/" content=/"text/html; charset=GB2312/">/n";
#region 模板页的样式
sTableTitle = sTableTitle + "<style type=/"text/css/">/n";
sTableTitle = sTableTitle + "<!--/n";
sTableTitle = sTableTitle + "body,table,tr,td,p{font-size:9pt;font-family:宋体;line-height:1.4}/n";
sTableTitle = sTableTitle + ".print-coltitle/n";
sTableTitle = sTableTitle + "{/n";
sTableTitle = sTableTitle + " border-right: black 1px solid;/n";
sTableTitle = sTableTitle + " border-top: black 0px solid;/n";
sTableTitle = sTableTitle + " border-left: black 0px solid;/n";
sTableTitle = sTableTitle + " border-bottom: black 2px solid;/n";
sTableTitle = sTableTitle + " white-space: normal;/n";
sTableTitle = sTableTitle + " background-color: #eeeeee;/n";
sTableTitle = sTableTitle + "}/n";
sTableTitle = sTableTitle + ".print-row/n";
sTableTitle = sTableTitle + "{/n";
sTableTitle = sTableTitle + " border-right: black 1px solid;/n";
sTableTitle = sTableTitle + " border-top: black 0px solid;/n";
sTableTitle = sTableTitle + " border-left: black 0px solid;/n";
sTableTitle = sTableTitle + " border-bottom: black 1px solid;/n";
sTableTitle = sTableTitle + " white-space:normal;/n";
sTableTitle = sTableTitle + " background-color: white;/n";
sTableTitle = sTableTitle + "}/n";
sTableTitle = sTableTitle + ".print-body/n";
sTableTitle = sTableTitle + "{/n";
sTableTitle = sTableTitle + " border-right: black 1px solid;/n";
sTableTitle = sTableTitle + " border-top: black 2px solid;/n";
sTableTitle = sTableTitle + " border-left: black 2px solid;/n";
sTableTitle = sTableTitle + " border-bottom: black 2px solid;/n";
sTableTitle = sTableTitle + " background-color: white;/n";
sTableTitle = sTableTitle + " white-space: normal;/n";
sTableTitle = sTableTitle + "}/n";
sTableTitle = sTableTitle + ".print-title{font-size:12pt;font-family:宋体;line-height:1.4}/n";
sTableTitle = sTableTitle + "-->/n";
sTableTitle = sTableTitle + "</style>/n";
#endregion
sTableTitle = sTableTitle +"<script language=/"javascript/">function maximizeWin() { if (window.screen) { var aw = screen.availWidth; var ah = screen.availHeight;window.moveTo(-4, -4); window.resizeTo(aw+9, ah+4); } } function TableAllRowSpan(TableName,ColumnIndex){var objTableName = TableName;var strTmp = /"/" ; var SpanCount = 1 ;var SpanStart = 1;var SpanOffSet = 0 ;var RowIndex = 0 ;for ( RowIndex = 1 ; RowIndex < objTableName.rows.length ; RowIndex++ ){ if (strTmp == objTableName.rows(RowIndex).cells(ColumnIndex).outerText) {SpanCount++;}else{strTmp = objTableName.rows(RowIndex).cells(ColumnIndex).outerText ;if ( RowIndex != 1 ){objTableName.rows(SpanStart).cells(ColumnIndex).rowSpan = SpanCount; for ( SpanOffSet = 1 ; SpanOffSet < SpanCount ; SpanOffSet++){objTableName.rows(SpanStart + SpanOffSet).cells(ColumnIndex).style.display = /"none/";}}SpanStart = RowIndex ; SpanCount = 1;}}if ( RowIndex != 1 ){objTableName.rows(SpanStart).cells(ColumnIndex).rowSpan = SpanCount;for ( SpanOffSet = 1 ; SpanOffSet < SpanCount ; SpanOffSet++ ){objTableName.rows(SpanStart + SpanOffSet).cells(ColumnIndex).style.display = /"none/";}}}";
sTableTitle = sTableTitle +"function TableSomeRowSpan (TableName, ColumnIndex ,bRow, eRow){ var objTableName = TableName;var strTmp = /"/" ; var SpanCount = 1 ;var SpanStart = 1 ;var SpanOffSet = 0 ;var RowIndex = 0 ;for ( RowIndex = bRow ; RowIndex < eRow ; RowIndex++ ){ if (strTmp == objTableName.rows(RowIndex).cells(ColumnIndex).outerText) {SpanCount++;} else{strTmp = objTableName.rows(RowIndex).cells(ColumnIndex).outerText ;if ( RowIndex != bRow ){objTableName.rows(SpanStart).cells(ColumnIndex).rowSpan = SpanCount;for ( SpanOffSet = 1 ; SpanOffSet < SpanCount ; SpanOffSet++){objTableName.rows(SpanStart + SpanOffSet).cells(ColumnIndex).style.display = /"none/";}}SpanStart = RowIndex ; SpanCount = 1;}}if ( RowIndex != bRow ){objTableName.rows(SpanStart).cells(ColumnIndex).rowSpan = SpanCount;for ( SpanOffSet = 1 ; SpanOffSet < SpanCount ; SpanOffSet++ ){objTableName.rows(SpanStart + SpanOffSet).cells(ColumnIndex).style.display = /"none/";}}}function TableRowSpan(TableName,ColumnIndex){var objTableName = document.all(TableName);var SpanCount = 1 ;var SpanStart = 1 ;var SpanOffSet = 0 ; var RowIndex = 0 ;var BColumnIndex =0;if(ColumnIndex==0){TableAllRowSpan(objTableName,ColumnIndex);} else{BColumnIndex = ColumnIndex - 1 ;for ( RowIndex = 1 ; RowIndex < objTableName.rows.length ; RowIndex++ ){SpanOffSet = objTableName.rows(RowIndex).cells(BColumnIndex).rowSpan;if(SpanOffSet > 1){SpanStart = RowIndex; SpanCount = SpanStart + SpanOffSet; TableSomeRowSpan (objTableName, ColumnIndex ,SpanStart, SpanCount); RowIndex = RowIndex + SpanOffSet-1;}}}} maximizeWin();</script>/n";
sTableTitle = sTableTitle + "</head>/n";
sTableTitle = sTableTitle + "<body>/n";
sTableTitle = sTableTitle + "Model/n";
sTableTitle = sTableTitle + "</body>/n";
sTableTitle = sTableTitle + "</html>/n";
sw.WriteLine(sTableTitle);
sw.Flush();
sw.Close();
}
}
catch(Exception ex)
{
throw ex;
//Response.Write("<Script>alert('读取文件错误')</Script>");
}
}
#endregion
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btnPrint.Click += new System.EventHandler(this.btnPrint_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
扫一扫
1276
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
