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