protected void btnUpdate_Click(object sender, EventArgs e)
{
btnUpdate1_Click(null, null);
btnUpdate2_Click(null, null);
btnUpdate3_Click(null, null);
btnUpdate4_Click(null, null);
btnUpdate5_Click(null, null);
btnUpdate6_Click(null, null);
btnUpdate7_Click(null, null);
btnUpdate8_Click(null, null);
btnUpdate14_Click(null, null);
btnUpdate15_Click(null, null);
btnUpdate16_Click(null, null);
btnUpdate17_Click(null, null);
btnUpdate18_Click(null, null);
DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVien(0, 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
if (dtNhanVien != null && dtNhanVien.Rows.Count > 0)
{
foreach (DataRow item in dtNhanVien.Rows)
{
DotDanhGiaController.DanhGiaThang_DGCBCNVDanhGia_TongDiemCongThucMoi(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(item["IDNhanVien"]));
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
foreach (GridViewRow gv in dgrBoPhan.Rows)
{
int idBoPhan = ConvertUtility.ToInt32(((Label)gv.FindControl("lblKey")).Text);
int idDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
TextBox txtMatXanh = (TextBox)gv.FindControl("txtMatXanh");
TextBox txtMatMeu = (TextBox)gv.FindControl("txtMatMeu");
TextBox txtMatNau = (TextBox)gv.FindControl("txtMatNau");
TextBox txtOther = (TextBox)gv.FindControl("txtOther");
TextBox txtNote = (TextBox)gv.FindControl("txtNote");
TextBox txtGhiChu = (TextBox)gv.FindControl("txtGhiChu");
int MatXanh = ConvertUtility.ToInt32(txtMatXanh.Text);
int MatMeu = ConvertUtility.ToInt32(txtMatMeu.Text);
int MatNau = ConvertUtility.ToInt32(txtMatNau.Text);
int Other = ConvertUtility.ToInt32(txtOther.Text);
string note = txtNote.Text;
string note1 = txtGhiChu.Text;
UserController.UpdateBoPhanDiemKyLuat5S(idBoPhan, idDotDanhGia, MatXanh, MatMeu, MatNau, Other, note, note1);
}
DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVien(0, 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
if (dtNhanVien != null && dtNhanVien.Rows.Count > 0)
{
foreach (DataRow item in dtNhanVien.Rows)
{
DotDanhGiaController.DanhGiaThang_DGCBCNVDanhGia_TongDiemCongThucMoi(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(item["IDNhanVien"]));
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
foreach (GridViewRow gv in dgrBoPhan.Rows)
{
int idBoPhan = ConvertUtility.ToInt32(((Label)gv.FindControl("lblKey")).Text);
int idDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
TextBox txtYTuongDoatGiai = (TextBox)gv.FindControl("txtYTuongDoatGiai");
TextBox txtKhongPhoiHop = (TextBox)gv.FindControl("txtKhongPhoiHop");
TextBox txtPhoiHopNhietTinh = (TextBox)gv.FindControl("txtPhoiHopNhietTinh");
TextBox txtThucDayNhanVien = (TextBox)gv.FindControl("txtThucDayNhanVien");
int YTuongDoatGiai = ConvertUtility.ToInt32(txtYTuongDoatGiai.Text);
int KhongPhoiHop = ConvertUtility.ToInt32(txtKhongPhoiHop.Text);
int PhoiHopNhietTinh = ConvertUtility.ToInt32(txtPhoiHopNhietTinh.Text);
int ThucDayNhanVien = ConvertUtility.ToInt32(txtThucDayNhanVien.Text);
UserController.UpdateBoPhanDGDiemSangTao(idBoPhan, idDotDanhGia, YTuongDoatGiai, KhongPhoiHop, PhoiHopNhietTinh, ThucDayNhanVien);
}
DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVien(0, 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
if (dtNhanVien != null && dtNhanVien.Rows.Count > 0)
{
foreach (DataRow item in dtNhanVien.Rows)
{
DotDanhGiaController.DanhGiaThang_DGCBCNVDanhGia_TongDiemCongThucMoi(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(item["IDNhanVien"]));
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
foreach (GridViewRow gv in dgrBoPhan.Rows)
{
int idBoPhan = ConvertUtility.ToInt32(((Label)gv.FindControl("lblKey")).Text);
int idDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
TextBox txtThamGiaHDCongTy = (TextBox)gv.FindControl("txtThamGiaHDCongTy");
TextBox txtChuyenCan = (TextBox)gv.FindControl("txtChuyenCan");
TextBox txtTuanThuThoiGian = (TextBox)gv.FindControl("txtTuanThuThoiGian");
TextBox txtKhenThuong = (TextBox)gv.FindControl("txtKhenThuong");
TextBox txtDiemKyLuatTT = (TextBox)gv.FindControl("txtDiemKyLuatTT");
int ThamGiaHDCongTy = ConvertUtility.ToInt32(txtThamGiaHDCongTy.Text);
int ChuyenCan = ConvertUtility.ToInt32(txtChuyenCan.Text);
int TuanThuThoiGian = ConvertUtility.ToInt32(txtTuanThuThoiGian.Text);
int KhenThuong = ConvertUtility.ToInt32(txtKhenThuong.Text);
int DiemKyLuatTT = ConvertUtility.ToInt32(txtDiemKyLuatTT.Text);
UserController.UpdateBoPhanDGKyLuat(idBoPhan, idDotDanhGia, ThamGiaHDCongTy, ChuyenCan, TuanThuThoiGian, KhenThuong, DiemKyLuatTT);
}
DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVien(0, 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
if (dtNhanVien != null && dtNhanVien.Rows.Count > 0)
{
foreach (DataRow item in dtNhanVien.Rows)
{
DotDanhGiaController.DanhGiaThang_DGCBCNVDanhGia_TongDiemCongThucMoi(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(item["IDNhanVien"]));
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
foreach (GridViewRow gv in dgrBoPhan.Rows)
{
int idBoPhan = ConvertUtility.ToInt32(((Label)gv.FindControl("lblKey")).Text);
int idDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
TextBox txtYTuongThang = (TextBox)gv.FindControl("txtYTuongThang");
TextBox txtYTuongMoi = (TextBox)gv.FindControl("txtYTuongMoi");
TextBox txtSoNhanVienGui = (TextBox)gv.FindControl("txtSoNhanVienGui");
TextBox txtSoYTuongDuocChon = (TextBox)gv.FindControl("txtSoYTuongDuocChon");
TextBox txtSoNhanVien = (TextBox)gv.FindControl("txtSoNhanVien");
int ytuongthang = ConvertUtility.ToInt32(txtYTuongThang.Text);
int ytuongmoi = ConvertUtility.ToInt32(txtYTuongMoi.Text);
int sonhanviengui = ConvertUtility.ToInt32(txtSoNhanVienGui.Text);
int ytuongduocchon = ConvertUtility.ToInt32(txtSoYTuongDuocChon.Text);
int sonhanvien = ConvertUtility.ToInt32(txtSoNhanVien.Text);
UserController.UpdateBoPhanDiemSangTao(idBoPhan, idDotDanhGia, ytuongthang, ytuongmoi, sonhanviengui, ytuongduocchon, sonhanvien);
}
DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVien(0, 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
if (dtNhanVien != null && dtNhanVien.Rows.Count > 0)
{
foreach (DataRow item in dtNhanVien.Rows)
{
DotDanhGiaController.DanhGiaThang_DGCBCNVDanhGia_TongDiemCongThucMoi(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(item["IDNhanVien"]));
}
}
}
private void BindUser()
{
DataTable dtNhanVien = null;
if (!CurrentUser.IsAdmin && !CurrentUser.IsSuperAdmin)
{
dtNhanVien = DotDanhGiaController.QuanLyNhanVienTheoNDG_ByNhanVienQuanLy(CurrentUser.UserID, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
}
else
{
dtNhanVien = DotDanhGiaController.GetAllNhanVien(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropPhongBan.SelectedValue), ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
}
if (dtNhanVien != null && dtNhanVien.Rows.Count > 0)
{
dropUser.DataSource = dtNhanVien;
dropUser.DataBind();
dropUser.Items.Insert(0, new ListItem("All", "0"));
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVien(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropPhongBan.SelectedValue));
if (dtNhanVien == null)
{
return;
}
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(misValue);
int sheet = 1;
foreach (DataRow itemNhanVien in dtNhanVien.Rows)
{
int idNhanVien = ConvertUtility.ToInt32(itemNhanVien["UserID"]);
#region Cong viec thuong xuyen
DataTable dtCongViec = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS(idNhanVien, 1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
DataTable dtCongViecNew = dtCongViec.Clone();
dtCongViecNew.Columns.Add("TyTrongCaNhan", typeof(string));
dtCongViecNew.Columns.Add("TyTrongCaNhanSoVoiPhong", typeof(string));
dtCongViecNew.Columns.Add("GioLamViec", typeof(string));
DataSet ds = DotDanhGiaController.GetPTDG(idNhanVien, 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
DataTable dtSoNhanVien = ds.Tables[1];
DataTable dtTyTrong = ds.Tables[2];
DataTable dtSoNhanVienPhong = ds.Tables[3];
int tongSoNhanVien = 0;
if (dtSoNhanVien != null && dtSoNhanVien.Rows.Count > 0)
{
tongSoNhanVien = ConvertUtility.ToInt32(dtSoNhanVien.Rows[0]["TongSoNhanVien"]);
}
int tyTrongCVPhongVoiTrungTam = 0;
if (dtTyTrong != null && dtTyTrong.Rows.Count > 0)
{
tyTrongCVPhongVoiTrungTam = ConvertUtility.ToInt32(dtTyTrong.Rows[0]["TyTrong"]);
}
if (tyTrongCVPhongVoiTrungTam == 0)
{
tyTrongCVPhongVoiTrungTam = 100;
}
int tongSoNhanVienPhong = 0;
if (dtSoNhanVienPhong != null && dtSoNhanVienPhong.Rows.Count > 0)
{
tongSoNhanVienPhong = ConvertUtility.ToInt32(dtSoNhanVienPhong.Rows[0]["TongSoNhanVien"]);
}
DataRow rowHeader = dtCongViecNew.NewRow();
rowHeader["TenCVCha"] = "-----------------Công việc thường xuyên----------------";
rowHeader["Ten"] = "---------------------------";
rowHeader["TyTrong"] = "0";
rowHeader["KeHoach"] = "";
rowHeader["TyTrongCaNhan"] = "0";
rowHeader["GioLamViec"] = "0";
rowHeader["TyTrongCaNhanSoVoiPhong"] = "0";
dtCongViecNew.Rows.Add(rowHeader);
foreach (DataRow item in dtCongViec.Rows)
{
DataRow row = dtCongViecNew.NewRow();
int idCongViecKPI = ConvertUtility.ToInt32(item["IDCongViecKPI"]);
DataTable dtTyTrongKPI = DotDanhGiaController.GetTyTrongCongViec(idCongViecKPI, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropPhongBan.SelectedValue), idNhanVien);
double tyTrongCVDuocGiao = 0;
row["TenCVCha"] = ConvertUtility.ToString(item["TenCVCha"]);
row["Ten"] = item["Ten"];
double tyTrongCVDuocGiaoCaNhan = 0;
double tyTrongCVDuocGiaoCaNhanSoVoiPhong = 0;
if (dtTyTrongKPI != null && dtTyTrongKPI.Rows.Count > 0)
{
tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien;
double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien * 22 / 100, 3);
double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 3);
tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 3);
tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]), 3);
row["TyTrong"] = tyTrongCVDuocGiao;
}
else
{
tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien;
double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien * 22 / 100, 3);
double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 3);
tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 3);
tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]), 3);
row["TyTrong"] = tyTrongCVDuocGiao;
}
row["KeHoach"] = item["KeHoach"].ToString();
row["TyTrongCaNhan"] = Math.Round(tyTrongCVDuocGiaoCaNhan, 3).ToString().Replace(",", ".");// tyTrongCVDuocGiaoCaNhan.ToString().Replace(",", ".");
row["GioLamViec"] = Math.Round(tyTrongCVDuocGiaoCaNhan * 22 * 8 / 100, 3).ToString().Replace(",", ".");
//if (dtTyTrongKPI != null && dtTyTrongKPI.Rows.Count > 0)
//{
// tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien;
// double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien * 22 / 100, 2);
// double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 2);
// tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 2);
// tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]), 2);
// row["TyTrong"] = tyTrongCVDuocGiao.ToString();
//}
//else
//{
// tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien;
// double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien * 22 / 100, 2);
// double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 2);
// tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 2);
// tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]), 2);
// row["TyTrong"] = tyTrongCVDuocGiao.ToString();
//}
row["TyTrongCaNhanSoVoiPhong"] = tyTrongCVDuocGiaoCaNhanSoVoiPhong.ToString().Replace(",", ".");
dtCongViecNew.Rows.Add(row);
}
#endregion
rowHeader = dtCongViecNew.NewRow();
rowHeader["TenCVCha"] = "-----------------Công việc kế hoạch tháng----------------";
rowHeader["Ten"] = "---------------------------";
rowHeader["TyTrong"] = "0";
rowHeader["KeHoach"] = "";
rowHeader["TyTrongCaNhan"] = "0";
rowHeader["GioLamViec"] = "0";
rowHeader["TyTrongCaNhanSoVoiPhong"] = "0";
dtCongViecNew.Rows.Add(rowHeader);
#region Cong viec ke hoach thang
dtCongViec = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS(idNhanVien, 2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
ds = DotDanhGiaController.GetPTDG(idNhanVien, 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
dtSoNhanVien = ds.Tables[1];
dtTyTrong = ds.Tables[2];
dtSoNhanVienPhong = ds.Tables[3];
tongSoNhanVien = 0;
if (dtSoNhanVien != null && dtSoNhanVien.Rows.Count > 0)
{
tongSoNhanVien = ConvertUtility.ToInt32(dtSoNhanVien.Rows[0]["TongSoNhanVien"]);
}
tyTrongCVPhongVoiTrungTam = 0;
if (dtTyTrong != null && dtTyTrong.Rows.Count > 0)
{
tyTrongCVPhongVoiTrungTam = ConvertUtility.ToInt32(dtTyTrong.Rows[0]["TyTrong"]);
}
if (tyTrongCVPhongVoiTrungTam == 0)
{
tyTrongCVPhongVoiTrungTam = 100;
}
tongSoNhanVienPhong = 0;
if (dtSoNhanVienPhong != null && dtSoNhanVienPhong.Rows.Count > 0)
{
tongSoNhanVienPhong = ConvertUtility.ToInt32(dtSoNhanVienPhong.Rows[0]["TongSoNhanVien"]);
}
double tyTrongCVKeHoachThang = 0;
foreach (DataRow item in dtCongViec.Rows)
{
DataRow row = dtCongViecNew.NewRow();
int idCongViecKPI = ConvertUtility.ToInt32(item["IDCongViecKPI"]);
DataTable dtTyTrongKPI = DotDanhGiaController.GetTyTrongCongViec(idCongViecKPI, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropPhongBan.SelectedValue), idNhanVien);
double tyTrongCVDuocGiao = 0;
row["TenCVCha"] = ConvertUtility.ToString(item["TenCVCha"]);
row["Ten"] = item["Ten"];
//double tyTrongCVDuocGiaoCaNhan = 0;
//double tyTrongCVDuocGiaoCaNhanSoVoiPhong = 0;
//if (dtTyTrongKPI != null && dtTyTrongKPI.Rows.Count > 0)
//{
// tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien;
// tyTrongCVKeHoachThang += tyTrongCVDuocGiaoCaNhan;
// double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien * 22 / 100, 2);
// double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 2);
// tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 2);
// tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]), 2);
// row["TyTrong"] = tyTrongCVDuocGiao.ToString();
//}
//else
//{
// tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien;
// tyTrongCVKeHoachThang += tyTrongCVDuocGiaoCaNhan;
// double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien * 22 / 100, 2);
// double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 2);
// tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 2);
// tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]), 2);
// row["TyTrong"] = tyTrongCVDuocGiao.ToString();
//}
//row["KeHoach"] = item["KeHoach"].ToString();
//row["TyTrongCaNhan"] = tyTrongCVDuocGiaoCaNhan.ToString().Replace(",", ".");
//row["GioLamViec"] = Math.Round(tyTrongCVDuocGiaoCaNhan * 22 * 8 / 100, 2);
double tyTrongCVDuocGiaoCaNhan = 0;
double tyTrongCVDuocGiaoCaNhanSoVoiPhong = 0;
if (dtTyTrongKPI != null && dtTyTrongKPI.Rows.Count > 0)
{
tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien;
double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien * 22 / 100, 3);
double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 3);
tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 3);
tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]), 3);
row["TyTrong"] = tyTrongCVDuocGiao;
}
else
{
tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien;
double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien * 22 / 100, 3);
double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 3);
tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 3);
tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]), 3);
row["TyTrong"] = tyTrongCVDuocGiao;
}
row["KeHoach"] = item["KeHoach"].ToString();
row["TyTrongCaNhan"] = Math.Round(tyTrongCVDuocGiaoCaNhan, 3).ToString().Replace(",", ".");// tyTrongCVDuocGiaoCaNhan.ToString().Replace(",", ".");
row["GioLamViec"] = Math.Round(tyTrongCVDuocGiaoCaNhan * 22 * 8 / 100, 3).ToString().Replace(",", ".");
row["TyTrongCaNhanSoVoiPhong"] = tyTrongCVDuocGiaoCaNhanSoVoiPhong.ToString().Replace(",", ".");
dtCongViecNew.Rows.Add(row);
}
#endregion
rowHeader = dtCongViecNew.NewRow();
rowHeader["TenCVCha"] = "-----------------Công việc phát sinh----------------";
rowHeader["Ten"] = "---------------------------";
rowHeader["TyTrong"] = "0";
rowHeader["KeHoach"] = "";
rowHeader["TyTrongCaNhan"] = "0";
rowHeader["GioLamViec"] = "0";
rowHeader["TyTrongCaNhanSoVoiPhong"] = "0";
dtCongViecNew.Rows.Add(rowHeader);
#region Cong viec phat sinh
dtCongViec = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS(idNhanVien, 3, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
ds = DotDanhGiaController.GetPTDG(idNhanVien, 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
dtSoNhanVien = ds.Tables[1];
dtTyTrong = ds.Tables[2];
dtSoNhanVienPhong = ds.Tables[3];
tongSoNhanVien = 0;
if (dtSoNhanVien != null && dtSoNhanVien.Rows.Count > 0)
{
tongSoNhanVien = ConvertUtility.ToInt32(dtSoNhanVien.Rows[0]["TongSoNhanVien"]);
}
tyTrongCVPhongVoiTrungTam = 0;
if (dtTyTrong != null && dtTyTrong.Rows.Count > 0)
{
tyTrongCVPhongVoiTrungTam = ConvertUtility.ToInt32(dtTyTrong.Rows[0]["TyTrong"]);
}
if (tyTrongCVPhongVoiTrungTam == 0)
{
tyTrongCVPhongVoiTrungTam = 100;
}
tongSoNhanVienPhong = 0;
if (dtSoNhanVienPhong != null && dtSoNhanVienPhong.Rows.Count > 0)
{
tongSoNhanVienPhong = ConvertUtility.ToInt32(dtSoNhanVienPhong.Rows[0]["TongSoNhanVien"]);
}
tyTrongCVKeHoachThang = 0;
foreach (DataRow item in dtCongViec.Rows)
{
DataRow row = dtCongViecNew.NewRow();
int idCongViecKPI = ConvertUtility.ToInt32(item["IDCongViecKPI"]);
DataTable dtTyTrongKPI = DotDanhGiaController.GetTyTrongCongViec(idCongViecKPI, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropPhongBan.SelectedValue), idNhanVien);
double tyTrongCVDuocGiao = 0;
row["TenCVCha"] = ConvertUtility.ToString(item["TenCVCha"]);
row["Ten"] = item["Ten"];
//double tyTrongCVDuocGiaoCaNhan = 0;
//double tyTrongCVDuocGiaoCaNhanSoVoiPhong = 0;
//if (dtTyTrongKPI != null && dtTyTrongKPI.Rows.Count > 0)
//{
// tyTrongCVDuocGiaoCaNhan = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien, 2);
// tyTrongCVKeHoachThang += tyTrongCVDuocGiaoCaNhan;
// double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien * 22 / 100, 2);
// double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 2);
// tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 2);
// tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]), 2);
// row["TyTrong"] = tyTrongCVDuocGiao.ToString();
//}
//else
//{
// tyTrongCVDuocGiaoCaNhan = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien, 2);
// tyTrongCVKeHoachThang += tyTrongCVDuocGiaoCaNhan;
// double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien * 22 / 100, 2);
// double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 2);
// tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 2);
// tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]), 2);
// row["TyTrong"] = tyTrongCVDuocGiao.ToString();
//}
//row["KeHoach"] = item["KeHoach"].ToString();
//row["TyTrongCaNhan"] = tyTrongCVDuocGiaoCaNhan.ToString().Replace(",", ".");
//row["GioLamViec"] = Math.Round(tyTrongCVDuocGiaoCaNhan * 22 * 8 / 100, 2);
double tyTrongCVDuocGiaoCaNhan = 0;
double tyTrongCVDuocGiaoCaNhanSoVoiPhong = 0;
if (dtTyTrongKPI != null && dtTyTrongKPI.Rows.Count > 0)
{
tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien;
double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]) * tongSoNhanVien * 22 / 100, 3);
double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 3);
tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 3);
tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(dtTyTrongKPI.Rows[0]["TyTrong"]), 3);
row["TyTrong"] = tyTrongCVDuocGiao;
}
else
{
tyTrongCVDuocGiaoCaNhan = ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien;
double songaylamvieccuaNV = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]) * tongSoNhanVien * 22 / 100, 3);
double tongsongaylamvieccuaphong = Math.Round(ConvertUtility.ToDouble(tongSoNhanVien) * 22 * tyTrongCVPhongVoiTrungTam / 100, 3);
tyTrongCVDuocGiaoCaNhanSoVoiPhong = Math.Round(songaylamvieccuaNV * 100 / tongsongaylamvieccuaphong, 3);
tyTrongCVDuocGiao = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]), 3);
row["TyTrong"] = tyTrongCVDuocGiao;
}
row["KeHoach"] = item["KeHoach"].ToString();
row["TyTrongCaNhan"] = Math.Round(tyTrongCVDuocGiaoCaNhan, 3).ToString().Replace(",", ".");// tyTrongCVDuocGiaoCaNhan.ToString().Replace(",", ".");
row["GioLamViec"] = Math.Round(tyTrongCVDuocGiaoCaNhan * 22 * 8 / 100, 3).ToString().Replace(",", ".");
row["TyTrongCaNhanSoVoiPhong"] = tyTrongCVDuocGiaoCaNhanSoVoiPhong.ToString().Replace(",", ".");
dtCongViecNew.Rows.Add(row);
}
#endregion
XmlDocument doc = BuildXmlDocument(dtCongViecNew);
if (!Directory.Exists(Server.MapPath("/UpLoad/Temp/" + itemNhanVien["UserID"].ToString() + "/")))
{
Directory.CreateDirectory(Server.MapPath("/UpLoad/Temp/" + itemNhanVien["UserID"].ToString() + "/"));
}
////ds.Dispose();
string datetime = DateTime.Now.ToString("yyyyMMddHHmmss");
FileStream downloadFile =
File.Create(Server.MapPath("/UpLoad/Temp/" + itemNhanVien["UserID"].ToString() + "/") + "ReportCongViecNhanVien_" + datetime +
".xls");
// transform
XslTransform xsl = new XslTransform();
xsl.Load(Server.MapPath("/Template/" + "ReportCongViecNhanVien.xsl"));
DateConverter objDateConverter = new DateConverter();
XsltArgumentList args = new XsltArgumentList();
args.AddExtensionObject("urn:ms-kb", objDateConverter);
xsl.Transform(doc, args, downloadFile, null);
downloadFile.Flush();
downloadFile.Close();
HyperLink hplDownload = new HyperLink();
hplDownload.Text = "Công việc của " + itemNhanVien["Username"].ToString() + ", click vào link để Tải file về";
hplDownload.Visible = true;
hplDownload.NavigateUrl = "/UpLoad/Temp/" + itemNhanVien["UserID"].ToString() + "/ReportCongViecNhanVien_" + datetime + ".xls";
Literal lit = new Literal();
lit.Text = "<br />";
pnLink.Controls.Add(hplDownload);
pnLink.Controls.Add(lit);
CreateExcelDoc excell_app = new CreateExcelDoc(sheet, xlWorkBook, itemNhanVien["UserName"].ToString());
//creates the main header
excell_app.createHeaders(1, 1, "Nhóm công việc", "A1", "A1", 0, "YELLOW", true, 40, "");
excell_app.createHeaders(1, 2, "Tên công việc", "B1", "B1", 0, "YELLOW", true, 40, "");
excell_app.createHeaders(1, 3, "Kế hoạch", "C1", "C1", 0, "YELLOW", true, 40, "");
excell_app.createHeaders(1, 4, "Tỷ Trọng so với trung tâm", "D1", "D1", 0, "YELLOW", true, 20, "");
excell_app.createHeaders(1, 5, "Tỷ Trọng so với phòng", "E1", "E1", 0, "YELLOW", true, 20, "");
excell_app.createHeaders(1, 6, "Tỷ Trọng công việc cá nhân trong tháng", "F1", "F1", 0, "YELLOW", true, 20, "");
excell_app.createHeaders(1, 7, "Giờ làm việc", "G1", "G1", 0, "YELLOW", true, 20, "");
int rowIndex = 2;
foreach (DataRow item in dtCongViecNew.Rows)
{
excell_app.addData(rowIndex, 1, item["TenCVCha"].ToString(), "A" + rowIndex.ToString(), "A" + rowIndex.ToString(), "");
excell_app.addData(rowIndex, 2, item["Ten"].ToString(), "B" + rowIndex.ToString(), "B" + rowIndex.ToString(), "");
excell_app.addData(rowIndex, 3, item["KeHoach"].ToString(), "C" + rowIndex.ToString(), "C" + rowIndex.ToString(), "");
excell_app.addData(rowIndex, 4, item["TyTrong"].ToString(), "D" + rowIndex.ToString(), "D" + rowIndex.ToString(), "#,##0");
excell_app.addData(rowIndex, 5, item["TyTrongCaNhanSoVoiPhong"].ToString(), "E" + rowIndex.ToString(), "E" + rowIndex.ToString(), "#,##0");
excell_app.addData(rowIndex, 6, item["TyTrongCaNhan"].ToString(), "F" + rowIndex.ToString(), "F" + rowIndex.ToString(), "#,##0");
excell_app.addData(rowIndex, 7, item["GioLamViec"].ToString(), "G" + rowIndex.ToString(), "G" + rowIndex.ToString(), "");
rowIndex++;
}
sheet++;
}
string datetimeTTPhong = DateTime.Now.ToString("yyyyMMddHHmmss");
string fileName = "/UpLoad/Temp/ReportCongViecNhanVien_" + datetimeTTPhong + ".xls";
CreateExcelDoc.SaveExcel(Server.MapPath(fileName), xlWorkBook);
HyperLink hplDownloadCVPhongTT = new HyperLink();
hplDownloadCVPhongTT.Text = "Công việc của Trung Tâm hoặc phòng, click vào link để Tải file về";
hplDownloadCVPhongTT.Visible = true;
hplDownloadCVPhongTT.NavigateUrl = fileName;
pnLink.Controls.Add(hplDownloadCVPhongTT);
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
dropDotDanhGia.DataSource = DotDanhGiaController.GetAll(1);
dropDotDanhGia.DataBind();
if (Session["IDDotDanhGia"] != null)
{
dropDotDanhGia.SelectedValue = Session["IDDotDanhGia"].ToString();
}
else
{
int idDotDanhActive = ConvertUtility.ToInt32(DotDanhGiaController.GetDaultDotDanhGia().Rows[0]["ID"]);
dropDotDanhGia.SelectedValue = idDotDanhActive.ToString();
}
dropTrungTam.DataSource = BoPhanController.GetAll();
dropTrungTam.DataBind();
if (Session["IDTrungTam"] != null)
{
dropTrungTam.SelectedValue = Session["IDTrungTam"].ToString();
}
else
{
dropTrungTam.SelectedValue = CurrentUser.IDTrungTam.ToString();
}
lstNhanVien.Items.Clear();
DataTable dtNhanVien = null;
if (!CurrentUser.IsAdmin && !CurrentUser.IsSuperAdmin)
{
dtNhanVien = DotDanhGiaController.QuanLyNhanVienTheoNDG_ByNhanVienQuanLy(CurrentUser.UserID, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
}
else
{
dtNhanVien = DotDanhGiaController.GetAllNhanVien(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
}
if (dtNhanVien != null && dtNhanVien.Rows.Count > 0)
{
DataTable dtNew = dtNhanVien.Clone();
foreach (DataRow item in dtNhanVien.Rows)
{
DataRow rowNew = dtNew.NewRow();
rowNew["UserID"] = item["UserID"];
DataTable dtCongViec = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS_6_11_2014(ConvertUtility.ToInt32(item["UserID"]), 1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
double tyTrongCVDuocGiao = 0;
foreach (DataRow row in dtCongViec.Rows)
{
tyTrongCVDuocGiao += Math.Round(ConvertUtility.ToDouble(row["TyTrong"]), 3);
}
rowNew["UserName"] = "******" + tyTrongCVDuocGiao + "%) " + item["UserName"].ToString();
dtNew.Rows.Add(rowNew);
}
lstNhanVien.DataSource = dtNew;
lstNhanVien.DataBind();
int idNhanVien = 0;
if (Session["IDNhanVien"] != null)
{
idNhanVien = ConvertUtility.ToInt32(Session["IDNhanVien"]);
try
{
lstNhanVien.SelectedValue = idNhanVien.ToString();
}
catch
{
}
}
lstCongViecDuocGiao.Items.Clear();
QuanLyCongViecKTXVaPSController.LoadCongViec(lstCongViecDuocGiao.Items, ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, 1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
lstCongViec.Items.Clear();
QuanLyCongViecKTXVaPSController.LoadCongViecChuaDuocGiao(lstCongViec.Items, ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, 1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
if (idNhanVien > 0)
{
DataTable dtCongViecTX = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS_6_11_2014(idNhanVien, 1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
DataTable dtCongViecTXNew = dtCongViecTX.Clone();
try
{
lstNhanVien.SelectedValue = idNhanVien.ToString();
}
catch (Exception)
{
lstNhanVien.SelectedIndex = -1;
}
#region Cong Viec Thuong Xuyen
foreach (ListItem item in lstCongViecDuocGiao.Items)
{
if (dtCongViecTX.Select("IDCongViecKPI = " + item.Value).Length > 0)
{
item.Attributes.Add("style", "color:blue");
}
}
foreach (DataRow item in dtCongViecTX.Rows)
{
DataRow row = dtCongViecTXNew.NewRow();
row["ID"] = ConvertUtility.ToString(item["ID"]);
row["TenCVCha"] = ConvertUtility.ToString(item["TenCVCha"]);
row["Ten"] = item["Ten"];
row["NgayBatDau"] = ConvertUtility.ToDateTime(item["NgayBatDau"]); //.ToString("dd/MM/yyyy");
row["NgayKetThuc"] = ConvertUtility.ToDateTime(item["NgayKetThuc"]); //.ToString("dd/MM/yyyy");
row["KeHoach"] = item["KeHoach"].ToString().Replace("\n", "<br /><br />").Replace("\r", "<br /><br />");
row["TyTrong"] = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]), 2).ToString();
row["SoGio"] = Math.Round(ConvertUtility.ToDouble(item["SoGio"]), 2).ToString();
dtCongViecTXNew.Rows.Add(row);
}
dgrNhanVienCVTX.DataSource = dtCongViecTXNew;
#endregion
#region ty trong cong viec da giao
DataTable dtCongViecThuongXuyen = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS(idNhanVien, 1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
double tyTrongCVThuongXuyen = 0;
double SoGioCVThuongXuyen = 0;
foreach (DataRow item in dtCongViecThuongXuyen.Rows)
{
tyTrongCVThuongXuyen += ConvertUtility.ToDouble(item["TyTrong"]);
SoGioCVThuongXuyen += ConvertUtility.ToDouble(item["SoGio"]);
}
DataTable dtCongViecKTH = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS(idNhanVien, 2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
double tyTrongCVKeHoachThang = 0;
double SoGioCVKeHoachThang = 0;
foreach (DataRow item in dtCongViecKTH.Rows)
{
tyTrongCVKeHoachThang += ConvertUtility.ToDouble(item["TyTrong"]);
SoGioCVKeHoachThang += ConvertUtility.ToDouble(item["SoGio"]);
}
DataTable dtCongViecPhatSinh = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS(idNhanVien, 3, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
double tyTrongCVPhatSinh = 0;
double SoGioCVPhatSinh = 0;
foreach (DataRow item in dtCongViecPhatSinh.Rows)
{
tyTrongCVPhatSinh += ConvertUtility.ToDouble(item["TyTrong"]);
SoGioCVPhatSinh += ConvertUtility.ToDouble(item["SoGio"]);
}
lblTyTrongCVThuongXuyen.Text = Math.Round(tyTrongCVThuongXuyen, 2).ToString() + "% <br/>" + Math.Round(SoGioCVThuongXuyen, 2).ToString() + "h";
lblTyTrongCVKeHoachThang.Text = Math.Round(tyTrongCVKeHoachThang, 2).ToString() + "% <br/>" + Math.Round(SoGioCVKeHoachThang, 2).ToString() + "h";
lblTyTrongCVPhatSinh.Text = Math.Round(tyTrongCVPhatSinh, 2).ToString() + "% <br/>" + Math.Round(SoGioCVPhatSinh, 2).ToString() + "h";
lblTongTyTrong.Text = Math.Round((tyTrongCVThuongXuyen + tyTrongCVKeHoachThang + tyTrongCVPhatSinh), 2) + "% <br />" + Math.Round((SoGioCVThuongXuyen + SoGioCVKeHoachThang + SoGioCVPhatSinh), 2) + "h";
#endregion
}
}
dgrNhanVienCVTX.DataBind();
}
//protected void dropTrungTam_SelectedIndexChanged(object sender, EventArgs e)
//{
// dropPhongBan.Items.Clear();
// dropPhongBan.DataSource = DotDanhGiaController.GetAllPhongBan(ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
// dropPhongBan.DataBind();
// dropPhongBan.Items.Insert(0, new ListItem("----------Lựa chọn----------", "0"));
//}
//protected void dropPhongBan_SelectedIndexChanged(object sender, EventArgs e)
//{
//}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
DataTable dt = new DataTable();
dt.Columns.Add("HoTen", typeof(String));
dt.Columns.Add("ChucVu", typeof(String));
dt.Columns.Add("TTCVThuongXuyen", typeof(String));
dt.Columns.Add("TTCVKeHoachThang", typeof(String));
dt.Columns.Add("TTCVPhatSinh", typeof(String));
dt.Columns.Add("TTConLai", typeof(String));
//dt.Columns.Add("TTSoVoiBoPhan", typeof(String));
DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVien(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0);
if (dtNhanVien == null)
{
return;
}
foreach (DataRow itemNhanVien in dtNhanVien.Rows)
{
DataRow row = dt.NewRow();
#region Ty Trong Cong Viec
double totalCVTX = 0;
double totalCVKTX = 0;
double totalCVPS = 0;
double total = 0;
double totalCVTX_Gio = 0;
double totalCVKTX_Gio = 0;
double totalCVPS_Gio = 0;
double total_Gio = 0;
idNhanVien = ConvertUtility.ToInt32(itemNhanVien["UserID"]);
string HoTen = "";
string ChucVu = "";
DataTable dtUserInfo = DotDanhGiaController.GetUserInfo(idNhanVien);
if (dtUserInfo != null && dtUserInfo.Rows.Count > 0)
{
HoTen = dtUserInfo.Rows[0]["HoTen"].ToString();
ChucVu = dtUserInfo.Rows[0]["ChucVu"].ToString();
}
DataTable dtCongViecThuongXuyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), idNhanVien);
foreach (DataRow item in dtCongViecThuongXuyen.Rows)
{
totalCVTX += ConvertUtility.ToDouble(item["TyTrongCV"]);
totalCVTX_Gio += ConvertUtility.ToDouble(item["SoGio"]);
}
DataTable dtCongViecKhongThuonguyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), idNhanVien);
foreach (DataRow item in dtCongViecKhongThuonguyen.Rows)
{
totalCVKTX += ConvertUtility.ToDouble(item["TyTrongCV"]);
totalCVKTX_Gio += ConvertUtility.ToDouble(item["SoGio"]);
}
DataTable dtCongViecPhatSinh = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(3, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), idNhanVien);
foreach (DataRow item in dtCongViecPhatSinh.Rows)
{
totalCVPS += ConvertUtility.ToDouble(item["TyTrongCV"]);
totalCVPS_Gio += ConvertUtility.ToDouble(item["SoGio"]);
}
row["HoTen"] = HoTen;
row["ChucVu"] = ChucVu;
row["TTCVThuongXuyen"] = Math.Round(totalCVTX, 2) + "% (" + totalCVTX_Gio + "h)";
row["TTCVKeHoachThang"] = Math.Round(totalCVKTX, 2) + "% (" + totalCVKTX_Gio + "h)";
row["TTCVPhatSinh"] = Math.Round(totalCVPS, 2) + "% (" + totalCVPS_Gio + "h)";
total = totalCVTX + totalCVKTX + totalCVPS;
total_Gio = totalCVTX_Gio + totalCVKTX_Gio + totalCVPS_Gio;
double totalCVPhatSinh = Math.Round((100 - total), 2);
double totalCVPhatSinh_Gio = Math.Round((176 - total_Gio), 2);
if (totalCVPhatSinh > 0)
{
row["TTConLai"] = totalCVPhatSinh + "% (" + totalCVPhatSinh_Gio + "h)";
}
else
{
row["TTConLai"] = "0%";
}
dt.Rows.Add(row);
#endregion
}
dgrBaoCao.DataSource = dt;
dgrBaoCao.DataBind();
}
