private void BindDatalist(int currentpage) { pds.AllowPaging = true; pds.PageSize = 8; pds.CurrentPageIndex = currentpage; if (Session["ShopId"] != null) { BuyerDSTableAdapters.View_Phone_ShopTableAdapter HotPhoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable HotPhoneDT = HotPhoneDA.GetHotByShopId(long.Parse(Session["ShopId"].ToString())); if (HotPhoneDT.Rows.Count != 0) { lblShopName.Text = HotPhoneDT.Rows[0][22].ToString(); imgShopLogo.ImageUrl = HotPhoneDT.Rows[0][29].ToString(); for (int i = 0; i < HotPhoneDT.Rows.Count; i++) { switch (i) { case 0: { img1.ImageUrl = HotPhoneDT.Rows[i][16].ToString(); lbtnName1.Text = HotPhoneDT.Rows[i][1].ToString(); lbtnName1.CommandArgument = HotPhoneDT.Rows[i][0].ToString(); break; } case 1: { img2.ImageUrl = HotPhoneDT.Rows[i][16].ToString(); lbtnName2.Text = HotPhoneDT.Rows[i][1].ToString(); lbtnName2.CommandArgument = HotPhoneDT.Rows[i][0].ToString(); break; } case 2: { img3.ImageUrl = HotPhoneDT.Rows[i][16].ToString(); lbtnName3.Text = HotPhoneDT.Rows[i][1].ToString(); lbtnName3.CommandArgument = HotPhoneDT.Rows[i][0].ToString(); break; } } } } BuyerDSTableAdapters.View_Phone_ShopTableAdapter AllPhoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable AllPhoneDT = AllPhoneDA.GetDataByShopId(long.Parse(Session["ShopId"].ToString())); if (AllPhoneDT.Rows.Count != 0) { pds.DataSource = AllPhoneDT.DefaultView; dlPhone.DataSource = pds; dlPhone.DataBind(); } } }
protected void dlShop_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Footer) { Label lblCurrent = e.Item.FindControl("lblCurrentPage") as Label; Label lblCount = e.Item.FindControl("lblCount") as Label; LinkButton lbtnFirst = e.Item.FindControl("lbtnFirst") as LinkButton; LinkButton lbtnPre = e.Item.FindControl("lbtnPre") as LinkButton; LinkButton lbtnNext = e.Item.FindControl("lbtnNext") as LinkButton; LinkButton lbtnLast = e.Item.FindControl("lbtnLast") as LinkButton; lblCurrent.Text = "第" + (pds.CurrentPageIndex + 1).ToString() + "页"; lblCount.Text = "共" + pds.PageCount.ToString() + "页"; if (pds.IsFirstPage) { lbtnFirst.Enabled = false; lbtnPre.Enabled = false; } if (pds.IsLastPage) { lbtnNext.Enabled = false; lbtnLast.Enabled = false; } } else { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataList dlPhoneInShop = (DataList)e.Item.FindControl("dlPhoneInShop"); string ShopId = dlShop.DataKeys[e.Item.ItemIndex].ToString().Trim(); if (ShopId != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetHotByShopId(long.Parse(ShopId)); if (phoneDT.Rows.Count > 0) { dlPhoneInShop.DataSource = phoneDT; dlPhoneInShop.DataBind(); } } } } }
protected void btnSearch_Click(object sender, EventArgs e) { dlPhone.Visible = true; if (txtLower.Text == "" && txtHigher.Text == "" && txtSearch.Text == "") { Response.Write("<Script>alert('请输入查询条件!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('请输入查询条件!');", true); } else { if (txtSearch.Text != "") { if (txtLower.Text == "" && txtHigher.Text == "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByInPhone(long.Parse(Session["ShopId"].ToString()), txtSearch.Text); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { if (txtHigher.Text != "" && txtLower.Text != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPriceAndName(long.Parse(Session["ShopId"].ToString()), txtSearch.Text, int.Parse(txtLower.Text.Trim()), int.Parse(txtHigher.Text.Trim())); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { if (txtHigher.Text == "" && txtLower.Text != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPriceAndName(long.Parse(Session["ShopId"].ToString()), txtSearch.Text, int.Parse(txtLower.Text.Trim()), 10000); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPriceAndName(long.Parse(Session["ShopId"].ToString()), txtSearch.Text, 0, int.Parse(txtHigher.Text.Trim())); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } } } } else { if (txtLower.Text != "" && txtHigher.Text != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPrice(long.Parse(Session["ShopId"].ToString()), int.Parse(txtLower.Text.Trim()), int.Parse(txtHigher.Text.Trim())); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { if (txtHigher.Text == "" && txtLower.Text != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPrice(long.Parse(Session["ShopId"].ToString()), int.Parse(txtLower.Text.Trim()), 10000); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPrice(long.Parse(Session["ShopId"].ToString()), 0, int.Parse(txtHigher.Text.Trim())); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } } } } }
protected void dlShop_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Footer) { Label lblCurrent = e.Item.FindControl("lblCurrentPage") as Label; Label lblCount = e.Item.FindControl("lblCount") as Label; LinkButton lbtnFirst = e.Item.FindControl("lbtnFirst") as LinkButton; LinkButton lbtnPre = e.Item.FindControl("lbtnPre") as LinkButton; LinkButton lbtnNext = e.Item.FindControl("lbtnNext") as LinkButton; LinkButton lbtnLast = e.Item.FindControl("lbtnLast") as LinkButton; lblCurrent.Text = "第" + (pds.CurrentPageIndex + 1).ToString() + "页"; lblCount.Text = "共" + pds.PageCount.ToString() + "页"; if (pds.IsFirstPage) { lbtnFirst.Enabled = false; lbtnPre.Enabled = false; } if (pds.IsLastPage) { lbtnNext.Enabled = false; lbtnLast.Enabled = false; } } else { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataList dlPhoneInShop = (DataList)e.Item.FindControl("dlPhoneInShop"); string ShopId = dlShop.DataKeys[e.Item.ItemIndex].ToString().Trim(); if (ShopId != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetHotByShopId(long.Parse(ShopId)); if (phoneDT.Rows.Count > 0) { dlPhoneInShop.DataSource = phoneDT; dlPhoneInShop.DataBind(); } } } } }
protected void btnSearch_Click(object sender, EventArgs e) { dlPhone.Visible = true; if (txtLower.Text == "" && txtHigher.Text == "" && txtSearch.Text == "") { Response.Write("<Script>alert('请输入查询条件!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('请输入查询条件!');", true); } else { if (txtSearch.Text != "") { if (txtLower.Text == "" && txtHigher.Text == "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByInPhone(long.Parse(Session["ShopId"].ToString()), txtSearch.Text); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { if (txtHigher.Text != "" && txtLower.Text != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPriceAndName(long.Parse(Session["ShopId"].ToString()), txtSearch.Text, int.Parse(txtLower.Text.Trim()), int.Parse(txtHigher.Text.Trim())); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { if (txtHigher.Text == "" && txtLower.Text != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPriceAndName(long.Parse(Session["ShopId"].ToString()), txtSearch.Text, int.Parse(txtLower.Text.Trim()), 10000); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPriceAndName(long.Parse(Session["ShopId"].ToString()), txtSearch.Text, 0, int.Parse(txtHigher.Text.Trim())); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } } } } else { if (txtLower.Text != "" && txtHigher.Text != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPrice(long.Parse(Session["ShopId"].ToString()), int.Parse(txtLower.Text.Trim()), int.Parse(txtHigher.Text.Trim())); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { if (txtHigher.Text == "" && txtLower.Text != "") { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPrice(long.Parse(Session["ShopId"].ToString()), int.Parse(txtLower.Text.Trim()), 10000); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } else { BuyerDSTableAdapters.View_Phone_ShopTableAdapter phoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable phoneDT = phoneDA.GetDataByPrice(long.Parse(Session["ShopId"].ToString()), 0, int.Parse(txtHigher.Text.Trim())); dlPhone.DataSource = phoneDT; dlPhone.DataBind(); if (phoneDT.Rows.Count == 0) { dlPhone.Visible = false; Response.Write("<Script>alert('没有满足条件的商品!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('没有满足条件的商品!');", true); } } } } } }
private void BindDatalist(int currentpage) { pds.AllowPaging = true; pds.PageSize = 8; pds.CurrentPageIndex = currentpage; if (Session["ShopId"] != null) { BuyerDSTableAdapters.View_Phone_ShopTableAdapter HotPhoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable HotPhoneDT = HotPhoneDA.GetHotByShopId(long.Parse(Session["ShopId"].ToString())); if (HotPhoneDT.Rows.Count != 0) { lblShopName.Text = HotPhoneDT.Rows[0][22].ToString(); imgShopLogo.ImageUrl = HotPhoneDT.Rows[0][29].ToString(); for (int i = 0; i < HotPhoneDT.Rows.Count; i++) { switch (i) { case 0: { img1.ImageUrl = HotPhoneDT.Rows[i][16].ToString(); lbtnName1.Text = HotPhoneDT.Rows[i][1].ToString(); lbtnName1.CommandArgument = HotPhoneDT.Rows[i][0].ToString(); break; } case 1: { img2.ImageUrl = HotPhoneDT.Rows[i][16].ToString(); lbtnName2.Text = HotPhoneDT.Rows[i][1].ToString(); lbtnName2.CommandArgument = HotPhoneDT.Rows[i][0].ToString(); break; } case 2: { img3.ImageUrl = HotPhoneDT.Rows[i][16].ToString(); lbtnName3.Text = HotPhoneDT.Rows[i][1].ToString(); lbtnName3.CommandArgument = HotPhoneDT.Rows[i][0].ToString(); break; } } } } BuyerDSTableAdapters.View_Phone_ShopTableAdapter AllPhoneDA = new BuyerDSTableAdapters.View_Phone_ShopTableAdapter(); DataTable AllPhoneDT = AllPhoneDA.GetDataByShopId(long.Parse(Session["ShopId"].ToString())); if (AllPhoneDT.Rows.Count != 0) { pds.DataSource = AllPhoneDT.DefaultView; dlPhone.DataSource = pds; dlPhone.DataBind(); } } }