点击按钮触发事件调用存储过程1

protected void btnAdd_Click(object sender,EventArgs e)

{

  txtEmpID.Text = Coeno.Utility.String.CleanUpInput(txtEmpID.Text); 

  txtEmpName.Text= Coeno.Utility.String.CleanUpInput(txtEmpName.Text);

  txtEmpCardID.Text = Coeno.Utility.String.CleanUpInput(txtEmpCardID.Text);

       --(点击按钮触发事件调用存储过程2)

  string EmpCardID = txtEmpCardID.Text + "-" + txtEmpID.Text;

  if(string.IsNullOrEmpty(txtEmpID.Text))

  {

    lblMsg.Text = "工号不可为空";

    lblMsg.ForeColor = System.Drawing.Color.Red;

    return;

  }

  if(string.IsNullOrEmpty(txtEmpCard.Text))

  {

    lblMsg.Text="卡号不可为空";

    lblMsg.ForeColor=System.Drawing.Color.Red;

    return;

  }

  if(txtEmpCardID.Text.Length!=10)

  {

    lblMsg.Text="卡号必须是10位";

    lblMsg.ForeColor=System.Drawing.Color.Red;

    return;

  }

  string ReturnStatus = "";

     string ReturnID="";

  string ReturnMsg="";

  try

  {

     Coeno.GSManaweb.EmpCard.AddICCard(txtEmpID.Text,EmpCardID,txtEmpCardID.Text,txtCurrentEmpID.Text,out ReturnStatus,Out ReturnID,out ReturnMsg);

     --(点击按钮触发事件调用存储过程4)

    if(ReturnStatus=="1")

    {

      QueryCard();

      lblMsg.Text = ReturnMsg;

      lblMsg.ForeColor = System.Drawing.Color.Blue;

      

      txtEmpID.Text = " ";

      txtEmpCardID.Text = " ";

      txtEmpName.Text = " ";

      txtDeptID.Text = " ";

      txtDeptName.Text = “ ”; 

      return;

    }

    else

    {

      lblMsg.Text = ReturnMsg;

      lblMsg.ForeColor = System.Drawing.Color.Red;

      

      GVInfo.EditIndex = -1;

      QueryCard();

      return

    }

  }

  catch(Exception ed)

  {

    lblMsg.Text="卡號資料新增失敗"

    lblMsg.ForeColor = System.Drawing.Color.Red;

    QueryCard();

    return;

  }

}

--QueryCard

public void QueryCard()

{

  txtEmpID.Text = Coeno.Utility.String.CleanUpInput(txtEmpID.Text);

  txtEmpName.Text = Coeno.Utility.String.CleanUpInput(txtEmpName.Text);

  txtEmpCardID.Text = Coeno.Utility.String.CleanUpInput(txtEmpCardID.Text);

  if (string.IsNullOrEmpty(txtEmpID.Text)&&string.IsNullOrEmpty(txtEmpCardID.Text))

  {

    lblMsg.Text = "請至少輸入一個查詢條件";

    lblMsg.ForeColor = System.Drawing.Color.Red;

    return;

  }

  DataTable da = Coeno.GSManaweb.EmpCard.GetICCardInfo(txtEmpID.Text,txtEmpCardID.Text);

       --点击按钮触发事件调用存储过程6

  if(da.Row.Count>0)

  {

    GVInfo.DataSource = da;

    GVInfo.DataBind();

  }

  else

  {

    lblMsg.Text = "無相關資料";

    lblMsg.ForeColor = System.Drawing.Color.Red;

    GVInfo.DataSource = null;

    GVInfo.DataBind();

  }

 

}

原文地址:https://www.cnblogs.com/ximi07/p/11143387.html