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); }