public ActionResult DeleteFriendLink() { if (!AppData.IsManagerLogin) { return(Json(new { success = false, msg = "您未登录后台或会话已过期" })); } if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 1903)) { return(Json(new { success = false, msg = "您没有执行该操作的权限" })); } FriendLinkBLL friendLinkBLL = new FriendLinkBLL(); Validation vld = new Validation(); int id = vld.GetInt("id"); if (id != 0) { FriendLinkObj friendLinkObj = friendLinkBLL.GetFriendLinkByID(id); System.IO.File.Delete(Config.MediaPath + friendLinkObj.Pic); friendLinkBLL.DeleteFriendLink(id); } return(Json(new { success = true })); }
public void AddFriendLink(FriendLinkObj friendLinkObj) { using (helper = new SqlHelper()) { helper.AddStringParameter("@FriendName", 200, friendLinkObj.FriendName); helper.AddStringParameter("@Url", 200, friendLinkObj.Url); helper.AddStringParameter("@Pic", 200, friendLinkObj.Pic); helper.AddIntParameter("@Sort", friendLinkObj.Sort); helper.ExecuteNonQuery("insert into FriendLinks (FriendName,Url,Pic,Sort) values (@FriendName,@Url,@Pic,@Sort)", CommandType.Text); } }
public void ModifyFriendLink(FriendLinkObj friendLinkObj) { using (helper = new SqlHelper()) { helper.AddIntParameter("@FriendID", friendLinkObj.FriendID); helper.AddStringParameter("@FriendName", 200, friendLinkObj.FriendName); helper.AddStringParameter("@Url", 200, friendLinkObj.Url); helper.AddStringParameter("@Pic", 200, friendLinkObj.Pic); helper.AddIntParameter("@Sort", friendLinkObj.Sort); helper.ExecuteNonQuery("update FriendLinks set FriendName=@FriendName,Url=@Url,Pic=@Pic,Sort=@Sort where FriendID=@FriendID", CommandType.Text); } }
public FriendLinkObj GetFriendLinkByID(int friendId) { using (helper = new SqlHelper()) { helper.AddIntParameter("@FriendID", friendId); using (SqlDataReader dr = helper.ExecuteReader("select FriendName,Url,Pic,Sort from FriendLinks where FriendID=@FriendID", CommandType.Text)) { if (dr.HasRows && dr.Read()) { FriendLinkObj friendLinkObj = new FriendLinkObj(); friendLinkObj.FriendID = friendId; friendLinkObj.FriendName = dr[0] == DBNull.Value ? null : (string)dr[0]; friendLinkObj.Url = dr[1] == DBNull.Value ? null : (string)dr[1]; friendLinkObj.Pic = dr[2] == DBNull.Value ? null : (string)dr[2]; friendLinkObj.Sort = dr[3] == DBNull.Value ? 0 : (int)dr[3]; return(friendLinkObj); } return(null); } } }
public void ModifyFriendLink(FriendLinkObj friendLinkObj) { dal.ModifyFriendLink(friendLinkObj); }
public void AddFriendLink(FriendLinkObj friendLinkObj) { dal.AddFriendLink(friendLinkObj); }
public ActionResult AddFriendLink() { if (Request.HttpMethod != "POST") { if (!AppData.IsManagerLogin) { return(Redirect("/Manage/Error/1.html")); } if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 1901)) { return(Redirect("/Manage/Error/2.html")); } return(View()); } else { if (!AppData.IsManagerLogin) { return(Result(false, "您未登录后台或会话已过期")); } if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 1901)) { return(Result(false, "您没有执行该操作的权限")); } FriendLinkBLL friendLinkBLL = new FriendLinkBLL(); HttpPostedFileBase pic = Request.Files["pic"]; if (pic == null || pic.ContentLength == 0) { return(Result(false, "请选择一张图片上传")); } string ext = System.IO.Path.GetExtension(pic.FileName); if (!Regex.IsMatch(ext, @"^\.(gif|jpg|jpeg|png)$", RegexOptions.IgnoreCase)) { return(Result(false, "上传的图片格式不合要求,请上传gif,png,jpg格式的图片")); } Validation vld = new Validation(); FriendLinkObj friendLinkObj = new FriendLinkObj(); friendLinkObj.FriendName = vld.Get("name", false); friendLinkObj.Url = vld.Get("url", false); if (vld.HasError) { return(Result(false, "数据填写不完整")); } string dirPath = Config.MediaPath + @"\Upload"; if (!Directory.Exists(dirPath)) { Directory.CreateDirectory(dirPath); } string newFileName = DateTime.Now.ToString("yyyyMMddHHmmss_ffff") + ext; string savePath = Path.Combine(dirPath, newFileName); friendLinkObj.Pic = "/Upload/" + newFileName; friendLinkBLL.AddFriendLink(friendLinkObj); pic.SaveAs(savePath); return(Result(true)); } }