//员工离职状态 protected void JobStatus_Click(object sender, EventArgs e) { string username = off_username.Text.Trim(); //用户名 string jobStatus = Request.Form["jobstatus"].ToString().Trim(); //工作状态 //查找是否有此用户 string[] pwd = new string[1]; string[] list01 = { "password" }; sqlTable st = new sqlTable(); st.select_onjob(username, pwd, "Login", list01); if (pwd[0] == "NULL" || pwd[0] == "null") { Response.Write("<script>alert('员工姓名输入有误,请重新输入')</script>"); } else { //更新状态 string[] list = { "on_job" }; string[] source = { jobStatus }; string[] selectList = { "name" }; string[] selectSource = { username }; int res = st.table_update("Login", list, source, selectList, selectSource); if (res == 1) { Response.Write("<script>alert('修改成功')</script>"); Page_Load(sender, e); } else { Response.Write("<script>alert('语法错误')</script>"); } } }