using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

namespace ygdzwww
{
 /// <summary>
 /// WebForm1 的摘要说明。
 /// </summary>
 public class WebForm1 : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.DataGrid DataGrid1;
  protected System.Web.UI.WebControls.Label Label4;
  protected System.Web.UI.WebControls.LinkButton PageFirst;
  protected System.Web.UI.WebControls.LinkButton PageNext;
  protected System.Web.UI.WebControls.LinkButton PageLast;
  protected System.Web.UI.WebControls.LinkButton PagePre;
  protected System.Web.UI.WebControls.Button BTXianDelete;
  protected System.Web.UI.WebControls.Button BTXianSearch;
  protected System.Web.UI.WebControls.Label LBXianName;
  protected System.Web.UI.WebControls.TextBox TBXianName;
  protected System.Web.UI.WebControls.Label LBPageCount;
  protected System.Web.UI.WebControls.Button BTXianAdd;
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   if(!Page.IsPostBack)
   {
    DataGrid1.DataSource=new YGDZ.WKR_T01_01_1Service().GetAll();
    DataGrid1.DataBind();
    LBPageCount.Text = "第"+((Int32) DataGrid1.CurrentPageIndex +1)+"页"+"/共"+DataGrid1.PageCount +"页";
   }
  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.BTXianAdd.Click += new System.EventHandler(this.BTXianAdd_Click);
   this.BTXianDelete.Click += new System.EventHandler(this.BTXianDelete_Click);
   this.BTXianSearch.Click += new System.EventHandler(this.BTXianSearch_Click);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  private void BTXianAdd_Click(object sender, System.EventArgs e)
  {
   Response.Redirect("YGDZ_xianadd.aspx" );   
  }
  

  public void PageButton(object sender, System.EventArgs e)
  {
   string arg=((LinkButton)sender).CommandArgument;
   switch(arg)
   {
    case ("pagefirst"):
     DataGrid1.CurrentPageIndex=0;
     break;
    case ("pagenext"):
     if(DataGrid1.CurrentPageIndex<(DataGrid1.PageCount -1))
      DataGrid1.CurrentPageIndex ++;
     break;
    case ("pagepre"):
     if(DataGrid1.CurrentPageIndex>0)
      DataGrid1.CurrentPageIndex --;
     break;
    case ("pagelast"):
     DataGrid1.CurrentPageIndex=DataGrid1.PageCount-1;
     break;

   }
   DataGrid1.DataSource=new YGDZ.WKR_T01_01_1Service().GetAll();
   DataGrid1.DataBind();
   LBPageCount.Text="第"+((Int32) DataGrid1.CurrentPageIndex +1)+"页"+"/共"+DataGrid1.PageCount +"页";

  
  }

  private void BTXianSearch_Click(object sender, System.EventArgs e)
  {
   if(TBXianName.Text.Trim()!="")
   {
    DataGrid1.DataSource=new YGDZ.WKR_T01_01_1Service().GetbySQL("select * from wkr_t01_01_1 where B010102 like '%"+TBXianName.Text.Trim()+"%'");
    DataGrid1.DataBind();
    LBPageCount.Text="第"+((Int32) DataGrid1.CurrentPageIndex +1)+"页"+"/共"+DataGrid1.PageCount +"页";
   }
   else
   {    
    DataGrid1.DataSource=new YGDZ.WKR_T01_01_1Service().GetAll();
    DataGrid1.DataBind();
   }
   
  
  }

  private void BTXianDelete_Click(object sender, System.EventArgs e)
  {
   foreach(DataGridItem item in DataGrid1.Items )

   {
    CheckBox selection;
    selection = (CheckBox)item.FindControl("chk");

    if (selection.Checked)
    {
     string sXianCode=item.Cells[1].Text;
     YGDZ.WKR_T01_01_1Service objService2=new YGDZ.WKR_T01_01_1Service();
     YGDZ.WKR_T01_01_1Set dset= objService2.GetbySQL("delete WKR_T01_01_1 where B010101="+sXianCode);            
    }    

   }
  //
   DataGrid1.DataSource=new YGDZ.WKR_T01_01_1Service().GetAll();
   DataGrid1.DataBind();
   LBPageCount.Text ="第"+((Int32) DataGrid1.CurrentPageIndex +1)+"页"+"/共"+DataGrid1.PageCount +"页";
  
  }

  
 }
}