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