/// <summary> /// 创建新的 Triplets 对象。 /// </summary> /// <param name="id">Id 属性的初始值。</param> /// <param name="timeStamp">TimeStamp 属性的初始值。</param> /// <param name="subject">Subject 属性的初始值。</param> /// <param name="verb">Verb 属性的初始值。</param> /// <param name="object">Object 属性的初始值。</param> public static Triplets CreateTriplets(global::System.Int32 id, global::System.DateTime timeStamp, global::System.String subject, global::System.String verb, global::System.String @object) { Triplets triplets = new Triplets(); triplets.Id = id; triplets.TimeStamp = timeStamp; triplets.Subject = subject; triplets.Verb = verb; triplets.Object = @object; return triplets; }
/// <summary> /// classify the activity update the dictionary and write into the database again /// </summary> public void classify() { int counter = 0; foreach (DataRow row in ds[0].Tables[0].Rows) { counter++; Console.Write(counter + " "); for (int i = 0; i < 3; i++) { Console.Write(row[i].ToString() + " "); } Console.WriteLine(); Duration du = new Duration() { TimeStamp = Convert.ToDateTime(row[0].ToString()), Activity_id = row[1].ToString(), Activity_duration = row[2].ToString(), }; if (Activity_Dic.ContainsKey(du.Activity_id)) { Activity_Dic[du.Activity_id]++; } else { Activity_Dic.Add(du.Activity_id, 1); } using (Week8Container w8c = new Week8Container()) { w8c.DurationSet.AddObject(du); w8c.SaveChanges(); } } Console.Write("☆☆☆☆☆☆☆First Table:DurationSet Import into database done☆☆☆☆☆☆☆"); foreach (DataRow row in ds[1].Tables[0].Rows) { Embedded em = new Embedded() { TimeStamp = Convert.ToDateTime(row[0].ToString()), Item1 = row[1].ToString(), Item2 = row[2].ToString() }; using (Week8Container w8c = new Week8Container()) { w8c.EmbeddedSet.AddObject(em); w8c.SaveChanges(); } } Console.Write("☆☆☆☆☆☆☆Second Table:EmbeddedSet Import into database done☆☆☆☆☆☆☆"); foreach (DataRow row in ds[2].Tables[0].Rows)//////////////// { Triplets tr = new Triplets() { TimeStamp = Convert.ToDateTime(row[0].ToString()), Subject = row[1].ToString(), Verb = row[2].ToString(), Object=row[3].ToString() }; using (Week8Container w8c = new Week8Container()) { w8c.TripletsSet.AddObject(tr); w8c.SaveChanges(); } } Console.Write("☆☆☆☆☆☆☆Third Table:TripletsSet Import into database done☆☆☆☆☆☆☆"); using (Week8Container w8c = new Week8Container()) { totalEventNumber = w8c.DurationSet.Count(); } }
/// <summary> /// 用于向 TripletsSet EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddToTripletsSet(Triplets triplets) { base.AddObject("TripletsSet", triplets); }