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