public SearchData(GameMain.TABLE_TYPE _eTableType, Define.WHERE_PATTERN _eWherePattern, List <int> _int_list, BannerBase.MODE _eBannerMode = BannerBase.MODE.NONE)
{
m_eTableType = _eTableType;
m_eWherePattern = _eWherePattern;
int_list = _int_list;
m_strWhere = "";
m_eBannerMode = _eBannerMode;
}
public List <DataItem> Select(Define.WHERE_PATTERN _ePattern, List <int> _iList = null)
{
List <DataItem> ret = new List <DataItem> ();
foreach (DataItem data in m_soDataItem.list)
{
if (data.Equals(_ePattern, _iList) == true)
{
ret.Add(data);
}
}
return(ret);
/*
* string strQuery = "select * from " + TABLE_NAME;
*
* if (_strWhere != null) {
* strQuery += " where " + _strWhere;
* }
*
* //Debug.Log ("DBWork SelectQuery : "+strQuery);
*
* //m_sqlDBはDBDataBaseのプロテクト変数
* SQLiteQuery query = new SQLiteQuery(m_sqlDB,strQuery);
*
* List<DataItem> ret = new List<DataItem> ();
*
* if (_bUse) {
* Debug.Log (strQuery);
* }
* //テーブルからデータを取ってくる
* while (query.Step ()) {
* DataItem data = MakeData (query);
* ret.Add (data);
* }
* query.Release ();
*
* return ret;
*/
}
public bool Equals(Define.WHERE_PATTERN _ePattern, List <int> _iList)
{
switch (_ePattern)
{
case Define.WHERE_PATTERN.SERIAL_EQUAL:
if (item_serial == _iList[0])
{
return(true);
}
break;
case Define.WHERE_PATTERN.SERIAL_NOT_EQUAL:
if (item_serial != _iList [0])
{
return(true);
}
break;
case Define.WHERE_PATTERN.RATE:
if ((item_id == 23 || item_id == 24) && status == 1)
{
return(true);
}
break;
case Define.WHERE_PATTERN.ITEM_STATUS_NOT_EQUAL:
if (status != _iList [0])
{
return(true);
}
break;
default:
break;
}
return(false);
}
