public void UpdateNguocNhanVien_BaoHiem() { BHNHANVIEN_BAOHIEM nvbh = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(Convert.ToInt32(hdfIdNhanVien_BaoHiem.Text)); nvbh.IDNhanVien_BaoHiem = Convert.ToInt32(hdfIdNhanVien_BaoHiem.Text); if (!string.IsNullOrEmpty(txtLuongDongBHXHMoi1.Text)) { nvbh.LuongBaoHiem = Convert.ToDecimal(txtLuongDongBHXHMoi1.Text); } if (!string.IsNullOrEmpty(txtPhuCapTNNMoi1.Text)) { nvbh.PhuCapTNN = Convert.ToDecimal(txtPhuCapTNNMoi1.Text); } if (!string.IsNullOrEmpty(txtPhuCapCVMoi1.Text)) { nvbh.PhuCapCV = Convert.ToDecimal(txtPhuCapCVMoi1.Text); } if (!string.IsNullOrEmpty(txtPhuCapTNVKMoi1.Text)) { nvbh.PhuCapTNVK = Convert.ToDecimal(txtPhuCapTNVKMoi1.Text); } NhanVien_BaoHiemController nvc = new NhanVien_BaoHiemController(); nvc.UpdateNhanVien_BaoHiem(nvbh); }
public int TinhSoThangDongBaoHiem(int idNhanVien, int ThoiGianDongTruoc) { var macb = new NhanVien_BaoHiemController().GetMaCBByIDNhanVienBH(idNhanVien); var rs = (from t in dataContext.BangThanhToanLuongs where t.MaCB == macb select t).ToList(); return(ThoiGianDongTruoc + rs.Count); }
//click vào nút thêm, hoặc sửa. load thông tin của nhân viên protected void btnAddXemTheoNhanVien_Click(object sender, DirectEventArgs e) { //txtThoiGianDong1.StyleSpec = "color:black"; //txtSoNgayNghi1.StyleSpec = "color:black"; //new BaoHiemController().ClearControl(wdXemTheoNhanVien); DAL.BHNHANVIEN_BAOHIEM nvbh = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByIDNhanVien_BaoHiem(int.Parse(hdfIDNhanVienBaoHiem.Text)); txtMaCanBo1.Text = nvbh.MaNhanVien; txtHoTen1.Text = nvbh.HoTen; if (!Util.GetInstance().IsDateNull(nvbh.NgaySinh)) { dfNgaySinh1.SelectedDate = (DateTime)nvbh.NgaySinh; } txtSoSoBHXH1.Text = nvbh.SoSoBHXH; txtSoCMND1.Text = nvbh.SoCMTND; txtThoiGianDong1.Text = new BaoHiemController().ChuyenSoThangDongBH(Convert.ToInt32(nvbh.ThoiGianDongBaoHiem)); ThoiGianDongBHXH = Convert.ToInt32(nvbh.ThoiGianDongBaoHiem); if (string.IsNullOrEmpty(nvbh.SoSoBHXH)) { txtSoSoBHXH1.StyleSpec = "color:red;"; Dialog.ShowNotification("Nhân viên này chưa có số sổ BHXH"); } // chkDaThanhToan1.Checked = true; if (hdfwdShow.Text == "Sua") { int iddieukienhuong; DAL.BHCHITIETCHEDOBAOHIEM chitiet = new CheDoBaoHiemController().GetChiTietCheDoBaoHiemByID(int.Parse(hdfIDChiTietCheDoBaoHiem.Text)); iddieukienhuong = chitiet.IDBangTinhCheDoBaoHiem; DAL.BHBANGTINHCHEDOBAOHIEM bangtinh = new BangTinhCheDoBaoHiemController().GetByPrKey(chitiet.IDBangTinhCheDoBaoHiem); //cbbCheDo1Store // RM.RegisterClientScriptBlock("abc","cbbCheDo1Store.reload();"); cbbCheDo1.SetValue(bangtinh.IDCheDoBaoHiem); hdfIDCheDoBaoHiem.Text = bangtinh.IDCheDoBaoHiem.ToString(); RM.RegisterClientScriptBlock("abc", "cbbDieuKienHuong1Store.reload();"); hdfDieuKienHuong.Text = bangtinh.IDBangTinhCheDoBaoHiem.ToString(); cbbDieuKienHuong1.SetValue(iddieukienhuong); cbbDieuKienHuong1.Text = bangtinh.TenDieuKienHuong; if (!Util.GetInstance().IsDateNull(chitiet.NgayBatDau)) { dfNgayBatDau1.SelectedDate = chitiet.NgayBatDau; } if (!Util.GetInstance().IsDateNull(chitiet.NgayKetThuc)) { dfNgayKetThuc1.SelectedDate = chitiet.NgayKetThuc; } txtSoTienDeNghi1.Text = chitiet.SoTienDeNghi.ToString(); txtSoNgayNghi1.Text = chitiet.SoNgayNghi.ToString(); chkDaThanhToan1.Checked = chitiet.TinhTrangThanhToan; txtChiTieuLuong1.Text = chitiet.TienLuongTinhHuong.ToString(); txtGhiChu1.Text = chitiet.GhiChu; txtLuyKe1.Text = new CheDoBaoHiemController().TinhSoNgayNghiNhanVien(int.Parse(hdfIDNhanVienBaoHiem.Text), int.Parse(hdfIDCheDoBaoHiem.Text)).ToString(); } }
[DirectMethod] //khi kích vào nút sửa, tự động load dữ liệu biến động public void loadThongTinBienDong() { // thay đổi title icon windown wdThemSuaBienDongNhanVien.Title = "Sửa biến động cho nhân viên"; wdThemSuaBienDongNhanVien.Icon = Icon.Pencil; ChiTietNhanVienBienDongInfo bdbh = new QuanLyBienDongBaoHiemController().GetByIDBienDongBaoHiem(int.Parse(hdfChiTietID.Text)); txtMaCanBo1.Text = bdbh.MaNhanVien; txtHoTen1.Text = bdbh.HoTen; dfNgaySinh1.Value = bdbh.NgaySinh; txtSoSoBHXH1.Text = bdbh.MaSo; // thông tin về truy thu thoái thu nfTruyThuBHXH.Text = bdbh.TruyThuBHXH.ToString(); nfTruyThuBHYT.Text = bdbh.TruyThuBHYT.ToString(); nfThoaiThuBHXH.Text = bdbh.ThoaiThuBHXH.ToString(); nfThoaiThuBHYT.Text = bdbh.ThoaiThuBHYT.ToString(); //thong tin nhan vien DAL.BHNHANVIEN_BAOHIEM hs = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(hdfMaNhanVien.Value.ToString()); txtLuongDongBH1.Text = hs.LuongBaoHiem.ToString(); txtThoiGianDongBHXH1.Text = new BaoHiemController().ChuyenSoThangDongBH((int)hs.ThoiGianDongBaoHiem); // check chkBHTN1.SetValue(hs.DangDongBHTN); chkBHYT1.SetValue(hs.DangDongBHYT); chkBHXH1.SetValue(hs.DangDongBHXH); hdfIsBHXH.Text = hs.DangDongBHXH.ToString(); hdfIsBHYT.Text = hs.DangDongBHYT.ToString(); hdfIsBHTN.Text = hs.DangDongBHTN.ToString(); //thông tin quy định biến động DAL.BHQUYDINHBIENDONG qdbd = new BHQUYDINHBIENDONGController().Lay1QuyDinhBienDong(bdbh.IDQuyDinhBienDong); //set 1 số id cho hiddenfield hdfIdNhanVien_BaoHiem.Text = hs.IDNhanVien_BaoHiem.ToString(); hdfIDQuyDinhBienDong.Text = qdbd.IDQuyDinhBienDong.ToString(); hdfIDLoaiCheDo.Text = qdbd.IDCheDoBaoHiem.ToString(); hdfMaLoaiBienDong.Text = qdbd.MaBienDong; tgfChonBienDong1.Text = qdbd.TenBienDong; //dt.Rows[0]["TenBienDong"].ToString(); hdfMaLoaiBienDong.Text = qdbd.MaBienDong; chkBHXH1.Checked = (bool)qdbd.IsBHXH; // (bool)dt.Rows[0]["IsBHXH"]; chkBHYT1.Checked = (bool)qdbd.IsBHYT; // (bool)dt.Rows[0]["IsBHYT"]; chkBHTN1.Checked = (bool)qdbd.IsBHTN; // (bool)dt.Rows[0]["IsBHTN"]; if (qdbd.IDCheDoBaoHiem != null) { hdfIDLoaiCheDo.Text = qdbd.IDCheDoBaoHiem.ToString(); // RM.RegisterClientScriptBlock("rlst", "#{cbbLoaiCheDo1_Store}.reload();"); } hdfIDQuyDinhBienDong.Text = qdbd.IDQuyDinhBienDong.ToString();// dt.Rows[0]["IDQuyDinhBienDong"].ToString(); txtLuongDongBHXHCu1.Text = bdbh.TienLuongCu.ToString(); txtPhuCapTNVKCu1.Text = bdbh.PhuCapTNVKCu.ToString(); txtPhuCapTNNCu1.Text = bdbh.PhuCapNgheCu.ToString(); txtPhuCapCVCu1.Text = bdbh.PhuCapCVCu.ToString(); txtLuongDongBHXHMoi1.Text = bdbh.TienLuongMoi.ToString(); txtPhuCapCVMoi1.Text = bdbh.PhuCapCVMoi.ToString(); txtPhuCapTNNMoi1.Text = bdbh.PhuCapTNNgheMoi.ToString(); txtPhuCapTNVKMoi1.Text = bdbh.PhuCapTNVKMoi.ToString(); txtLuongDongBHXHMoi1.Text = bdbh.TienLuongMoi.ToString(); //if (qdbd.LoaiAnhHuong == "TMD" || qdbd.LoaiAnhHuong == "GMD") //{ // RM.RegisterClientScriptBlock("rl10", "#{pnlThongTinLuong1}.enable();");//#{tabPanel1}.addTab(#{pnlThongTinLuong1}); //} //else //{ // RM.RegisterClientScriptBlock("rl11", "#{pnlThongTinLuong1}.disable();");//#{tabPanel1}.closeTab(#{pnlThongTinLuong1}, 'hide'); //} //if (qdbd.LoaiAnhHuong == "TruyThu" || qdbd.LoaiAnhHuong == "ThoaiThu") //{ // RM.RegisterClientScriptBlock("rl2", "#{pnlTruyThoaithu1}.enable();");//#{tabPanel1}.addTab(#{pnlThongTinLuong1}); //} //else //{ // RM.RegisterClientScriptBlock("rl13", "#{pnlTruyThoaithu1}.disable();");//#{tabPanel1}.closeTab(#{pnlThongTinLuong1}, 'hide'); // //RM.RegisterClientScriptBlock("rl4", "#{tabPanel}.closeTab(#{pnlTruyThoaithu}, 'hide');"); //} dfTuNgay1.Value = bdbh.TuNgay.Value; if (bdbh.DenNgay != null) { dfDenNgay1.Value = bdbh.DenNgay; } if (bdbh.ThangDangKy.HasValue) { dfNgayDangKyVoiCQBH.Value = bdbh.ThangDangKy.Value; } chkDaCoSo.Checked = (bool)bdbh.DaCoSo; chkKhongTraThe.Checked = (bool)bdbh.KhongTraThe; txtDienGiai1.Text = bdbh.DienGiai; //Thông tin chế độ. }
[DirectMethod]//khi kích vào nút thêm, tự động load dữ liệu của nhân viên public void loadThongTinNhanVien() { btnLayThayDoiTuQuyetDinhLuong.Disabled = false; BHNHANVIEN_BAOHIEM hs = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(hdfMaNhanVien.Value.ToString()); txtMaCanBo1.Text = hs.MaNhanVien; dfNgaySinh1.Value = hs.NgaySinh; txtLuongDongBH1.Text = hs.LuongBaoHiem.ToString(); txtHoTen1.Text = hs.HoTen; txtSoSoBHXH1.Text = hs.SoSoBHXH; txtThoiGianDongBHXH1.Text = new BaoHiemController().ChuyenSoThangDongBH(Convert.ToInt32(hs.ThoiGianDongBaoHiem)); hdfIdNhanVien_BaoHiem.Text = hs.IDNhanVien_BaoHiem.ToString(); //set check vaf hidden field cho check chkBHTN1.Checked = (bool)hs.DangDongBHTN; chkBHYT1.Checked = (bool)hs.DangDongBHYT; chkBHXH1.Checked = (bool)hs.DangDongBHXH; hdfIsBHXH.Text = hs.DangDongBHXH.ToString(); hdfIsBHYT.Text = hs.DangDongBHYT.ToString(); hdfIsBHTN.Text = hs.DangDongBHTN.ToString(); //if (hs.TrangThaiCapTheBHYT != null) // chkKhongTraThe.Checked = hs.TrangThaiCapTheBHYT == "DaCapThe" ? true : false; chkKhongTraThe.Checked = false; if (hs.TrangThaiCapSoBHXH != null) { chkDaCoSo.Checked = hs.TrangThaiCapSoBHXH == "DaCapSo" ? true : false; } if (!string.IsNullOrEmpty(hs.LuongBaoHiem.ToString())) { txtLuongDongBHXHCu1.Text = hs.LuongBaoHiem.ToString(); txtLuongDongBHXHMoi1.Text = txtLuongDongBHXHCu1.Text; } if (!string.IsNullOrEmpty(hs.PhuCapCV.ToString())) { txtPhuCapCVCu1.Text = hs.PhuCapCV.ToString(); txtPhuCapCVMoi1.Text = txtPhuCapCVCu1.Text; } if (!string.IsNullOrEmpty(hs.PhuCapTNVK.ToString())) { txtPhuCapTNVKCu1.Text = hs.PhuCapTNVK.ToString(); txtPhuCapTNVKMoi1.Text = txtPhuCapTNVKCu1.Text; } if (!string.IsNullOrEmpty(hs.PhuCapTNN.ToString())) { txtPhuCapTNNCu1.Text = hs.PhuCapTNN.ToString(); txtPhuCapTNNMoi1.Text = txtPhuCapTNNCu1.Text; } dfTuNgay1.SelectedDate = DateTime.Now; #region Xử lý thay đổi thông tin lương từ quyết định lương txtTTLuongBHCu.Text = txtLuongDongBHXHCu1.Text; txtTTPhuCapCVCu.Text = txtPhuCapCVCu1.Text; txtTTPCTNVKCu.Text = txtPhuCapTNVKCu1.Text; txtTTPCTNNCu.Text = txtPhuCapTNNCu1.Text; string soquyetdinh; string tenquyetdinh; DateTime?ngayky; DateTime?Ngayhieuluc; DateTime?Hethieuluc; decimal? luongbaohiem; decimal? phucapcv; decimal? phucaptnn; decimal? phucaptnvk; decimal? phucapkhac; new BaoHiemController().TTQuyetDinhLuongMoiNhat(hs.IDNhanVien_BaoHiem, out soquyetdinh, out tenquyetdinh, out ngayky, out Ngayhieuluc, out Hethieuluc, out luongbaohiem, out phucapcv, out phucaptnn, out phucaptnvk, out phucapkhac); txtTTSoQD.Text = soquyetdinh; txtTTTenQD.Text = tenquyetdinh; if (!new SoftCore.Util().IsDateNull(Ngayhieuluc)) { dfTTNgayHieuLuc.SelectedDate = (DateTime)Ngayhieuluc; } if (!new SoftCore.Util().IsDateNull(Hethieuluc)) { dfTTNgayHetHieuLuc.SelectedDate = (DateTime)Hethieuluc; } if (luongbaohiem != null) { txtTTLuongBHMoi.Text = luongbaohiem.ToString(); txtLuongDongBHXHMoi1.Text = txtLuongDongBHXHCu1.Text; } if (phucapcv != null) { txtTTPhuCapCVMoi.Text = phucapcv.ToString(); txtPhuCapCVMoi1.Text = txtPhuCapCVCu1.Text; } if (phucaptnn != null) { txtTTPCTNNMoi.Text = phucaptnn.ToString(); txtPhuCapTNNMoi1.Text = txtPhuCapTNNCu1.Text; } if (phucaptnvk != null) { txtTTPCTNVKMoi.Text = phucaptnvk.ToString(); txtPhuCapTNVKMoi1.Text = txtPhuCapTNVKCu1.Text; } #endregion }
//sự kiện cập nhật sửa protected void btnCapNhatSua_Click(object sender, DirectEventArgs e) { QuanLyBienDongBaoHiemController qlbd = new QuanLyBienDongBaoHiemController(); BHBIENDONGBAOHIEM bdbh = qlbd.GetBienDongBaoHiemByID(int.Parse(hdfChiTietID.Text)); bdbh.IDQuyDinhBienDong = int.Parse(hdfIDQuyDinhBienDong.Text); bdbh.TuNgay = (DateTime)dfTuNgay1.Value; if (!SoftCore.Util.GetInstance().IsDateNull(dfDenNgay1.SelectedDate)) { bdbh.DenNgay = (DateTime)dfDenNgay1.Value; } if (!SoftCore.Util.GetInstance().IsDateNull(dfNgayDangKyVoiCQBH.SelectedDate)) { bdbh.ThangDangKy = (DateTime)dfNgayDangKyVoiCQBH.Value; } DAL.BHQUYDINHBIENDONG qdbd = new BHQUYDINHBIENDONGController().Lay1QuyDinhBienDong(bdbh.IDQuyDinhBienDong); bdbh.Loai = qdbd.LoaiAnhHuong; BHNHANVIEN_BAOHIEM hs = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(hdfMaNhanVien.Value.ToString()); if (!string.IsNullOrEmpty(hs.LuongBaoHiem.ToString())) { txtLuongDongBHXHCu1.Text = hs.LuongBaoHiem.ToString(); txtLuongDongBHXHMoi1.Text = txtLuongDongBHXHCu1.Text; } if (!string.IsNullOrEmpty(hs.PhuCapCV.ToString())) { txtPhuCapCVCu1.Text = hs.PhuCapCV.ToString(); txtPhuCapCVMoi1.Text = txtPhuCapCVCu1.Text; } if (!string.IsNullOrEmpty(hs.PhuCapTNVK.ToString())) { txtPhuCapTNVKCu1.Text = hs.PhuCapTNVK.ToString(); txtPhuCapTNVKMoi1.Text = txtPhuCapTNVKCu1.Text; } if (!string.IsNullOrEmpty(hs.PhuCapTNN.ToString())) { txtPhuCapTNNCu1.Text = hs.PhuCapTNN.ToString(); txtPhuCapTNNMoi1.Text = txtPhuCapTNNCu1.Text; } if (qdbd.LoaiAnhHuong == "TMD" || qdbd.LoaiAnhHuong == "GMD") { bdbh.TienLuongCu = txtLuongDongBHXHCu1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHCu1.Text.Replace('.', ',')); bdbh.PhuCapTNVKCu = txtPhuCapTNVKCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNVKCu1.Text.Replace('.', ',')); bdbh.PhuCapNgheCu = txtPhuCapTNNCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNNCu1.Text.Replace('.', ',')); bdbh.PhuCapCVCu = txtPhuCapCVCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapCVCu1.Text.Replace('.', ',')); bdbh.TienLuongMoi = txtLuongDongBHXHMoi1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHMoi1.Text.Replace('.', ',')); bdbh.PhuCapCVMoi = txtPhuCapCVMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapCVMoi1.Text.Replace('.', ',')); bdbh.PhuCapTNNgheMoi = txtPhuCapTNNMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNNMoi1.Text.Replace('.', ',')); bdbh.PhuCapTNVKMoi = txtPhuCapTNVKMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNVKMoi1.Text.Replace('.', ',')); bdbh.TienLuongMoi = txtLuongDongBHXHMoi1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHMoi1.Text.Replace('.', ',')); if (e.ExtraParams["Command"] == "Insert") { if (hdfMaLoaiBienDong.Text == "TMD" || hdfMaLoaiBienDong.Text == "GMD") { UpdateNguocNhanVien_BaoHiem(); } } } else if (qdbd.LoaiAnhHuong == "TruyThu") { bdbh.TruyThuBHXH = nfTruyThuBHXH.Text == "" ? 0 : Convert.ToDecimal(nfTruyThuBHXH.Text.Replace('.', ',')); bdbh.TruyThuBHYT = nfTruyThuBHYT.Text == "" ? 0 : Convert.ToDecimal(nfTruyThuBHYT.Text.Replace('.', ',')); } else if (qdbd.LoaiAnhHuong == "ThoaiThu") { bdbh.ThoaiThuBHYT = nfThoaiThuBHYT.Text == "" ? 0 : Convert.ToDecimal(nfThoaiThuBHYT.Text.Replace('.', ',')); bdbh.ThoaiThuBHXH = nfThoaiThuBHXH.Text == "" ? 0 : Convert.ToDecimal(nfThoaiThuBHXH.Text.Replace('.', ',')); } else { bdbh.TienLuongCu = txtLuongDongBHXHCu1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHCu1.Text.Replace('.', ',')); bdbh.PhuCapTNVKCu = txtPhuCapTNVKCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNVKCu1.Text.Replace('.', ',')); bdbh.PhuCapNgheCu = txtPhuCapTNNCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNNCu1.Text.Replace('.', ',')); bdbh.PhuCapCVCu = txtPhuCapCVCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapCVCu1.Text.Replace('.', ',')); bdbh.TienLuongMoi = txtLuongDongBHXHMoi1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHMoi1.Text.Replace('.', ',')); bdbh.PhuCapCVMoi = txtPhuCapCVMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapCVMoi1.Text.Replace('.', ',')); bdbh.PhuCapTNNgheMoi = txtPhuCapTNNMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNNMoi1.Text.Replace('.', ',')); bdbh.PhuCapTNVKMoi = txtPhuCapTNVKMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNVKMoi1.Text.Replace('.', ',')); bdbh.TienLuongMoi = txtLuongDongBHXHMoi1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHMoi1.Text.Replace('.', ',')); } bdbh.KhongTraThe = chkKhongTraThe.Checked; bdbh.DaCoSo = chkDaCoSo.Checked; bdbh.DienGiai = txtDienGiai1.Text; qlbd.UpdateBienDongBaoHiem(bdbh); //update tinh trangg dong cho nhan vien BHNHANVIEN_BAOHIEM nvbh = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(Convert.ToInt32(hdfIdNhanVien_BaoHiem.Text)); nvbh.IDNhanVien_BaoHiem = Convert.ToInt32(hdfIdNhanVien_BaoHiem.Text); nvbh.DangDongBHXH = chkBHXH1.Checked; nvbh.DangDongBHYT = chkBHYT1.Checked; nvbh.DangDongBHTN = chkBHTN1.Checked; new NhanVien_BaoHiemController().UpdateNhanVien_BaoHiem(nvbh); Dialog.ShowNotification("Thông báo", "Đã cập nhật thành công"); if (e.ExtraParams["Close"] == "True") { wdThemSuaBienDongNhanVien.Hide(); } grpChiTietNhanVien.Reload(); grpBienDongBaoHiem.Reload(); }
// sự kiện nút lưu thêm protected void bt_addclick(object sender, DirectEventArgs e) { //get usercontrol all DAL.BHBIENDONGBAOHIEM bdbh = new DAL.BHBIENDONGBAOHIEM(); bdbh.MaNhanVien = txtMaCanBo1.Text; bdbh.HoTen = txtHoTen1.Text; bdbh.NgaySinh = Convert.ToDateTime(dfNgaySinh1.Value); bdbh.MaSo = txtSoSoBHXH1.Text; bdbh.IDQuyDinhBienDong = Convert.ToInt32(hdfIDQuyDinhBienDong.Text); bdbh.IDNhanVien_BaoHiem = Convert.ToInt32(hdfIdNhanVien_BaoHiem.Text); bdbh.TuNgay = Convert.ToDateTime(dfTuNgay1.Value); if (Radio1.Checked == true) { bdbh.TruyThuBHXH = decimal.Parse("0" + NumberField2.Text); bdbh.TruyThuBHYT = decimal.Parse("0" + NumberField3.Text); } else if (Radio2.Checked == true) { bdbh.ThoaiThuBHXH = decimal.Parse("0" + NumberField2.Text); bdbh.ThoaiThuBHYT = decimal.Parse("0" + NumberField3.Text); } if (!new SoftCore.Util().IsDateNull(dfDenNgay1.SelectedDate)) { bdbh.DenNgay = Convert.ToDateTime(dfDenNgay1.Value); } DAL.BHQUYDINHBIENDONG qdbd = new BHQUYDINHBIENDONGController().Lay1QuyDinhBienDong(bdbh.IDQuyDinhBienDong); BHNHANVIEN_BAOHIEM hs = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(hdfMaNhanVien.Value.ToString()); if (!string.IsNullOrEmpty(hs.LuongBaoHiem.ToString())) { txtLuongDongBHXHCu1.Text = hs.LuongBaoHiem.ToString(); txtLuongDongBHXHMoi1.Text = txtLuongDongBHXHCu1.Text; } if (!string.IsNullOrEmpty(hs.PhuCapCV.ToString())) { txtPhuCapCVCu1.Text = hs.PhuCapCV.ToString(); txtPhuCapCVMoi1.Text = txtPhuCapCVCu1.Text; } if (!string.IsNullOrEmpty(hs.PhuCapTNVK.ToString())) { txtPhuCapTNVKCu1.Text = hs.PhuCapTNVK.ToString(); txtPhuCapTNVKMoi1.Text = txtPhuCapTNVKCu1.Text; } if (!string.IsNullOrEmpty(hs.PhuCapTNN.ToString())) { txtPhuCapTNNCu1.Text = hs.PhuCapTNN.ToString(); txtPhuCapTNNMoi1.Text = txtPhuCapTNNCu1.Text; } if (qdbd.LoaiAnhHuong == "TMD" || qdbd.LoaiAnhHuong == "GMD") { bdbh.TienLuongCu = txtLuongDongBHXHCu1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHCu1.Text.Replace('.', ',')); bdbh.PhuCapTNVKCu = txtPhuCapTNVKCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNVKCu1.Text.Replace('.', ',')); bdbh.PhuCapNgheCu = txtPhuCapTNNCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNNCu1.Text.Replace('.', ',')); bdbh.PhuCapCVCu = txtPhuCapCVCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapCVCu1.Text.Replace('.', ',')); bdbh.TienLuongMoi = txtLuongDongBHXHMoi1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHMoi1.Text.Replace('.', ',')); bdbh.PhuCapCVMoi = txtPhuCapCVMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapCVMoi1.Text.Replace('.', ',')); bdbh.PhuCapTNNgheMoi = txtPhuCapTNNMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNNMoi1.Text.Replace('.', ',')); bdbh.PhuCapTNVKMoi = txtPhuCapTNVKMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNVKMoi1.Text.Replace('.', ',')); bdbh.TienLuongMoi = txtLuongDongBHXHMoi1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHMoi1.Text.Replace('.', ',')); } if (qdbd.LoaiAnhHuong == "TLD") { bdbh.TienLuongCu = 0; bdbh.PhuCapTNVKCu = 0; bdbh.PhuCapNgheCu = 0; bdbh.PhuCapCVCu = 0; bdbh.TienLuongMoi = txtLuongDongBHXHMoi1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHMoi1.Text.Replace('.', ',')); bdbh.PhuCapCVMoi = txtPhuCapCVMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapCVMoi1.Text.Replace('.', ',')); bdbh.PhuCapTNNgheMoi = txtPhuCapTNNMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNNMoi1.Text.Replace('.', ',')); bdbh.PhuCapTNVKMoi = txtPhuCapTNVKMoi1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNVKMoi1.Text.Replace('.', ',')); bdbh.TienLuongMoi = txtLuongDongBHXHMoi1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHMoi1.Text.Replace('.', ',')); } if (qdbd.LoaiAnhHuong == "GLD") { bdbh.TienLuongCu = txtLuongDongBHXHCu1.Text == "" ? 0 : Convert.ToDecimal(txtLuongDongBHXHCu1.Text.Replace('.', ',')); bdbh.PhuCapTNVKCu = txtPhuCapTNVKCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNVKCu1.Text.Replace('.', ',')); bdbh.PhuCapNgheCu = txtPhuCapTNNCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapTNNCu1.Text.Replace('.', ',')); bdbh.PhuCapCVCu = txtPhuCapCVCu1.Text == "" ? 0 : Convert.ToDecimal(txtPhuCapCVCu1.Text.Replace('.', ',')); bdbh.TienLuongMoi = 0; bdbh.PhuCapCVMoi = 0; bdbh.PhuCapTNNgheMoi = 0; bdbh.PhuCapTNVKMoi = 0; bdbh.TienLuongMoi = 0; } if (qdbd.LoaiAnhHuong.Contains("TruyThu")) { bdbh.TruyThuBHXH = nfTruyThuBHXH.Text == "" ? 0 : Convert.ToDecimal(nfTruyThuBHXH.Text.Replace('.', ',')); bdbh.TruyThuBHYT = nfTruyThuBHYT.Text == "" ? 0 : Convert.ToDecimal(nfTruyThuBHYT.Text.Replace('.', ',')); } if (qdbd.LoaiAnhHuong.Contains("ThoaiThu")) { bdbh.ThoaiThuBHXH = nfThoaiThuBHXH.Text == "" ? 0 : Convert.ToDecimal(nfThoaiThuBHXH.Text.Replace('.', ',')); bdbh.ThoaiThuBHYT = nfThoaiThuBHYT.Text == "" ? 0 : Convert.ToDecimal(nfThoaiThuBHYT.Text.Replace('.', ',')); } bdbh.DaCoSo = chkDaCoSo.Checked; bdbh.KhongTraThe = chkKhongTraThe.Checked; bdbh.DienGiai = txtDienGiai1.Text; bdbh.UserID = CurrentUser.ID; bdbh.MaDonVi = Session["MaDonVi"].ToString(); bdbh.DateCreate = DateTime.Now; //bdbh.ThangDangKy = DateTime.Now; if (!SoftCore.Util.GetInstance().IsDateNull(dfNgayDangKyVoiCQBH.SelectedDate)) { bdbh.ThangDangKy = (DateTime)dfNgayDangKyVoiCQBH.Value; } bdbh.ChucVu = ""; //update tinh trangg dong cho nhan vien BHNHANVIEN_BAOHIEM nvbh = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(Convert.ToInt32(hdfIdNhanVien_BaoHiem.Text)); nvbh.IDNhanVien_BaoHiem = Convert.ToInt32(hdfIdNhanVien_BaoHiem.Text); nvbh.DangDongBHXH = chkBHXH1.Checked; nvbh.DangDongBHYT = chkBHYT1.Checked; nvbh.DangDongBHTN = chkBHTN1.Checked; bdbh.NgaySinh = nvbh.NgaySinh; bdbh.GioiTinh = nvbh.GioiTinh ?? true; bdbh.Loai = qdbd.LoaiAnhHuong; new QuanLyBienDongBaoHiemController().InsertBienDongBaoHiem(bdbh); new NhanVien_BaoHiemController().UpdateNhanVien_BaoHiem(nvbh); Dialog.ShowNotification("Thông báo", "Đã cập nhật thành công"); if (e.ExtraParams["Command"] == "Insert") { if (hdfMaLoaiBienDong.Text == "TMD" || hdfMaLoaiBienDong.Text == "GMD") { UpdateNguocNhanVien_BaoHiem(); } } if (e.ExtraParams["Close"] == "True") { //wdThemSuaBienDongNhanVien.Hide(); wdThemSuaBienDongNhanVien.Hide(); } grpChiTietNhanVien.Reload(); grpBienDongBaoHiem.Reload(); // update ngược lại bảng NHANVIEN_BAOHIEM }
//sự kiện nhấn nút lưu sửa public void btnSuaThongTin_Click(object sender, DirectEventArgs e) { NhanVien_BaoHiemController nvc = new NhanVien_BaoHiemController(); DAL.BHNHANVIEN_BAOHIEM nvbh = nvc.GetNhanVien_BaoHiemByMaNhanVien(hdfIDNhanVienBaoHiem.Text); if (txtHoTenMoi.Text != "") { nvbh.HoTen = txtHoTenMoi.Text; nvbh.Ten = new CommonUtil().GetFirstNamFromFullName(txtHoTenMoi.Text); } if (!string.IsNullOrEmpty(nfNgayMoi.Text) && !string.IsNullOrEmpty(nfThangMoi.Text) && !string.IsNullOrEmpty(nfNamMoi.Text)) { nvbh.NgaySinh = new DateTime(int.Parse(nfNamMoi.Text), int.Parse(nfThangMoi.Text), int.Parse(nfNgayMoi.Text)); } if (cbbGioiTinhMoi.SelectedIndex > -1) { nvbh.GioiTinh = cbbGioiTinhMoi.Value.ToString() != "0"; } if (!string.IsNullOrEmpty(txtSoCMNDMoi.Text)) { nvbh.SoCMTND = txtSoCMNDMoi.Text; } if (!string.IsNullOrEmpty(nfNgayCapMoi.Text) && !string.IsNullOrEmpty(nfThangCapMoi.Text) && !string.IsNullOrEmpty(nfNamCapMoi.Text)) { nvbh.NgayCapCMTND = new DateTime(int.Parse(nfNamCapMoi.Text), int.Parse(nfThangCapMoi.Text), int.Parse(nfNgayCapMoi.Text)); } if (cbbNoiCapCMNDMoi.SelectedIndex > -1) { nvbh.NoiCapCMTND = cbbNoiCapCMNDMoi.Value.ToString(); } if (!string.IsNullOrEmpty(txtDiaChiMoi.Text)) { nvbh.DiaChiLienHe = txtDiaChiMoi.Text; } nvbh.NoiDangKyKCB = txtNoiDangKyKCBMoi.Value == null ? "" : txtNoiDangKyKCBMoi.Value.ToString(); nvbh.SoTheBHYT = txtSoTheBHYTSua.Text; nvbh.TuThangBHYT = bhc.SetValueDatetime(spinTuNamBHYTSua, cbbTuThangBHYTSua, 1); nvbh.DenThangBHYT = bhc.SetValueDatetime(spinDenNamBHYTSua, cbbDenThangBHYTSua, 1); nvbh.BHXHTrangThaiDangKyCQBH = chkDaDangKyCQBHSua.Checked; nvbh.NgayDangKyBHXH = bhc.SetValueDatetime(spinNamDangKyBHXHSua, cbbThangDangKyBHXHSua, 1); nvbh.DangDongBHXH = chkDongBHXH.Checked; nvbh.DangDongBHYT = chkDongBHYT.Checked; nvbh.DangDongBHTN = chkDongBHTN.Checked; //nvbh.TrangThaiCapSoBHXH = cbbTrangThaiCapSoSua.SelectedItem.Value; nvbh.TrangThaiCapSoBHXH = hdfTrangThaiCapSoSua.Text; //nvbh.TrangThaiCapTheBHYT = cboTrangThaiCapThe.SelectedItem.Value; nvbh.TrangThaiCapTheBHYT = hdfTrangThaiCapThe.Text; nvbh.NoiCapSoBHXH = hdfNoiCapSoBHXHSua.Text; nvbh.SoSoBHXH = txtSoSoBHXHSua.Text; if (!string.IsNullOrEmpty(txtLuongBaoHiemSua.Text)) { nvbh.LuongBaoHiem = decimal.Parse(txtLuongBaoHiemSua.Text); } if (!string.IsNullOrEmpty(txtPhuCapCVSua.Text)) { nvbh.PhuCapCV = decimal.Parse(txtPhuCapCVSua.Text); } if (!string.IsNullOrEmpty(txtPhuCapKhacSua.Text)) { nvbh.PhuCapKhac = decimal.Parse(txtPhuCapKhacSua.Text); } if (!string.IsNullOrEmpty(txtPhuCapTNNgheSua.Text)) { nvbh.PhuCapTNN = decimal.Parse(txtPhuCapTNNgheSua.Text); } if (!string.IsNullOrEmpty(txtPhuCapTNVKSua.Text)) { nvbh.PhuCapTNVK = decimal.Parse(txtPhuCapTNVKSua.Text); } //if (dfNgayCapSoBHXHSua.Value != null && !dfNgayCapSoBHXHSua.SelectedDate.ToString().Contains("0001")) // nvbh.NgayCapSoBHXH = dfNgayCapSoBHXHSua.SelectedDate; if (!Util.GetInstance().IsDateNull(dfNgayCapSoBHXHSua.SelectedDate)) { nvbh.NgayCapSoBHXH = dfNgayCapSoBHXHSua.SelectedDate; } int thangold = nvbh.ThoiGianDongBHXHTruocKhiVaoCongTy; nvbh.ThoiGianDongBHXHTruocKhiVaoCongTy = int.Parse(nfSoThangDongTruocSua.Text == "" ? "0" : nfSoThangDongTruocSua.Text) + int.Parse(nfSoNamDongTruocSua.Text == "" ? "0" : nfSoNamDongTruocSua.Text) * 12; nvbh.ThoiGianDongBaoHiem = (nvbh.ThoiGianDongBaoHiem - thangold) + nvbh.ThoiGianDongBHXHTruocKhiVaoCongTy; nvc.UpdateNhanVien_BaoHiem(nvbh); #region update ngược lại bảng hồ sơ var hsc = new HoSoController(); DAL.HOSO hoso = hsc.GetByMaCB(hdfIDNhanVienBaoHiem.Text); if (!string.IsNullOrEmpty(txtHoTenMoi.Text)) { hoso.HO_TEN = txtHoTenMoi.Text; hoso.TEN_CB = new CommonUtil().GetFirstNamFromFullName(txtHoTenMoi.Text); } else { hoso.HO_TEN = txtHoTenCu.Text; } if (!string.IsNullOrEmpty(nfNgayMoi.Text) && !string.IsNullOrEmpty(nfThangMoi.Text) && !string.IsNullOrEmpty(nfNamMoi.Text)) { hoso.NGAY_SINH = new DateTime(int.Parse(nfNamMoi.Text), int.Parse(nfThangMoi.Text), int.Parse(nfNgayMoi.Text)); } else if (!string.IsNullOrEmpty(nfNgayCu.Text) && !string.IsNullOrEmpty(nfThangCu.Text) && !string.IsNullOrEmpty(nfNamCu.Text)) { hoso.NGAY_SINH = new DateTime(int.Parse(nfNamCu.Text), int.Parse(nfThangCu.Text), int.Parse(nfNgayCu.Text)); } if (cbbGioiTinhMoi.SelectedIndex > -1) { hoso.MA_GIOITINH = cbbGioiTinhMoi.Value.ToString() == "0" ? "F" : "M"; } else { hoso.MA_GIOITINH = cbbGioiTinhCu.Value.ToString() == "0" ? "F" : "M"; } if (!string.IsNullOrEmpty(txtSoCMNDMoi.Text)) { hoso.SO_CMND = txtSoCMNDMoi.Text; } else { hoso.SO_CMND = txtSoCMNDCu.Text; } if (!string.IsNullOrEmpty(nfNgayCapMoi.Text) && !string.IsNullOrEmpty(nfThangCapMoi.Text) && !string.IsNullOrEmpty(nfNamCapMoi.Text)) { hoso.NGAYCAP_CMND = new DateTime(int.Parse(nfNamCapMoi.Text), int.Parse(nfThangCapMoi.Text), int.Parse(nfNgayCapMoi.Text)); } else if (!string.IsNullOrEmpty(nfNgayCapCu.Text) && !string.IsNullOrEmpty(nfThangCapCu.Text) && !string.IsNullOrEmpty(nfNamCapCu.Text)) { hoso.NGAYCAP_CMND = new DateTime(int.Parse(nfNamCapCu.Text), int.Parse(nfThangCapCu.Text), int.Parse(nfNgayCapCu.Text)); } if (cbbNoiCapCMNDMoi.SelectedIndex > -1) { hoso.MA_NOICAP_CMND = cbbNoiCapCMNDMoi.Value.ToString(); } if (!string.IsNullOrEmpty(txtDiaChiMoi.Text)) { hoso.DIA_CHI_LH = txtDiaChiMoi.Text; } else { hoso.DIA_CHI_LH = txtDiaChiCu.Text; } if (!string.IsNullOrEmpty(hdfNoiDungKyKCBMoi.Text)) { hoso.MA_NOI_KCB = hdfNoiDungKyKCBMoi.Text; } if (!string.IsNullOrEmpty(txtSoTheBHYTSua.Text)) { hoso.SOTHE_BHYT = txtSoTheBHYTSua.Text; } if (cbbTuThangBHYTSua.SelectedIndex > -1 && !string.IsNullOrEmpty(spinTuNamBHYTSua.Value.ToString())) { hoso.NGAY_DONGBH = new DateTime(int.Parse(spinTuNamBHYTSua.Text), int.Parse(cbbTuThangBHYTSua.Value.ToString()), 1); } if (cbbDenThangBHYTSua.SelectedIndex > -1 && !string.IsNullOrEmpty(spinDenNamBHYTSua.Value.ToString())) { hoso.NGAY_HETHAN_BHYT = new DateTime(int.Parse(spinDenNamBHYTSua.Text), int.Parse(cbbDenThangBHYTSua.Value.ToString()), 1); } //nvbh.NoiCapSoBHXH = txtNoiCapSoBHXHSua.Text; if (!string.IsNullOrEmpty(txtSoSoBHXHSua.Text)) { hoso.SOTHE_BHXH = txtSoSoBHXHSua.Text; } hsc.UpDateHoSoBaoHiem(hoso); #endregion grpQuanLyThongTinBaoHiem.Reload(); wdThayDoiThongTin.Hide(); }
[DirectMethod] // sự kiện khi nháy vào nút sửa hoặc dbclick public void SuaThongTinNhanVien(string manhanvien) { TabPanel1.ActiveTab = pnlThongTinChung; DAL.BHNHANVIEN_BAOHIEM nvbh = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(manhanvien); DAL.HOSO hoso = new HoSoController().GetByMaCB(manhanvien); txtHoTenCu.Text = nvbh.HoTen; if (nvbh.NgaySinh != null && !nvbh.NgaySinh.ToString().Contains("0001")) { nfNgayCu.Value = DateTime.Parse(nvbh.NgaySinh.ToString()).Day; nfThangCu.Value = DateTime.Parse(nvbh.NgaySinh.ToString()).Month; nfNamCu.Value = DateTime.Parse(nvbh.NgaySinh.ToString()).Year; } cbbGioiTinhCu.Value = nvbh.GioiTinh == false ? 0 : 1; txtSoCMNDCu.Text = hoso.SO_CMND; cbbNoiCapCMNDCu.Text = new DM_NOICAP_CMNDController().GetTenByMa(nvbh.NoiCapCMTND); // txtSoCMNDCu.Text = nvbh.SoCMTND; if (nvbh.NgayCapCMTND != null && !nvbh.NgayCapCMTND.ToString().Contains("0001")) { nfNgayCapCu.Value = DateTime.Parse(nvbh.NgayCapCMTND.ToString()).Day; nfThangCapCu.Value = DateTime.Parse(nvbh.NgayCapCMTND.ToString()).Month; nfNamCapCu.Value = DateTime.Parse(nvbh.NgayCapCMTND.ToString()).Year; } txtDiaChiCu.Text = nvbh.DiaChiLienHe; txtNoiDangKyKCBCu.Text = new DM_NOI_KCBController().GetTenByMa(nvbh.NoiDangKyKCB); if (nvbh.HoTen != hoso.HO_TEN) { txtHoTenMoi.Text = hoso.HO_TEN; } if (nvbh.NgaySinh != hoso.NGAY_SINH) { if (hoso.NGAY_SINH != null && !hoso.NGAY_SINH.ToString().Contains("0001")) { nfNgayMoi.Value = DateTime.Parse(hoso.NGAY_SINH.ToString()).Day; nfThangMoi.Value = DateTime.Parse(hoso.NGAY_SINH.ToString()).Month; nfNamMoi.Value = DateTime.Parse(hoso.NGAY_SINH.ToString()).Year; } } if (nvbh.GioiTinh != (hoso.MA_GIOITINH != "F")) { cbbGioiTinhMoi.Value = (hoso.MA_GIOITINH != "F"); } if (nvbh.SoCMTND != hoso.SO_CMND) { txtSoCMNDMoi.Text = nvbh.SoCMTND; } if (nvbh.NgayCapCMTND != hoso.NGAYCAP_CMND) { if (hoso.NGAYCAP_CMND != null && !hoso.NGAYCAP_CMND.ToString().Contains("0001")) { nfNgayCapMoi.Value = DateTime.Parse(hoso.NGAYCAP_CMND.ToString()).Day; nfThangCapMoi.Value = DateTime.Parse(hoso.NGAYCAP_CMND.ToString()).Month; nfNamCapMoi.Value = DateTime.Parse(hoso.NGAYCAP_CMND.ToString()).Year; } } if (hoso.MA_NOICAP_CMND != null) { if (nvbh.NoiCapCMTND != hoso.MA_NOICAP_CMND) { cbbNoiCapCMNDMoi.Value = hoso.MA_NOICAP_CMND; } } if (nvbh.DiaChiLienHe != hoso.DIA_CHI_LH) { txtDiaChiMoi.Text = hoso.DIA_CHI_LH; } if (nvbh.NoiDangKyKCB != hoso.MA_NOI_KCB) { txtNoiDangKyKCBMoi.Text = new DM_NOI_KCBController().GetTenByMa(hoso.MA_NOI_KCB); txtNoiDangKyKCBMoi.SelectedItem.Value = hoso.MA_NOI_KCB; } //txtNoiDangKyKCBMoi.Value = hoso.MA_NOI_KCB; txtLuongBaoHiemSua.Text = nvbh.LuongBaoHiem.ToString(); txtPhuCapCVSua.Text = nvbh.PhuCapCV.ToString(); txtPhuCapKhacSua.Text = nvbh.PhuCapKhac.ToString(); txtPhuCapTNNgheSua.Text = nvbh.PhuCapTNN.ToString(); txtPhuCapTNVKSua.Text = nvbh.PhuCapTNVK.ToString(); txtSoTheBHYTSua.Text = nvbh.SoTheBHYT; if (!Util.GetInstance().IsDateNull(nvbh.TuThangBHYT)) { cbbTuThangBHYTSua.Value = nvbh.TuThangBHYT.Value.Month; spinTuNamBHYTSua.Value = nvbh.TuThangBHYT.Value.Year; } if (!Util.GetInstance().IsDateNull(nvbh.DenThangBHYT)) { cbbDenThangBHYTSua.Value = nvbh.DenThangBHYT.Value.Month; spinDenNamBHYTSua.Value = nvbh.DenThangBHYT.Value.Year; } chkDaDangKyCQBHSua.Checked = bool.Parse(nvbh.BHXHTrangThaiDangKyCQBH.ToString()); if (nvbh.NgayDangKyBHXH != null && !nvbh.NgayDangKyBHXH.ToString().Contains("0001")) { cbbThangDangKyBHXHSua.Value = nvbh.NgayDangKyBHXH.Value.Month; spinNamDangKyBHXHSua.Value = nvbh.NgayDangKyBHXH.Value.Year; } if (!string.IsNullOrEmpty(nvbh.TrangThaiCapSoBHXH)) { cbbTrangThaiCapSoSua.Value = nvbh.TrangThaiCapSoBHXH; hdfTrangThaiCapSoSua.SetValue(nvbh.TrangThaiCapSoBHXH); } if (!string.IsNullOrEmpty(nvbh.TrangThaiCapTheBHYT)) { cboTrangThaiCapThe.Value = nvbh.TrangThaiCapTheBHYT; hdfTrangThaiCapThe.SetValue(nvbh.TrangThaiCapTheBHYT); } else { hdfTrangThaiCapThe.SetValue("ChuaCapThe"); } //txtNoiCapSoBHXHSua.Text = nvbh.NoiCapSoBHXH; if (!string.IsNullOrEmpty(nvbh.NoiCapSoBHXH)) { hdfNoiCapSoBHXHSua.Text = nvbh.NoiCapSoBHXH; txtNoiCapSoBHXHSua.Text = new DM_NOICAPBAOHIEMXHController().GetTenByMa(nvbh.NoiCapSoBHXH); } if (!string.IsNullOrEmpty(nvbh.SoSoBHXH)) { txtSoSoBHXHSua.Text = nvbh.SoSoBHXH; } if (nvbh.NgayCapSoBHXH != null && !nvbh.NgayCapSoBHXH.ToString().Contains("0001")) { dfNgayCapSoBHXHSua.SetValue(nvbh.NgayCapSoBHXH); } chkDongBHXH.Checked = nvbh.DangDongBHXH; chkDongBHYT.Checked = nvbh.DangDongBHYT; chkDongBHTN.Checked = nvbh.DangDongBHTN; nfSoThangDongTruocSua.Text = (nvbh.ThoiGianDongBHXHTruocKhiVaoCongTy % 12).ToString(); nfSoNamDongTruocSua.Text = (nvbh.ThoiGianDongBHXHTruocKhiVaoCongTy / 12).ToString(); RM.RegisterClientScriptBlock("rsSinhNoiDung", "SinhNoiDung();"); wdThayDoiThongTin.Show(); }
//lưu nhân viên đóng mới public void btnLuuThem_Click(object sender, DirectEventArgs e) { //Kiểm tra nhân viên này đã được lưu ở trên bảng BHNhanVien_BaoHiem chưa NhanVien_BaoHiemController nbc = new NhanVien_BaoHiemController(); if (new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(txtMaCanBo.Text) != null) { RM.RegisterClientScriptBlock("relTrungCanBo", " alert('Cán bộ này đã được quản lý ở phân hệ bảo hiểm');"); return; } if (nfSoThangDongTruocThem.Text == "") { RM.RegisterClientScriptBlock("relChuaNhapThoiGian", " alert('Bạn chưa nhập thời gian đóng trước khi vào công ty cho cán bộ này');"); } // Lưu thông tin vào bảng bhNhanVien_BaoHiem NhanVien_BaoHiemController nvc = new NhanVien_BaoHiemController(); HoSoController hsc = new HoSoController(); DAL.HOSO hoso = hsc.GetByMaCB(txtMaCanBo.Text); DAL.BHNHANVIEN_BAOHIEM nvbh = new DAL.BHNHANVIEN_BAOHIEM(); nvbh.IDNhanVien_BaoHiem = int.Parse(hoso.PR_KEY.ToString()); nvbh.MaNhanVien = hoso.MA_CB; nvbh.HoTen = hoso.HO_TEN; nvbh.Ten = new CommonUtil().GetFirstNamFromFullName(hoso.HO_TEN); nvbh.GioiTinh = hoso.MA_GIOITINH != "F"; nvbh.NgaySinh = hoso.NGAY_SINH; nvbh.HoKhauThuongTruTamTru = hoso.HO_KHAU; nvbh.DiaChiLienHe = hoso.DIA_CHI_LH; nvbh.SoCMTND = hoso.SO_CMND; nvbh.NgayCapCMTND = new SoftCore.Util().IsDateNull(hoso.NGAYCAP_CMND) ? null : hoso.NGAYCAP_CMND; nvbh.NoiCapCMTND = hoso.MA_NOICAP_CMND ?? ""; nvbh.MaChucVu = hoso.MA_CHUCVU; nvbh.LuongBaoHiem = decimal.Parse(nfLuongBaoHiem.Value.ToString()); nvbh.LoaiBHYT = ""; string[] arr = hdfPhuCap.Text.Split(';'); nvbh.PhuCapCV = int.Parse(arr[0]); nvbh.PhuCapKhac = int.Parse(arr[3]); nvbh.PhuCapTNVK = int.Parse(arr[2]); nvbh.PhuCapTNN = int.Parse(arr[1]); // hdfPhuCap.Text = phucapcv.ToString() + ";" + phucaptnn.ToString() + ";" + phucaptnvk.ToString() + ";" + phucapkhac.ToString(); nvbh.NoiDangKyKCB = hoso.MA_NOI_KCB; nvbh.SoTheBHYT = txtSoTheBHYT.Text; nvbh.TuThangBHYT = new BaoHiemController().SetValueDatetime(spinTuNamBHYT, cbbTuThangBHYT, 1); nvbh.DenThangBHYT = new BaoHiemController().SetValueDatetime(spinDenNamBHYT, cbbDenThangBHYT, 1); nvbh.BHXHTrangThaiDangKyCQBH = chkTrangThaiDangKy.Checked; nvbh.NgayDangKyBHXH = new BaoHiemController().SetValueDatetime(spinNamBHXH, cbbThangBHXH, 1); //nvbh.TrangThaiCapSoBHXH = cbbTrangthaiCapSo.SelectedItem.Value ?? "ChuaCapSo"; nvbh.TrangThaiCapSoBHXH = hdfTrangThaiCapSo.Text; //nvbh.TrangThaiCapTheBHYT = cbbTrangThaiCapThe.SelectedItem.Value ?? "ChuaCapThe"; nvbh.TrangThaiCapTheBHYT = hdfTrangThaiCapThe.Text; nvbh.NoiCapSoBHXH = txtNoiCapSoBHXH.Text; nvbh.SoSoBHXH = txtSoSoBHXH.Text; if (!util.IsDateNull(dfNgayCapSo.SelectedDate)) { nvbh.NgayCapSoBHXH = dfNgayCapSo.SelectedDate; } nvbh.DangDongBHXH = chkBHXH.Checked; nvbh.DangDongBHYT = chkBHYT.Checked; nvbh.DangDongBHTN = chkBHTN.Checked; nvbh.ThoiGianDongBHXHTruocKhiVaoCongTy = int.Parse(nfSoThangDongTruocThem.Text == "" ? "0" : nfSoThangDongTruocThem.Text) + int.Parse(nfSoNamDongTruocThem.Text == "" ? "0" : nfSoNamDongTruocThem.Text) * 12; //nvbh.ThoiGianDongBaoHiem = nvc.TinhSoThangDongBaoHiem(nvbh.IDNhanVien_BaoHiem, nvbh.ThoiGianDongBHXHTruocKhiVaoCongTy); nvbh.ThoiGianDongBaoHiem = nvbh.ThoiGianDongBHXHTruocKhiVaoCongTy; nvbh.MaDonVi = Session["MaDonVi"].ToString(); nvbh.UserID = CurrentUser.ID; nvbh.DateCreate = DateTime.Now; QuanLyThongTinBaoHiemController qlc = new QuanLyThongTinBaoHiemController(); qlc.LuuNhanVienDongMoi(nvbh); Dialog.ShowNotification("Cập nhật dữ liệu thành công"); if (e.ExtraParams["Close"] == "True") { wdThongTinDongBHNhanVien.Hide(); RM.RegisterClientScriptBlock("rs30", "grpQuanLyThongTinBaoHiem_store.reload();"); } else { RM.RegisterClientScriptBlock("rs32", "grpQuanLyThongTinBaoHiem_store.reload();"); } RM.RegisterClientScriptBlock("rs31", "resetFormThem();"); }
public void BindData(ReportFilter rp) { //string filter dạng hoten_bh,ngaysinh_bh,thangsinh_bh,namsinh_bh,gioitinh_bh,socmnd_bh,ngaycmnd_bh,thangcmnd_bh,namcmnd_bh,noicapcmnd_bh,diachi_bh,noidangky_bh,noidungthaydoi,manhanvien_baohiem string hoten_bh = rp.WhereClause.Split(',')[0]; string ngaysinh_bh = rp.WhereClause.Split(',')[1]; string thangsinh_bh = rp.WhereClause.Split(',')[2]; string namsinh_bh = rp.WhereClause.Split(',')[3]; string gioitinh_bh = rp.WhereClause.Split(',')[4]; string socmnd_bh = rp.WhereClause.Split(',')[5]; string ngaycmnd_bh = rp.WhereClause.Split(',')[6]; string thangcmnd_bh = rp.WhereClause.Split(',')[7]; string namcmnd_bh = rp.WhereClause.Split(',')[8]; string noicapcmnd_bh = rp.WhereClause.Split(',')[9]; string diachi_bh = rp.WhereClause.Split(',')[10]; string noidangky_bh = rp.WhereClause.Split(',')[11]; string noidungthaydoi = rp.WhereClause.Split(',')[12]; string manhanvien_baohiem = rp.WhereClause.Split(',')[13]; DAL.BHNHANVIEN_BAOHIEM nvbh = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(manhanvien_baohiem); if (!string.IsNullOrEmpty(hoten_bh)) { xrlhoten.Text = "- Tên tôi là (viết chữ in hoa có dấu): " + hoten_bh.ToUpper(); } else { if (!string.IsNullOrEmpty(nvbh.HoTen)) { xrlhoten.Text = "- Tên tôi là (viết chữ in hoa có dấu): " + nvbh.HoTen.ToUpper(); } } if (!string.IsNullOrEmpty(ngaysinh_bh) && !string.IsNullOrEmpty(thangsinh_bh) && !string.IsNullOrEmpty(namsinh_bh)) { xrlnamsinh.Text = "- Ngày tháng năm sinh: " + ngaysinh_bh + "/" + thangsinh_bh + "/" + namsinh_bh; } else { if (nvbh.NgaySinh != null && !nvbh.NgaySinh.ToString().Contains("0001")) { xrlnamsinh.Text = "- Ngày tháng năm sinh: " + Convert.ToDateTime(nvbh.NgaySinh).Day + "/" + Convert.ToDateTime(nvbh.NgaySinh).Month + "/" + Convert.ToDateTime(nvbh.NgaySinh).Year; } } if (!string.IsNullOrEmpty(gioitinh_bh)) { if (gioitinh_bh == "0") { xrlgioitinh.Text = "Giới tính: " + "Nữ"; } else { xrlgioitinh.Text = "Giới tính: " + "Nam"; } } else { if (!string.IsNullOrEmpty(nvbh.GioiTinh.ToString())) { if (nvbh.GioiTinh == true) { xrlgioitinh.Text = "Giới tính: " + "Nam"; } else { xrlgioitinh.Text = "Giới tính: " + "Nữ"; } } } string tendonvi = new DM_DONVIController().GetNameById(nvbh.MaDonVi); if (!string.IsNullOrEmpty(tendonvi)) { xrldonvi.Text = "- Đơn vị: " + tendonvi; } if (!string.IsNullOrEmpty(socmnd_bh)) { xrlcmt.Text = "- CMT số: " + socmnd_bh; } else { if (!string.IsNullOrEmpty(nvbh.SoCMTND)) { xrlcmt.Text = "- CMT số: " + nvbh.SoCMTND; } } if (!string.IsNullOrEmpty(noicapcmnd_bh)) { xrlnoicap.Text = "nơi cấp: " + noicapcmnd_bh; } else { if (!string.IsNullOrEmpty(nvbh.NoiCapCMTND)) { xrlnoicap.Text = "nơi cấp: " + nvbh.NoiCapCMTND; } } if (!string.IsNullOrEmpty(ngaycmnd_bh) && !string.IsNullOrEmpty(thangcmnd_bh) && !string.IsNullOrEmpty(namcmnd_bh)) { xrlngaycap.Text = "ngày cấp: " + ngaycmnd_bh + "/" + thangcmnd_bh + "/" + namcmnd_bh; } else { // txtSoCMNDCu.Text = nvbh.SoCMTND; if (nvbh.NgayCapCMTND != null && !nvbh.NgayCapCMTND.ToString().Contains("0001")) { xrlngaycap.Text = "ngày cấp: " + Convert.ToDateTime(nvbh.NgayCapCMTND).Day + "/" + Convert.ToDateTime(nvbh.NgayCapCMTND).Month + "/" + Convert.ToDateTime(nvbh.NgayCapCMTND).Year; } } if (!string.IsNullOrEmpty(noidungthaydoi)) { xrlnoidungthaydoi.Text = noidungthaydoi; } }
/// <summary> /// Cập nhật lại các thủ tục /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void CapNhatThuTuc_Click(object sender, DirectEventArgs e) { try { // upload file string path = string.Empty; if (fufTepTinDinhKem.HasFile) { string directory = Server.MapPath(""); path = UploadFile(fufTepTinDinhKem, "File/ThoiViec"); } // cập nhật thủ tục DAL.DanhSachCanBoThoiViec tv = new DAL.DanhSachCanBoThoiViec(); tv.ID = int.Parse("0" + hdfRecordID.Text); if (!dfNgayNghi.SelectedDate.ToString().Contains("0001")) { tv.NgayNghi = dfNgayNghi.SelectedDate; } if (cbx_lydonghi.SelectedItem.Value != null) { tv.MaLyDoNghi = cbx_lydonghi.SelectedItem.Value; } tv.DaTraTheBHYT = bool.Parse(cbTraTheBHYT.SelectedItem.Value); if (!dfNgayTraThe.SelectedDate.ToString().Contains("0001")) { tv.NgayTraThe = dfNgayTraThe.SelectedDate; } tv.DaTraSoBHXH = bool.Parse(cbSoBHXH.SelectedItem.Value); if (!dfNgayTraSo.SelectedDate.ToString().Contains("0001")) { tv.NgayTraSo = dfNgayTraSo.SelectedDate; } if (hdfCanBoDuyet.Text != "") { tv.FrCBDuyetNghi = decimal.Parse("0" + hdfCanBoDuyet.Text); } tv.IsBelongToBlackList = chkThemVaoDsHanChe.Checked; if (cbxLyDoHanChe.SelectedItem.Value != null) { tv.MaLyDoBiHanChe = int.Parse(cbxLyDoHanChe.SelectedItem.Value); } tv.DaHoanThanhThuTuc = chkHoanTatThuTuc.Checked; tv.GhiChu = txtGhiChuTV.Text; tv.SoQuyetDinh = txtSoQuyetDinh.Text; if (path != "") { tv.AttachFile = path; } else { tv.AttachFile = hdfTepTinDinhKem.Text; } // if (tv.DaHoanThanhThuTuc == true) // { //bool htTaiSan = new BanGiaoTaiSanController().KiemTraHoanThanhBGTaiSan(tv.ID); //if (htTaiSan == false) //{ // X.Msg.Alert("Thông báo", "Bạn không thể cập nhật trạng thái Hoàn tất thủ tục khi chưa hoàn thành bàn giao tất cả tài sản").Show(); // return; //} //bool htCongNo = new ThanhToanCongNoController().KiemTraHoanThanhCongNo(tv.ID); //if (htCongNo == false) //{ // X.Msg.Alert("Thông báo", "Bạn không thể cập nhật trạng thái Hoàn tất thủ tục khi chưa hoàn thành thanh toán công nợ").Show(); // return; //} // } new DanhSachCanBoThoiViecController().UpdateThuTuc(tv); if (tv.DaHoanThanhThuTuc == true) { // cập nhật trạng thái đã nghỉ trong bảng HOSO DAL.HOSO hs = new DAL.HOSO(); DAL.DanhSachCanBoThoiViec ds = new DanhSachCanBoThoiViecController().GetByID(tv.ID); hs.PR_KEY = ds.PrKeyHoSo; hs.DA_NGHI = true; hs.NGAY_NGHI = tv.NgayNghi; hs.MA_LYDO_NGHI = tv.MaLyDoNghi; new DanhSachCanBoThoiViecController().UpdateNghiViecHoSo(hs); // cập nhật thông tin bảo hiểm nhân viên (trạng thái đã trả thẻ hay chưa) DAL.BHNHANVIEN_BAOHIEM nvbh = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByIDNhanVien_BaoHiem(int.Parse(ds.PrKeyHoSo.ToString())); if (nvbh != null) { if (tv.DaTraSoBHXH == true) { nvbh.TrangThaiCapSoBHXH = "DaTraSo"; } if (tv.DaTraTheBHYT == true) { nvbh.TrangThaiCapTheBHYT = "DaTraThe"; } new NhanVien_BaoHiemController().UpdateNhanVien_BaoHiem(nvbh); } } RM.RegisterClientScriptBlock("rsl", "Store1.reload();wdCapNhatThuTuc.hide(); LoadDataInSouthPanel();"); } catch (Exception ex) { X.Msg.Alert("Thông báo", "Có lỗi xảy ra: " + ex.Message.ToString()).Show(); } }