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