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 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"); } }