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