调拨代码汇总
一、合并单元格
private DataTable CreateDataTable()
{
DataTable dt = new DataTable();
dt.Columns.Add("Year");
dt.Columns.Add("Term");
dt.Columns.Add("Course");
dt.Columns.Add("Teacher");
dt.Columns.Add("Score");
dt.Columns.Add("Remark");
dt.Rows.Add("2010年", "第一学期", "语文", "张三", "75", "及格");
dt.Rows.Add("2010年", "第一学期", "数学", "李四", "85", "良好");
dt.Rows.Add("2010年", "第二学期", "语文", "李四", "75", "及格");
dt.Rows.Add("2010年", "第二学期", "数学", "李四", "95", "优秀");
dt.Rows.Add("2010年", "第二学期", "政治", "李四", "57", "不及格");
return dt;
}
private void BindGrid()
{
grdScore.DataSource = CreateDataTable();
grdScore.DataBind();
GroupGridView(grdScore, new int[] { 0, 1, 3 });
}
private void GroupGridView(GridView gv, int[] rowCounts)
{
string strContent;
int i;
int count;
int rowSpanCount;
foreach (int rowCount in rowCounts)
{
strContent = string.Empty;
i = 0;
count = 0;
rowSpanCount = 2;
foreach (GridViewRow row in gv.Rows)
{
if (strContent == row.Cells[rowCount].Text)
{
gv.Rows[count - 1].Cells[rowCount].RowSpan = rowSpanCount++;
gv.Rows[i].Cells[rowCount].Visible = false;
}
else
{
rowSpanCount = 2;
count = i + 1;
}
strContent = row.Cells[rowCount].Text;
i++;
}
}
}
{
DataTable dt = new DataTable();
dt.Columns.Add("Year");
dt.Columns.Add("Term");
dt.Columns.Add("Course");
dt.Columns.Add("Teacher");
dt.Columns.Add("Score");
dt.Columns.Add("Remark");
dt.Rows.Add("2010年", "第一学期", "语文", "张三", "75", "及格");
dt.Rows.Add("2010年", "第一学期", "数学", "李四", "85", "良好");
dt.Rows.Add("2010年", "第二学期", "语文", "李四", "75", "及格");
dt.Rows.Add("2010年", "第二学期", "数学", "李四", "95", "优秀");
dt.Rows.Add("2010年", "第二学期", "政治", "李四", "57", "不及格");
return dt;
}
private void BindGrid()
{
grdScore.DataSource = CreateDataTable();
grdScore.DataBind();
GroupGridView(grdScore, new int[] { 0, 1, 3 });
}
private void GroupGridView(GridView gv, int[] rowCounts)
{
string strContent;
int i;
int count;
int rowSpanCount;
foreach (int rowCount in rowCounts)
{
strContent = string.Empty;
i = 0;
count = 0;
rowSpanCount = 2;
foreach (GridViewRow row in gv.Rows)
{
if (strContent == row.Cells[rowCount].Text)
{
gv.Rows[count - 1].Cells[rowCount].RowSpan = rowSpanCount++;
gv.Rows[i].Cells[rowCount].Visible = false;
}
else
{
rowSpanCount = 2;
count = i + 1;
}
strContent = row.Cells[rowCount].Text;
i++;
}
}
}
二、页面打印
window.print(); //简单又好用
三、Gridview中链接直接弹出页面
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
CellPadding="4" Width="616px">
<RowStyle BackColor="White" ForeColor="#003399" />
<Columns>
<asp:TemplateField HeaderText="编号">
<ItemTemplate>
<asp:HyperLink ID="HyperLink1" onclick="javascript: window.open('Default.aspx?Id='+this.innerText+'')" style="text-decoration: underline;cursor:hand" runat="server"><%# Eval("Code") %></asp:HyperLink>
<%-- <asp:HyperLink ID="HyperLink1" onclick="bindData(this.innerText)" style="text-decoration: underline;cursor:hand" runat="server"><%# Eval("Code") %></asp:HyperLink>--%>
<%-- <a onclick="bindData(this.innerText)" style="text-decoration: underline;cursor:hand"><%# Eval("Code") %></a>--%>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Name" HeaderText="名称" />
<asp:BoundField DataField="Store" HeaderText="所属仓库" />
<asp:BoundField DataField="StoreInfo" HeaderText="仓管信息" />
<asp:BoundField DataField="Number" HeaderText="商品数" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
</asp:GridView>
BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
CellPadding="4" Width="616px">
<RowStyle BackColor="White" ForeColor="#003399" />
<Columns>
<asp:TemplateField HeaderText="编号">
<ItemTemplate>
<asp:HyperLink ID="HyperLink1" onclick="javascript: window.open('Default.aspx?Id='+this.innerText+'')" style="text-decoration: underline;cursor:hand" runat="server"><%# Eval("Code") %></asp:HyperLink>
<%-- <asp:HyperLink ID="HyperLink1" onclick="bindData(this.innerText)" style="text-decoration: underline;cursor:hand" runat="server"><%# Eval("Code") %></asp:HyperLink>--%>
<%-- <a onclick="bindData(this.innerText)" style="text-decoration: underline;cursor:hand"><%# Eval("Code") %></a>--%>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Name" HeaderText="名称" />
<asp:BoundField DataField="Store" HeaderText="所属仓库" />
<asp:BoundField DataField="StoreInfo" HeaderText="仓管信息" />
<asp:BoundField DataField="Number" HeaderText="商品数" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
</asp:GridView>
下面的代码是在上边的基础上添加了对IE的控制的
<asp:HyperLink ID="HyperLink1" onclick="javascript: window.open('Default.aspx?Id='+this.innerText+'','查看','top=150,left=50,toolbar=no, menubar=no,scrollbars=yes, resizable=no, location=no, status=no, width=850,height=400');" style="text-decoration: underline;cursor:hand" runat="server"><%# Eval("Code") %></asp:HyperLink>