예제 #1
0
 private void startModeSetting(ref UserInfoBo userInfo, Login form)
 {
     CommonFunction common = new CommonFunction();
     if (form.kojinRdo.Checked)
     {
         common.setSqliteDbContextPath(WordConverter_v2.Settings1.Default.SqliteContextString);
         userInfo.startUpMode = (int)StartUpMode.個人;
     }
     else
     {
         StringBuilder sb = new StringBuilder();
         sb.Append("Server=" + WordConverter_v2.Settings1.Default.ServerName);
         sb.Append(";Port=" + WordConverter_v2.Settings1.Default.DbPortNo);
         sb.Append(";User Id=" + WordConverter_v2.Settings1.Default.DbUserId);
         sb.Append(";Password="******";Database=" + WordConverter_v2.Settings1.Default.DbName);
         common.setPostgresDbContext(sb.ToString());
         userInfo.startUpMode = (int)StartUpMode.複数人;
     }
 }
예제 #2
0
 /// <summary>
 /// 初期表示アクション
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void Login_Load(object sender, EventArgs e)
 {
     CommonFunction common = new CommonFunction();
     this.UserId.Text = WordConverter_v2.Settings1.Default.UserId;
     this.fukusuRdo.Checked = WordConverter_v2.Settings1.Default.FukusuRiyou;
     this.kojinRdo.Checked = WordConverter_v2.Settings1.Default.KojinRiyou;
 }
예제 #3
0
 private void startModeSetting(ref UserInfoBo userInfo, Login form)
 {
     CommonFunction common = new CommonFunction();
     if (form.kojinRdo.Checked)
     {
         userInfo.startUpMode = (int)StartUpMode.個人;
         userInfo.dbType = Constant.SQLITE_CONNECT;
     }
     else
     {
         userInfo.startUpMode = (int)StartUpMode.複数人;
         userInfo.dbType = Constant.POSTGRES_CONNECT;
     }
 }
예제 #4
0
        private static void ExecutePostgresDDL()
        {
            StringBuilder sb = new StringBuilder();
            sb.AppendLine("CREATE TABLE USER_MST( ");
            sb.AppendLine("  user_id SERIAL PRIMARY KEY");
            sb.AppendLine("  , emp_id INTEGER UNIQUE");
            sb.AppendLine("  , user_name TEXT");
            sb.AppendLine("  , kengen INTEGER");
            sb.AppendLine("  , mail_id TEXT");
            sb.AppendLine("  , password TEXT");
            sb.AppendLine("  , mail_address TEXT");
            sb.AppendLine("  , sanka_kahi INTEGER");
            sb.AppendLine("  , delete_flg INTEGER");
            sb.AppendLine("  , version INTEGER");
            sb.AppendLine("  , cre_date TEXT");
            sb.AppendLine("); ");
            sb.AppendLine("");
            sb.AppendLine("CREATE TABLE WORD_DIC( ");
            sb.AppendLine("  word_id SERIAL PRIMARY KEY");
            sb.AppendLine("  , ronri_name1 TEXT");
            sb.AppendLine("  , ronri_name2 TEXT");
            sb.AppendLine("  , butsuri_name TEXT");
            sb.AppendLine("  , data_type text");
            sb.AppendLine("  , user_id INTEGER");
            sb.AppendLine("  , version INTEGER");
            sb.AppendLine("  , cre_date TEXT");
            sb.AppendLine("  , FOREIGN KEY (user_id) REFERENCES USER_MST(user_id)");
            sb.AppendLine("); ");
            sb.AppendLine("");
            sb.AppendLine("CREATE TABLE WORD_SHINSEI( ");
            sb.AppendLine("  shinsei_id SERIAL PRIMARY KEY");
            sb.AppendLine("  , ronri_name1 TEXT");
            sb.AppendLine("  , ronri_name2 TEXT");
            sb.AppendLine("  , butsuri_name TEXT");
            sb.AppendLine("  , word_id INTEGER");
            sb.AppendLine("  , status INTEGER");
            sb.AppendLine("  , user_id INTEGER");
            sb.AppendLine("  , version INTEGER");
            sb.AppendLine("  , cre_date TEXT");
            sb.AppendLine("  , FOREIGN KEY (user_id) REFERENCES USER_MST(user_id)");
            sb.AppendLine("); ");
            sb.AppendLine("CREATE TABLE or_map( ");
            sb.AppendLine("  or_id SERIAL PRIMARY KEY");
            sb.AppendLine("  , data_type text");
            sb.AppendLine("  , db_data_type text");
            sb.AppendLine("  , project_name text");
            sb.AppendLine("  , yuko_flg INTEGER");
            sb.AppendLine("  , delete_flg INTEGER");
            sb.AppendLine("  , version INTEGER");
            sb.AppendLine("  , cre_date text");
            sb.AppendLine(");");
            sb.AppendLine("insert ");
            sb.AppendLine("into USER_MST( ");
            sb.AppendLine("  user_id");
            sb.AppendLine("  , emp_id");
            sb.AppendLine("  , user_name");
            sb.AppendLine("  , kengen");
            sb.AppendLine("  , mail_id");
            sb.AppendLine("  , password");
            sb.AppendLine("  , mail_address");
            sb.AppendLine("  , sanka_kahi");
            sb.AppendLine("  , delete_flg");
            sb.AppendLine("  , version");
            sb.AppendLine(") ");
            sb.AppendLine("values ( ");
            sb.AppendLine("  1");
            sb.AppendLine("  , 999");
            sb.AppendLine("  , 'Admin'");
            sb.AppendLine("  , 0");
            sb.AppendLine("  , '999'");
            sb.AppendLine("  , '*****@*****.**'");
            sb.AppendLine("  , '*****@*****.**'");
            sb.AppendLine("  , 0");
            sb.AppendLine("  , 0");
            sb.AppendLine("  , 0");
            sb.AppendLine("); ");
            sb.AppendLine("insert into public.or_map(or_id,data_type,db_data_type,project_name,yuko_flg,delete_flg,version,cre_date) values (1,'String','VARCHAR',null,0,0,0,null);");
            sb.AppendLine("insert into public.or_map(or_id,data_type,db_data_type,project_name,yuko_flg,delete_flg,version,cre_date) values (2,'Integer','INTEGER',null,0,0,0,null);");
            sb.AppendLine("insert into public.or_map(or_id,data_type,db_data_type,project_name,yuko_flg,delete_flg,version,cre_date) values (3,'Date','DATE',null,0,0,0,null);");
            sb.AppendLine("insert into public.or_map(or_id,data_type,db_data_type,project_name,yuko_flg,delete_flg,version,cre_date) values (4,'Timestamp','TIMESTAMP',null,0,0,0,null);");
            string postgresDdlText = sb.ToString();

            CommonFunction common = new CommonFunction();
            string dbConnectionString = common.getDbConnectionString();
            using (NpgsqlConnection cn = new NpgsqlConnection(dbConnectionString))
            {
                cn.Open();
                NpgsqlCommand cmd = cn.CreateCommand();
                cmd.CommandText = postgresDdlText;
                cmd.ExecuteNonQuery();
                cn.Close();
            }
        }
