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