protected void Button1_Click(object sender, EventArgs e) { try { if (Session["id"] != null) { int id = Int32.Parse(Session["id"].ToString()); TeacherComm context = new TeacherComm(); var task = new keti(); task.title = t_title.Text; task.people = t_people.Text; task.shenbaodate = Convert.ToDateTime(t_shen.Text); task.startdate = Convert.ToDateTime(t_start.Text); task.enddate = Convert.ToDateTime(t_end.Text); task.gonghao = id; context.keti.Add(task); context.SaveChanges(); Response.Write("<script>alert('添加成功!');window.location.href='task_info.aspx';</script>"); } } catch { Response.Write("<script>alert('添加成失败!')</script>"); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int t_gonghao = Int32.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString()); TeacherComm context = new TeacherComm(); var t_rongyu = context.rongyu.Where(x => x.gonghao == t_gonghao).FirstOrDefault(); if (t_rongyu != null) { context.rongyu.Remove(t_rongyu); } var t_keti = context.keti.Where(x => x.gonghao == t_gonghao).FirstOrDefault(); if (t_keti != null) { context.keti.Remove(t_keti); } var user = context.teacher.Where(x => x.gonghao == t_gonghao).FirstOrDefault(); context.teacher.Remove(user); context.SaveChanges(); Response.Redirect("/web/admins_layout/usertype_info.aspx"); } catch { Response.Write("<script>alert('删除失败!');window.location.href='usertype_info.aspx';</script>"); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int xibuid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString()); TeacherComm context = new TeacherComm(); var user = context.teacher.Where(x => x.xibuId == xibuid).FirstOrDefault(); int t_id = 0; if (user != null) { t_id = user.gonghao; } var t_rongyu = context.rongyu.Where(x => x.gonghao == t_id).FirstOrDefault(); if (t_rongyu != null) { context.rongyu.Remove(t_rongyu); } var t_keti = context.keti.Where(x => x.gonghao == t_id).FirstOrDefault(); if (t_keti != null) { context.keti.Remove(t_keti); } if (user != null) { context.teacher.Remove(user); } var xibu = context.xibu.Where(x => x.ID == xibuid).FirstOrDefault(); context.xibu.Remove(xibu); context.SaveChanges(); Response.Write("<script>alert('删除成功!');window.location.href='xibu_info.aspx';</script>"); }
protected void Button1_Click(object sender, EventArgs e) { TeacherComm context = new TeacherComm(); int id = Int32.Parse(Session["id"].ToString()); //var user = context.teacher.Where(x => x.gonghao == id).FirstOrDefault(); var user = context.teacher.Find(id); try { user.gonghao = Int32.Parse(t_number.Text.Trim()); user.name = t_name.Text; user.name2 = t_name2.Text; user.sex = t_sex.SelectedValue; user.shenfennu = t_category.Text.Trim(); user.jiguan = t_jiguan.Text; user.minzu = t_minzu.Text; user.hunyin = t_hunyiin.SelectedValue; //var aa = Request["t_worktime"].ToString(); user.worktime = Convert.ToDateTime(t_worktime.Text); //var bb = Request["t_birthday"].ToString(); user.birthday = Convert.ToDateTime(t_birthday.Text); user.birthplace = t_birthplace.Text; user.zhengzhi = t_zhengzhi.Text; user.jiankang = t_health.Text; user.teachertype = t_cate.SelectedValue; user.cellphone = t_phone.Text; user.mail = t_mail.Text; context.SaveChanges(); Response.Write("<script>alert('保存成功!')</script>"); } catch { Response.Write("<script>alert('保存失败!!!')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { int id = Int32.Parse(Request.QueryString["gonghao"].ToString()); TeacherComm context = new TeacherComm();; var user = context.teacher.Where(x => x.gonghao == id).FirstOrDefault(); user.usertype = t_usertype.SelectedValue; context.SaveChanges(); Response.Write("<script>alert('修改成功!')</script>"); }
protected void btn_1_Click(object sender, EventArgs e) { TeacherComm context = new TeacherComm(); var xibu = new xibu(); xibu.xibuNa = t_xibuna.Text; context.xibu.Add(xibu); context.SaveChanges(); Response.Write("<script>alert('添加成功');window.location.href='xibu_info.aspx';</script>"); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { TeacherComm context = new TeacherComm(); int idd = int.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString()); var task = context.keti.Where(x => x.id == idd).FirstOrDefault(); context.keti.Remove(task); context.SaveChanges(); Response.Write("<script>alert('删除成功!');window.location.href='task_info.aspx';</script>"); } catch { Response.Write("<script>alert('删除失败!')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { try { int idd = Int32.Parse(Request.QueryString["idd"].ToString()); TeacherComm context = new TeacherComm(); var xibu = context.xibu.Where(x => x.ID == idd).FirstOrDefault(); xibu.xibuNa = t_xibuna.Text.Trim(); context.SaveChanges(); Response.Write("<script>alert('保存成功!');window.location.href='xibu_info.aspx';</script>"); } catch { Response.Write("<script>alert('保存失败!')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { if (Session["id"] != null) { int id = Int32.Parse(Session["id"].ToString()); string na = DropDownList1.SelectedValue; TeacherComm context = new TeacherComm(); var xibu_ = context.xibu.Where(x => x.xibuNa == na).FirstOrDefault(); int idd = xibu_.ID; var user = context.teacher.Where(x => x.gonghao == id).FirstOrDefault(); user.classname = t_class.Text; user.project = t_kemu.Text; user.xibuId = idd; user.season = t_xueqi.SelectedValue; context.SaveChanges(); Response.Write("<script>alert('保存成功!!!')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { try { if (Session["id"] != null) { int id = Int32.Parse(Session["id"].ToString()); TeacherComm context = new TeacherComm(); var user = context.teacher.Where(x => x.gonghao == id).FirstOrDefault(); user.twork = TextBox1.Text; context.SaveChanges(); Response.Write("<script>alert('编辑成功!')</script>"); } } catch { Response.Write("<script>alert('编辑失败!')</script>"); } }
protected void btn_1_Click(object sender, EventArgs e) { if (Session["id"] != null) { int id = Int32.Parse(Session["id"].ToString()); TeacherComm context = new TeacherComm(); var user = context.teacher.Where(x => x.gonghao == id).FirstOrDefault(); if (t_pwd.Text == user.pwd) { user.pwd = t_pwd2.Text; context.SaveChanges(); Session.Remove("id"); Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('密码不正确!')</script>"); } } }
protected void h_add_Click(object sender, EventArgs e) { try { if (Session["id"] != null) { int id = Int32.Parse(Session["id"].ToString()); TeacherComm context = new TeacherComm(); var honor = new rongyu(); honor.gonghao = id; honor.Adddate = Convert.ToDateTime(h_date.Text); honor.text = h_name.Text; context.rongyu.Add(honor); context.SaveChanges(); Response.Write("<script>alert('添加成功!');window.location.href='honor_info.aspx';</script>"); } } catch { Response.Write("<script>alert('添加失败!')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { try { TeacherComm context = new TeacherComm(); string xibuna = t_xibu.SelectedValue; var xibu = context.xibu.Where(x => x.xibuNa == xibuna).FirstOrDefault(); int xibuid = xibu.ID; var user = new teacher(); user.gonghao = Int32.Parse(t_gonghao.Text); user.name = t_name.Text; user.pwd = t_pwd.Text; user.sex = t_sex.SelectedValue; user.usertype = t_usertype.Text; user.xibuId = xibuid; context.teacher.Add(user); context.SaveChanges(); Response.Write("<script>alert('用户添加成功!');window.location.href=usertype_info.aspx';</script>"); } catch { Response.Write("<script>alert('用户添加失败!')</script>"); } }