private void rptBbkiemke_Load(object sender, System.EventArgs e) { user = ttb.user; i_dongiale = ttb.d_dongia_le(i_nhom); if (bnhom) { label14.Text = "Nhóm :"; } kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; sql = "select * from " + user + ".ttb_dmkho where nhom=" + i_nhom; if (s_kho != "") { sql += " and id in (" + s_kho.Substring(0, s_kho.Length - 1) + ")"; } sql += " order by stt"; kho.DataSource = ttb.get_data(sql).Tables[0]; // //Load_nguon nguon.DisplayMember = "TEN"; nguon.ValueMember = "ID"; sql = "select * from " + user + ".ttb_dmnguon where nhom=" + i_nhom; sql += " order by stt"; nguon.DataSource = ttb.get_data(sql).Tables[0]; nguon.SelectedIndex = -1; // if (!bnhom) { bln_noingoai = ttb.bNoiNgoai_Hang(i_nhom) || ttb.bNoiNgoai_Nuoc(i_nhom); } if (bln_noingoai) { if (ttb.bNoiNgoai_Hang(i_nhom)) { sql = "select a.*, b.stt, b.ten as tennhom, e.loai as idnn, f.ten as noingoai,e.ten as tenhang from " + user + ".ttb_dmbd a, " + user + ".ttb_dmnhom b, " + user + ".ttb_dmhang e, " + user + ".ttb_nhomhang f"; sql += " where a.manhom=b.id and a.mahang=e.id and e.loai=f.id and a.nhom=" + i_nhom + " order by a.id"; } else { sql = "select a.*, b.stt, b.ten as tennhom, e.loai as idnn, f.ten as noingoai,e.ten as tenhang from " + user + ".ttb_dmbd a, " + user + ".ttb_dmnhom b, " + user + ".ttb_dmnuoc e, " + user + ".ttb_nhomnuoc f"; sql += " where a.manhom=b.id and a.manuoc=e.id and e.loai=f.id and a.nhom=" + i_nhom + " order by a.id"; } } else { sql = "select a.*, b.stt, b.ten as tennhom, a.maloai as idnn, f.ten as noingoai from " + user + ".ttb_dmbd a, " + user + ".ttb_dmnhom b, " + user + ".ttb_dmhang e, " + user + ".ttb_dmloai f"; sql += " where a.manhom=b.id and a.mahang=e.id and a.maloai=f.id and a.nhom=" + i_nhom + " order by a.id"; } dt = ttb.get_data(sql).Tables[0]; // dtnhom = ttb.get_data("select * from " + user + ".ttb_dmnhom where nhom=" + i_nhom + " order by id").Tables[0]; ds.ReadXml("..\\..\\..\\xml\\ttb_Bbkiemke.xml"); dsrpt.ReadXml("..\\..\\..\\xml\\ttb_Bbkiemke.xml"); ttb.ins_thongso(i_nhom, 601, 616); foreach (DataRow r in ttb.get_data("select * from " + user + ".ttb_thongso where id between 601 and 616 and nhom=" + i_nhom).Tables[0].Rows) { switch (int.Parse(r["id"].ToString())) { case 601: c1.Text = r["ten"].ToString().Trim(); break; case 602: c2.Text = r["ten"].ToString().Trim(); break; case 603: c3.Text = r["ten"].ToString().Trim(); break; case 604: c4.Text = r["ten"].ToString().Trim(); break; case 605: c5.Text = r["ten"].ToString().Trim(); break; case 606: c6.Text = r["ten"].ToString().Trim(); break; case 607: c7.Text = r["ten"].ToString().Trim(); break; case 608: c8.Text = r["ten"].ToString().Trim(); break; case 609: c11.Text = r["ten"].ToString().Trim(); break; case 610: c12.Text = r["ten"].ToString().Trim(); break; case 611: c13.Text = r["ten"].ToString().Trim(); break; case 612: c14.Text = r["ten"].ToString().Trim(); break; case 613: c15.Text = r["ten"].ToString().Trim(); break; case 614: c16.Text = r["ten"].ToString().Trim(); break; case 615: c17.Text = r["ten"].ToString().Trim(); break; case 616: c18.Text = r["ten"].ToString().Trim(); break; } } noingoai.DisplayMember = "TEN"; noingoai.ValueMember = "ID"; if (bln_noingoai) { if (ttb.bNoiNgoai_Hang(i_nhom)) { noingoai.DataSource = ttb.get_data("select * from " + user + ".ttb_nhomhang where nhom=" + i_nhom + " order by stt").Tables[0]; } else { noingoai.DataSource = ttb.get_data("select * from " + user + ".ttb_nhomnuoc where nhom=" + i_nhom + " order by stt").Tables[0]; } } else if (bnhom) { noingoai.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnhom where nhom=" + i_nhom + " order by stt").Tables[0]; } else { noingoai.DataSource = ttb.get_data("select * from " + user + ".ttb_dmloai where nhom=" + i_nhom + " order by stt").Tables[0]; } noingoai.SelectedIndex = -1; }