예제 #1
0
        private void btnView_Click(object sender, EventArgs e)
        {
            if (dateTo.DateTime < dateFrom.DateTime)
            {
                MessageBox.Show("Ngày tháng nhập không hợp lệ !.");
                return;
            }
            dtxp.Clear();
            btnExportExcelTemplate.Enabled        = false;
            btnExportExcelTemplateByGroup.Enabled = false;
            Waiting.ShowWaitForm();
            colTimeStr.Visible        = true;
            colTimeIn.Visible         = false;
            colTimeOut.Visible        = false;
            colDepartmentName.Visible = true;
            colGroupName.Visible      = true;
            colDayStr.Visible         = false;
            colDateStr.Visible        = false;
            colIndex.Visible          = false;
            colMachineNumber.Visible  = true;
            Class.ChamCong_CheckInOut cc = new Class.ChamCong_CheckInOut();
            cc.FromDay = dateFrom.DateTime;
            cc.ToDay   = dateTo.DateTime;
            DataTable dt = cc.CHECKINOUT_GetByDate();

            gridItem.DataSource = dt;
            Waiting.CloseWaitForm();
        }
예제 #2
0
 private void btnTongHopXem_Click(object sender, EventArgs e)
 {
     if (dateTHTo.DateTime < dateTHFrom.DateTime)
     {
         MessageBox.Show("Ngày tháng nhập không hợp lệ !.");
         return;
     }
     Waiting.ShowWaitForm();
     Waiting.SetWaitFormDescription("Đang khởi tạo yêu cầu..");
     colIndex.Visible          = true;
     colDayStr.Visible         = true;
     colDateStr.Visible        = true;
     colTimeOut.Visible        = true;
     colTimeIn.Visible         = true;
     colDepartmentName.Visible = true;
     colGroupName.Visible      = true;
     colTimeStr.Visible        = false;
     colMachineNumber.Visible  = false;
     Class.ChamCong_CheckInOut cc = new Class.ChamCong_CheckInOut();
     cc.FromDay      = dateTHFrom.DateTime;
     cc.ToDay        = dateTHTo.DateTime;
     cc.TimeBeginIn  = timeBeginIn.Time;
     cc.TimeEndIn    = timeEndIn.Time;
     cc.TimeBeginOut = timeBeginOut.Time;
     cc.TimeEndOut   = timeEndOut.Time;
     dtxp            = cc.CHECKINOUT_GetByDateAll_Report();
     Waiting.SetWaitFormDescription("Khởi tạo dữ liệu hoàng tất..");
     gridItem.DataSource = dtxp;
     if (dtxp.Rows.Count > 0)
     {
         btnExportExcelTemplate.Enabled        = true;
         btnExportExcelTemplateByGroup.Enabled = true;
     }
     Waiting.CloseWaitForm();
 }
