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); } } } }
public void refre_zhu() { List <string> list1 = new List <string>(); List <int> list2 = new List <int> (); Chart1.Height = 400; Chart1.Width = 900; new Warehouse.Tools.AddSysLog().addlog("1", "图形化展示", "查询"); List <Model.Amount> amos = new DAL.AmountDAO().getAllAmounts(); for (int i = 0; i < amos.Count; i++) { list1.Add(amos[i].Goods.GoodsName); list2.Add(amos[i].Goods.GoodsCount); } //title属性说明 //边框样式设置 Chart1.ChartAreas["ChartArea1"].BorderColor = Color.Black; Chart1.ChartAreas["ChartArea1"].BorderWidth = 2; Chart1.ChartAreas[0].AxisX.Interval = 1; Chart1.ChartAreas[0].AxisX.IntervalOffset = 0; Chart1.ChartAreas[0].AxisX.LabelStyle.IsStaggered = true; Chart1.Series.Add("现有数量"); Chart1.Series["现有数量"]["PixelPointWidth"] = "20"; Chart1.Series["现有数量"].Points.DataBindXY(list1, list2); //添加数据源,X、Y轴(结合这里是动态数组) for (int i = 0; i < list1.Count; i++) { Chart1.Series["现有数量"].Points[i].Label = list2[i].ToString();//柱状图顶部添加说明数据 } //设置图例说明 Chart1.ChartAreas["ChartArea1"].AxisY.TitleFont = new Font("微软雅黑", float.Parse("8"), FontStyle.Regular); Chart1.ChartAreas["ChartArea1"].AxisY.TitleForeColor = Color.FromName("Black"); Chart1.ChartAreas["ChartArea1"].AxisY.Title = "数量"; Chart1.ChartAreas["ChartArea1"].AxisX.TitleFont = new Font("微软雅黑", float.Parse("8"), FontStyle.Regular); Chart1.ChartAreas["ChartArea1"].AxisX.TitleForeColor = Color.FromName("Black"); Chart1.ChartAreas["ChartArea1"].AxisX.Title = "物品名称"; }
public void refre_pie() { //<summary> //2013年5月22日 修改 并添加说明 //ToolTip:鼠标放在图标上显示数据(#VALX:指标名称,#VALY指标值) //LegendToolTip:鼠标放在图例上显示数据(#PERCENT:百分比) //PostBackValue:返回值(#INDEX:索引值) //LegendPostBackValue:图例返回值 //LegendText:图例值 //Label:饼图值 //</summary> List <string> list1 = new List <string>(); List <int> list2 = new List <int>(); List <Model.Amount> amos = new DAL.AmountDAO().getAllAmounts(); for (int i = 0; i < amos.Count; i++) { list1.Add(amos[i].Goods.GoodsName); list2.Add(amos[i].Goods.GoodsCount); } new Warehouse.Tools.AddSysLog().addlog("1", "图形化展示", "查询"); Series series = Chart2.Series.Add("My Series"); series.ToolTip = "#VALX:#VALY 数量"; series.LegendToolTip = "#PERCENT"; series.PostBackValue = "#INDEX"; series.LegendPostBackValue = "#INDEX"; series.LegendText = "#VALX"; series.Label = "#VALX[#PERCENT]"; series.Points.DataBindXY(list1, list2); Chart2.Series[0]["PieLabelStyle"] = "Outside"; //饼图说明显示方式(外面) series.ChartType = SeriesChartType.Pie; //图标的显示风格(饼图) series.ShadowOffset = 2; series.BorderColor = Color.DarkGray; Chart2.Width = 880; Chart2.Height = 400; }