datagrid的增删查改 aspx.cs部分代码

//说明：这里有三个部分“Main Parts”，“Mechanical Parts”，“Labour”都有添加、修改、删除，模糊查询方法（由于这三个部分都是存放在一张表中的所以操作方法都相同，只是个别字段不同）

private void ddlBind(string str)
  {
   //"Parts"
   //"Mechanical Parts"
   comCodeEngine codeEngineT= new comCodeEngine();
   modCodeInfo mod=new modCodeInfo();
   mod.AttributeType=str;

   IList codeApproval = codeEngineT.GetCodeList(mod);     
   this.ddlAttribute.DataSource=codeApproval;
   ddlAttribute.DataTextField="Remarks";
   ddlAttribute.DataValueField="Description";
   ddlAttribute.DataBind(); 
    
  }

  private void dataGridBind()
  {
   DataSet ds=new DataSet();
   bizPart biz =new bizPart();
   modPart mod =new modPart();
   
   if(ViewState["OrderBy"]==null)
    ViewState["OrderBy"]="OrderIndex";
   switch(this.rdbtnType.SelectedValue)
   {
    case "0":mod.ParentType="Main Parts";break;
    case "1" :mod.ParentType="Mechanical Parts";break;
    case "2" :mod.ParentType="Labour";break;
    default:mod.ParentType="Main Parts";break;

   }  
   if(ViewState["SearchBy"]!=null)
   {
    if(ViewState["SearchBy"].ToString()=="No")
     mod.PartNo=this.txtSearchNo.Text.Trim();
    if(ViewState["SearchBy"].ToString()=="Desc")
     mod.PartDescription=this.txtSearchDesc.Text.Trim();

    ds=biz.GetSearchPart(mod);
   }
   else
   {
    ds=biz.GetPart(mod);
   
   }   

   DataView dv=new DataView(ds.Tables[0]);

   dv.Sort=ViewState["OrderBy"].ToString();

   this.dgPart.DataSource=dv;
   this.dgPart.DataBind(); 

   int nPage = dgPart.CurrentPageIndex;
   int nPageSize = dgPart.PageSize;
   for(int i=0; i<this.dgPart.Items.Count; i++)
   {
    int id = nPage * nPageSize + i + 1;
    if(id<10)
     this.dgPart.Items[i].Cells[0].Text = "0" + id.ToString();
    else
     this.dgPart.Items[i].Cells[0].Text = id.ToString();
   }

   pageCommLibrary.RemoveConfirm(dgPart,this);
  }

  private void rdbtnType_SelectedIndexChanged(object sender, System.EventArgs e)
  {
   ViewState["SearchBy"]=null;
   this.txtSearchNo.Text="";
   this.txtSearchDesc.Text="";

   this.dgPart.EditItemIndex=-1;
   this.dgPart.CurrentPageIndex=0;   

   this.ddlAttribute.SelectedIndex=0;   
   this.txtDesc.Text="";
   this.txtUnitofMeasure.Text="";
   this.txtGroup.Text="0";

   if(this.rdbtnType.SelectedIndex==2)
   {
    this.dgPart.Columns[4].Visible=false;

    this.ddlAttribute.Visible=false;    

    this.txtDesc.Visible=true;  
    this.txtUnitofMeasure.Visible=false;  
   
   }

   else if(this.rdbtnType.SelectedIndex==0)
   {
    ddlBind("Parts");
    this.dgPart.Columns[4].Visible=true;

    this.ddlAttribute.Visible=true;
    this.txtDesc.Visible=true;   
    this.txtUnitofMeasure.Visible=true; 
   }
   else
   {
    ddlBind("Mechanical Parts");
    this.dgPart.Columns[4].Visible=true;

    this.ddlAttribute.Visible=true;     
    this.txtDesc.Visible=true;  
    this.txtUnitofMeasure.Visible=true;  
   }

   
   dataGridBind();

   pageCommLibrary.SetBoxToLableStyle(this);
  }
       
  ///添加方法
  private void imgbtnSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  {
   bizPart biz =new bizPart();
   modPart mod =new modPart();
   mod.PartDescription=this.txtDesc.Text.Trim();
   if(this.rdbtnType.SelectedIndex==2)
   {
    mod.PartAttributeType="Labour";
    mod.ParentType="Labour";
   }
   else if(this.rdbtnType.SelectedIndex==1)
   {
    mod.PartAttributeType=this.ddlAttribute.SelectedValue;
    mod.ParentType="Mechanical Parts";
    
   }
   else if(this.rdbtnType.SelectedIndex==0)
   {    
    mod.ParentType="Main Parts";
    mod.PartAttributeType=this.ddlAttribute.SelectedValue;
     
   }

   mod.PartDescription=this.txtDesc.Text.Trim();

   if(mod.PartDescription.Trim()=="")
   {
    pageCommLibrary.showJSMsgInPage(this,"零件描述"+comMessage.Create().GetMessage("CanNotBeNull"));     
    return;     
   }     
   
   DataSet dsssss=biz.GetPart(mod);
   if(dsssss.Tables[0].Rows.Count>0)
   {
    pageCommLibrary.showJSMsgInPage(this,"该零件"+comMessage.Create().GetMessage("Exist"));
    return;        
  
   }   
    
   if(!pageCommLibrary.bIsNumber(this.txtGroup.Text.Trim()))
   {
    pageCommLibrary.showJSMsgInPage(this,"组"+comMessage.Create().GetMessage("IsNotNumber"));
    //pageCommLibrary.showJSMsgInPage(this,"Group "+comMessage.Create().GetMessage("IsNotNumber"));
    return;     
   }

   if(txtUnitofMeasure.Enabled)
    mod.UnitofMeasure=this.txtUnitofMeasure.Text.Trim();
   mod.GroupIndex=this.txtGroup.Text.Trim();

   mod.ModD.Creator=Session["LoginName"].ToString(); 
   mod.ModD.LastModifier=Session["LoginName"].ToString(); 

   bool bRest=biz.InsertPart(mod);
   if(!bRest)
   {    
    pageCommLibrary.showJSMsgInPage(this,comMessage.Create().GetMessage("InsertFail"));   
    
   }
   else
   {
    ViewState["LogEvent"]=Const.EVENTLOG_SUBMIT;
    new Log().LogData((ILogPage)this);
    
    dataGridBind();

    this.ddlAttribute.SelectedIndex=0;    
    this.txtDesc.Text="";
    //this.txtNo.Text="";
    this.txtUnitofMeasure.Text="";
    this.txtGroup.Text="0";
   }     
  
  }
  
  ///取消添加
  private void imgbtnCancel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  {
   this.ddlAttribute.SelectedIndex=0;   
   this.txtDesc.Text="";
   //this.txtNo.Text="";
   this.txtUnitofMeasure.Text="";
   this.txtGroup.Text="0";
  
  }

  public NameValueCollection GetOldData()
  {
   NameValueCollection nameValue = new NameValueCollection();

   //   string str = (string)this.ViewState["old"];
   //
   //   if(str != null)
   //    old.Add("txtPolicyNo",str);

   return nameValue;
   
  }
  public NameValueCollection GetLogData()
  {
   NameValueCollection nameValue = new NameValueCollection();
   //log.Add("txtPolicyNo",txtPolicyNo.Text);

   if(ViewState["LogEvent"]!=null)
   {  
    nameValue.Add("eventLog", ViewState["LogEvent"].ToString()); 
   }
  
   nameValue.Add("userId",Session["LoginName"].ToString());   
   nameValue.Add("memo","Admin_Part");

   return nameValue;
  }

  private void imbtnAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  {   
   this.PanelAdd.Visible=(!this.PanelAdd.Visible);
  }

  private void dgPart_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   this.dgPart.EditItemIndex=-1;
   dataGridBind();
  
  }

  private void dgPart_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   bizPart biz =new bizPart();
   modPart mod =new modPart();

   string strid=(string)this.dgPart.DataKeys[(int)e.Item.ItemIndex];
   mod.ID=strid;

   bool bRest=biz.DeletePartByID(mod);

   if(bRest)
   {
    ViewState["LogEvent"]=Const.EVENTLOG_REMOVE;
    new Log().LogData((ILogPage)this);
   
   }
   else
   {
    pageCommLibrary.showJSMsgInPage(this,comMessage.Create().GetMessage("RemoveFail"));
    return;  
   
   }

   int iP=this.dgPart.CurrentPageIndex*dgPart.PageSize+dgPart.Items.Count;
   if(iP % dgPart.PageSize == 1 && iP != 1 && dgPart.CurrentPageIndex != 0)
    dgPart.CurrentPageIndex = dgPart.CurrentPageIndex -1;

   dataGridBind();
  
  }

  private void dgPart_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {

   this.dgPart.EditItemIndex = (int)e.Item.ItemIndex;  
   dataGridBind();
   pageCommLibrary.SetEditFormate(this.dgPart);   
  
  }

  private void dgPart_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
  
   this.dgPart.CurrentPageIndex = e.NewPageIndex;
   dataGridBind();
  }

  private void dgPart_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   
   bizPart biz =new bizPart();
   modPart mod =new modPart();

   string strid=(string)this.dgPart.DataKeys[(int)e.Item.ItemIndex];
   string strPartNo="";

   strPartNo=((TextBox)(e.Item.Cells[2].Controls[0])).Text.Trim().ToString();    
   if(strPartNo=="")
   {
    pageCommLibrary.showJSMsgInPage(this,"零件编号"+comMessage.Create().GetMessage("CanNotBeNull"));  

    return;
   }
   else
   {
    if(!pageCommLibrary.CheckStrLen(strPartNo,24))
    {
     strPartNo=strPartNo.Substring(0,24);
    
    }

    modPart modP =new modPart();
    modP.PartNo=strPartNo;    
      
    if(modP.PartNo!=null)
    {
     DataSet dsssss=biz.GetPart(modP);
     for(int i=0;i<dsssss.Tables[0].Rows.Count;i++)
     {
      if(dsssss.Tables[0].Rows[i]["ID"].ToString().Trim()!=strid&&strPartNo==dsssss.Tables[0].Rows[i]["PartNo"].ToString().Trim())
      {
       pageCommLibrary.showJSMsgInPage(this,"零件编号"+comMessage.Create().GetMessage("Exist"));
       return;        
    
      } 
     }
    }  
   }
   
   mod.PartAttributeType=e.Item.Cells[1].Text.ToString();
   switch(this.rdbtnType.SelectedValue)
   {
    case "0":mod.ParentType="Main Parts";break;
    case "1" :mod.ParentType="Mechanical Parts";break;
    case "2" :mod.ParentType="Labour";break;
    default:mod.ParentType="Main Parts";break;

   }   
   if(this.rdbtnType.SelectedIndex==0)
   { 
    
    mod.PartDescription=((TextBox)(e.Item.Cells[3].Controls[0])).Text.Trim().ToString();
    mod.UnitofMeasure=((TextBox)(e.Item.Cells[4].Controls[0])).Text.Trim().ToString();
   
   }
   else  if(this.rdbtnType.SelectedIndex==1)
   {
    
    mod.PartDescription=((TextBox)(e.Item.Cells[3].Controls[0])).Text.Trim().ToString();
    mod.UnitofMeasure=((TextBox)(e.Item.Cells[4].Controls[0])).Text.Trim().ToString();
  
   } 
   else  if(this.rdbtnType.SelectedIndex==2)   {
    
    mod.PartDescription=((TextBox)(e.Item.Cells[3].Controls[0])).Text.Trim().ToString();    
   
   }

   if(!pageCommLibrary.CheckStrLen(mod.PartDescription,255))
   {
    mod.PartDescription=mod.PartDescription.Substring(0,255);
    
   }

   if(mod.UnitofMeasure!=null&&!pageCommLibrary.CheckStrLen(mod.UnitofMeasure,255))
   {
    mod.UnitofMeasure=mod.UnitofMeasure.Substring(0,255);
    
   }

