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();
}
