protected void Button66_Click(object sender, EventArgs e)
{
Model.Outout add = new Model.Outout();
if (Button66.Text == "增加")
{
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")
{
Warehouse.Tools.queryV qq = new Tools.queryV();
DAL.Query quu = new DAL.Query();
int n = quu.query("Outout");
add.Num = n + 1;
add.OuID = TextBox11.Text;
add.GoodsNum = TextBox12.Text;
add.PositionNum = TextBox9.Text;
add.OutAmount = Convert.ToDouble(TextBox2.Text);
add.BatchNum = TextBox3.Text;
add.Date = Convert.ToDateTime(TextBox4.Text);
add.UserId = qu.query("select staffNum from Staff where staffName='" + TextBox5.Text + "'");
add.Remark = TextBox6.Text;
bool xx = new DAL.OutoutDAO().addOut(add);
if (xx)
{
Model.Amount update = new Model.Amount();
update.Amounts = Convert.ToDouble(Session["max"].ToString()) - Convert.ToDouble(add.OutAmount);
double d = Convert.ToDouble(Session["V"].ToString()) / Convert.ToDouble(Session["max"].ToString());
update.V = (update.Amounts * d).ToString();
update.GoodsNum = TextBox12.Text;
update.PositionNum = TextBox9.Text;
update.Vp = d.ToString();
bool yy = new DAL.AmountDAO().update(update);
if (yy)
{
double rest = Convert.ToDouble(qu.query("select Rest from Position where positionNum='" + TextBox9.Text + "'"));
Model.Position Update = new Model.Position();
Update.Rest = (rest + d * add.OutAmount).ToString();
Update.PositionNum = TextBox9.Text;
bool cc = new DAL.PositionDAO().update(Update);
}
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');window.location.href='出库登记.aspx'", true);
}
}
}
}
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;
}
}
}
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;
}
}
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;
}
}
protected void Button66_Click(object sender, EventArgs e)
{
if (Button66.Text == "增加")
{
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")
{
Warehouse.Tools.queryV qq = new Tools.queryV();
Model.Inin add = new Model.Inin();
DAL.Query qu = new DAL.Query();
int n = qu.query("Inin");
add.Num = n + 1;
add.InID = TextBox11.Text;
add.PositionNum = TextBox9.Text;
add.GoodsNum = TextBox12.Text;
add.InAmount = double.Parse(TextBox2.Text);
add.V = (Convert.ToDouble(tiqu.tiqu(TextBox2.Text)) * Convert.ToDouble(tiqu.tiqu(TextBox7.Text))).ToString();
add.BatchNum = TextBox3.Text;
add.Date = DateTime.Now;
add.UserId = TextBox5.Text;
add.Remark = TextBox6.Text;
bool xx = new DAL.IninDAO().addIn(add);
if (xx)
{
if ((Convert.ToInt32(new Warehouse.Tools.queryV().query("select count(*) from Amount where goodsNum='" + add.GoodsNum + "' and PositionNum ='" + add.PositionNum + "' ")) > 0) && (Convert.ToInt32(new Warehouse.Tools.queryV().query("select count(*) from Amount where Vp='" + (tiqu.tiqu(TextBox7.Text)).ToString() + "' "))) > 0)
{
Model.Amount addd = new Model.Amount();
addd.Num = Convert.ToInt32(new Warehouse.Tools.queryV().query("select count(*) from Amount where 1=1 ")) + 1;
addd.GoodsNum = add.GoodsNum;
addd.PositionNum = add.PositionNum;
addd.Vp = (tiqu.tiqu(TextBox7.Text)).ToString();
addd.Amounts = add.InAmount + Convert.ToDouble(new Warehouse.Tools.queryV().query("select amount from Amount where goodsNum='" + add.GoodsNum + "' and PositionNum ='" + add.PositionNum + "' "));
switch (new Warehouse.Tools.queryV().query("select goodsStyle from Goods where goodsNum='" + add.GoodsNum + "'").ToString())
{
case "固态": addd.AmountPer = "Kg"; break;
case "液态": addd.AmountPer = "L"; break;
case "气态": addd.AmountPer = "L"; break;
case "其他": addd.AmountPer = "Kg"; break;
}
addd.V = (Convert.ToDouble(new Warehouse.Tools.queryV().query("select V from Amount where goodsNum='" + add.GoodsNum + "' and PositionNum ='" + add.PositionNum + "' ")) + (Convert.ToDouble(TextBox2.Text) * Convert.ToDouble(tiqu.tiqu(TextBox7.Text)))).ToString();
new DAL.AmountDAO().updateAmount(addd);
}
else
{
Model.Amount addd = new Model.Amount();
addd.Num = Convert.ToInt32(new Warehouse.Tools.queryV().query("select count(*) from Amount where 1=1 ")) + 1;
addd.GoodsNum = add.GoodsNum;
addd.PositionNum = add.PositionNum;
addd.Amounts = add.InAmount;
switch (new Warehouse.Tools.queryV().query("select goodsStyle from Goods where goodsNum='" + add.GoodsNum + "' ").ToString())
{
case "固态": addd.AmountPer = "Kg"; break;
case "液态": addd.AmountPer = "L"; break;
case "气态": addd.AmountPer = "L"; break;
case "其他": addd.AmountPer = "Kg"; break;
}
addd.Vp = (tiqu.tiqu(TextBox7.Text)).ToString();
addd.V = (Convert.ToDouble(tiqu.tiqu(TextBox2.Text)) * Convert.ToDouble(tiqu.tiqu(TextBox7.Text))).ToString();
new DAL.AmountDAO().addAmount(addd);
}
Warehouse.Tools.update up = new Tools.update();
double xxxx1 = (tiqu.tiqu(TextBox7.Text) * (tiqu.tiqu(TextBox2.Text)));
double xxxx2 = tiqu.tiqu(qq.query("select Rest from Position where positionNum='" + TextBox9.Text + "' "));
string rest = (xxxx2 - xxxx1).ToString();
up.updates("update Position set Rest='" + rest + "' where positionNum='" + TextBox9.Text + "' ");
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功！');", true);
Div1.Visible = false;
GridView1.Visible = true;
if (GridView1.Visible == true)
{
Button1.Visible = true;
Button4.Visible = true;
ListBox11.Visible = true;
TextBox1.Visible = true;
Button5.Visible = true;
}
rg.Refresh("select * from Inin order by num", "inID", GridView1);
Warehouse.TextBox_Clear tx = new TextBox_Clear();
tx.clear(Div1);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败！');", true);
}
}
else
{
Response.Write("<script>window.location.href='#div_kkk'</script>");
}
}
else if (Button66.Text == "确定")
{
Model.Inin add = new Model.Inin();
add.InID = TextBox11.Text;
add.PositionNum = TextBox9.Text;
add.GoodsNum = TextBox12.Text;
add.InAmount = Int32.Parse(TextBox2.Text);
add.BatchNum = TextBox3.Text;
add.Date = DateTime.Now;
add.UserId = TextBox5.Text;
add.Remark = TextBox6.Text;
bool xx = new DAL.IninDAO().updateIn(add);
if (xx)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功！');", true);
Div1.Visible = false;
GridView1.Visible = true;
if (GridView1.Visible == true)
{
Button1.Visible = true;
Button4.Visible = true;
ListBox11.Visible = true;
TextBox1.Visible = true;
Button5.Visible = true;
}
rg.Refresh("select * from Inin order by num", "inID", GridView1);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败！');", true);
}
}
}
protected void Button9_Click(object sender, EventArgs e)
{
switch (Button9.Text)
{
case "增加":
{
if (Image12.ImageUrl == "~/Image/对号.png" && Image11.ImageUrl == "~/Image/对号.png")
{
if (TextBox3.Text == "")
{
TextBox3.Text = "暂无";
}
if (TextBox4.Text == "")
{
TextBox4.Text = "暂无";
}
Model.Department add = new Model.Department();
DAL.Query nn = new DAL.Query();
int n = nn.query("Department");
add.Num = (n + 1).ToString();
add.StaffNum = TextBox4.Text;
add.DepartId = TextBox1.Text;
add.DepartName = TextBox2.Text;
add.ParentdepartName = TextBox3.Text;
bool xx = new DAL.DepartmentDAO().addDepart(add);
if (xx == true) //添加一个部门
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');window.location.href='管理部门.aspx'", true);
Div1.Style["display"] = "none";
GridView1.Visible = true;
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;
}
}
else
{
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.Department update = new Model.Department();
update.DepartId = TextBox1.Text;
update.DepartName = TextBox2.Text;
update.StaffNum = TextBox4.Text;
update.ParentdepartName = TextBox3.Text;
bool xx = new DAL.DepartmentDAO().updateDepart(update);
if (xx)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功！');", true);
Div1.Style["display"] = "none";
GridView1.Visible = true;
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;
}
rg.Refresh("select * from Department order by num", "departId", GridView1);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败！');", true);
}
}
break;
}
}
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")
{
try
{
Model.GoodsType add = new Model.GoodsType();
DAL.Query nn = new DAL.Query();
int n = nn.query("GoodsType");
add.Num = (n + 1).ToString();
add.GoodsTypeNum = TextBox10.Text;
add.GoodsTypeName = TextBox11.Text;
add.ParentTypeNum = TextBox12.Text;
add.GoodsTypeCondition = ListBox3.Text;
add.Remark = TextBox14.Text;
add.CreateTime = DateTime.Now;
add.UpdateTime = DateTime.Now;
bool xx = new DAL.GoodsTypeDAO().addGoodsType(add);
if (xx == true)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功！');", true);
Div1.Visible = false;
GridView1.Visible = true;
Button2.Visible = true;
Button3.Visible = true;
Button4.Visible = true;
TextBox2.Visible = true;
ListBox4.Visible = true;
Div1.Visible = false;
GridView1.Visible = true;
rg.Refresh("select * from Goodstype order by num", "goodsTypeNum", GridView1);
}
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.GoodsType update = new Model.GoodsType();
update.GoodsTypeNum = TextBox10.Text;
update.GoodsTypeName = TextBox11.Text;
update.ParentTypeNum = TextBox12.Text;
update.GoodsTypeCondition = ListBox3.Text;
update.Remark = TextBox14.Text;
update.CreateTime = Convert.ToDateTime(TextBox15.Text);
update.UpdateTime = DateTime.Now;
bool xx = new DAL.GoodsTypeDAO().updateGoodsType(update);
if (xx)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功！');", true);
Div1.Visible = false;
GridView1.Visible = true;
Button2.Visible = true;
Button3.Visible = true;
Button4.Visible = true;
TextBox2.Visible = true;
ListBox4.Visible = true;
Div1.Visible = false;
GridView1.Visible = true;
rg.Refresh("select * from Goodstype order by num", "goodsTypeNum", GridView1);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败！');", true);
}
}
break;
}
}
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;
}
}
protected void Button66_Click(object sender, EventArgs e)
{
if (Button66.Text == "增加")
{
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" && Image9.ImageUrl == "~/Image/对号.png" && Image10.ImageUrl == "~/Image/对号.png")
{
Model.Goods add = new Model.Goods();
DAL.Query qu = new DAL.Query();
int n = qu.query("Goods");
add.Num = n + 1;
add.GoodsNum = TextBox11.Text;
add.GoodsTypeNum = TextBox9.Text;
add.GoodsName = TextBox12.Text;
add.GoodsStyle = ListBox6.SelectedItem.Text;
add.GoodsColor = ListBox7.SelectedItem.Text;
add.GoodsSmell = ListBox8.SelectedItem.Text;
add.GoodsShape = ListBox9.SelectedItem.Text;
add.GoodsPer = ListBox14.SelectedItem.Text;
add.GoodsCondition = ListBox10.SelectedItem.Text;
add.Max = TextBox2.Text;
bool xx = new DAL.GoodsDAO().addGoods(add);
if (xx)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功！');", true);
Div1.Visible = false;
GridView1.Visible = true;
if (GridView1.Visible == true)
{
Button1.Visible = true;
Button4.Visible = true;
ListBox11.Visible = true;
TextBox1.Visible = true;
Button5.Visible = true;
}
rg.Refresh("select * from Goods order by num", "goodsNum", GridView1);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败！');", true);
}
}
else
{
Response.Write("<script>window.location.href='#div_kkk'</script>");
}
}
else if (Button66.Text == "确定")
{
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" && Image9.ImageUrl == "~/Image/对号.png" && Image10.ImageUrl == "~/Image/对号.png")
{
Model.Goods add = new Model.Goods();
add.GoodsNum = TextBox11.Text;
add.GoodsTypeNum = TextBox9.Text;
add.GoodsName = TextBox12.Text;
add.GoodsStyle = ListBox6.SelectedItem.Text;
add.GoodsColor = ListBox7.SelectedItem.Text;
add.GoodsSmell = ListBox8.SelectedItem.Text;
add.GoodsShape = ListBox9.SelectedItem.Text;
add.GoodsPer = ListBox14.SelectedItem.Text;
add.GoodsCondition = ListBox10.SelectedItem.Text;
add.Max = TextBox2.Text;
bool xx = new DAL.GoodsDAO().updateGoods(add);
if (xx)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功！');", true);
Div1.Visible = false;
GridView1.Visible = true;
if (GridView1.Visible == true)
{
Button1.Visible = true;
Button4.Visible = true;
ListBox11.Visible = true;
TextBox1.Visible = true;
Button5.Visible = true;
}
rg.Refresh("select * from Goods order by num", "goodsNum", GridView1);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败！');", true);
}
}
}
}
