protected void Page_Load(object sender, EventArgs e) { if (Session["ACCOUNT"] == null) { Response.Redirect("../Login.aspx"); } try { this.itemId = int.Parse(Request["id"].ToString()); } catch { this.itemId = 0; } if (!Page.IsPostBack && this.itemId > 0) { TrinhDoTinHoc objTrinhDoTinHoc = new TrinhDoTinHoc(); DataRow objData = objTrinhDoTinHoc.getItem(itemId); if (objData != null) { txtNameTrinhDo.Text = objData["NameTrinhDo"].ToString(); txtNote.Text = objData["Note"].ToString(); this.ckbState.Checked = (bool)objData["State"]; } } this.txtNameTrinhDo.Focus(); }
protected void btnSave_Click(object sender, EventArgs e) { TrinhDoTinHoc objTrinhDoTinHoc = new TrinhDoTinHoc(); objTrinhDoTinHoc.delData(itemId); Response.Redirect("TrinhDoTinHoc.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (Session["ACCOUNT"] == null) { Response.Redirect("../Login.aspx"); } Session["TITLE"] = "TRÌNH ĐỘ TIN HỌC"; TrinhDoTinHoc objTrinhDoTinHoc = new TrinhDoTinHoc(); DataTable objData = objTrinhDoTinHoc.getList(); //dtlAccount.DataSource = objData.DefaultView; //dtlAccount.DataBind(); cpData.MaxPages = 1000; cpData.PageSize = 15; cpData.DataSource = objData.DefaultView; cpData.BindToControl = dtlData; dtlData.DataSource = cpData.DataSourcePaged; dtlData.DataBind(); index = 1; }
protected void btnSave_Click(object sender, EventArgs e) { this.lblMsg.Text = ""; if (this.txtNameTrinhDo.Text.Trim() == "") { this.lblMsg.Text = "Bạn chưa nhập tên trình độ tin học"; this.txtNameTrinhDo.Focus(); return; } TrinhDoTinHoc objTrinhDoTinHoc = new TrinhDoTinHoc(); int ret = objTrinhDoTinHoc.setData(itemId, this.txtNameTrinhDo.Text.Trim(), txtNote.Text.Trim(), ckbState.Checked); if (ret == 0) { this.lblMsg.Text = "Có lỗi xảy ra!"; } else { Response.Redirect("TrinhDoTinHoc.aspx?id=" + ret); } }
protected void Page_Load(object sender, EventArgs e) { //if (Session["ACCOUNT"] == null) //{ // Response.Redirect("../Login.aspx"); //} try { this.IDNldTuVan = int.Parse(Request.QueryString["id"].ToString()); } catch { this.IDNldTuVan = 0; } if (!Page.IsPostBack && this.IDNldTuVan > 0) { this.objTableNldTuVan = this.objNguoiLaoDong.getDataTblNldTuVanById(this.IDNldTuVan); if (this.objTableNldTuVan.Rows.Count > 0) { this.objTableNguoiLaoDong = this.objNguoiLaoDong.getDataById(int.Parse(this.objTableNldTuVan.Rows[0]["IDNguoiLaoDong"].ToString())); if (this.objTableNguoiLaoDong.Rows.Count > 0) { this.NLDGioiTinh = this.objTableNguoiLaoDong.Rows[0]["IDGioiTinh"].ToString().Replace("0", "Nữ").Replace("1", "Nam"); this.NLDHoten = this.objTableNguoiLaoDong.Rows[0]["HoVaTen"].ToString(); this.NLDNgaySinh = DateTime.Parse(this.objTableNguoiLaoDong.Rows[0]["NgaySinh"].ToString()).ToString("dd/MM/yyyy"); this.NLDCMND = this.objTableNguoiLaoDong.Rows[0]["CMND"].ToString(); this.NLDNgayCapCMND = DateTime.Parse(this.objTableNguoiLaoDong.Rows[0]["NgayCapCMND"].ToString()).ToString("dd/MM/yyyy"); this.NLNoiCap = this.objTableNguoiLaoDong.Rows[0]["NoiCap"].ToString(); this.NLDBHXH = this.objTableNguoiLaoDong.Rows[0]["BHXH"].ToString(); this.NLDDienThoai = this.objTableNguoiLaoDong.Rows[0]["DienThoai"].ToString(); this.NLDEmail = this.objTableNguoiLaoDong.Rows[0]["Email"].ToString(); this.NLDDanToc = this.objDanToc.getDataNameById(int.Parse(this.objTableNguoiLaoDong.Rows[0]["IDDanToc"].ToString())); this.NLDTonGiao = this.objTonGiao.getDataNameById(int.Parse(this.objTableNguoiLaoDong.Rows[0]["IDTonGiao"].ToString())); this.NLDNoiThuongTru = this.objTableNguoiLaoDong.Rows[0]["Xom_TT"].ToString() + ", " + this.objTableNguoiLaoDong.Rows[0]["Xa_TT"].ToString() + ", " + this.objTableNguoiLaoDong.Rows[0]["Huyen_TT"].ToString() + ", " + this.objTableNguoiLaoDong.Rows[0]["Tinh_TT"].ToString(); this.NLDDiaChi = this.objTableNguoiLaoDong.Rows[0]["Xom_DC"].ToString() + ", " + this.objTableNguoiLaoDong.Rows[0]["Xa_DC"].ToString() + ", " + this.objTableNguoiLaoDong.Rows[0]["Huyen_DC"].ToString() + ", " + this.objTableNguoiLaoDong.Rows[0]["Tinh_DC"].ToString(); this.NLDSucKhoe = this.objTableNguoiLaoDong.Rows[0]["SucKhoe"].ToString(); this.NLDChieuCao = this.objTableNguoiLaoDong.Rows[0]["ChieuCao"].ToString(); this.NLDCanNang = this.objTableNguoiLaoDong.Rows[0]["CanNang"].ToString(); this.NLDTrinhDoPhoThong = this.objTrinhDoPhoThong.getDataNameById(int.Parse(this.objTableNguoiLaoDong.Rows[0]["IDTrinhDoPhoThong"].ToString())); this.NLDNgoaiNgu = this.objNgoaiNgu.getDataNameById(int.Parse(this.objTableNguoiLaoDong.Rows[0]["IDNgoaiNgu"].ToString())); this.NLDTinHoc = this.objTinHoc.getDataNameById(int.Parse(this.objTableNguoiLaoDong.Rows[0]["IDTinHoc"].ToString())); this.NLDTrinhDoKyNangNghe = this.objTableNguoiLaoDong.Rows[0]["TrinhDoKyNangNghe"].ToString(); this.NLDKhaNangNoiTroi = this.objTableNguoiLaoDong.Rows[0]["KhaNangNoiTroi"].ToString(); chkDocThan.Checked = (this.objTableNguoiLaoDong.Rows[0]["StateLapGiaDinh"].ToString() == "0" ? true : false); chkKetHon.Checked = (this.objTableNguoiLaoDong.Rows[0]["StateLapGiaDinh"].ToString() == "1" ? true : false); TrinhDoTinHoc objTDTinHoc = new TrinhDoTinHoc(); trinhDoTinHoc = objTDTinHoc.getNameById((int)this.objTableNguoiLaoDong.Rows[0]["IdTrinhDoTinHoc"]); TrinhDoNgoaiNgu objTDNgoaiNgu = new TrinhDoNgoaiNgu(); trinhDongoaiNgu = objTDNgoaiNgu.getNameById((int)this.objTableNguoiLaoDong.Rows[0]["IdTrinhDoNgoaiNgu"]); this.objTableNldDaoTao = this.objNguoiLaoDong.getDataNldQuaTrinhDaoTao(int.Parse(this.objTableNldTuVan.Rows[0]["IDNguoiLaoDong"].ToString())); if (this.objTableNldDaoTao.Rows.Count > 0) { NLDQuaTrinhDaoTao_CN1 = this.objTableNldDaoTao.Rows[0]["NameDTNganhNghe"].ToString(); NLDQuaTrinhDaoTao_CM1 = this.objTableNldDaoTao.Rows[0]["NameTrinhdoChuyenMon"].ToString(); } if (this.objTableNldDaoTao.Rows.Count > 1) { NLDQuaTrinhDaoTao_CN2 = this.objTableNldDaoTao.Rows[1]["NameDTNganhNghe"].ToString(); NLDQuaTrinhDaoTao_CM2 = this.objTableNldDaoTao.Rows[1]["NameTrinhdoChuyenMon"].ToString(); } if (this.objTableNldDaoTao.Rows.Count > 2) { NLDQuaTrinhDaoTao_CN3 = this.objTableNldDaoTao.Rows[2]["NameDTNganhNghe"].ToString(); NLDQuaTrinhDaoTao_CM3 = this.objTableNldDaoTao.Rows[2]["NameTrinhdoChuyenMon"].ToString(); } this.objTableNldCongTac = this.objNguoiLaoDong.getDataNldQuatrinhCongTac(int.Parse(this.objTableNldTuVan.Rows[0]["IDNguoiLaoDong"].ToString())); if (this.objTableNldCongTac.Rows.Count > 0) { NLDQuaTrinhCongTac_DV1 = this.objTableNldCongTac.Rows[0]["DonVi"].ToString(); NLDQuaTrinhCongTac_TG1 = DateTime.Parse(this.objTableNldCongTac.Rows[0]["NgayBatDau"].ToString()).ToString("dd/MM/yyyy") + " - " + DateTime.Parse(this.objTableNldCongTac.Rows[0]["NgayKetThuc"].ToString()).ToString("dd/MM/yyyy"); NLDQuaTrinhCongTac_VT1 = this.objTableNldCongTac.Rows[0]["NameChucVu"].ToString(); } if (this.objTableNldCongTac.Rows.Count > 1) { NLDQuaTrinhCongTac_DV1 = this.objTableNldCongTac.Rows[1]["DonVi"].ToString(); NLDQuaTrinhCongTac_TG1 = DateTime.Parse(this.objTableNldCongTac.Rows[1]["NgayBatDau"].ToString()).ToString("dd/MM/yyyy") + " - " + DateTime.Parse(this.objTableNldCongTac.Rows[1]["NgayKetThuc"].ToString()).ToString("dd/MM/yyyy"); NLDQuaTrinhCongTac_VT1 = this.objTableNldCongTac.Rows[1]["NameChucVu"].ToString(); } if (this.objTableNldCongTac.Rows.Count > 2) { NLDQuaTrinhCongTac_DV1 = this.objTableNldCongTac.Rows[2]["DonVi"].ToString(); NLDQuaTrinhCongTac_TG1 = DateTime.Parse(this.objTableNldCongTac.Rows[2]["NgayBatDau"].ToString()).ToString("dd/MM/yyyy") + " - " + DateTime.Parse(this.objTableNldCongTac.Rows[2]["NgayKetThuc"].ToString()).ToString("dd/MM/yyyy"); NLDQuaTrinhCongTac_VT1 = this.objTableNldCongTac.Rows[2]["NameChucVu"].ToString(); } } if (this.objTableNldTuVan.Rows[0]["MucLuongTN"].ToString() != "0") { this.NLDMucLuongTN = String.Format("{0:0,0}", double.Parse(this.objTableNldTuVan.Rows[0]["MucLuongTN"].ToString())) + " đ"; } this.LanTuVan = this.objTableNldTuVan.Rows[0]["LanTuVan"].ToString(); this.NLDLyDoTN = this.objTableNldTuVan.Rows[0]["LyDoTN"].ToString(); this.NLDDNDaLienHe = this.objTableNldTuVan.Rows[0]["DNDaLienHe"].ToString(); // this.ckbTuVanPhapLuat.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanPhapLuat"].ToString()); // this.ckbTuVanViecLam.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanViecLam"].ToString()); // this.ckbTuVanBHTN.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanBHTN"].ToString()); //this.ckbTuVanKhac.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanKhac"].ToString()); this.NLDViTriCongViec = this.objTableNldTuVan.Rows[0]["ViTriCongViec"].ToString(); if (this.objTableNldTuVan.Rows[0]["MucLuongThapNhat"].ToString() != "0") { this.NLDMucLuongThapNhat = String.Format("{0:0,0}", double.Parse(this.objTableNldTuVan.Rows[0]["MucLuongThapNhat"].ToString())) + " đ"; } this.NLDDieuKienLamViec = this.objTableNldTuVan.Rows[0]["DieuKienLamViec"].ToString(); this.NLDDiaDiemLamViec = this.objTableNldTuVan.Rows[0]["DiaDiemLamViec"].ToString(); this.NLDNoiDungKhac = this.objTableNldTuVan.Rows[0]["NoiDungKhac"].ToString(); // new this.NLDViTriCongViec2 = this.objTableNldTuVan.Rows[0]["ViTriCongViec2"].ToString(); if (this.objTableNldTuVan.Rows[0]["MucLuongThapNhat2"].ToString() != "0") { this.NLDMucLuongThapNhat2 = String.Format("{0:0,0}", double.Parse(this.objTableNldTuVan.Rows[0]["MucLuongThapNhat2"].ToString())) + " đ"; } this.NLDDieuKienLamViec2 = this.objTableNldTuVan.Rows[0]["DieuKienLamViec2"].ToString(); this.NLDDiaDiemLamViec2 = this.objTableNldTuVan.Rows[0]["DiaDiemLamViec2"].ToString(); // this.NLDNoiDungKhac2 = this.objTableNldTuVan.Rows[0]["NoiDungKhac2"].ToString(); if (this.objTableNldTuVan.Rows[0]["NgayTuVan"].ToString() != "") { this.NLDNgayTuVan = "Vinh, ngày " + DateTime.Parse(this.objTableNldTuVan.Rows[0]["NgayTuVan"].ToString()).ToString("dd") + " tháng " + DateTime.Parse(this.objTableNldTuVan.Rows[0]["NgayTuVan"].ToString()).ToString("MM") + " năm " + DateTime.Parse(this.objTableNldTuVan.Rows[0]["NgayTuVan"].ToString()).ToString("yyyy"); } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["ACCOUNT"] == null) { Response.Redirect("../Login.aspx"); } Session["TITLE"] = "TƯ VẤN NGƯỜI LAO ĐỘNG"; #region Kiem tra quyen this.objTablePermission = this.objAccount.getDataPermission(Session["ACCOUNT"].ToString(), 10); if (this.objTablePermission.Rows.Count == 0) { this.objTablePermission = this.objAccount.getDataPermission(Session["ACCOUNT"].ToString(), 11); if (this.objTablePermission.Rows.Count > 0) { this.ckbTuVanViecLam.Enabled = true; } else { this.ckbTuVanViecLam.Enabled = false; } } #endregion #region lay bien truy van try { foreach (DataRow row in new ViTri().getList().Rows) { lv_Vitri.Add(row["NameVitri"].ToString()); } } catch { } try { this.IDNldTuVan = int.Parse(Request["id"].ToString()); } catch { this.IDNldTuVan = 0; } try { this.IDNguoiLaoDong = int.Parse(Request["idNld"].ToString()); } catch { this.IDNguoiLaoDong = 0; } try { this.IDNldDangKy = int.Parse(Request["idNldDK"].ToString()); } catch { this.IDNldDangKy = 0; } #endregion #region Lay thong tin so luong tin tuyen dung this.strBtnViecLamTrongNuoc = "Việc trong nước [ " + this.objTuyenDung.getDataCount(false) + " ]"; this.strBtnViecLamNgoai = "Việc ngoài nước [ " + this.objTuyenDung.getDataCount(true) + " ]"; this.strBtnDaoTaoNghe = "Đào tạo nghề [ " + this.objDTKhoaDaoTao.getDataCount() + " ]"; #endregion this.txtIDNldTuVan.Value = this.IDNldTuVan.ToString(); this.txtIDNguoiLaoDong.Value = this.IDNguoiLaoDong.ToString(); if (this.IDNldTuVan > 0) { this.btnQuaTrinhDaoTao.Disabled = false; this.btnQuaTrinhCongTac.Disabled = false; } else { this.btnQuaTrinhDaoTao.Disabled = true; this.btnQuaTrinhCongTac.Disabled = true; } if (!Page.IsPostBack) { this.ddlGioiTinh.DataSource = this.objGioiTinh.getDataCategoryToCombobox(); this.ddlGioiTinh.DataTextField = "NameGioiTinh"; this.ddlGioiTinh.DataValueField = "IDGioiTinh"; this.ddlGioiTinh.DataBind(); // ******************* Tỉnh thành **************************** DataTable objTinhThanhData = this.objProvincer.getDataCategoryToCombobox(); this.ddlTinh_TT.DataSource = objTinhThanhData.DefaultView; this.ddlTinh_TT.DataTextField = "Name"; this.ddlTinh_TT.DataValueField = "Id"; this.ddlTinh_TT.SelectedValue = "40"; this.ddlTinh_TT.DataBind(); this.ddlTinh_DC.DataSource = objTinhThanhData.DefaultView; this.ddlTinh_DC.DataTextField = "Name"; this.ddlTinh_DC.DataValueField = "Id"; this.ddlTinh_DC.SelectedValue = "40"; this.ddlTinh_DC.DataBind(); // ############################################################ //ddlTinh_TT_SelectedIndexChanged(null,null); if (this.ddlTinh_TT.Items.Count > 0) { this.ddlHuyen_TT.DataSource = this.objDistrict.getDataCategoryToCombobox(this.ddlTinh_TT.SelectedValue.ToString()); this.ddlHuyen_TT.DataTextField = "Name"; this.ddlHuyen_TT.DataValueField = "Id"; this.ddlHuyen_TT.DataBind(); } if (this.ddlHuyen_TT.Items.Count > 0) { this.ddlXa_TT.DataSource = this.objWard.getDataCategoryToCombobox(this.ddlTinh_TT.SelectedValue.ToString(), this.ddlHuyen_TT.SelectedValue.ToString()); this.ddlXa_TT.DataTextField = "Name"; this.ddlXa_TT.DataValueField = "Id"; ddlXa_TT.SelectedValue = "0"; this.ddlXa_TT.DataBind(); } //ddlTinh_DC_SelectedIndexChanged(null,null); if (this.ddlTinh_DC.Items.Count > 0) { this.ddlHuyen_DC.DataSource = this.objDistrict.getDataCategoryToCombobox(this.ddlTinh_DC.SelectedValue.ToString()); this.ddlHuyen_DC.DataTextField = "Name"; this.ddlHuyen_DC.DataValueField = "Id"; this.ddlHuyen_DC.DataBind(); } if (this.ddlHuyen_DC.Items.Count > 0) { this.ddlXa_DC.DataSource = this.objWard.getDataCategoryToCombobox(this.ddlTinh_DC.SelectedValue.ToString(), this.ddlHuyen_DC.SelectedValue.ToString()); this.ddlXa_DC.DataTextField = "Name"; this.ddlXa_DC.DataValueField = "Id"; ddlXa_DC.SelectedValue = "0"; this.ddlXa_DC.DataBind(); } this.ddlDanToc.DataSource = this.objDanToc.getDataCategoryToCombobox(); this.ddlDanToc.DataTextField = "NameDanToc"; this.ddlDanToc.DataValueField = "IDDanToc"; this.ddlDanToc.SelectedIndex = 0; this.ddlDanToc.DataBind(); this.ddlTonGiao.DataSource = this.objTonGiao.getDataCategoryToCombobox(); this.ddlTonGiao.DataTextField = "NameTonGiao"; this.ddlTonGiao.DataValueField = "IDTonGiao"; this.ddlTonGiao.DataBind(); ddlTonGiao.SelectedValue = "0"; this.ddlNgoaiNgu.DataSource = this.objNgoaiNgu.getDataCategoryToCombobox(); this.ddlNgoaiNgu.DataTextField = "NameNgoaiNgu"; this.ddlNgoaiNgu.DataValueField = "IDNgoaiNgu"; this.ddlNgoaiNgu.SelectedValue = "0"; this.ddlNgoaiNgu.DataBind(); this.ddlTrinhDoPhoThong.DataSource = this.objTrinhDoPhoThong.getDataCategoryToCombobox(); this.ddlTrinhDoPhoThong.DataTextField = "NameTrinhDoPhoThong"; this.ddlTrinhDoPhoThong.DataValueField = "IDTrinhDoPhoThong"; this.ddlTrinhDoPhoThong.DataBind(); this.ddlTinHoc.DataSource = this.objTinHoc.getDataCategoryToCombobox(); this.ddlTinHoc.DataTextField = "NameTinHoc"; this.ddlTinHoc.DataValueField = "IDTinHoc"; this.ddlTinHoc.SelectedValue = "0"; this.ddlTinHoc.DataBind(); TrinhDoTinHoc objTrinhDoTinHoc = new TrinhDoTinHoc(); this.ddlTrinhDoTinHoc.DataSource = objTrinhDoTinHoc.getDataCategoryToCombobox(); this.ddlTrinhDoTinHoc.DataTextField = "NameTrinhDo"; this.ddlTrinhDoTinHoc.DataValueField = "ID"; this.ddlTrinhDoTinHoc.DataBind(); this.ddlTrinhDoTinHoc.SelectedValue = "0"; TrinhDoNgoaiNgu objTrinhDoNgoaiNgu = new TrinhDoNgoaiNgu(); this.ddlTrinhDoNgoaiNgu.DataSource = objTrinhDoNgoaiNgu.getDataCategoryToCombobox(); this.ddlTrinhDoNgoaiNgu.DataTextField = "NameTrinhDo"; this.ddlTrinhDoNgoaiNgu.DataValueField = "ID"; this.ddlTrinhDoNgoaiNgu.DataBind(); this.ddlTrinhDoNgoaiNgu.SelectedValue = "0"; } if (!Page.IsPostBack && this.IDNldTuVan > 0) { this.objTableNldTuVan = this.objNguoiLaoDong.getDataTblNldTuVanById(this.IDNldTuVan); if (this.objTableNldTuVan.Rows.Count > 0) { this.IDNguoiLaoDong = int.Parse(this.objTableNldTuVan.Rows[0]["IDNguoiLaoDong"].ToString()); this.IDNldDangKy = this.objNguoiLaoDong.getDataNldDangKyByIDNldTuVan(this.IDNldTuVan); if (this.objTableNldTuVan.Rows[0]["MucLuongTN"].ToString() != "0") { this.txtMucLuongTN.Text = this.objTableNldTuVan.Rows[0]["MucLuongTN"].ToString(); } this.txtLyDoTN.Text = this.objTableNldTuVan.Rows[0]["LyDoTN"].ToString(); this.txtDnDaLienHe.Text = this.objTableNldTuVan.Rows[0]["DnDaLienHe"].ToString(); this.ckbTuVanPhapLuat.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanPhapLuat"].ToString()); this.ckbTuVanViecLam.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanViecLam"].ToString()); this.ckbTuVanXuatKhauLaoDong.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanXuatKhauLaoDong"].ToString()); this.ckbTuVanDuHoc.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanDuHoc"].ToString()); this.ckbTuVanBHTN.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanBHTN"].ToString()); this.ckbTuVanHocNghe.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanHocNghe"].ToString()); this.ckbTuVanKhac.Checked = bool.Parse(this.objTableNldTuVan.Rows[0]["TuVanKhac"].ToString()); this.txtViTriCongViec.Text = this.objTableNldTuVan.Rows[0]["ViTriCongViec"].ToString(); if (this.objTableNldTuVan.Rows[0]["MucLuongThapNhat"].ToString() != "0") { this.txtMucLuongThapNhat.Text = this.objTableNldTuVan.Rows[0]["MucLuongThapNhat"].ToString(); } this.txtDieuKienLamViec.Text = this.objTableNldTuVan.Rows[0]["DieuKienLamViec"].ToString(); this.txtDiaDiemLamViec.Text = this.objTableNldTuVan.Rows[0]["DiaDiemLamViec"].ToString(); this.txtViTriCongViec2.Text = this.objTableNldTuVan.Rows[0]["ViTriCongViec2"].ToString(); if (this.objTableNldTuVan.Rows[0]["MucLuongThapNhat2"].ToString() != "0") { this.txtMucLuongThapNhat2.Text = this.objTableNldTuVan.Rows[0]["MucLuongThapNhat2"].ToString(); } this.txtDieuKienLamViec2.Text = this.objTableNldTuVan.Rows[0]["DieuKienLamViec2"].ToString(); this.txtDiaDiemLamViec2.Text = this.objTableNldTuVan.Rows[0]["DiaDiemLamViec2"].ToString(); // nội dung khác của vị trí 2 sẻ ko hoạt động this.txtNoiDungKhac.Text = this.objTableNldTuVan.Rows[0]["NoiDungKhac"].ToString(); this.ddlIdLoaiLaoDong.SelectedValue = this.objTableNldTuVan.Rows[0]["IDLoaiLaoDong"].ToString(); if (this.objTableNldTuVan.Rows[0]["MucLuongThapNhat2"].ToString() != "0") { this.txtMucLuongThapNhat2.Text = this.objTableNldTuVan.Rows[0]["MucLuongThapNhat2"].ToString(); } this.txtDieuKienLamViec2.Text = this.objTableNldTuVan.Rows[0]["DieuKienLamViec2"].ToString(); this.txtDiaDiemLamViec2.Text = this.objTableNldTuVan.Rows[0]["DiaDiemLamViec2"].ToString(); this.txtCongViecTruocThatNghiep.Text = this.objTableNldTuVan.Rows[0]["CongViecTruocThatNghiep"].ToString(); this.txtNoiDungKhac.Text = this.objTableNldTuVan.Rows[0]["NoiDungKhac"].ToString(); this.ddlIdLoaiLaoDong.SelectedValue = this.objTableNldTuVan.Rows[0]["IDLoaiLaoDong"].ToString(); } } if (!Page.IsPostBack && this.IDNguoiLaoDong > 0) { this.objTable = this.objNguoiLaoDong.getDataById(this.IDNguoiLaoDong); if (this.objTable.Rows.Count > 0) { //this.txtMa.Text = this.objTable.Rows[0]["Ma"].ToString(); this.txtHoVaTen.Text = this.objTable.Rows[0]["HoVaTen"].ToString(); this.txtNgaySinh.Value = DateTime.Parse(this.objTable.Rows[0]["NgaySinh"].ToString()).ToString("dd/MM/yyyy"); this.ddlGioiTinh.SelectedValue = this.objTable.Rows[0]["IDGioiTinh"].ToString(); this.txtDienThoai.Text = this.objTable.Rows[0]["DienThoai"].ToString(); this.txtEmail.Text = this.objTable.Rows[0]["Email"].ToString(); this.ddlDanToc.SelectedValue = this.objTable.Rows[0]["IDDanToc"].ToString(); this.ddlTonGiao.SelectedValue = this.objTable.Rows[0]["IDTonGiao"].ToString(); this.txtSucKhoe.Text = this.objTable.Rows[0]["SucKhoe"].ToString(); this.txtChieuCao.Text = this.objTable.Rows[0]["ChieuCao"].ToString(); this.txtCanNang.Text = this.objTable.Rows[0]["CanNang"].ToString(); this.ddlNgoaiNgu.SelectedValue = this.objTable.Rows[0]["IDNgoaiNgu"].ToString(); this.ddlTrinhDoPhoThong.SelectedValue = this.objTable.Rows[0]["IDTrinhDoPhoThong"].ToString(); this.ddlTinHoc.SelectedValue = this.objTable.Rows[0]["IDTinHoc"].ToString(); this.txtCMND.Text = this.objTable.Rows[0]["CMND"].ToString(); this.txtNgayCapCMND.Value = DateTime.Parse(this.objTable.Rows[0]["NgayCapCMND"].ToString()).ToString("dd/MM/yyyy"); this.txtNoiCap.Text = this.objTable.Rows[0]["NoiCap"].ToString(); this.txtBHXH.Text = this.objTable.Rows[0]["BHXH"].ToString(); this.txtTrinhDoDaoTao.Text = this.objTable.Rows[0]["TrinhDoDaoTao"].ToString(); this.txtTrinhDoKyNangNghe.Text = this.objTable.Rows[0]["TrinhDoKyNangNghe"].ToString(); this.txtKhaNangNoiTroi.Text = this.objTable.Rows[0]["KhaNangNoiTroi"].ToString(); this.txtXom_TT.Text = this.objTable.Rows[0]["Xom_TT"].ToString(); this.txtXom_DC.Text = this.objTable.Rows[0]["Xom_DC"].ToString(); this.ddlTrinhDoTinHoc.SelectedValue = this.objTable.Rows[0]["IdTrinhDoTinHoc"].ToString(); this.ddlTrinhDoNgoaiNgu.SelectedValue = this.objTable.Rows[0]["IdTrinhDoNgoaiNgu"].ToString(); // chọn trạng thái gia đình this.ckDocThan.Checked = (this.objTable.Rows[0]["StateLapGiaDinh"].ToString() == "0" ? true : false); this.ckKetHon.Checked = (this.objTable.Rows[0]["StateLapGiaDinh"].ToString() == "1" ? true : false); // ****************** chọn tỉnh ****************** for (int i = 0; i < this.ddlTinh_TT.Items.Count; i++) { if (this.ddlTinh_TT.Items[i].Text == this.objTable.Rows[0]["Tinh_TT"].ToString()) { this.ddlTinh_TT.SelectedIndex = i; break; } } for (int i = 0; i < this.ddlTinh_DC.Items.Count; i++) { if (this.ddlTinh_DC.Items[i].Text == this.objTable.Rows[0]["Tinh_DC"].ToString()) { this.ddlTinh_DC.SelectedIndex = i; break; } } // ****************** chọn huyện ****************** if (this.ddlTinh_TT.Items.Count > 0) { this.ddlHuyen_TT.DataSource = this.objDistrict.getDataCategoryToCombobox(this.ddlTinh_TT.SelectedValue.ToString()); this.ddlHuyen_TT.DataTextField = "Name"; this.ddlHuyen_TT.DataValueField = "Id"; this.ddlHuyen_TT.DataBind(); } if (this.ddlTinh_DC.Items.Count > 0) { this.ddlHuyen_DC.DataSource = this.objDistrict.getDataCategoryToCombobox(this.ddlTinh_DC.SelectedValue.ToString()); this.ddlHuyen_DC.DataTextField = "Name"; this.ddlHuyen_DC.DataValueField = "Id"; this.ddlHuyen_DC.DataBind(); } for (int i = 0; i < this.ddlHuyen_TT.Items.Count; i++) { if (this.ddlHuyen_TT.Items[i].Text == this.objTable.Rows[0]["Huyen_TT"].ToString()) { this.ddlHuyen_TT.SelectedIndex = i; break; } } for (int i = 0; i < this.ddlHuyen_DC.Items.Count; i++) { if (this.ddlHuyen_DC.Items[i].Text == this.objTable.Rows[0]["Huyen_DC"].ToString()) { this.ddlHuyen_DC.SelectedIndex = i; break; } } // ****************** chọn xã ****************** if (this.ddlHuyen_TT.Items.Count > 0) { this.ddlXa_TT.DataSource = this.objWard.getDataCategoryToCombobox(this.ddlTinh_TT.SelectedValue.ToString(), this.ddlHuyen_TT.SelectedValue.ToString()); this.ddlXa_TT.DataTextField = "Name"; this.ddlXa_TT.DataValueField = "Id"; this.ddlXa_TT.DataBind(); } if (this.ddlHuyen_DC.Items.Count > 0) { this.ddlXa_DC.DataSource = this.objWard.getDataCategoryToCombobox(this.ddlTinh_DC.SelectedValue.ToString(), this.ddlHuyen_DC.SelectedValue.ToString()); this.ddlXa_DC.DataTextField = "Name"; this.ddlXa_DC.DataValueField = "Id"; this.ddlXa_DC.DataBind(); } for (int i = 0; i < this.ddlXa_TT.Items.Count; i++) { if (this.ddlXa_TT.Items[i].Text == this.objTable.Rows[0]["Xa_TT"].ToString()) { this.ddlXa_TT.SelectedIndex = i; break; } } for (int i = 0; i < this.ddlXa_DC.Items.Count; i++) { if (this.ddlXa_DC.Items[i].Text == this.objTable.Rows[0]["Xa_DC"].ToString()) { this.ddlXa_DC.SelectedIndex = i; break; } } ////////////////////////////////////////////////////// } } this.txtMa.Focus(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["ACCOUNT"] == null) { Response.Redirect("../Login.aspx"); } Session["TITLE"] = "THÔNG TIN TUYỂN DỤNG"; try { this.itemId = int.Parse(Request["id"].ToString()); } catch { this.itemId = 0; } try { this.IdDonVi = int.Parse(Request.QueryString["did"].ToString()); } catch { this.IdDonVi = 0; } try { this.tenDonVi = Request.QueryString["n"].ToString(); } catch { this.tenDonVi = ""; } if (!Page.IsPostBack) { DoanhNghiep objDoanhNghiep = new DoanhNghiep(); DataTable objdata = objDoanhNghiep.getDataById(this.IdDonVi); if (objdata.Rows.Count > 0) { this.txtIDDonVi.Value = objdata.Rows[0]["IDDonVi"].ToString(); this.txtTenDonVi.Text = objdata.Rows[0]["TenDonVi"].ToString(); nganhnghebuf = objdata.Rows[0]["IDNganhNghe"].ToString(); } } this.txtIDTuyenDung.Value = this.itemId.ToString(); if (!Page.IsPostBack) { if (Session["TuyenDungMessage"] != null) { this.lblMsg.Text = Session["TuyenDungMessage"].ToString(); Session["TuyenDungMessage"] = null; } this.ddlNhomNganh.DataSource = this.objNhomNganh.getDataCategoryToCombobox(); this.ddlNhomNganh.DataTextField = "NameNhomNganh"; this.ddlNhomNganh.DataValueField = "IdNhomNganh"; this.ddlNhomNganh.DataBind(); this.ddlNhomNganh.SelectedValue = "0"; this.ddlIDTinh.DataSource = this.objProvincer.getDataCategoryToCombobox(); this.ddlIDTinh.DataTextField = "Name"; this.ddlIDTinh.DataValueField = "Id"; this.ddlIDTinh.DataBind(); this.ddlIDTinh.SelectedValue = "0"; ViTri objViTri = new ViTri(); this.ddlIdVitri.DataSource = objViTri.getDataCategoryToCombobox(); this.ddlIdVitri.DataTextField = "NameViTri"; this.ddlIdVitri.DataValueField = "ID"; this.ddlIdVitri.DataBind(); this.ddlIdVitri.SelectedValue = "0"; this.ddlIDChucVu.DataSource = this.objChucVu.getDataCategoryToCombobox(); this.ddlIDChucVu.DataTextField = "NameChucVu"; this.ddlIDChucVu.DataValueField = "IDChucVu"; this.ddlIDChucVu.DataBind(); this.ddlIDChucVu.SelectedValue = "0"; TrinhDoTinHoc objTrinhDoTinHoc = new TrinhDoTinHoc(); this.ddlTinHoc.DataSource = objTrinhDoTinHoc.getDataCategoryToCombobox(); this.ddlTinHoc.DataTextField = "NameTrinhDo"; this.ddlTinHoc.DataValueField = "ID"; this.ddlTinHoc.DataBind(); this.ddlTinHoc.SelectedValue = "0"; TrinhDoNgoaiNgu objTrinhDoNgoaiNgu = new TrinhDoNgoaiNgu(); this.ddlTrinhDoNgoaiNgu.DataSource = objTrinhDoNgoaiNgu.getDataCategoryToCombobox(); this.ddlTrinhDoNgoaiNgu.DataTextField = "NameTrinhDo"; this.ddlTrinhDoNgoaiNgu.DataValueField = "ID"; this.ddlTrinhDoNgoaiNgu.DataBind(); this.ddlTrinhDoNgoaiNgu.SelectedValue = "0"; this.ddlIDDoTuoi.DataSource = this.objDoTuoi.getDataCategoryToCombobox(); this.ddlIDDoTuoi.DataTextField = "NameDoTuoi"; this.ddlIDDoTuoi.DataValueField = "IDDoTuoi"; this.ddlIDDoTuoi.DataBind(); this.ddlIDDoTuoi.SelectedValue = "0"; this.ddlIDGioiTinh.DataSource = this.objGioiTinh.getDataCategoryToCombobox("Nam/nữ"); this.ddlIDGioiTinh.DataTextField = "NameGioiTinh"; this.ddlIDGioiTinh.DataValueField = "IDGioiTinh"; this.ddlIDGioiTinh.DataBind(); this.ddlIDGioiTinh.SelectedValue = "0"; this.ddlIDTrinhDoChuyenMon.DataSource = this.objTrinhDoChuyenMon.getDataCategoryToCombobox(); this.ddlIDTrinhDoChuyenMon.DataTextField = "NameTrinhDoChuyenMon"; this.ddlIDTrinhDoChuyenMon.DataValueField = "IDTrinhDoChuyenMon"; this.ddlIDTrinhDoChuyenMon.DataBind(); this.ddlIDTrinhDoChuyenMon.SelectedValue = "0"; this.ddlIDMucLuong.DataSource = this.objMucluong.getDataCategoryToCombobox(); this.ddlIDMucLuong.DataTextField = "NameMucLuong"; this.ddlIDMucLuong.DataValueField = "IDMucLuong"; this.ddlIDMucLuong.DataBind(); this.ddlIDMucLuong.SelectedValue = "0"; NgoaiNgu objNgoaiNgu = new NgoaiNgu(); this.ddlyeuCauNgoaiNgu.DataSource = objNgoaiNgu.getDataCategoryToCombobox(); this.ddlyeuCauNgoaiNgu.DataTextField = "NameNgoaiNgu"; this.ddlyeuCauNgoaiNgu.DataValueField = "IDNgoaiNgu"; this.ddlyeuCauNgoaiNgu.DataBind(); this.ddlyeuCauNgoaiNgu.SelectedValue = "0"; TinHoc objTinHoc = new TinHoc(); this.ddlyeuCauTinHoc.DataSource = objTinHoc.getDataCategoryToCombobox(); this.ddlyeuCauTinHoc.DataTextField = "NameTinHoc"; this.ddlyeuCauTinHoc.DataValueField = "IDTinHoc"; this.ddlyeuCauTinHoc.DataBind(); this.ddlyeuCauTinHoc.SelectedValue = "0"; } if (!Page.IsPostBack && this.itemId > 0) { this.objTable = this.objTuyenDung.getDataById(this.itemId); if (this.objTable.Rows.Count > 0) { this.txtMaTuyenDung.Text = this.objTable.Rows[0]["MaTuyenDung"].ToString(); this.txtIDDonVi.Value = this.objTable.Rows[0]["IDDonVi"].ToString(); this.txtTenDonVi.Text = this.objTable.Rows[0]["TenDonVi"].ToString(); this.ddlNhomNganh.SelectedValue = this.objTable.Rows[0]["IDNhomNghanh"].ToString(); this.ddlNganhNghe.DataSource = this.objNganhNghe.getDataCategoryToCombobox(this.ddlNhomNganh.SelectedValue.ToString()); this.ddlNganhNghe.DataTextField = "NameDTNganhNghe"; this.ddlNganhNghe.DataValueField = "IDDTNganhNghe"; this.ddlNganhNghe.DataBind(); this.ddlNganhNghe.SelectedValue = this.objTable.Rows[0]["IDNganhNghe"].ToString(); this.ddlIDChucVu.SelectedValue = this.objTable.Rows[0]["IDChucVu"].ToString(); this.ddlTrinhDoNgoaiNgu.SelectedValue = this.objTable.Rows[0]["IdTrinhDoNgoaiNgu"].ToString(); this.ddlTinHoc.SelectedValue = this.objTable.Rows[0]["IdTrinhDoTinHoc"].ToString(); this.ddlIdVitri.SelectedValue = this.objTable.Rows[0]["IdViTri"].ToString(); this.txtSoLuongTuyenDung.Text = this.objTable.Rows[0]["SoLuongTuyenDung"].ToString(); this.ddlIDDoTuoi.SelectedValue = this.objTable.Rows[0]["IDDoTuoi"].ToString(); this.ddlIDGioiTinh.SelectedValue = this.objTable.Rows[0]["IDGioiTinh"].ToString(); this.txtUuTien.Text = this.objTable.Rows[0]["UuTien"].ToString(); this.ddlIDTrinhDoChuyenMon.SelectedValue = this.objTable.Rows[0]["IDTrinhDoChuyenMon"].ToString(); this.txtNoiDungKhac.Text = this.objTable.Rows[0]["NoiDungKhac"].ToString(); this.txtMoTa.Text = this.objTable.Rows[0]["MoTa"].ToString(); this.txtDiaDiem.Text = this.objTable.Rows[0]["DiaDiem"].ToString(); this.ddlIDMucLuong.SelectedValue = this.objTable.Rows[0]["IDMucLuong"].ToString(); this.ckbNuocNgoai.Checked = bool.Parse(this.objTable.Rows[0]["NuocNgoai"].ToString()); this.txtQuyenLoi.Text = this.objTable.Rows[0]["QuyenLoi"].ToString(); this.txtNgayBatDau.Value = DateTime.Parse(this.objTable.Rows[0]["NgayBatDau"].ToString()).ToString("dd/MM/yyyy"); this.txtNgayKetThuc.Value = DateTime.Parse(this.objTable.Rows[0]["NgayKetThuc"].ToString()).ToString("dd/MM/yyyy"); this.ckbState.Checked = bool.Parse(this.objTable.Rows[0]["State"].ToString()); this.ddlyeuCauNgoaiNgu.SelectedValue = this.objTable.Rows[0]["YCNgoaiNgu"].ToString(); this.ddlyeuCauTinHoc.SelectedValue = this.objTable.Rows[0]["YCTinHoc"].ToString(); this.txtNamKinhNghiem.Text = this.objTable.Rows[0]["NamKinhNghiem"].ToString(); this.ddlThoiGianLamViec.SelectedValue = this.objTable.Rows[0]["ThoiGianLamViec"].ToString(); this.txtIdQuocGia.Value = this.objTable.Rows[0]["IdQuocGia"].ToString(); this.txtNameQuocGia.Value = this.objTable.Rows[0]["NameQuocGia"].ToString(); } } this.txtMaTuyenDung.Focus(); }