public ResponseContext <bool> AddOrUpdateImage(ImgGalleryEntity request)
{
bool success = true;
if (request.ImgId <= 0)
{
request.CreateTime = DateTime.Now;
request.ModifyTime = DateTime.Now;
success = sysDal.IndertImageGallery(request);
}
else
{
request.ModifyTime = DateTime.Now;
success = sysDal.UpdateImageGallery(request);
}
if (success)
{
return(new ResponseContext <bool>(success));
}
else
{
return(new ResponseContext <bool>(false, ErrCodeEnum.InnerError, success));
}
}
public bool UpdateShortUrl(ImgGalleryEntity req)
{
using (var Db = GetDbConnection())
{
var sql = @"UPDATE dbo.gallery_ImgGallery
SET ShortUrl = @ShortUrl
, ModifyUserId = @ModifyUserId
, ModifyTime = @ModifyTime
WHERE ImgId = @ImgId";
return(Db.Execute(sql, req) > 0);
}
}
public bool UpdateImageGallery(ImgGalleryEntity req)
{
using (var Db = GetDbConnection())
{
var sql = @"UPDATE dbo.gallery_ImgGallery
SET ImgName = @ImgName
, Remark = @Remark
, ModifyUserId = @ModifyUserId
, ModifyTime = @ModifyTime
WHERE ImgId = @ImgId";
return(Db.Execute(sql, req) > 0);
}
}
public ResponseContext <bool> UpdateShortUrl(ImgGalleryEntity request)
{
DeleteLocalImage(request.ImgId);
request.ModifyTime = DateTime.Now;
bool success = sysDal.UpdateShortUrl(request);
if (success)
{
return(new ResponseContext <bool>(success));
}
else
{
return(new ResponseContext <bool>(false, ErrCodeEnum.InnerError, success));
}
}
public bool IndertImageGallery(ImgGalleryEntity req)
{
using (var Db = GetDbConnection())
{
var sql = @"INSERT INTO dbo.gallery_ImgGallery
(ImgName
,ShortUrl
,Remark
,CreateUserId
,ModifyUserId
,CreateTime
,ModifyTime)
VALUES
(@ImgName
,@ShortUrl
,@Remark
,@CreateUserId
,@ModifyUserId
,@CreateTime
,@ModifyTime)";
return(Db.Execute(sql, req) > 0);
}
}