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 Button4_Click(object sender, EventArgs e)
{
bool xx = new DAL.RoomDAO().deleteAllRooms();
if (xx)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功！');", true);
re.Refresh("select * from Room order by num", "roomNum", GridView1);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除失败！');", true);
}
}
protected void Button200_Click(object sender, EventArgs e)
{
ideas.Style["display"] = "none";
bool yy = new DAL.RoomDAO().deleteRoomByNum(Session["delete"].ToString());
Session["delete"] = "";
if (yy)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功！');", true);
re.Refresh("select * from Room order by num", "roomNum", 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)
{
Button1.Visible = true;
Button4.Visible = true;
Button5.Visible = true;
ListBox1.Visible = true;
TextBox1.Visible = true;
}
else if (GridView1.Visible == false)
{
Button1.Visible = false;
Button4.Visible = false;
Button5.Visible = false;
ListBox1.Visible = false;
TextBox1.Visible = false;
}
TextBox10.Text = GridView1.Rows[xy].Cells[1].Text;
Model.Room pos = new DAL.RoomDAO().getRoomByNum(GridView1.Rows[xy].Cells[1].Text);
TextBox11.Text = pos.RoomName;
TextBox12.Text = pos.ChestMax.ToString();
string xx = pos.CreateTime.ToString();
string yy = pos.UpdateTime.ToString();
StringBuilder sb1 = new StringBuilder();
StringBuilder sb2 = new StringBuilder();
foreach (char x in xx)
{
if (Convert.ToInt32(x) != 32)
{
sb1.Append(x);
}
else if (Convert.ToInt32(x) == 32)
{
break;
}
}
foreach (char x in yy)
{
if (Convert.ToInt32(x) != 32)
{
sb2.Append(x);
}
else if (Convert.ToInt32(x) == 32)
{
break;
}
}
TextBox13.Text = pos.Remark;
TextBox14.Text = sb1.ToString();
TextBox15.Text = sb2.ToString();
TextBox1.ReadOnly = true;
}
if (e.CommandName == "deletee")
{
Model.Room delete = new Model.Room();
int x = Convert.ToInt32(e.CommandArgument);
delete.RoomNum = GridView1.Rows[x].Cells[1].Text;
ideas.Style["display"] = "inline";
Session["delete"] = delete.RoomNum;
}
}
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")
{
try
{
Model.Room add = new Model.Room();
DAL.Query nn = new DAL.Query();
int n = nn.query("room");
add.Num = (n + 1).ToString();
add.RoomNum = TextBox10.Text;
add.RoomName = TextBox11.Text;
add.M = qu.tiqu(TextBox12.Text).ToString();
add.Height = qu.tiqu(TextBox2.Text).ToString();
add.Remark = TextBox13.Text;
add.CreateTime = DateTime.Now;
add.UpdateTime = DateTime.Now;
bool xx = new DAL.RoomDAO().addRoom(add);
if (xx == true)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功！');", true);
Div1.Visible = false;
GridView1.Visible = true;
re.Refresh("select * from Room order by num", "roomNum", GridView1);
if (GridView1.Visible == true)
{
Button1.Visible = true;
Button5.Visible = true;
ListBox1.Visible = true;
TextBox1.Visible = true;
}
else if (GridView1.Visible == false)
{
Button1.Visible = false;
Button5.Visible = false;
ListBox1.Visible = false;
TextBox1.Visible = false;
Div1.Visible = true;
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败！');", true);
}
}
catch
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败！');", true);
}
}
else
{
Response.Write("<script>window.location.href='#div_kkk'</script>");
}
}
break;
case "确定":
{
Button btn = sender as Button;
Model.Room update = new Model.Room();
update.RoomNum = TextBox10.Text;
update.RoomName = TextBox11.Text;
update.M = qu.tiqu(TextBox12.Text).ToString();
update.Height = qu.tiqu(TextBox2.Text).ToString();
update.Remark = TextBox13.Text;
update.CreateTime = Convert.ToDateTime(TextBox14.Text);
update.UpdateTime = DateTime.Now;
bool xx = new DAL.RoomDAO().updateRoom(update);
if (xx)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功！');", true);
Div1.Visible = false;
GridView1.Visible = true;
re.Refresh("select * from Room order by num", "roomNum", GridView1);
if (GridView1.Visible == true)
{
Button1.Visible = true;
Button5.Visible = true;
ListBox1.Visible = true;
TextBox1.Visible = true;
}
else if (GridView1.Visible == false)
{
Button1.Visible = false;
Button5.Visible = false;
ListBox1.Visible = false;
TextBox1.Visible = false;
Div1.Visible = true;
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败！');", true);
}
}
break;
}
}