public ActionResult Add(Slide slide) { if (Session["UserId"] == null) { return Redirect("/admin/login"); } if (slide != null) { if (!string.IsNullOrEmpty(slide.Title) && !string.IsNullOrEmpty(slide.Url) && !string.IsNullOrEmpty(slide.Image)) { SlideService slideService = new SlideService(); slideService.AddSlide(slide); } } return Redirect(Request.UrlReferrer.AbsoluteUri); }
/// <summary> /// 添加幻灯片 /// </summary> public string AddSlide(Slide slide) { string result = "添加失败"; var conn = DBRepository.GetSqlConnection(); try { conn.Open(); if (slide != null) { if (!string.IsNullOrEmpty(slide.Title) && !string.IsNullOrEmpty(slide.Url) && !string.IsNullOrEmpty(slide.Image)) { slide.InsertTime = DateTime.Now; List<string> filterColumns = new List<string>() { "Id" }; if (DBRepository.Insert<Slide>(slide, conn, filterColumns)) { result = "success"; } } } else { result = "slide对象为空"; LogService.Log("SlideService.AddSlide", "slide对象为空"); } } catch (Exception e) { result = "程序出现异常,详情见日志"; LogService.Log("添加幻灯片", e.ToString()); } finally { conn.Close(); } return result; }
private static void GetHomeSlides(ref HomeData homeData, SqlDataReader reader) { homeData.Slides = new List<Slide>(); while (reader.Read()) { Slide slide = new Slide { Id = reader[0] != DBNull.Value ? reader.GetInt32(0) : 0, Title = reader[0] != DBNull.Value ? reader.GetString(1) : string.Empty, Url = reader[0] != DBNull.Value ? reader.GetString(2) : string.Empty, Image = reader[0] != DBNull.Value ? reader.GetString(3) : string.Empty, InsertTime = reader[0] != DBNull.Value ? reader.GetDateTime(4) : DateTime.Now }; homeData.Slides.Add(slide); } reader.NextResult(); }