Esempio n. 1
0
        //---------------------------------------------------------------------
        void _loadTable(string table_name)
        {
            string str_query_select = string.Format("SELECT * FROM {0};", table_name);

            try
            {
                Dictionary <int, List <DataInfo> > map_data = Sqlite.getTableData(str_query_select);
                if (map_data.Count <= 0)
                {
                    return;
                }

                EbTableBuffer table = new EbTableBuffer(table_name);

                foreach (var i in map_data)
                {
                    //int data_id = i.Key;
                    //table.WriteInt(data_id);

                    List <DataInfo> list_data_info = i.Value;
                    foreach (var data_info in list_data_info)
                    {
                        object data_value = data_info.data_value;
                        string data_name  = data_info.data_name;

                        switch (data_info.data_type)
                        {
                        case 1:
                            table.WriteInt((int)data_value);
                            break;

                        case 2:
                            table.WriteFloat((float)(double)data_value);
                            break;

                        case 3:
                            table.WriteString((string)data_value);
                            break;
                        }
                    }
                }

                table.WriteEnd();

                mMapTable[table.TableName] = table;
            }
            catch (Exception e)
            {
                EbLog.Error(str_query_select + "_______" + e.ToString());
            }
        }
Esempio n. 2
0
        //---------------------------------------------------------------------
        void _loadTable(string table_name)
        {
            string str_query_select = string.Format("SELECT * FROM {0};", table_name);

            try
            {
                List <TbDataInfo> list_data = Sqlite.getTableData(str_query_select);
                if (list_data.Count <= 0)
                {
                    return;
                }

                EbTableBuffer table = new EbTableBuffer(table_name);

                foreach (var i in list_data)
                {
                    //int data_id = i.Key;
                    //table.WriteInt(data_id);
                    TbDataInfo      d_info         = i;
                    List <DataInfo> list_data_info = d_info.ListDataInfo;
                    foreach (var data_info in list_data_info)
                    {
                        object data_value = data_info.data_value;
                        //string data_name = data_info.data_name;

                        switch (data_info.data_type)
                        {
                        case 1:
                            table.WriteInt((int)data_value);
                            break;

                        case 2:
                            table.WriteFloat((float)(double)data_value);
                            break;

                        case 3:
                            table.WriteString((string)data_value);
                            break;
                        }
                    }
                }

                table.WriteEnd();

                mMapTable[table.TableName] = table;
            }
            catch (Exception)
            {
            }
        }