public IHttpActionResult Echart_Cruises_Class(string ksrq, string jsrq, string cruisesno = "")
{
try
{
CruisesReport rep = new CruisesReport();
var list = rep.Cruises_Rc_Class(ksrq, jsrq, cruisesno).OrderByDescending(t => t.je);
var cruiseslist = list.Select(t => new { cruisesno = t.cruisesno, cruisesname = t.cruisesname }).Distinct();
var placelist = list.Select(t => new { placeno = t.placeno, placename = t.placename }).Distinct();
List <dynamic> jelist = new List <dynamic>();
foreach (var sitem in placelist)
{
var datalist = new List <decimal>();
var tempdata = new { name = sitem.placename, type = "bar", label = "labelOption", data = datalist };
foreach (var item in cruiseslist)
{
var je = list.Where(t => t.cruisesno == item.cruisesno && t.placeno == sitem.placeno).Sum(t => (decimal)t.je);
datalist.Add(je);
}
jelist.Add(tempdata);
}
return(Json(new { code = 1, msg = "ok", list = list, cruiseslist = cruiseslist, placelist = placelist, jelist = jelist }));
}
catch (Exception e)
{
return(Json(new { code = 0, msg = e.Message }));
}
}
public IHttpActionResult Cruises_Class_Rank(string ksrq, string jsrq, string cruisesno = "")
{
try
{
CruisesReport rep = new CruisesReport();
var list = rep.Cruises_Rc_Class(ksrq, jsrq, cruisesno).GroupBy(t => new { t.typeno, t.typename }).Select(t => new { t.Key.typeno, t.Key.typename, je = t.Sum(x => (decimal)x.je) }).OrderByDescending(t => t.je);
return(Json(new { code = 1, msg = "ok", list = list }));
}
catch (Exception e)
{
return(Json(new { code = 0, msg = e.Message }));
}
}
