/// <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);
