public void DropAndCreate(Context context)
        {
            SQLiteDatabase db = new MySQLiteOpenHelper(context).ReadableDatabase;

            db.ExecSQL(DeleteQuery);
            OnCreate(db);
        }
        //DB에 대화가 있으면 교체, 없으면 삽입
        public void InsertOrUpdate(Context context, Dialogue dialogue)
        {
            SQLiteDatabase db = new MySQLiteOpenHelper(context).WritableDatabase;

            ContentValues values = new ContentValues();

            values.Put(_ColumnNameStr[(int)COLUMN_NAME.THREAD_ID], dialogue.Thread_id);
            values.Put(_ColumnNameStr[(int)COLUMN_NAME.ADDRESS], dialogue.Address);
            values.Put(_ColumnNameStr[(int)COLUMN_NAME.LABLE_COMMON], dialogue.Lables[0]);
            values.Put(_ColumnNameStr[(int)COLUMN_NAME.LABLE_DELIVERY], dialogue.Lables[1]);
            values.Put(_ColumnNameStr[(int)COLUMN_NAME.LABLE_CARD], dialogue.Lables[2]);
            values.Put(_ColumnNameStr[(int)COLUMN_NAME.LABLE_IDENTIFICATION], dialogue.Lables[3]);
            values.Put(_ColumnNameStr[(int)COLUMN_NAME.LABLE_PUBLIC], dialogue.Lables[4]);
            values.Put(_ColumnNameStr[(int)COLUMN_NAME.LABLE_AGENCY], dialogue.Lables[5]);
            values.Put(_ColumnNameStr[(int)COLUMN_NAME.LABLE_ETC], dialogue.Lables[6]);

            db.InsertWithOnConflict(_TABLE_NAME, null, values, Conflict.Replace);

            db.Close();
        }
        //모든 Lable 데이터를 DB에서 불러온다.
        public DialogueSet Load(Context context)
        {
            SQLiteDatabase db = new MySQLiteOpenHelper(context).ReadableDatabase;

            ICursor cursor = db.Query(_TABLE_NAME, new string[]
            {
                _ColumnNameStr[(int)COLUMN_NAME.THREAD_ID],
                _ColumnNameStr[(int)COLUMN_NAME.ADDRESS],
                _ColumnNameStr[(int)COLUMN_NAME.LABLE_COMMON],
                _ColumnNameStr[(int)COLUMN_NAME.LABLE_DELIVERY],
                _ColumnNameStr[(int)COLUMN_NAME.LABLE_CARD],
                _ColumnNameStr[(int)COLUMN_NAME.LABLE_IDENTIFICATION],
                _ColumnNameStr[(int)COLUMN_NAME.LABLE_PUBLIC],
                _ColumnNameStr[(int)COLUMN_NAME.LABLE_AGENCY],
                _ColumnNameStr[(int)COLUMN_NAME.LABLE_ETC],
            },
                                      null, null, null, null, null);

            DialogueSet result = null;

            if (cursor != null)
            {
                result = new DialogueSet();
                while (cursor.MoveToNext())
                {
                    Dialogue objDialogue = new Dialogue();
                    objDialogue.Thread_id = cursor.GetLong(0);
                    objDialogue.Address   = cursor.GetString(1);

                    for (int i = 0; i < Dialogue.Lable_COUNT; i++)   //DB의 2~8행까지 데이터를 0~6번 레이블에 저장
                    {
                        objDialogue.Lables[i] = cursor.GetInt(i + 2);
                    }
                    result.InsertOrUpdate(objDialogue);
                }
            }

            cursor.Close();
            db.Close();
            return(result);
        }
 public LableDBManager()
 {
     _Helper = new MySQLiteOpenHelper(Application.Context);
 }