private void cmbModel_SelectedIndexChanged(object sender, EventArgs e)
{
TfSQL con = new TfSQL();
string sql = "select distinct model_sub_cd from m_model where model_cd = '" + cmbModel.Text + "' order by model_sub_cd";
con.getComboBoxData(sql, ref cmbSubModel);
}
// ロード時の処理（コンボボックスに、オートコンプリート機能の追加）
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();
}
TfSQL con = new TfSQL();
string sql = "select distinct user_name from m_user order by user_name";
con.getComboBoxData(sql, ref cmbUserName);
AcceptButton = btnLogIn;
}
private void frmItem_Load(object sender, EventArgs e)
{
TfSQL con = new TfSQL();
string sql = @"select distinct model_cd from(select model_cd ,user_dept_cd from m_model a,m_user b where a.user_id = b.user_id )t,m_user a
where a.user_dept_cd = t.user_dept_cd and a.user_name = '" + username + "'";
con.getComboBoxData(sql, ref cmbModel);
cmbModel.Text = "";
txtUser.Text = username;
dtInspectItems = new DataTable();
dtpFromDate.Value = DateTime.Now.AddDays(-7);
}
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;
}
private void frmItem_Load(object sender, EventArgs e)
{
TfSQL con = new TfSQL();
string sql = @"
select distinct model_cd from(
select model_cd ,user_dept_cd from m_model a,m_user b where a.user_id = b.user_id )t,m_user a
where a.user_dept_cd = t.user_dept_cd and a.user_name = '" + username + "'";
con.getComboBoxData(sql, ref cmbModel);
cmbModel.Text = "";
txtUser.Text = username;
dtInspectItems = new DataTable();
if (username == "admin")
{
btnEditMaster.Visible = true;
}
}