예제 #3
0
        private void btnLoadData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            Waiting.ShowWaitForm();
            Waiting.SetWaitFormDescription("Đang đọc dữ liệu chấm công..");
            Class.S_Log.Insert("Chấm công", "Tải dữ liệu từ máy chấm công về máy tính");
            dtxp.Clear();
            btnExportExcelTemplate.Enabled        = false;
            btnExportExcelTemplateByGroup.Enabled = false;
            //colMachineNumber.Visible = true;
            //colTimeStr.Visible = true;
            //colDepartmentName.Visible = false;
            //colGroupName.Visible = false;
            //colTimeIn.Visible = false;
            //colTimeOut.Visible = false;
            //colDayStr.Visible = false;
            //colDateStr.Visible = false;
            //colIndex.Visible = false;
            //create datatabe
            DataTable dt = new DataTable();

            dt.Columns.Add("InOutCode", Type.GetType("System.String"));
            dt.Columns.Add("MachineNumber", Type.GetType("System.String"));
            dt.Columns.Add("EnrollNumber", Type.GetType("System.String"));
            dt.Columns.Add("VerifyMode", Type.GetType("System.String"));
            dt.Columns.Add("InOutMode", Type.GetType("System.String"));
            dt.Columns.Add("Year", Type.GetType("System.String"));
            dt.Columns.Add("Month", Type.GetType("System.String"));
            dt.Columns.Add("Day", Type.GetType("System.String"));
            dt.Columns.Add("Hour", Type.GetType("System.String"));
            dt.Columns.Add("Minute", Type.GetType("System.String"));
            dt.Columns.Add("Second", Type.GetType("System.String"));
            dt.Columns.Add("TimeStr", Type.GetType("System.DateTime"));

            DataTable dtChange = new DataTable();

            dtChange.Columns.Add("InOutCode", Type.GetType("System.String"));
            dtChange.Columns.Add("MachineNumber", Type.GetType("System.String"));
            dtChange.Columns.Add("EnrollNumber", Type.GetType("System.String"));
            dtChange.Columns.Add("VerifyMode", Type.GetType("System.String"));
            dtChange.Columns.Add("InOutMode", Type.GetType("System.String"));
            dtChange.Columns.Add("Year", Type.GetType("System.String"));
            dtChange.Columns.Add("Month", Type.GetType("System.String"));
            dtChange.Columns.Add("Day", Type.GetType("System.String"));
            dtChange.Columns.Add("Hour", Type.GetType("System.String"));
            dtChange.Columns.Add("Minute", Type.GetType("System.String"));
            dtChange.Columns.Add("Second", Type.GetType("System.String"));
            dtChange.Columns.Add("TimeStr", Type.GetType("System.DateTime"));
            dtChange.Columns.Add("EmployeeCode", Type.GetType("System.String"));
            dtChange.Columns.Add("FirstName", Type.GetType("System.String"));
            dtChange.Columns.Add("LastName", Type.GetType("System.String"));

            #region Goi Du Lieu May Cham Cong
            Waiting.SetWaitFormDescription("Đang tải dữ liệu chấm công..");

            if (bIsConnected)
            {
                if (product == "0")
                {
                    bool ret = axczkem1.ReadAllGLogData(id);
                    Application.DoEvents();
                    if (ret)
                    {
                        int a  = 0;
                        int b  = 0;
                        int c  = 0;
                        int d  = 0;
                        int ee = 0;
                        int f  = 0;
                        int g  = 0;
                        int h  = 0;
                        int ii = 0;
                        int k  = 0;
                        int l  = 0;
                        //sw.Write("MachineNumber,EnrollNumber,VerifyMode,InOutMode,Year,Month,Day,Hour,Minute,Second,,, \r\n");
                        while (axczkem1.GetGeneralExtLogData(id, ref a, ref b, ref c, ref d, ref ee, ref f, ref g, ref h, ref ii, ref k, ref l))
                        {
                            DataRow dr = dt.NewRow();
                            dr[0]  = id + a.ToString() + d.ToString() + ee.ToString() + f.ToString() + g.ToString() + h.ToString() + ii.ToString();
                            dr[1]  = id;
                            dr[2]  = a.ToString();
                            dr[3]  = b.ToString();
                            dr[4]  = c.ToString();
                            dr[5]  = d.ToString();
                            dr[6]  = ee.ToString();
                            dr[7]  = f.ToString();
                            dr[8]  = g.ToString();
                            dr[9]  = h.ToString();
                            dr[10] = ii.ToString();
                            string dateString = ee.ToString() + "/" + f.ToString() + "/" + d.ToString() + " " + g.ToString() + ":" + h.ToString() + ":" + ii.ToString();
                            MessageBox.Show(e.ToString() + "-" + ee.ToString() + "-" + f.ToString() + "-" + g.ToString() + "-" + h.ToString() + "-" + id.ToString());
                            dr[11] = new DateTime(d, ee, f, g, h, ii);
                            //  dr[11] = DateTime.Parse(dateString);
                            dt.Rows.Add(dr);
                            Application.DoEvents();
                        }
                    }
                }
                else if (product == "1")

                {
                    bool ret = axczkem1.ReadGeneralLogData(id);
                    Application.DoEvents();
                    if (ret)
                    {
                        string a  = "";
                        int    b  = 0;
                        int    c  = 0;
                        int    d  = 0;
                        int    ee = 0;
                        int    f  = 0;
                        int    g  = 0;
                        int    h  = 0;
                        int    ii = 0;
                        // int k = 0;
                        int l = 0;
                        //sw.Write("MachineNumber,EnrollNumber,VerifyMode,InOutMode,Year,Month,Day,Hour,Minute,Second,,, \r\n");
                        while (axczkem1.SSR_GetGeneralLogData(id, out a, out b, out c, out d, out ee, out f, out g, out h, out ii, ref l))
                        {
                            DataRow dr = dt.NewRow();
                            dr[0]  = id + a.ToString() + d.ToString() + ee.ToString() + f.ToString() + g.ToString() + h.ToString() + ii.ToString();
                            dr[1]  = id;
                            dr[2]  = a.ToString();
                            dr[3]  = b.ToString();
                            dr[4]  = c.ToString();
                            dr[5]  = d.ToString();
                            dr[6]  = ee.ToString();
                            dr[7]  = f.ToString();
                            dr[8]  = g.ToString();
                            dr[9]  = h.ToString();
                            dr[10] = ii.ToString();
                            //string dateString= ee.ToString()+"/"+f.ToString()+"/"+d.ToString()+" "+g.ToString()+":"+h.ToString()+":"+ii.ToString();
                            //  MessageBox.Show(e.ToString()+"-"+ee.ToString()+"-"+f.ToString()+"-"+g.ToString()+"-"+h.ToString()+"-"+id.ToString());
                            dr[11] = new DateTime(d, ee, f, g, h, ii);
                            // dr[11] = DateTime.Parse(dateString);
                            dt.Rows.Add(dr);
                            Application.DoEvents();
                        }
                    }
                }
            }

            #endregion
            Waiting.SetWaitFormDescription("Đang tải dữ liệu hiện tại..");
            Class.ChamCong_CheckInOut cc = new Class.ChamCong_CheckInOut();
            DataTable      dtcc          = cc.CHECKINOUT_GetList();
            Class.NhanVien nv            = new Class.NhanVien();
            nv.Status = -1;
            DataTable dtnv = nv.LoadDanhSachNhanVien_Ex();
            Waiting.SetWaitFormDescription("Đang so sánh dữ liệu hiện tại..");
            //try
            //{
            //    for (int i = 0; i < dt.Rows.Count; i++)
            //    {
            //        DataRow[] result = dtcc.Select("InOutCode='" + dt.Rows[i]["InOutCode"].ToString() + "'");
            //        if (result.Length < 1)
            //        {
            //            // DataTable dtnv = nv.HRM_EMPLOYEE_GetByEnroll(dt.Rows[i]["EnrollNumber"].ToString()); ko su dung chuc năng nay vi làm hao ton bo nho
            //            DataRow[] result2 = dtnv.Select("EnrollNumber='" + dt.Rows[i]["EnrollNumber"].ToString() + "'");
            //            DataRow dr = dtChange.NewRow();
            //            dr[0] = dt.Rows[i][0];
            //            dr[1] = dt.Rows[i][1];
            //            dr[2] = dt.Rows[i][2];
            //            dr[3] = dt.Rows[i][3];
            //            dr[4] = dt.Rows[i][4];
            //            dr[5] = dt.Rows[i][5];
            //            dr[6] = dt.Rows[i][6];
            //            dr[7] = dt.Rows[i][7];
            //            dr[8] = dt.Rows[i][8];
            //            dr[9] = dt.Rows[i][9];
            //            dr[10] = dt.Rows[i][10];
            //            dr[11] = dt.Rows[i][11];
            //            if (result2.Length > 0)
            //            {
            //                //dr[12] = dtnv.Rows[0]["EmployeeCode"].ToString();
            //                //dr[13] = dtnv.Rows[0]["FirstName"].ToString() + " " + dtnv.Rows[0]["LastName"].ToString();
            //                dr[12] = result2[0]["EmployeeCode"];
            //                dr[13] = result2[0]["FirstName"];
            //                dr[14] = result2[0]["LastName"];
            //            }
            //            else
            //            {
            //                dr[12] = "";
            //                dr[13] = "";
            //                dr[14] = "";
            //            }

            //            dtChange.Rows.Add(dr);
            //        }
            //        Application.DoEvents();

            //    }
            //}
            //catch { }


            try
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    DataRow dr = dtChange.NewRow();
                    dr[0]  = dt.Rows[i][0];
                    dr[1]  = dt.Rows[i][1];
                    dr[2]  = dt.Rows[i][2];
                    dr[3]  = dt.Rows[i][3];
                    dr[4]  = dt.Rows[i][4];
                    dr[5]  = dt.Rows[i][5];
                    dr[6]  = dt.Rows[i][6];
                    dr[7]  = dt.Rows[i][7];
                    dr[8]  = dt.Rows[i][8];
                    dr[9]  = dt.Rows[i][9];
                    dr[10] = dt.Rows[i][10];
                    dr[11] = dt.Rows[i][11];

                    dtChange.Rows.Add(dr);
                }
                Application.DoEvents();
            }

            catch { }


            Waiting.SetWaitFormDescription("Hoàn thành quá trình so sánh..");
            gridItem.DataSource = dtChange;

            if (dtChange.Rows.Count > 0)
            {
                Waiting.SetWaitFormDescription("Thêm dữ liệu mới vào CSDL..");
                cc.Insert(dtChange);
            }

            Waiting.CloseWaitForm();
            MessageBox.Show("Dữ liệu chấm công mới: " + dtChange.Rows.Count + "\n Tổng số record máy chấm công: " + dt.Rows.Count);
        }