/// <summary> /// 添加一个库位类型.库位类型ID是主键. /// </summary> /// <param name="posity">库位类型对象.</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool addPositionType(Model.PositionType posity) { string sqltext = "insert positiontype(num,positionTypeId,positionTypeName,length,width,height,remark) values(@num,@positionTypeId,@positionTypeName,@length,@width,@height,@remark)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara = new SqlParameter("@num", posity.Num); SqlParameter sqlpara1 = new SqlParameter("@positionTypeId", posity.PositionTypeId); SqlParameter sqlpara2 = new SqlParameter("@positionTypeName", posity.PositionTypeName); SqlParameter sqlpara3 = new SqlParameter("@length", posity.Length); SqlParameter sqlpara4 = new SqlParameter("@width", posity.Width); SqlParameter sqlpara5 = new SqlParameter("@height", posity.Height); SqlParameter sqlpara6 = new SqlParameter("@remark", posity.Remark); para.Add(sqlpara); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个库位.库位ID不可更改. /// </summary> /// <param name="posity">库位类型对象.</param> public bool updatePositionType(Model.PositionType posity) { string sqltext = "update positiontype set positionTypeName=@positionTypeName,length=@length,width=@width,height=@height,remark=@remark where positionTypeId=@positionTypeId"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@positionTypeId", posity.PositionTypeId); SqlParameter sqlpara2 = new SqlParameter("@positionTypeName", posity.PositionTypeName); SqlParameter sqlpara3 = new SqlParameter("@length", posity.Length); SqlParameter sqlpara4 = new SqlParameter("@width", posity.Width); SqlParameter sqlpara5 = new SqlParameter("@height", posity.Height); SqlParameter sqlpara6 = new SqlParameter("@remark", posity.Remark); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
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); } } }
/// <summary> /// 获取所有的库位类型. /// </summary> /// <returns>库位类型对象泛型集合.</returns> public List <Model.PositionType> getAllPositionsType() { List <Model.PositionType> posity = new List <Model.PositionType>(); string sqltext = "select * from positiontype"; SqlDataReader sdr = DBTools.exereaderSQL(sqltext, new List <SqlParameter>()); while (sdr.Read()) { Model.PositionType p = new Model.PositionType(); p.PositionTypeId = sdr["positionTypeId"].ToString(); p.PositionTypeName = sdr["positionTypeName"].ToString(); p.Length = sdr["length"].ToString(); p.Width = sdr["width"].ToString(); p.Height = sdr["height"].ToString(); p.Remark = sdr["remark"].ToString(); posity.Add(p); } sdr.Close(); DBTools.DBClose(); return(posity); }
/// <summary> /// 通过ID找到库位类型. /// </summary> /// <param name="iid">库位类型ID.</param> public Model.PositionType getPositionTypeByid(string iid) { Model.PositionType p = null; string sqltext = "select * from positiontype where positionTypeId=@positionTypeId"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@positionTypeId", iid); para.Add(sqlpara1); SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para); while (sdr.Read()) { p = new Model.PositionType(); p.PositionTypeId = sdr["positionTypeId"].ToString(); p.PositionTypeName = sdr["positionTypeName"].ToString(); p.Length = sdr["length"].ToString(); p.Width = sdr["width"].ToString(); p.Height = sdr["height"].ToString(); p.Remark = sdr["remark"].ToString(); } sdr.Close(); DBTools.DBClose(); return(p); }
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; } }