【InfoPath应用场景：库存管理】在InfoPath Form Service利用WSS Web Service技术,通过VSTA代码把复杂表单写入SharePoint列表数据库的后继...

http://blog.lickies.cn/DocLib/[%20InfoPath应用场景：库存管理%20]%20在InfoPath%20Form%20Service利用WSS%20Web%20Service技术,通过VSTA代码把复杂表单写入SharePoint列表数据库%20(一）.aspx

后继处理删除表单表单操作:

首先创建ConsoleApplication1项目
代码如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
namespace Eallies.EventHandler.Register
{
public class Program
{
static void Main(string[] args)
{

SPSite site = new SPSite("http://fileserver/");
SPList list = site.OpenWeb("/Docs").Lists["修改建议文档"];
list.EventReceivers.Add(SPEventReceiverType.ItemDeleted, "Eallies.EventHandler.SP2007, Version=1.0.0.0, Culture=neutral, PublicKeyToken=24da4dca5bdd679d", "Eallies.EventHandler.SP2007.ListHandler");
list.EventReceivers.Add(SPEventReceiverType.ItemDeleting, "Eallies.EventHandler.SP2007, Version=1.0.0.0, Culture=neutral, PublicKeyToken=24da4dca5bdd679d", "Eallies.EventHandler.SP2007.ListHandler");
}
}
}
创建Eallies.EventHandler.SP2007项目
代码如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;

namespace Eallies.EventHandler.SP2007
{
public class ListHandler : SPItemEventReceiver
{

public static string szGlogal;



public override void ItemDeleting(SPItemEventProperties properties)
{
string NameField = properties.OpenWeb().Lists[properties.ListId].Fields.GetField("建议编号").InternalName;
string NameValue = properties.ListItem[NameField].ToString();
szGlogal = NameValue;
}


public override void ItemDeleted(SPItemEventProperties properties)
{

SPSite site = new SPSite("http://fileserver"/);
SPList list = site.OpenWeb("/Docs").Lists["修改建议数据"];
string QueryText = "<Where><Eq><FieldRef Name='" + list.Fields["建议编号"].InternalName + "'/><Value Type='Text'>"
+ szGlogal + "</Value></Eq></Where>";
SPQuery myQ = new SPQuery();
myQ.Query = QueryText;

SPListItemCollection items = list.GetItems(myQ);

int total = items.Count;

for (int i = total - 1; i >= 0; i--)

items.Delete(i);


}

}


}
ok, 特别指出最后循环一定要从大到小,时分关键,就是因为这个问题让我折腾了好久,慢慢理解其中理由.慢慢调试应该没问题.

转载于:https://www.cnblogs.com/dtg123/archive/2009/03/05/1403879.html