/// <summary>
        /// 添加/编辑
        /// </summary>
        /// <returns></returns>
        public ActionResult AdertEdit()
        {
            //绑定广告位置
            BLL.AdertPositionBase apbll = new BLL.AdertPositionBase();
            List<Model.AdertPositionBase> listadert= apbll.GetModelList(" p_Delete=0 and p_Status=0 ");
            List<SelectListItem> seltype = new List<SelectListItem>();
            seltype = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
            for (int i = 0; i < listadert.Count; i++)
            {
                seltype.Add(new SelectListItem
                {
                    Value = listadert[i].p_ID.ToString(),
                    Text = listadert[i].p_PositionName
                });
            }
            ViewData["AdertPosition"] = new SelectList(seltype, "Value", "Text", "请选择");

            //绑定广告分类
            BLL.ProductTypeBase ptbll = new BLL.ProductTypeBase();
            List<Model.ProductTypeBase> modelType = ptbll.GetModelList(" pt_ParentId = 0  and pt_IsDel=0 and pt_StatusCode=0");

            List<SelectListItem> selectType = new List<SelectListItem>();
            selectType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
            for (int i = 0; i < modelType.Count; i++)
            {
                selectType.Add(new SelectListItem
                {
                    Value = modelType[i].pt_ID.ToString(),
                    Text = modelType[i].pt_Name
                });
            }
            ViewData["AdertFenLeiPosition"] = new SelectList(selectType, "Value", "Text", "请选择");

            ViewData["otype"] = RequestBase.GetString("otype");
            if (RequestBase.GetString("a_ID") != null && RequestBase.GetString("a_ID") != "")
            {
                Model.Adert adert = new BLL.Adert().GetModel(int.Parse(RequestBase.GetString("a_ID")));
                ViewData["AdertPosition"] = new SelectList(seltype, "Value", "Text", adert.a_PID);

                if (adert.a_spare2 != null)
                {
                    ViewData["AdertFenLeiPosition"] = new SelectList(selectType, "Value", "Text", adert.a_spare2);
                }
                else {

                }

                ViewData["picurl"] = adert.a_Image;
                return View(adert);
            }
            else {
                return View();
            }
        }
        /// <summary>
        /// 广告位置添加
        /// </summary>
        /// <returns></returns>
        public ActionResult AdertPositionEdit()
        {
            //BLL.ProductTypeBase ptbll = new BLL.ProductTypeBase();
            //List<Model.ProductTypeBase> modelType = ptbll.GetModelList(" pt_ParentId = 0 and pt_IsDel=0");

            //List<SelectListItem> selectType = new List<SelectListItem>();
            //selectType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
            //for (int i = 0; i < modelType.Count; i++)
            //{
            //    selectType.Add(new SelectListItem
            //    {
            //        Value = modelType[i].pt_ID.ToString(),
            //        Text = modelType[i].pt_Name
            //    });
            //}
            //ViewData["AdertType"] = new SelectList(selectType, "Value", "Text", "请选择");
            //List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" }, new SelectListItem { Text = "左边", Value = "0" }, new SelectListItem { Text = "下边", Value = "1" } };
            //ViewData["XianshiPosition"] = new SelectList(select1, "Value", "Text", "请选择");
            ViewData["otype"] = RequestBase.GetString("otype");
            if (RequestBase.GetString("p_ID") != null && RequestBase.GetString("p_ID") != "")
            {
                Model.AdertPositionBase apmodel = new Model.AdertPositionBase();
                apmodel = new BLL.AdertPositionBase().GetModel(int.Parse(RequestBase.GetString("p_ID")));

                Model.AdertPositionBase adert = new BLL.AdertPositionBase().GetModel(int.Parse(RequestBase.GetString("p_ID")));
                //DataSet ptdataset = new BLL.ProductTypeBase().GetList(" pt_Name='" + adert.p_PositionExplain + "'");
                //int ptid = int.Parse(ptdataset.Tables[0].Rows[0]["pt_ID"].ToString());
                //ViewData["AdertType"] = new SelectList(selectType, "Value", "Text", ptid);

                //if (adert.p_showposition == "0")//广告位置在左边时
                //{
                //    ViewData["XianshiPosition"] = new SelectList(select1, "Value", "Text", 0);
                //}
                //else
                //{
                //    ViewData["XianshiPosition"] = new SelectList(select1, "Value", "Text", 1);
                //}
                return View(adert);
            }
            else
            {
                return View();
            }
        }
        public ActionResult Save(Model.Adert model)
        {
            bool result = false;

            try
            {
                if (Request.Form["AdertPosition"] == "-1")
                {
                    return Content(DWZUtil.GetResultJson("300", "保存失败!!请选择广告位置", "", "", ""));
                }
                else if (Request.Form["FileInputEId"].ToString() == "") {
                    return Content(DWZUtil.GetResultJson("300", "保存失败!!请上传一张广告图片", "", "", ""));
                }
                else
                {
                    if (Request.Form["txbotype"] == "add")
                    {
                        model.a_PID = int.Parse(Request.Form["AdertPosition"]);//广告位置ID
                        Model.AdertPositionBase apmodel = new BLL.AdertPositionBase().GetModel(int.Parse(Request.Form["AdertPosition"]));
                        model.a_spare1 = apmodel.p_PositionName;//广告位置名称
                        if (Request.Form["AdertFenLeiPosition"] == "-1")
                        {
                        }
                        else {
                            model.a_spare2 = int.Parse(Request.Form["AdertFenLeiPosition"]);
                        }

                        model.a_Image = Request.Form["FileInputEId"].ToString();
                        model.a_CreateUser = base.EmployeeBase.e_ID;
                        result = adertbll.Add(model) > 0 ? true : false;

                    }
                    else
                    {
                        model.a_PID = int.Parse(Request.Form["AdertPosition"]);
                        if (Request.Form["AdertFenLeiPosition"] == "-1")
                        {

                        }
                        else {
                            model.a_spare2 = int.Parse(Request.Form["AdertFenLeiPosition"]);
                        }
                        Model.AdertPositionBase adertmodel =new BLL.AdertPositionBase().GetModel(model.a_PID);
                        model.a_spare1 = adertmodel.p_PositionName;
                        model.a_Image = Request.Form["FileInputEId"].ToString();
                        result = adertbll.Update(model);
                    }
                }

                if (result)
                {
                    return Content(DWZUtil.GetResultJson("200", "操作成功!!", "w_广告管理", "", "closeCurrent"));
                }
                else
                {
                    return Content(DWZUtil.GetResultJson("300", "保存失败!!", "", "", ""));
                }
            }
            catch
            {
                return Content(DWZUtil.GetResultJson("300", "保存失败!!", "", "", ""));
            }
        }
        /// <summary>
        /// 输入积分控制下拉框value
        /// </summary>
        /// <returns></returns>
        public string getScore()
        {
            string data = "";//返回页面的数据
            try
            {
                int score = int.Parse(RequestBase.GetString("aa"));//得到广告位置id
                if (score.ToString() != "")//如果页面输入的是正整数
                {
                    Model.AdertPositionBase moap = new BLL.AdertPositionBase().GetModel(score);
                    data = moap.p_PositionExplain;
                }
                else
                {
                    data = "error 请选择广告位置";
                }
            }
            catch (Exception)
            {

                data = "error";
            }
            return data;
        }
        //广告管理
        // GET: /Adert/
        /// <summary>
        /// 广告列表页
        /// </summary>
        /// <returns></returns>
        public ActionResult AdertMsg()
        {
            //绑定广告分类
            BLL.ProductTypeBase ptbll = new BLL.ProductTypeBase();
            List<Model.ProductTypeBase> modelType = ptbll.GetModelList(" pt_ParentId = 0  and pt_IsDel=0 and pt_StatusCode=0");

            List<SelectListItem> selectType = new List<SelectListItem>();
            selectType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
            for (int i = 0; i < modelType.Count; i++)
            {
                selectType.Add(new SelectListItem
                {
                    Value = modelType[i].pt_ID.ToString(),
                    Text = modelType[i].pt_Name
                });
            }
            ViewData["AdertFenLeiPosition"] = new SelectList(selectType, "Value", "Text", "请选择");

            //绑定广告位置
            BLL.AdertPositionBase apbll = new BLL.AdertPositionBase();
            List<Model.AdertPositionBase> listap = apbll.GetModelList(" p_Status = 0 and p_Delete=0");

            List<SelectListItem> selectposition = new List<SelectListItem>();
            selectposition = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
            for (int i = 0; i < listap.Count; i++)
            {
                selectposition.Add(new SelectListItem
                {
                    Value = listap[i].p_ID.ToString(),
                    Text = listap[i].p_PositionName
                });
            }
            ViewData["AdertPosition"] = new SelectList(selectposition, "Value", "Text", "请选择");

            return View();
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <returns></returns>
        public ActionResult Delete()
        {
            string pid = RequestBase.GetString("p_ID");
            Model.AdertPositionBase apmodel = new Model.AdertPositionBase();
            apmodel = new BLL.AdertPositionBase().GetModel(int.Parse(pid));
            bool result = false;
            try
            {
                if (apmodel.p_PositionExplain == "1")
                {
                    return Content(DWZUtil.GetResultJson("300", "删除失败!!此广告位为固定广告位不能进行此操作!", "", "", ""));
                }
                else
                {
                    Model.AdertPositionBase adertposition = apbll.GetModel(int.Parse(RequestBase.GetString("p_ID")));
                    adertposition.p_Delete = 1;
                    result = apbll.Update(adertposition);
                    if (result)
                    {
                        return Content(DWZUtil.GetAjaxTodoJson("200", "删除成功!!", "w_广告位置管理", "", "forward", "AdertPositionBox", ""));
                    }
                    else
                    {
                        return Content(DWZUtil.GetResultJson("300", "删除失败!!", "", "", ""));
                    }
                }

            }
            catch
            {
                return Content(DWZUtil.GetResultJson("300", "删除失败!!", "", "", ""));
            }
        }
        /// <summary>
        /// 获取广告
        /// </summary>
        /// <param name="viewName">view名称</param>
        /// <param name="ptID">分类ID</param>
        /// <param name="isBottom">是否底部</param>
        public void GetProductTypeAds(string viewName, int ptID, bool isBottom)
        {
            BLL.AdertPositionBase adp = new BLL.AdertPositionBase();
            string sql = string.Empty;
            if (isBottom)
            {
                sql = "p_Status = 0 and p_Delete = 0 and p_producttype = " + ptID + "and p_showposition = 1";
            }
            else
            {
                sql = "p_Status = 0 and p_Delete = 0 and p_producttype = " + ptID + "and p_showposition = 0";
            }

            var model = adp.GetModelList(sql).FirstOrDefault();
            if (model != null)
            {
                var list = new BLL.Adert().GetModelList(" a_Status = 0 and a_Delete = 0 and a_PID = " + model.p_ID);
                ViewData[viewName] = list;
            }
        }