/// <summary>
/// 编辑景点
/// </summary>
public void EditViewSpot(AddOrEditViewSpotDto input)
{
//using (TransactionScope tran = new TransactionScope())
//{
using (var db = new RTDbContext())
{
int wisdomGuideId = GetWisdomGuideId(db);
var model = db.WisdomGuideViewSpots.FirstOrDefault(p => p.Id == input.Id);
if (model == null)
{
throw new RTException("所选数据不存在");
}
model.ImgUrl = HttpPathCombine(_resourcePath, input.SmallImgUrl);
//model.ViewSpotDescribe = input.ViewSpotDescribe;
model.Position = input.Position;
model.Phone = input.Phone;
model.Longitude = input.Longitude;
model.Latitude = input.Latitude;
model.ViewSpotName = input.ViewSpotName;
model.WisdomGuideId = wisdomGuideId;
db.Entry(model).State = EntityState.Modified;
int ViewSpotId = model.Id;
_detail.AddOrEdit(new AddOrEditDetailInput
{
ProjectId = model.Id,
ImgUrl = HttpPathCombine(_resourcePath, input.BigImgUrl),
Paragraphs = input.Contents
}, db);
var list = db.WisdomGuideViewSpotVideos.Where(p => p.WisdomGuideViewSpotId == ViewSpotId).ToList();
if (list != null && list.Count() != 0)
{
for (int i = 0; i < list.Count; i++)
{
db.WisdomGuideViewSpotVideos.Remove(list[i]);
}
}
if (input.VoiceList != null && input.VoiceList.Count != 0)
{
input.VoiceList.ForEach(item =>
{
db.WisdomGuideViewSpotVideos.Add(new WisdomGuideViewSpotVideo
{
ImgUrl = HttpPathCombine(_resourcePath, item.ImgUrl),
VoiceName = item.VoiceName,
VoiceUrl = HttpPathCombine(_voicePath, item.VoiceUrl),
WisdomGuideViewSpotId = ViewSpotId
});
});
}
db.SaveChanges();
}
// tran.Complete();
//}
}
/// <summary>
/// 获取用于编辑景点的数据
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public AddOrEditViewSpotDto GetViewSpotForEdit(RTEntity <int> input)
{
if (input == null)
{
throw new RTException("输入参数不能为空");
}
var result = new AddOrEditViewSpotDto();
using (var db = new RTDbContext())
{
var viewSpot = db.WisdomGuideViewSpots.FirstOrDefault(p => p.Id == input.Parameter);
if (viewSpot == null)
{
throw new RTException("所选数据不存在");
}
result.Id = viewSpot.Id;
result.SmallImgUrl = viewSpot.ImgUrl;
//result.Content = viewSpot.Content;
//result.ImgUrl = viewSpot.ImgUrl;
//result.ViewSpotDescribe = viewSpot.ViewSpotDescribe;
result.Position = viewSpot.Position;
result.Phone = viewSpot.Phone;
result.Longitude = viewSpot.Longitude;
result.Latitude = viewSpot.Latitude;
result.ViewSpotName = viewSpot.ViewSpotName;
result.WisdomGuideId = viewSpot.WisdomGuideId;
var detail = _detail.GetDetail(new GetDetailInput
{
ProjectId = viewSpot.Id
}, db);
if (detail == null)
{
return(result);
}
result.BigImgUrl = detail.ImgUrl;
result.Contents = detail.Paragraphs;
var videoList = db.WisdomGuideViewSpotVideos.Where(p => p.WisdomGuideViewSpotId == viewSpot.Id).ToList();
if (videoList != null && videoList.Count != 0)
{
result.VoiceList = new List <ViewSpotVideoDto>();
videoList.ForEach(item =>
{
result.VoiceList.Add(new ViewSpotVideoDto
{
ImgUrl = item.ImgUrl,
VoiceName = item.VoiceName,
VoiceUrl = item.VoiceUrl,
WisdomGuideViewSpotId = item.WisdomGuideViewSpotId
});
});
}
}
return(result);
}
/// <summary>
/// 添加景点
/// </summary>
public void AddViewSpot(AddOrEditViewSpotDto input)
{
//using (TransactionScope tran = new TransactionScope())
//{
using (var db = new RTDbContext())
{
int wisdomGuideId = GetWisdomGuideId(db);
var model = new WisdomGuideViewSpot
{
//Content = input.Content,
ImgUrl = HttpPathCombine(_resourcePath, input.SmallImgUrl),
//ViewSpotDescribe = input.ViewSpotDescribe,
Position = input.Position,
Phone = input.Phone,
Longitude = input.Longitude,
Latitude = input.Latitude,
ViewSpotName = input.ViewSpotName,
WisdomGuideId = wisdomGuideId
};
db.WisdomGuideViewSpots.Add(model);
db.SaveChanges();
_detail.AddOrEdit(new AddOrEditDetailInput
{
ProjectId = model.Id,
ImgUrl = HttpPathCombine(_resourcePath, input.BigImgUrl),
Paragraphs = input.Contents
}, db);
int ViewSpotId = model.Id;
if (input.VoiceList != null && input.VoiceList.Count != 0)
{
input.VoiceList.ForEach(item =>
{
db.WisdomGuideViewSpotVideos.Add(new WisdomGuideViewSpotVideo
{
ImgUrl = HttpPathCombine(_resourcePath, item.ImgUrl),
VoiceName = item.VoiceName,
VoiceUrl = HttpPathCombine(_voicePath, item.VoiceUrl),
WisdomGuideViewSpotId = ViewSpotId
});
});
}
db.SaveChanges();
}
//tran.Complete();
//}
}
/// <summary>
/// 添加景点
/// </summary>
public GeneralResult AddViewSpot(AddOrEditViewSpotDto input)
{
var result = new GeneralResult();
try
{
bll.AddViewSpot(input);
result.State = 0;
result.Msg = "操作成功";
}
catch (RTException e)
{
result = RTExceptionHandle(e);
}
catch (Exception e1)
{
result = ExceptionHandle(e1);
}
return(result);
}
