private void btnPrint_Click(object sender, EventArgs e) { List <CHITIETDONHANG> lstCTDH = dhDAO.GetCTDH(dh.ID); List <THONGTINCHITIETDH2> lstTTCT = new List <THONGTINCHITIETDH2>(); foreach (CHITIETDONHANG c in lstCTDH) { THONGTINCHITIETDH2 t2 = new THONGTINCHITIETDH2(); SANPHAM s = new SanphamDAO().getSanphamById(c.SANPHAM_ID); THONGTINCHITIETDH t = new THONGTINCHITIETDH(c, s); t2.ID = t.ID; t2.KHOILUONG = t.KHOILUONG; t2.SOLUONG = t.SOLUONG; t2.DONGIA = String.Format("{0:0,0}", t.DONGIA); t2.THANHTIEN = String.Format("{0:0,0}", t.THANHTIEN); t2.TEN = new LoaiSpDAO().getLOAISPById(t.LOAISP).TEN; lstTTCT.Add(t2); } //FormPrint formPrint = new FormPrint(lstTTCT, dh); //formPrint.ShowDialog(); string dir = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName; string template = dir + @"\Template\DonHang.docx"; DataTable dt = new DataTable(); dt.Columns.Add("ngay"); dt.Columns.Add("thang"); dt.Columns.Add("nam"); dt.Columns.Add("NGUOINHAN"); dt.Columns.Add("SDT"); dt.Columns.Add("DIACHI"); dt.Columns.Add("NGAYDAT"); dt.Columns.Add("TONGTIEN"); dt.Rows.Add(new Object[] { DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year, dh.TENNGUOINHAN, dh.SDT, dh.DIACHI, String.Format("{0:dd-MM-yyyy}", dh.NGAYDAT), String.Format("{0:0,0}", dh.TONGTIEN) }); dt.TableName = "donhang"; DataTable dt2 = new ConnectAPI().ConvertToDataTable <THONGTINCHITIETDH2>(lstTTCT); dt2.TableName = "chitiet"; DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.Tables.Add(dt2); Aspose.Words.Document doc = new Aspose.Words.Document(template); doc.MailMerge.ExecuteWithRegions(ds); string filePath = dir + String.Format("/DonHang_{0}_{1}.pdf", dh.TENNGUOINHAN, DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year); doc.Save(filePath, Aspose.Words.SaveFormat.Pdf); Process.Start(filePath); }
private void Hienthi() { int idDh = (int)grViewDH.GetFocusedRowCellValue("ID"); dh = dhDAO.GetDHById(idDh); List <CHITIETDONHANG> lstCTDH = dhDAO.GetCTDH(dh.ID); List <THONGTINCHITIETDH> lstTTCT = new List <THONGTINCHITIETDH>(); foreach (CHITIETDONHANG c in lstCTDH) { SANPHAM s = new SanphamDAO().getSanphamById(c.SANPHAM_ID); THONGTINCHITIETDH t = new THONGTINCHITIETDH(c, s); lstTTCT.Add(t); } grCtrlCTDH.DataSource = lstTTCT; txtNgaydat.Text = ((DateTime)dh.NGAYDAT).ToShortDateString(); txtKH.Text = dhDAO.GetTenKH(dh.ID); txtDC.Text = dh.DIACHI; txtNguoinhan.Text = dh.TENNGUOINHAN; txtSDT.Text = dh.SDT; txtTong.Text = dh.TONGTIEN.ToString(); txtTrangthai.Text = dhDAO.GetTTbyId(dh.TRANGTHAI_ID).TEN; }