コード例 #1
0
ファイル: RealDB.cs プロジェクト: yjboys-qhq/GGTalk
        public GGGroup GetGroup(string groupID)
        {
            GGGroup group = null;

            using (TransactionScope scope = this.transactionScopeFactory.NewTransactionScope())
            {
                IOrmAccesser <GGGroup> accesser = scope.NewOrmAccesser <GGGroup>();
                group = accesser.GetOne(groupID);
                scope.Commit();
            }
            return(group);
        }
コード例 #2
0
ファイル: RealDB.cs プロジェクト: yjboys-qhq/GGTalk
        public GGUser GetUser(string userID)
        {
            GGUser user = null;

            using (TransactionScope scope = this.transactionScopeFactory.NewTransactionScope())
            {
                IOrmAccesser <GGUser> accesser = scope.NewOrmAccesser <GGUser>();
                user = accesser.GetOne(userID);
                scope.Commit();
            }
            return(user);
        }
コード例 #3
0
ファイル: TextStaticFun.cs プロジェクト: tw0r2/wms_rfid
        public void Run1()
        {
            IList <ELDB2.Storages> list = null;

            using (TransactionScope scope = ELDB2.DBFactory.NewTransactionScope(false))
            {
                IOrmAccesser <ELDB2.Storages> storages = ELDB2.DBFactory.NewOrmAccesser <ELDB2.Storages>(scope);
                Filter         filter   = new Filter(ELDB2.Storages._Sign, 1, ComparisonOperators.Equal);
                ELDB2.Storages storage1 = storages.GetOne(filter);
                if (storage1 != null)
                {
                    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 = 2;
                        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);
                }
                scope.Commit();
            }
        }