sharepoint 文档点击数

来源:互联网 发布:美国网络小说 知乎 编辑:程序博客网 时间:2024/03/28 22:40

最近一直在研究sharepoint中的文档点击数,之前在网上找了大部分都是这个方法http://www.cnblogs.com/pengyuan512/archive/2008/01/07/1028522.html

我不知道这个方法在07中是否能用,但是在10里面调试死活都不好使,而且还没有反应,无奈听别人说网站集的审计报告能够实现于是找到

SPSite siteCollection = SPContext.Current.Site;
SPAuditQuery wssQuery
=new SPAuditQuery(siteCollection);
SPAuditEntryCollection auditCol;
auditCol
= siteCollection.Audit.GetEntries(wssQuery);
// enumerate through audit log and read entries
foreach (SPAuditEntry entryin auditCol) {
// inspect entry
}

这个方法,发现这个方法能够取出文档名称,但是不能获取文档的点击数,被逼无奈选择了读取数据库

但是这个方法也有个弊病,那就是审核报告是timer事件,定期会清空,这个要注意

下面是我的方法

首先找到数据库WSS_Content里面的AuditData

using (SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=sa;database=WSS_Content"))
            {
                //数据库连接语句
                string sql = @"SELECT DocLocation,count(itemid) as countnum from AuditData where
                            Event = 3 and itemtype = 1 group by DocLocation order by countnum desc ";
                conn.Open();
                //创建连接
                SqlCommand com = new SqlCommand(sql, conn);
                SqlDataAdapter dt = new SqlDataAdapter(com);
                DataSet ds = new DataSet();
                dt.Fill(ds);
                DataTable dTable = ds.Tables[0];
                //遍历
                foreach (DataRow dr in dTable.Rows)
                {
                    //获取数据库列名
                    string DocLocation = dr["DocLocation"].ToString();
                    string countnum = dr["countnum"].ToString();
                    //获取文件的后缀名
                    string docName = DocLocation.Substring(DocLocation.LastIndexOf(".")+1);
                    //获取文件所在的列表、库的地址
                    string docWeb = DocLocation.Substring(0, DocLocation.LastIndexOf("/"));
                    //获取文件名称
                    string fileName = DocLocation.Substring(DocLocation.LastIndexOf("/") + 1);
                    //拼接完整地址
                    string webStrs = "http://lsw/" + docWeb;
                    //去掉页面类型
                    if(docName!="aspx"){
                       //判断是否是主站下的如果有两个“/”代表是子网站
                       int count = DocLocation.Split('/').Length;
                       if (count > 2)
                       {
                           using (SPWeb spWeb = new SPSite("http://lsw/" + docWeb).OpenWeb())
                           {
                               //如果不存在网站地址,或者列表不存在跳出
                               try
                               {
                                   if (spWeb.GetList(webStrs)!= null)
                                   {
                                       //打开items
                                       SPListItemCollection splistitem = spWeb.GetList(webStrs).Items;
                                       //遍历itmes
                                       foreach(SPItem spitem in splistitem){
                                           if (spitem["名称"].ToString() == fileName)
                                           {
                                               spitem["HitCount"] = countnum;
                                               spitem.Update();
                                             }
                                       }
                                   }
                               }
                               catch (Exception)
                               {
                               } 
                           }
                       }
                       else {
                           //获取文件所在的列表、库的地址;这个是获取主网站下的文档
                           using (SPWeb spWebs = new SPSite("http://lsw/").OpenWeb())
                           {
                               try
                               {
                                   if (spWebs.GetList(webStrs) != null)
                                   {
                                       SPListItemCollection splistitem = spWebs.GetList(webStrs).Items;
                                       foreach (SPItem spitem in splistitem)
                                       {
                                           if (spitem["名称"].ToString() == fileName)
                                           {
                                               spitem["HitCount"] = countnum;
                                               spitem.Update();
                                           }
                                       }
                                   }
                               }
                               catch (Exception)
                               {
                               }
                           }
                       }
                    }
                }
            }

 

大家可以参考一下啊,如果有些的不对的地方请大家多提宝贵意见,以便后面的人少走弯路。

原创粉丝点击