public void GetByProjectId(int ProjID) { var q = SalariesCmd.GetSalaryBySelectedprotID(ProjID); ReportDataSource rs = new ReportDataSource(); List<SalaryReportObj> ls = new List<SalaryReportObj>(); int counter = 0; foreach (var item in q) { counter++; ls.Add(new SalaryReportObj() { ProjectName = item.ProjectProfile.ProjectName, SalarysID = counter , EmployeeName = item.Contract.Employee.EmployeeName, SalaryAmount = item.Amount.Value, SalaryIssueDate = item.IssueDate.Value, SalaryForMonth = item.Formonth.Value, coin=item.ProjectProfile.Coin, EmployeejobNumber=item.Contract.Employee.EmployeejobNumber }); } rs.Name = "DataSet1"; rs.Value = ls; frmReportViewer frm = new frmReportViewer(); frm.reportViewer1.LocalReport.DataSources.Clear(); frm.reportViewer1.LocalReport.DataSources.Add(rs); frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptSalaryGroupby.rdlc"; frm.ShowDialog(); }
public void GetByProjectId(int ProjID) { var q = ProjectExpensesCmd.GetAllExpensesByProject(ProjID); ReportDataSource rs = new ReportDataSource(); List<ExpensessReportObj> ls = new List<ExpensessReportObj>(); int counter = 0; foreach (var item in q) { counter++; ls.Add(new ExpensessReportObj() { ProjectName = item.ProjectProfile.ProjectName, ExpensessID = counter , ExpensessName = item.ExpensesName, ExpenssesCost = item.RequiarAmount.Value, DateOfs = item.DateofProcess.Value, Bill_SerialNumber = item.BillNumber, CashingNumber = item.CashingNumber, SubActivityName = item.ProjectSubActivity.SubActivityName, coin=item.ProjectProfile.Coin, SupplierName=item.Supplier.Name }); } rs.Name = "DataSet1"; rs.Value = ls; frmReportViewer frm = new frmReportViewer(); frm.reportViewer1.LocalReport.DataSources.Clear(); frm.reportViewer1.LocalReport.DataSources.Add(rs); frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.RptExpensesss.rdlc"; frm.ShowDialog(); }
public void ShowReport(List<SalaryReportObj> ls) { ReportDataSource rs = new ReportDataSource(); rs.Name = "DataSet1"; rs.Value = ls; frmReportViewer frm = new frmReportViewer(); frm.reportViewer1.LocalReport.DataSources.Clear(); frm.reportViewer1.LocalReport.DataSources.Add(rs); frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptSalaryGroupby.rdlc"; frm.ShowDialog(); }
public void ShowReportByGrid(List<ExpensessReportObj> ls) { ReportDataSource rs = new ReportDataSource(); rs.Name = "DataSet1"; rs.Value = ls; frmReportViewer frm = new frmReportViewer(); frm.reportViewer1.LocalReport.DataSources.Clear(); frm.reportViewer1.LocalReport.DataSources.Add(rs); frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.RptExpensesss.rdlc"; frm.ShowDialog(); }