public static List <StockDb> GetAllDbS(EnShowType en)
{
MysqlHelper sql = new MysqlHelper(dbIp, mysqlPort, mysqlUser, mysqlPassword, mysqlDbName);
//DataTable dt = null;
List <StockDb> stockS = new List <StockDb>();
if (en == EnShowType.stock)
{
DataTable dt = sql.SelectAllTable(holdStocks);
stockS = GetStockCCS(dt);
}
else if (en == EnShowType.etf)
{
DataTable dt = sql.SelectAllTable(holdETFs);
stockS = GetStockCCS(dt);
}
else
{
DataTable dtStock = sql.SelectAllTable(holdStocks);
stockS = GetStockCCS(dtStock);
DataTable dtETF = sql.SelectAllTable(holdETFs);
List <StockDb> ETFs = GetStockCCS(dtETF);
stockS.AddRange(ETFs);
}
sql.Close();
return(stockS);
}
public static float GetSelledIncrease(EnShowType en)
{
MysqlHelper sql = new MysqlHelper(dbIp, mysqlPort, mysqlUser, mysqlPassword, mysqlDbName);
float res = 0;
if (en == EnShowType.stock)
{
res = GetSelledStockYK();
}
else if (en == EnShowType.etf)
{
res = GetSelledEtfYK();
}
else if (en == EnShowType.All)
{
res = GetSelledStockYK();
res += GetSelledEtfYK();
}
return(res);
}
public void Reset(EnShowType type = EnShowType.enAllHide)
{
WindowRoot.transform.localPosition = Vector3.zero;
WindowRoot.transform.localScale = Vector3.one;
switch (type)
{
case EnShowType.enAllHide:
{
m_spriteSucc.gameObject.SetActive(false);
m_spriteFail.gameObject.SetActive(false);
}
break;
case EnShowType.enShowSucc:
{
m_spriteSucc.gameObject.SetActive(true);
m_spriteFail.gameObject.SetActive(false);
m_anim.Play("qtedone", PlayMode.StopAll);
}
break;
case EnShowType.enShowFail:
{
m_spriteSucc.gameObject.SetActive(false);
m_spriteFail.gameObject.SetActive(true);
m_anim.Play("qtefailed", PlayMode.StopAll);
}
break;
default:
{
m_spriteSucc.gameObject.SetActive(false);
m_spriteFail.gameObject.SetActive(false);
}
break;
}
}
