private async Task <List <KucunViewModel> > GetKucunTable() { List <KucunViewModel> togetherKucun = new List <KucunViewModel>(); //首先获取实时库存并归类 var temp = from u in Db.KucunTable orderby u.updatetime where u.kucun != 0 select new KucunViewModel { id = u.id, dataServer = u.daqu, server = u.fuwuqi, oldGil = 0, nowGil = u.kucun, totalGil = u.kucun, updataTime = TimeCommon.DateStringFromNowShupai(u.updatetime) }; togetherKucun = await temp.ToListAsync(); //List<KucunViewModel> togetherKucun = await temp.Skip(0).Take(10).ToListAsync(); //然后再获取转移库存列表 var oldKucunTemp = from u in Db.OldHouse where u.Gil != 0 select new KucunViewModel { id = u.ID, dataServer = u.DataServer, server = u.Server, oldGil = u.Gil, nowGil = 0, totalGil = u.Gil, updataTime = TimeCommon.DateStringFromNow(u.CreateTime) }; //把得到的Temp转换成合并显示类型并加入List foreach (var oldGil in oldKucunTemp) { KucunViewModel oldKucun = isServerInList(oldGil.server, togetherKucun);//获取已经在实时库存中存在的服务器 //如果存在 if (oldKucun != null) { oldKucun.id = oldGil.id; oldKucun.oldGil += oldGil.oldGil; oldKucun.totalGil = oldKucun.nowGil + oldKucun.oldGil; } //如果不存在 else { togetherKucun.Add(oldGil); } } return(togetherKucun); }
private async Task <List <KucunViewModel> > GetKucunTableByServer(string server) { List <KucunViewModel> togetherKucun = new List <KucunViewModel>(); //首先获取实时库存并归类 var temp = from u in Db.KucunTable orderby u.updatetime where u.kucun != 0 select new KucunViewModel { id = u.id, dataServer = u.daqu, server = u.fuwuqi, oldGil = 0, nowGil = u.kucun, totalGil = u.kucun, updataTime = TimeCommon.DateStringFromNow(u.updatetime) }; //挑选服务器部分 switch (server) { case "usa": temp = temp.Where(u => u.dataServer == "Aether" || u.dataServer == "Primal" || u.dataServer == "Crystal"); break; case "japan": temp = temp.Where(u => u.dataServer == "Elemental" || u.dataServer == "Gaia" || u.dataServer == "Mana"); break; case "chaos": temp = temp.Where(u => u.dataServer == "Chaos" || u.dataServer == "Light"); break; case "oumei": temp = temp.Where(u => u.dataServer == "Aether" || u.dataServer == "Primal" || u.dataServer == "Chaos" || u.dataServer == "Crystal" || u.dataServer == "Light"); break; default: break; } togetherKucun = await temp.ToListAsync(); //List<KucunViewModel> togetherKucun = await temp.Skip(0).Take(10).ToListAsync(); //然后再获取转移库存列表 var oldKucunTemp = from u in Db.OldHouse where u.Gil != 0 select new KucunViewModel { id = u.ID, dataServer = u.DataServer, server = u.Server, oldGil = u.Gil, nowGil = 0, totalGil = u.Gil, updataTime = TimeCommon.DateStringFromNow(u.CreateTime) }; switch (server) { case "usa": oldKucunTemp = oldKucunTemp.Where(u => u.dataServer == "Aether" || u.dataServer == "Primal" || u.dataServer == "Crystal"); break; case "japan": oldKucunTemp = oldKucunTemp.Where(u => u.dataServer == "Elemental" || u.dataServer == "Gaia" || u.dataServer == "Mana"); break; case "chaos": oldKucunTemp = oldKucunTemp.Where(u => u.dataServer == "Chaos" || u.dataServer == "Light"); break; case "oumei": oldKucunTemp = oldKucunTemp.Where(u => u.dataServer == "Aether" || u.dataServer == "Primal" || u.dataServer == "Chaos" || u.dataServer == "Crystal" || u.dataServer == "Light"); break; default: break; } //把得到的Temp转换成合并显示类型并加入List foreach (var oldGil in oldKucunTemp) { KucunViewModel oldKucun = isServerInList(oldGil.server, togetherKucun);//获取已经在实时库存中存在的服务器 //如果存在 if (oldKucun != null) { oldKucun.id = oldGil.id; oldKucun.oldGil += oldGil.oldGil; oldKucun.totalGil = oldKucun.nowGil + oldKucun.oldGil; } //如果不存在 else { togetherKucun.Add(oldGil); } } return(togetherKucun); }