public ActionResult List()
        {
            T_ActivityAreaBll bll = new T_ActivityAreaBll();
            var model             = bll.GetList();

            return(View(model));
        }
        public ActionResult AreaList()
        {
            T_ActivityAreaBll bll = new T_ActivityAreaBll();

            var list = bll.GetList();

            return(View(list));
        }
        //全国经销商活动场次统计
        public Dictionary <string, object> GetAgencyStatisticsList()
        {
            T_SaleActivityTypeBll typebll     = new T_SaleActivityTypeBll();
            T_AgencyBll           t_agencybll = new T_AgencyBll();
            T_ActivityAreaBll     areabll     = new T_ActivityAreaBll();
            var    arealist   = areabll.GetList();
            var    typelist   = typebll.GetList();
            var    agencylist = t_agencybll.GetList();
            string begintime  = HttpContext.Current.Request.Form["begintime"].ToString();
            string endtime    = HttpContext.Current.Request.Form["endtime"].ToString();
            string areaid     = HttpContext.Current.Request.Form["areaid"].ToString();
            string strwhere   = "IsDelete=0";

            if (!string.IsNullOrEmpty(begintime))
            {
                strwhere += " and ActivityDate>='" + begintime + "'";
            }
            if (!string.IsNullOrEmpty(endtime))
            {
                strwhere += " and ActivityDate<='" + endtime + "'";
            }
            if (!string.IsNullOrEmpty(areaid))
            {
                strwhere += " and saleactivitytypeid=" + areaid;
            }
            else
            {
                strwhere += " and saleactivitytypeid=" + arealist[0];
            }
            string date       = DateTime.Now.Year.ToString() + "-01-01";
            int    indexmonth = DateTime.Now.Month;
            var    listmonth  = new List <int>();

            for (int i = 1; i < indexmonth + 1; i++)
            {
                listmonth.Add(i);
            }
            var database = DataFactory.Database();

            var dsaverage = database.FindDataSetBySql("select DATEPART(month, ActivityDate) as nmonth,agencyid,saleactivitytypeid from T_SaleActivity   where datediff(year, ActivityDate, '" + date + "') = 0 group by AgencyId, DATEPART(month, ActivityDate),SaleActivityTypeId order by DATEPART(month, ActivityDate)");
            List <AgencyStatisticsViewModel> listview = new List <AgencyStatisticsViewModel>();

            foreach (var item in agencylist)
            {
                var model = new AgencyStatisticsViewModel();
                model.AgencyName = item.AgencyName;
                model.AgencyId   = item.AgencyId;
                List <Months> listmonthview = new List <Months>();
                foreach (var item1 in listmonth)
                {
                    var monthview = new Months();
                    monthview.Month = item1.ToString();
                    List <int> listid   = new List <int>();
                    var        dsselect = dsaverage.Tables[0].Select("nmonth=" + item1.ToString() + " and agencyid=" + item.AgencyId + "");
                    foreach (var item2 in dsselect)
                    {
                        if (!listid.Contains(int.Parse(item2["saleactivitytypeid"].ToString())))
                        {
                            listid.Add(int.Parse(item2["saleactivitytypeid"].ToString()));
                        }
                    }
                    monthview.SaleActivityTypeIdList = listid;
                    listmonthview.Add(monthview);
                }
                model.listmonth = listmonthview;


                listview.Add(model);
            }
            return(new Dictionary <string, object>
            {
                { "code", 1 },
                { "typelist", typelist.Select(a => new { saleactivitytypeid = a.SaleActivityTypeId, saleactivitytypename = a.SaleActivityTypeName }) },
                { "agencylist", agencylist.Select(a => new { agencyid = a.AgencyId, agencyname = a.AgencyName }) },
                { "list", listview },
                { "monthlist", listmonth },
                { "arealist", arealist }
            });
        }