点击按钮触发事件调用存储过程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();
}
}