public DataTable GetDataTableByPage(string mysql, CDBProcess db)
{
DataSet myds = new DataSet();
SqlDataAdapter myda = null;
myda = db.Getadapter(mysql);
myda.Fill(myds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "temptbl");
DataTable dt = myds.Tables["temptbl"];
return dt;
}
private void BindList(CDBProcess db)
{
DataTable dt;
object obj = Request.QueryString["op"];
if (ViewState["mydt"] != null && obj != null)
{
dt = GetDtByDvAndPage(((DataTable)ViewState["mydt"]).DefaultView);
this.repToursList.DataSource = dt;
repToursList.DataBind();
}
else
{
city = Request["city"] == null ? "" : Request["city"].ToString();
typ = Request["tp"] == null ? "" : Request["tp"].ToString();
string sql = "";
string sqlCount = "";
//string strWhere = " and state = 0 ";
if (obj != null)
{
city = Request["c"].ToString();
typ = Request["t"].ToString();
pname = Request["pname"].ToString();
}
if (city == "" || city == "null")
{
sql = "select * from productinfo where state = 0 and isDel<>1 and type = 4 $pname$ order by [sort] asc";
sqlCount = "select count(*) from productinfo where state = 0 and isDel<>1 and type = 4 $pname$";
}
else
{
if (typ == "Anytype")
{
sql = "select * from productinfo where state = 0 and type = 4 and isDel<>1 $pname$ and ProductCity='" + city + "' order by [sort] asc";
sqlCount = "select count(*) from productinfo where state = 0 and type = 4 and isDel<>1 $pname$ and ProductCity='" + city + "'";
}
else
{
sql = "select * from productinfo where state = 0 and type = 4 and isDel<>1 $pname$ and ProductCity='" + city + "' and (TourType1='" + typ + "' or TourType2='" + typ + "') order by [sort] asc";
sqlCount = "select count(*) from productinfo where state = 0 and type = 4 and isDel<>1 $pname$ and ProductCity='" + city + "' and (TourType1='" + typ + "' or TourType2='" + typ + "')";
}
aboutTitle = " -- " + city;
}
if (string.IsNullOrEmpty(pname) == false)
{
sql = sql.Replace("$pname$", " and productname like '%" + pname + "%' ");
sqlCount = sqlCount.Replace("$pname$", " and productname like '%" + pname + "%' ");
}
else
{
sql = sql.Replace("$pname$", " ");
sqlCount = sqlCount.Replace("$pname$", "");
}
int count = Convert.ToInt32(db.Scalar(sqlCount));
dt = GetDataTableByPage(sql, db);
AspNetPager1.RecordCount = count;
this.repToursList.DataSource = dt;
this.repToursList.DataBind();
ViewState["mydt"] = db.GetDataSet(sql).Tables[0];
}
//string strWhere = " and state = 0 ";
//DataTable dt = CProductInfo.GetproductinfoList(db, 6, strWhere + " and type = 4 ");
//this.repToursList.DataSource = dt.DefaultView;
//this.repToursList.DataBind();
}
private void Bindmost(CDBProcess db)
{
string strWhere = " and state = 0 ";
DataTable dt;
if (typ == "All")
{
dt = CProductInfo.GetproductinfoListM(db, 15, strWhere + " and isDel<>1 and type = 4 order by [sort] asc");
}
else
{
//dt = CProductInfo.GetproductinfoList(db, 10, strWhere + " and type = 1 and ProductCity=" + typ);
dt = CProductInfo.GetproductinfoListM(db, 15, strWhere + " and isDel<>1 and type = 4 order by [sort] asc");
}
this.replistdy.DataSource = dt.DefaultView;
this.replistdy.DataBind();
}
