public static void test123() { using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false)) { IRelationAccesser r = scope.NewRelationAccesser(); DataTable tb = r.DoQuery("select * from storages order by Address").Tables[0]; // ================================= System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); ELDB2.HashSelectHandle h = new ELDB2.HashSelectHandle(tb); int j = 0; for (int k = 0; k < 1000; k++) { foreach (DataRow row in tb.Rows) { Hashtable t = h.Select <string>("Address", row.Field <string>("Address").Trim()); for (int i = 0; i < t.Count; i++) { j++; } } } System.Console.WriteLine(j.ToString()); System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); // ================================= scope.Commit(); } }
public void Run0(bool isHash) { IList <ELDB2.Storages> list = null; IList <ELDB2.Storages> list1 = null; using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false)) { System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); ELDB2.HashSelectHandle hashTable = null; Hashtable hashTable1 = null; IOrmAccesser <ELDB2.Storages> storages = ELDB2.DBFactory.NewOrmAccesser <ELDB2.Storages>(scope); Filter filter = new Filter(ELDB2.Storages._Sign, 0, ComparisonOperators.Equal); list1 = storages.GetMuch(filter); if (isHash) { IRelationAccesser r = scope.NewRelationAccesser(); DataTable tb = r.DoQuery("select * from storages order by Address").Tables[0]; hashTable = new ELDB2.HashSelectHandle(tb); } else { list = storages.GetAll(); } for (int mm = 0; mm < 1; mm++) { if (list1 != null) { foreach (ELDB2.Storages storage1 in list1) { if (isHash) { //hashTable1 = hashTable.Select(ELDB2.Storages._Address, storage1.Address); list = hashTable.Select <ELDB2.Storages, string>(ELDB2.Storages._Address, storage1.Address); IEnumerable <ELDB2.Storages> storages1 = from storage in list where storage.Address == storage1.Address orderby storage.Address select storage; foreach (ELDB2.Storages item in storages1) { item.Act = "10"; hashTable.Update <ELDB2.Storages, string>(item); } } else { IEnumerable <String> Address = from storage in list where storage.Address == storage1.Address orderby storage.Address select storage.Address; foreach (string item in Address) { System.Console.WriteLine(item); } } } } } System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); // ========================= scope.Commit(); } }
public void Run(bool isHash) { IList <ELDB2.Storages> list = null; IList <ELDB2.Storages> list1 = null; using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false)) { System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); ELDB2.HashSelectHandle hashTable = null; if (isHash) { IRelationAccesser r = scope.NewRelationAccesser(); DataTable tb = r.DoQuery("select * from storages order by Address").Tables[0]; hashTable = new ELDB2.HashSelectHandle(tb); } for (int mm = 0; mm < 5; mm++) { IOrmAccesser <ELDB2.Storages> storages = ELDB2.DBFactory.NewOrmAccesser <ELDB2.Storages>(scope); Filter filter = new Filter(ELDB2.Storages._Sign, 0, ComparisonOperators.Equal); list1 = storages.GetMuch(filter); if (list1 != null) { foreach (ELDB2.Storages storage1 in list1) { if (isHash) { list = hashTable.Select <ELDB2.Storages, string>(ELDB2.Storages._Address, storage1.Address); } else { Filter filter1 = new Filter(ELDB2.Storages._Address, storage1.Address, ComparisonOperators.Equal); list = storages.GetMuch(filter1); } string[] data = new string[5]; for (int i = 0; i < 5; i++) { data[i] = ""; } foreach (ELDB2.Storages storage in list) { string s1, s2, s3, s4; switch ("mode1") { case "mode1": s1 = storage.StorageName.Trim() + " " + storage.Act.Trim() + " " + storage.Contents.Trim() + storage.ProductName.Trim() + "".PadRight(56, " "[0]); s1 = StrHandle.GetStringWith(s1, 56); if (storage.Row == "3") { data[0] = s1; } if (storage.Row == "2") { data[1] = s1; } if (storage.Row == "1") { data[2] = s1; } break; case "mode2": s1 = "储位:" + storage.StorageName.Trim(); s1 = StrHandle.GetStringWith(s1, 24); s2 = "操作:" + storage.Act.Trim(); s2 = StrHandle.GetStringWith(s2, 24); s3 = "品牌:" + storage.ProductName.Trim(); s3 = StrHandle.GetStringWith(s3, 24); s4 = "数量:" + storage.Contents.Trim(); s4 = StrHandle.GetStringWith(s4, 20); data[0] = s1; data[0] = data[0] + s2; data[0] = data[0] + s3; data[0] = data[0] + s4; break; default: break; } storage.Sign = 0; //storages.Update(storage); IRelationAccesser ra = scope.NewRelationAccesser(); //ra.DoCommand("Update [Sy_ShowInfo] set [HardwareReadState] = 1 where ReadState =1 and [StorageID] = '" + storage.StorageID + "'"); } //this.elOpertor.SendData(int.Parse(storage1.Address.Substring(storage1.Address.Length - 2, 2)), data); } } } System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); // ========================= scope.Commit(); } }
public static void testhashclass() { ELDB2.HashSelectHandle hs = new ELDB2.HashSelectHandle(); Hashtable ht = hs.Select("port", "12"); }
public static void test123() { using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false)) { IRelationAccesser r = scope.NewRelationAccesser(); DataTable tb = r.DoQuery("select * from storages order by Address").Tables[0]; // ================================= System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); ELDB2.HashSelectHandle h = new ELDB2.HashSelectHandle(tb); int j = 0; for (int k = 0; k < 1000; k++) { foreach (DataRow row in tb.Rows) { Hashtable t = h.Select<string>("Address", row.Field<string>("Address").Trim()); for (int i = 0; i < t.Count; i++) { j++; } } } System.Console.WriteLine(j.ToString()); System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); // ================================= scope.Commit(); } }
public void Run0(bool isHash) { IList<ELDB2.Storages> list = null; IList<ELDB2.Storages> list1 = null; using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false)) { System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); ELDB2.HashSelectHandle hashTable = null; Hashtable hashTable1 = null; IOrmAccesser<ELDB2.Storages> storages = ELDB2.DBFactory.NewOrmAccesser<ELDB2.Storages>(scope); Filter filter = new Filter(ELDB2.Storages._Sign, 0, ComparisonOperators.Equal); list1 = storages.GetMuch(filter); if (isHash) { IRelationAccesser r = scope.NewRelationAccesser(); DataTable tb = r.DoQuery("select * from storages order by Address").Tables[0]; hashTable = new ELDB2.HashSelectHandle(tb); } else { list = storages.GetAll(); } for (int mm = 0; mm < 1; mm++) { if (list1 != null) { foreach (ELDB2.Storages storage1 in list1) { if (isHash) { //hashTable1 = hashTable.Select(ELDB2.Storages._Address, storage1.Address); list = hashTable.Select<ELDB2.Storages,string>(ELDB2.Storages._Address, storage1.Address); IEnumerable<ELDB2.Storages> storages1 = from storage in list where storage.Address == storage1.Address orderby storage.Address select storage; foreach (ELDB2.Storages item in storages1) { item.Act = "10"; hashTable.Update<ELDB2.Storages, string>(item); } } else { IEnumerable<String> Address = from storage in list where storage.Address == storage1.Address orderby storage.Address select storage.Address; foreach (string item in Address) { System.Console.WriteLine(item); } } } } } System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); // ========================= scope.Commit(); } }
public void Run(bool isHash) { IList<ELDB2.Storages> list = null; IList<ELDB2.Storages> list1 = null; using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false)) { System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); ELDB2.HashSelectHandle hashTable = null; if (isHash) { IRelationAccesser r = scope.NewRelationAccesser(); DataTable tb = r.DoQuery("select * from storages order by Address").Tables[0]; hashTable = new ELDB2.HashSelectHandle(tb); } for (int mm = 0; mm < 5; mm++) { IOrmAccesser<ELDB2.Storages> storages = ELDB2.DBFactory.NewOrmAccesser<ELDB2.Storages>(scope); Filter filter = new Filter(ELDB2.Storages._Sign, 0, ComparisonOperators.Equal); list1 = storages.GetMuch(filter); if (list1 != null) { foreach (ELDB2.Storages storage1 in list1) { if (isHash) { list = hashTable.Select<ELDB2.Storages, string>(ELDB2.Storages._Address, storage1.Address); } else { Filter filter1 = new Filter(ELDB2.Storages._Address, storage1.Address, ComparisonOperators.Equal); list = storages.GetMuch(filter1); } string[] data = new string[5]; for (int i = 0; i < 5; i++) data[i] = ""; foreach (ELDB2.Storages storage in list) { string s1, s2, s3, s4; switch ("mode1") { case "mode1": s1 = storage.StorageName.Trim() + " " + storage.Act.Trim() + " " + storage.Contents.Trim() + storage.ProductName.Trim() + "".PadRight(56, " "[0]); s1 = StrHandle.GetStringWith(s1, 56); if (storage.Row == "3") data[0] = s1; if (storage.Row == "2") data[1] = s1; if (storage.Row == "1") data[2] = s1; break; case "mode2": s1 = "储位:" + storage.StorageName.Trim(); s1 = StrHandle.GetStringWith(s1, 24); s2 = "操作:" + storage.Act.Trim(); s2 = StrHandle.GetStringWith(s2, 24); s3 = "品牌:" + storage.ProductName.Trim(); s3 = StrHandle.GetStringWith(s3, 24); s4 = "数量:" + storage.Contents.Trim(); s4 = StrHandle.GetStringWith(s4, 20); data[0] = s1; data[0] = data[0] + s2; data[0] = data[0] + s3; data[0] = data[0] + s4; break; default: break; } storage.Sign = 0; //storages.Update(storage); IRelationAccesser ra = scope.NewRelationAccesser(); //ra.DoCommand("Update [Sy_ShowInfo] set [HardwareReadState] = 1 where ReadState =1 and [StorageID] = '" + storage.StorageID + "'"); } //this.elOpertor.SendData(int.Parse(storage1.Address.Substring(storage1.Address.Length - 2, 2)), data); } } } System.Console.WriteLine(System.DateTime.Now.Second + ":" + System.DateTime.Now.Millisecond); // ========================= scope.Commit(); } }