public List <QuaTrinhCongTacDTO> LayDSQuaTrinhCongTacTheoMaNV(int maNV)
{
List <QuaTrinhCongTacDTO> ds = new List <QuaTrinhCongTacDTO>();
KetNoiCSDL.MoKetNoi();
string sqlselect = "select * from QuaTrinhCongTac" +
" inner join HoSo on QuaTrinhCongTac.MaNhanVien=HoSo.MaNhanVien where QuaTrinhCongTac.MaNhanVien=@ma";
SqlCommand cmd = new SqlCommand(sqlselect, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("ma", maNV);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateTime dt = DateTime.Parse(dr["tungay"].ToString());
DateTime dt2 = DateTime.Parse(dr["denngay"].ToString());
QuaTrinhCongTacDTO qt = new QuaTrinhCongTacDTO(
Convert.ToInt32(dr["manhanvien"].ToString()),
dt.ToString("dd/MM/yyyy"),
dt2.ToString("dd/MM/yyyy"),
dr["noicongtac"].ToString(),
dr["chucvu"].ToString()
);
ds.Add(qt);
}
KetNoiCSDL.DongKetNoi();
return(ds);
}
public QuaTrinhCongTacDTO LayBangQuaTrinhCongTacTheoMaNVTuNgay(int maNV, string tuNgay)
{
QuaTrinhCongTacDTO ds = null;
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select * from QuaTrinhcongTac where manhanvien=@ma and tungay=@tungay";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("ma", maNV);
cmd.Parameters.Add("tungay", tuNgay);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateTime date1 = DateTime.Parse(dr["tungay"].ToString());
DateTime date2 = DateTime.Parse(dr["denngay"].ToString());
ds = new QuaTrinhCongTacDTO(
Convert.ToInt32(dr["manhanvien"]),
date1.ToString("dd/MM/yyyy"),
date2.ToString("dd/MM/yyyy"),
dr["noicongtac"].ToString(),
dr["chucvu"].ToString());
}
KetNoiCSDL.DongKetNoi();
return(ds);
}
private void cbbTuNgay_SelectionChangeCommitted_1(object sender, EventArgs e)
{
DateTime dt = DateTime.ParseExact(cbbTuNgay.SelectedValue.ToString(), "dd/MM/yyyy", null);
string st = dt.ToString("dd/MM/yyyy");
QuaTrinhCongTacDTO qt = quaTrinhCongTacBUL.LayBangQuaTrinhCongTacTheoMaNVTuNgay(Convert.ToInt32(this.Tag.ToString()), dt.ToString("MM/dd/yyyy"));
txtCV.Text = qt.ChucVu;
txtNCT.Text = qt.NoiCongTac;
txtDenNgay.Text = qt.DenNgay;
}
private void cbbTuNgay_SelectionChangeCommitted(object sender, EventArgs e)
{
DateTime dt = DateTime.Parse(cbbTuNgay.SelectedValue.ToString());
string txt = dt.ToString("MM/dd/yyyy");
QuaTrinhCongTacDTO qtct = quaTrinhCongTacBUL.LayBangQuaTrinhCongTacTheoMaNVTuNgay(Convert.ToInt32(this.Tag.ToString()), dt.ToString("MM/dd/yyyy"));
lbChucVu.Text = qtct.ChucVu;
txtTenNV.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString()));
txtNCT.Text = qtct.NoiCongTac;
dtDenNgay.Value = DateTime.Parse(qtct.DenNgay);
}
private void frmXoaQTCT_Load(object sender, EventArgs e)
{
txtMaNV.Text = this.Tag.ToString();
txtTenNV.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString()));
cbbTuNgay.DataSource = quaTrinhCongTacBUL.LayBangQuaTrinhCongTacTheoMaNV(Convert.ToInt32(this.Tag.ToString()));
cbbTuNgay.DisplayMember = "tungay";
cbbTuNgay.ValueMember = "tungay";
cbbTuNgay.SelectedIndex = 0;
DateTime dt = DateTime.ParseExact(cbbTuNgay.SelectedValue.ToString(), "dd/MM/yyyy", null);
string st = dt.ToString("dd/MM/yyyy");
QuaTrinhCongTacDTO qt = quaTrinhCongTacBUL.LayBangQuaTrinhCongTacTheoMaNVTuNgay(Convert.ToInt32(this.Tag.ToString()), dt.ToString("MM/dd/yyyy"));
txtCV.Text = qt.ChucVu;
txtNCT.Text = qt.NoiCongTac;
txtDenNgay.Text = qt.DenNgay;
}
private void frmSuaQTCT_Load(object sender, EventArgs e)
{
lbMaNhanVien.Text = this.Tag.ToString();
List <QuaTrinhCongTacDTO> ds = quaTrinhCongTacBUL.LayDSQuaTrinhCongTacTheoMaNV(Convert.ToInt32(this.Tag.ToString()));
cbbTuNgay.DataSource = quaTrinhCongTacBUL.LayDSQuaTrinhCongTacTheoMaNV(Convert.ToInt32(this.Tag.ToString()));
cbbTuNgay.DisplayMember = "tungay";
cbbTuNgay.ValueMember = "tungay";
cbbTuNgay.SelectedIndex = 0;
dtDenNgay.Format = DateTimePickerFormat.Custom;
dtDenNgay.CustomFormat = "dd/MM/yyyy";
DateTime dt = DateTime.ParseExact(cbbTuNgay.SelectedValue.ToString(), "dd/MM/yyyy", null);
QuaTrinhCongTacDTO qtct = quaTrinhCongTacBUL.LayBangQuaTrinhCongTacTheoMaNVTuNgay(Convert.ToInt32(this.Tag.ToString()), dt.ToString("MM/dd/yyyy"));
lbChucVu.Text = qtct.ChucVu;
txtTenNV.Text = hoSoBUL.LayTenTheoMaNhanVien(Convert.ToInt32(this.Tag.ToString()));
txtNCT.Text = qtct.NoiCongTac;
dtDenNgay.Value = DateTime.Parse(qtct.DenNgay);
}
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;
}
}
