//Set item sprite display in the frame
public void SetCollectedItem(ItemNum collectedItemType)
{
//if ItemNum = HealthKit
if (collectedItemType == ItemNum.HeathKit)
{
//set sprite alpha to 1
itemSprite.color = new Color(1, 1, 1, 1);
//replace the current sprite to the first on of the list
itemSprite.sprite = itemSpriteList[0];
}
if (collectedItemType == ItemNum.Bumper)
{
//set sprite alpha to 1
itemSprite.color = new Color(1, 1, 1, 1);
//replace the current sprite to the second on of the list
itemSprite.sprite = itemSpriteList[1];
}
if (collectedItemType == ItemNum.SpeedBoost)
{
//set sprite alpha to 1
itemSprite.color = new Color(1, 1, 1, 1);
//replace the current sprite to the third on of the list
itemSprite.sprite = itemSpriteList[2];
}
}
public TradeExamineViewPage Index(string searchString, string Year, int?page)
{
TradeExamineViewPage xx = new TradeExamineViewPage();
int pageNumber;
int pageSizeNum;
int ItemNum;
int pageNum;
var TradeExamine1 = (
from a in db.Trade
where a.TradeState == TradeState1.Online
select new TradeExamineViewPage1
{
TradeID = a.TradeID,
TradePeopleNum = (from b in db.Trade
join c in db.TradeExamine on b.TradeID equals c.TradeID
where b.TradeID == a.TradeID
select b.TradeID).Count(),
TradeTitle = a.TradeTitle,
TradeTime = a.TradeTime,
TradeAddress = a.TradeAddress,
TradeImg = a.TradeImg,
TradeState = a.TradeState,
TradeContact = a.TradeContact,
TradeInfo = a.TradeInfo,
}).ToList();
if (!String.IsNullOrEmpty(searchString))
{
TradeExamine1 = TradeExamine1.Where(s => s.TradeTitle.Contains(searchString)).ToList();
}
if (!String.IsNullOrEmpty(Year))
{
TradeExamine1 = TradeExamine1.Where(s => s.TradeTime.Value.Year.ToString() == Year).ToList();
}
var TradePeopleNum = TradeExamine1.GroupBy(a => a.TradeID).Count().ToString();
pageSizeNum = 5; //每页显示多少条
ItemNum = TradeExamine1.Count(); //数据总数
pageNum = (ItemNum % pageSizeNum) == 0 ? (ItemNum / pageSizeNum) : (ItemNum / pageSizeNum) + 1; //总页数
if (page == 4)
{
pageNumber = pageNum;
}
else
{
pageNumber = page ?? 1;
}
TradeExamine1 = TradeExamine1.OrderBy(x => x.TradeExamineID).Skip((pageNumber - 1) * pageSizeNum).Take(pageSizeNum).ToList();
xx.aa = TradeExamine1;
xx.pageNumber = pageNumber;
xx.pageNumx = pageNum;
xx.ItemNum = ItemNum.ToString();
xx.searchString = searchString;
xx.Year = Year;
return(xx);
}
public ForeExhibitionViewPage Index(int?page)
{
ForeExhibitionViewPage xx = new ForeExhibitionViewPage();
int pageNumber;
int pageSizeNum;
int ItemNum;
int pageNum;
var TradeInfo = db.Trade.Where(x => x.TradeState == TradeState1.Online).ToList();
pageSizeNum = Convert.ToInt32(page); //每页显示多少条
ItemNum = TradeInfo.Count(); //数据总数
pageNum = (ItemNum % pageSizeNum) == 0 ? (ItemNum / pageSizeNum) : (ItemNum / pageSizeNum) + 1; //总页数
if (page == 4)
{
pageNumber = pageNum;
}
else
{
pageNumber = page ?? 1;
}
TradeInfo = TradeInfo.OrderBy(x => x.TradeID).Take(pageSizeNum).ToList();
xx.aa = TradeInfo;
xx.pageNumber = pageNumber;
xx.pageNumx = pageNum;
xx.ItemNum = ItemNum.ToString();
return(xx);
}
public VisaManageViewPage Index(string searchString, VisaState1 State, int?page)
{
VisaManageViewPage xx = new VisaManageViewPage();
var VisaManage = db.Visa.ToList();
int pageNumber;
int pageSizeNum;
int ItemNum;
int pageNum;
if (State == VisaState1.All)
{
VisaManage = VisaManage.Where(s => s.VisaName.Contains(searchString)).ToList();
}
else
{
if (!String.IsNullOrEmpty(searchString))
{
VisaManage = VisaManage.Where(s => s.VisaName.Contains(searchString)).ToList();
}
VisaManage = VisaManage.Where(s => s.VisaState == State).ToList();
}
pageSizeNum = 5; //每页显示多少条
ItemNum = VisaManage.Count(); //数据总数
pageNum = (ItemNum % pageSizeNum) == 0 ? (ItemNum / pageSizeNum) : (ItemNum / pageSizeNum) + 1; //总页数
if (page == 4)
{
pageNumber = pageNum;
}
else
{
pageNumber = page ?? 1;
}
VisaManage = VisaManage.OrderBy(x => x.VisaID).Skip((pageNumber - 1) * pageSizeNum).Take(pageSizeNum).ToList();
xx.aa = VisaManage;
xx.pageNumber = pageNumber;
xx.pageNumx = pageNum;
xx.ItemNum = ItemNum.ToString();
xx.searchstring = searchString;
xx.State = State;
return(xx);
}
//Spawn an item base from ENUM class. The rate is given by ItemRateGenerator()
private void SpawnRandItem()
{
//Create an array to store Enum class's values
Array itemTypeList = Enum.GetValues(typeof(ItemNum));
//Select a value from that array and cast as an ItemNum, based on ItemRateGenerator()
currActivatedItemNum = (ItemNum)itemTypeList.GetValue(ItemRateGenerator(itemSpawnRateList, 1000));
//Create an empty GameObject and assign instansiated item to it depending on the switch
GameObject newSpawnedItem = null;
//Set up a switch to decide which item to instantiate
switch (currActivatedItemNum)
{
//creates a gameobject of (healthKit) with it's parent being "this", at the same time zero out the axis
case ItemNum.HeathKit:
newSpawnedItem = Instantiate(healthKit, gameObject.transform.position, Quaternion.identity);
HealthKitPickedUpTimes++;
break;
//creates a gameobject of (bumper) with it's parent being "this", at the same time zero out the axis
case ItemNum.Bumper:
newSpawnedItem = Instantiate(bumper, gameObject.transform.position, Quaternion.identity);
BumperPickedUpTimes++;
break;
//creates a gameobject of (speedBoost) with it's parent being "this", at the same time zero out the axis
case ItemNum.SpeedBoost:
newSpawnedItem = Instantiate(speedBoost, gameObject.transform.position, Quaternion.identity);
SpeedBoostPickedUpTimes++;
break;
default:
Debug.Log("Random Spawner Invalid ItemNum");
break;
}
//Set the axis of the newly spawned item to the parent's as well as the item object itself
newSpawnedItem.transform.SetParent(gameObject.transform);
//Set item is spawned
isSpawned = true;
//Set item is picked up
isPickedUp = false;
}
public EmbassyViewPage Index(string searchString, EmbassyState1 State, int?page)
{
EmbassyViewPage xx = new EmbassyViewPage();
var Embassy = db.Embassy.ToList();
int pageNumber;
int pageSizeNum;
int ItemNum;
int pageNum;
if (State == EmbassyState1.All)
{
Embassy = Embassy.Where(s => s.CompanyName.Contains(searchString)).ToList();
}
else
{
if (!String.IsNullOrEmpty(searchString))
{
Embassy = Embassy.Where(s => s.CompanyName.Contains(searchString)).ToList();
}
Embassy = Embassy.Where(s => s.EmbassyType == State).ToList();
}
pageSizeNum = 5; //每页显示多少条
ItemNum = Embassy.Count(); //数据总数
pageNum = (ItemNum % pageSizeNum) == 0 ? (ItemNum / pageSizeNum) : (ItemNum / pageSizeNum) + 1; //总页数
if (page == 4)
{
pageNumber = pageNum;
}
else
{
pageNumber = page ?? 1;
}
Embassy = Embassy.OrderBy(x => x.EmbassyID).Skip((pageNumber - 1) * pageSizeNum).Take(pageSizeNum).ToList();
xx.aa = Embassy;
xx.pageNumber = pageNumber;
xx.pageNumx = pageNum;
xx.ItemNum = ItemNum.ToString();
xx.searchstring = searchString;
xx.State = State;
return(xx);
}
public UserManagerViewPage Index(string searchString, UsersRole Role, int?page)
{
UserManagerViewPage xx = new UserManagerViewPage();
var Users = db.UsersInfo.Where(s => s.UserRole != UsersRole.SystemManager).ToList();
int pageNumber;
int pageSizeNum;
int ItemNum;
int pageNum;
if (Role == UsersRole.All)
{
Users = Users.Where(s => s.UserName.Contains(searchString)).ToList();
}
else
{
if (!String.IsNullOrEmpty(searchString))
{
Users = Users.Where(s => s.UserName.Contains(searchString)).ToList();
}
Users = Users.Where(s => s.UserRole == Role).ToList();
}
pageSizeNum = 5; //每页显示多少条
ItemNum = Users.Count(); //数据总数
pageNum = (ItemNum % pageSizeNum) == 0 ? (ItemNum / pageSizeNum) : (ItemNum / pageSizeNum) + 1; //总页数
if (page == 4)
{
pageNumber = pageNum;
}
else
{
pageNumber = page ?? 1;
}
Users = Users.OrderBy(x => x.UserID).Skip((pageNumber - 1) * pageSizeNum).Take(pageSizeNum).ToList();
xx.aa = Users;
xx.pageNumber = pageNumber;
xx.pageNumx = pageNum;
xx.ItemNum = ItemNum.ToString();
xx.searchstring = searchString;
xx.Role = Role;
return(xx);
}
//Set item sprite display in the frame
public void SetCollectedItem(ItemNum collectedItemType, int a_playerIndex) //player index 0,1
{
//set a null ref to put in which player to change sprite
Image itemSprite = null;
//check playerIndex to decide which UI need to change
if (a_playerIndex == 0)
{
itemSprite = itemP1Sprite;
}
else
{
itemSprite = itemP2Sprite;
}
//if ItemNum = HealthKit
if (collectedItemType == ItemNum.HeathKit)
{
//set sprite alpha to 1
itemSprite.color = new Color(1, 1, 1, 1);
//replace the current sprite to the first on of the list
itemSprite.sprite = itemSpriteList[0];
}
//if ItemNum = Bumper
if (collectedItemType == ItemNum.Bumper)
{
//set sprite alpha to 1
itemSprite.color = new Color(1, 1, 1, 1);
//replace the current sprite to the second on of the list
itemSprite.sprite = itemSpriteList[1];
}
//if ItemNum = SpeedBoost
if (collectedItemType == ItemNum.SpeedBoost)
{
//set sprite alpha to 1
itemSprite.color = new Color(1, 1, 1, 1);
//replace the current sprite to the third on of the list
itemSprite.sprite = itemSpriteList[2];
}
}
public TradeInfoViewPage Index(string searchString, string Date, string Place, int?page)
{
TradeInfoViewPage xx = new TradeInfoViewPage();
var TradeInfo = db.Trade.Where(a => a.TradeState == TradeState1.Online).ToList();
int pageNumber;
int pageSizeNum;
int ItemNum;
int pageNum;
if (!String.IsNullOrEmpty(searchString))
{
TradeInfo = TradeInfo.Where(s => s.TradeTitle.Contains(searchString)).ToList();
}
if (!String.IsNullOrEmpty(Date))
{
TradeInfo = TradeInfo.Where(s => s.TradeTime == Convert.ToDateTime(Date)).ToList();
}
if (!String.IsNullOrEmpty(Place))
{
TradeInfo = TradeInfo.Where(s => s.TradeAddress.Contains(Place)).ToList();
}
pageSizeNum = 5; //每页显示多少条
ItemNum = TradeInfo.Count(); //数据总数
pageNum = (ItemNum % pageSizeNum) == 0 ? (ItemNum / pageSizeNum) : (ItemNum / pageSizeNum) + 1; //总页数
if (page == 4)
{
pageNumber = pageNum;
}
else
{
pageNumber = page ?? 1;
}
TradeInfo = TradeInfo.OrderBy(x => x.TradeID).Skip((pageNumber - 1) * pageSizeNum).Take(pageSizeNum).ToList();
xx.aa = TradeInfo;
xx.pageNumber = pageNumber;
xx.pageNumx = pageNum;
xx.ItemNum = ItemNum.ToString();
xx.searchstring = searchString;
return(xx);
}
public ExamineViewPage Index(string searchString, string Year, int?page)
{
ExamineViewPage xx = new ExamineViewPage();
var Examine = db.Examine.ToList();
int pageNumber;
int pageSizeNum;
int ItemNum;
int pageNum;
if (!String.IsNullOrEmpty(searchString))
{
Examine = Examine.Where(s => s.CompanyName.Contains(searchString)).ToList();
}
if (!String.IsNullOrEmpty(Year))
{
Examine = Examine.Where(s => s.ExamineTime.Value.Year == Convert.ToInt32(Year)).ToList();
}
pageSizeNum = 5; //每页显示多少条
ItemNum = Examine.Count(); //数据总数
pageNum = (ItemNum % pageSizeNum) == 0 ? (ItemNum / pageSizeNum) : (ItemNum / pageSizeNum) + 1; //总页数
if (page == 4)
{
pageNumber = pageNum;
}
else
{
pageNumber = page ?? 1;
}
Examine = Examine.OrderBy(x => x.ExamineID).Skip((pageNumber - 1) * pageSizeNum).Take(pageSizeNum).ToList();
xx.aa = Examine;
xx.pageNumber = pageNumber;
xx.pageNumx = pageNum;
xx.ItemNum = ItemNum.ToString();
xx.searchstring = searchString;
xx.Year = Year;
return(xx);
}
