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