private void frmPhieuxuat_ng_Load(object sender, System.EventArgs e) { user = d.user; stime = "'" + d.f_ngay + "'"; i_dongiale = d.d_dongia_le(i_nhom); sql = "select * from " + user + ".d_duockp "; sql += " where nhom like '%" + i_nhom.ToString() + ",%'"; if (s_makp != "") { string s = s_makp.Replace(",", "','"); sql += " and makp in ('" + s.Substring(0, s.Length - 3) + "')"; } sql += " order by stt"; dtkp = d.get_data(sql).Tables[0]; makp.DataSource = dtkp; makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; sql = "select * from " + user + ".d_dmloaint where nhom=" + i_nhom; if (s_loaint != "") { sql += " and id in (" + s_loaint.Substring(0, s_loaint.Length - 1) + ")"; } sql += " order by stt"; dtloai = d.get_data(sql).Tables[0]; loai.DataSource = dtloai; loai.DisplayMember = "TEN"; loai.ValueMember = "ID"; sql = "select a.*,b.stt as sttnhom,b.ten as tennhom,c.ten as tenhang "; sql += " from " + user + ".d_dmbd a," + user + ".d_dmnhom b," + user + ".d_dmhang c where a.manhom=b.id and a.mahang=c.id and a.nhom=" + i_nhom; dt = d.get_data(sql).Tables[0]; s_makho = d.get_dmkho(7).Trim(); s_makho = (s_makho == "") ? "" : s_makho.Substring(0, s_makho.Length - 1); sql = "select * from " + user + ".d_dmkho where hide=0 and nhom=" + i_nhom; if (s_makho != "") { sql += " and id in (" + s_makho + ")"; } sql += " order by stt"; dtdmkho = d.get_data(sql).Tables[0]; kho.DataSource = dtdmkho; kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; ds.ReadXml("..//..//..//xml//d_thkhoa.xml"); dsxml.ReadXml("..//..//..//xml//d_thkhoa.xml"); }