private void frmXoaTDNN_Load(object sender, EventArgs e) { txtMaNV.Text = this.Tag.ToString(); txtTenNV2.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())); cboNgoaiNgu.DataSource = trinhdoNNBUL.layNgoaiNguTheoMa(Convert.ToInt32(this.Tag.ToString())); cboNgoaiNgu.DisplayMember = "NgoaiNgu"; cboNgoaiNgu.ValueMember = "NgoaiNgu"; TrinhDoNgoaiNguDTO ds = trinhdoNNBUL.layDStrinhdoCMtheomavanganh(Convert.ToInt32(this.Tag.ToString()), cboNgoaiNgu.SelectedValue.ToString())[0]; txtTrinhDO.Text = ds.TrinhDo; }
public List <TrinhDoNgoaiNguDTO> DemTrinhDoTheoTen() { List <TrinhDoNgoaiNguDTO> ds = new List <TrinhDoNgoaiNguDTO>(); KetNoiCSDL.MoKetNoi(); string sqlSelect = "select ngoaingu,count(*) as 'tong' from TrinhDoNgoaiNgu group by ngoaingu"; SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TrinhDoNgoaiNguDTO nn = new TrinhDoNgoaiNguDTO(dr["ngoaingu"].ToString(), Convert.ToInt32(dr["tong"])); ds.Add(nn); } KetNoiCSDL.DongKetNoi(); return(ds); }
public List <TrinhDoNgoaiNguDTO> LayBangTrinhDoNgoaiNgu() { List <TrinhDoNgoaiNguDTO> ds = new List <TrinhDoNgoaiNguDTO>(); KetNoiCSDL.MoKetNoi(); string sqlSelect = "select ngoaingu from trinhdongoaingu group by ngoaingu"; SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TrinhDoNgoaiNguDTO nn = new TrinhDoNgoaiNguDTO( 0, dr["ngoaingu"].ToString(), "" ); ds.Add(nn); } KetNoiCSDL.DongKetNoi(); return(ds); }
public List <TrinhDoNgoaiNguDTO> LayThongTinTDNNtheoMa(int maNV) { List <TrinhDoNgoaiNguDTO> ds = new List <TrinhDoNgoaiNguDTO>(); KetNoiCSDL.MoKetNoi(); string sqlSelect = "select * from trinhdongoaingu where manhanvien=@ma "; SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi); cmd.Parameters.AddWithValue("ma", maNV); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TrinhDoNgoaiNguDTO td = new TrinhDoNgoaiNguDTO( Convert.ToInt32(dr["manhanvien"]), dr["ngoaingu"].ToString(), dr["trinhdo"].ToString() ); ds.Add(td); } KetNoiCSDL.DongKetNoi(); return(ds); }
private void cboNgoaiNgu_SelectionChangeCommitted_1(object sender, EventArgs e) { TrinhDoNgoaiNguDTO ds = trinhdoNNBUL.layDStrinhdoCMtheomavanganh(Convert.ToInt32(this.Tag.ToString()), cboNgoaiNgu.SelectedValue.ToString())[0]; txtTrinhDO.Text = ds.TrinhDo; }
private void frmSuaHoSo_Load(object sender, EventArgs e) { lblMaNV.Text = this.Tag.ToString(); lbMaNhanVienTDCM.Text = this.Tag.ToString(); lbMaNhanVienTDNN.Text = this.Tag.ToString(); cbbMaPhongBan.DataSource = phongBanBUL.LayDSPhongBan(); cbbMaPhongBan.DisplayMember = "TenPhongBan"; cbbMaPhongBan.ValueMember = "MaPhongBan"; lbTenNhanVienTDCM.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())); lbTenNhanVienTDNN.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())); dtNgaySinh.Format = DateTimePickerFormat.Custom; dtNgaySinh.CustomFormat = "dd/MM/yyyy"; dtNgayTD.Format = DateTimePickerFormat.Custom; dtNgayTD.CustomFormat = "dd/MM/yyyy"; HoSoDTO ds = hoSoBUL.LayDSHoSoTheoMa(Convert.ToInt32(this.Tag.ToString()))[0]; txtHodem.Text = ds.HoDem; txtTen.Text = ds.TenDem; DateTime dt = DateTime.ParseExact(ds.NgaySinh, "dd/MM/yyyy", null); dtNgaySinh.Value = dt; if (rdoNam.Text == ds.GioiTinh) { rdoNam.Checked = true; } if (rdoNu.Text == ds.GioiTinh) { rdoNu.Checked = true; } txtSodt.Text = ds.SoDienThoai; txtEmail.Text = ds.Email; dt = DateTime.ParseExact(ds.NgayTuyenDung, "dd/MM/yyyy", null); dtNgayTD.Value = dt; cbbMaPhongBan.SelectedValue = ds.MaPhongBan; ////////qua trinh cong tac lbMaNhanVienQTCT.Text = this.Tag.ToString(); cbbTuNgay.DataSource = quaTrinhCongTacBUL.LayDSQuaTrinhCongTacTheoMaNV(Convert.ToInt32(this.Tag.ToString())); if (quaTrinhCongTacBUL.LayDSQuaTrinhCongTacTheoMaNV(Convert.ToInt32(this.Tag.ToString())).Count > 0) { cbbTuNgay.DisplayMember = "tungay"; cbbTuNgay.ValueMember = "tungay"; cbbTuNgay.SelectedIndex = 0; dtDenNgay.Format = DateTimePickerFormat.Custom; dtDenNgay.CustomFormat = "dd/MM/yyyy"; DateTime dtqtct = DateTime.Parse(cbbTuNgay.SelectedValue.ToString()); string txt = dtqtct.ToString("MM/dd/yyyy"); QuaTrinhCongTacDTO qtct = quaTrinhCongTacBUL.LayBangQuaTrinhCongTacTheoMaNVTuNgay(Convert.ToInt32(this.Tag.ToString()), dtqtct.ToString("MM/dd/yyyy")); lbChucVu.Text = qtct.ChucVu; lbTenNhanVienQTCT.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())); txtNCT.Text = qtct.NoiCongTac; } /////////////////nhan vien chuc vu lbMaNhanVienCV.Text = this.Tag.ToString(); cbbMaChucVu.DataSource = chucVuBUL.LayTenChucVuTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())); if (chucVuBUL.LayTenChucVuTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())).Count > 0) { cbbMaChucVu.DisplayMember = "tenchucvu"; cbbMaChucVu.ValueMember = "machucvu"; cbbMaChucVu.SelectedIndex = 0; lbTenNhanVienCV.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString()));; cbbTuNgayNVCV.DataSource = nhanVienChucVuBUL.LayNhanVienChucVuTheoMaNVMaCV(Convert.ToInt32(this.Tag.ToString()), Convert.ToInt32(cbbMaChucVu.SelectedValue)); cbbTuNgayNVCV.DisplayMember = "tungay"; cbbTuNgayNVCV.ValueMember = "tungay"; } ////////////// trinh do chuyen mon lbMaNhanVienTDCM.Text = this.Tag.ToString(); lbTenNhanVienTDCM.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())); cbbLoaiHinhDT.DataSource = trinhdoCMBUL.LayThongTinTrinhDoCHuyenMongopLHDT(); cbbLoaiHinhDT.DisplayMember = "LoaiHinhDaoTao"; cbbLoaiHinhDT.ValueMember = "LoaiHinhDaoTao"; cboTrinhDo.DataSource = trinhdoCMBUL.LayThongTinTrinhDoCHuyenMongopTD(); cboTrinhDo.DisplayMember = "TrinhDo"; cboTrinhDo.ValueMember = "TrinhDo"; cboNganh.DataSource = trinhdoCMBUL.LayThongTinnganhTheoMa(Convert.ToInt32(lbMaNhanVienTDCM.Text)); cboNganh.DisplayMember = "nganh"; cboNganh.ValueMember = "nganh"; if (trinhdoCMBUL.LayDSTDCMtheoMa(Convert.ToInt32(this.Tag.ToString())).Count > 0) { TrinhDoChuyenMonDTO dsTDCM = trinhdoCMBUL.layDStrinhdoCMtheomavanganh(Convert.ToInt32(this.Tag.ToString()), cboNganh.SelectedValue.ToString())[0]; cbbLoaiHinhDT.SelectedValue = dsTDCM.LoaiHinhDaoTao; cboTrinhDo.SelectedValue = dsTDCM.TrinhDo; txtTruongDaoTao.Text = dsTDCM.TruongDaoTao; } /////////// trinh do ngoai ngu lbMaNhanVienTDNN.Text = this.Tag.ToString(); lbTenNhanVienTDNN.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())); cboNgoaiNgu.DataSource = trinhdoNNBUL.layNgoaiNguTheoMa(Convert.ToInt32(this.Tag.ToString())); cboNgoaiNgu.DisplayMember = "NgoaiNgu"; cboNgoaiNgu.ValueMember = "NgoaiNgu"; //List<TrinhDoNgoaiNguDTO> nn = trinhdoNNBUL.layDStrinhdoCMtheomavanganh(Convert.ToInt32(this.Tag.ToString()), cboNgoaiNgu.SelectedValue.ToString()); if (trinhdoNNBUL.LayTTTrinhDoNNTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())).Count > 0) { TrinhDoNgoaiNguDTO dstdnn = trinhdoNNBUL.layDStrinhdoCMtheomavanganh(Convert.ToInt32(this.Tag.ToString()), cboNgoaiNgu.SelectedValue.ToString())[0]; txtTrinhDo.Text = dstdnn.TrinhDo; } }