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