public void CreateReport()
{
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-GI4R9EJ;Initial Catalog=QUANLYCF1;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from HOADONBANHANG where MONTH(THOIGIAN) = Month(GETDATE()) and day(THOIGIAN) = day(GETDATE()) and year(THOIGIAN) = year(GETDATE())", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
Report1 report = new Report1();
report.DataSouce = dt;
report.ShowPreview();
}
private void barButtonItem13_ItemClick(object sender, ItemClickEventArgs e)
{
if (tabPane1.SelectedPageIndex == 3)
{
if (clientBindingSource1.Current is Client buffer)
{
buffer.Accountings = Gateway.Call(new GetAccountingByOwnerId()
{
Id = buffer.Id
}).Result;
var report = new Report1();
report.objectDataSource1.DataSource = buffer;
report.ShowPreview();
}
}
else
{
XtraMessageBox.Show("Выберете клиента для вывода в отчёт.");
}
}
