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;
}
}
