private void frmReport_Load(object sender, System.EventArgs e)
{
this.Report.Size = new System.Drawing.Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
this.Size = new System.Drawing.Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
i_nhom = get_nhomkho();
i_soluong_le = ttb.d_soluong_le(i_nhom);
i_dongia_le = ttb.d_dongia_le(i_nhom);
i_thanhtien_le = ttb.d_thanhtien_le(i_nhom);
string dir = System.IO.Directory.GetCurrentDirectory();
ExportPath = "";
int j = 0;
for (int i = 0; i < dir.Length; i++)
{
if (dir.Substring(i, 1) == "\\")
{
j++;
}
if (j == 2)
{
break;
}
ExportPath += dir.Substring(i, 1);
}
ExportPath += "\\pdf\\";
if (!System.IO.Directory.Exists(ExportPath))
{
System.IO.Directory.CreateDirectory(ExportPath);
}
PreviewReport();
}
private void frmThkhoa_Load(object sender, System.EventArgs e)
{
user = ttb.user; stime = "'" + ttb.f_ngay + "'";
i_dongiale = ttb.d_dongia_le(i_nhom);
sql = "select * from " + user + ".d_duockp ";
sql += " where nhom like '%" + i_nhom.ToString() + ",%'";
if (s_makp != "")
{
sql += " and id in (" + s_makp.Substring(0, s_makp.Length - 1) + ")";
}
sql += " order by stt";
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
makp.DataSource = ttb.get_data(sql).Tables[0];
sql = "select a.*,b.stt as sttnhom,b.ten as tennhom,c.ten as tenhang ";
sql += " from " + user + ".ttb_dmbd a," + user + ".ttb_dmnhom b," + user + ".ttb_dmhang c where a.manhom=b.id and a.mahang=c.id and a.nhom=" + i_nhom;
dt = ttb.get_data(sql).Tables[0];
sql = "select * from " + user + ".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.DataSource = dtdmkho;
kho.DisplayMember = "TEN";
kho.ValueMember = "ID";
ds.ReadXml("..\\..\\..\\xml\\ttb_thkhoa.xml");
dsxml.ReadXml("..\\..\\..\\xml\\ttb_thkhoa.xml");
}
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;
}
private void taotable()
{
if (!kiemtra())
{
return;
}
i_dongia = ttb.d_dongia_le(int.Parse(nhom.SelectedValue.ToString()));
ds.Clear();
s_loai = ""; s_phieu = "";
for (int i = 0; i < loai.Items.Count; i++)
{
if (loai.GetItemChecked(i))
{
s_loai += dtloai.Rows[i]["id"].ToString().Trim() + ",";
}
}
for (int i = 0; i < phieu.Items.Count; i++)
{
if (phieu.GetItemChecked(i))
{
s_phieu += dtphieu.Rows[i]["id"].ToString().Trim() + ",";
}
}
dtdmbd = ttb.get_data("select * from " + user + ".ttb_dmbd where nhom=" + int.Parse(nhom.SelectedValue.ToString())).Tables[0];
string cont = " and a.makp=" + int.Parse(makp.SelectedValue.ToString()) + " and a.nhom=" + int.Parse(nhom.SelectedValue.ToString());
cont += " and a.ngay between to_date('" + tu.Text + "'," + stime + ") and to_date('" + den.Text + "'," + stime + ")";
if (s_loai != "")
{
cont += " and a.loai in (" + s_loai.Substring(0, s_loai.Length - 1) + ")";
}
if (s_phieu != "")
{
cont += " and a.phieu in (" + s_phieu.Substring(0, s_phieu.Length - 1) + ")";
}
if (imp.Visible)
{
if (imp.Checked)
{
cont += " and c.manhom in (31,55)";
}
else
{
cont += " and c.manhom not in (31,55)";
}
}
s_makho = ""; s_tenkho = "";
for (int i = 0; i < makho.Items.Count; i++)
{
if (makho.GetItemChecked(i))
{
s_makho += dtkho.Rows[i]["id"].ToString().Trim() + ",";
s_tenkho += dtkho.Rows[i]["ten"].ToString().Trim() + ";";
}
}
if (s_makho == "")
{
for (int i = 0; i < makho.Items.Count; i++)
{
s_makho += dtkho.Rows[i]["id"].ToString().Trim() + ",";
s_tenkho += dtkho.Rows[i]["ten"].ToString().Trim() + ";";
}
}
if (s_makho != "")
{
cont += " and b.makho in (" + s_makho.Substring(0, s_makho.Length - 1) + ")";
}
DateTime dt1 = ttb.StringToDate(tu.Text).AddDays(-ttb.iNgaykiemke);
DateTime dt2 = ttb.StringToDate(den.Text).AddDays(ttb.iNgaykiemke);
int y1 = dt1.Year, m1 = dt1.Month;
int y2 = dt2.Year, m2 = dt2.Month;
int itu, iden;
string mmyy = "";
for (int i = y1; i <= y2; i++)
{
itu = (i == y1)?m1:1;
iden = (i == y2)?m2:12;
for (int j = itu; j <= iden; j++)
{
mmyy = j.ToString().PadLeft(2, '0') + i.ToString().Substring(2, 2);
if (ttb.bMmyy(mmyy))
{
get_xuat(mmyy, cont);
get_hoantra(mmyy, cont);
}
}
}
sort();
}
