public MediaObj GetMedia(int mediaID)
{
using (helper = new SqlHelper())
{
helper.AddIntParameter("@MediaID", mediaID);
string sql = "select Description,Src,Type,SavePath,Url,Content from Media where MediaID=@MediaID";
using (SqlDataReader dr = helper.ExecuteReader(sql, CommandType.Text))
{
if (dr.HasRows && dr.Read())
{
MediaObj mediaObj = new MediaObj();
mediaObj.MediaID = mediaID;
mediaObj.Description = dr[0] == DBNull.Value ? null : (string)dr[0];
mediaObj.Src = dr[1] == DBNull.Value ? null : (string)dr[1];
mediaObj.Type = dr[2] == DBNull.Value ? 0 : (int)dr[2];
mediaObj.SavePath = dr[3] == DBNull.Value ? null : (string)dr[3];
mediaObj.Url = dr[4] == DBNull.Value ? null : (string)dr[4];
mediaObj.Content = dr[5] == DBNull.Value ? null : (string)dr[5];
return(mediaObj);
}
return(null);
}
}
}
public ActionResult Entrance()
{
ViewBag.cates = new ProductBLL().GetParentCates();
MediaBLL mediaBLL = new MediaBLL();
MediaObj mediaObj = mediaBLL.GetMedia(1);
ViewBag.media1 = mediaObj;
mediaObj = mediaBLL.GetMedia(2);
ViewBag.media2 = mediaObj;
mediaObj = mediaBLL.GetMedia(3);
ViewBag.media3 = mediaObj;
return(View());
}
public int SetMedia(MediaObj mediaObj)
{
using (helper = new SqlHelper())
{
string sql = "if exists (select 1 from Media where MediaID=@MediaID) update Media set Description=@Description,Src=@Src,Type=@Type,SavePath=@SavePath,Url=@Url,Content=@Content where MediaID=@MediaID else insert into Media (MediaID,Description,Src,Type,SavePath,Url,Content) values (@MediaID,@Description,@Src,@Type,@SavePath,@Url,@Content)";
helper.AddIntParameter("@MediaID", mediaObj.MediaID);
helper.AddStringParameter("@Description", 200, mediaObj.Description);
helper.AddStringParameter("@Src", 200, mediaObj.Src);
helper.AddIntParameter("@Type", mediaObj.Type);
helper.AddStringParameter("@SavePath", 200, mediaObj.SavePath);
helper.AddStringParameter("@Url", 200, mediaObj.Url);
helper.AddStringParameter("@Content", 2000, mediaObj.Content);
return(helper.ExecuteNonQuery(sql, CommandType.Text));
}
}
public ActionResult Index()
{
if (!AppData.IsManagerLogin)
{
return(Redirect("/Manage/Error/1.html"));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 16))
{
return(Redirect("/Manage/Error/2.html"));
}
MediaBLL mediaBLL = new MediaBLL();
MediaObj mediaObj = mediaBLL.GetMedia(1);
ViewBag.media1 = mediaObj;
mediaObj = mediaBLL.GetMedia(2);
ViewBag.media2 = mediaObj;
mediaObj = mediaBLL.GetMedia(3);
ViewBag.media3 = mediaObj;
mediaObj = mediaBLL.GetMedia(4);
ViewBag.media4 = mediaObj;
mediaObj = mediaBLL.GetMedia(5);
ViewBag.media5 = mediaObj;
mediaObj = mediaBLL.GetMedia(6);
ViewBag.media6 = mediaObj;
mediaObj = mediaBLL.GetMedia(7);
ViewBag.media7 = mediaObj;
mediaObj = mediaBLL.GetMedia(8);
ViewBag.media8 = mediaObj;
mediaObj = mediaBLL.GetMedia(9);
ViewBag.media9 = mediaObj;
mediaObj = mediaBLL.GetMedia(10);
ViewBag.media10 = mediaObj;
mediaObj = mediaBLL.GetMedia(11);
ViewBag.media11 = mediaObj;
mediaObj = mediaBLL.GetMedia(12);
ViewBag.media12 = mediaObj;
mediaObj = mediaBLL.GetMedia(13);
ViewBag.media13 = mediaObj;
mediaObj = mediaBLL.GetMedia(14);
ViewBag.media14 = mediaObj;
return(View());
}
public ActionResult Upload()
{
ViewBag.success = false;
if (!AppData.IsManagerLogin)
{
ViewBag.msg = "抱歉，您未登录后台或会话已过期!";
return(View());
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 1601))
{
ViewBag.msg = "您没有执行该操作的权限!";
return(View());
}
HttpPostedFileBase pic = Request.Files.Count == 0 ? null : Request.Files[0];
int mediaID = string.IsNullOrEmpty(Request.Form["id"]) ? 0 : int.Parse(Request.Form["id"]);
if (pic != null && !string.IsNullOrEmpty(pic.FileName))
{
int type = string.IsNullOrEmpty(Request.Form["type"]) ? 0 : int.Parse(Request.Form["type"]);
string ext = Path.GetExtension(pic.FileName);
if (type == 0)
{
if (!Regex.IsMatch(ext, @"^\.(gif|jpg|jpeg|png)$", RegexOptions.IgnoreCase))
{
ViewBag.msg = "上传的图片格式不合要求,请上传gif,png,jpg格式的图片";
return(View());
}
}
else if (type == 1)
{
if (!Regex.IsMatch(ext, @"^\.(mp3|wma)$", RegexOptions.IgnoreCase))
{
ViewBag.msg = "上传的图片格式不合要求,请上传mp3,wma格式的文件";
return(View());
}
}
string dirPath = Config.MediaPath + @"\Media";
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
MediaBLL mediaBLL = new MediaBLL();
MediaObj mediaObj = mediaBLL.GetMedia(mediaID);
if (mediaObj != null)
{
System.IO.File.Delete(Config.MediaPath + mediaObj.SavePath);
}
else
{
mediaObj = new MediaObj();
mediaObj.MediaID = mediaID;
}
string newFileName = DateTime.Now.ToString("yyyyMMddHHmmss_ffff") + ext;
string savePath = Path.Combine(dirPath, newFileName);
mediaObj.SavePath = @"\Media\" + newFileName;
mediaObj.Src = "/Media/" + newFileName;
mediaObj.Description = Request.Form["desc"];
mediaObj.Url = Request.Form["url"];
mediaObj.Content = Request.Form["content"];
mediaBLL.SetMedia(mediaObj);
pic.SaveAs(savePath);
ViewBag.success = true;
return(View());
}
else if (mediaID != 0)
{
MediaBLL mediaBLL = new MediaBLL();
MediaObj mediaObj = mediaBLL.GetMedia(mediaID);
mediaObj.Description = Request.Form["desc"];
mediaObj.Url = Request.Form["url"];
mediaObj.Content = Request.Form["content"];
mediaBLL.SetMedia(mediaObj);
ViewBag.success = true;
return(View());
}
else
{
ViewBag.msg = "请您选择一张图片上传";
return(View());
}
}
public int SetMedia(MediaObj mediaObj)
{
return(dal.SetMedia(mediaObj));
}
