public DataBaseLoadController(AuctionContext auctionContext) { _auctionContext = auctionContext; _realmRepository = new RealmRepository(_auctionContext); _auctionRepository = new AuctionRepository(_auctionContext); _itemRepository = new ItemRepository(auctionContext); }
public StartTestViewModel(SQLiteRepository repository, Realm realm) { _realm = realm; _realmRepository = new RealmRepository(realm); _sqliteRepository = repository; _realmRepository.Clear(); }
public int GetCompanyIdByRealm(string name) { if (name.IsNullOrEmpty()) { return(-2); } var obj = RealmRepository.Find(o => o.Name == name && o.State == 1); if (obj == null) { return(0); } return(obj.CID); }
public CompanyAuthorize GetOne(object id) { var obj = CompanyAuthorRepository.Get(id); if (obj != null) { var realm = RealmRepository.Find(o => o.CID == obj.CID); if (realm != null) { obj.RealmName = realm.Name; obj.RealmState = realm.State == 1; obj.RealmUrl = realm.Url; } } return(obj); }
public IEnumerable <dynamic> GetPageList(System.Collections.Specialized.NameValueCollection nvl, out int recordCount) { //状态 var State = (nvl["State"] ?? "").Trim(); //类别 var Category = (nvl["Category"] ?? "").Trim(); //关键字类型 var keywordType = (nvl["keywordType"] ?? "").Trim(); //关键字 var keyword = (nvl["keyword"] ?? "").Trim(); //商户域名信息 var QRealm = RealmRepository.GetQuery(o => o.CID != -1); //商户信息 var QTraders = TradersRepository.GetQuery(); //一级域名 var QSysData = SysDataDictionaryRepository.GetQuery(o => o.DicPSN == 600 && o.Status); if (State != "-2") { short Sta = Convert.ToInt16(State); QRealm = QRealm.Where(o => o.State == Sta); } if (Category != "-1") { short Catego = Convert.ToInt16(Category); QRealm = QRealm.Where(o => o.Category == Catego); } if (!keywordType.IsNullOrEmpty() && !keyword.IsNullOrEmpty()) { if (keywordType == "1") { if (!Tool.IsNumber(keyword) || keyword.Length > 7) { keyword = "0"; } int key = Convert.ToInt32(keyword); QRealm = QRealm.Where(o => o.CID == key); } } var q = from r in QRealm join t in QTraders on r.CID equals t.CID into tt from ttt in tt.DefaultIfEmpty() join s in QSysData on r.Domain1 equals s.DicSN into ss from sss in ss.DefaultIfEmpty() select new { r.Id, r.Category, r.CID, TradersFullTitle = ttt == null ? "" : ttt.FullTitle, Domain = r.Name + "." + sss.Title, r.Remark, r.CreateDT, r.State }; if (keywordType == "3" && !keywordType.IsNullOrEmpty() && !keyword.IsNullOrEmpty()) { q = q.Where(o => o.Domain.Contains(keyword)); } if (keywordType == "2" && !keywordType.IsNullOrEmpty() && !keyword.IsNullOrEmpty()) { q = q.Where(o => o.TradersFullTitle.Contains(keyword)); } recordCount = q.Count(); return(q.ToPageList()); }
public ReclamacoesViewModel() { _realmRepository = new RealmRepository <Reclamacao>(); _reclamacaoRepository = new ReclamacaoRepository(); }
public LoginHelper() { _realmRepository = new RealmRepository <TLogin>(); }