//销售统计
        public ActionResult AgentUserNameIndexSale(int ID)
        {
            C_UserVM cuser = C_UserVM.GetVMByID(ID);

            ViewData["user"] = cuser;
            DateTime dt = DateTime.Now;

            ViewData["TheMonthSale"] = OrderCensus.GetLastMonthVal(string.Format("and ParentUser='******' and DatAudit >='{0}-{1}-01 00:00:00' and DatAudit <='{2}-{3}-01 00:00:00'", dt.Year, dt.Month, dt.AddMonths(1).Year, dt.AddMonths(1).Month))[0].SumPrice;
            ViewData["Sale"]         = OrderCensus.GetLastMonthVal(" and ParentUser='******'")[0].SumPrice;
            return(View());
        }
        //销售统计
        public ActionResult GetLastMonthValueSale(string ID)
        {
            string where = string.Empty;
            int            month     = 0;
            int            year      = 0;
            int            Nextmonth = 0;
            int            Nextyear  = 0;
            List <decimal> SumVal    = new List <decimal>();
            DateTime       dt        = DateTime.Now;

            for (int i = 5; i >= 1; i--)
            {
                year      = dt.AddMonths(-i).Year;
                month     = dt.AddMonths(-i).Month;
                Nextyear  = dt.AddMonths(-i + 1).Year;
                Nextmonth = dt.AddMonths(-i + 1).Month;
                where     = " and ParentUser='******'";
                where    += string.Format(" and DatAudit >='{0}-{1}-01 00:00:00' ", year, month);
                where    += string.Format(" and DatAudit <'{0}-{1}-01 00:00:00' ", Nextyear, Nextmonth);
                List <OrderCensusShow> list = OrderCensus.GetLastMonthVal(where);
                SumVal.Add(list[0].SumPrice);
            }
            return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(SumVal)));
        }