employee/employee_Add.aspx.cs

（完整代码） 2KB 

 using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Text;
using System.Data.SqlClient;

public partial class employee_Add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
        
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (SqlHelper.Exists("select count(*) from employee where eno='" + txt_eno.Text + "'"))
        {
            MessageBox.Show(this, "该员工编号已存在！");
            return;
        }

        StringBuilder strSql = new StringBuilder();
         strSql.Append(@"insert into Employee ( eno,pwd,ename,sex,tel,castno,status,memo ) ");
        strSql.Append(@" values (@eno,@pwd,@ename,@sex,@tel,@castno,@status,@memo)");

        //设置参数
        SqlParameter[] parameters = new SqlParameter[] {
            new SqlParameter("@eno", SqlDbType.VarChar,20),
            new SqlParameter("@pwd", SqlDbType.VarChar,50),
            new SqlParameter("@ename", SqlDbType.VarChar,50),
            new SqlParameter("@sex", SqlDbType.VarChar,10),
            new SqlParameter("@tel", SqlDbType.VarChar,50),
            new SqlParameter("@castno", SqlDbType.VarChar,50),
            new SqlParameter("@status", SqlDbType.VarChar,20),
            new SqlParameter("@memo", SqlDbType.VarChar,500)        };

        parameters[0].Value =txt_eno.Text;
        parameters[1].Value =txt_pwd.Text;
        parameters[2].Value =txt_ename.Text;
        parameters[3].Value =rtsex.SelectedValue;
        parameters[4].Value =txt_tel.Text;
        parameters[5].Value =txt_castno.Text;
        parameters[6].Value =rdlstatus.SelectedValue;
        parameters[7].Value =txt_memo.Text;

        SqlHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
        MessageBox.ShowAndRedirect(this, "保存成功！", "employee_Add.aspx");

    }
}

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。