예제 #5
0
        private void sqliteTestConnectBtn_Click(object sender, EventArgs e)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("Data Source=" + this.sqliteDbFilePath.Text);
            sb.Append(";foreign keys=true;");
            CommonFunction common = new CommonFunction();

            if (common.isExistSqliteDb(sb.ToString()) && common.isExistSqliteDbTable(sb.ToString()))
            {
                this.endSqliteTestConnectProc(sb.ToString());
                return;
            }
            else if (!common.isExistSqliteDbTable(sb.ToString()))
            {
                common.ExecuteSqliteDDL();
                this.endSqliteTestConnectProc(this.getSqliteDbFilePath());
                return;
            }

            StringBuilder eSb = new StringBuilder();
            eSb.AppendLine("DB接続失敗");
            MessageBox.Show(eSb.ToString());
        }
예제 #6
0
        private void sqliteTestConnectBtn_Click(object sender, EventArgs e)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("Data Source=" + this.sqliteDbFilePath.Text);
            sb.Append(";foreign keys=true;");
            CommonFunction common = new CommonFunction();
            string dbConnectionString = common.getDbConnectionString();
            string dbProviderName = common.getDbProviderName();

            try
            {
                using (SQLiteConnection cn = new SQLiteConnection(sb.ToString()))
                {
                    cn.Open();
                    SQLiteCommand cmd = cn.CreateCommand();
                    cmd.CommandText = "SELECT * FROM WORD_DIC";
                    cmd.ExecuteReader();

                    common.setSqliteDbContextPath(sb.ToString());
                    MyRepository rep = new MyRepository();
                    UserMst fromUser = rep.FindUserMstByUserId(999);

                    MessageBox.Show("DB接続に成功しました!!");
                    this.sqliteConnectableDbPath.Text = sb.ToString();
                    this.sqliteSaveBtn.Visible = true;
                    this.sqliteDbFilePath.Enabled = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("DB接続失敗");
                common.resetDbContextPath(dbConnectionString, dbProviderName);
            }
        }