예제 #1
0
        public static void SyncCategory(List <CategoryData> list)
        {
            try
            {
                //string json = Newtonsoft.Json.JsonConvert.SerializeObject(list);

                /*
                 * Unable to complete operation. The supplied SqlConnection does not specify an initial catalog or AttachDBFileName.
                 */

                DBReporistory <CategoryData> md    = new DBReporistory <CategoryData>(new ConfigurationItems().SqliteDbConnString);
                List <CategoryData>          dstas = md.DoQuery <CategoryData>().ToList();
                //一次操作数据量过大需要分批次
                List <CategoryData> group = new List <CategoryData>();
                for (int i = 0; i < list.Count; i++)
                {
                    group.Add(list[i]);
                    if (i % 2 == 0)
                    {
                        md.AddList(group.ToArray());
                        group.Clear();
                    }
                }
            }
            catch (Exception ex)
            {
            }
        }
예제 #2
0
        public void SaveQQ(List <FindQQDataTable> data)
        {
            try
            {
                //由于sqlite不支持guid数据存储:直接存储会变成乱码

                DBReporistory <TecentQQData> main = new DBReporistory <TecentQQData>(ConnString);
                DateTime            now           = DateTime.Now;
                List <TecentQQData> tcs           = new List <TecentQQData>();
                foreach (FindQQDataTable item in data)
                {
                    NoIDQQData   noKey = item.ConvertMapModel <FindQQDataTable, NoIDQQData>();
                    TecentQQData tc    = noKey.ConvertMapModel <NoIDQQData, TecentQQData>();
                    tc.ID         = GenerateId();
                    tc.CreateTime = now;
                    if (string.IsNullOrEmpty(tc.Url))//没有采集到该账户的头像数据
                    {
                        tc.ImgType = -1;
                    }
                    tc.DayInt = int.Parse(now.ToString("yyyyMMdd"));
                    tcs.Add(tc);
                }
                main.AddList(tcs.ToArray());
            }
            catch (Exception ex)
            {
                /*  原因:sqlite不支持实体列数据类型为Guid的情形
                 * One or more validation errors were detected during model generation:
                 *
                 * Infrastructure.EFSQLite.TecentQQData: : EntityType 'TecentQQData' has no key defined. Define the key for this EntityType.
                 * Entity: EntityType: EntitySet 'Entity' is based on type 'TecentQQData' that has no keys defined.
                 *
                 */
            }
        }
예제 #3
0
 public static void SyncCategory(List <CategoryData> list)
 {
     try
     {
         DBReporistory <CategoryData> md    = new DBReporistory <CategoryData>(new ConfigurationItems().SqliteDbConnString);
         List <CategoryData>          dstas = md.DoQuery <CategoryData>().ToList();
         //一次操作数据量过大需要分批次
         List <CategoryData> group = new List <CategoryData>();
         for (int i = 0; i < list.Count; i++)
         {
             group.Add(list[i]);
             if (i % 2 == 0)
             {
                 md.AddList(group.ToArray());
                 group.Clear();
             }
         }
     }
     catch (Exception ex)
     {
     }
 }