protected void makeMultipleWordList(DbDataReader reader, ref List <IchiranWordBo> wordList, ref IchiranWordBo word)
 {
     word              = new IchiranWordBo();
     word.ronri_name1  = reader["ronri_name1"].ToString();
     word.butsuri_name = reader["butsuri_name"].ToString();
     word.data_type    = reader["data_type"].ToString();
     wordList.Add(word);
 }
        public IchiranInitServiceOutBo execute()
        {
            IchiranInitServiceOutBo outBo    = new IchiranInitServiceOutBo();
            List <IchiranWordBo>    wordList = new List <IchiranWordBo>();
            IchiranWordBo           word     = new IchiranWordBo();

            if (!String.IsNullOrEmpty(base.inBo.clipboardText))
            {
                CommonFunction common             = new CommonFunction();
                string         dbConnectionString = common.getDbConnectionString();
                string         key  = this.inBo.clipboardText;
                string         nl   = Environment.NewLine;
                String[]       keys = key.Split(new string[] { nl }, StringSplitOptions.None);

                if (keys.Count() == 1)
                {
                    using (SQLiteConnection cn = new SQLiteConnection(dbConnectionString))
                    {
                        SQLiteCommand cmd = (SQLiteCommand)this.setQueryCommandSingle(cn, keys);
                        using (var reader = cmd.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                if (!this.makeSingleWordList(reader, ref wordList, ref word))
                                {
                                    continue;
                                }
                                ;
                            }
                        }
                        cn.Close();
                    }
                }
                else
                {
                    using (SQLiteConnection cn = new SQLiteConnection(dbConnectionString))
                    {
                        SQLiteCommand cmd = (SQLiteCommand)this.setQueryCommandMultiple(cn, keys);
                        using (var reader = cmd.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                this.makeMultipleWordList(reader, ref wordList, ref word);
                            }
                        }
                        cn.Close();
                    }
                }
            }
            this.makeIchiranDispList(ref outBo, this.inBo, wordList, word);
            return(outBo);
        }
 protected bool makeSingleWordList(DbDataReader reader, ref List <IchiranWordBo> wordList, ref IchiranWordBo word)
 {
     if (!isContains(reader["butsuri_name"].ToString(), wordList))
     {
         if (!reader["butsuri_name"].ToString().IsAlphanumeric())
         {
             word              = new IchiranWordBo();
             word.ronri_name1  = reader["ronri_name1"].ToString();
             word.butsuri_name = reader["butsuri_name"].ToString();
             word.data_type    = reader["data_type"].ToString();
             wordList.Add(word);
             return(false);
         }
         bool isDoneRonriNameDisp = false;
         if (BaseForm.UserInfo.pascal)
         {
             word              = new IchiranWordBo();
             word.ronri_name1  = reader["ronri_name1"].ToString();
             word.butsuri_name = reader["butsuri_name"].ToString().ToPascalCase();
             word.data_type    = reader["data_type"].ToString();
             wordList.Add(word);
             isDoneRonriNameDisp = true;
         }
         if (BaseForm.UserInfo.camel)
         {
             word              = new IchiranWordBo();
             word.ronri_name1  = isDoneRonriNameDisp ? "" : reader["ronri_name1"].ToString();
             word.butsuri_name = reader["butsuri_name"].ToString().ToCamelCase();
             word.data_type    = reader["data_type"].ToString();
             wordList.Add(word);
             isDoneRonriNameDisp = true;
         }
         if (BaseForm.UserInfo.snake)
         {
             word              = new IchiranWordBo();
             word.ronri_name1  = isDoneRonriNameDisp ? "" : reader["ronri_name1"].ToString();
             word.butsuri_name = reader["butsuri_name"].ToString().ToSnakeCase();
             word.data_type    = reader["data_type"].ToString();
             wordList.Add(word);
         }
     }
     return(true);
 }
 protected void makeIchiranDispList(ref IchiranInitServiceOutBo outBo, IchiranInitServiceInBo ichiranInitServiceInBo, List <IchiranWordBo> wordList, IchiranWordBo word)
 {
     if (wordList.Count == 0 || String.IsNullOrEmpty(ichiranInitServiceInBo.clipboardText))
     {
         word.ronri_name1  = "-";
         word.butsuri_name = Constant.NONE_WORD;
         wordList.Add(word);
     }
     outBo.wordList = this.toIchiranDispList(wordList, this.inBo.dispNumber);
 }