public void updateControls(string model, string process, string inspect, string user, string ip)
{
txtModel.Text = model;
txtProcess.Text = process;
txtInspect.Text = inspect;
txtUser.Text = user;
_ip = ip;
string sql_line = "select line from tbl_model_line where model = '" + txtModel.Text + "' order by line";
TfSQL ln = new TfSQL();
ln.getComboBoxData(sql_line, ref cmbLine);
//cmbLine.SelectedIndex = 0;
}
// サブプロシージャ：型式コンボボックスへ候補を取り込む
public void getComboListFromDB(ref ComboBox cmb)
{
string sql_model = "select model from tbl_model_dbplace order by model";
System.Diagnostics.Debug.Print(sql_model);
TfSQL tf = new TfSQL();
tf.getComboBoxData(sql_model, ref cmb);
if (cmbModel.Items.Count > 0)
{
cmbModel.SelectedIndex = 0;
}
}
// ロード時の処理（コンボボックスに、オートコンプリート機能の追加）
private void Form5_Load(object sender, EventArgs e)
{
if (System.Deployment.Application.ApplicationDeployment.IsNetworkDeployed)
{
Version deploy = System.Deployment.Application.ApplicationDeployment.CurrentDeployment.CurrentVersion;
StringBuilder version = new StringBuilder();
version.Append("VERSION: ");
//version.Append(applicationName + "_");
version.Append(deploy.Major);
version.Append("_");
//version.Append(deploy.Minor);
//version.Append("_");
version.Append(deploy.Build);
version.Append("_");
version.Append(deploy.Revision);
Version_lbl.Text = version.ToString();
}
txtPwd.Visible = false;
btnLogIn.Enabled = false;
grChangePass.Visible = false;
string sql = "select DISTINCT qcuser FROM qc_user ORDER BY qcuser";
TfSQL tf = new TfSQL();
tf.getComboBoxData(sql, ref cmbUserName);
tf.getComboBoxData(sql, ref cmbUserC);
string HostName = Dns.GetHostName();
IPHostEntry ip = Dns.GetHostByName(HostName);
foreach (IPAddress ipadd in ip.AddressList)
{
lblIP.Text = lblIP.Text + ipadd.ToString();
}
}
