private void frmTtkcb_Load(object sender, System.EventArgs e) { user = m.user; s_thetrongtinh = d.thetrongtinh(m.nhom_duoc); s_thetunguyen = d.thetunguyen(m.nhom_duoc); if (s_thetunguyen != "") { s_tunguyen = s_thetunguyen.Replace(",", "','"); } string vitri = d.thetunguyen_vitri_ora(m.nhom_duoc); if (vitri != "") { v1 = int.Parse(vitri.Substring(0, 1)); v2 = int.Parse(vitri.Substring(2, 1)); } dtnhom = d.get_data("select distinct stt from " + user + ".v_nhombhyt order by stt").Tables[0]; madoituong.DataSource = m.get_data("select a.*,to_char(madoituong) as madoituong1 from " + user + ".doituong a where sothe<>0 order by madoituong").Tables[0]; madoituong.DisplayMember = "DOITUONG"; madoituong.ValueMember = "MADOITUONG"; sql = "select * from " + user + ".btdkp_bv"; if (s_makp != "") { string s = s_makp.Replace(",", "','"); sql += " where makp in ('" + s.Substring(0, s.Length - 3) + "')"; } sql += " order by loai,makp"; dtkp = m.get_data(sql).Tables[0]; makp.DataSource = dtkp; makp.DisplayMember = "TENKP"; makp.ValueMember = "MAKP"; taotable(); loaidt.SelectedIndex = 0; }
private void frmTtkcbngtr_Load(object sender, System.EventArgs e) { user = m.user; i_nhom = m.nhom_duoc; s_thetrongtinh = d.thetrongtinh(i_nhom); s_thetunguyen = d.thetunguyen(i_nhom); if (s_thetunguyen != "") { s_tunguyen = s_thetunguyen.Replace(",", "','"); } string vitri = d.thetunguyen_vitri_ora(i_nhom); if (vitri != "") { v1 = int.Parse(vitri.Substring(0, 1)); v2 = int.Parse(vitri.Substring(2, 1)); } dtnhom = d.get_data("select distinct stt from " + user + ".v_nhombhyt order by stt").Tables[0]; madoituong.DataSource = d.get_data("select a.*,to_char(madoituong) as madoituong1 from " + user + ".doituong a where sothe<>0 order by madoituong").Tables[0]; madoituong.DisplayMember = "DOITUONG"; madoituong.ValueMember = "MADOITUONG"; taotable(); loaidt.SelectedIndex = 0; }