Ejemplo n.º 1
0
        /// <summary>
        /// 获取数据库表
        /// </summary>
        public static DataTable GetDataTable(string tableName)
        {
            string sql = string.Format("select * from {0};", tableName);

            return(SqliteHelper.ExecuteDataTable(sql, null));
        }
Ejemplo n.º 2
0
 /// <summary>
 /// 更新数据
 /// </summary>
 public static bool Updata(string tableName, Dictionary <string, object> data, KeyValuePair <string, object> where)
 {
     return(SqliteHelper.Update(tableName, data, where));
 }
Ejemplo n.º 3
0
 /// <summary>
 /// 删除数据
 /// </summary>
 public static bool Delete(string tableName, KeyValuePair <string, object> where)
 {
     return(SqliteHelper.Delete(tableName, where));
 }
Ejemplo n.º 4
0
 /// <summary>
 /// 插入数据
 /// </summary>
 public static bool Insert(string tableName, Dictionary <string, object> data)
 {
     return(SqliteHelper.Insert(tableName, data));
 }
Ejemplo n.º 5
0
 /// <summary>
 /// 创建表
 /// </summary>
 public static bool InitTable(string tableName, string[] definition)
 {
     return(CheckTable(tableName) || SqliteHelper.CreateTable(tableName, definition));
 }