private void frmRegisterUser_Load(object sender, EventArgs e) { IPQC_Motor.TfSQL con = new IPQC_Motor.TfSQL(); string sqldept = "select distinct user_dept_cd from m_user order by user_dept_cd"; con.getComboBoxData(sqldept, ref cmbDept); string sqlPermision = "select distinct user_permision from m_user order by user_permision"; con.getComboBoxData(sqlPermision, ref cmbPermision); }
private void frmFMS_Load(object sender, EventArgs e) { IPQC_Motor.TfSQL con = new IPQC_Motor.TfSQL(); string sqlProcedure = @" select distinct header_procedure from (select header_procedure, user_dept_cd from m_header 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 + "' order by header_procedure"; con.getComboBoxData(sqlProcedure, ref cmbQuiTrinh); string sqlMachine = @" select distinct header_machine from (select header_machine, user_dept_cd from m_header 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 + "' order by header_machine"; con.getComboBoxData(sqlMachine, ref cmbMaSo); callpic(); }
public void getCmb(string sql, ref ComboBox cmb) { IPQC_Motor.TfSQL tf = new IPQC_Motor.TfSQL(); tf.getComboBoxData(sql, ref cmb); }