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(); }
public frmSignalHistory(string mac, int t) { InitializeComponent(); Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải lịch sử Modem .!"); LoadList(mac, 0); Waiting.CloseWaitForm(); }
private void btnAddHD_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang khởi tạo hợp đồng mới.."); frmDanhSachHopDong_Season_Update frm = new frmDanhSachHopDong_Season_Update(true, "Thêm Hợp Đồng Thời vụ", "HĐ", null, "frmDanhSachHopDong"); frm.Owner = this; Waiting.CloseWaitForm(); frm.ShowDialog(); }
private void btnLoadAll_Click(object sender, EventArgs e) { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải lịch sử Card.!"); Class.SolarWinds_Get clssl = new Class.SolarWinds_Get(); DataTable dt = clssl.NW_InterfaceLog_GetList(); gridItem.DataSource = dt; Waiting.CloseWaitForm(); }
public frmSignalChart(string mac, int t) { InitializeComponent(); Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải biểu đồ .!"); LoadChart(mac, t); this.Text = "Chart For Device " + mac; Waiting.CloseWaitForm(); Mac = mac; }
private void btnDanhMucChuongTrinh_ItemClick(object sender, ItemClickEventArgs e) { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang khởi tạo danh mục.."); if (!Class.App.IsFocusForm(typeof(frmDanhmuc_Form), this)) { Class.S_Log.Insert("Danh mục", "Xem Danh mục chương trình"); frmDanhmuc_Form frm = new frmDanhmuc_Form(); frm.MdiParent = this; frm.Show(); } Waiting.CloseWaitForm(); }
private void btnDanhSachNhanVien_ItemClick(object sender, ItemClickEventArgs e) { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải danh sách nhân viên.."); if (!Class.App.IsFocusForm(typeof(frmDanhSachNhanVien), this)) { Class.S_Log.Insert("Nhân viên", "Xem Danh sách nhân viên"); frmDanhSachNhanVien frm = new frmDanhSachNhanVien(); frm.MdiParent = this; frm.Show(); } Waiting.CloseWaitForm(); }
private void btnQuanLyHopDong_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải danh sách hợp đồng.."); if (!Class.App.IsFocusForm(typeof(FrmDanhSach_HopDong), this)) { Class.S_Log.Insert("Hợp đồng", "Xem Danh sách hợp đồng"); FrmDanhSach_HopDong frm = new FrmDanhSach_HopDong(); frm.MdiParent = this; frm.Show(); } Waiting.CloseWaitForm(); }
private void btnQuaTrinhLamViec_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải quá trình làm việc.."); if (!Class.App.IsFocusForm(typeof(frmQuaTrinh_LamViec), this)) { Class.S_Log.Insert("Quá trình làm việc", "Xem "); frmQuaTrinh_LamViec frm = new frmQuaTrinh_LamViec(); frm.MdiParent = this; frm.Show(); } Waiting.CloseWaitForm(); }
private void btnCountIP_Click(object sender, EventArgs e) { Waiting.ShowWaitForm(); DataRow[] rows; for (int i = 0; i < dt.Rows.Count; i++) { Waiting.SetWaitFormDescription("Dòng " + (i + 1).ToString()); Application.DoEvents(); rows = dt.Select("IpAddress='" + dt.Rows[i]["IpAddress"].ToString() + "'"); // rows = dt.Select("MacAddress='" + dt.Rows[i]["MacAddress"].ToString() + "'"); dt.Rows[i]["Note"] = rows.Length; } Waiting.CloseWaitForm(); }
private void btnCallDanhSachNhom_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e) { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang khởi tạo danh sách nhóm"); if (!Class.App.IsFocusForm(typeof(frmDanhSachNhom), this)) { Class.S_Log.Insert("Danh mục", "Xem Danh mục chương trình"); frmDanhSachNhom frm = new frmDanhSachNhom(); frm.TopLevel = false; frm.Dock = System.Windows.Forms.DockStyle.Fill; pControls.Controls.Add(frm); frm.Show(); } Waiting.CloseWaitForm(); }
private void btnConnect_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang kết nối đến CMTS"); Class.CMTS cmts = new Class.CMTS(); cmts.Connect(Class.CMTS.CMTS_Host); if (Class.CMTS.tcpClient.Connected) { btnConnect.Enabled = false; } Waiting.CloseWaitForm(); } catch { } }
private void btnConnect_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (cboDeivice.EditValue != null) { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang kết nối thiết bị"); try { Class.DanhMuc_ThietBiChamCong dm = new Class.DanhMuc_ThietBiChamCong(); DataTable dt = dm.GetMachineByCode(cboDeivice.EditValue.ToString()); id = int.Parse(dt.Rows[0]["MachineCode"].ToString()); ip = dt.Rows[0]["IP"].ToString(); port = int.Parse(dt.Rows[0]["PortID"].ToString()); string MachineName = dt.Rows[0]["MachineName"].ToString(); if (MachineName.IndexOf("TFT") > 0) { product = "1"; } else { product = "0"; } bIsConnected = axczkem1.Connect_Net(ip, port); if (bIsConnected) { btnConnect.Enabled = false; btnDisconnect.Enabled = true; btnLoadData.Enabled = true; cboDeivice.Enabled = false; lblStatus.Text = "<image=State_Validation_Valid_48x48.png> Đang kết nối"; } Class.S_Log.Insert("Chấm công", "Kết nối thiết bị chấm công"); } catch { } Waiting.CloseWaitForm(); } else { MessageBox.Show("Bạn chưa chọn thết bị"); } }
private void btnEdit_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!btnEdit.Enabled) { return; } int SelectedRow = gridItemDetail.FocusedRowHandle; if (SelectedRow >= 0) { DataRow drow = gridItemDetail.GetDataRow(SelectedRow); string _value = drow["ContractCode"].ToString(); Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải thông tin hợp đồng.."); frmDanhSachHopDong_Season_Update frm = new frmDanhSachHopDong_Season_Update(false, "Cập nhật Hợp Đồng Lao Động", "HĐ", _value, "frmDanhSachHopDong"); frm.Owner = this; Waiting.CloseWaitForm(); frm.ShowDialog(); } }
private void btnPrint_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int SelectedRow = gridItemDetail.FocusedRowHandle; if (SelectedRow >= 0) { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải trang in hợp đồng thời vụ"); DataRow drow = gridItemDetail.GetDataRow(SelectedRow); string _value = drow["ContractCode"].ToString(); Class.NhanVien_HopDong_ThoiVu hd = new Class.NhanVien_HopDong_ThoiVu(); hd.ContractCode = _value; DataTable dt = hd.HRM_CONTRACT_SEASON_GetPrintByCode(); // Reports.reportHopDongThoiVu rp = new Reports.reportHopDongThoiVu(); // rp.DataSource = dt; // rp.ShowDesigner(); // rp.ShowPreview(); Waiting.CloseWaitForm(); } }
private void btnImport_Click(object sender, EventArgs e) { if (dt.Rows.Count > 0) { Waiting.ShowWaitForm(); Class.NW_Dhcp_Customer cls = new Class.NW_Dhcp_Customer(); string fail = ""; for (int i = 0; i < dt.Rows.Count; i++) { Application.DoEvents(); Waiting.SetWaitFormDescription("Đang lưu ...(" + (i + 1).ToString() + ")"); cls.IpAddress = dt.Rows[i]["IpAddress"].ToString(); cls.MacAddress = dt.Rows[i]["MacAddress"].ToString(); cls.MacAddress_CMTS = dt.Rows[i]["MacAddress_CMTS"].ToString(); cls.CustomerCode = dt.Rows[i]["CustomerCode"].ToString(); cls.CustomerName = dt.Rows[i]["CustomerName"].ToString(); cls.CustomerAddress = dt.Rows[i]["CustomerAddress"].ToString(); cls.PoolIp = dt.Rows[i]["PoolIp"].ToString(); cls.Bootfile = dt.Rows[i]["Bootfile"].ToString(); cls.IpPublic = dt.Rows[i]["IpPublic"].ToString(); cls.MacPc = dt.Rows[i]["MacPc"].ToString(); cls.PoolPublic = dt.Rows[i]["PoolPublic"].ToString(); cls.Location = dt.Rows[i]["Location"].ToString(); cls.Note = dt.Rows[i]["Note"].ToString(); //if (cls.IpAddress == "192.168.11.63") //{ // string degug = ""; //} if (!cls.InsertMySQL()) // thay the import vao dl binh thuong thi impoort vao Mysql server co DHCP SV { fail += "\r\n" + dt.Rows[i]["IpAddress"].ToString(); } } Waiting.CloseWaitForm(); //MessageBox.Show("Hoàn thành Insert !"); //MessageBox.Show(fail); } }
private void checkEdit1_CheckedChanged(object sender, EventArgs e) { dateChoose.Enabled = false; Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải tất cả"); chartUSSnr.Series.Clear(); chartRemote.Series.Clear(); Series Dssnr = new Series("DSSNR \r\n " + Mac, ViewType.Line); Series UsTx = new Series("USTX \r\n " + Mac, ViewType.Line); Series DsRx = new Series("DSRX \r\n " + Mac, ViewType.Line); Series UsSnr = new Series("USSNR \r\n " + Mac, ViewType.StepArea); Series UsNoise = new Series("", ViewType.StepArea); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Status"].ToString() == "online") { if (dt.Rows[i]["value1"].ToString() != "0" && dt.Rows[i]["value2"].ToString() != "0") { Dssnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value1"].ToString())); UsTx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value2"].ToString())); DsRx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value3"].ToString())); } } else { if (checkEdit1.Checked == false) { Dssnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); UsTx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); DsRx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); } } if (dt.Rows[i]["value4"].ToString() != "") { UsSnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value4"].ToString())); if (int.Parse(dt.Rows[i]["value4"].ToString()) < 210) { UsNoise.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value4"].ToString())); } else { if (checkEdit1.Checked == false) { UsNoise.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); } } } else { if (checkEdit1.Checked == false) { UsSnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); UsNoise.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); } } } chartUSSnr.Series.AddRange(new Series[] { UsSnr, UsNoise }); chartRemote.Series.AddRange(new Series[] { UsTx, Dssnr, DsRx }); Waiting.CloseWaitForm(); }
private void Update_HopDongLaoDong() { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang khởi tạo yêu cầu.."); Class.NhanVien_HopDong_ThoiVu hd = new Class.NhanVien_HopDong_ThoiVu(); hd.ContractCode = txtContractCode.Text; hd.EmployeeCode = txtEmployeeCode.EditValue.ToString(); hd.ContractTime = txtContractTime.Text; hd.ContractYear = int.Parse(txtContractYear.Text); hd.SignDate = dateSignDate.DateTime; hd.FromDate = dateFromDate.DateTime; hd.ToDate = dateToDate.DateTime; hd.BasicSalary = txtBasicSalary.Value; hd.PayForm = txtPayForm.Text; hd.PayDate = txtPayDate.Text; hd.Allowance = txtAllowance.Text; hd.Insurance = txtInsurance.Text; hd.WorkTime = txtWorkTime.Text; hd.Signer = txtSigner.Text; hd.SignerPosition = txtSignerPosition.Text; hd.SignerNationality = txtSignerNationality.Text; hd.Company = txtCompany.Text; hd.Address = txtAddress.Text; hd.Tel = txtTel.Text; hd.Description = txtDescription.Text; hd.IsCurrent = checkIsCurrent.Checked; if (txtContractCode.Enabled == true) { Waiting.SetWaitFormDescription("Đang thực hiện thêm.."); if (hd.Insert()) { Waiting.SetWaitFormDescription("Đang tải dữ liệu.."); (this.Owner as frmDanhSachHopDong_Season).HRM_CONTRACT_SEASON_GetList(); Waiting.CloseWaitForm(); Class.App.SaveSuccessfully(); } else { Waiting.CloseWaitForm(); Class.App.SaveNotSuccessfully(); } } else { Waiting.SetWaitFormDescription("Đang thực hiện cập nhật.."); if (hd.Update()) { Waiting.SetWaitFormDescription("Đang tải dữ liệu.."); (this.Owner as frmDanhSachHopDong_Season).HRM_CONTRACT_SEASON_GetList(); Waiting.CloseWaitForm(); Class.App.SaveSuccessfully(); } else { Waiting.CloseWaitForm(); Class.App.SaveNotSuccessfully(); } } }
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); }
//string template_grid = Application.StartupPath + @"\Templates\Templates_Menu.xml"; private void btnDangNhap_ItemClick(object sender, ItemClickEventArgs e) { frmDangNhap frm = new frmDangNhap(); frm.Owner = this; frm.ShowDialog(); if (_taiKhoan != "") { Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang tải thông tin tài khoản.."); Permission_Show_Menu(_taiKhoan); //hien thi btndoimatkhau btnDoiMatKhau.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; // goi chuc nang thong bao this.btnThongBao.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; Class.RegistryWriter rg = new Class.RegistryWriter(); lblFullname.Caption = "Đang sử dụng: " + _taiKhoan + " | Thời gian: " + DateTime.Now.ToString("dd/MM/yyyy h:m tt") + " | Máy chủ: " + rg.valuekey("server"); sv_host = rg.valuekey("server"); // goi thong tin de luu Log phan mem Class.S_Log.Call_PcInfo(); Class.S_Log.UserName = _taiKhoan.ToLower(); ribbon.SelectedPage = Menu_Hrm; Class.S_Log.Insert("Hệ thống", "Đăng nhập"); Class.App.client_User = _taiKhoan; if (rg.valuekey("alert") == "Blue") { btnThongBao.Enabled = true; } else if (rg.valuekey("alert") == "1") { btnThongBao.Enabled = true; Class.ThongKe tk = new Class.ThongKe(); DataTable dt = tk.CT_EMPLOYEE_GetListBirthday(); if (dt.Rows.Count > 0) { dt.Columns.Add("Day", Type.GetType("System.String")); for (int i = 0; i < dt.Rows.Count; i++) { string txt = ((DateTime)dt.Rows[i]["BirthDay"]).Day.ToString(); if (txt.Length == 1) { txt = "0" + txt; } dt.Rows[i]["Day"] = txt; } DataView dv = dt.DefaultView; dv.Sort = "Day ASC"; dt = dv.ToTable(); // xuat thong bao sinh nhat sap den string tb = ""; for (int i = 0; i < dt.Rows.Count; i++) { tb += (i + 1).ToString() + ". " + dt.Rows[i]["FirstName"].ToString() + " " + dt.Rows[i]["LastName"].ToString() + ": <i>" + ((DateTime)dt.Rows[i]["Birthday"]).ToString("dd/MM/yyyy") + "</i>\n"; } alertControl.Show(this, "Danh sách sắp đến ngày sinh nhật:", tb); //------------- // xuat danh sach sap phai ky lai hop dong Class.DanhMuc_HopDong hd = new Class.DanhMuc_HopDong(); DataTable dthd = hd.CT_CONTRACT_GetListJustExpiration(); if (dthd.Rows.Count > 0) { DataView _dv = new DataView(); _dv = dthd.DefaultView; _dv.Sort = "ToDate ASC"; string tb2 = ""; for (int i = 0; i < _dv.Count; i++) { tb2 += (i + 1).ToString() + ". " + _dv[i]["FirstName"].ToString() + " " + _dv[i]["LastName"].ToString() + " -<i> " + ((DateTime)_dv[i]["ToDate"]).ToString("dd/MM/yyyy") + "</i>\n";; } alertControl.Show(this, "Danh sách sắp ký lại hợp đồng :", tb2); } ////-----------------================= if (File.Exists(@"media/" + Class.App.media)) { SoundPlayer simpleSound = new SoundPlayer(@"media/" + Class.App.media); simpleSound.Play(); } } } else { btnThongBao.Enabled = false; } Waiting.CloseWaitForm(); } }
private void btnLoadAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (Waiting.IsSplashFormVisible) { return; } Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription("Đang kêt nôi đến hệ thống khách hàng.!"); gridItem.Enabled = false; if (gridItemDetail.RowCount > 0) { Class.CN_ADMIN cn = new Class.CN_ADMIN(); if (!cn.isLogin()) { cn.Connect(Class.CN_ADMIN.User, Class.CN_ADMIN.Passwors); } string mac = ""; string CustomerName = ""; string Address = ""; string Ward = ""; string District = ""; List <string> l = new List <string>(); Waiting.SetWaitFormDescription("Đang kêt kiểm tra đăng nhập.!"); if (cn.isLogin()) { Waiting.SetWaitFormDescription("Đang Tải thông tin khách hàng.!"); for (int i = 0; i < gridItemDetail.RowCount; i++) { CustomerName = ""; Address = ""; if (gridItemDetail.GetRowCellDisplayText(i, colMacAdress).ToString().Length > 1) { // thuc hien lay mac theo dinh dang mac = gridItemDetail.GetRowCellDisplayText(i, colMacAdress).ToString(); mac = mac.Replace(".", ""); mac = mac.Replace(".", ""); // khoi thao mac theo dinh dang mac = mac.Insert(2, ":"); mac = mac.Insert(5, ":"); mac = mac.Insert(8, ":"); mac = mac.Insert(11, ":"); mac = mac.Insert(14, ":"); // l = cn.Device_Search(mac, "2", out CustomerName, out Address, out Ward); cn.Device__Edit_View(mac, out CustomerName, out Address, out Ward, out District); gridItemDetail.SetRowCellValue(i, colCustomerName, CustomerName); gridItemDetail.SetRowCellValue(i, colCustomerAddress, Address); gridItemDetail.SetRowCellValue(i, colWard, Ward); gridItemDetail.SetRowCellValue(i, colDisTrict, District); //dt.Rows[i]["CustomerName"] = CustomerName; //dt.Rows[i]["CustomerAddress"] = Address; //dt.Rows[i]["Ward"] = Ward; //dt.Rows[i]["District"] = District; } } } Waiting.SetWaitFormDescription("Hoàn tất quá trình tải.!"); } gridItem.Enabled = true; Waiting.CloseWaitForm(); }
private void btnLoad_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (btnConnect.Enabled) { return; } else { if (!Class.CMTS.tcpClient.Connected) { btnConnect.Enabled = true; return; } } Waiting.ShowWaitForm(); // lay Remote DateTime dtime = DateTime.Now; Class.CMTS cmts = new Class.CMTS(); string value1 = ""; string value2 = ""; string value3 = ""; string mac = ""; string IpPrivate = ""; string status = ""; string location = ""; string[] list = null; dtRe.Rows.Clear(); list = null; // lay remote cmts.Remote_Card_all(out list, Waiting); if (list != null) { DataRow dr; for (int i = 0; i < list.Length; i++) { // lay online if (list[i].IndexOf("MOT") < 0) // kiem tra { if (list[i].IndexOf("online") > 0) { status = "online"; } else { status = "offline"; } // location Regex r2 = new Regex(@"(\d+)/(\d+)/(\w+) "); Match m2 = r2.Match(list[i]); if (m2.Success) { location = m2.Value.Trim(); } // loc thong so Regex r = new Regex(@" (\d+).(\d+).(\d+).(\d+)(.*)(\w+).(\w+).(\w+)(.*)(\d+) "); Match m = r.Match(list[i]); if (m.Success) { string kq = m.Value; kq = kq.Trim(); kq = kq.Replace(" ", " "); kq = kq.Replace(" ", " "); kq = kq.Replace(" ", " "); string[] cat = kq.Split(' '); IpPrivate = cat[0]; mac = cat[1]; value1 = cat[2]; value2 = cat[3]; value3 = cat[4]; if (IpPrivate.Equals("0.0.0.0")) { mac = cat[2]; value1 = cat[3]; value2 = cat[4]; value3 = cat[5]; } } if (mac.Trim() != "") { dr = dtRe.NewRow(); dr["MacAddress"] = mac; dr["IpPrivate"] = IpPrivate; dr["value1"] = value1; dr["value2"] = value2; dr["value3"] = value3; dr["Location"] = location; dr["Status"] = status; dr["DateTime"] = dtime; dtRe.Rows.Add(dr); } } } } /// het lay Remote /// lay PHY /// string value4 = ""; dtPhy.Rows.Clear(); list = null; List <string> list1 = new List <string>(); // lay remote cmts.PHY_Card_all(out list, Waiting, out list1); if (list != null) { DataRow dr; for (int i = 0; i < list.Length; i++) { value4 = ""; Regex rMac = new Regex(@"(\w+).(\w+).(\w+).(\w+)"); Match m3 = rMac.Match(list[i]); if (m3.Success) { string kq2 = m3.Value; mac = kq2; Regex rPHY = new Regex(@" (\d+){3} "); Match m4 = rPHY.Match(list[i]); if (m4.Success) { string kq = m4.Value; value4 = kq; if (value4 != "") { if (value4.Length >= 6) { value4 = value4.Substring(0, 4); } if (int.Parse(value4) > 500) { value4 = "0"; } dr = dtPhy.NewRow(); dr["MacAddress"] = mac; dr["value4"] = value4; dr["DateTime"] = dtime; dr["Status"] = "online"; dtPhy.Rows.Add(dr); } } } } } // bo sung if (list1 != null) { DataRow dr; for (int i = 0; i < list1.Count; i++) { value4 = ""; Regex rMac = new Regex(@"(\w+).(\w+).(\w+).(\w+)"); Match m3 = rMac.Match(list1[i]); if (m3.Success) { string kq2 = m3.Value; mac = kq2; Regex rPHY = new Regex(@" (\d+){3} "); Match m4 = rPHY.Match(list1[i]); if (m3.Success) { string kq = m4.Value; value4 = kq; if (value4 != "") { if (value4.Length >= 6) { value4 = value4.Substring(0, 4); } if (int.Parse(value4) > 500) { value4 = "0"; } dr = dtPhy.NewRow(); dr["MacAddress"] = mac; dr["value4"] = value4; dr["DateTime"] = dtime; dr["Status"] = "online"; dtPhy.Rows.Add(dr); } } } } } // het phan bo sung // noi du lieu string txt = ""; DataRow[] result = null; DataRow[] result2 = null; value4 = ""; Class.CMTS cls = new Class.CMTS(); if (dt.Rows.Count > 0) { if (dtRe.Rows.Count > 0) { // begin Append for (int i = 0; i < dt.Rows.Count; i++) { txt = dt.Rows[i]["MacAddress"].ToString(); result = dtRe.Select("MacAddress ='" + txt + "'"); dt.Rows[i]["DateTime"] = dtime; foreach (DataRow row in result) { dt.Rows[i]["IpPrivate"] = row["IpPrivate"].ToString(); dt.Rows[i]["Location"] = row["Location"].ToString(); dt.Rows[i]["value1"] = row["value1"].ToString(); dt.Rows[i]["value2"] = row["value2"].ToString(); dt.Rows[i]["value3"] = row["value3"].ToString(); dt.Rows[i]["Status"] = row["Status"].ToString(); } result2 = dtPhy.Select("MacAddress ='" + txt + "'"); foreach (DataRow row in result2) { dt.Rows[i]["value4"] = row["value4"].ToString(); } if (dt.Rows[i]["Status"].ToString() == "online") { if (dt.Rows[i]["value4"] == DBNull.Value) { Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString()); Thread.Sleep(2); cls.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4); dt.Rows[i]["value4"] = value4; } else if (dt.Rows[i]["value4"].ToString().Trim() == "") { Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString()); Thread.Sleep(2); cls.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4); dt.Rows[i]["value4"] = value4; } } Waiting.SetWaitFormDescription("Bắt đầu tiến hành nối Dữ liệu.!(" + (i + 1) + ")"); Thread.Sleep(1); } } } // het theo kieu load het Modem ///////////////////////////////////////////////////////////// //Waiting.SetWaitFormDescription("Lưu thông số thiết bị vào CSDL"); //Class.NW_Device clsdv = new Class.NW_Device(); //for (int i = 0; i < dt.Rows.Count; i++) //{ // Waiting.SetWaitFormDescription("Lưu dữ liệu thiết bị : " + (i + 1)); // Thread.Sleep(1); // clsdv.MacAddress = dt.Rows[i]["MacAddress"].ToString(); // clsdv.IpPrivate = dt.Rows[i]["IpPrivate"].ToString(); // clsdv.IpPublic1 = dt.Rows[i]["IpPublic1"].ToString(); // clsdv.IpPublic2 = dt.Rows[i]["IpPublic2"].ToString(); // clsdv.Value1 = dt.Rows[i]["Value1"].ToString(); // clsdv.Value2 = dt.Rows[i]["Value2"].ToString(); // clsdv.Value3 = dt.Rows[i]["Value3"].ToString(); // clsdv.Value4 = dt.Rows[i]["Value4"].ToString(); // clsdv.Location = dt.Rows[i]["Location"].ToString(); // clsdv.Status = dt.Rows[i]["Status"].ToString(); // clsdv.DateTime = (DateTime)dt.Rows[i]["DateTime"]; // clsdv.UpdateSignal(); //} Waiting.CloseWaitForm(); //btnChart_ItemClick(null, null); } catch { Class.CMTS.tcpClient = null; btnConnect.Enabled = true; if (Waiting.IsSplashFormVisible) { Waiting.CloseWaitForm(); } } }