usingSystem.Collections;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
usingSystem.Text;
usingMaticsoft.Common;
usingLTP.Accounts.Bus;
usingSystem;
namespaceMaticsoft.Web.Employees
{
  publicpartialclassMYAdd:Page
  {
    protectedvoidPage_Load(objectsender,EventArgse)
    {
 
    }
    
 
    protectedvoidButtonOK_Click(objectsender,EventArgse)
    {
      stringERRM ="";
      if(!PageValidate.IsNumber(Temployeeid.Text.Trim()))
      {
        ERRM +="输入的id不是数字，不合法！";
      }
      if(this.Temployeeid.Text.Trim().Length ==0)
      {
        ERRM +="用户id不能为空！";
      }
      if(ERRM !="")
      {
        MessageBox.Show(this, ERRM);
        ERRM ="";
        return;
      }      intEmployeeID =int.Parse(this.Temployeeid.Text);      /
      stringEmployeesName =this.Temployeename.Text;
      Maticsoft.Model.Employeesmodel =newModel.Employees();         //新建一个在dal层Employees的model对象，用于对数据库Employees表的数据处理
      model.EmployeeID = EmployeeID;                                 //将text里面用户输入的id数据传给model
      model.EmployeesName = EmployeesName;                          //将text里面用户输入的name数据传给model
      Maticsoft.BLL.Employeesbll =newBLL.Employees();               //新建一个在bll层的employees对象，用于调用dal层的model对象
      bll.Add(model);                                                  //在bll层调用add方法添加一条数据                                  
 
//////////////////////////////////////  bll层的add 方法  ///////////////////////////////////////////////////////////////////////////
         /// 增加一条数据       
                publicboolAdd(Maticsoft.Model.Employeesmodel)
                {
                        returndal.Add(model);                     //调用dal层的add方法添加一条数据
                }
 
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
 
 
 
 
////////////////////////////////////// dal层的 add 方法  ///////////////////////////////////////////////////////////////////////////
      ///增加一数据
                publicboolAdd(Maticsoft.Model.Employeesmodel)
                {
                        StringBuilderstrSql=newStringBuilder();
                        strSql.Append("insert into Employees(");
                        strSql.Append("EmployeeID,EmployeesName)");
                        strSql.Append(" values (");
                        strSql.Append("@EmployeeID,@EmployeesName)");
                        SqlParameter[] parameters = {
                                        newSqlParameter("@EmployeeID",SqlDbType.Int,4),
                                        newSqlParameter("@EmployeesName",SqlDbType.VarChar,90)};
                        parameters[0].Value = model.EmployeeID;
                        parameters[1].Value = model.EmployeesName;
 
                        introws=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
                        if(rows >0)
                        {
                                returntrue;
                        }
                        else
                        {
                                returnfalse;
                        }
                }
 
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
      Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功|！","MYAdd.aspx");           //成功创建后弹出对话框，并跳转到当前页面！
 
    }
 
    protectedvoidButtonNo_Click(objectsender,EventArgse)
    {
      Response.Redirect("list.aspx");
    }
  
  }
}