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>");
}
}
