读书人

自己写了个分页,有点有关问题,请大家看

发布时间: 2012-04-08 14:38:30 作者: rapoo

自己写了个分页,有点问题,请大家看看
static string sql= " ";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
sql = "select [id],[ss],[city],[qy],[pq],[house_name],[address],[hx],[wylx],[jz_area],[jg],[zxcd],[cx],[bs],[cq],[zj],[fk],[fy],[zhuangtai],[kf],[dq],[wt],[ly],[tdjb],[lpwq],[jj],[jd],[jcpt],[bzjc],[cont],[djdate],[gxdate],[ren],[phone],[telphone],[lc],[sumlc],[newold],[wygl],[jt],[pay],[email],[zs],[tuijian],[tuijian1],[niandai],[lc1],[lc2],[gs],[area1],[area2],[dj],[cjr],[lb],[cj],[tel1],[ren1],[pay1],[fx],[fx1],[dian],[salesname],[mjdw],[jgdw],[anjie],[xingzi],[dong],[menpai],[quanshu],[shi],[ting],[wei],[loupan],[jingqudizhi],[ishide] from HouseInfo where [ishide]=1 and [chuqiu]= '1 ' ";

getbind(sql);

}
}

public void getbind(string sql)
{
DataSet ds = new DataSet();
ds = open.getreader(sql);
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = ds.Tables[0].DefaultView;

int count = ds.Tables[0].Rows.Count;

objPds.AllowPaging = true;
objPds.PageSize = 10;
int CurPage;
if (Request.QueryString[ "Page "] != null)
CurPage = Convert.ToInt32(Request.QueryString[ "Page "]);
else
CurPage = 1;

objPds.CurrentPageIndex = CurPage - 1;
lblCurrentPage.Text =CurPage.ToString();
zongjilu.Text = count.ToString();

int sumye = count / 10 + 1;

sumyema.Text = sumye.ToString();
tiaomeiye.Text = "10 ";
if (!objPds.IsFirstPage)
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page= " + Convert.ToString(CurPage - 1);



if (!objPds.IsLastPage)
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page= " + Convert.ToString(CurPage + 1);

if(!objPds.IsFirstPage)
first.NavigateUrl = Request.CurrentExecutionFilePath + "?Page= " + 1;
if (!objPds.IsLastPage)
end.NavigateUrl = Request.CurrentExecutionFilePath + "?Page= " + sumye;
Repeater1.DataSource = objPds;
Repeater1.DataBind();
}

protected void chaxun_Click1(object sender, EventArgs e)
{
string sql1 = " ";
string wuyeleixing = wylx.SelectedItem.Text; //物业类型
if (idhao.Text != null&&idhao.Text!= " ")
{
string id = idhao.Text.Trim(); //房源id号
sql1 += " and id= "+id;
}

if (dian.SelectedItem.Text != "请选择 ")
{
string dia = dian.SelectedItem.Text; //店
sql1 += "and dian= ' " + dia + " ' ";
}

string jia1 = jiage1.Text.Trim(); //价格1
string jia2 = jiage2.Text.Trim();  //价格2
if (jia1 == " " && jia2 != " ")
{
Response.Write( " <script> alert( '价格必须同步! ') </script> ");
}
else if (jia1 != " " && jia2 == " ")
{


Response.Write( " <script> alert( '价格必须同步! ') </script> ");
}
else if (jia1 != " " && jia2 != " ")
{
sql1 += " and pay> = " + jia1 + " and pay <= " + jia2;
}
string mj1 = mianji1.Text.Trim(); //面积1
string mj2 = mianji2.Text.Trim(); //面积2

if (mj1 == " " && mj2 != " ")
{
Response.Write( " <script> alert( '面积必须同步! ') </script> ");
}
else if (mj1 != " " && mj2 == " ")
{
Response.Write( " <script> alert( '面积必须同步! ') </script> ");
}
else if (mj1 != " " && mj2 != " ")
{
sql1 += " and jz_area> = " + mj1 + " and jz_area <= " + mj2;
}


string loucheng1 = lc1.Text.Trim(); //楼层1
string loucheng2 = lc2.Text.Trim(); //楼层2

if (loucheng1 == " " && loucheng2 != " ")
{
Response.Write( " <script> alert( '楼层必须同步! ') </script> ");
}
else if (loucheng1 != " " && loucheng2 == " ")
{
Response.Write( " <script> alert( '楼层必须同步! ') </script> ");
}
else if (loucheng1 != " " && loucheng2 != " ")


{
sql1 += " and lc> = " + loucheng1 + " and lc <= " + loucheng2;
}

//时间

if (zhuangtai.SelectedItem.Text != "请选择 ")
{
string zhuangta = zhuangtai.SelectedItem.Text; //状态
sql1 += " and zhuangtai= ' " + zhuangta + " ' ";
}
if (jianzhuniandai.SelectedItem.Text != "请选择 ")
{
string jznd = jianzhuniandai.SelectedItem.Text; // 建筑年代
sql1 += " and niandai= "+jznd;
}
if (shii.SelectedItem.Text != "请选择 ")
{
string shis = shii.SelectedItem.Text;
sql1 += " and shi= ' " + shis+ " ' ";
if (ting.SelectedItem.Text != "请选择 ")
{
string tingt=ting.SelectedItem.Text;
sql1 += " and ting= ' " + tingt+ " ' ";
}
if (wei.SelectedItem.Text != "请选择 ")
{
string weiw = wei.SelectedItem.Text;
sql1 += " and wei= ' " + weiw+ " ' ";
}

}
sql += sql1;


getbind(sql);
sql = "select [id],[ss],[city],[qy],[pq],[house_name],[address],[hx],[wylx],[jz_area],[jg],[zxcd],[cx],[bs],[cq],[zj],[fk],[fy],[zhuangtai],[kf],[dq],[wt],[ly],[tdjb],[lpwq],[jj],[jd],[jcpt],[bzjc],[cont],[djdate],[gxdate],[ren],[phone],[telphone],[lc],[sumlc],[newold],[wygl],[jt],[pay],[email],[zs],[tuijian],[tuijian1],[niandai],[lc1],[lc2],[gs],[area1],[area2],[dj],[cjr],[lb],[cj],[tel1],[ren1],[pay1],[fx],[fx1],[dian],[salesname],[mjdw],[jgdw],[anjie],[xingzi],[dong],[menpai],[quanshu],[shi],[ting],[wei],[loupan],[jingqudizhi],[ishide] from HouseInfo where [ishide]=1 and [chuqiu]= '1 ' ";
}
}

每次点击查询后,得到的分页,点击下一页就回到了初始化的分页 不知道是怎么回事啊
就算查出来的只有一页还是可以点击下一页 点击下一页就回到了初始化的分页

[解决办法]
点击分页事件里要重新帮顶数据源

读书人网 >asp.net

热点推荐