public void GetRptCollectionByDateAndID(int ID, DateTime date1, DateTime date2) { var q = WorkCmd.GetByIDAndDate(ID, date1, date2); ReportDataSource rs = new ReportDataSource(); List <EmpWorkObj> ls = new List <EmpWorkObj>(); foreach (var item in q) { ls.Add(new EmpWorkObj() { Id = item.Id, empname = item.EmpTable.EmpName, empNo = item.EmpTable.EmpNo, WorkDat = item.WorkDate.Value, start = DateTime.Parse(item.startTime.ToString()), end = DateTime.Parse(item.endtime.ToString()), RealWork = float.Parse(item.RealWorkTimeNo.ToString()), worktime = float.Parse(item.WorkTime.ToString()), defernce = float.Parse(item.DefernceTime.ToString()), TotalDefernce = WorkCmd.GetTotalDefrnc(date1, date2, ID), TotalDays = WorkCmd.GetTotalCountDayWork(date1, date2, item.Id), HoldyDays = WorkCmd.GetTotalCountDayHolady(date1, date2, item.Id), TotalWorkHouer = WorkCmd.GetTotalWorkTime(date1, date2, item.Id), TotalRealWorkHour = WorkCmd.GetTotalRealWork(date1, date2, item.Id), }); } var q1 = HoldyCmd.GetByIDAndDate(ID, date1, date2); ReportDataSource rs1 = new ReportDataSource(); List <HoldyObj> ls1 = new List <HoldyObj>(); foreach (var item in q1) { ls1.Add(new HoldyObj() { HoldyDate = item.HoldyDate.Value, HoldyType = item.HoldType, }); } rs.Name = "DataSet1"; rs1.Name = "DataSet2"; rs.Value = ls; rs1.Value = ls1; ReportFrm frm = new ReportFrm(); frm.reportViewer1.LocalReport.DataSources.Clear(); frm.reportViewer1.LocalReport.DataSources.Add(rs); frm.reportViewer1.LocalReport.DataSources.Add(rs1); frm.reportViewer1.LocalReport.ReportEmbeddedResource = "PcdcrSystem.Report.EmpWorkReoprt.rdlc"; frm.ShowDialog(); }
private void simpleButton1_Click(object sender, EventArgs e) { if (checkBox1.Checked == true && checkBox2.Checked == false) { #region " CheckFillTextBox " if (EmpComboBox.Text == "") { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } if (EmpComboBox.SelectedValue == null) { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } #endregion this.Cursor = Cursors.WaitCursor; HoldyGridView.DataSource = HoldyCmd.GetByEmpID(int.Parse(EmpComboBox.SelectedValue.ToString())); GC.SuppressFinalize(HoldyCmd.GetByEmpID(int.Parse(EmpComboBox.SelectedValue.ToString()))); GC.Collect(); GC.WaitForFullGCComplete(); GC.WaitForPendingFinalizers(); this.Cursor = Cursors.Default; } if (checkBox1.Checked == false && checkBox2.Checked == true) { this.Cursor = Cursors.WaitCursor; HoldyGridView.DataSource = HoldyCmd.GetByDate(FromDateTimePicker.Value.Date, ToDateTimePicker.Value.Date); GC.SuppressFinalize(HoldyCmd.GetByDate(FromDateTimePicker.Value.Date, ToDateTimePicker.Value.Date)); GC.Collect(); GC.WaitForFullGCComplete(); GC.WaitForPendingFinalizers(); this.Cursor = Cursors.Default; } if (checkBox1.Checked == true && checkBox2.Checked == true) { #region " CheckFillTextBox " if (EmpComboBox.Text == "") { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } if (EmpComboBox.SelectedValue == null) { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } #endregion this.Cursor = Cursors.WaitCursor; HoldyGridView.DataSource = HoldyCmd.GetByIDAndDate(int.Parse(EmpComboBox.SelectedValue.ToString()), FromDateTimePicker.Value.Date, ToDateTimePicker.Value.Date); GC.SuppressFinalize(HoldyCmd.GetByIDAndDate(int.Parse(EmpComboBox.SelectedValue.ToString()), FromDateTimePicker.Value.Date, ToDateTimePicker.Value.Date)); GC.Collect(); GC.WaitForFullGCComplete(); GC.WaitForPendingFinalizers(); this.Cursor = Cursors.Default; } }