public override void ItemUpdated(SPItemEventProperties properties) { base.ItemUpdated(properties); using (SPWeb web = properties.OpenWeb()) { SPList TestA = web.Lists["TestA"]; string employee = Convert.ToString(properties.ListItem["EmployeeNo"]); string department = Convert.ToString(properties.AfterProperties["Department"]); int ItemID = properties.ListItem.ID; SPList TestB = web.Lists["TestB"]; SPQuery query = new SPQuery(); query.Query = "<Where><Eq><FieldRef Name='Department' /><Value Type='Text'>" + department + "</Value></Eq></Where>"; SPListItemCollection items = TestB.GetItems(query); if (items.Count > 0) { foreach (SPListItem Item in items) { web.AllowUnsafeUpdates = true; SPFieldLookupValueCollection objLookupFieldValueCol = (SPFieldLookupValueCollection)Item["Employee"]; SPFieldLookupValue lookupValue = new SPFieldLookupValue(); lookupValue.LookupId = ItemID; objLookupFieldValueCol.Remove(lookupValue); Item["Employee"] = objLookupFieldValueCol; Item.Update(); web.AllowUnsafeUpdates = false; } } else { //SPListItem NewlistItem = TestB.AddItem(); SPFieldLookupValue lookupValue = new SPFieldLookupValue(); lookupValue.LookupId = ItemID; SPFieldLookupValueCollection objLookupFieldValueCol = new SPFieldLookupValueCollection(); objLookupFieldValueCol.Remove(lookupValue); //NewlistItem["Employee"] = objLookupFieldValueCol; //NewlistItem["Department"] = department; //NewlistItem.Update(); } web.AllowUnsafeUpdates = false; } }
objLookupFieldValueCol.Remove(objLookupFieldValueCol.Find(delegate(SPFieldLookupValue LV){return LV.LookupId == ItemID;}));
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)