// #region 专辑添加-编辑 public ActionResult AlbumAdd(VideoAlbumModel model, string ReturnUrl, int ClassId = 0, Nullable <int> myid = 0) { model.ClassId = ClassId; #region 获取来路路径 if (System.Web.HttpContext.Current.Request.UrlReferrer != null) { ViewBag.ReturnUrl = System.Web.HttpContext.Current.Request.UrlReferrer.PathAndQuery; } #endregion ViewBag.Headline = "专辑添加"; //栏目主题 ViewBag.ButtonValue = "添加"; //按钮名称 using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作 { if ((myid > 0) && (model.Operate == null)) { int mySelfId = 0; int.TryParse(myid.ToString(), out mySelfId); ViewBag.Headline = "看一看专辑编辑"; ViewBag.ButtonValue = "修改"; model.Operate = "edit"; // #region 取出数据 Child_Video_Album editRecord = myOperating.Child_Video_Album.FirstOrDefault(p => p.AlbumId == mySelfId); if (editRecord != null) { model.ClassId = editRecord.ClassId; model.AlbumId = editRecord.AlbumId; model.AlbumTitle = editRecord.AlbumTitle; model.AlbumImage = editRecord.AlbumImage; model.AlbumDescrib = editRecord.AlbumDescrib; model.OrderBy = editRecord.OrderBy; } #endregion } else if (model.Operate == "add") { #region 保存添加 if (ModelState.IsValid) { Child_Video_Album addRecord = new Child_Video_Album(); addRecord.ClassId = model.ClassId; addRecord.AlbumTitle = model.AlbumTitle; addRecord.AlbumImage = model.AlbumImage; addRecord.AlbumDescrib = model.AlbumDescrib; addRecord.AddDate = DateTime.Now; addRecord.VideoCount = 0; addRecord.PlayTimes = 0; addRecord.OrderBy = model.OrderBy; addRecord.Status = 200; // myOperating.Child_Video_Album.Add(addRecord); myOperating.SaveChanges(); model = null; // return(RedirectToLocal(ReturnUrl)); } else { ModelState.AddModelError("", "输入错误"); } #endregion } else if (model.Operate == "edit") { #region 保存编辑 if (ModelState.IsValid) { Child_Video_Album editSaveRecord = myOperating.Child_Video_Album.FirstOrDefault(p => p.AlbumId == model.AlbumId); if (editSaveRecord != null) { editSaveRecord.ClassId = model.ClassId; editSaveRecord.AlbumTitle = model.AlbumTitle; editSaveRecord.AlbumImage = model.AlbumImage; editSaveRecord.AlbumDescrib = model.AlbumDescrib; editSaveRecord.OrderBy = model.OrderBy; // myOperating.SaveChanges(); // return(RedirectToLocal(ReturnUrl)); } } else { ModelState.AddModelError("", "输入错误"); } #endregion } else { model.Operate = "add"; model.OrderBy = 1; } // List <Child_Video_Class> BookTable = myOperating.Child_Video_Class.ToList(); // ViewBag.DataList = BookTable; } // return(View(model)); }
//------------------------- #region 专辑列表 public ActionResult AlbumList(string currentpage, int ClassId = 0, long del = 0) { #region 翻页定义 ViewBag.CurrentPage = 0; //当前页 ViewBag.PPage = 0; //上一页 ViewBag.NPage = 0; //下一页 ViewBag.PageCount = 0; //总页数 ViewBag.RecordCount = 0; //记录总数 ViewBag.IsFirstPage = ""; //第一条记录,禁用首页和上一页 ViewBag.IsEndPage = ""; //最后条记录,禁用首页和下一页 #endregion // ViewBag.Headline = "专辑管理";//栏目主题 // ViewBag.DataList = null; ViewBag.RecordItem = null; ViewBag.Operate = "add"; //add添加;edit编辑取出数据;editsave编辑保存 // StatusData myStatusData = new StatusData(); //返回状态 // using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作 { #region 除 if (del > 0) { Child_Video_Album myDelRecord = myOperating.Child_Video_Album.FirstOrDefault(p => p.AlbumId == del); if (myDelRecord != null) { FunctionClass.delFile(myDelRecord.AlbumImage); myOperating.Child_Video_Album.Remove(myDelRecord); myOperating.SaveChanges(); } } #endregion // #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "OrderBy"; // //当前页 int sqlCurrentpage = 1; if (!String.IsNullOrWhiteSpace(currentpage)) { bool isOk = int.TryParse(currentpage, out sqlCurrentpage); if (!isOk) { sqlCurrentpage = 1; } } //页大小 int sqlPagesize = 10; #endregion // #region 取出内容 IQueryable <Child_Video_Album> myIQueryable = null; if (ClassId > 0) { myIQueryable = myOperating.Child_Video_Album.Where(p => p.ClassId == ClassId); } else { myIQueryable = myOperating.Child_Video_Album.Where(p => p.Status == 200); } // if (myIQueryable != null) { List <Child_Video_Album> BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true).ToList(); // ViewBag.DataList = BookTable; #region 页数取值 ViewBag.CurrentPage = sqlCurrentpage; ViewBag.PageCount = pageCount; ViewBag.RecordCount = recordCount; if (sqlCurrentpage > 1) { ViewBag.PPage = sqlCurrentpage - 1; } else { ViewBag.IsFirstPage = "disabled"; ViewBag.PPage = 1; } if (sqlCurrentpage < pageCount) { ViewBag.NPage = sqlCurrentpage + 1; } else { ViewBag.NPage = sqlCurrentpage; ViewBag.IsEndPage = "disabled"; } #endregion } #endregion ViewBag.ClassId = ClassId;//当前类别 List <Child_Video_Class> ClassTable = myOperating.Child_Video_Class.ToList(); // ViewBag.DataListClass = ClassTable; } return(View()); }