Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
 }