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_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 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.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 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;
}
}
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 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_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();
}
}
