/// <summary> /// 初始化产品分类表 TB_ItemCat /// </summary> public void InitializationItemCat() { List<ItemCat> itemcatlist = GetItemCats(); using (CatalogDataContext dct = new CatalogDataContext()) { var allItemCat = dct.TB_ItemCats; List<ItemCat> itemcatinsert = new List<ItemCat>(); //先判断数据库里是否存在,不存在的数据才需要插入 if (allItemCat != null && allItemCat.Count() > 0) { foreach (var itemcat in itemcatlist) { if (allItemCat.Where(i => i.Cid == itemcat.Cid && i.Name == itemcat.Name).FirstOrDefault() == null) { itemcatinsert.Add(itemcat); } } } else { itemcatinsert.AddRange(itemcatlist); } //遍历获取到的淘宝分类数据插入TB_ItemCat foreach (var item in itemcatinsert) { TB_ItemCat obj = new TB_ItemCat(); obj.ID = Guid.NewGuid(); obj.Cid = item.Cid; obj.Name = item.Name; obj.IsParent = item.IsParent; if (string.IsNullOrEmpty(item.ModifiedTime) == false) { obj.ModifiedTime = DateTime.Parse(item.ModifiedTime); } obj.ModifiedType = item.ModifiedType; obj.ParentCid = item.ParentCid; obj.SortOrder = item.SortOrder; obj.Status = item.Status; dct.TB_ItemCats.InsertOnSubmit(obj); } dct.SubmitChanges(); } }
partial void UpdateTB_ItemCat(TB_ItemCat instance);
partial void DeleteTB_ItemCat(TB_ItemCat instance);
partial void InsertTB_ItemCat(TB_ItemCat instance);