//   DataSet ds=biz.GetPart(mod);    
//   for(int i=0;i<ds.Tables[0].Rows.Count;i++)
//   {
//    if(ds.Tables[0].Rows[i]["ID"].ToString().Trim()!=strid)
//    {
//     pageCommLibrary.showJSMsgInPage(this,"this part "+comMessage.Create().GetMessage("Exist"));
//     return;        
//    
//    } 
//   }

   string strGroup=((TextBox)(e.Item.Cells[5].Controls[0])).Text.Trim().ToString();
   
   if(!pageCommLibrary.bIsNumber(strGroup))
   {
    pageCommLibrary.showJSMsgInPage(this,"组"+comMessage.Create().GetMessage("IsNotNumber"));
    return;     
   }  
   
   mod.GroupIndex=strGroup;
   mod.PartNo=strPartNo;   
   mod.ID=strid;
   mod.ModD =  CommFunction.GetDataGridDate(e,this.dgPart.Columns.Count);
   mod.ModD.LastModifier=Session["LoginName"].ToString(); 

   bool bRest=biz.UpdataPartByID(mod);

   if(bRest)
   {
    ViewState["LogEvent"]=Const.EVENTLOG_UPDATE;
    new Log().LogData((ILogPage)this);
   
   }
   else
   {
    pageCommLibrary.showJSMsgInPage(this,comMessage.Create().GetMessage("UpdateFail"));
    return;  
   
   } 
           
   this.dgPart.EditItemIndex=-1;
   
   dataGridBind();
  
  }

  private void dgPart_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
  {
  
   if(ViewState["OrderBy"]!=null)
   {
    if(ViewState["OrderBy"].ToString()==e.SortExpression.ToString()+" desc")
     ViewState["OrderBy"]=e.SortExpression.ToString()+" asc";
    else
     ViewState["OrderBy"]=e.SortExpression.ToString()+" desc";
   }
   else
    ViewState["OrderBy"]=e.SortExpression.ToString()+" desc";

   dataGridBind();    
  }

  private void imgSearchNo_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  {  
   ViewState["SearchBy"]="No";
   this.dgPart.CurrentPageIndex=0;   
   dataGridBind();
  }

  private void imgSearchDesc_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  {
   ViewState["SearchBy"]="Desc";
   this.dgPart.CurrentPageIndex=0;    
   dataGridBind();
  
  }