下面程序中如何将 dep_user,j(序号)传递到filename页面中去public string[] 分页(string dep_user, string page1, int zt, string filename)
{
int i,j=1;
int page;
int pagesize = 30;
if (page1 != null && page1 != "") { page = Convert.ToInt32(page1); } else { page = 1; }
if (page == 0) { page = 1; };
string[] temp = new string[2];
conn.SelectCommand = "select count(*) as dd from sb_all where dep_user = '" + dep_user + "'and zt= '" + zt + "';";
SqlDataReader read = (SqlDataReader)conn.Select(DataSourceSelectArguments.Empty);
read.Read();
int num = Convert.ToInt32(read["dd"].ToString());
string first;
if (page > 1) { first = "<A href=\"" + filename + "?page=1\">首页</A> <A href=\"" + filename + "?page=" + (page - 1) + "\">上一页</A>"; }
else { first = "首页 上一页"; };
int maxp;
if (num != 0 && num != 1)
{
if (pagesize % num == 0) { maxp = num / pagesize; } else { maxp = Convert.ToInt32(Math.Floor(num / pagesize + 0.0) + 1); }
}
else { maxp = 1; }
string npage;
if (page < maxp) { npage = "<a href=\"" + filename + "?page=" + (page + 1) + "\">下一页</a> <a href=\"" + filename + "?page=" + maxp + "\">尾页</a>"; }
else { npage = "下一页 尾页"; }
temp[1] = "共" + maxp + "页 " + num + "条信息 " + first + " 【" + page + "】 " + npage;
temp[1] = temp[1] + " 到 <select name=\"select\" onchange=\"javascript:window.location.href=this.options[this.selectedIndex].value\" >";
for (i = 1; i <= maxp; i++)
{
temp[1] = temp[1] + "<option value=" + filename + "?page=" + i;
if (i == page) { temp[1] = temp[1] + " selected "; };
temp[1] = temp[1] + ">" + i + "</option>";
};
temp[1] = " <tr><td colspan='17'>" + temp[1] + "</select> 页"+" </td></tr>";
read.Close();
if (page == maxp) { conn.SelectCommand = "select * from sb_all where id in ( select top " + (num - pagesize * (page - 1)) + " id from sb_all where id in ( SELECT TOP " + page * pagesize + " id from sb_all where dep_user = '" + dep_user + "'and zt= '" + zt + "' order by pipe_num DESC ) order by pipe_num ASC ) order by pipe_num DESC;"; }
else
{
conn.SelectCommand = "select * from sb_all where id in ( select top " + pagesize + " id from sb_all where id in ( SELECT TOP " + page * pagesize + " id from sb_all where dep_user = '" + dep_user + "'and zt= '" + zt + "' order by pipe_num DESC ) order by pipe_num ASC ) order by pipe_num DESC;";
}
read = (SqlDataReader)conn.Select(DataSourceSelectArguments.Empty);
while (read.Read())
{ temp[0] = temp[0] + " <tr><td>" + j + "</td><td>" + read["water_dah"].ToString() + "</td><td>" + read["user_addr"].ToString() + "</td><td>" + read["sb_kj"].ToString() + "</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>";
j = j + 1;
} read.Close();
return temp;
}
{
int i,j=1;
int page;
int pagesize = 30;
if (page1 != null && page1 != "") { page = Convert.ToInt32(page1); } else { page = 1; }
if (page == 0) { page = 1; };
string[] temp = new string[2];
conn.SelectCommand = "select count(*) as dd from sb_all where dep_user = '" + dep_user + "'and zt= '" + zt + "';";
SqlDataReader read = (SqlDataReader)conn.Select(DataSourceSelectArguments.Empty);
read.Read();
int num = Convert.ToInt32(read["dd"].ToString());
string first;
if (page > 1) { first = "<A href=\"" + filename + "?page=1\">首页</A> <A href=\"" + filename + "?page=" + (page - 1) + "\">上一页</A>"; }
else { first = "首页 上一页"; };
int maxp;
if (num != 0 && num != 1)
{
if (pagesize % num == 0) { maxp = num / pagesize; } else { maxp = Convert.ToInt32(Math.Floor(num / pagesize + 0.0) + 1); }
}
else { maxp = 1; }
string npage;
if (page < maxp) { npage = "<a href=\"" + filename + "?page=" + (page + 1) + "\">下一页</a> <a href=\"" + filename + "?page=" + maxp + "\">尾页</a>"; }
else { npage = "下一页 尾页"; }
temp[1] = "共" + maxp + "页 " + num + "条信息 " + first + " 【" + page + "】 " + npage;
temp[1] = temp[1] + " 到 <select name=\"select\" onchange=\"javascript:window.location.href=this.options[this.selectedIndex].value\" >";
for (i = 1; i <= maxp; i++)
{
temp[1] = temp[1] + "<option value=" + filename + "?page=" + i;
if (i == page) { temp[1] = temp[1] + " selected "; };
temp[1] = temp[1] + ">" + i + "</option>";
};
temp[1] = " <tr><td colspan='17'>" + temp[1] + "</select> 页"+" </td></tr>";
read.Close();
if (page == maxp) { conn.SelectCommand = "select * from sb_all where id in ( select top " + (num - pagesize * (page - 1)) + " id from sb_all where id in ( SELECT TOP " + page * pagesize + " id from sb_all where dep_user = '" + dep_user + "'and zt= '" + zt + "' order by pipe_num DESC ) order by pipe_num ASC ) order by pipe_num DESC;"; }
else
{
conn.SelectCommand = "select * from sb_all where id in ( select top " + pagesize + " id from sb_all where id in ( SELECT TOP " + page * pagesize + " id from sb_all where dep_user = '" + dep_user + "'and zt= '" + zt + "' order by pipe_num DESC ) order by pipe_num ASC ) order by pipe_num DESC;";
}
read = (SqlDataReader)conn.Select(DataSourceSelectArguments.Empty);
while (read.Read())
{ temp[0] = temp[0] + " <tr><td>" + j + "</td><td>" + read["water_dah"].ToString() + "</td><td>" + read["user_addr"].ToString() + "</td><td>" + read["sb_kj"].ToString() + "</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>";
j = j + 1;
} read.Close();
return temp;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货