private void Get_Contract()
{
Class.DanhMuc_HopDong dmhd = new Class.DanhMuc_HopDong();
DataTable dthd = dmhd.CT_CONTRACT_GetList();
gridItem.DataSource = dthd;
}
private void call_info(string code)
{
Class.DanhMuc_HopDong hd = new Class.DanhMuc_HopDong();
DataTable dt = hd.CT_CONTRACT_Get(code);
txtSigner.Text = dt.Rows[0]["Signer"].ToString();
txtSignerNationality.Text = dt.Rows[0]["SignerNationality"].ToString();
txtSignerPosition.Text = dt.Rows[0]["SignerPosition"].ToString();
txtCompany.Text = dt.Rows[0]["Company"].ToString();
txtAddress.Text = dt.Rows[0]["Address"].ToString();
txtTel.Text = dt.Rows[0]["Tel"].ToString();
checkIsCurrent.Checked = (bool)dt.Rows[0]["IsCurrent"];
txtEmployeeCode.EditValue = dt.Rows[0]["EmployeeCode"].ToString();
//tab thong tin hop dong
if (dt.Rows[0]["SecondAllowance"].ToString().Length > 0)
{
_textAll = dt.Rows[0]["SecondAllowance"].ToString();
}
else
{
_textAll = "0";
}
txtContractCode.Text = dt.Rows[0]["ContractCode"].ToString();
txtContractTime.Text = dt.Rows[0]["ContractTime"].ToString();
txtContractType.Text = dt.Rows[0]["ContractType"].ToString();
txtContractYear.Text = dt.Rows[0]["ContractYear"].ToString();
dateSignDate.DateTime = (DateTime)dt.Rows[0]["SignDate"];
dateFromDate.DateTime = (DateTime)dt.Rows[0]["FromDate"];
if (dt.Rows[0]["ToDate"] != DBNull.Value)
{
dateToDate.DateTime = (DateTime)dt.Rows[0]["ToDate"];
}
txtBasicSalary.Value = (decimal)dt.Rows[0]["BasicSalary"];
txtPayForm.Text = dt.Rows[0]["PayForm"].ToString();
txtPayDate.Value = (int)dt.Rows[0]["PayDate"];
txtAllowance.Text = dt.Rows[0]["Allowance"].ToString();
txtTestAllowance.Text = dt.Rows[0]["SecondAllowance"].ToString();
txtRate.Text = dt.Rows[0]["Rate"].ToString();
txtInsurance.Text = dt.Rows[0]["Insurance"].ToString();
txtWorkTime.Text = dt.Rows[0]["WorkTime"].ToString();
txtSubject.Text = dt.Rows[0]["Subject"].ToString();
txtDescription.Text = dt.Rows[0]["Description"].ToString();
}
private void btnPrint_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int SelectedRow = gridItemDetail.FocusedRowHandle;
if (SelectedRow >= 0)
{
int waitIndex = 0;
Waiting.ShowWaitForm();
DataRow drow = gridItemDetail.GetDataRow(SelectedRow);
string _value = drow["ContractCode"].ToString();
Class.DanhMuc_HopDong hd = new Class.DanhMuc_HopDong();
hd.ContractCode = _value;
DataTable dt = hd.CT_CONTRACT_GetPrintByCode();
if (_value.IndexOf("HDTV") > 0)
{
// Reports.reportHoDongThuViec rp = new Reports.reportHoDongThuViec();
// rp.DataSource = dt;
// rp.ShowDesigner();
// rp.ShowPreviewDialog();
}
else
{
Reports.reportHopDongLaoDong report = new Reports.reportHopDongLaoDong(dt);
report.DataSource = dt;
Waiting.CloseWaitForm();
waitIndex = 1;
report.ShowPreviewDialog();
report.ShowDesigner();
Class.S_Log.Insert("Hợp đồng", "Xem trang In Hợp đồng lao động: " + _value);
}
if (waitIndex != 1)
{
Waiting.CloseWaitForm();
}
}
}
private void Update_hopDong()
{
Class.DanhMuc_HopDong dmhd = new Class.DanhMuc_HopDong();
dmhd.ContractCode = txtContractCode.Text;
dmhd.EmployeeCode = txtEmployeeCode.Text;
dmhd.ContractType = txtContractType.Text;
dmhd.ContractTime = txtContractTime.Text;
dmhd.ContractYear = int.Parse(txtContractYear.Text);
dmhd.SignDate = dateSignDate.DateTime;
dmhd.FromDate = dateFromDate.DateTime;
dmhd.ToDate = dateToDate.DateTime;
dmhd.BasicSalary = txtBasicSalary.Value;
dmhd.PayForm = txtPayForm.Text;
dmhd.PayDate = int.Parse(txtPayDate.Text);
dmhd.Allowance = txtAllowance.Text;
dmhd.SecondAllowance = txtTestAllowance.Text;
dmhd.Rate = int.Parse(txtRate.Text);
dmhd.Insurance = txtInsurance.Text;
dmhd.WorkTime = txtWorkTime.Text;
dmhd.Signer = txtSigner.Text;
dmhd.SignerPosition = txtSignerPosition.Text;
dmhd.SignerNationality = txtSignerNationality.Text;
dmhd.Company = txtCompany.Text;
dmhd.Address = txtAddress.Text;
dmhd.Tel = txtTel.Text;
dmhd.Subject = txtSubject.Text;
dmhd.Description = txtDescription.Text;
dmhd.IsCurrent = checkIsCurrent.Checked;
if (dmhd.Insert())
{
Class.App.SaveSuccessfully();
}
else
{
Class.App.SaveNotSuccessfully();
}
}
//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 xulyTaoCodeHopdong()
{
if (btnUpdate.Enabled == true)
{
if (txtFullName.Text != "[Họ và tên nhân viên]")
{
Class.DanhMuc_HopDong hd = new Class.DanhMuc_HopDong();
// Class.NhanVien_HopDong hd = new Class.NhanVien_HopDong();
hd.ContractYear = int.Parse(txtContractYear.Text);
// hd.ContractType = txtContractType.Text;
DataTable dt = hd.CT_CONTRACT_GetByYear();
hd.EmployeeCode = txtEmployeeCode.EditValue.ToString();
DataTable dthdbynv = hd.CT_CONTRACT_GetByEmployee();
if (dt.Rows.Count > 0)
{
string _idCheck;
string[] cat;
int next_ID = 0;
int next_ID2 = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
_idCheck = dt.Rows[i]["ContractCode"].ToString();
cat = _idCheck.Split('-');
next_ID2 = int.Parse(cat.GetValue(0).ToString());
if ((next_ID2 - next_ID) > 1)
{
break;
}
next_ID = int.Parse(cat.GetValue(0).ToString());
}
//string _idContract = dt.Rows[dt.Rows.Count - 1]["ContractCode"].ToString();
//cat = _idContract.Split('-');
// next_ID = int.Parse(cat.GetValue(0).ToString()) + 1;
next_ID++;
if (next_ID.ToString().Length == 1)
{
txtContractCode.Text = "000" + next_ID.ToString() + "-" + txtContractYear.Text;
}
if (next_ID.ToString().Length == 2)
{
txtContractCode.Text = "00" + next_ID.ToString() + "-" + txtContractYear.Text;
}
if (next_ID.ToString().Length == 3)
{
txtContractCode.Text = "0" + next_ID.ToString() + "-" + txtContractYear.Text;
}
if (next_ID.ToString().Length == 4)
{
txtContractCode.Text = next_ID.ToString() + "-" + txtContractYear.Text;
}
}
else
{
txtContractCode.Text = "0001-" + txtContractYear.Text;
}
// kiem tra ky hop dong truc tiep ko co thu viec
int solanHD = 1;
for (int i = 0; i < dthdbynv.Rows.Count; i++)
{
string maHD = dthdbynv.Rows[i]["ContractCode"].ToString();
if (maHD.Contains("HDTV"))
{
solanHD = dthdbynv.Rows.Count;
break;
}
if (maHD.Contains("HDLD"))
{
solanHD++;
}
}
switch (txtContractType.Text)
{
case "Hợp đồng xác định thời hạn":
txtContractCode.Text = txtContractCode.Text + "/HDLD/Lan" + solanHD;
break;
case "Hợp đồng không xác định thời hạn":
txtContractCode.Text = txtContractCode.Text + "/HDLD/KXDTH-Lan" + solanHD;
break;
case "Hợp đồng thử việc":
txtContractCode.Text = txtContractCode.Text + "/HDTV";
break;
case "Hợp đồng học việc":
txtContractCode.Text = txtContractCode.Text + "/HDHV";
break;
}
if (dthdbynv.Rows.Count > 0)
{
if (dthdbynv.Rows[dthdbynv.Rows.Count - 1]["ToDate"] != DBNull.Value)
{
DateTime _dateNgaykt = (DateTime)dthdbynv.Rows[dthdbynv.Rows.Count - 1]["ToDate"];
DateTime _dateNgayKyTiep = _dateNgaykt.AddDays(1);
dateFromDate.DateTime = _dateNgayKyTiep;
dateSignDate.DateTime = _dateNgayKyTiep;
dateFromDate_Validated(null, null);
}
}
else
{
// la HDTV se lay ngay tu ngay bat dau lam viec
dateFromDate.DateTime = DateBegin;
dateSignDate.DateTime = DateBegin;
dateFromDate_Validated(null, null);
}
}
else
{
MessageBox.Show("Vui Lòng chọn nhân viên ký hợp đồng trước");
TabControl.SelectedTabPage = TabPage1;
}
}
// tam thoi han che khong cho lam lap 4 hop dong lao dong
if (txtContractCode.Text.Contains("Lan4"))
{
MessageBox.Show("Hợp đồng Lao động chỉ chấp nhận nhỏ hơn 4 lần, Vui lòng kiểm tra lại hoặc liên hệ Người Quản Trị", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
