// 検索ボタン押下時、データを読み込み、ＤＡＴＡＧＲＩＤＶＩＥＷを更新する
// サブサブプロシージャ：グリットビュー右端にボタンを追加
private void addButtonsToDataGridView(DataGridView dgv)
{
bool adm_flag = false;
TfSQL flag = new TfSQL();
bool fl = flag.sqlExecuteScalarBool("select admin_flag from qc_user where qcuser = '******'");
if (fl == true)
{
adm_flag = true;
}
Open = new DataGridViewButtonColumn();
Open.Text = "Open";
Open.UseColumnTextForButtonValue = true;
Open.Width = 45;
dgv.Columns.Add(Open);
if (adm_flag == true)
{
btnDelete.Visible = true;
}
}
// ロード時の処理
private void frmManual_Load(object sender, EventArgs e)
{
// 当フォームの表示場所を指定
this.Left = 300;
this.Top = 15;
if (cmbLine.Text == "")
{
btnMeasure.Enabled = false;
}
//Exit app if user has been log in by another device
TfSQL flag = new TfSQL();
string ipadd = flag.sqlExecuteScalarString("select ip_address from qc_user where qcuser = '******'");
bool expmiss = flag.sqlExecuteScalarBool("select export_permission from qc_user where qcuser = '******'");
if (ipadd == "null")
{
flag.sqlExecuteScalarString("UPDATE qc_user SET loginstatus=true, ip_address = '" + _ip + "' where qcuser = '******'");
}
if (ipadd != "null" && ipadd != _ip)
{
DialogResult res = MessageBox.Show("User is logged in " + _ip + "," + System.Environment.NewLine +
"Do you want to log out and log in again ?", "Notice", MessageBoxButtons.OK, MessageBoxIcon.Question);
if (res == DialogResult.OK)
{
Application.Exit();
}
}
if (txtUser.Text != "Admin")
{
string[] a = txtUser.Text.Split('_');
//User permission
if (a[1] != "CHK" && txtUser.Text != "Admin")
{
btnMeasure.Enabled = false;
btnRegister.Enabled = false;
btnDelete.Enabled = false;
}
if (expmiss == false && txtUser.Text != "Admin")
{
btnExport.Enabled = false;
}
}
// ＤＡＴＥＴＩＭＥＰＩＣＫＥＲを１０日前の日付にする
dtpSet10daysBefore(dtpLotFrom);
// ＤＡＴＥＴＩＭＥＰＩＣＫＥＲの分以下を切り上げる
dtpRoundUpHour(dtpLotTo);
// ＤＡＴＥＴＩＭＥＰＩＣＫＥＲの分以下を下げる
dtpRounddownHour(dtpLotInput);
// 各種処理用のテーブルを生成してデータを読み込む
dtBuffer = new DataTable();
defineBufferAndHistoryTable(ref dtBuffer);
dtHistory = new DataTable();
defineBufferAndHistoryTable(ref dtHistory);
readDtHistory(ref dtHistory);
dtUpLowIns = new DataTable();
setLimitSetAndCommand(ref dtUpLowIns);
// グリットビューの更新
updateDataGripViews(dtBuffer, dtHistory, ref dgvBuffer, ref dgvHistory);
// グリットビュー右端にボタンを追加（初回のみ）
addButtonsToDataGridView(dgvHistory);
}
