protected void ddl_BrandName_SelectedIndexChanged(object sender, EventArgs e) { if (this.ddl_BrandName.SelectedValue.ToString() == "所有") { GoodProvider providers = new GoodProvider(); this.ListPager1.RecordCount = providers.GetSize(); this.BindSource(0, null); return; } this.BindSelect(); }
protected void btn_Result_Click(object sender, EventArgs e) { if (this.txt_Name.Text == "") { GoodProvider provider = new GoodProvider(); this.ListPager1.RecordCount = provider.GetSize(); this.BindSource(0); return; } this.BindSelect(); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.GridView1.Columns[5].Visible = false; GoodProvider provider = new GoodProvider(); this.ListPager1.RecordCount = provider.GetSize(); this.BindSource(0, null); } this.account.Text = Session["LOGINED"].ToString(); this.datetime.Text = this.BindDayWeek(); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
private void BindSelect() { Good good = new Good(); good.Unit_id = Convert.ToInt32(this.ddl_Unit.SelectedValue); good.Brand_id = Convert.ToInt32(this.ddl_BrandName.SelectedValue); good.Good_name = "%" + this.txt_Name.Text + "%"; good.Product_id = 2; GoodProvider provider = new GoodProvider(); this.ListPager1.RecordCount = provider.GetSize(good); DataTable table = provider.Select(good, 0, this.ListPager1.RecordCount); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { id = Request.QueryString["id"].ToString(); } if (!IsPostBack) { this.BindDDL(); GoodProvider provider = new GoodProvider(); this.ListPager1.RecordCount = provider.GetSize(); this.BindSource(0, null); } this.account.Text = Session["LOGINED"].ToString(); this.datetime.Text = this.BindDayWeek(); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
protected void btn_Result_Click(object sender, EventArgs e) { Good good = new Good(); GoodProvider provider = new GoodProvider(); if (this.txt_Position.Text == "") { GoodProvider providers = new GoodProvider(); this.ListPager1.RecordCount = providers.GetSize(); this.BindSource(0, null); } else { good.Good_name = "%" + this.txt_Position.Text + "%"; DataTable table = provider.Select(good, 0, this.ListPager1.RecordCount); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); } }
protected void btn_Result_Click(object sender, EventArgs e) { Good good = new Good(); GoodProvider provider = new GoodProvider(); if (this.txt_Name.Text == "") { if (this.txt_code.Text == "") { GoodProvider providers = new GoodProvider(); this.ListPager1.RecordCount = providers.GetSize(); this.BindSource(0, null); } else { good.Product_id = 2; good.Good_code = "%" + this.txt_code.Text + "%"; DataTable table = provider.Select(good, 0, this.ListPager1.RecordCount); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); } } else { if (this.txt_code.Text == "") { good.Product_id = 2; good.Good_name = "%" + this.txt_Name.Text + "%"; this.ListPager1.RecordCount = provider.GetSize(good); this.BindSource(0, "%" + this.txt_Name.Text + "%"); } else { good.Product_id = 2; good.Good_name = "%" + this.txt_Name.Text + "%"; good.Good_code = "%" + this.txt_code.Text + "%"; DataTable table = provider.Select(good, 0, this.ListPager1.RecordCount); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); } } this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }