private void PreviewReport()
{
string s_error = "";
try
{
oRpt = new ReportDocument();
if (Directory.Exists("..\\..\\..\\" + s_dirreport) == false)
{
s_dirreport = "report";
}
oRpt.Load("..\\..\\..\\" + s_dirreport + "\\" + ReportFile, OpenReportMethod.OpenReportByTempCopy);
if (dt != null)
{
oRpt.SetDataSource(dt);
}
else if (ds != null)
{
oRpt.SetDataSource(ds);
}
else
{
return;
}
s_error = "soyte";
oRpt.DataDefinition.FormulaFields["soyte"].Text = "'" + ttb.Syte + "'";
s_error = "benhvien";
oRpt.DataDefinition.FormulaFields["benhvien"].Text = "'" + ttb.Tenbv + "'";
s_error = "c1";
oRpt.DataDefinition.FormulaFields["c1"].Text = "'" + c1 + "'";
s_error = "c2";
oRpt.DataDefinition.FormulaFields["c2"].Text = "'" + c2 + "'";
s_error = "c3";
oRpt.DataDefinition.FormulaFields["c3"].Text = "'" + c3 + "'";
s_error = "c4";
oRpt.DataDefinition.FormulaFields["c4"].Text = "'" + c4 + "'";
s_error = "c5";
oRpt.DataDefinition.FormulaFields["c5"].Text = "'" + c5 + "'";
s_error = "c6";
oRpt.DataDefinition.FormulaFields["c6"].Text = "'" + c6 + "'";
s_error = "c7";
oRpt.DataDefinition.FormulaFields["c7"].Text = "'" + c7 + "'";
s_error = "c8";
oRpt.DataDefinition.FormulaFields["c8"].Text = "'" + c8 + "'";
s_error = "c9";
oRpt.DataDefinition.FormulaFields["c9"].Text = "'" + c9 + "'";
s_error = "c10";
oRpt.DataDefinition.FormulaFields["c10"].Text = "'" + c10 + "'";
s_error = "giamdoc";
oRpt.DataDefinition.FormulaFields["giamdoc"].Text = "'" + ttb.Giamdoc(-2) + "'";
s_error = "phutrach";
oRpt.DataDefinition.FormulaFields["phutrach"].Text = "'" + ttb.Phutrach(i_nhom) + "'";
s_error = "thongke";
oRpt.DataDefinition.FormulaFields["thongke"].Text = "'" + ttb.Thongke(i_nhom) + "'";
s_error = "ketoan";
oRpt.DataDefinition.FormulaFields["ketoan"].Text = "'" + ttb.Ketoan(i_nhom) + "'";
s_error = "thukho";
oRpt.DataDefinition.FormulaFields["thukho"].Text = "'" + ttb.Thukho(i_nhom) + "'";
s_error = "l_soluong";
oRpt.DataDefinition.FormulaFields["l_soluong"].Text = i_soluong_le.ToString();
s_error = "l_dongia";
oRpt.DataDefinition.FormulaFields["l_dongia"].Text = i_dongia_le.ToString();
s_error = "l_thanhtien";
oRpt.DataDefinition.FormulaFields["l_thanhtien"].Text = i_thanhtien_le.ToString();
Report.ReportSource = oRpt;
}
catch (Exception e)
{
MessageBox.Show(((s_error.Trim() == "")?"Thiếu fomular: " + s_error:"") + "\n The following error was discovered: '" + e.Message + "'. It was occured in '" + e.StackTrace + "'", "Report Viewer", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butIn_Click(object sender, System.EventArgs e)
{
if (dsct.Tables[0].Rows.Count == 0 || dsll.Tables[0].Rows.Count == 0)
{
return;
}
sql = "select * from ttb_phieuxuat where to_char(ngay,'dd/mm/yyyy')='" + s_ngay + "' and nhom=" + i_nhom;
if (i_makp != 0)
{
sql += " and makp=" + i_makp;
}
sql += " and kho='" + i_makho.ToString() + "'";
sql += " and loai='" + dsphieu.Tables[0].Rows[phieu.SelectedIndex]["stt"].ToString() + "'";
if (ttb.get_data(sql).Tables[0].Rows.Count == 0) //s_mmyy
{
MessageBox.Show("Chưa cập nhật không thể in !", ttb.Msg);
return;
}
int i_row = dataGrid1.CurrentCell.RowNumber;
string tenfile = "d_phieuxuat.rpt", slydo = dsphieu.Tables[0].Rows[phieu.SelectedIndex]["lydo"].ToString();
if (dataGrid1[i_row, 5].ToString().Trim().Length > 0)
{
slydo += " (Số phiếu lĩnh : " + dataGrid1[i_row, 5].ToString().Trim() + ")";
}
decimal d_tongcong = tongcong(dsct.Tables[0]);
if (ttb.bPreview)
{
frmReport f = new frmReport(ttb, dsct.Tables[0], tenfile, dataGrid1[i_row, 1].ToString(), dataGrid1[i_row, 2].ToString(), dataGrid1[i_row, 3].ToString(), dataGrid1[i_row, 4].ToString(), s_tenkp, slydo, s_tenkho, doiso.Doiso_Unicode(Convert.ToInt64(d_tongcong).ToString()), "", "");
f.ShowDialog();
}
else
{
ReportDocument oRpt = new ReportDocument();
oRpt.Load("..\\..\\..\\report\\" + tenfile, OpenReportMethod.OpenReportByTempCopy);
oRpt.SetDataSource(dsct.Tables[0]);
oRpt.DataDefinition.FormulaFields["soyte"].Text = "'" + ttb.Syte + "'";
oRpt.DataDefinition.FormulaFields["benhvien"].Text = "'" + ttb.Tenbv + "'";
oRpt.DataDefinition.FormulaFields["c1"].Text = "'" + dataGrid1[i_row, 1].ToString() + "'";
oRpt.DataDefinition.FormulaFields["c2"].Text = "'" + dataGrid1[i_row, 2].ToString() + "'";
oRpt.DataDefinition.FormulaFields["c3"].Text = "'" + dataGrid1[i_row, 3].ToString() + "'";
oRpt.DataDefinition.FormulaFields["c4"].Text = "'" + dataGrid1[i_row, 4].ToString() + "'";
oRpt.DataDefinition.FormulaFields["c5"].Text = "'" + s_tenkp + "'";
oRpt.DataDefinition.FormulaFields["c6"].Text = "'" + slydo + "'";
oRpt.DataDefinition.FormulaFields["c7"].Text = "'" + s_tenkho + "'";
oRpt.DataDefinition.FormulaFields["c8"].Text = "'" + doiso.Doiso_Unicode(Convert.ToInt64(d_tongcong).ToString()) + "'";
oRpt.DataDefinition.FormulaFields["c9"].Text = "";
oRpt.DataDefinition.FormulaFields["c10"].Text = "";
oRpt.DataDefinition.FormulaFields["giamdoc"].Text = "'" + ttb.Giamdoc(i_nhom) + "'";
oRpt.DataDefinition.FormulaFields["phutrach"].Text = "'" + ttb.Phutrach(i_nhom) + "'";
oRpt.DataDefinition.FormulaFields["thongke"].Text = "'" + ttb.Thongke(i_nhom) + "'";
oRpt.DataDefinition.FormulaFields["ketoan"].Text = "'" + ttb.Ketoan(i_nhom) + "'";
oRpt.DataDefinition.FormulaFields["thukho"].Text = "'" + ttb.Thukho(i_nhom) + "'";
//oRpt.PrintOptions.PaperSize=PaperSize.PaperA4;
oRpt.PrintOptions.PaperSize = PaperSize.DefaultPaperSize;
oRpt.PrintOptions.PaperOrientation = PaperOrientation.Portrait;
oRpt.PrintToPrinter(1, false, 0, 0);
oRpt.Close(); oRpt.Dispose();
}
}
