public void checkSeries(series pSeries) { series addedSeries = new series(); addedSeries.areaID = pSeries.areaID; addedSeries.measureID = pSeries.measureID; addedSeries.industryID = pSeries.industryID; addedSeries.seriesID = pSeries.seriesID; addedSeries.beginYear = pSeries.beginYear; addedSeries.beginPeriod = pSeries.beginPeriod; addedSeries.endYear = pSeries.endYear; addedSeries.endPeriod = pSeries.endPeriod; addedSeries.blsTable = pSeries.blsTable; db.series.Add(addedSeries); db.SaveChanges(); //addData ****needs Multiple Active Result set on the web.config file. foreach (data_table val in pSeries.data_table) { db.data_table.Add(val); db.SaveChanges(); } }
static void plot2d() { int num = 161; float[] x = new float[num]; float[] y = new float[num]; float[] z = new float[num]; for (int i = 0; i < num; i++) { x[i] = (float)((i - 180) * Math.PI / 180.0); y[i] = (float)(Math.Sin(x[i])); z[i] = (float)(Math.Cos(x[i])); } series a = new series(x, y); series b = new series(x, z); FigureForm_Plot2D p2 = new FigureForm_Plot2D(); List <series> t = new List <series>(); t.Add(a); t.Add(b); p2.FigureInitial(t, false, new float[4] { -5, 500, -1, 100 }); p2.ShowDialog(); }
static void AscanTestt() { int num = 360; float[] x = new float[num]; float[] y = new float[num]; for (int i = 0; i < num; i++) { x[i] = (float)((i - 180)); y[i] = 0.0f; } series a = new series(x, y); List <series> list = new List <series>() { a }; AscanTest ascanTest = new AscanTest(x, y); /*ascan_Ruler1.ascan_1.StepX = 1; * ascan_Ruler1.ascan_1.StepY = 0.001f; * ascan_Ruler1.ascan_1.StartX = x[0]; * ascan_Ruler1.ascan_1.EndX = x[num - 1]; * ascan_Ruler1.ascan_1.StartY = -1; * ascan_Ruler1.ascan_1.EndY = 1; * ascan_Ruler1.ascan_1.NewImage(list, true, new float[] { x[0], x[num - 1], -1, 1 }); * ascan_Ruler1.ascan_1.ascanToolLayout1.ReferenceC.InfoFormat = "{0:0.000}"; * ascan_Ruler1.ascan_1.ascanToolLayout1.MeasureC.InfoFormat = "{0:0.000}"; * ascan_Ruler1.ascan_1.ascanToolLayout1.ReferenceC.Enable = false; * * * ascan_Ruler1.ReDrawRuler(); * * StartPosition = FormStartPosition.CenterScreen; * ShowDialog();*/ }
public JsonResult postdata(series pData) { string test = "test"; addModel.checkSeries(pData); return(Json(test, "application/json")); }
public ActionResult DeleteConfirmed(int id) { series series = db.series.Find(id); db.series.Remove(series); db.SaveChanges(); return(RedirectToAction("Index")); }
public void VerifyMonthlyGraphValue(lineChartData objlineChartData, DataTable dt, List <double> ProjectedList) { if (objlineChartData.categories != null && objlineChartData.categories.Count > 0 && objlineChartData.series != null && objlineChartData.series.Count > 0) { List <string> categories = objlineChartData.categories; series ActualSeries = objlineChartData.series[0]; series GoalSeries = objlineChartData.series[1]; series ProjectedSeries = objlineChartData.series[2]; decimal SumOfActualSeries = 0; if (dt.Rows[3] != null) { for (int i = 1; i <= dt.Columns.Count - 1; i++) { SumOfActualSeries = SumOfActualSeries + Convert.ToDecimal(dt.Rows[3].ItemArray[i].ToString()) + Convert.ToDecimal(ProjectedList[i - 1]); Assert.AreEqual(Math.Round(Convert.ToDecimal(ActualSeries.data[i + 1].ToString()), 2), Math.Round(SumOfActualSeries, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of actual revenue in graph " + MonthList[i - 1] + " is " + ActualSeries.data[i + 1].ToString() + "."); } } if (GoalAmount != 0) { decimal goal = 0; for (int i = 2; i <= GoalSeries.data.Count - 1; i++) { if (i - 1 >= NewStartDate.Month && i - 1 <= NewEndDate.Month) { goal = goal + GoalAmount; Assert.AreEqual(Math.Round(Convert.ToDecimal(GoalSeries.data[i].ToString()), 2), Math.Round(goal, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of goal in graph " + MonthList[i - 2] + " is " + GoalSeries.data[i].ToString() + "."); } else { Assert.AreEqual(GoalSeries.data[i].ToString(), "0"); Console.WriteLine("ReportController - GetRevenueData \n The assert value of goal in graph " + MonthList[i - 2] + " is " + GoalSeries.data[i].ToString() + "."); } } } for (int i = 2; i <= ProjectedSeries.data.Count - 1; i++) { decimal projectedData = 0; decimal projected = 0; if (ProjectedSeries.data[i].ToString() != null) { projectedData = Convert.ToDecimal(ProjectedSeries.data[i]); if (currentMonth > i - 1) { projected = Convert.ToDecimal(ProjectedList[i - 2]); } else { projected = Convert.ToDecimal(ProjectedList[i - 2]) + Convert.ToDecimal(TotalRevenueList[i - 2].ToString()); } } Assert.AreEqual(Math.Round(projectedData, 2), Math.Round(projected, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of projected revenue in graph " + MonthList[i - 2] + " is " + projectedData.ToString() + "."); } } }
public ActionResult Edit([Bind(Include = "id,title,plot,imdb,poster,director,youtube_trailer,awards,year_start,year_end")] series series) { if (ModelState.IsValid) { db.Entry(series).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(series)); }
public ActionResult Create([Bind(Include = "id,title,plot,imdb,poster,director,youtube_trailer,awards,year_start,year_end")] series series) { if (ModelState.IsValid) { db.series.Add(series); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(series)); }
private List <series> copy(List <series> a) { int n = a.Count; List <series> b = new List <series>(n); for (int i = 0; i < n; i++) { series tmp = new series(); a[i].CopyTo(tmp); b.Add(tmp); } return(b); }
private void accelerationToolStripMenuItem_Click(object sender, EventArgs e) { chart1.Series.Clear(); chart1.ChartAreas[0].AxisX.IsMarginVisible = false; series series = new series { Name = "velocity", Color = Color.Blue, IsVisibleInLegend = false, IsXValueIndexed = true, ChartType = SeriesChartType.Spline, BorderWidth = 2 }; }
// GET: series/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } series series = db.series.Find(id); if (series == null) { return(HttpNotFound()); } return(View(series)); }
/// <summary> /// 隐患整改情况饼图 /// </summary> /// <param name="queryJson"></param> /// <returns></returns> public ActionResult GetHtNumReadjustChart(string queryJson) { var curUser = ERCHTMS.Code.OperatorProvider.Provider.Current(); //当前用户 var queryParam = queryJson.ToJObject(); string deptCode = curUser.DeptCode; //部门 string year = queryParam["year"].ToString(); //年度 string hidRank = ""; //隐患级别 if (!queryParam["level"].IsEmpty()) { hidRank = queryParam["level"].ToString().Replace("请选择", ""); } string hidPoint = ""; //区域 StatisticsEntity hentity = new StatisticsEntity(); hentity.sDeptCode = deptCode; //整改部门 hentity.sArea = hidPoint; //区域 hentity.sYear = year; //年度 hentity.sHidRank = hidRank; //隐患级别 hentity.sAction = "6"; //对比图分析 //列表 var dt = htbaseinfobll.QueryStatisticsByAction(hentity); IList <series> slist = new List <series>(); List <int> oVal = new List <int>(); List <int> iVal = new List <int>(); series s1 = new series(); s1.name = "已整改"; series s2 = new series(); s2.name = "未整改"; //图表分析 foreach (DataRow row in dt.Rows) { //y 轴Value oVal.Add(Convert.ToInt32(row["yValue"].ToString())); iVal.Add(Convert.ToInt32(row["wValue"].ToString())); } s1.data = oVal; //已整改 s2.data = iVal; //未整改 slist.Add(s1); slist.Add(s2); var jsonData = new { tdata = dt, sdata = slist }; return(Content(jsonData.ToJson())); }
public static void GetSensorHistory(int groupId, DateTime startDate, DateTime endDate, int step, List <Sensor> sensors, field field) { long start = ToEpochTime(startDate) * 1000; long end = ToEpochTime(endDate) * 1000; var seriesList = new List <series>(); foreach (Sensor s in sensors) { series ser = new series(); ser.widgetId = s.id; ser.field = field.ToString(); seriesList.Add(ser); } SensorQuery query = new SensorQuery() { groupId = 2401, startMs = start, endMs = end, stepMs = step, series = seriesList }; RestClient client = new RestClient() { BaseUrl = new Uri("https://api.samsara.com") }; var request = new RestRequest(); // request.AddBody(new { groupId = "2401" }); JavaScriptSerializer serial = new JavaScriptSerializer(); var jsonToSend = serial.Serialize(query); request.AddParameter("application/json; charset=utf-8", jsonToSend, ParameterType.RequestBody); request.Method = Method.POST; request.Resource = "v1/sensors/history"; request.AddQueryParameter("access_token", "xBE7YA36JSQIgMatJOW4JiFQqxEhO2"); var response = client.Execute(request); int i = 0; }
static void LsTest(bool last) { int num = 360; float[] x = new float[num]; float[] y = new float[num]; float[] x1 = new float[num * 2]; float[] z = new float[num * 2]; for (int i = 0; i < num; i++) { x[i] = (float)((i - 180) * Math.PI / 180.0); x1[i] = x[i]; x1[i + num] = (float)(x[i] + 2 * Math.PI); y[i] = (float)(Math.Sin(x[i])); z[i] = (float)(Math.Cos(x[i])); z[i + num] = z[i]; } series a = new series(x, y); a.sColor = System.Drawing.Color.Red; series b = new series(x1, z); List <series> t = new List <series>(); t.Add(a); t.Add(b); LongStripForm lsf = new LongStripForm(); lsf.longStrip1.JudgeLine0Enable = true; lsf.longStrip1.JudgeLine0 = 0.5f; ///动态画图时,必须fixRange lsf.FigureInitial(t, true, new float[4] { x[0], x1[2 * num - 1], -1, 1 }); if (!last) { lsf.Show(); } else { lsf.ShowDialog(); } }
public void ReCal() { if (envelopActived) { UpdataEnvelop(); } else { envelop = null; if (listData != null) { listData.Remove(envelop); } } gate0.DrawGate(); gate1.DrawGate(); gate2.DrawGate(); gate3.DrawGate(); }
public ChartModel CompanyCompare(List <CompanyDetails> details, List <CompanyInfo> infos) { var model = new ChartModel(); model.title = "before"; model.xName = "m"; model.xData = new string[] { "S", "Base", "meal" }; model.yName = "项目"; var serieslist = new List <series>(); foreach (CompanyDetails detail in details) { var s = new series(); s.name = infos.Where(p => p.Id == detail.CompanyId).ToList()[0].CompanyName; s.type = "bar"; s.data = new string[] { detail.Salary, detail.BaseSalary, detail.MealAllowance }; serieslist.Add(s); } model.series = serieslist; return(model); }
static void Tooltest() { int num = 360; float[] x = new float[num]; float[] y = new float[num]; for (int i = 0; i < num; i++) { x[i] = (float)((i - 180)); y[i] = (float)(Math.Sin(x[i] * Math.PI / 180) * 100); } series a = new series(x, y); List <series> list = new List <series>() { a }; ToolTest toolTest = new ToolTest(); toolTest.ascan_Ruler1.ascan_1.NewImage(list, true, new float[] { -180, 180, -100, 100 }); toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.StepX = 1; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.StepY = 0.1f; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.StartX = 0; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.EndX = 360; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.StartY = -100; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.EndY = 100; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.MeasureC.Enable = false; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.ReferenceC.Enable = false; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.gate1.Enable = true; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.gate1.Start = 10; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.gate1.End = 50; toolTest.ascan_Ruler1.ascan_1.ascanToolLayout1.gate1.Threshold = 10; //toolTest.ascan_Ruler1.ReDrawRuler(); //toolTest.ascan_Ruler1.Invalidate(); toolTest.ascan_Ruler1.ascan_1.Reset(); toolTest.ShowDialog(); }
public ChartModel CompanyCompare(List <CompanyDetails> details, List <CompanyInfo> infos) { var common = new CommonMethod(); var model = new ChartModel(); model.title = "After"; model.xName = "m"; model.xData = new string[] { "S", "After" }; model.yName = "项目"; var serieslist = new List <series>(); foreach (CompanyDetails detail in details) { var after = common.AfterTaxSalary(detail); var s = new series(); s.name = infos.Where(p => p.Id == detail.CompanyId).ToList()[0].CompanyName; s.type = "bar"; s.data = new string[] { after.HousingBenefit.ToString(), after.TaxSalary.ToString() }; serieslist.Add(s); } model.series = serieslist; return(model); }
private void SeriesSync(int EventId, Dictionary<string, series> SeriesList) { var SeriesListUpdated = new Dictionary<string, series>(); var lstSeries = seriesRepo.GetSeriesByEvent(EventId); foreach (string seriesName in SeriesList.Keys) { bool found = false; if (lstSeries.Count() > 0) { found = (lstSeries.Any(x => x.name.Contains(seriesName))); } if (!found) { var newSeries = new series(); newSeries.lsevent_id = EventId; newSeries.name = seriesName; SeriesListUpdated[seriesName] = seriesRepo.Insert(newSeries); } else { SeriesListUpdated[seriesName] = lstSeries.First(x => x.name == seriesName); } } this.SeriesList = SeriesListUpdated; }
/// <summary> /// Add By Mayi; /// 实现接收拖拽对象的函数; /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Address_Drop(object sender, DragEventArgs e) { try { DataGridCell_MIB_MouseEventArgs cell = e.Data.GetData(typeof(DataGridCell_MIB_MouseEventArgs)) as DataGridCell_MIB_MouseEventArgs; foreach (var iter in cell.SelectedCell.Properties) { // 找与其对应的节点; if (cell.HeaderName == (iter.Value as DataGrid_Cell_MIB).MibName_CN) { Console.WriteLine("Selected Cell Keys is " + iter.Key + "and value is " + (iter.Value as DataGrid_Cell_MIB).MibName_CN + " This Node oid is " + (iter.Value as DataGrid_Cell_MIB).oid); List <string> inputoid = new List <string>(); inputoid.Add((iter.Value as DataGrid_Cell_MIB).oid); GettingValue = true; // 启动一个线程不断读取该节点的数值并回填到EChart的option中; Task ReadValue_FromSNMP = new Task(() => { string[] data = { }; double[] da_Num = { }; // 构造option,以显示在js中,作为初始默认显示; Dictionary <string, string> Ret = new Dictionary <string, string>(); List <double> da_Num_content = new List <double>(); List <string> data_content = new List <string>(); // 持续获取数据; while (GettingValue) { // !!!后续需要扩展功能,保存日志文件; SnmpMessageV2c snmpmsg1 = new SnmpMessageV2c(); Ret = snmpmsg1.GetRequest(inputoid, "public", "172.27.245.92"); double temp = 0; foreach (var iter2 in Ret) { Console.WriteLine("Get MibValue is " + iter2.Value); Double.TryParse(iter2.Value, out temp); da_Num_content.Add(temp); da_Num = da_Num_content.ToArray(); // 将数据集再转换回数组; data_content.Add(DateTime.Now.ToString("T")); data = data_content.ToArray(); } Thread.Sleep(2000); series mySeries = new series((iter.Value as DataGrid_Cell_MIB).MibName_CN, "line", false, "circle", "", da_Num); m_CbForJs.listForLegend.Add((iter.Value as DataGrid_Cell_MIB).MibName_CN); m_CbForJs.listForSeries.Add(mySeries); legend myLegend = new legend(m_CbForJs.listForLegend); xAxis xaxis = new xAxis(data); Option myOption = new Option(myLegend, m_CbForJs.listForSeries, xaxis); m_CbForJs.Option = Option.ObjectToJson(myOption); } }); ReadValue_FromSNMP.Start(); } } } catch (Exception ex) { Console.WriteLine("LineChart Receive Mouse Drop Exception " + ex.ToString()); } }
static void LongStripTest() { int num = 36000; float[] x = new float[num]; float[] y = new float[num]; float[] y2 = new float[num]; float[] y3 = new float[num]; for (int i = 0; i < num; i++) { x[i] = (float)((i - 180)); y[i] = (float)Math.Sin(i * Math.PI / 180); y2[i] = (float)Math.Sin((i + 10) * Math.PI / 180); y3[i] = (float)Math.Sin((i + 20) * Math.PI / 180); } series a = new series(x, y); series b = new series(x, y2); series c = new series(x, y3); List <series> list = new List <series>() { a }; LongStripTest ls = new LongStripTest(); ls.startX = x[0]; ls.endX = x[num - 1]; ls.startY = -1; ls.endY = 1; ls.stepX = x[1] - x[0]; ls.stepY = 0.001f; ls.data = list; ls.judge0Enable = true; ls.judge1Enable = true; ls.judge1Color = System.Drawing.Color.Red; ls.judge0Color = System.Drawing.Color.Red; ls.judge0Y = -0.5f; ls.judge1y = 0.5f; ls.InfoFormat = "{0:0.000}"; ls.tipFont = new System.Drawing.Font("宋体", 16); ls.tipFormat = "0.000"; ls.Initial(true); /*LongStrip_Ruler lsr = ls.longStrip_Ruler1; * lsr.longStrip_1.StepX = x[1]-x[0]; * lsr.longStrip_1.StepY = 0.001f; * lsr.longStrip_1.StartX = x[0]; * lsr.longStrip_1.EndX = x[num - 1]; * lsr.longStrip_1.StartY = -1; * lsr.longStrip_1.EndY = 1; * lsr.longStrip_1.NewImage(list, true, new float[] { x[0], x[num - 1], -1, 1 }); * lsr.longStrip_1.longStripToolLayout1.JudgeLine0.InfoFormat = "{0:0.000}"; * lsr.longStrip_1.longStripToolLayout1.JudgeLine1.InfoFormat = "{0:0.000}"; * lsr.longStrip_1.longStripToolLayout1.JudgeLine0.Y = 0.5f; * lsr.longStrip_1.longStripToolLayout1.JudgeLine1.Y = -0.5f; * lsr.longStrip_1.longStripToolLayout1.JudgeLine0.Enable = true; * lsr.longStrip_1.longStripToolLayout1.infoShow.data = list; * lsr.longStrip_1.longStripToolLayout1.infoShow.startx0 = x[0]; * lsr.ReDrawRuler(); * * ls.StartPosition = FormStartPosition.CenterParent; * ls.ShowDialog();*/ }
public void VerifyQuarterlyGraphValue(lineChartData objlineChartData, CardSectionListModel objCardSectionListModel) { if (objlineChartData.categories != null && objlineChartData.categories.Count > 0 && objlineChartData.series != null && objlineChartData.series.Count > 0) { List <string> categories = objlineChartData.categories; series ActualSeries = objlineChartData.series[0]; series GoalSeries = objlineChartData.series[1]; series ProjectedSeries = objlineChartData.series[2]; decimal SumOfActualSeries = 0; decimal SumOfGoalSeries = 0; decimal SumOfProjectedSeries = 0; decimal SumOfActualCostSeries = 0; lineChartData tacticLineChartData = objCardSectionListModel.LineChartData; series tacticRevenueSeries = tacticLineChartData.series[0]; series tacticCostSeries = tacticLineChartData.series[1]; #region Graph for Plan for (int i = 1; i <= ActualSeries.data.Count - 1; i++) { if (QuaterlyTotalRevenueList != null && QuaterlyTotalRevenueList.Count > 0 && QuaterlyProjectedList != null && QuaterlyProjectedList.Count > 0) { SumOfActualSeries = Convert.ToDecimal(QuaterlyTotalRevenueList[i - 1]) + Convert.ToDecimal(QuaterlyProjectedList[i - 1]); Assert.AreEqual(Math.Round(Convert.ToDecimal(ActualSeries.data[i].ToString()), 2), Math.Round(SumOfActualSeries, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly actual revenue in graph " + QuarterList[i - 1] + " is " + ActualSeries.data[i].ToString() + "."); } } for (int i = 1; i <= GoalSeries.data.Count - 1; i++) { if (QuaterlyGoalList != null && QuaterlyGoalList.Count > 0) { SumOfGoalSeries = SumOfGoalSeries + Convert.ToDecimal(QuaterlyGoalList[i - 1]); Assert.AreEqual(Math.Round(Convert.ToDecimal(GoalSeries.data[i].ToString()), 2), Math.Round(SumOfGoalSeries, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly goal in graph " + QuarterList[i - 1] + " is " + GoalSeries.data[i].ToString() + "."); } } for (int i = 1; i <= ProjectedSeries.data.Count - 1; i++) { decimal projectedSeries = 0; if (QuaterlyProjectedList != null && QuaterlyProjectedList.Count > 0 && QuaterlyProjectedList[i - 1] != 0) { SumOfProjectedSeries = Convert.ToDecimal(QuaterlyTotalRevenueList[i - 1]) + Convert.ToDecimal(QuaterlyProjectedList[i - 1]); } if (ProjectedSeries.data[i].ToString() == "") { projectedSeries = 0; } else { projectedSeries = Convert.ToDecimal(ProjectedSeries.data[i].ToString()); } Assert.AreEqual(Math.Round(Convert.ToDecimal(projectedSeries), 2), Math.Round(SumOfProjectedSeries, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly projected revenue in graph " + QuarterList[i - 1] + " is " + ProjectedSeries.data[i].ToString() + "."); } #endregion #region Graph for Tactic for (int i = 0; i <= QuaterlyTotalRevenueList.Count - 1; i++) { if (QuaterlyTotalRevenueList != null && QuaterlyTotalRevenueList.Count > 0) { Assert.AreEqual(Math.Round(Convert.ToDecimal(tacticRevenueSeries.data[i].ToString()), 2), Math.Round(Convert.ToDecimal(QuaterlyTotalRevenueList[i]), 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly tactic actual revenue in graph " + QuarterList[i] + " is " + tacticRevenueSeries.data[i].ToString() + "."); } } for (int i = 0; i <= QuaterlyActualCostList.Count - 1; i++) { if (QuaterlyActualCostList != null && QuaterlyActualCostList.Count > 0) { SumOfActualCostSeries = SumOfActualCostSeries + Convert.ToDecimal(QuaterlyActualCostList[i]); Assert.AreEqual(Math.Round(Convert.ToDecimal(tacticCostSeries.data[i].ToString()), 2), Math.Round(SumOfActualCostSeries, 2)); Console.WriteLine("ReportController - GetRevenueData \n The assert value of quarterly tactic actual cost in graph " + QuarterList[i] + " is " + tacticCostSeries.data[i].ToString() + "."); } } #endregion } }
public string insertFromCsv(string fileName) { string[] strArray; string firstLine = string.Empty; Regex r = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); StreamReader sr = new StreamReader(fileName); string headerline = sr.ReadLine(); firstLine = sr.ReadLine(); strArray = r.Split(firstLine); area newArea = new area(); measure newMeasure = new measure(); industry newIndustry = new industry(); series newSeries = new series(); newArea.areaID = strArray[2]; newArea.areaName = strArray[1]; newMeasure.measureID = strArray[4]; newMeasure.measureName = strArray[3]; newIndustry.industryID = strArray[6]; newIndustry.industryName = strArray[5]; newSeries.areaID = newArea.areaID; newSeries.measureID = newMeasure.measureID; newSeries.industryID = newIndustry.industryID; newSeries.seriesID = newArea.areaID + strArray[0]; newSeries.beginYear = "NA"; newSeries.beginPeriod = "NA"; newSeries.endYear = "NA"; newSeries.endPeriod = "NA"; newSeries.blsTable = strArray[0]; db.areas.Add(newArea); db.industries.Add(newIndustry); db.measures.Add(newMeasure); db.series.Add(newSeries); db.SaveChanges(); //start reading from 2nd line in CSV foreach (var line in File.ReadAllLines(fileName, Encoding.GetEncoding(1250)).Skip(1)) { strArray = r.Split(line); //assign split string to variables data_table newData = new data_table(); int year = Convert.ToInt32(strArray[7]); long value = Convert.ToInt64(strArray[8]); newData.seriesID = newSeries.seriesID; newData.period = "NA"; newData.year = year; newData.value = value; db.data_table.Add(newData); db.SaveChanges(); } return("Updated Database"); }
public ActionResult GetHtNumChart(string queryJson) { var curUser = ERCHTMS.Code.OperatorProvider.Provider.Current(); //当前用户 var queryParam = queryJson.ToJObject(); string deptCode = curUser.DeptCode; //部门 string year = DateTime.Now.Year.ToString(); if (!queryParam["year"].IsEmpty()) { year = queryParam["year"].ToString(); } string hidPoint = ""; //区域 string hidRank = string.Empty; if (!queryParam["level"].IsEmpty()) { hidRank = queryParam["level"].ToString().Replace("请选择", ""); //隐患级别 } string ischeck = ""; string checkType = ""; StatisticsEntity hentity = new StatisticsEntity(); hentity.sDeptCode = deptCode; hentity.sYear = year; hentity.sArea = hidPoint; hentity.sHidRank = hidRank; hentity.sAction = "4"; hentity.isCheck = ischeck; hentity.sCheckType = checkType; var dt = htbaseinfobll.QueryStatisticsByAction(hentity); IList <series> slist = new List <series>(); if (!string.IsNullOrEmpty(hidRank)) { string[] arr = hidRank.Split(','); //单个或多个隐患级别 foreach (string aStr in arr) { series s = new series(); s.name = aStr; List <int> dlist = new List <int>(); foreach (DataRow row in dt.Rows) { int tempValue = 0; if (aStr == "一般隐患") { tempValue = Convert.ToInt32(row["OrdinaryHid"].ToString()); } else //重大隐患 { tempValue = Convert.ToInt32(row["ImportanHid"].ToString()); } dlist.Add(tempValue); } s.data = dlist; slist.Add(s); } } else //无隐患级别条件 { series s = new series(); s.name = "所有隐患"; List <int> dlist = new List <int>(); foreach (DataRow row in dt.Rows) { int tempValue = Convert.ToInt32(row["allhid"].ToString()); dlist.Add(tempValue); } s.data = dlist; slist.Add(s); } return(Content(slist.ToJson())); }