private void btnReportKhacPhucPhongNgua_Click(object sender, EventArgs e) { Model.Function.ConnectSanXuat();//Mo ket noi string sqlQuery = string.Format(@"select * from ViewChatLuongHoatDong where LoaiDeNghi like 'NCR' and ID like '{0}'", iD); ReportKhacPhucPhongNgua kppn = new ReportKhacPhucPhongNgua(); kppn.DataSource = Function.GetDataTable(sqlQuery); kppn.DataMember = "Table"; kppn.CreateDocument(false); kppn.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = "NCR-No-" + iD; PrintTool tool = new PrintTool(kppn.PrintingSystem); kppn.ShowPreviewDialog(); Function.Disconnect(); }
private void PrintNCR_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); ketnoi kn = new ketnoi(); dt = kn.laybang(@"select R.*,D.Cai,D.Kg,D.Thongtin,D.ChiPhiDonHang from tblNCR R inner join NcrDatHang D on R.NcrID=D.NcrID where R.NcrID='" + txtNcrID.Text + "'"); ReportKhacPhucPhongNgua xRNcr = new ReportKhacPhucPhongNgua(); xRNcr.DataSource = dt; xRNcr.DataMember = "Table"; xRNcr.CreateDocument(false); xRNcr.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName = txtNcrID.Text; PrintTool tool = new PrintTool(xRNcr.PrintingSystem); xRNcr.ShowPreviewDialog(); kn.dongketnoi(); }