private void butIn_Click(object sender, System.EventArgs e)
{
s_mmyy = mm.Value.ToString().PadLeft(2, '0') + yyyy.Value.ToString().PadLeft(4, '0').Substring(2, 2);
ds.Clear();
Loc();
ds.Merge(ttb.get_tondau(ds, dt, s_mmyy, -1, (manguon.SelectedIndex == -1)?-1:int.Parse(manguon.SelectedValue.ToString()), i_nhom));
ds.Merge(ttb.get_nhap(ds, dt, dtkp, tmpkho, s_mmyy.Substring(0, 2), s_mmyy.Substring(0, 2), s_mmyy.Substring(2, 2), -1, (manguon.SelectedIndex == -1)?-1:int.Parse(manguon.SelectedValue.ToString()), i_nhom));
ds.Merge(ttb.get_xuat(ds, dt, dtkp, dtloaint, dtkhac, tmpkho, s_mmyy.Substring(0, 2), s_mmyy.Substring(0, 2), s_mmyy.Substring(2, 2), -1, (manguon.SelectedIndex == -1)?-1:int.Parse(manguon.SelectedValue.ToString()), i_nhom));
get_sort();
if (dsxml.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Không có số liệu !", ttb.Msg);
return;
}
frmReport f = new frmReport(ttb, dsxml.Tables[0], "d_sochitiet.rpt", ttb.Thongso("ttb_thongso", "kho"), "Tháng " + mm.Value.ToString().PadLeft(2, '0') + " năm " + yyyy.Value.ToString(), (manguon.SelectedIndex == -1)?"":manguon.Text, "", "", "", "", "", "", "");
f.ShowDialog();
}
private void rptBctheonhom_Load(object sender, System.EventArgs e)
{
ds.ReadXml("..\\..\\..\\xml\\ttb_bctheoloai.xml");
dsxml.ReadXml("..\\..\\..\\xml\\ttb_bctheoloai.xml");
dtdmnhom = ttb.get_data("select * from ttb_dmnhom where stt<>0 and nhom=" + i_nhom + " order by stt").Tables[0];
manguon.DisplayMember = "TEN";
manguon.ValueMember = "ID";
if (ttb.bQuanlynguon(i_nhom))
{
manguon.DataSource = ttb.get_data("select * from ttb_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0];
}
else
{
manguon.DataSource = ttb.get_data("select * from ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0];
}
nhomcc.DisplayMember = "TEN";
nhomcc.ValueMember = "ID";
if (ttb.bQuanlynhomcc(i_nhom))
{
nhomcc.DataSource = ttb.get_data("select * from ttb_nhomcc where nhom=" + i_nhom + " order by stt").Tables[0];
}
else
{
nhomcc.DataSource = ttb.get_data("select * from ttb_nhomcc where id=0 or nhom=" + i_nhom + " order by stt").Tables[0];
}
dt = ttb.get_data("select a.*,b.ten tennhom from ttb_dmbd a,ttb_dmnhom b where a.manhom=b.id and a.nhom=" + i_nhom + " order by a.id").Tables[0];
sql = "select * from ttb_dmkho where nhom=" + i_nhom;
if (s_makho != "")
{
sql += " and id in (" + s_makho.Substring(0, s_makho.Length - 1) + ")";
}
sql += " order by stt";
dtdmkho = ttb.get_data(sql).Tables[0];
kho.DisplayMember = "TEN";
kho.ValueMember = "ID";
kho.DataSource = dtdmkho;
manhom.DisplayMember = "TEN";
manhom.ValueMember = "ID";
manhom.DataSource = dtdmnhom;
s_manhom = ttb.Thongso("manhom").Trim();
}
