public ActionResult AddPhotoPoint() { if (!AppData.IsManagerLogin) { return(HandleResult(false, "您未登录后台或会话已过期")); } if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 1001)) { return(HandleResult(false, "您没有执行该操作的权限")); } Validation vld = new Validation(); PhotoPointObj photoPointObj = new PhotoPointObj(); photoPointObj.PhotoID = vld.GetInt("photoID", false, "请传入照片编号"); photoPointObj.X = vld.GetInt("x", false, "请传入照片X坐标"); photoPointObj.Y = vld.GetInt("y", false, "请传入照片Y坐标"); photoPointObj.Name = vld.Get("name", false, "请填写照片名称"); photoPointObj.Cap = vld.Get("cab"); HttpPostedFileBase pic = Request.Files.Count == 0 ? null : Request.Files[0]; if (pic == null || pic.ContentLength == 0) { return(HandleResult(false, "请选择一张照片")); } if (vld.HasError) { return(HandleResult(false, vld.GetError())); } string ext = Path.GetExtension(pic.FileName); if (!Regex.IsMatch(ext, @"^\.(gif|jpg|jpeg|png)$", RegexOptions.IgnoreCase)) { return(HandleResult(false, "上传的图片格式不合要求,请上传gif,png,jpg格式的图片")); } string path = DateTime.Now.ToString("yyyyMMdd"); string dirPath = Config.MediaPath + @"\Package\" + path; if (!Directory.Exists(dirPath)) { Directory.CreateDirectory(dirPath); } string newFileName = DateTime.Now.ToString("yyyyMMddHHmmss_ffff") + ext; string savePath = Path.Combine(dirPath, newFileName); pic.SaveAs(savePath); photoPointObj.Pic = "/Package/" + path + "/" + newFileName; PhotoBLL photoBLL = new PhotoBLL(); photoBLL.AddPhotoPoint(photoPointObj); return(HandleResult(true, photoPointObj.PhotoID.ToString())); }
public void ModifyPhotoPoint(PhotoPointObj photoPointObj) { using (helper = new SqlHelper()) { helper.AddIntParameter("@PointID", photoPointObj.PointID); helper.AddIntParameter("@PhotoID", photoPointObj.PhotoID); helper.AddIntParameter("@X", photoPointObj.X); helper.AddIntParameter("@Y", photoPointObj.Y); helper.AddStringParameter("@Pic", 500, photoPointObj.Pic); helper.AddStringParameter("@Name", 500, photoPointObj.Name); helper.AddTextParameter("@Cap", photoPointObj.Cap); helper.ExecuteNonQuery("update PhotoPoints set PhotoID=@PhotoID,X=@X,Y=@Y,Pic=@Pic,Name=@Name,Cap=@Cap where PointID=@PointID", CommandType.Text); } }
public void AddPhotoPoint(PhotoPointObj photoPointObj) { using (helper = new SqlHelper()) { var id = helper.AddOutputParameter("@PointID"); helper.AddIntParameter("@PhotoID", photoPointObj.PhotoID); helper.AddIntParameter("@X", photoPointObj.X); helper.AddIntParameter("@Y", photoPointObj.Y); helper.AddStringParameter("@Pic", 500, photoPointObj.Pic); helper.AddStringParameter("@Name", 500, photoPointObj.Name); helper.AddTextParameter("@Cap", photoPointObj.Cap); helper.ExecuteNonQuery("insert into PhotoPoints (PhotoID,X,Y,Pic,Name,Cap) values (@PhotoID,@X,@Y,@Pic,@Name,@Cap) select @PointID=@@IDENTITY", CommandType.Text); photoPointObj.PointID = (int)id.Value; } }
public ActionResult DeletePhotoPoint() { if (!AppData.IsManagerLogin) { return(Json(new { success = false, msg = "您未登录后台或会话已过期" })); } if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 1003)) { return(Json(new { success = false, msg = "您没有执行该操作的权限" })); } Validation vld = new Validation(); int pointID = vld.GetInt("id", false, "请传入照片编号"); PhotoBLL photoBLL = new PhotoBLL(); PhotoPointObj photoPointObj = photoBLL.GetPhotoPointByID(pointID); System.IO.File.Delete(Config.MediaPath + photoPointObj.Pic.Replace("/", "\\")); photoBLL.DeletePhotoPoint(pointID); return(Json(new { success = true })); }
public PhotoPointObj GetPhotoPointByID(int pointID) { using (helper = new SqlHelper()) { helper.AddIntParameter("@PointID", pointID); using (SqlDataReader dr = helper.ExecuteReader("select PhotoID,X,Y,Pic,Name,Cap from PhotoPoints where PointID=@PointID", CommandType.Text)) { if (dr.HasRows && dr.Read()) { PhotoPointObj photoPointObj = new PhotoPointObj(); photoPointObj.PointID = pointID; photoPointObj.PhotoID = dr[0] == DBNull.Value ? 0 : (int)dr[0]; photoPointObj.X = dr[1] == DBNull.Value ? 0 : (int)dr[1]; photoPointObj.Y = dr[2] == DBNull.Value ? 0 : (int)dr[2]; photoPointObj.Pic = dr[3] == DBNull.Value ? null : (string)dr[3]; photoPointObj.Name = dr[4] == DBNull.Value ? null : (string)dr[4]; photoPointObj.Cap = dr[5] == DBNull.Value ? null : (string)dr[5]; return(photoPointObj); } return(null); } } }
public void ModifyPhotoPoint(PhotoPointObj photoPointObj) { dal.ModifyPhotoPoint(photoPointObj); }
public void AddPhotoPoint(PhotoPointObj photoPointObj) { dal.AddPhotoPoint(photoPointObj); }