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 btnLayCongViecThangTruoc_Click(object sender, EventArgs e) { QuanLyCongViecKTXVaPSController.ClearAllCongViecTheoBoPhanVaDotDanhGia(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 1); #region Copy cong viec thuong xuyen cua thang truoc DataTable dt = new DataTable(); dt.Columns.Add("ID", typeof(string)); dt.Columns.Add("Ten", typeof(string)); dt.Columns.Add("TyTrong", typeof(string)); dt.Columns.Add("SoGio", typeof(string)); dt.Columns.Add("ParentID", typeof(string)); dt.Columns.Add("Priority", typeof(string)); dt.Columns.Add("KeHoach", typeof(string)); dt.Columns.Add("DonViDo", typeof(string)); dt.Columns.Add("IDTrungTam", typeof(string)); dt.Columns.Add("IDPhongBan", typeof(string)); dt.Columns.Add("Loai", typeof(string)); dt.Columns.Add("IDDotDanhGia", typeof(string)); dt.Columns.Add("LevelDeep", typeof(string)); dt.Columns.Add("NgayBatDau", typeof(string)); dt.Columns.Add("NgayKetThuc", typeof(string)); dt.Columns.Add("TrangThaiCV", typeof(string)); dt.Columns.Add("TuanLamViec", typeof(string)); dt.Columns.Add("IDNhomCongViec", typeof(string)); DataTable source = QuanLyCongViecKTXVaPSController.LoadCongViecForCopyNew(dt, ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, 1, ConvertUtility.ToInt32(dropDotDanhGiaCopy.SelectedValue)); DataRow[] row = source.Select("ParentID=0"); int parentId = 0; foreach (DataRow item in row) { QuanLyCongViecKTXVaPSInfo info = new QuanLyCongViecKTXVaPSInfo(); info.Ten = ConvertUtility.ToString(item["Ten"]); info.TyTrong = ConvertUtility.ToDouble(item["TyTrong"]); info.SoGio = ConvertUtility.ToDouble(item["SoGio"]); info.ParentID = 0; info.Priority = ConvertUtility.ToInt32(item["Priority"]); info.KeHoach = ConvertUtility.ToString(item["KeHoach"]); info.DonViDo = ConvertUtility.ToString(item["DonViDo"]); info.IDTrungTam = ConvertUtility.ToInt32(item["IDTrungTam"]); info.IDPhongBan = ConvertUtility.ToInt32(item["IDPhongBan"]); info.Loai = ConvertUtility.ToInt32(item["Loai"]); info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.LevelDeep = ConvertUtility.ToInt32(item["LevelDeep"]); info.NgayBatDau = ConvertUtility.ToDateTime(item["NgayBatDau"]).AddMonths(1); info.NgayKetThuc = ConvertUtility.ToDateTime(item["NgayKetThuc"]).AddMonths(1); info.TrangThaiCV = ConvertUtility.ToInt32(item["TrangThaiCV"]); info.TuanLamViec = ConvertUtility.ToString(item["TuanLamViec"]); info.IDNhomCongViec = ConvertUtility.ToInt32(item["IDNhomCongViec"]); if (ConvertUtility.ToInt32(item["ID"]) == 31279) { string a = "a"; } info.OldID = ConvertUtility.ToInt32(item["ID"]); try { parentId = QuanLyCongViecKTXVaPSController.Insert_6_11_2014(info); #region Log Action LogFileInfo logFileInfo = new LogFileInfo(); logFileInfo.Log_Action = "Add"; logFileInfo.Log_Type_Object = "QuanLyCongViecKPI"; logFileInfo.Item_CatID = "Cong Viec thuong xuyen"; logFileInfo.Item_ID = info.ID.ToString(); logFileInfo.Item_Name = info.Ten; logFileInfo.Description_Before = "Old Data: "; logFileInfo.Description_After = "Add KPI with info: <br />" + GetObjectInfo(info); logFileInfo.UserName = CurrentUser.Username; logFileInfo.UserID = CurrentUser.UserID; CreateLogFile.LogAction(logFileInfo); #endregion InsertCongViecCon(source, item, parentId, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue)); lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS; } catch (Exception ex) { lblStatusUpdate.Text = ex.Message; } } UpdateCapDoCongViec(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue)); #endregion #region Lay cac nhan vien va cac cong viec duoc giao thang truoc --> thuc hien giao viec //lay tat ca nhan vien cua trung tam DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVienTemp(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0); foreach (DataRow item in dtNhanVien.Rows) { try { string[] array = item["UserID"].ToString().Split('_'); int idNhanVien = ConvertUtility.ToInt32(array[0]); int idBoPhan = ConvertUtility.ToInt32(array[2]); DataSet ds = DotDanhGiaController.GetPTDG(idNhanVien, ConvertUtility.ToInt32(item["IDPhong"])); DataTable dtNDG = ds.Tables[0]; int idNguoiDanhGia = 0; if (dtNDG != null && dtNDG.Rows.Count > 0) { idNguoiDanhGia = ConvertUtility.ToInt32(dtNDG.Rows[0]["IDNguoiDG"]); } DotDanhGiaController.UpdateNhanVienVaoDotDanhGia(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), idNhanVien, ConvertUtility.ToInt32(array[2]), ConvertUtility.ToInt32(array[1]), idNguoiDanhGia, 0); #region Update cong viec cho nhan vien theo thang DataTable dtCongViec = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS_6_11_2014(idNhanVien, 1, ConvertUtility.ToInt32(dropDotDanhGiaCopy.SelectedValue)); if (dtCongViec != null && dtCongViec.Rows.Count > 0) { foreach (DataRow rowCV in dtCongViec.Rows) { DanhGiaThang_DGCBCNVDanhGiaTTCVInfo info = new DanhGiaThang_DGCBCNVDanhGiaTTCVInfo(); info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.IDNhanVien = idNhanVien; info.TenCongViec = ConvertUtility.ToString(rowCV["Ten"]); int idCongViecKPI = ConvertUtility.ToInt32(rowCV["IDCongViecKPI"]); QuanLyCongViecKTXVaPSInfo infoCongViecKPI = QuanLyCongViecKTXVaPSController.GetInfoByOldID(idCongViecKPI); if (infoCongViecKPI != null) { info.IDBoPhan = ConvertUtility.ToInt32(rowCV["IDBoPhan"]); info.IDPhongBan = ConvertUtility.ToInt32(rowCV["IDPhongBan"]); info.TyTrongCV = Math.Round(ConvertUtility.ToDouble(rowCV["TyTrong"]), 2); info.SoGio = Math.Round(ConvertUtility.ToDouble(rowCV["SoGio"]), 2); DotDanhGiaController.UpdateCongViecChoNhanVien(idNhanVien, infoCongViecKPI.ID, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), info.IDBoPhan, info.IDPhongBan, info.TyTrongCV, info.SoGio); info.SoLieuCamKet = ConvertUtility.ToString(rowCV["KeHoach"]); info.YeuCauHoTro = ""; info.Loai = 1; info.IDCongViec = infoCongViecKPI.ID; info.IDBoPhanHoTro = 0; info.IDBoPhan = ConvertUtility.ToInt32(rowCV["IDBoPhan"]); info.IDPhongBan = ConvertUtility.ToInt32(rowCV["IDPhongBan"]); info.NgayBatDau = ConvertUtility.ToDateTime(rowCV["NgayBatDau"]).AddMonths(1); info.NgayKetThuc = ConvertUtility.ToDateTime(rowCV["NgayKetThuc"]).AddMonths(1); DanhGiaThang_DGCBCNVDanhGiaTTCVController.InsertKeHoachThang(info); } } } #endregion } catch (Exception ex) { throw ex; } } #endregion Session["Nav"] = "1"; }