コード例 #1
0
ファイル: RealDB.cs プロジェクト: yjboys-qhq/GGTalk
        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);
        }
コード例 #2
0
ファイル: TextStaticFun.cs プロジェクト: tw0r2/wms_rfid
        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();
            }
        }