C# (CSharp) ECOLOGCarSimulator.Daos DatabaseAccesser示例

示例#1

        public static DataTable Get()
        {
            string query = "SELECT * FROM " + TableName;

            return(DatabaseAccesser.GetResult(query));
        }

示例#2

        public static int GetMaxTripId()
        {
            string query = $"SELECT MAX({ColumnTripId}) AS max_id FROM {TableName}";

            return(DatabaseAccesser.GetResult(query).Rows[0].Field <int?>("max_id") ?? 0);
        }

示例#3

 public static void Insert(DataTable dataTable)
 {
     DatabaseAccesser.Insert(TableName, dataTable);
 }