public int GetGameBySearch(DateTime start, DateTime end, string team, ref DataTable dt)
{
SQLiteDBHelper sqliteHelper = new SQLiteDBHelper();
StringBuilder strSql = new StringBuilder();
strSql.Append("select gametime,league,home,visitor,sn from game ");
strSql.Append("where 1 = 1 ");
if (start != null)
{
strSql.Append("and gametime >= @start ");
}
if (end != null)
{
strSql.Append("and gametime <= @end ");
}
if (team != "")
{
strSql.Append("and home like @home or visitor like @visitor ");
}
strSql.Append(" order by gametime desc");
SQLiteParameter[] para =
{
sqliteHelper.MakeSQLiteParameter("@start", DbType.DateTime, start),
sqliteHelper.MakeSQLiteParameter("@end", DbType.DateTime, end),
sqliteHelper.MakeSQLiteParameter("@home", DbType.String, 32,"%" + team + "%"),
sqliteHelper.MakeSQLiteParameter("@visitor", DbType.String, 32,"%" + team + "%")
};
int result = sqliteHelper.ExecuteDataTable(strSql, para, ref dt);
return(result);
}
public int GetGameDetailByKey(int gameSN, ref DataTable dt)
{
SQLiteDBHelper sqliteHelper = new SQLiteDBHelper();
StringBuilder strSql = new StringBuilder();
strSql.Append("select changetime,win,draw,lose,changeminute from gamedetail ");
strSql.Append("where gamesn = @gamesn ");
SQLiteParameter[] para =
{
sqliteHelper.MakeSQLiteParameter("@gamesn", DbType.Int32, gameSN)
};
int result = sqliteHelper.ExecuteDataTable(strSql, para, ref dt);
return(result);
}
public int GetGameByKey(int gameSN, ref DataTable dt)
{
SQLiteDBHelper sqliteHelper = new SQLiteDBHelper();
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from game ");
strSql.Append("where sn = @sn order by gametime desc");
SQLiteParameter[] para =
{
sqliteHelper.MakeSQLiteParameter("@sn", DbType.Int32, gameSN)
};
int result = sqliteHelper.ExecuteDataTable(strSql, para, ref dt);
return(result);
}
public int GetMaxGameSN()
{
DataTable dt = new DataTable();
SQLiteDBHelper sqliteHelper = new SQLiteDBHelper();
StringBuilder strSql = new StringBuilder();
strSql.Append("select max(sn) from game");
int result = sqliteHelper.ExecuteDataTable(strSql, null, ref dt);
if (result != -1)
{
if (dt.Rows[0][0].ToString().Equals(string.Empty))
{
result = 0;
}
else
{
result = int.Parse(dt.Rows[0][0].ToString());
}
}
return(result);
}