public List <TrinhDoChuyenMonDTO> LayDSTDCMtheoMa(int maNV) { List <TrinhDoChuyenMonDTO> ds = new List <TrinhDoChuyenMonDTO>(); KetNoiCSDL.MoKetNoi(); string sqlSelect = "select * from trinhdochuyenmon where manhanvien = @ma"; SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi); cmd.Parameters.AddWithValue("ma", maNV); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TrinhDoChuyenMonDTO td = new TrinhDoChuyenMonDTO( Convert.ToInt32(dr["manhanvien"]), dr["nganh"].ToString(), dr["trinhdo"].ToString(), dr["loaihinhdaotao"].ToString(), dr["truongdaotao"].ToString() ); ds.Add(td); } KetNoiCSDL.DongKetNoi(); return(ds); }
private void cboNganh_SelectionChangeCommitted_1(object sender, EventArgs e) { TrinhDoChuyenMonDTO ds = trinhdoCMBUL.layDStrinhdoCMtheomavanganh(Convert.ToInt32(this.Tag.ToString()), cboNganh.SelectedValue.ToString())[0]; cboLoaiHinhDT.SelectedValue = ds.LoaiHinhDaoTao; cboTrinhDo.SelectedValue = ds.TrinhDo; txtTruongDT.Text = ds.TruongDaoTao; }
private void frmXoaTDCM_Load(object sender, EventArgs e) { txtMaNV.Text = this.Tag.ToString(); txtTenNV.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString())); cboNganh.DataSource = trinhdoCMBUL.LayThongTinnganhTheoMa(Convert.ToInt32(txtMaNV.Text)); cboNganh.DisplayMember = "nganh"; cboNganh.ValueMember = "nganh"; TrinhDoChuyenMonDTO ds = trinhdoCMBUL.layDStrinhdoCMtheomavanganh(Convert.ToInt32(this.Tag.ToString()), cboNganh.SelectedValue.ToString())[0]; txtLoaiHinhDT.Text = ds.LoaiHinhDaoTao; txtTrinhDO.Text = ds.TrinhDo; txtTruongDT.Text = ds.TruongDaoTao; }
public List <TrinhDoChuyenMonDTO> DemTrinhDoTheoTen() { List <TrinhDoChuyenMonDTO> ds = new List <TrinhDoChuyenMonDTO>(); KetNoiCSDL.MoKetNoi(); string sqlSelect = "select trinhdo,count(*) as 'tong' from trinhdochuyenmon group by TrinhDo"; SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TrinhDoChuyenMonDTO cm = new TrinhDoChuyenMonDTO(dr["trinhdo"].ToString(), Convert.ToInt32(dr["tong"])); ds.Add(cm); } KetNoiCSDL.DongKetNoi(); return(ds); }
public List <TrinhDoChuyenMonDTO> LayDSTrinhDo() { List <TrinhDoChuyenMonDTO> ds = new List <TrinhDoChuyenMonDTO>(); KetNoiCSDL.MoKetNoi(); string sqlSelect = "select trinhdo from trinhdochuyenmon group by trinhdo "; SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TrinhDoChuyenMonDTO td = new TrinhDoChuyenMonDTO(dr["trinhdo"].ToString()); ds.Add(td); } KetNoiCSDL.DongKetNoi(); return(ds); }
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; } }