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