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()));
}
