开发环境为2005,控件为datagrid
----------------index.aspx---------------------------
<%@ Page Language="C#" AutoEventWireup="true" EnableEventValidation="false" CodeFile="index.aspx.cs" Inherits="dealer_index" %>
<%@ Register Src="../inc/index_foot.ascx" TagName="index_foot" TagPrefix="uc4" %>
<%@ Register Src="../inc/invite_foot.ascx" TagName="invite_foot" TagPrefix="uc2" %>
<%@ Register Src="../inc/invite_top.ascx" TagName="invite_top" TagPrefix="uc1" %>
<!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 >
<title>医药代理-药品代理-医药代理信息-3721医药网</title>
<SCRIPT language="JavaScript">
function doPrint(){
var str="<html>";
var article;
var css;
var strAdBegin="<!--NEWSZW_HZH_BEGIN-->";
var strAdEnd="<!--NEWSZW_HZH_END-->";
var strFontSize='【<A href="javascript:doZoom(16)">大</A> _fcksavedurl=""javascript:doZoom(16)">大</A>" _fcksavedurl=""javascript:doZoom(16)">大</A>" <A href="javascript:doZoom(14)">中</A> <A href="javascript:doZoom(12)">小</A>】'
var strdoPrint="doPrint()";
var strTmp;
css="<style>"
+"body{font-family:宋体}"
+"td,.f14{font-size:14px}"
+".f24 {font-size:24px;}"
+".f12 {font-size:12px;}"
+".title14 {font-size:14px;line-height:130%}"
+".l17 {line-height:170%;}"
+"</style>";
str += css;
str += '<meta http-equiv="content-type" content="text/html; charset=gb2312">';
str += '<title>'+document.title+'</title>';
str += "<body topmargin=5 leftmargin=5 marginheight=5 marginwidth=5 onLoad='window.print()'>";
str += "<center>";
str += "<table width=600 border=0 cellpadding=0 cellspacing=20 bgcolor=#F7FBF7><tr><td>";
article=document.getElementById('article').innerHTML;
if(article.indexOf(strAdBegin)!=-1){
str +=article.substr(0,article.indexOf(strAdBegin));
strTmp=article.substr(article.indexOf(strAdEnd)+strAdEnd.length, article.length);
}else{
strTmp=article
}
str +=strTmp
str += "</td></tr></table></center>";
str += "</body></html>";
document.write(str);
document.close();
}
</SCRIPT>
<SCRIPT language="JavaScript">
function doZoom(size){
document.getElementById('table2').style.fontSize=size+'px'
}
</SCRIPT>
<meta http-equiv="Content-Language" content="zh-cn" />
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<meta name="generator" content="医药代理"/>
<meta name="keywords" content="医药代理,药品代理"/>
<meta name="description" content="医药代理版块主要是为医药行业的相关人士提供大量的医药代理和药品代理信息,让更多的人在第一时间就可以通过网络了解医药代理信息."/>
<meta name="robots" content="index, follow" />
<meta name="googlebot" content="index, follow" />
<link href="../style/dealer.css" rel="stylesheet" type="text/css"/>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
.stock_input1 {
font-size: 12px;
border: 1px solid #087D7B;
line-height: 12px;
padding-top: 3px;
background-color: #D6DF8C;
background-image: url(images/stock_pic_inputbj.gif);
}
-->
</style>
<link href="../../style/invite.css" rel="stylesheet" type="text/css" />
<link href="../../style/invite.css" rel="stylesheet" type="text/css" />
<link href="../../style/invite.css" rel="stylesheet" type="text/css" />
<link href="../../style/invite.css" rel="stylesheet" type="text/css" />
<link href="../../style/invite.css" rel="stylesheet" type="text/css" />
<link href="../../style/invite.css" rel="stylesheet" type="text/css" />
<link href="../../style/invite.css" rel="stylesheet" type="text/css" />
</head>
<body style="text-align:center">
<form id="form1" runat="server">
<asp:Panel runat=server ID=pnTop>
<!--------------------------------------------头文件--开始----------------------------------------------------------------->
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td colspan="5" rowspan="2" valign="bottom">
<uc1:invite_top ID="Invite_top1" runat="server" />
</td>
</tr>
</table>
<!--------------------------------------------头文件--结束----------------------------------------------------------------->
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td height="5"></td>
</tr>
<tr>
<td style="height: 25px"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td style="width: 769px; height: 24px" align="left">
当前位置┆<a href="http://www.yy3721.com/">首页</a>- 代理信息列表</td>
<td style="width: 9px; height: 24px">
<input class="stock_input1" name="Submit3" type="submit" value="--我要发布代理信息--" id="Submit1" onserverclick="Submit1_ServerClick" runat="server" /> </td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#00B6B5">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" background="../images/dealer_pic_sousuosbj.gif" bgcolor="#006963">
<tr>
<td width="10%" align="center" class="hong"><img src="../images/dealer_pic_sousuo.jpg" width="68" height="28" /></td>
<td height="28" align="center" class="hong" style="width: 10%">代理信息搜索:</td>
<td align="center" style="width: 19%">
<asp:TextBox ID="TextBox2" class="dealer_from" runat="server" Width="177px"></asp:TextBox></td>
<td style="width: 18%">
区域:
<asp:DropDownList ID="Supply_area" runat="server">
<asp:ListItem Value="">--选择区域--</asp:ListItem>
<asp:ListItem Value="北京">北京</asp:ListItem>
<asp:ListItem Value="辽宁">辽宁</asp:ListItem>
<asp:ListItem Value="广东">广东</asp:ListItem>
<asp:ListItem Value="浙江">浙江</asp:ListItem>
<asp:ListItem Value="江苏">江苏</asp:ListItem>
<asp:ListItem Value="山东">山东</asp:ListItem>
<asp:ListItem Value="四川">四川</asp:ListItem>
<asp:ListItem Value="黑龙江">黑龙江</asp:ListItem>
<asp:ListItem Value="湖南">湖南</asp:ListItem>
<asp:ListItem Value="湖北">湖北</asp:ListItem>
<asp:ListItem Value="上海">上海</asp:ListItem>
<asp:ListItem Value="福建">福建</asp:ListItem>
<asp:ListItem Value="陕西">陕西</asp:ListItem>
<asp:ListItem Value="河南">河南</asp:ListItem>
<asp:ListItem Value="安徽">安徽</asp:ListItem>
<asp:ListItem Value="重庆">重庆</asp:ListItem>
<asp:ListItem Value="河北">河北</asp:ListItem>
<asp:ListItem Value="吉林">吉林</asp:ListItem>
<asp:ListItem Value="江西">江西</asp:ListItem>
<asp:ListItem Value="天津">天津</asp:ListItem>
<asp:ListItem Value="广西">广西</asp:ListItem>
<asp:ListItem Value="山西">山西</asp:ListItem>
<asp:ListItem Value="内蒙古">内蒙古</asp:ListItem>
<asp:ListItem Value="甘肃">甘肃</asp:ListItem>
<asp:ListItem Value="贵州">贵州</asp:ListItem>
<asp:ListItem Value="新疆">新疆</asp:ListItem>
<asp:ListItem Value="云南">云南</asp:ListItem>
<asp:ListItem Value="宁夏">宁夏</asp:ListItem>
<asp:ListItem Value="海南">海南</asp:ListItem>
<asp:ListItem Value="青海">青海</asp:ListItem>
<asp:ListItem Value="西藏">西藏</asp:ListItem>
<asp:ListItem Value="香港">香港</asp:ListItem>
<asp:ListItem Value="澳门">澳门</asp:ListItem>
<asp:ListItem Value="海外">海外</asp:ListItem>
<asp:ListItem Value="其它">其它</asp:ListItem>
</asp:DropDownList>
</td>
<td style="width: 17%">
类别:
<asp:DropDownList ID="Supply_type2" runat="server">
<asp:ListItem Value="">--选择类型--</asp:ListItem>
<asp:ListItem Value="生物制剂">生物制剂</asp:ListItem>
<asp:ListItem Value="西药产品">西药产品</asp:ListItem>
<asp:ListItem Value="中药产品">中药产品</asp:ListItem>
<asp:ListItem Value="中药材">中药材</asp:ListItem>
<asp:ListItem Value="原料药">原料药</asp:ListItem>
<asp:ListItem Value="中间体">中间体</asp:ListItem>
<asp:ListItem Value="保健品">保健品</asp:ListItem>
<asp:ListItem Value="消毒剂">消毒剂</asp:ListItem>
<asp:ListItem Value="卫生用品">卫生用品</asp:ListItem>
<asp:ListItem Value="医疗器械">医疗器械</asp:ListItem>
<asp:ListItem Value="医疗设备">医疗设备</asp:ListItem>
<asp:ListItem Value="药用辅料">药用辅料</asp:ListItem>
<asp:ListItem Value="医用辅料">医用辅料</asp:ListItem>
<asp:ListItem Value="诊断试剂">诊断试剂</asp:ListItem>
<asp:ListItem Value="检验用品">检验用品</asp:ListItem>
<asp:ListItem Value="玻璃器皿">玻璃器皿</asp:ListItem>
<asp:ListItem Value="药品内色袋">药品内色袋</asp:ListItem>
<asp:ListItem Value="药品外色袋">药品外色袋</asp:ListItem>
<asp:ListItem Value="化学试剂">化学试剂</asp:ListItem>
<asp:ListItem Value="药品包装">药品包装</asp:ListItem>
</asp:DropDownList>
</td>
<td width="15%" align="center">
<asp:Button ID="Button1" class="dealer_input" runat="server" Text="搜索" OnClick="Button1_Click" CssClass="stock_input1" />
</td>
</tr>
</table>
<asp:HiddenField ID="hidden1" runat="server" />
<asp:HiddenField ID="hidden2" runat="server" />
<asp:HiddenField ID="hidden3" runat="server" />
</td>
</tr>
</table></td>
</tr>
</table>
<tr>
<td height="5"></td>
</tr>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td style="height: 93px"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="middle" background="../images/dealer_pic_sousuosbj2.gif" style="height: 62px"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="155" style="height: 65px"></td>
<td style="height: 65px"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#CEE7E7">
<tr>
<td width="39" height="24" align="center" bgcolor="#FFFFFF">
<a href="index_search.aspx?Supply_area=北京">北京</a></td>
<td width="39" align="center" bgcolor="#FFFFFF">
<a href="index_search.aspx?Supply_area=广东">广东</a></td>
<td width="39" align="center" bgcolor="#FFFFFF">
<a href="index_search.aspx?Supply_area=上海">上海</a></td>
<td width="39" align="center" bgcolor="#FFFFFF">
<a href="index_search.aspx?Supply_area=天津">天津</a></td>
<td width="39" align="center" bgcolor="#FFFFFF">
<a href="index_search.aspx?Supply_area=重庆">重庆</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=海南">海南</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=广西">广西</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=陕西" class="dealer_black">陕西</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=新疆" class="dealer_black">新疆</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=福建" class="dealer_black">福建</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=浙江" class="dealer_black">浙江</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=江苏" class="dealer_black">江苏</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=山东" class="dealer_black">山东</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=湖南" class="dealer_black">湖南</a></td>
<td width="39" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=湖北" class="dealer_black">湖北</a></td>
<td width="42" align="center" bgcolor="#FFFFFF" class="dealer_black"><a href="index_search.aspx?Supply_area=内蒙古" class="dealer_black">内蒙古</a></td>
<td width="42" rowspan="2" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx" class="dealer_black">所有代理信息</a></td>
</tr>
<tr>
<td height="24" align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=四川">四川</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=贵州">贵州</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=云南">云南</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=甘肃">甘肃</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=西藏">西藏</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=江西">江西</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=安徽">安徽</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=河南" class="dealer_black">河南</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=河北" class="dealer_black">河北</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=辽宁" class="dealer_black">辽宁</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=吉林" class="dealer_black">吉林</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=内蒙" class="dealer_black">内蒙</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=宁夏" class="dealer_black">宁夏</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=山西" class="dealer_black">山西</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=青海" class="dealer_black">青海</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="index_search.aspx?Supply_area=黑龙江" class="dealer_black">黑龙江</a></td>
</tr>
</table></td>
<td width="5" style="height: 65px"> </td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
<table id="table1" width="800" border="0" align="center" cellpadding="0" cellspacing="0" runat="server">
<tr>
<td height="2" bgcolor="#087D7B" style="width: 579px"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style=" width: 579px;">
<table border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#92C9C6" style="width: 800px">
<tr>
<td width="200" align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 24px">
代理药品名称</td>
<td width="200" align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 24px">代理区域</td>
<td width="150" align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 24px">代理类别</td>
<td width="150" align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 24px">姓名</td>
<td align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 24px; width: 200px;">发布日期</td>
<td align="left" bgcolor="92C9C6" class="dealer_black" style="height: 24px; width: 100px;">选择打印<asp:Button ID="btCheckAll" runat="server" CssClass="stock_input1" OnClick="btCheckAll_Click"
Text="全选" /></td>
</tr>
</table>
<asp:DataGrid ID="DataGrid1" runat="server" AutoGenerateColumns="False" HorizontalAlign="Center" AllowCustomPaging="True" PageSize="30" ShowHeader="False" CellPadding="2" Width="800px" >
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr >
<td width="200" height="25" align="left" class="dealer_black">
<a href='sanji.aspx?Supply_id=<%#DataBinder.Eval(Container.DataItem, "Supply_id")%>' target="_blank"><%#(DataBinder.Eval(Container.DataItem, "Supply_name").ToString().Length > 10)?DataBinder.Eval(Container.DataItem,"Supply_name").ToString().Substring(0,10):DataBinder.Eval(Container.DataItem,"Supply_name").ToString()%>
</a>
</td>
<td width="200" align="left" class="dealer_black"><%#DataBinder.Eval(Container.DataItem, "Supply_area")%></td>
<td width="150" align="left" class="dealer_black"><%#Member_all.substring_9(DataBinder.Eval(Container.DataItem, "Supply_type").ToString())%></td>
<td width="150" align="left" class="dealer_black"><%#DataBinder.Eval(Container.DataItem, "Supply_Linkman")%></td>
<td width="200" align="left" class="dealer_black">
<%#(DataBinder.Eval(Container.DataItem, "Supply_issuance").ToString().Length > 10) ? DataBinder.Eval(Container.DataItem, "Supply_issuance").ToString().Substring(0, 9) : DataBinder.Eval(Container.DataItem, "Supply_issuance").ToString()%>
</td>
<td align="center" class="dealer_black" style="width: 100px">
<asp:CheckBox ID="CheckBox1" runat="server" Text="选中此项" /></td>
<asp:Label ID="lbl" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Supply_id")%>' Visible="false"></asp:Label></tr>
</table>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
<AlternatingItemStyle BackColor="#F7FBF7" Font-Bold="False" Font-Italic="False" Font-Overline="False"
Font-Strikeout="False" Font-Underline="False" />
<ItemStyle BackColor="#E7F3FF" Font-Bold="False" Font-Italic="False" Font-Overline="False"
Font-Strikeout="False" Font-Underline="False" />
<PagerStyle Visible="False" />
</asp:DataGrid>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="width: 579px"><table width="800" border="0" align="center" cellpadding="0" cellspacing="0" class="dealer_button" style="height: 5px">
<tr>
<td height="28" align="center" bgcolor="#94CBC6" style="width: 665px">共找到<asp:Label ID="lblcount" runat="server" Text="Label"></asp:Label>项记录
<asp:LinkButton ID="hlfirst" runat="server" OnClick="LinkButton1_Click">首页</asp:LinkButton>
<asp:LinkButton ID="hlprev" runat="server" OnClick="LinkButton2_Click">上一页</asp:LinkButton>
<asp:LinkButton ID="hlnext" runat="server" OnClick="LinkButton3_Click">下一页</asp:LinkButton>
<asp:LinkButton ID="hllastpage" runat="server" OnClick="LinkButton4_Click">尾页</asp:LinkButton>
第
<asp:Label ID="lblcurrent" runat="server" Text="Label"></asp:Label> 页 转到: <asp:DropDownList
ID="DropDownList1" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" AutoPostBack="True">
</asp:DropDownList>
<%-- <asp:TextBox class="dealer_from" style="TEXT-ALIGN: center" maxlength="5" ID="TextBox1" runat="server" Width="40px"></asp:TextBox>--%>
</td>
<td align="left" bgcolor="#94CBC6" style="height: 45px">
<%-- <asp:Button ID="Button2" class="dealer_input" alt="页面跳转" runat="server" Text="-G O-" OnClick="Button2_Click" CssClass="stock_input1" />--%>
<asp:Button ID="Button3" class="dealer_input" runat="server" Text="打印预览" OnClick="Button3_Click" CssClass="stock_input1" /></td>
</tr>
</table></td>
</tr>
</table>
</asp:Panel>
<DIV id="article" >
<table width="800" id="table2" border="0" align="center" cellpadding="0" cellspacing="0" runat="server">
<tr>
<td bgcolor="#087D7B" style="width: 802px; height: 1px;"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#92C9C6">
<tr>
<td width="200" align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 25px">
代理药品名称</td>
<td width="200" align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 25px">
代理区域</td>
<td align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 25px; width: 150px;">
代理类别</td>
<td width="150" align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 25px">
姓名</td>
<td width="200" align="left" bgcolor="#92C9C6" class="dealer_black" style="height: 25px">
联系方式</td>
<td width="100" align="left" bgcolor="92C9C6" class="dealer_black" style="height: 25px">
发布日期</td>
</tr>
</table>
<asp:DataGrid ID="DataGrid2" runat="server" AutoGenerateColumns="False" HorizontalAlign="Center" AllowCustomPaging="True" PageSize="30" ShowHeader="False" CellPadding="2" >
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr >
<td width="200" height="25" align="left" class="dealer_black">
<a href='sanji.aspx?Supply_id=<%#DataBinder.Eval(Container.DataItem, "Supply_id")%>' target="_blank">
<%#(DataBinder.Eval(Container.DataItem, "Supply_name").ToString().Length > 10)?DataBinder.Eval(Container.DataItem,"Supply_name").ToString().Substring(0,10):DataBinder.Eval(Container.DataItem,"Supply_name").ToString()%>
</a>
</td>
<td width="200" align="left" class="dealer_black">
<%#DataBinder.Eval(Container.DataItem, "Supply_area")%>
</td>
<td width="150" align="left" class="dealer_black">
<%#Member_all.substring_9(DataBinder.Eval(Container.DataItem, "Supply_type").ToString())%>
</td>
<td width="150" align="left" class="dealer_black">
<%#DataBinder.Eval(Container.DataItem, "Supply_Linkman")%>
</td>
<td width="200" align="left" class="dealer_black">
手机: <%#DataBinder.Eval(Container.DataItem, "Supply_mobiletel")%> <br>
电话: <%#DataBinder.Eval(Container.DataItem, "Supply_phone")%>
</td>
<td align="center" class="dealer_black" style="width: 100px">
<%#(DataBinder.Eval(Container.DataItem, "Supply_issuance").ToString().Length > 10) ? DataBinder.Eval(Container.DataItem, "Supply_issuance").ToString().Substring(0, 9) : DataBinder.Eval(Container.DataItem, "Supply_issuance").ToString()%></td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
<AlternatingItemStyle BackColor="#F7FBF7" Font-Bold="False" Font-Italic="False" Font-Overline="False"
Font-Strikeout="False" Font-Underline="False" />
<ItemStyle BackColor="#E7F3FF" Font-Bold="False" Font-Italic="False" Font-Overline="False"
Font-Strikeout="False" Font-Underline="False" />
<PagerStyle Visible="False" />
</asp:DataGrid>
</td>
</tr>
</table>
</DIV>
<table id=tb2 width="800" border="0" align="center" cellpadding="0" cellspacing="0" runat=server> <tr>
<td align="right" style="height: 20px" bgcolor="#92C9C6">
<span style="color: #006d6b"></span><span style="color: #006d6b"></span><input id="btPrint" type="button" onclick="doPrint()" class="stock_input1" value="开始打印" style="width: 58px" />
<asp:Button ID="Button4" runat="server" CssClass="stock_input1"
Text="返回" OnClick="Button4_Click" /> </td>
</tr></table>
<asp:Panel runat=server ID=pnEof>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="200" valign="top" style="height: 293px"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#92C9C6">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="23" bgcolor="#D6EBEF"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="13%" align="center"><img src="../images/dealer_pic_daili.gif" width="11" height="11" /></td>
<td width="68%" class="dealer_black">医药资讯</td>
<td width="19%"><a href="../news/news_more.aspx" class="dealer_black"><img border=none src="../images/dealer_menu_more.gif" width="42" height="16" /></a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="2"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="200" bgcolor="#FFFFFF" align="center" valign="top">
<asp:Repeater ID="rpt_yyzx" runat="server"><FooterTemplate>
</table>
</FooterTemplate>
<HeaderTemplate>
<table width="100%">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td align="left">
· <a href ='../news/news_show.aspx?news_id=<%#DataBinder.Eval(Container.DataItem,"news_id") %>' target="_blank">
<%#DataBinder.Eval(Container.DataItem, "news_title")%>
</a>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>
</td>
</tr>
</table></td>
</tr>
</table>
</td>
<td width="5" style="height: 293px"> </td>
<td style="height: 293px" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" align="center" background="../images/dealer_pic_sousuosbj.gif"><img src="../images/dealer_pic_zs.jpg" width="140" height="25" /></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#92C9C6">
<tr>
<td bgcolor="#ffffff" colspan="3" rowspan="8" align="center">
<asp:DataList ID="DataList1" runat="server" RepeatColumns="3">
<ItemTemplate>
<table width="100%" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#92C9C6">
<tr>
<td height="24" align="left" width="300" bgcolor="#E7F3FF">
<a href='../invite/sanji.aspx?id=<%# DataBinder.Eval(Container.DataItem,"business_id") %>'>
<%# DataBinder.Eval(Container.DataItem,"business_name").ToString().Length>12?DataBinder.Eval(Container.DataItem,"business_name").ToString().Substring(0,12):DataBinder.Eval(Container.DataItem,"business_name") %></a>
<img src="../images/invite_pic_new.gif" width="28" height="11" />
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList></td>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table id="eofTable" width="800" border="0" align="center" cellpadding="0" cellspacing="0" runat="server">
<tr>
<td>
<uc4:index_foot ID="Index_foot1" runat="server" />
</td>
</tr>
</table>
</asp:Panel>
</form>
</body>
</html>
------------------------index.aspx.cs------------------------------
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 System.Data.SqlClient;
public partial class dealer_index : System.Web.UI.Page
{
private static int intRecordCount; //记录总数
private static int intPageCount; //总页数
private static int intCurrentPageIndex; //当前页码
private DataView dv;
public string del_strsql, Rq_area, text, ddiyu, dleibie, str_sqlzx, dltype;
private int s_id1;
// private String _txt_name, _txt_sort, _txt_Supply_type;
//public int iCurrentPage = 1, iPageCount = 1, iPageSize = 30, iRecordSet = 0;
public string s_name=String.Empty, s_prev=String.Empty, s_sort="";
private int pagesize = 25;
private static int cpage;
private static int TotalPages;
private static int Last_Page;
protected void Page_Load(object sender, EventArgs e)
{
table2.Visible = false;
table1.Visible = true;
tb2.Visible = false;
pnTop.Visible = true;
pnEof.Visible = true;
if (!Page.IsPostBack)
{
Databind_first();
}
#region 招商,医药资讯
// 最新代理
SqlConnection zx_con = new SqlConnection(ConfigurationSettings.AppSettings["Str_sql"]);
zx_con.Open();
str_sqlzx = "select top 30 business_id,business_name from business order by Business_issuance desc";
DataSet ds1 = new DataSet();
SqlDataAdapter zx_sda = new SqlDataAdapter(str_sqlzx, zx_con);
zx_sda.Fill(ds1, "zxdaili");
DataList1.DataSource = ds1.Tables["zxdaili"];
DataList1.DataBind();
zx_sda.Dispose();
//医药咨询 rpt_yyzx
str_sqlzx = "select top 14 news_Id,left(News_Title,13) as news_title,Convert(varchar(10),[time],120) as [time] from admin_News where News_Type=6 order by News_Id desc";
SqlDataAdapter sda_yyzx = new SqlDataAdapter(str_sqlzx, zx_con);
sda_yyzx.Fill(ds1, "yyzx");
rpt_yyzx.DataSource = ds1.Tables["yyzx"];
rpt_yyzx.DataBind();
sda_yyzx.Dispose();
ds1.Dispose();
zx_con.Close();
zx_con.Dispose();
#endregion
}
private void Databind_first()
{
Pager pg = new Pager();
s_name = hidden1.Value;
s_sort = hidden2.Value;
s_prev = hidden3.Value;
int s_cpage = 1;
ViewState["cpage"] = 1;
int Counts=0;
if(s_name!=""||s_sort!=""||s_prev!="")
{
Counts = pg.GetCounts("Supply_id", "Supply", s_name, s_prev, s_sort);
}
else
{
Counts = pg.GetCounts("Supply_id", "Supply", "", "", "");
}
lblcount.Text = Counts.ToString();//得到总记录
TotalPages = Counts / pagesize;
Last_Page = TotalPages;
if (Counts < pagesize)
TotalPages = 1;
else
{
if (Counts % pagesize != 0) TotalPages++;
}//计算总页数
//lblcurrent.Text = cpage.ToString() + "/" + TotalPages;
lblcurrent.Text = ViewState["cpage"] + "/" + TotalPages;
DataSet ds = new DataSet();
if (s_name != "" || s_sort != "" || s_prev != "")
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", s_name, s_prev, s_sort, "Supply_id", "Supply", 1, pagesize, Convert.ToInt32(ViewState["cpage"]));
}
else
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "", "", "Supply_id", "Supply", 1, pagesize, Convert.ToInt32(ViewState["cpage"]));
}
bind(ds);
Gethl();
Getddlist();
}
#region 用于drodownlist页的跳转
private void Getddlist()
{
if(TotalPages!=1)
{
for(int i=1;i<=TotalPages;i++)
{
DropDownList1.Items.Add(new ListItem(i.ToString(),i.ToString()));
}
}
else
{
DropDownList1.Items.Add(new ListItem("1","1"));
}
}
#endregion
#region 用于上下页的状态显示
private void Gethl()//得到上页,下页状态
{
if(lblcurrent.Text=="1")
{
hlprev.Enabled=false;
hlnext.Enabled=false;
}
else
{
if(Convert.ToInt32(ViewState["cpage"])==1)
{
hlprev.Enabled=false;
hlfirst.Enabled=false;
}
else
{
hlprev.Enabled=true;
hlfirst.Enabled = true;
}
if (Convert.ToInt32(ViewState["cpage"]) == Convert.ToInt32(TotalPages))
{
hlnext.Enabled = false;
hllastpage.Enabled = false;
}
else
{
hlnext.Enabled = true;
hllastpage.Enabled = true;
}
}
lblcurrent.Text=Convert.ToInt32(ViewState["cpage"]).ToString()+"/"+TotalPages;
}
#endregion
#region 用于分页的绑定
private void bind(DataSet ds)
{
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
}
#endregion
#region 用于首页的显示
protected void LinkButton1_Click(object sender, EventArgs e)
{
ViewState["cpage"] = 1;
Pager pg = new Pager();
DataSet ds = new DataSet();
// ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "Supply_id", "supply", 1, 30, cpage);
s_name = hidden1.Value;
s_sort = hidden2.Value;
s_prev = hidden3.Value;
if (s_name != "" || s_sort != "" || s_prev != "")
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", s_name, s_prev, s_sort, "Supply_id", "Supply", 1, pagesize, Convert.ToInt32(ViewState["cpage"]));
}
else
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "", "", "Supply_id", "Supply", 1, pagesize, Convert.ToInt32(ViewState["cpage"]));
}
bind(ds);
Gethl();
DropDownList1.ClearSelection();
DropDownList1.Items.FindByValue(Convert.ToInt32(ViewState["cpage"]).ToString()).Selected = true;
}
#endregion
#region 用于尾页的显示
protected void LinkButton4_Click(object sender, EventArgs e)
{
ViewState["cpage"] = Last_Page + 1;
Pager pg = new Pager();
DataSet ds = new DataSet();
//ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "Supply_id", "supply", cpage, 30, cpage);
s_name = hidden1.Value;
s_sort = hidden2.Value;
s_prev = hidden3.Value;
if (s_name != "" || s_sort != "" || s_prev != "")
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", s_name, s_prev, s_sort, "Supply_id", "supply", Convert.ToInt32(ViewState["cpage"]), pagesize, Convert.ToInt32(ViewState["cpage"]));
}
else
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "", "", "Supply_id", "supply", Convert.ToInt32(ViewState["cpage"]), pagesize, Convert.ToInt32(ViewState["cpage"]));
}
bind(ds);
Gethl();
DropDownList1.ClearSelection();
DropDownList1.Items.FindByValue(Convert.ToInt32(ViewState["cpage"]).ToString()).Selected = true;
}
#endregion
#region 用于上一页的显示
protected void LinkButton2_Click(object sender, EventArgs e)
{
ViewState["cpage"] = Convert.ToInt32(ViewState["cpage"]) - 1;
Pager pg = new Pager();
DataSet ds=new DataSet();
//ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "Supply_id", "supply", cpage, 30, cpage);
s_name = hidden1.Value;
s_sort = hidden2.Value;
s_prev = hidden3.Value;
if (s_name != "" || s_sort != "" || s_prev != "")
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", s_name, s_sort, s_prev, "Supply_id", "supply", Convert.ToInt32(ViewState["cpage"]), pagesize, Convert.ToInt32(ViewState["cpage"]));
}
else
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "", "", "Supply_id", "supply", Convert.ToInt32(ViewState["cpage"]), pagesize, Convert.ToInt32(ViewState["cpage"]));
}
bind(ds);
Gethl();
DropDownList1.ClearSelection();
DropDownList1.Items.FindByValue(Convert.ToString(ViewState["cpage"])).Selected = true;
}
#endregion
#region 用于下一页的显示
protected void LinkButton3_Click(object sender, EventArgs e)
{
ViewState["cpage"] = Convert.ToInt32(ViewState["cpage"]) + 1;
Pager pg=new Pager();
DataSet ds=new DataSet();
s_name = hidden1.Value;
s_sort = hidden2.Value;
s_prev = hidden3.Value;
// ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "Supply_id", "supply", cpage, 30, cpage);
if (s_name != "" || s_sort != "" || s_prev != "")
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", s_name, s_prev, s_sort, "Supply_id", "supply", Convert.ToInt32(ViewState["cpage"]), pagesize, Convert.ToInt32(ViewState["cpage"]));
}
else
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "", "", "Supply_id", "supply", Convert.ToInt32(ViewState["cpage"]), pagesize, Convert.ToInt32(ViewState["cpage"]));
}
bind(ds);
Gethl();
DropDownList1.ClearSelection();
DropDownList1.Items.FindByValue(Convert.ToString(ViewState["cpage"])).Selected = true;
}
#endregion
#region Dropdownlist的转向分页
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
ViewState["cpage"]= Convert.ToInt32(DropDownList1.SelectedValue);
Pager pg=new Pager();
DataSet ds=new DataSet();
//ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "Supply_id", "supply", cpage, 30, cpage);
if (s_name != "" || s_sort != "" || s_prev != "")
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", s_name, s_sort, s_prev, "Supply_id", "supply", Convert.ToInt32(ViewState["cpage"]), pagesize, Convert.ToInt32(ViewState["cpage"]));
}
else
{
ds = pg.GetCurrentDataSet("Supply_id,Supply_name,Supply_area,Supply_type,Supply_Linkman,Supply_issuance", "", "", "", "Supply_id", "supply", Convert.ToInt32(ViewState["cpage"]), pagesize, Convert.ToInt32(ViewState["cpage"]));
}
bind(ds);
Gethl();
}
#endregion
//分页
#region
#endregion
#region 搜索
protected void Button1_Click(object sender, EventArgs e)
{
hidden1.Value = SqlZhuru.SQLzhuru(TextBox2.Text.ToString());
hidden2.Value = Supply_area.Text.ToString();
hidden3.Value = Supply_type2.Text.ToString();
Databind_first();
}
#endregion
protected void Submit1_ServerClick(object sender, EventArgs e)
{
Response.Redirect("../member_page/user/mdealer/mdealer_issue.aspx");
}
protected void preview(string s_sql,DataGrid gr)
{
SqlConnection mycon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["Str_sql"].ToString());
mycon.Open();
SqlDataAdapter pter = new SqlDataAdapter(s_sql, mycon);
DataSet ds = new DataSet();
pter.Fill(ds,"tablename");
gr.DataSource = ds.Tables["tablename"];
gr.DataBind();
ds.Dispose();
mycon.Close();
}
private void DelteList(int id)
{
SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["Str_sql"]);
SqlCommand cmd = new SqlCommand("select * from business where business_id=@id", con);
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@id"].Value = id;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
protected void Button4_Click(object sender, EventArgs e)
{
}
protected void Button3_Click(object sender, EventArgs e)
{
if (Session["user"] == null || Session["user"] == String.Empty)
{
//SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["Str_sql"]);
//con.Open();
//string s_id = "select max(Supply_id) from supply";
//SqlCommand cmd = new SqlCommand(s_id, con);
//s_id1 = Convert.ToInt32(cmd.ExecuteScalar());
//con.Close();
//Jscript.AlertAndRedirect("您还没有登陆", "sanji.aspx?Supply_id=" + s_id1 + "");
Jsp.OpenNewWindow("http://www.yy3721.com/dealer/dear_login.aspx", 600, 200);
return;
}
int checkCount = 0;
int rows_count = DataGrid1.Items.Count;
string s_sql = "select * from supply where supply_id=";
for (int i = 0; i < rows_count; i++)
{
System.Web.UI.WebControls.CheckBox box = (System.Web.UI.WebControls.CheckBox)DataGrid1.Items[i].FindControl("CheckBox1");
if (box != null && box.Checked)
{
checkCount++;
System.Web.UI.WebControls.Label lb = (System.Web.UI.WebControls.Label)DataGrid1.Items[i].FindControl("lbl");
if (lb != null)
{
s_sql = s_sql + Convert.ToInt32(lb.Text.Trim()) + " or supply_id=";
}
}
}
if (checkCount != 0)
{
s_sql = s_sql.Substring(0, s_sql.Length - 13);
preview(s_sql, DataGrid2);
table1.Visible = false;
table2.Visible = true;
tb2.Visible = true;
pnTop.Visible = false;
pnEof.Visible = false;
}
else
{
Jsp.Alert("请选择要选种的类别");
}
}
protected void btCheckAll_Click(object sender, EventArgs e)
{
if (Session["user"] == null || Session["user"] == String.Empty)
{
Jsp.OpenNewWindow("http://www.yy3721.com/dealer/dear_login.aspx", 600, 200);
return;
}
int count = DataGrid1.Items.Count;
for (int i = 0; i < count; i++)
{
System.Web.UI.WebControls.CheckBox cb = (System.Web.UI.WebControls.CheckBox)DataGrid1.Items[i].FindControl("CheckBox1");
cb.Checked = true;
}
}
//protected void LinkButton1_Click(object sender, EventArgs e)
//{
// intCurrentPageIndex = 1; //重新绑定数据
// this.Bind(intCurrentPageIndex);
//}
//protected void LinkButton2_Click(object sender, EventArgs e)
//{
// intCurrentPageIndex = intCurrentPageIndex - 1;
// if (intCurrentPageIndex <= 0)
// {
// intCurrentPageIndex = 1;
// }
// //重新绑定数据
// this.Bind(intCurrentPageIndex);
//}
//protected void LinkButton3_Click(object sender, EventArgs e)
//{
// intCurrentPageIndex = intCurrentPageIndex + 1;
// if (intCurrentPageIndex > intPageCount)
// {
// intCurrentPageIndex = intPageCount;
// }
// //重新绑定数据
// this.Bind(intCurrentPageIndex);
//}
//protected void LinkButton4_Click(object sender, EventArgs e)
//{
// intCurrentPageIndex = intPageCount;
// //重新绑定数据
// this.Bind(intCurrentPageIndex);
//}
protected void DataGrid2_SelectedIndexChanged(object sender, EventArgs e)
{
}
}