public List <GGGroup> GetAllGroup() { List <GGGroup> list = new List <GGGroup>(); using (TransactionScope scope = this.transactionScopeFactory.NewTransactionScope()) { IOrmAccesser <GGGroup> accesser = scope.NewOrmAccesser <GGGroup>(); list = accesser.GetAll(); scope.Commit(); } return(list); }
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(); } }