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;
}
}
