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>();
}
