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