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_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 viewer_disp()
{
//ページレポートに接続文字列とクエリ（sql）をセットして表示する
GrapeCity.ActiveReports.PageReport rpt = new GrapeCity.ActiveReports.PageReport();
// レポート定義のファイルをロードします。
rpt.Load(new System.IO.FileInfo("rpt_uriage_denpyou.rdlx"));
// 接続文字列を変更します
//rpt.Report.DataSources[0].ConnectionProperties.DataProvider = tss.DataSource;
rpt.Report.DataSources[0].ConnectionProperties.ConnectString = tss.GetConnectionString();
// 変更するSQL文を定義します
String tmpQuery = "select * from tss_uriage_denpyou_trn";
// SQL文を変更します
rpt.Report.DataSets[0].Query.CommandText = GrapeCity.ActiveReports.Expressions.ExpressionInfo.Parse(tmpQuery, GrapeCity.ActiveReports.Expressions.ExpressionResultType.String);
GrapeCity.ActiveReports.Document.PageDocument pageDocument = new GrapeCity.ActiveReports.Document.PageDocument(rpt);
viewer1.LoadDocument(pageDocument);
//viewer1.LoadDocument("rpt_uriage_denpyou.rdlx");
}
private void frm_utl_tss_nouhin_m_to_tss_nouhin_schedule_m_Load(object sender, EventArgs e)
{
tss.GetConnectionString();
lbl_db.Text = tss.DataSource;
}
