public async Task <IActionResult> Edit(Guid id, ProjectImageViewModel projectImageViewModel)
{
if (id != projectImageViewModel.Id)
{
return(NotFound());
}
ModelState.Remove("ProjectViewModel.Name");
ModelState.Remove("ProjectViewModel.Description");
if (!ModelState.IsValid)
{
return(View(projectImageViewModel));
}
//Delete Old File
if (projectImageViewModel.Image != null)
{
UploadFile.Delete(projectImageViewModel.Image);
}
string fileName = null;
try
{
fileName = await UploadFile.Add(projectImageViewModel.ImageUpload);
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
if (fileName == null)
{
return(View(projectImageViewModel));
}
projectImageViewModel.Image = fileName;
var projectImage = _mapper.Map <ProjectImage>(projectImageViewModel);
projectImage.ProjectId = projectImageViewModel.ProjectId;
await _projectImageRep.Update(projectImage);
await _projectImageRep.SaveChanges();
return(RedirectToAction("Index", new { id = projectImageViewModel.ProjectId }));
}
/// <summary>批量删除，根据JoinName和JoinId</summary>
/// <param name="joinName">相关表名，即UploadConfig.JoinName</param>
/// <param name="joinId">相关ID,即UploadConfig.JoinID</param>
public static void Upload_BatDelPic(string joinName, int joinId)
{
if (string.IsNullOrEmpty(joinName) || joinId < 1)
{
return;
}
//string sql = "select Id,Path from UploadFile where JoinName='+joinName+' and JoinId=" + joinId;
//-------------------------------------------------
var dt = UploadFile.Find(x => x.JoinId == joinId && x.JoinName == joinName);
foreach (var rs in dt)
{
DirFileHelper.DelPicFile(rs.Path);
UploadFile.Delete(x => x.Id == rs.Id);
}
}
/// <summary>根据 FilePath 删除 UploadFile的记录，不删除文件</summary>
/// <param name="filePath">FilePath</param>
private void Upload_DelRs(string filePath)
{
////设置条件
//var wheres = new List<ConditionFun.SqlqueryCondition>();
//wheres.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, UploadFileTable.Path, Comparison.Equals, filePath));
////查询
//var select = new SelectHelper();
//int id = ConvertHelper.Cint0(select.GetColumnsValue<UploadFile>(UploadFileTable.Id, wheres));
int id = ConvertHelper.Cint0(GetFieldValue(UploadFileTable.Id, UploadFileTable.Path, filePath, false));
//判断
if (id > 0)
{
UploadFile.Delete(x => x.Id == id);
}
//int k = SqlHelper.ExecuteScalarToInt("select top 1 Id from UploadFile where Path='" + filePath + "'");
//if (k > 0) {
// SqlHelper.ExecuteNonQuery("delete from UploadFile where Id=" + k.ToString());
//}
}
public async Task <IActionResult> DeletePost(Guid id)
{
var projectFromRep = await _projectRep.GetById(id);
if (projectFromRep == null)
{
return(NotFound());
}
// Update image
if (projectFromRep.MainImage != null)
{
// Delete Old image
UploadFile.Delete(projectFromRep.MainImage);
}
await _projectRep.Delete(id);
await _projectRep.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
/// <summary>
/// 图片操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnOperate_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
UploadFile model = UploadFiles.Where(x => x.Id == btn.Tag.ToString()).FirstOrDefault();
switch (btn.Content)
{
case "Del":
if (!CommonHelper.DeleteConfirm())
{
break;
}
UploadFiles.Remove(model);
model.Delete();
break;
case "Edit":
PhotoEditModule editModule = new PhotoEditModule
{
ParentControl = this,
UploadFile = model
};
App.CurrentWindow.brMain.Child = editModule;
break;
case "Browser":
PhotoViewModule viewModule = new PhotoViewModule(model.FileFullName)
{
ParentControl = this
};
App.CurrentWindow.brMain.Child = viewModule;
break;
case "Upload":
MessageBox.Show("Has joined the upload queue!");
break;
}
}
public async Task <IActionResult> Edit(Guid id, ProjectViewModel projectViewModel)
{
if (id != projectViewModel.Id)
{
return(NotFound());
}
// Update image
if (projectViewModel.ImageUpload != null)
{
// Delete Old image
UploadFile.Delete(projectViewModel.MainImage);
string fileName = null;
try
{
fileName = await UploadFile.Add(projectViewModel.ImageUpload);
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
if (fileName == null)
{
return(View(projectViewModel));
}
projectViewModel.MainImage = fileName;
}
var project = _mapper.Map <Project>(projectViewModel);
await _projectRep.Update(project);
await _projectRep.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
public ActionResult Delete(long attachId, int companyId)
{
var res = UploadFile.Delete(attachId, companyId);
return(res);
}
public ActionResult Delete(long attachId, int companyId)
{
return(UploadFile.Delete(attachId, companyId));
}
