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