protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "editt") { Image1.Visible = true; Image2.Visible = true; Image3.Visible = true; Image4.Visible = true; Image5.Visible = true; Image6.Visible = true; 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.PositionType pos = new DAL.PositionTypeDAO().getPositionTypeByid(GridView1.Rows[xy].Cells[1].Text); TextBox11.Text = pos.PositionTypeName; TextBox12.Text = pos.Length; TextBox13.Text = pos.Width; TextBox14.Text = pos.Height; TextBox15.Text = pos.Remark; TextBox10.ReadOnly = true; } if (e.CommandName == "deletee") { Model.PositionType delete = new Model.PositionType(); int x = Convert.ToInt32(e.CommandArgument); delete.PositionTypeId = GridView1.Rows[x].Cells[1].Text; bool yy = new DAL.ChestDAO().deleteChestByNum(delete.PositionTypeId); if (yy) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功!');", true); rg.Refresh("select * from Positiontype order by num", "PositionTypeId", GridView1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除失败!');", true); } } }
protected void Button4_Click(object sender, EventArgs e) { bool xx = new DAL.PositionTypeDAO().deleteAllPositionsType(); if (xx) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功!');", true); rg.Refresh("select * from Positiontype order by num", "PositionTypeId", 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") { try { Model.PositionType add = new Model.PositionType(); DAL.Query nn = new DAL.Query(); int n = nn.query("Positiontype"); add.Num = (n + 1).ToString(); add.PositionTypeId = TextBox10.Text; add.PositionTypeName = TextBox11.Text; add.Length = TextBox12.Text; add.Width = TextBox13.Text; add.Height = TextBox14.Text; add.Remark = TextBox15.Text; bool xx = new DAL.PositionTypeDAO().addPositionType(add); if (xx == true) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');", true); Div1.Visible = false; GridView1.Visible = true; rg.Refresh("select * from Positiontype order by num", "PositionTypeId", GridView1); 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; Div1.Visible = true; } } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败!');", true); } //Response.Redirect(Request.Url.ToString()); } catch { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败!');", true); } } } break; case "确定": { Button btn = sender as Button; Model.PositionType update = new Model.PositionType(); update.PositionTypeId = TextBox10.Text; update.PositionTypeName = TextBox11.Text; update.Length = TextBox12.Text; update.Width = TextBox13.Text; update.Height = TextBox14.Text; update.Remark = TextBox15.Text; bool xx = new DAL.PositionTypeDAO().updatePositionType(update); if (xx) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功!');", true); Div1.Visible = false; GridView1.Visible = true; rg.Refresh("select * from Positiontype order by num", "PositionTypeId", GridView1); 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; Div1.Visible = true; } } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败!');", true); } } break; } }