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