public void KhongDuyet(int userID, string lyDoKhongDuyet, decimal prKeyNguoiDuyet)
{
DAL.HOSO_TUCAPNHAT tmp = GetByPrKey(userID);
if (tmp != null)
{
tmp.LyDoKhongDuyet = lyDoKhongDuyet;
tmp.NgayDuyet = DateTime.Now;
tmp.TrangThaiDuyet = "KhongDuyet";
tmp.PrkeyNguoiDuyet = prKeyNguoiDuyet;
Save();
}
}
/// <summary>
/// Duyệt và chuyển thông tin sang form hồ sơ
/// </summary>
/// <param name="userID"></param>
/// <param name="prKeyNguoiDuyet"></param>
/// <returns>trả về khóa chính của bản ghi mới</returns>
public decimal CopyToHoSo(int userID, decimal prKeyNguoiDuyet, string thongTinThem, string maDV)
{
bool isInsert = false;
DAL.HOSO hs = dataContext.HOSOs.Where(t => t.UserID == userID).FirstOrDefault();
DAL.HOSO_TUCAPNHAT tuCapNhat = GetByUserId(userID);
if (hs == null)
{
hs = new DAL.HOSO();
isInsert = true;
hs.MA_CB = new HoSoController().GenerateMaCB(maDV);
}
hs.BI_DANH = tuCapNhat.BI_DANH;
hs.CAN_NANG = tuCapNhat.CAN_NANG;
hs.CHIEU_CAO = tuCapNhat.CHIEU_CAO;
hs.ChucVuCongDoan = tuCapNhat.ChucVuCongDoan;
hs.DaThamGiaQuanDoi = tuCapNhat.DaThamGiaQuanDoi;
hs.DI_DONG = tuCapNhat.DI_DONG;
hs.DIA_CHI_LH = tuCapNhat.DIA_CHI_LH;
hs.DiaChiNguoiLienHe = tuCapNhat.DiaChiNguoiLienHe;
hs.EMAIL = tuCapNhat.EMAIL;
hs.EMAIL_RIENG = tuCapNhat.EMAIL_RIENG;
hs.DT_CQUAN = tuCapNhat.DT_CQUAN;
hs.DT_NHA = tuCapNhat.DT_NHA;
hs.EmailNguoiLienHe = tuCapNhat.EmailNguoiLienHe;
hs.HangThuongTat = tuCapNhat.HangThuongTat;
hs.HinhThucThuongTat = tuCapNhat.HinhThucThuongTat;
hs.HO_CB = tuCapNhat.HO_CB;
hs.HO_KHAU = tuCapNhat.HO_KHAU;
hs.HO_TEN = tuCapNhat.HO_TEN;
hs.LaDangVien = tuCapNhat.LaDangVien;
hs.LaThuongBinh = tuCapNhat.LaThuongBinh;
hs.MA_CAPBAC_QDOI = tuCapNhat.MA_CAPBAC_QDOI;
hs.MA_CHUCVU = tuCapNhat.MA_CHUCVU;
hs.MA_CHUCVU_DANG = tuCapNhat.MA_CHUCVU_DANG;
hs.MA_CHUCVU_DOAN = tuCapNhat.MA_CHUCVU_DOAN;
hs.MA_CHUCVU_QDOI = tuCapNhat.MA_CHUCVU_QDOI;
hs.MA_CHUYENNGANH = tuCapNhat.MA_CHUYENNGANH;
hs.MA_CONGTRINH = tuCapNhat.MA_CONGTRINH;
hs.MA_CONGVIEC = tuCapNhat.MA_CONGVIEC;
hs.MA_DANTOC = tuCapNhat.MA_DANTOC;
hs.MA_DONVI = tuCapNhat.MA_DONVI;
hs.MA_GIOITINH = tuCapNhat.MA_GIOITINH;
hs.MA_HT_TUYENDUNG = tuCapNhat.MA_HT_TUYENDUNG;
hs.MA_LOAI_CS = tuCapNhat.MA_LOAI_CS;
hs.MA_LOAI_HDONG = tuCapNhat.MA_LOAI_HDONG;
hs.MA_NGACH = tuCapNhat.MA_NGACH;
hs.MA_NGOAINGU = tuCapNhat.MA_NGOAINGU;
hs.MA_NOI_KCB = tuCapNhat.MA_NOI_KCB;
hs.MA_NOICAP_BHXH = tuCapNhat.MA_NOICAP_BHXH;
hs.MA_NOICAP_CMND = tuCapNhat.MA_NOICAP_CMND;
hs.MA_NOICAP_HOCHIEU = tuCapNhat.MA_NOICAP_HOCHIEU;
hs.MA_NUOC = tuCapNhat.MA_NUOC;
hs.MA_TD_CHINHTRI = tuCapNhat.MA_TD_CHINHTRI;
hs.MA_TD_QLKT = tuCapNhat.MA_TD_QLKT;
hs.MA_TD_QUANLY = tuCapNhat.MA_TD_QUANLY;
hs.MA_TD_VANHOA = tuCapNhat.MA_TD_VANHOA;
hs.MA_TINHOC = tuCapNhat.MA_TINHOC;
hs.MA_TINHTHANH = tuCapNhat.MA_TINHTHANH;
hs.MA_TONGIAO = tuCapNhat.MA_TONGIAO;
hs.MA_TP_BANTHAN = tuCapNhat.MA_TP_BANTHAN;
hs.MA_TP_GIADINH = tuCapNhat.MA_TP_GIADINH;
hs.MA_TRINHDO = tuCapNhat.MA_TRINHDO;
hs.MA_XEPLOAI = tuCapNhat.MA_XEPLOAI;
hs.MA_TRUONG_DAOTAO = tuCapNhat.MA_TRUONG_DAOTAO;
hs.MA_TT_HN = tuCapNhat.MA_TT_HN;
hs.MA_TT_SUCKHOE = tuCapNhat.MA_TT_SUCKHOE;
hs.NHOM_MAU = tuCapNhat.NHOM_MAU;
hs.MST_CANHAN = tuCapNhat.MST_CANHAN;
hs.UU_DIEM = tuCapNhat.UU_DIEM;
hs.TYLE_DONG_BH = tuCapNhat.TYLE_DONG_BH;
hs.TEN_CB = tuCapNhat.TEN_CB;
hs.TAI_NH = tuCapNhat.TAI_NH;
hs.SoThuongTat = tuCapNhat.SoThuongTat;
hs.SOTHE_DANG = tuCapNhat.SOTHE_DANG;
hs.SOTHE_BHYT = tuCapNhat.SOTHE_BHYT;
hs.SOTHE_BHXH = tuCapNhat.SOTHE_BHXH;
hs.SOHIEU_CCVC = tuCapNhat.SOHIEU_CCVC;
hs.SO_THICH = tuCapNhat.SO_THICH;
hs.SO_TAI_KHOAN = tuCapNhat.SO_TAI_KHOAN;
hs.SO_HOCHIEU = tuCapNhat.SO_HOCHIEU;
hs.SO_CMND = tuCapNhat.SO_CMND;
hs.SDTNguoiLienHe = tuCapNhat.SDTNguoiLienHe;
hs.QueQuan = tuCapNhat.QueQuan;
hs.QuanHeVoiCanBo = tuCapNhat.QuanHeVoiCanBo;
hs.PHOTO = tuCapNhat.PHOTO;
hs.NoiSinhHoatDang = tuCapNhat.NoiSinhHoatDang;
hs.NOI_SINH = tuCapNhat.NOI_SINH;
hs.NOI_KETNAP_DOAN = tuCapNhat.NOI_KETNAP_DOAN;
hs.NOI_KETNAP_DANG = tuCapNhat.NOI_KETNAP_DANG;
hs.NHUOC_DIEM = tuCapNhat.NHUOC_DIEM;
hs.NguoiLienHe = tuCapNhat.NguoiLienHe;
hs.NgayVaoCongDoan = tuCapNhat.NgayVaoCongDoan;
hs.NAM_TN = tuCapNhat.NAM_TN;
hs.NGAYVAO_QDOI = tuCapNhat.NGAYVAO_QDOI;
hs.NGAY_BN_CHUCVU = tuCapNhat.NGAY_BN_CHUCVU;
hs.NGAY_BN_NGACH = tuCapNhat.NGAY_BN_NGACH;
hs.NGAY_CTHUC_DANG = tuCapNhat.NGAY_CTHUC_DANG;
hs.NGAY_DONGBH = tuCapNhat.NGAY_DONGBH;
hs.NGAY_HETHAN_BHYT = tuCapNhat.NGAY_HETHAN_BHYT;
hs.NGAY_HETHAN_HOCHIEU = tuCapNhat.NGAY_HETHAN_HOCHIEU;
hs.NGAY_KTBH = tuCapNhat.NGAY_KTBH;
hs.NGAY_SINH = tuCapNhat.NGAY_SINH;
hs.NGAY_TGCM = tuCapNhat.NGAY_TGCM;
hs.NGAY_TUYEN_CHINHTHUC = tuCapNhat.NGAY_TUYEN_CHINHTHUC;
hs.NGAY_TUYEN_DTIEN = tuCapNhat.NGAY_TUYEN_DTIEN;
hs.NGAYCAP_BHXH = tuCapNhat.NGAYCAP_BHXH;
hs.NGAYCAP_CMND = tuCapNhat.NGAYCAP_CMND;
hs.NGAYCAP_HOCHIEU = tuCapNhat.NGAYCAP_HOCHIEU;
hs.NGAYVAO_DOAN = tuCapNhat.NGAYVAO_DOAN;
hs.NGAYRA_QDOI = tuCapNhat.NGAYRA_QDOI;
hs.NGAYVAO_DANG = tuCapNhat.NGAYVAO_DANG;
hs.DATE_CREATE = DateTime.Now;
hs.NgayDuyet = DateTime.Now;
hs.UserID = userID;
hs.PrkeyNguoiDuyet = prKeyNguoiDuyet;
hs.HinhThucLamViec = tuCapNhat.HinhThucLamViec;
if (isInsert)
{
dataContext.HOSOs.InsertOnSubmit(hs);
}
tuCapNhat.TrangThaiDuyet = "DaDuyet";
Save();
string[] storeList = thongTinThem.Split(',');
if (string.IsNullOrEmpty(thongTinThem))
{
thongTinThem = "";
}
storeList = new string[] {
"DuyetHoSoQuanHeGiaDinh",
"DuyetHoSoDeTai",
"DuyetHoSoKhaNang",
"DuyetHoSoKhenThuong",
"DuyetHoSoKyLuat",
"DuyetHoSoQuaTrinhCongTac",
"DuyetHoSoQuaTrinhDieuChuyen",
"DuyetHoSoTaiSan",
"DuyetHoSoTepTinDinhKem",
"DuyetHoSoQuaTrinhHocTap",
"DuyetHoSoKinhNghiemLamViec",
"DuyetHoSoBangCapChungChi",
"DuyetHoSoTaiNanLaoDong"
};
foreach (var item in storeList)
{
if (!string.IsNullOrEmpty(item))
{
DataHandler.GetInstance().ExecuteNonQuery(item.Trim(), "@userid", userID);
}
}
return(hs.PR_KEY);
}
public void Add(DAL.HOSO_TUCAPNHAT obj)
{
dataContext.HOSO_TUCAPNHATs.InsertOnSubmit(obj);
Save();
}
