/// <summary> /// 执行查询SQL,返回受影响行数 /// </summary> /// <param name="sql">sql语句</param> /// <param name="parameters">参数</param> /// <returns></returns> public int IntQuery(string sql, SQLiteParameter[] parameters) { int result = 0; try { SQLiteDBHelper dbHelper = new SQLiteDBHelper(); result = dbHelper.ExecuteNonQuery(sql, parameters); } catch { } return(result); }
/// <summary> /// 执行查询SQL,返回查询结果表 /// </summary> /// <param name="sql">sql语句</param> /// <param name="parameters">参数</param> /// <returns>查询结果表</returns> public DataTable DataTableQuery(string sql, SQLiteParameter[] parameters) { DataTable data = new DataTable(); try { SQLiteDBHelper dbHelper = new SQLiteDBHelper(); data = dbHelper.ExecuteDataTable(sql, parameters); } catch { } return(data); }
/// <summary> /// 执行查询SQL,返回查询结果的首行首列 /// </summary> /// <param name="sql">sql语句</param> /// <param name="parameters">参数</param> /// <returns></returns> public string StringQuery(string sql, SQLiteParameter[] parameters) { string result = string.Empty; try { SQLiteDBHelper dbHelper = new SQLiteDBHelper(); DataTable data = dbHelper.ExecuteDataTable(sql, parameters); if (data != null && data.Rows.Count > 0) { result = data.Rows[0][0].ToString(); } } catch { } return(result); }