protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int rowIndex = e.RowIndex; Freight freight = new Freight(); freight.Freight_id = Convert.ToInt32(this.GridView1.DataKeys[rowIndex].Value); FreightProvider provider = new FreightProvider(); if (provider.Delete(freight)) { this.Alert("删除成功!!!"); if (this.txt_Name.Text == "") { this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1; this.BindSource(null); } else { this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1; this.BindSource("%" + this.txt_Name.Text + "%"); } } }
protected void btn_sure_Click(object sender, EventArgs e) { Freight freight = this.AddFreight(); FreightProvider provider = new FreightProvider(); switch (this.OperationFlag) { case Operation.Add: if (this.IsSame() == 1) { break; } if (provider.Insert(freight)) { this.Alert("添加成功!!!"); this.TextCancel(); } break; case Operation.Update: if (provider.Update(freight)) { this.Alert("修改成功!!!"); this.BindText(); } break; } }
protected void btn_Result_Click(object sender, EventArgs e) { Freight freight = new Freight(); freight.Freight_name = "%" + this.txt_Name.Text + "%"; FreightProvider provider = new FreightProvider(); this.ListPager1.RecordCount = provider.GetSize(freight); this.BindSource(0, "%" + this.txt_Name.Text + "%"); this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FreightProvider provider = new FreightProvider(); 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 BindText() { Freight freight = new Freight(); freight.Freight_id = Convert.ToInt32(id); FreightProvider provider = new FreightProvider(); DataTable table = new DataTable(); table = provider.Select(freight); this.txt_name.Text = table.Rows[0]["freight_name"].ToString(); }
private void BindSource() { FreightProvider freight = new FreightProvider(); this.ddl_freight.DataSource = freight.GetAll(); this.ddl_freight.DataBind(); SendProvider send = new SendProvider(); this.ddl_send.DataSource = send.GetAll(); this.ddl_send.DataBind(); CustomersProvider customers = new CustomersProvider(); this.ddl_customers.DataSource = customers.GetAll(); this.ddl_customers.DataBind(); }
/// <summary> /// 绑定Freight信息的数据源 /// </summary> private void BindSource(int start, string name) { if (name != null) { Freight freight = new Freight(); freight.Freight_name = name; FreightProvider provider = new FreightProvider(); DataTable table = provider.Select(freight, start, this.ListPager1.PageSize); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); } else { FreightProvider provider = new FreightProvider(); DataTable table = provider.GetAll(start, this.ListPager1.PageSize); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); } }
private int IsSame() { Freight freight = new Freight(); FreightProvider provider = new FreightProvider(); freight.Freight_name = this.txt_name.Text; DataTable table = new DataTable(); table = provider.Select(freight); if (table.Rows.Count != 0) { this.Alert("该方式已经存在,请重新输入!!!"); return(1); } else { return(0); } }