protected void Button4_Click(object sender, EventArgs e) { DAL.StaffDAO DeleteAll = new DAL.StaffDAO(); bool xx = DeleteAll.deleteAllStaffs();//删除所有员工 if (xx) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功!');", true); Div1.Visible = false; GridView1.Visible = true; if (GridView1.Visible == true) { Button2.Visible = true; Button4.Visible = true; Button3.Visible = true; ListBox9.Visible = true; TextBox6.Visible = true; } else if (GridView1.Visible == false) { Button2.Visible = false; Button4.Visible = false; Button3.Visible = false; ListBox9.Visible = false; TextBox6.Visible = false; } rg.Refresh("select * from Staff order by num", "staffNum", GridView1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除失败!');", true); } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { A6.InnerText = ">>"; A7.InnerText = "编辑员工"; if (e.CommandName == "editt") { int xy = Convert.ToInt32(e.CommandArgument); Div1.Visible = true; Button9.Text = "确定"; GridView1.Visible = false; if (GridView1.Visible == true) { Button2.Visible = true; Button4.Visible = true; Button3.Visible = true; ListBox9.Visible = true; TextBox6.Visible = true; } else if (GridView1.Visible == false) { Button2.Visible = false; Button4.Visible = false; Button3.Visible = false; ListBox9.Visible = false; TextBox6.Visible = false; } TextBox1.Text = GridView1.Rows[xy].Cells[1].Text; Model.staff pos = new DAL.StaffDAO().getStaffByNum(GridView1.Rows[xy].Cells[1].Text); TextBox2.Text = pos.StaffName; TextBox3.Text = pos.DepartId; ListBox7.Text = pos.Gender; TextBox7.Text = pos.IdCard; TextBox8.Text = pos.PhoneNumber; } if (e.CommandName == "deletee") { Model.Room delete = new Model.Room(); int x = Convert.ToInt32(e.CommandArgument); delete.RoomNum = GridView1.Rows[x].Cells[1].Text; bool yy = new DAL.RoomDAO().deleteRoomByNum(delete.RoomNum); if (yy) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功!');", true); rg.Refresh("select * from Room", "roomNum", GridView1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除失败!');", true); } } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "editt") { Div1.Style["display"] = "inline"; int xy = Convert.ToInt32(e.CommandArgument); Button9.Text = "确定"; GridView1.Visible = false; if (GridView1.Visible == true) { Button1.Visible = true; Button4.Visible = true; Button5.Visible = true; ListBox1.Visible = true; TextBox5.Visible = true; } else if (GridView1.Visible == false) { Button1.Visible = false; Button4.Visible = false; Button5.Visible = false; ListBox1.Visible = false; TextBox5.Visible = false; } TextBox1.Text = GridView1.Rows[xy].Cells[1].Text; TextBox2.Text = GridView1.Rows[xy].Cells[2].Text; //TextBox3.Text = GridView1.Rows[xy].Cells[3].Text; //TextBox4.Text = GridView1.Rows[xy].Cells[4].Text; Model.Department de = new Model.Department(); Model.staff st = new Model.staff(); de = new DAL.DepartmentDAO().getDepartById(GridView1.Rows[xy].Cells[3].Text); st = new DAL.StaffDAO().getStaffByNum(GridView1.Rows[xy].Cells[4].Text); TextBox3.Text = de.DepartName; TextBox4.Text = st.StaffName; Image11.Visible = true; Image11.ImageUrl = "~/Image/对号.png"; Image12.Visible = true; Image12.ImageUrl = "~/Image/对号.png"; Image1.Visible = true; Image1.ImageUrl = "~/Image/对号.png"; Image2.Visible = true; Image2.ImageUrl = "~/Image/对号.png"; rl.Refresh3("departId", "departName", "Department", TextBox1.Text, ListBox2); } if (e.CommandName == "deletee") { ideas.Style["display"] = "inline"; int x = Convert.ToInt32(e.CommandArgument); Session["e"] = x; } }
protected void Button30_Click(object sender, EventArgs e) { Button btn = (Button)sender; Model.staff staff = new Model.staff(); GridViewRow row = (GridViewRow)btn.NamingContainer; staff.StaffNum = row.Cells[0].Text; bool xx = new DAL.StaffDAO().deleteStaffByNum(staff.StaffNum); if (xx) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功!');", true); Response.Redirect(Request.Url.ToString()); rg.Refresh("select * from Staff order by num", "staffNum", GridView1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除失败!');", true); } }
protected void Button9_Click(object sender, EventArgs e) { switch (Button9.Text) { case "增加": { if (Image1.ImageUrl == "~/Image/对号.png" && Image2.ImageUrl == "~/Image/对号.png" && Image3.ImageUrl == "~/Image/对号.png" && Image4.ImageUrl == "~/Image/对号.png" && Image5.ImageUrl == "~/Image/对号.png" && Image6.ImageUrl == "~/Image/对号.png" && Image7.ImageUrl == "~/Image/对号.png" && Image8.ImageUrl == "~/Image/对号.png") { Model.staff staff = new Model.staff(); DAL.Query qu = new DAL.Query(); int n = qu.query("staff"); staff.Num = (n + 1).ToString(); staff.StaffNum = TextBox1.Text; staff.StaffName = TextBox2.Text; staff.DepartId = TextBox3.Text; staff.Birthday = Convert.ToDateTime(ListBox2.Text + "/" + ListBox3.Text + "/" + ListBox4.Text); staff.Gender = ListBox7.Text; staff.Hometown = ListBox5.SelectedItem.Text + TextBox4.Text; staff.IdCard = TextBox7.Text; staff.PhoneNumber = TextBox8.Text; staff.EntryTime = DateTime.Now; bool xx = new DAL.StaffDAO().addStaff(staff); if (xx == true) //添加一个员工 { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');", true); Div1.Visible = false; GridView1.Visible = true; if (GridView1.Visible == true) { Button2.Visible = true; Button4.Visible = true; Button3.Visible = true; ListBox9.Visible = true; TextBox6.Visible = true; } else if (GridView1.Visible == false) { Button2.Visible = false; Button4.Visible = false; Button3.Visible = false; ListBox9.Visible = false; TextBox6.Visible = false; } rg.Refresh("select * from Staff order by num", "staffNum", GridView1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败!');", true); Div1.Visible = false; GridView1.Visible = true; if (GridView1.Visible == true) { Button2.Visible = true; Button4.Visible = true; Button3.Visible = true; ListBox9.Visible = true; TextBox6.Visible = true; } else if (GridView1.Visible == false) { Button2.Visible = false; Button4.Visible = false; Button3.Visible = false; ListBox9.Visible = false; TextBox6.Visible = false; } } } else { Response.Write("<script>window.location.href='#div_kkk'</script>"); } } break; case "确定": { Button btn = sender as Button; Model.staff staff = new Model.staff(); staff.StaffNum = TextBox1.Text; staff.StaffName = TextBox2.Text; staff.DepartId = TextBox3.Text; staff.Birthday = Convert.ToDateTime(ListBox2.Text + "/" + ListBox3.Text + "/" + ListBox4.Text); staff.Gender = ListBox7.Text; //staff.Hometown = ListBox5.SelectedValue + TextBox4.Text; staff.IdCard = TextBox7.Text; staff.PhoneNumber = TextBox8.Text; bool xx = new DAL.StaffDAO().updateStaff(staff); if (xx) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功!');", true); Div1.Visible = false; GridView1.Visible = true; if (GridView1.Visible == true) { Button2.Visible = true; Button4.Visible = true; Button3.Visible = true; ListBox9.Visible = true; TextBox6.Visible = true; } else if (GridView1.Visible == false) { Button2.Visible = false; Button4.Visible = false; Button3.Visible = false; ListBox9.Visible = false; TextBox6.Visible = false; } rg.Refresh("select * from Staff order by num", "staffNum", GridView1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败!');", true); } } break; } }