public ActionResult CellList(int collectionId, string searchStr, int pageIndex = 1)
{
if (Session["admin"] != null)
{
ViewBag.searchStr = searchStr;
AudioCollections audioCollection = db.AudioCollections.Find(collectionId);
ViewBag.CollectionName = audioCollection.Title;
ViewBag.Category = audioCollection.Category;
ViewBag.Category = audioCollection.Category;
if (!string.IsNullOrEmpty(searchStr))
{
var audios = db.Audios.Where(item => item.AudioCollectionId == collectionId && item.Title.Contains(searchStr));
int count = audios.Count();
audios = audios.OrderByDescending(item => item.Id).Skip(pageSize * (pageIndex - 1)).Take(pageSize);
CellInitPage(collectionId, pageIndex, count);
return(View(audios));
}
else
{
var audios = db.Audios.Where(item => item.AudioCollectionId == collectionId).OrderByDescending(item => item.Id).Skip(pageSize * (pageIndex - 1)).Take(pageSize);
int count = db.Audios.Where(item => item.AudioCollectionId == collectionId).Count();
CellInitPage(collectionId, pageIndex, count);
return(View(audios));
}
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult GetAudioDetailList()
{
var stream = HttpContext.Request.InputStream;
string requestJson = new StreamReader(stream).ReadToEnd(); //json 字符串在此
JObject jo = (JObject)JsonConvert.DeserializeObject(requestJson);
int audeoCollectionId = Convert.ToInt32(jo["audioId"].ToString());
AudioCollections audeoCollection = db.AudioCollections.Find(audeoCollectionId);
List <Audios> audios = db.Audios.Where(item => item.AudioCollectionId == audeoCollectionId).ToList();
AudioDetailData audioDetailData = new AudioDetailData();
audioDetailData.Id = audeoCollection.Id;
audioDetailData.Title = audeoCollection.Title;
audioDetailData.CreateTime = audeoCollection.CreateTime.ToString("yyyy-MM-dd");
audioDetailData.Level = audeoCollection.Grade;
audioDetailData.Tags = audeoCollection.Tags;
audioDetailData.Content = "/admin/audio/preview/" + audeoCollectionId;
List <AudioDetail> videoDetails = new List <AudioDetail>();
foreach (Audios audio in audios)
{
AudioDetail audioDetail = new AudioDetail();
audioDetail.Id = audio.Id;
int originalWidth = 0;
int originalHeight = 0;
if (audio.AudioIndex != null)
{
audioDetail.PicAD = audio.AudioIndex;
System.Drawing.Image imgOriginal = System.Drawing.Image.FromFile(Server.MapPath(HttpUtility.UrlDecode(audio.AudioIndex)));
originalWidth = imgOriginal.Width;
originalHeight = imgOriginal.Height;
}
else
{
audioDetail.PicAD = "";
}
audioDetail.PicWidth = originalWidth;
audioDetail.PicHeight = originalHeight;
audioDetail.Title = audio.Title;
if (audio.AudioLink != null)
{
audioDetail.AudioLink = audio.AudioLink;
}
else
{
audioDetail.AudioLink = "";
}
videoDetails.Add(audioDetail);
}
audioDetailData.AudioDetail = videoDetails;
return(Json(new { data = audioDetailData }));
}
public ActionResult Edit(int id)
{
if (Session["admin"] != null)
{
ViewBag.IsCreate = true;
AudioCollections audioCollections = db.AudioCollections.Find(id);
return(View("Edit", audioCollections));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult Create(int category)
{
if (Session["admin"] != null)
{
ViewBag.IsCreate = false;
AudioCollections audioCollections = new AudioCollections();
audioCollections.Category = category;
return(View("Edit", audioCollections));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult CellEdit(int id)
{
if (Session["admin"] != null)
{
ViewBag.IsCreate = true;
Audios audio = db.Audios.Find(id);
AudioCollections audioCollection = db.AudioCollections.Find(audio.AudioCollectionId);
ViewBag.CollectionName = audioCollection.Title;
ViewBag.Category = audioCollection.Category;
return(View("CellEdit", audio));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult CellCreate(int collectionId)
{
if (Session["admin"] != null)
{
AudioCollections audioCollection = db.AudioCollections.Find(collectionId);
ViewBag.CollectionName = audioCollection.Title;
ViewBag.Category = audioCollection.Category;
ViewBag.IsCreate = false;
Audios audio = new Audios();
audio.AudioCollectionId = collectionId;
return(View("CellEdit", audio));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult SaveEdit(AudioCollections audioCollections, bool IsCreate)
{
if (Session["admin"] != null)
{
if (IsCreate)
{
audioCollections.UpdateTime = DateTime.Now;
db.Entry(audioCollections).State = EntityState.Modified;
}
else
{
audioCollections.CreateTime = DateTime.Now;
audioCollections.UpdateTime = DateTime.Now;
db.AudioCollections.Add(audioCollections);
}
db.SaveChanges();
return(RedirectToAction("List", new { category = audioCollections.Category }));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult Preview(int id)
{
AudioCollections article = db.AudioCollections.Find(id);
return(View(article));
}
