MOSS 2007 文档库事件处理

最新推荐文章于 2023-07-05 11:45:17 发布

weixin_30872867

最新推荐文章于 2023-07-05 11:45:17 发布

阅读量47

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/willpower/archive/2008/07/20/1247189.html

本文介绍了一个使用C#实现的SharePoint列表事件处理程序。该程序会在列表项被插入时，将特定字段的数据同步到SQL Server数据库中。涉及的技术包括SharePoint API、SQL Server连接及命令执行等。

using System;
using System.Text;
using Microsoft.SharePoint;
using System.Data.SqlClient;
namespace EventHandle
{
    public class listEventHandle : IListEventSink
{
        public void OnEvent(SPListEvent listEvent)
        {

            try
            {
                if (listEvent.Type == SPListEventType.Insert)
                {
                    SPWeb web = listEvent.Site.OpenWeb();
                    SPFile SharePointEventItem = web.GetFile(listEvent.UrlAfter);
                    SPListItem item = SharePointEventItem.Item;

                    string itemid = item.ID.ToString();
                    string name = item["姓名"].ToString();
                    string destAdd = item["目的"].ToString();
                    string appDate = item["申请日期"].ToString();
                    string memo = item["备注"].ToString();
                    string email = item["Email"].ToString();
                    string cfd = item["出发地"].ToString();
                    string mdd = item["目的地"].ToString();
                    SqlConnection conn = new SqlConnection("Data Source=moss;Initial Catalog=test;integrated security=SSPI");
                    conn.Open();
                    SqlCommand cmd = new SqlCommand("insert into t_cs(listitem_id,Name,destAdd,appDate,memo,email,cfd,mdd) values('" + itemid + "','" + name + "','" + destAdd + "','" + appDate + "','" + memo + "','" + email + "','" + cfd + "','" + mdd + "')", conn);
                    cmd.ExecuteNonQuery();
                    conn.Close();
                }
            }
            catch (Exception e)
            {
                System.IO.StreamWriter log = new System.IO.StreamWriter(@"d:\log.txt", true);
                log.Write("StackTrace:" + e.StackTrace);
                log.Write("Message:" + e.Message);
                log.Flush();
                log.Close();
            }
        }
}
}