Exemplo n.º 1
0
        public void GetRptCollectionByDateAndID(DateTime date1, DateTime date2)
        {
            var q = EmpCmd.GetAll();
            ReportDataSource rs = new ReportDataSource();
            List <MonthyObj> ls = new List <MonthyObj>();

            foreach (var item in q)
            {
                ls.Add(new MonthyObj()
                {
                    id           = item.Id,
                    EmpName      = item.EmpName,
                    empNo        = item.EmpNo,
                    TotalDays    = WorkCmd.GetTotalCountDayWork(date1, date2, item.Id),
                    HoldyDays    = WorkCmd.GetTotalCountDayHolady(date1, date2, item.Id),
                    WorkHouer    = WorkCmd.GetTotalWorkTime(date1, date2, item.Id),
                    RealWorkHour = WorkCmd.GetTotalRealWork(date1, date2, item.Id),
                    Defernce     = WorkCmd.GetTotalDefrncMonth(date1, date2, item.Id),
                });
            }

            rs.Name  = "DataSet1";
            rs.Value = ls;
            ReportFrm frm = new ReportFrm();

            frm.reportViewer1.LocalReport.DataSources.Clear();
            frm.reportViewer1.LocalReport.DataSources.Add(rs);
            frm.reportViewer1.LocalReport.ReportEmbeddedResource = "PcdcrSystem.Report.MonthlyReport.rdlc";

            frm.ShowDialog();
        }
Exemplo n.º 2
0
        public void GetAllEmployee()
        {
            var q = EmpCmd.GetAll();
            ReportDataSource rs = new ReportDataSource();
            List <EmpObj>    ls = new List <EmpObj>();
            int counter         = 0;

            foreach (var item in q)
            {
                counter++;
                ls.Add(new EmpObj()
                {
                    id       = counter,
                    empname  = item.EmpName,
                    empNo    = item.EmpNo,
                    start    = DateTime.Parse(item.StartTime.ToString()),
                    end      = DateTime.Parse(item.EndTime.ToString()),
                    worktime = float.Parse(item.WorkTimeNo.ToString()),
                });
            }
            rs.Name  = "DataSet1";
            rs.Value = ls;
            ReportFrm frm = new ReportFrm();

            frm.reportViewer1.LocalReport.DataSources.Clear();
            frm.reportViewer1.LocalReport.DataSources.Add(rs);
            frm.reportViewer1.LocalReport.ReportEmbeddedResource = "PcdcrSystem.Report.EmpReport.rdlc";
            frm.ShowDialog();
        }
Exemplo n.º 3
0
        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();
        }