protected void Button200_Click(object sender, EventArgs e) { Model.Position delete = new Model.Position(); int x = Convert.ToInt32(Session["e"]); delete.PositionNum = GridView1.Rows[x].Cells[1].Text; Warehouse.Tools.queryV qu = new Tools.queryV(); Warehouse.Tools.apartV qp = new Tools.apartV(); string chestNum = qu.query("select chestNum from Position where PositionNum='" + delete.PositionNum + "' "); string positionM = qu.query("select M from Position where PositionNum='" + delete.PositionNum + "' "); string M = qu.query("select M from Chest where chestNum='" + chestNum + "' "); bool yy = new DAL.PositionDAO().deletePositionByNum(delete.PositionNum); if (yy) { Warehouse.Tools.updateChestM up = new Tools.updateChestM(); double bb = (Convert.ToDouble(qp.apart(M)) + Convert.ToDouble(qp.apart(positionM))); up.update((bb.ToString() + "平方米"), chestNum); ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功!');", true); ideas.Style["display"] = "none"; pg.Refresh("select num,positionNum,chestNum,roomNum,positionTypeId,goodsTypes,M,remark from Position", "positionNum", GridView1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除失败!');", true); ideas.Style["display"] = "none"; } }
protected void Button6_Click(object sender, EventArgs e) { switch (Button6.Text) { case "增加": { Warehouse.Tools.queryV qu = new Tools.queryV(); Warehouse.Tools.apartV ap = new Tools.apartV(); Warehouse.Tools.tiqushuzi quu = new Tools.tiqushuzi(); string L = qu.query("select length from PositionType where PositionTypeId='" + TextBox7.Text + "' "); string W = qu.query("select width from PositionType where PositionTypeId='" + TextBox7.Text + "' "); string H = qu.query("select height from PositionType where PositionTypeId='" + TextBox7.Text + "' "); double a = double.Parse(qu.query("select M from Chest where chestNum='" + TextBox2.Text + "'")); double b = double.Parse(qu.query("select Height from Chest where chestNum='" + TextBox2.Text + "'")); double c = a * b - new Warehouse.Tools.positionSum().Sum(TextBox2.Text); if ((quu.tiqu(L) * quu.tiqu(W) * (quu.tiqu(H)) < c)) { try { DAL.Query nn = new DAL.Query(); int n = nn.query("position"); string nnn = ""; Model.Position add = new Model.Position(); add.Num = (n + 1).ToString(); add.PositionNum = TextBox1.Text; add.ChestNum = TextBox2.Text; add.RoomNum = TextBox3.Text; add.PositiontypeId = TextBox7.Text; add.M = (Convert.ToDouble(ap.apart(L)) * Convert.ToDouble(ap.apart(W))).ToString(); add.Height = (Convert.ToDouble(ap.apart(H))).ToString(); Warehouse.Tools.tiqushuzi tiqu = new Tools.tiqushuzi(); add.Rest = (tiqu.tiqu(add.M) * tiqu.tiqu(add.Height)).ToString(); for (int i = 0; i < ListBox3.Items.Count; i++) { if (nnn == "") { nnn += ListBox3.Items[i].Text; } else { nnn += "、" + ListBox3.Items[i].Text; } } add.GoodsTypes = nnn; add.Remark = TextBox6.Text; add.CreateTime = DateTime.Now; add.UpdateTime = DateTime.Now; bool xx = new DAL.PositionDAO().addPosition(add); //if (xx == true) //{ // double kk = Convert.ToDouble(ap.apart(qu.query("select M from Chest where chestNum='" + TextBox2.Text + "' "))) - (Convert.ToDouble(ap.apart(L)) * Convert.ToDouble(ap.apart(W))); // Warehouse.Tools.updateChestM up = new Tools.updateChestM(); // up.update(kk + "m²", TextBox2.Text); ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');window.location.href='管理库位.aspx'", true); //} } catch { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败!');", true); } } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败,最大体积为" + (a * b - new Warehouse.Tools.positionSum().Sum(TextBox1.Text)) + "!');", true); } } break; case "确定": { Button btn = sender as Button; Model.Position update = new Model.Position(); update.PositionNum = TextBox1.Text; update.ChestNum = TextBox2.Text; update.RoomNum = TextBox3.Text; update.PositiontypeId = TextBox7.Text; string nnn = ""; for (int bbb = 0; bbb < ListBox3.Items.Count; bbb++) { if (nnn == "") { nnn += ListBox3.Items[bbb].Text; } else { nnn += "、" + ListBox3.Items[bbb].Text; } } update.GoodsTypes = nnn; update.Remark = TextBox6.Text; update.UpdateTime = DateTime.Now; bool xx = new DAL.PositionDAO().updatePosition(update); if (xx) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功!');", true); pg.Refresh("select num,positionNum,chestNum,roomNum,positionTypeId,goodsTypes,M,remark from Position", "positionNum", GridView1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败!');", true); } } break; } }
protected void Button9_Click(object sender, EventArgs e) { switch (Button9.Text) { case "增加": { Warehouse.Tools.apartV ap = new Tools.apartV(); Warehouse.Tools.queryV qu = new Tools.queryV(); double xxx = new Warehouse.Tools.chestSum().Sum(ListBox2.SelectedItem.Value); double yy = Convert.ToDouble(quu.tiqu(new Warehouse.Tools.queryV().query("select M from Room where roomNum='" + ListBox2.SelectedItem.Value + "'"))) * Convert.ToDouble(quu.tiqu(new Warehouse.Tools.queryV().query("select Height from Room where roomNum='" + ListBox2.SelectedItem.Value + "'"))); if (yy - xxx >= Convert.ToDouble(quu.tiqu(TextBox12.Text)) * Convert.ToDouble(quu.tiqu(TextBox2.Text))) { if (Image1.ImageUrl == "~/Image/对号.png" && Image2.ImageUrl == "~/Image/对号.png" && Image3.ImageUrl == "~/Image/对号.png" && Image4.ImageUrl == "~/Image/对号.png" && Image5.ImageUrl == "~/Image/对号.png") { try { Model.Chest add = new Model.Chest(); DAL.Query nn = new DAL.Query(); int n = nn.query("chest"); add.Num = (n + 1).ToString(); add.ChestNum = TextBox10.Text; add.ChestName = TextBox11.Text; add.M = quu.tiqu(TextBox12.Text).ToString(); add.Height = quu.tiqu(TextBox2.Text).ToString(); add.RoomNum = TextBox13.Text; add.Remark = TextBox14.Text; add.CreateTime = DateTime.Now; add.UpdateTime = DateTime.Now; bool xx = new DAL.ChestDAO().addChest(add); if (xx == true) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');", true); Div1.Visible = false; GridView1.Visible = true; rg.Refresh("select * from Chest order by num", "chestNum", 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); } } catch { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败!');", true); } } else { Response.Write("<script>window.location.href='#div_kkk'</script>"); } } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('可放位置不足,请选择其他房间或总体积小于" + (yy - xxx).ToString() + "!');", true); } } break; case "确定": { Button btn = sender as Button; Model.Chest update = new Chest(); update.ChestNum = TextBox10.Text; update.ChestName = TextBox11.Text; update.M = quu.tiqu(TextBox12.Text).ToString(); update.Height = quu.tiqu(TextBox2.Text).ToString(); update.RoomNum = TextBox13.Text; update.Remark = TextBox14.Text; update.CreateTime = Convert.ToDateTime(TextBox15.Text); update.UpdateTime = DateTime.Now; bool xx = new DAL.ChestDAO().updateChest(update); if (xx && (Image1.ImageUrl == "~/Image/对号.png" && Image2.ImageUrl == "~/Image/对号.png" && Image3.ImageUrl == "~/Image/对号.png" && Image4.ImageUrl == "~/Image/对号.png" && Image5.ImageUrl == "~/Image/对号.png")) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功!');", true); Div1.Visible = false; GridView1.Visible = true; rg.Refresh("select * from Chest order by num", "chestNum", 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; } } }