private void btn_hyouji_Click(object sender, EventArgs e) { try { dt.Rows.Clear(); dt.Columns.Clear(); dt.Clear(); TssSystemLibrary tssdb = new TssSystemLibrary(); string connStr = tssdb.GetConnectionString(); OracleConnection conn = new OracleConnection(connStr); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; string sql = "select * from " + cb_table_name.Text; if (tb_sql.Text.Length >= 1) { sql = sql + " " + tb_sql.Text; } cmd.CommandText = sql; da = new OracleDataAdapter(cmd); cb = new OracleCommandBuilder(da); das = new DataSet(); da.Fill(dt); dgv_table.DataSource = null; dgv_table.DataSource = dt; } catch { dgv_table.DataSource = null; } }
private void btn_logout_Click(object sender, EventArgs e) { //ユーザーコードの取得 string TempPath = ConfigurationManager.AppSettings["TempPath"]; //テンポラリフォルダのパスの取得 //まずログアウト情報更新 string usercd; using (StreamReader sr = new StreamReader(TempPath + "user.txt")) { usercd = sr.ReadToEnd(); } TssSystemLibrary tsslib = new TssSystemLibrary(); string sql = "UPDATE tss_user_m SET login_flg = '0',logout_datetime = sysdate WHERE user_cd = '" + usercd + "'"; tsslib.OracleUpdate(sql); //ログイン画面へ this.Opacity = 0; frm_login frm_login = new frm_login(); frm_login.ShowDialog(this); frm_login.Dispose(); //ここから先のコードが実行されるということは、ログイン成功ということ //ログインユーザーIDの取得・表示 using (StreamReader sr = new StreamReader(TempPath + "user.txt")) { usercd = sr.ReadToEnd(); } if (usercd == "notlogin") //ユーザー名にnotloginという文字列が入っていたら終了する { Application.Exit(); } }
private void status_disp() { TssSystemLibrary tss = new TssSystemLibrary(); tss.GetSystemSetting(); tss.GetUser(); ss_status.Items.Add(tss.system_name); ss_status.Items.Add(tss.system_version); ss_status.Items.Add(tss.user_name); ss_status.Items.Add(tss.kengen1 + tss.kengen2 + tss.kengen3 + tss.kengen4 + tss.kengen5 + tss.kengen6); }
private void btn_syuuryou_Click(object sender, EventArgs e) { string TempPath = ConfigurationManager.AppSettings["TempPath"]; //テンポラリフォルダのパスの取得 //ログアウト情報更新 string usercd; using (StreamReader sr = new StreamReader(TempPath + "user.txt")) { usercd = sr.ReadToEnd(); } TssSystemLibrary tsslib = new TssSystemLibrary(); string sql = "UPDATE tss_user_m SET login_flg = '0',logout_datetime = sysdate WHERE user_cd = '" + usercd + "'"; tsslib.OracleUpdate(sql); Application.Exit(); }
private void btn_login_Click(object sender, EventArgs e) { try { TssSystemLibrary tsslib = new TssSystemLibrary(); string connStr = tsslib.GetConnectionString(); tsslib.GetSystemSetting(); OracleConnection conn = new OracleConnection(); OracleCommand cmd = new OracleCommand(); OracleDataAdapter da = new OracleDataAdapter(); DataTable dt = new DataTable(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; conn.ConnectionString = connStr; da.SelectCommand = cmd; cmd.CommandText = "SELECT * from tss_user_m where user_cd = '" + tb_user_cd.Text.ToString() + "' and password = '******' and login_kyoka_kbn = '1'"; conn.Close(); da.Fill(dt); if (dt.Rows.Count < 1) { MessageBox.Show("ユーザーコードまたはパスワードが違います。"); } else { //ログイン成功 string TempPath = ConfigurationManager.AppSettings["TempPath"]; //テンポラリフォルダのパスの取得 using (StreamWriter sw = new StreamWriter(TempPath + "user.txt", false)) { // ファイルへの書き込み sw.Write(tb_user_cd.Text); //ユーザー名を書き込む } //ログイン情報更新 string sql = "UPDATE tss_user_m SET login_flg = '1',login_datetime = sysdate,login_version = 'v" + tsslib.system_version + " CODE:" + tsslib.code_version + "' WHERE user_cd = '" + tb_user_cd.Text.ToString() + "'"; tsslib.OracleUpdate(sql); //ログイン記録の更新 tss.Login_Rireki("1"); //ログイン画面を閉じる this.Close(); } } catch (System.Exception ex) { MessageBox.Show(ex.ToString(), "エラー"); Application.Exit(); } }
private void cb_table_name_DropDown(object sender, EventArgs e) { //テーブル名を取得してコンボボックスのアイテムに追加する TssSystemLibrary tss = new TssSystemLibrary(); DataTable dt2 = new DataTable(); dt2 = tss.OracleSelect("SELECT TABLE_NAME FROM USER_TABLES order by table_name asc"); if (dt2 == null) { MessageBox.Show("テーブルが取得できません。", "エラー"); return; } cb_table_name.Items.Clear(); foreach (DataRow tablename in dt2.Rows) { cb_table_name.Items.Add(tablename[0]); } }
private void logout_write() { string TempPath = ConfigurationManager.AppSettings["TempPath"]; //テンポラリフォルダのパスの取得 //ログアウト情報更新 string usercd; using (StreamReader sr = new StreamReader(TempPath + "user.txt")) { usercd = sr.ReadToEnd(); } TssSystemLibrary tsslib = new TssSystemLibrary(); string sql = "UPDATE tss_user_m SET login_flg = '0',logout_datetime = sysdate WHERE user_cd = '" + usercd + "'"; tsslib.OracleUpdate(sql); //ログイン履歴の更新 if (usercd != "" && usercd != "notlogin") { tss.Login_Rireki("2"); } }
private void status_disp() { TssSystemLibrary tss = new TssSystemLibrary(); tss.GetSystemSetting(); tss.GetUser(); //tss.GetConnectionString(); ss_status.Items.Clear(); //追加する前にクリアする ss_status.Items.Add(tss.system_name); ss_status.Items.Add(tss.system_version); ss_status.Items.Add("CODE:" + tss.code_version); ss_status.Items.Add(tss.user_name); ss_status.Items.Add(tss.kengen1+tss.kengen2+tss.kengen3+"-"+tss.kengen4+tss.kengen5+tss.kengen6+"-"+tss.kengen7+tss.kengen8+tss.kengen9); switch (tss.DataSource) { case "pdb2a": lbl_db.Text = "TSS SYSTEM PRODUCTION Connect"; lbl_db.BackColor = Color.RoyalBlue; lbl_db.ForeColor = Color.White; break; case "pdb2a_dev": lbl_db.Text = "開発用DBに接続中!"; lbl_db.BackColor = Color.Red; lbl_db.ForeColor = Color.White; break; default: lbl_db.Text = "不明なDBに接続されています!"; lbl_db.BackColor = Color.Red; lbl_db.ForeColor = Color.White; break; } //メッセージ表示 DataTable w_dt_ctrl = new DataTable(); w_dt_ctrl = tss.OracleSelect("select * from tss_control_m where system_cd = '0101'"); if(w_dt_ctrl.Rows.Count<=0) { MessageBox.Show("コントロールマスタに異常があります。\nシステムを終了します。"); Application.Exit(); } //メッセージの表示 lbl_msg1.Text = w_dt_ctrl.Rows[0]["msg1"].ToString(); lbl_msg2.Text = w_dt_ctrl.Rows[0]["msg2"].ToString(); lbl_msg3.Text = w_dt_ctrl.Rows[0]["msg3"].ToString(); //メッセージの色の設定 switch (w_dt_ctrl.Rows[0]["color1"].ToString()) { case "1": lbl_msg1.ForeColor = Color.Red; break; case "2": lbl_msg1.ForeColor = Color.Blue; break; case "3": lbl_msg1.ForeColor = Color.Green; break; case "4": lbl_msg1.ForeColor = Color.Orange; break; case "5": lbl_msg1.ForeColor = Color.Gray; break; default: lbl_msg1.ForeColor = Color.Black; break; } switch (w_dt_ctrl.Rows[0]["color2"].ToString()) { case "1": lbl_msg2.ForeColor = Color.Red; break; case "2": lbl_msg2.ForeColor = Color.Blue; break; case "3": lbl_msg2.ForeColor = Color.Green; break; case "4": lbl_msg2.ForeColor = Color.Orange; break; case "5": lbl_msg2.ForeColor = Color.Gray; break; default: lbl_msg2.ForeColor = Color.Black; break; } switch (w_dt_ctrl.Rows[0]["color3"].ToString()) { case "1": lbl_msg3.ForeColor = Color.Red; break; case "2": lbl_msg3.ForeColor = Color.Blue; break; case "3": lbl_msg3.ForeColor = Color.Green; break; case "4": lbl_msg3.ForeColor = Color.Orange; break; case "5": lbl_msg3.ForeColor = Color.Gray; break; default: lbl_msg3.ForeColor = Color.Black; break; } }
private void logout_write() { string TempPath = ConfigurationManager.AppSettings["TempPath"]; //テンポラリフォルダのパスの取得 //ログアウト情報更新 string usercd; using (StreamReader sr = new StreamReader(TempPath + "user.txt")) { usercd = sr.ReadToEnd(); } TssSystemLibrary tsslib = new TssSystemLibrary(); string sql = "UPDATE tss_user_m SET login_flg = '0',logout_datetime = sysdate WHERE user_cd = '" + usercd + "'"; tsslib.OracleUpdate(sql); //ログイン履歴の更新 tss.Login_Rireki("2"); }
private void status_disp() { TssSystemLibrary tss = new TssSystemLibrary(); tss.GetSystemSetting(); tss.GetUser(); ss_status.Items.Clear(); //追加する前にクリアする ss_status.Items.Add(tss.system_name); ss_status.Items.Add(tss.system_version); ss_status.Items.Add("CODE:" + tss.code_version); ss_status.Items.Add(tss.user_name); ss_status.Items.Add(tss.kengen1 + tss.kengen2 + tss.kengen3 + "-" + tss.kengen4 + tss.kengen5 + tss.kengen6 + "-" + tss.kengen7 + tss.kengen8 + tss.kengen9); switch (tss.DataSource) { case "pdb2a": lbl_db.Text = "TSS SYSTEM PRODUCTION Connect"; lbl_db.BackColor = Color.RoyalBlue; lbl_db.ForeColor = Color.White; break; case "pdb2a_dev": lbl_db.Text = "開発用DBに接続中!"; lbl_db.BackColor = Color.Red; lbl_db.ForeColor = Color.White; break; default: lbl_db.Text = "不明なDBに接続されています!"; lbl_db.BackColor = Color.Red; lbl_db.ForeColor = Color.White; break; } //メッセージ表示 DataTable w_dt_ctrl = new DataTable(); w_dt_ctrl = tss.OracleSelect("select * from tss_control_m where system_cd = '0101'"); if (w_dt_ctrl.Rows.Count <= 0) { MessageBox.Show("コントロールマスタに異常があります。\nシステムを終了します。"); Application.Exit(); } //メッセージの表示 lbl_msg1.Text = w_dt_ctrl.Rows[0]["msg1"].ToString(); lbl_msg2.Text = w_dt_ctrl.Rows[0]["msg2"].ToString(); lbl_msg3.Text = w_dt_ctrl.Rows[0]["msg3"].ToString(); lbl_msg4.Text = w_dt_ctrl.Rows[0]["msg4"].ToString(); //メッセージの色の設定 switch (w_dt_ctrl.Rows[0]["color1"].ToString()) { case "1": lbl_msg1.ForeColor = Color.Red; break; case "2": lbl_msg1.ForeColor = Color.Blue; break; case "3": lbl_msg1.ForeColor = Color.Green; break; case "4": lbl_msg1.ForeColor = Color.Orange; break; case "5": lbl_msg1.ForeColor = Color.Gray; break; default: lbl_msg1.ForeColor = Color.Black; break; } switch (w_dt_ctrl.Rows[0]["color2"].ToString()) { case "1": lbl_msg2.ForeColor = Color.Red; break; case "2": lbl_msg2.ForeColor = Color.Blue; break; case "3": lbl_msg2.ForeColor = Color.Green; break; case "4": lbl_msg2.ForeColor = Color.Orange; break; case "5": lbl_msg2.ForeColor = Color.Gray; break; default: lbl_msg2.ForeColor = Color.Black; break; } switch (w_dt_ctrl.Rows[0]["color3"].ToString()) { case "1": lbl_msg3.ForeColor = Color.Red; break; case "2": lbl_msg3.ForeColor = Color.Blue; break; case "3": lbl_msg3.ForeColor = Color.Green; break; case "4": lbl_msg3.ForeColor = Color.Orange; break; case "5": lbl_msg3.ForeColor = Color.Gray; break; default: lbl_msg3.ForeColor = Color.Black; break; } switch (w_dt_ctrl.Rows[0]["color4"].ToString()) { case "1": lbl_msg4.ForeColor = Color.Red; break; case "2": lbl_msg4.ForeColor = Color.Blue; break; case "3": lbl_msg4.ForeColor = Color.Green; break; case "4": lbl_msg4.ForeColor = Color.Orange; break; case "5": lbl_msg4.ForeColor = Color.Gray; break; default: lbl_msg4.ForeColor = Color.Black; break; } }