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 Rc_SaleTop(string ksrq, string jsrq, string cruisesno = "")
{
try
{
CruisesReport rep = new CruisesReport();
var list = rep.RcSaleTop(ksrq, jsrq, cruisesno);
return(Json(new { code = 1, msg = "ok", list = list }));
}
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 }));
}
}
public IHttpActionResult RcIncome(string rcno)
{
try
{
CruisesReport rep = new CruisesReport();
var list = rep.RcIncome(rcno);
return(Json(new { code = 1, msg = "ok", list = list }));
}
catch (Exception e)
{
return(Json(new { code = 0, msg = e.Message }));
}
}
public IHttpActionResult cruisesincome_Report(string ksrq, string jsrq)
{
try
{
CruisesReport report = new CruisesReport();
var list = report.CruisesIncome(ksrq, jsrq);
return(Json(new { code = 1, msg = "ok", list = list }));
}
catch (Exception e)
{
return(Json(new { code = 0, msg = e.Message }));
}
}
public IHttpActionResult Cruises_RcSaleDetail(string rcno, int pageindex, int pagesize)
{
try
{
CruisesReport rep = new CruisesReport();
var list = rep.Cruises_RcSale_Detail(rcno).OrderBy(t => t.placeno).ToPagedList(pageindex, pagesize);
return(Json(new { code = 1, msg = "ok", list = list, resultcount = list.TotalItemCount }));
}
catch (Exception e)
{
return(Json(new { code = 0, msg = e.Message }));
}
}
public IHttpActionResult Echart_Cruises_Date(string ksrq, string jsrq)
{
try
{
CruisesReport rep = new CruisesReport();
var list = rep.CruisesIncome(ksrq, jsrq).OrderBy(t => t.cruisesno);
return(Json(new { code = 1, msg = "ok", list = list }));
}
catch (Exception e)
{
return(Json(new { code = 0, msg = e.Message }));
}
}
public IHttpActionResult Echart_CruisesRc(string ksrq, string jsrq)
{
try
{
CruisesReport rep = new CruisesReport();
var list = rep.CruisesRc(ksrq, jsrq, "").ToList().OrderBy(t => t.rcno);
return(Json(new {
code = 1,
msg = "ok",
list = list.ToList()
}));
}
catch (Exception e)
{
return(Json(new { code = 0, msg = e.Message }));
}
}
