Document Lock

 

 

. 'D:\Deploy\LockedOut\ReleaseLock.ps1'

 

$itemURL = "http://intranet.sdsa.com/gerp/Next%20ERP/Finance/30.%20L4%20Process%20Document/R.G-ERP_L1_L4_DATA_SEA%20v5_FICOWF.xlsx"
$site = New-Object Microsoft.SharePoint.SPSite($itemURL)
$web = $site.OpenWeb()
$item = $web.GetListItem($itemURL)
$file = $item.File
$userId = $file.LockedByUser.ID
$user = $web.AllUsers.GetByID($userId)
$impSite= New-Object Microsoft.SharePoint.SPSite($web.Url, $user.UserToken);
$impWeb = $impSite.OpenWeb();
$impItem = $impWeb.GetListItem($itemURL)
$impFile = $impItem.File
$impFile.ReleaseLock($impFile.LockId)

 

class MyEventHandler : SPItemEventReceiver {

public override void ItemAdded(SPItemEventProperties properties)
{
    base.ItemAdded(properties);

    
    ReleaseLock(properties);
}

 

protected void ReleaseLock(SPItemEventProperties properties)
{
    SPListItem item = properties.ListItem;

    try
    {
        SPFile file = item.File;
        if (!string.IsNullOrEmpty(file.LockId))
        {
            file.ReleaseLock(file.LockId);
        }
    }
    catch (Exception ex)
    {
    }
}

 

---------------------------------------------------------------

XLViewer.aspx

 

CSS Hidden (Excel 편집)

#m_excelWebRenderer_ewaCtl_btnEditInClient-Menu32{display:none;} #m_excelWebRenderer_ewaCtl_Jewel{display:none;}