private String loginLog(string proc, int ntype)
{
BLL_LoginLog BLL = new BLL_LoginLog();
if (!String.IsNullOrEmpty(SelectedTestRoomCodes))
{
string SQL = "SELECT MAX(CompanyName) CompanyName,MAX(SegmentName) SegmentName,COUNT(1) as nTotals, LEFT(TestRoomCode,12) AS CompanyCode FROM dbo.sys_loginlog a join sys_tree b ON LEFT(TestRoomCode,12)=b.NodeCode WHERE TestRoomCode IN (" + SelectedTestRoomCodes + ") AND FirstAccessTime>='" + StartDate + "' AND FirstAccessTime<'" + DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd") + "' GROUP BY LEFT(TestRoomCode,12) ORDER BY MAX(b.OrderID) ";
DataSet ds = DbHelperSQL.Query(SQL);
if (ds != null)
{
DataTable dt = ds.Tables[0];
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["SegmentName"].ToString() + "\n" + dr["CompanyName"].ToString();
trcs.IntNumber = Int32.Parse(dr["nTotals"].ToString());
//trcs.IntNumberMarks = Int32.Parse(dr["nUserCounts"].ToString());
trcs.Para1 = dr["CompanyCode"].ToString();
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
else
{
return("");
}
}
private String machinesummarypop(string proc, string testcode)
{
BLL_Machine BLL = new BLL_Machine();
testcode = GetSelectTree(testcode, SelectedTestRoomCodes);
DataTable dt = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), testcode, 1);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["testname"].ToString();
trcs.IntNumber = Int32.Parse(dr["ncount"].ToString());
trcs.Para1 = dr["companycode"].ToString();
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
private String parallellinechart(string proc, string testcode, int nUnit)
{
BLL_ParallelReport BLL = new BLL_ParallelReport();
testcode = GetSelectTree(testcode, SelectedTestRoomCodes);
DataTable dt = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), testcode, nUnit);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["result"].ToString();
trcs.IntNumber = Int32.Parse(dr["counts"].ToString());
trcs.Para1 = dr["testroomID"].ToString();
trcs.Para2 = dr["modelid"].ToString();
trcs.Para3 = dr["stype"].ToString();
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
private String qxzlhzbchartpop(string proc, string testcode)
{
BLL_Document BLL = new BLL_Document();
sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line;
testcode = GetSelectTree(testcode, SelectedTestRoomCodes);
DataTable dt = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), testcode, 1);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["testname"].ToString();
trcs.IntNumber = Int32.Parse(dr["ncount"].ToString());
trcs.Para1 = dr["modelid"].ToString();
trcs.Para2 = dr["segment"].ToString() + "-" + dr["company"].ToString();
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
private String qxjqgridpop(string proc, int ftype, string startdate, string enddate, string testcode, string modelid)
{
BLL_Document BLL = new BLL_Document();
if (modelid.Length > 0)
{
DataTable dt = BLL.GetProcDataTableChartsPara6(proc, ftype, startdate, enddate, testcode, modelid);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["chartDate"].ToString();
trcs.IntNumber = Int32.Parse(dr["zjCount"].ToString());
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
else
{
return("");
}
}
public ChartModel OrdersByShippingType(ChartModel model)
{
var data = _orderAnalyticsService.GetOrdersGrouped(model.From, model.To);
_chartService.SetBarChartLabelsAndData(ref model, data);
return(model);
}
private String failreportsum(string proc, int ntype)
{
BLL_Document BLL = new BLL_Document();
DataTable dt = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes, 1);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
if (ntype == 1)
{
trcs.Description = dr["segment"].ToString() + "\n" + dr["company"].ToString();
trcs.Para1 = dr["companycode"].ToString();
trcs.IntNumber = Int32.Parse(dr["totalncount"].ToString());
trcs.IntNumberMarks = Int32.Parse(dr["counts"].ToString());
trcs.DoubleNumber = Double.Parse(dr["prenct"].ToString());
}
else if (ntype == 2)
{
trcs.Description = dr["segment"].ToString() + "\n" + dr["company"].ToString() + "\n" + dr["testroom"].ToString();
trcs.IntNumber = Int32.Parse(dr["totalncount"].ToString());
trcs.IntNumberMarks = Int32.Parse(dr["counts"].ToString());
trcs.DoubleNumber = Double.Parse(dr["prenct"].ToString());
}
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
public static ChartModel CreateChartModel(DataRow dr)
{
ChartModel m = new ChartModel();
m.Tkey = dr["Tkey"].ToString().Replace("/", "_");
m.Avalue = Convert.ToDecimal(dr["Avalue"]);
m.Bvalue = Convert.ToDecimal(dr["Bvalue"]);
if (dr.Table.Columns.Contains("Title"))
{
m.Title = dr["Title"].ToString() == "" ? "请自出查询" : dr["Title"].ToString();
}
else
{
m.Title = "";
}
m.AsubB = Convert.ToDecimal(dr["AsubB"]);
if (Convert.ToDecimal(m.AsubB) > 0)
{
m.UpDown = 1;
}
else
{
m.UpDown = 0;
}
return(m);
}
public ChartModel SalesByShippingType(ChartModel model)
{
var data = _orderAnalyticsService.GetRevenueByShippingMethod(model.From, model.To);
_chartService.SetBarChartLabelsAndData(ref model, data);
return(model);
}
public JsonResult JsonHome(ChartModel model)
{
ResChartDto res = new ResChartDto();
try
{ model.DateTime = DateTime.Now;
string title = "";
string title1 = "";
if (model.QueryKind == 1)
{
title = model.DateTime.Year + "年" + model.DateTime.Month + "月份数据";
title1 = CommonHelp.list.Where(p => p.Area.Equals(model.Area)).FirstOrDefault().DesCribe;
}
if (model.QueryKind == 2)
{
title = model.DateTime.Year + "年全年数据";
title1 = CommonHelp.list.Where(p => p.Area.Equals(model.Area)).FirstOrDefault().DesCribe;
}
System.Web.Script.Serialization.JavaScriptSerializer sj = new System.Web.Script.Serialization.JavaScriptSerializer();
List <object> list1 = new List <object>();
List <ChartDataDto> list = DapperService.SqlHelp.GetChart(model);
string data = sj.Serialize(list);
res.data = data;
res.message = title;
res.message1 = title1; }
catch (Exception ex)
{
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public ActionResult Load(int userId, string chartName)
{
using (Entity context = new Entity())
{
byte[] bytes = Convert.FromBase64String(chartName);
string decoded = System.Text.Encoding.UTF8.GetString(bytes);
var userChart = context.t_user_favorite_chart.Find(new object[] { userId, decoded });
if (userChart == null)
{
throw new ArgumentException(String.Format("Chart not found! userId: {0}, chartName: {1}", userId, chartName));
}
ChartParameters parameters = ChartParameters.DeserializeXml(userChart);
var model = new ChartModel(parameters, parameters.ReportClassFieldId);
model.ChartName = userChart.chart_name;
if (parameters.ReportClassFieldId == null || parameters.ReportClassFieldId.Trim().Length == 0)
{
return(View("Index", model));
}
else
{
return(View("MultiCountry", model));
}
}
}
public ActionResult Save(string chartName, int indicatorId, int?siteId, string criterias, bool addMedian, int activeCriteria, string reportClassFieldId = "")
{
var criteriaArray = JsonConvert.DeserializeObject <ChartCriteria[]>(criterias);
var parameters = new ChartParameters(indicatorId, criteriaArray, addMedian, activeCriteria, reportClassFieldId);
using (Entity context = new Entity())
{
var userChart = context.t_user_favorite_chart.Find(new object[] { CurrentUser.Id, chartName });
if (userChart == null)
{
userChart = new t_user_favorite_chart();
userChart.user_id = CurrentUser.Id;
userChart.chart_name = chartName;
context.t_user_favorite_chart.Add(userChart);
}
userChart.chart_parameters = ChartParameters.SerializeToXml(parameters);
userChart.updated_date = DateTime.Now;
context.SaveChanges();
var chartModel = new ChartModel(parameters);
chartModel.ChartName = chartName;
chartModel.RefererSiteId = siteId;
return(View("Index", chartModel));
}
}
private void SetupChart()
{
_chart = new ChartModel();
_activity = new List <Point>(100);
chartPlaceholder.Children.Add(new PlotView()
{
Model = _chart.MyModel,
Width = chartPlaceholder.Width,
Height = chartPlaceholder.Height,
});
//Restrict handles to not exceed chart bounds
leftHandle.MinimumPosition = rightHandle.MinimumPosition = (int)chartPlaceholder.Margin.Left;
leftHandle.MaximumPosition =
rightHandle.MaximumPosition = (int)chartPlaceholder.Margin.Left + (int)chartPlaceholder.Width;
leftHandle.HandleMoved += (sender, args) =>
{
//Restrict handles to not exceed each other
rightHandle.MinimumPosition = leftHandle.Position;
UpdateSelectionRectangle();
};
rightHandle.HandleMoved += (sender, args) =>
{
leftHandle.MaximumPosition = rightHandle.Position;
UpdateSelectionRectangle();
};
}
public JsonResult GetTeacherWorkGrapData(
string uname = "",
string rname = "",
int deptId = -1,
int postId = -1,
int sex = -1,
DateTime?stime = null,
DateTime?etime = null,
int pageIndex = 1,
int pageSize = 20,
int sortDir = 0)
{
int total;
var list = _teacherWorkTime.GetTeacherWork(out total, uname, rname, postId, deptId, sex, stime, etime,
pageIndex, pageSize, sortDir);
var res = new ChartModel();
List <Series> itemArray = new List <Series>();
List <String> xAxis = list.Select(p => p.Realname).ToList();
itemArray.Add(new Series {
name = RetechWing.LanguageResources.ReportLanguage.LecturerWorkingHours, data = list.Select(p => (double)p.WorkTime).ToList()
});
res.DivID = "CourseChart";
res.title = "";
res.charttype = Charttype.Column;
res.xAxis = xAxis;
res.series = itemArray;
return(Json(res, JsonRequestBehavior.AllowGet));
}
public void SetLineChartLabels(ref ChartModel model)
{
model.Labels = new List <string>();
TimeSpan ts = model.To - model.From;
DateTime oldDate = DateTime.Parse(model.From.Date.ToString());
DateTime currentDate = oldDate;
if (ts.Days == 1)
{
for (int i = 0; i < 24; i++)
{
oldDate = currentDate;
currentDate = oldDate.AddHours(1);
model.Labels.Add(oldDate.Hour.ToString());
}
}
else
{
for (int i = 0; i < ts.Days; i++)
{
oldDate = currentDate;
currentDate = oldDate.AddDays(1);
model.Labels.Add(oldDate.ToString("dd/MM"));
}
}
}
public List <AlgorithmFirstStepModel> GenerateFirstStep()
{
_chartModel = new ChartModel();
var model = new List <AlgorithmFirstStepModel>();
_converter.SetParameters(_parameters);
var generatedNumbers = GetRandomNumbers(_parameters.RangeFrom, _parameters.RangeTo, _parameters.PopulationSize, _parameters.Precision.IntValue);
for (int i = 1; i <= _parameters.PopulationSize; i++)
{
model.Add(new AlgorithmFirstStepModel()
{
Id = i, RealValue = generatedNumbers[i - 1]
});
}
foreach (AlgorithmFirstStepModel data in model)
{
data.IntValue = _converter.RealToIntConvert(data.RealValue);
data.BinaryValue = _converter.IntToBinaryConvert(data.IntValue);
data.Int2Value = _converter.BinaryToIntConvert(data.BinaryValue);
data.Real2Value = _converter.IntToRealConvert(data.Int2Value);
data.FunctionResult = GetFunctionResult(data.RealValue);
}
return(model);
}
private ChartModel LoadFromCsv(string fname)
{
var chartModel = new ChartModel();
var lines = File.ReadAllLines(fname, Encoding.UTF8);
var names = lines[0]?.Split(';');
chartModel.Name = names.GetValue(0)?.ToString() ?? "Chart";
chartModel.NameX = names.GetValue(1)?.ToString() ?? "X";
chartModel.NameY = names.GetValue(2)?.ToString() ?? "Y";
foreach (var xValue in lines[1]?.Split(';'))
{
chartModel.AxisX.Add(xValue);
}
for (var i = 2; i < lines.Length; i++)
{
var serieElements = lines[i]?.Split(';');
var serie = new Serie(serieElements[0]);
for (var k = 1; k < serieElements.Length; k++)
{
serie.PointsList.Add(chartModel.AxisX[k - 1], double.Parse(serieElements[k]));
}
chartModel.SeriesList.Add(serie);
}
return(chartModel);
}
public ChartEditForm(ChartModel model, Func <string, ChartModel> func = null)
{
InitializeComponent();
this.model = model;
chartNameTextBox.Text = model.Text;
loadFileFunction = func ?? LoadFromCsv;
}
public ActionResult Index()
{
this.ViewData["Chart1"] = ChartModel.GenerateData();
this.ViewData["Chart2"] = ChartModel.GenerateData();
this.ViewData["Chart3"] = ChartModel.GenerateData();
return(View());
}
public ActionResult GetAllChart(string DeviceID)
{
var test = user.GetChart(DeviceID);
List <ChartModel> lm = new List <ChartModel>();
foreach (var res in test)
{
ChartModel mdl = new ChartModel();
mdl.Date = res.Date.Value.ToString("yyyy-MM-dd");
mdl.Detail_SensorName = res.Detail_SensorName;
mdl.average_of_day = Convert.ToDecimal(res.average_of_day);
mdl.lower = Convert.ToDecimal(res.lower);
mdl.upper = Convert.ToDecimal(res.upper);
lm.Add(mdl);
}
//var resutltJson = from d in test
// select new string[]
// {
// d.Date.Value.ToShortDateString(),
// d.Detail_SensorName,
// d.average_of_day.ToString(),
// d.lower.ToString(),
// d.upper.ToString()
// };
return(Json(new
{
Data = lm
}, JsonRequestBehavior.AllowGet));
// return Json(test, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// 图标显示原始数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static List <ChartDataDto> GetChart(ChartModel model)
{
List <ChartDataDto> ResList = new List <ChartDataDto>();
using (IDbConnection conn = MySqlConnection())
{
MySqlParameter[] p = new MySqlParameter[3]
{
new MySqlParameter("@_DateTime", model.DateTime),
new MySqlParameter("@_QueryKind", model.QueryKind), new MySqlParameter("@_Area", model.Area)
};
// List<dynamic>
DataTable dataTable = ExecuteDataTable("SP_Web_TaktTimeCount", CommandType.StoredProcedure, p);
for (var i = 0; i < dataTable.Columns.Count; i++)
{
ResList.Add(new ChartDataDto()
{
Num = Convert.ToInt32(dataTable.Rows[0][dataTable.Columns[i].ColumnName]),
ChartDate = dataTable.Columns[i].ColumnName.Substring(0, 10),
Light = Convert.ToInt32(dataTable.Rows[0][dataTable.Columns[i].ColumnName]) + 10,
Hight = Convert.ToInt32(dataTable.Rows[0][dataTable.Columns[i].ColumnName]) + 70
});
}
}
return(ResList);
}
private ChartModel <Language> ChartByLanguageCreator(ChartModel <Language> model)
{
foreach (var employee in Employees)
{
if (employee.IsWork)
{
var languages = EnumHelper.EnumHelper.GetFlags(employee.Language);
foreach (Language l in languages)
{
if (model.Dictionary.ContainsKey(l))
{
model.Dictionary[l] += 1;
}
else
{
model.Dictionary.Add(l, 1);
}
}
}
}
return(Children
.Aggregate(model, (current, child) => child.ChartByLanguageCreator(current)));
}
public void SetLineChartData(ref ChartModel model,
Dictionary <string, IList <KeyValuePair <DateTime, decimal> > > items)
{
foreach (string key in items.Keys)
{
IList <KeyValuePair <DateTime, decimal> > item = items[key];
var data = new List <decimal>();
TimeSpan ts = model.To - model.From;
DateTime oldDate = DateTime.Parse(model.From.Date.ToString());
DateTime currentDate = oldDate;
if (ts.Days == 1)
{
for (int i = 0; i < 24; i++)
{
data.Add(item.Where(x => x.Key.Hour == i + 1).Sum(x => x.Value));
}
}
else
{
for (int i = 0; i < ts.Days; i++)
{
data.Add(item.Where(x => x.Key == currentDate.AddDays(i)).Sum(x => x.Value));
}
}
model.MultipleData.Add(key, data.Any(x => x != 0) ? data : new List <decimal>());
}
}
private void uiSetLineColorButton_OnClick(object sender, EventArgs args)
{
using (var d = new ColorDialog())
{
d.Color = uiSetLineColorButton.BackColor;
if (d.ShowDialog() != DialogResult.OK)
return;
uiSetLineColorButton.BackColor = d.Color;
if (uiSelectAnnotButton.Checked)
{
foreach (Annotation a in ChartModel.Annotations.Where(a => a.IsSelected()))
{
var arrowAnnot = a as ArrowAnnotation;
if (arrowAnnot != null)
{
arrowAnnot.Color = OxyColor.FromAColor(arrowAnnot.Color.A,
d.Color.ToOxyColor());
}
// This will cover both Line and Polyline annotations
var pathAnnot = a as PathAnnotation;
if (pathAnnot != null)
{
pathAnnot.Color = OxyColor.FromAColor(pathAnnot.Color.A,
d.Color.ToOxyColor());
}
}
}
ChartModel.InvalidatePlot(false);
}
}
public JsonResult GetExaminationRecordsDistribution(int id)
{
List <string> distribution;
RExamination result = _examReportBL.GetExaminationRecordsDistribution(id, out distribution);
var itemArray = new List <pieSeries>();
foreach (string d in distribution)
{
itemArray.Add(new pieSeries
{
name = d,
y = result.RecordsDistribution[d]
});
}
var res = new ChartModel
{
DivID = "RecordsDistributionChart",
charttype = Charttype.Pie,
title = result == null ? "" : result.ExaminationTitle + "成绩分布统计",
pieseries = itemArray
};
return(Json(res, JsonRequestBehavior.AllowGet));
}
private void DrawText_OnMouseUp(object sender, OxyMouseEventArgs args)
{
if (_tempAnnot == null)
return;
var annot = _tempAnnot as TextAnnotation;
if (annot != null)
{
annot.Background = OxyColors.Undefined;
if (string.IsNullOrEmpty(uiSetTextTextBox.Text))
{
using (var d = new InputTextDialog())
{
d.DisplayText = uiSetTextTextBox.Text;
if (d.ShowDialog() == DialogResult.OK)
annot.Text = d.DisplayText;
else
ChartModel.Annotations.Remove(annot);
}
}
else
annot.Text = uiSetTextTextBox.Text;
}
_tempAnnot = null;
ChartModel.InvalidatePlot(false);
args.Handled = true;
}
private void uiSetFillAlphaTextBox_OnKeyDown(object sender, KeyEventArgs args)
{
if (args.KeyCode != Keys.Enter)
return;
foreach (Annotation a in ChartModel.Annotations.Where(a => a.IsSelected()))
{
var ellipseAnnot = a as EllipseAnnotation;
if (ellipseAnnot != null)
{
ellipseAnnot.Fill = OxyColor.FromAColor(byte.Parse(uiSetFillAlphaTextBox.Text),
ellipseAnnot.Fill);
}
var polyAnnot = a as PolygonAnnotation;
if (polyAnnot != null)
{
polyAnnot.Fill = OxyColor.FromAColor(byte.Parse(uiSetFillAlphaTextBox.Text),
polyAnnot.Fill);
}
var rectAnnot = a as RectangleAnnotation;
if (rectAnnot != null)
{
rectAnnot.Fill = OxyColor.FromAColor(byte.Parse(uiSetFillAlphaTextBox.Text),
rectAnnot.Fill);
}
}
ChartModel.InvalidatePlot(false);
}
private void DrawRectangle_OnMouseDown(object sender, OxyMouseDownEventArgs args)
{
if (args.ChangedButton != OxyMouseButton.Left)
return;
_tempAnnot = new RectangleAnnotation
{
Fill = HoverColor,
Layer = AnnotationLayer.AboveSeries
};
Axis xAxis = ChartModel.Axes.First(a => a.IsHorizontal());
Axis yAxis = ChartModel.Axes.First(a => a.IsVertical());
var type = (LimitType) uiSetTypeComboBox.SelectedItem;
var annot = _tempAnnot as RectangleAnnotation;
if (type == LimitType.None || type == LimitType.Vertical)
{
annot.MinimumX = xAxis.InverseTransform(args.Position.X);
annot.MaximumX = xAxis.InverseTransform(args.Position.X);
}
if (type == LimitType.None || type == LimitType.Horizontal)
{
annot.MinimumY = yAxis.InverseTransform(args.Position.Y);
annot.MaximumY = yAxis.InverseTransform(args.Position.Y);
}
ChartModel.Annotations.Add(_tempAnnot);
ChartModel.InvalidatePlot(false);
args.Handled = true;
}
private void DrawLine_OnMouseMove(object sender, OxyMouseEventArgs args)
{
if (_tempAnnot == null)
return;
Axis xAxis = ChartModel.Axes.First(a => a.IsHorizontal());
Axis yAxis = ChartModel.Axes.First(a => a.IsVertical());
var type = (LimitType) uiSetTypeComboBox.SelectedItem;
var annot = _tempAnnot as LineAnnotation;
if (annot != null)
{
if (type == LimitType.None)
{
double x1 = annot.X;
double x2 = xAxis.InverseTransform(args.Position.X);
double y1 = annot.Y;
double y2 = yAxis.InverseTransform(args.Position.Y);
double slope = (y2 - y1) / (x2 - x1);
annot.Intercept = y2 - slope * x2;
annot.Slope = slope;
}
else if (type == LimitType.Vertical)
annot.X = xAxis.InverseTransform(args.Position.X);
else if (type == LimitType.Horizontal)
annot.Y = yAxis.InverseTransform(args.Position.Y);
}
ChartModel.InvalidatePlot(false);
args.Handled = true;
}
public JsonResult Infos()
{
PriceDataModel2 db = new PriceDataModel2();
List <ChartModel> chartModels = new List <ChartModel>();
var stores = db.Stores.Where(p => p.isActive == true).ToList();
var money = db.OfferDet.ToList();
var orders = db.OfferMas.ToList();
foreach (var item in stores)
{
ChartModel chart = new ChartModel();
chart.storeName = item.StoreName;
foreach (var ord in orders)
{
if (ord.Store.Id == item.Id && ord.IsActive == true && ord.Status == 2)
{
chart.storeOrder += 1;
foreach (var mon in money)
{
if (ord.ID == mon.BasketMas_ID)
{
chart.storeMoney = chart.storeMoney + (mon.Price * mon.Quantity);
}
}
}
}
chartModels.Add(chart);
}
return(Json(chartModels, JsonRequestBehavior.AllowGet));
}
public Chart(ChartType type, ChartModel model)
{
_model = model;
_type = type;
// Initialize the default values
_initDefaultValues();
System.IO.Stream s = this.GetType().Assembly.GetManifestResourceStream("FreeSilverlightChart.Chart.xaml");
_chartCanvas = XamlReader.Load(new System.IO.StreamReader(s).ReadToEnd()) as Canvas;
_timer = _chartCanvas.FindName("timer") as Storyboard;
this.Children.Add(_chartCanvas);
}
public HorizontalBarChart(ChartType type, ChartModel model) : base(type, model)
{
}
public static Chart CreateChart(ChartType type, ChartModel model)
{
Chart chart = null;
if (type == ChartType.VBAR ||
type == ChartType.VBAR_STACKED ||
type == ChartType.BAR_LINE_COMBO ||
type == ChartType.BAR_AREA_COMBO ||
type == ChartType.BAR_LINE_AREA_COMBO)
{
chart = new BarChart(type, model);
}
else if (type == ChartType.HBAR || type == ChartType.HBAR_STACKED)
{
chart = new HorizontalBarChart(type, model);
}
else if( type == ChartType.CYLINDERBAR)
{
chart = new CylinderBarChart(type, model);
}
else if (type == ChartType.PIE)
{
chart = new PieChart(type, model);
}
else if (type == ChartType.AREA || type == ChartType.AREA_STACKED)
{
chart = new AreaChart(type, model);
}
else if (type == ChartType.LINE)
{
chart = new LineChart(type, model);
}
else if (type == ChartType.SCATTER_PLOT)
{
chart = new ScatterPlotChart(type, model);
}
else if (type == ChartType.XYLINE)
{
chart = new XYLineChart(type, model);
}
else if (type == ChartType.RADAR || type == ChartType.RADAR_AREA)
{
chart = new RadarChart(type, model);
}
else if (type == ChartType.FUNNEL)
{
chart = new FunnelChart(type, model);
}
else if (type == ChartType.SEMI_CIRCULAR_GAUGE)
{
chart = new SemiCircularGaugeChart(type, model);
}
else if (type == ChartType.CIRCULAR_GAUGE)
{
chart = new GaugeChart(type, model);
}
else if (type == ChartType.CANDLE_STICK)
{
chart = new CandleStickChart(type, model);
}
return chart;
}
