protected void btnSearch_Click(object sender, EventArgs e) { if (fileImport.HasFile) { if (!Directory.Exists(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/"))) { Directory.CreateDirectory(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/")); } string date = DateTime.Now.ToString("yyyyMMddHHmmss"); string path = Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(".csv", "") + "_Temp_" + date + ".csv"; if (File.Exists(path)) { File.Delete(path); } fileImport.PostedFile.SaveAs(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(".csv", "") + "_Temp_" + date + ".csv"); if (File.Exists(path)) { DataTable returnTable = ImportExcelToDataTable.ConvertCSVtoDataTable(path); if (returnTable != null && returnTable.Rows.Count > 0) { for (int i = 0; i < returnTable.Rows.Count; i++) { try { DataRow row = returnTable.Rows[i]; #region Import TongHopDanhGiaCaNhanThangInfo info = new TongHopDanhGiaCaNhanThangInfo(); info.BoPhan = row[0].ToString(); info.HoTen = row[1].ToString(); info.KPI = ConvertUtility.ToDouble(row[2].ToString().Replace(".", ",")) * 100; info.DiemDanhGiaDonVi = ConvertUtility.ToDouble(row[3].ToString().Replace(".", ",")) * 100; info.LoiNhuanCongTy = ConvertUtility.ToDouble(row[4].ToString().Replace(".", ",")) * 100; info.LoiNhuanBoPhan = ConvertUtility.ToDouble(row[5].ToString().Replace(".", ",")) * 100; info.QuanLyCongViecVaPhoiHop = ConvertUtility.ToDouble(row[6].ToString().Replace(".", ",")) * 100; info.KyLuatCaNhan = ConvertUtility.ToDouble(row[7].ToString().Replace(".", ",")) * 100; info.DiemThuong = ConvertUtility.ToDouble(row[8].ToString().Replace(".", ",")); info.MucDoHoanThanh = ConvertUtility.ToDouble(row[9].ToString().Replace(".", ",")) * 100; info.XepLoai = row[10].ToString(); info.HeSoLuongMem = ConvertUtility.ToDouble(row[11].ToString().Replace(".", ",")) * 100; info.Nam = ConvertUtility.ToInt32(dropNam.SelectedValue); info.Thang = ConvertUtility.ToInt32(dropThang.SelectedValue); TongHopDanhGiaCaNhanThangController.Insert(info); #endregion } catch { continue; } } lblUpdateStatus.Text = "Bạn đã import thành công file \"" + fileImport.FileName + "\""; } else { lblUpdateStatus.Text = "File import sai định dạng"; } } else { lblUpdateStatus.Text = "File import sai định dạng"; } } else { lblUpdateStatus.Text = "File import sai định dạng"; } }
protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); DataTable dtUsers = UserController.GetKetQuaDanhGia(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue)); DataTable dtUsersTemp = dtUsers.Clone(); dtUsersTemp.Columns.Add("MucDoHoanThanh", typeof(double)); dtUsersTemp.Columns.Add("XepLoai", typeof(string)); dtUsersTemp.Columns.Add("Rank", typeof(string)); double tbKetquaHTKHHD = 0; double tbDiemPhoiHop = 0; double tbDiemSangTao = 0; double tbDiemKyLuat = 0; double tbDiemMucDoHoanThanh = 0; foreach (DataRow item in dtUsers.Rows) { double KetquaHTKHHD = ConvertUtility.ToDouble(item["KetquaHTKHHD"]); double DiemPhoiHop = ConvertUtility.ToDouble(item["DiemPhoiHop"]); double DiemSangTao = ConvertUtility.ToDouble(item["DiemSangTao"]); double DiemKyLuat = ConvertUtility.ToDouble(item["DiemKyLuat"]); if (DiemSangTao == 0) { DiemSangTao = 100; } if (DiemPhoiHop == 0) { DiemPhoiHop = 100; } tbKetquaHTKHHD += KetquaHTKHHD; tbDiemPhoiHop += DiemPhoiHop; tbDiemSangTao += DiemSangTao; tbDiemKyLuat += DiemKyLuat; double tong = KetquaHTKHHD * 75 / 100; tong += DiemPhoiHop * 10 / 100; tong += DiemSangTao * 5 / 100; tong += DiemKyLuat * 10 / 100; tong = Math.Round(tong, 1); tbDiemMucDoHoanThanh += tong; DataRow row = dtUsersTemp.NewRow(); row["ID"] = item["ID"]; row["Ten"] = item["Ten"]; row["KetquaHTKHHD"] = item["KetquaHTKHHD"]; row["DiemPhoiHop"] = DiemPhoiHop; row["DiemSangTao"] = DiemSangTao; row["DiemKyLuat"] = item["DiemKyLuat"]; row["MucDoHoanThanh"] = tong;//.ToString().Substring(0, tong.ToString().IndexOf(',')) + "," + tong.ToString().Substring(tong.ToString().IndexOf(',') + 1,1); row["XepLoai"] = GetXepLoai(tong); dtUsersTemp.Rows.Add(row); } DataTable dtBoPhan = RankDt(dtUsersTemp, "MucDoHoanThanh"); foreach (DataRow item in dtUsersTemp.Rows) { item["Rank"] = dtBoPhan.Select(" ID='" + item["ID"] + "'")[0]["RankTemp"]; item["DiemSangTao"] = dtBoPhan.Select(" ID='" + item["ID"] + "'")[0]["DiemSangTao"]; item["DiemPhoiHop"] = dtBoPhan.Select(" ID='" + item["ID"] + "'")[0]["DiemPhoiHop"]; } dgrBoPhan.DataSource = dtUsersTemp; dgrBoPhan.RowDataBound += new GridViewRowEventHandler(dgrBoPhan_RowDataBound); dgrBoPhan.DataBind(); lblTotalTop.Text = lblTotalBottom.Text = dtUsers.Rows.Count.ToString(); int i = dtUsers.Rows.Count; lblTBKetQuaKHHD.Text = Math.Round(tbKetquaHTKHHD / i, 1).ToString() + "%"; tblTBDiemPhoiHop.Text = Math.Round(tbDiemPhoiHop / i, 1).ToString() + "%"; lblTBDiemSangTao.Text = Math.Round(tbDiemSangTao / i, 1).ToString() + "%"; lblTBKyLuat.Text = Math.Round(tbDiemKyLuat / i, 1).ToString() + "%"; lblTBMucDoHoanThanh.Text = Math.Round(tbDiemMucDoHoanThanh / i, 1).ToString() + "%"; }
protected void cmdUpdate_Click(object sender, EventArgs e) { QuanLyCongViecBaoCaoNgayInfo info = QuanLyCongViecBaoCaoNgayController.GetInfo(ConvertUtility.ToInt32(txtID.Text)); if (info == null) { cmdEmpty_Click(null, null); return; } if (info.ID == ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue)) { lblStatusUpdate.Text = "Trung mục cha"; return; } string oldData = GetObjectInfo(info); info.IDCongViecKPI = ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue); info.Ten = txtName.Text; info.KeHoach = txtKeHoach.Text; info.ParentID = txtCongViecLon.Text; info.TyTrong = 0;// ConvertUtility.ToDouble(txtTyTrong.Text); info.KetQua = txtKetqua.Text; info.TyLeHoanThanh = dropTyLeHoanThanh.SelectedValue; info.IDTrungTam = CurrentUser.IDTrungTam; info.IDPhongBan = CurrentUser.IDPhong; info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.SoGio = ConvertUtility.ToDouble(txtSoGio.Text); info.CreateBy = CurrentUser.UserID; info.LyDo = txtLyDo.Text; info.DeXuat = txtDeXuat.Text; info.CreatedOn = new DateTime(ConvertUtility.ToInt32(dropYear.SelectedValue), ConvertUtility.ToInt32(dropMonth.SelectedValue), ConvertUtility.ToInt32(dropDay.SelectedValue)); try { QuanLyCongViecBaoCaoNgayController.Update(info); lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS; #region Log Action LogFileInfo logFileInfo = new LogFileInfo(); logFileInfo.Log_Action = "Update"; logFileInfo.Log_Type_Object = "QuanLyCongViecKPITheoNgay"; logFileInfo.Item_CatID = "Cong Viec Thuong Xuyen"; logFileInfo.Item_ID = info.ID.ToString(); logFileInfo.Item_Name = info.Ten; logFileInfo.Description_Before = "Old Data: " + oldData; logFileInfo.Description_After = "Update KPI with info: <br />" + GetObjectInfo(info); logFileInfo.UserName = CurrentUser.Username; logFileInfo.UserID = CurrentUser.UserID; CreateLogFile.LogAction(logFileInfo); #endregion cmdEmpty_Click(null, null); //Response.Redirect(AppEnv.AdminUrlParams("baocaongay")); } catch (Exception ex) { lblStatusUpdate.Text = ex.Message; } }
protected string GetThoiGian(object tytrong) { return Math.Round(ConvertUtility.ToDouble(tytrong) * 22 * 8 / 100, 3).ToString(); }
private static double GetExpire() { return(ConvertUtility.ToDouble(ConfigurationSettings.AppSettings.Get("news_expired"))); }
private static EbayOrderHeaderType AddOrderHeader(OrderType orderType) { EbayOrderHeaderType ebayOrderHeaderType = new EbayOrderHeaderType(); ebayOrderHeaderType.OrderID = orderType.OrderID; ebayOrderHeaderType.AdjustmentAmount = orderType.AdjustmentAmount.Value; ebayOrderHeaderType.AmountPaid = orderType.AmountPaid.Value; ebayOrderHeaderType.AmountSaved = orderType.AmountSaved.Value; ebayOrderHeaderType.BuyerCheckoutMessage = orderType.BuyerCheckoutMessage == null ? "" : orderType.BuyerCheckoutMessage.ToString().Replace("'", "''"); ebayOrderHeaderType.BuyerUserID = orderType.BuyerUserID.ToString().Replace("'", "''"); ebayOrderHeaderType.eBayPaymentStatus = orderType.CheckoutStatus.eBayPaymentStatus.ToString().Replace("'", "''"); ebayOrderHeaderType.PaymentMethod = orderType.CheckoutStatus.PaymentMethod.ToString().Replace("'", "''"); if (orderType.CreatedTime.ToLocalTime() <= ConvertUtility.ToDateTime("1901-01-01 00:00:00")) { ebayOrderHeaderType.CreatedTime = (DateTime)SqlDateTime.MinValue; } else { ebayOrderHeaderType.CreatedTime = orderType.CreatedTime.ToLocalTime(); } ebayOrderHeaderType.ExtendedOrderID = orderType.ExtendedOrderID == null ? "" : orderType.ExtendedOrderID.ToString(); ebayOrderHeaderType.OrderStatus = orderType.OrderStatus.ToString(); if (orderType.PaidTime.ToLocalTime() <= ConvertUtility.ToDateTime("1901-01-01 00:00:00")) { ebayOrderHeaderType.PaidTime = (DateTime)SqlDateTime.MinValue; } else { ebayOrderHeaderType.PaidTime = orderType.PaidTime.ToLocalTime(); } if (orderType.PaymentHoldDetails == null) { ebayOrderHeaderType.PaymentExpectedReleaseDate = (DateTime)SqlDateTime.MinValue; ebayOrderHeaderType.PaymentHoldReason = ""; } else { if (orderType.PaymentHoldDetails.ExpectedReleaseDate.ToLocalTime() <= ConvertUtility.ToDateTime("1901-01-01 00:00:00")) { ebayOrderHeaderType.PaymentExpectedReleaseDate = (DateTime)SqlDateTime.MinValue; } else { ebayOrderHeaderType.PaymentExpectedReleaseDate = orderType.PaymentHoldDetails.ExpectedReleaseDate.ToLocalTime(); } ebayOrderHeaderType.PaymentHoldReason = orderType.PaymentHoldDetails.PaymentHoldReason.ToString(); } ebayOrderHeaderType.PaymentHoldStatus = orderType.PaymentHoldStatus.ToString(); ebayOrderHeaderType.SellerEmail = orderType.SellerEmail.Replace("'", "''"); ebayOrderHeaderType.SellerUserID = orderType.SellerUserID.Replace("'", "''"); ebayOrderHeaderType.AddressID = orderType.ShippingAddress.AddressID; ebayOrderHeaderType.CityName = orderType.ShippingAddress.CityName.Replace("'", "''"); ebayOrderHeaderType.Country = orderType.ShippingAddress.Country.ToString(); ebayOrderHeaderType.CountryName = orderType.ShippingAddress.CountryName.ToString().Replace("'", "''"); ebayOrderHeaderType.ExternalAddressID = orderType.ShippingAddress.ExternalAddressID == null ? "" : orderType.ShippingAddress.ExternalAddressID.ToString(); ebayOrderHeaderType.Name = orderType.ShippingAddress.Name == null ? "" : orderType.ShippingAddress.Name.ToString().Replace("'", "''"); ebayOrderHeaderType.Phone = orderType.ShippingAddress.Phone == null ? "" : orderType.ShippingAddress.Phone.ToString().Replace("'", "''"); ; ebayOrderHeaderType.PostalCode = orderType.ShippingAddress.PostalCode == null ? "" : orderType.ShippingAddress.PostalCode.ToString().Replace("'", "''"); ebayOrderHeaderType.StateOrProvince = orderType.ShippingAddress.StateOrProvince == null ? "" : orderType.ShippingAddress.StateOrProvince.ToString().Replace("'", "''"); ebayOrderHeaderType.Street1 = orderType.ShippingAddress.Street1 == null ? "" : orderType.ShippingAddress.Street1.ToString().Replace("'", "''"); ebayOrderHeaderType.Street2 = orderType.ShippingAddress.Street2 == null ? "" : orderType.ShippingAddress.Street2.ToString().Replace("'", "''"); ebayOrderHeaderType.SalesTaxAmount = orderType.ShippingDetails.SalesTax.SalesTaxAmount == null ? 0 : orderType.ShippingDetails.SalesTax.SalesTaxAmount.Value; ebayOrderHeaderType.SalesTaxPerecent = ConvertUtility.ToDouble(orderType.ShippingDetails.SalesTax.SalesTaxPercent.ToString()); ebayOrderHeaderType.SalesTaxState = orderType.ShippingDetails.SalesTax.SalesTaxState == null ? "" : orderType.ShippingDetails.SalesTax.SalesTaxState.ToString(); ebayOrderHeaderType.ShippingIncludedInTax = orderType.ShippingDetails.SalesTax.ShippingIncludedInTax == true ? 1 : 0; ebayOrderHeaderType.SellingManagerSalesRecordNumber = orderType.ShippingDetails.SellingManagerSalesRecordNumber.ToString(); ebayOrderHeaderType.ExpeditedService = orderType.ShippingServiceSelected.ExpeditedService == true ? 1 : 0; ebayOrderHeaderType.ShippingService = orderType.ShippingServiceSelected.ShippingService == null ? "" : orderType.ShippingServiceSelected.ShippingService.ToString(); ebayOrderHeaderType.ShippingServiceCost = orderType.ShippingServiceSelected.ShippingServiceCost == null ? 0 : orderType.ShippingServiceSelected.ShippingServiceCost.Value; ebayOrderHeaderType.ShippingServiceAdditionalCost = orderType.ShippingServiceSelected.ShippingServiceAdditionalCost == null ? 0 : orderType.ShippingServiceSelected.ShippingServiceAdditionalCost.Value; ebayOrderHeaderType.ShippingServicePriority = orderType.ShippingServiceSelected.ShippingServicePriority; ebayOrderHeaderType.Subtotal = orderType.Subtotal == null ? 0 : orderType.Subtotal.Value; ebayOrderHeaderType.Total = orderType.Total == null ? 0 : orderType.Total.Value; ebayOrderHeaderType.TransferStatus = 0; ebayOrderHeaderType.EnterDate = System.DateTime.Now; ebayOrderHeaderType.UpdateDate = System.DateTime.Now; return ebayOrderHeaderType; }
//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(); }
private static ImageInfo CreateEntityFromReader(IDataReader reader) { var item = new ImageInfo(); try { if (!reader.IsDBNull(reader.GetOrdinal("Image_ID"))) { item.Image_ID = ConvertUtility.ToInt32(reader["Image_ID"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Name"))) { item.Image_Name = ConvertUtility.ToString(reader["Image_Name"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Description"))) { item.Image_Description = ConvertUtility.ToString(reader["Image_Description"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Image_File"))) { item.Image_File = ConvertUtility.ToString(reader["Image_File"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Image_CreateDate"))) { item.Image_CreateDate = ConvertUtility.ToDateTime(reader["Image_CreateDate"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Image_FileSize"))) { item.Image_FileSize = ConvertUtility.ToDouble(reader["Image_FileSize"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Width"))) { item.Image_Width = ConvertUtility.ToInt32(reader["Image_Width"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Height"))) { item.Image_Height = ConvertUtility.ToInt32(reader["Image_Height"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Image_View"))) { item.Image_View = ConvertUtility.ToInt32(reader["Image_View"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("User_ID"))) { item.User_ID = ConvertUtility.ToInt32(reader["User_ID"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Visible"))) { item.Image_Visible = ConvertUtility.ToBoolean(reader["Image_Visible"]); } } catch { } return(item); }
protected void btnUpdate_Click(object sender, EventArgs e) { foreach (GridViewRow gv in dtgUsers.Rows) { string strUserID = ((Label)gv.FindControl("lblKey")).Text.ToString(); int idDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); TextBox txtDiem = (TextBox)gv.FindControl("txtDiem"); TextBox txtNote = (TextBox)gv.FindControl("txtNote"); UserController.UpdateUserDiemSangTao(ConvertUtility.ToInt32(strUserID), idDotDanhGia, ConvertUtility.ToDouble(txtDiem.Text), txtNote.Text); } }
protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); #region Check authenticate UserInfo userInfo = UserController.GetUser(idNhanVien); if (userInfo == null) { Response.Redirect(AppEnv.AdminUrlParams("accessdeny")); } if (!CurrentUser.IsAdmin && !CurrentUser.IsSuperAdmin) { if (CurrentUser.UserID != 8) { if (CurrentUser.RoleID == (int)Constants.Role.NhanVien || CurrentUser.RoleID == (int)Constants.Role.NhanVienKD) { if (CurrentUser.UserID != idNhanVien) { Response.Redirect(AppEnv.AdminUrlParams("accessdeny")); } } } } #endregion DataTable dt = DotDanhGiaController.checkDanhGiaThang(idDotDanhGia, idNhanVien); if (dt != null && dt.Rows.Count > 0) { #region kiem tra trang thai cua Ban danh gia if (idNhanVien == CurrentUser.UserID) { if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.ThongNhat) { btnSumit.Enabled = false; btnSumit.Text = "Thống nhất"; } else { btnSumit.Enabled = false; btnSumit.Text = "Chờ CEO đánh giá"; } } else { btnSumit.Enabled = true; btnSumit.Text = "Đánh giá và gửi lại kết quả cho TBP"; } #endregion tableContent.Visible = true; tableAlert.Visible = false; #region Tong diem cua ban danh gia DataSet ds = DotDanhGiaController.DanhGiaThang_DGCBCNVDanhGia_TongDiemCongThucMoi(idDotDanhGia, idNhanVien); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { lblDiemDanhGiaDonVi.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["TotalDiemDanhGiaDonVi"].ToString()), 2).ToString() + "%"; } if (ds.Tables[1].Rows.Count > 0) { lblDiemHoanThanhLoiNhuanCongTy.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[1].Rows[0]["TotalDiemLNCgTy"]), 2).ToString() + "%"; } if (ds.Tables[2].Rows.Count > 0) { lblDiemKhoiLuongCongViec.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[2].Rows[0]["TotalDiemKhoiLuongCongViec"]), 2).ToString() + "%"; } if (ds.Tables[3].Rows.Count > 0) { lblDiemKyNangLamViec.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[3].Rows[0]["TotalDiemKyNangLamViec"]), 2).ToString() + "%"; } if (ds.Tables[4].Rows.Count > 0) { lblDiemKyLuat.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[4].Rows[0]["TotalDiemKyLuat"]), 2).ToString() + "%"; } if (ds.Tables[5].Rows.Count > 0) { lblMucDoHoanThanh.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[5].Rows[0]["TongDiem"]), 1, MidpointRounding.AwayFromZero).ToString() + "%"; } if (ds.Tables[6].Rows.Count > 0) { lblXepLoai.Text = ds.Tables[6].Rows[0]["XepLoai"].ToString(); } if (ds.Tables[7].Rows.Count > 0) { lblName.Text = ds.Tables[7].Rows[0]["HoTen"].ToString(); } if (ds.Tables[8].Rows.Count > 0) { lblDiemThuong.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[8].Rows[0]["DiemThuong"]), 2).ToString() + "%"; } lblHeSoLuongMem.Text = GetLuongMem(lblXepLoai.Text); #region Ty Trong Cong Viec double totalCVTX = 0; double totalCVKTX = 0; double totalCVPS = 0; double total = 0; DataTable dtCongViecThuongXuyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(1, idDotDanhGia, idNhanVien); foreach (DataRow item in dtCongViecThuongXuyen.Rows) { totalCVTX += ConvertUtility.ToDouble(item["TyTrongCV"]); } DataTable dtCongViecKhongThuonguyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(2, idDotDanhGia, idNhanVien); foreach (DataRow item in dtCongViecKhongThuonguyen.Rows) { totalCVKTX += ConvertUtility.ToDouble(item["TyTrongCV"]); } DataTable dtCongViecPhatSinh = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(3, idDotDanhGia, idNhanVien); foreach (DataRow item in dtCongViecPhatSinh.Rows) { totalCVPS += ConvertUtility.ToDouble(item["TyTrongCV"]); } lblCVTX.Text = Math.Round(totalCVTX, 2) + "%"; lblCVKTX.Text = Math.Round(totalCVKTX, 2) + "%"; lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%"; total = totalCVTX + totalCVKTX + totalCVPS; lblTotal.Text = Math.Round(total, 2).ToString() + "%"; lblTotal.Text = Math.Round(total, 2).ToString() + "%"; if (total > 100) { lblTotal.ForeColor = Color.Red; } double totalCVPhatSinh = Math.Round((100 - total), 2); if (totalCVPhatSinh > 0) { lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%" + " còn lại " + Math.Round((100 - total), 2) + "%"; } else { lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%"; } #endregion } #endregion } else { tableContent.Visible = false; tableAlert.Visible = true; } }
void ButtonOkClick(object sender, EventArgs e) { invoice.AmountPaid = ConvertUtility.ToDouble(textBoxAmountPaid.Text); }
private static DownloadInfo CreateEntityFromReader(IDataReader reader) { var item = new DownloadInfo(); try { if (!reader.IsDBNull(reader.GetOrdinal("Download_ID"))) { item.Download_ID = ConvertUtility.ToInt32(reader["Download_ID"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Download_Name"))) { item.Download_Name = ConvertUtility.ToString(reader["Download_Name"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Download_Description"))) { item.Download_Description = ConvertUtility.ToString(reader["Download_Description"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Download_File"))) { item.Download_File = ConvertUtility.ToString(reader["Download_File"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Download_Extension"))) { item.Download_Extension = ConvertUtility.ToString(reader["Download_Extension"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Download_Visible"))) { item.Download_Visible = ConvertUtility.ToBoolean(reader["Download_Visible"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Download_CreateDate"))) { item.Download_CreateDate = ConvertUtility.ToDateTime(reader["Download_CreateDate"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Download_FileSize"))) { item.Download_FileSize = ConvertUtility.ToDouble(reader["Download_FileSize"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Download_View"))) { item.Download_View = ConvertUtility.ToInt32(reader["Download_View"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("User_ID"))) { item.User_ID = ConvertUtility.ToInt32(reader["User_ID"]); } } catch { } return(item); }
public OrderDetailForm(string orderNum, string channel) { InitializeComponent(); this._OrderNumTxt.ReadOnly = true; this._OrderNumTxt.Text = orderNum; this._ChannelTxt.Text = channel; DataRow orderHeaderDr = Db.GetOrderHeaderDrByOrderNum(orderNum, channel); if (orderHeaderDr["ShippedDate"].ToString() != "1753-01-01 00:00:00.000") { this._ReprintBtn.Enabled = true; } else { this._ReprintBtn.Enabled = false; } if (orderHeaderDr["TrackingNum"].ToString() == "") { this._AddTrackingNumBtn.Enabled = true; this._TrackingLinkLab.Visible = false; this._TrackingAddTxt.Visible = true; this._ShippingCarrierTxt.ReadOnly = false; } else { this._AddTrackingNumBtn.Enabled = false; } DataTable orderLineDt = new DataTable(); if (orderHeaderDr == null || orderHeaderDr["OrderNum"] == null) { MessageBox.Show("Error!! No result!!! Please contact Administrator!!!"); } else { try { orderLineDt = Db.GetOrderLineDtByOrderNum(orderNum, channel); this._AccountNameTxt.Text = orderHeaderDr["AccountName"].ToString(); this._BuyerUserIDTxt.Text = orderHeaderDr["BuyerUserID"].ToString(); this._OrderDateTxt.Text = orderHeaderDr["OrderDate"].ToString(); this._ShipNameTxt.Text = orderHeaderDr["ShipName"].ToString(); this._ShipEmailTxt.Text = orderHeaderDr["ShipEmail"].ToString(); this._EnterDateTxt.Text = orderHeaderDr["EnterDate"].ToString(); this._TrackingLinkLab.Text = orderHeaderDr["TrackingNum"].ToString(); this._Address1Txt.Text = orderHeaderDr["ShipAddress1"].ToString(); this._Address2Txt.Text = orderHeaderDr["ShipAddress2"].ToString(); this._ShipCityTxt.Text = orderHeaderDr["ShipCity"].ToString(); this._ShipStateTxt.Text = orderHeaderDr["ShipState"].ToString(); this._ShipZipTxt.Text = orderHeaderDr["ShipZip"].ToString(); this._ShipCountry.Text = orderHeaderDr["ShipCountry"].ToString(); this._ShipPhoneTxt.Text = orderHeaderDr["ShipPhone"].ToString(); this._ShippedDateTxt.Text = orderHeaderDr["ShippedDate"].ToString(); this._ShippingCarrierTxt.Text = orderHeaderDr["ShippingCarrier"].ToString(); this._SubTotalTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["SubTotal"]).ToString(); this._ShippingFeeTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["ShippingServiceCost"]).ToString() + ConvertUtility.ToDouble(orderHeaderDr["ShippingServiceAdditionalCost"]).ToString(); this._TaxTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["SalesTaxAmount"]).ToString(); this._OtherFeeTxt.Text = ""; this._NoteTxt.Text = orderHeaderDr["Note"].ToString(); this._TotalTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["Total"]).ToString(); this._PaidAmountTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["AmountPaid"]).ToString(); if (ConvertUtility.ToDouble(orderHeaderDr["AmountPaid"]) != ConvertUtility.ToDouble(orderHeaderDr["Total"])) { this._PaidAmountTxt.ForeColor = Color.Red; this._TotalTxt.ForeColor = Color.Red; } this._OrderLineDgv.DataSource = orderLineDt.DefaultView; } catch (Exception ex) { MessageBox.Show(ex.Message + " Error!! Please contact admin for OrderDetailForm "); } } }
public PropertyIndex GetPropertySearch(int pageSize, int pageIndex) { DateTime start = DateTime.Now; using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=dinhgianhadat.vn;Integrated Security=True;MultipleActiveResultSets=True;")) { conn.Open(); SqlCommand cmd = new SqlCommand("SP_F_Property_dgnd_Search", conn); cmd.CommandType = CommandType.StoredProcedure; //var priceFirst = GetListPropertyPriceStatic().FirstOrDefault(r => r.Id == options.PriceId && r.AdsType == options.AdsTypeId); //options.MinPriceProposed = priceFirst != null ? priceFirst.FromValue : options.MinPriceProposed; //options.MaxPriceProposed = priceFirst != null ? priceFirst.ToValue : options.MaxPriceProposed; //var areaFirst = GetListPropertyAreaStatic().FirstOrDefault(r => r.Id == options.AreaId); //options.MinAreaTotal = areaFirst != null ? areaFirst.FromValue : options.MinAreaTotal; //options.MaxAreaTotal = areaFirst != null ? areaFirst.ToValue : options.MaxAreaTotal; //options.WardId = options.WardId == 0 ? -1 : options.WardId; cmd.Parameters.AddWithValue("@pageSize", pageSize); cmd.Parameters.AddWithValue("@pageIndex", pageIndex); //cmd.Parameters.AddWithValue("@domainGroupId", options.DomainGroupId); //cmd.Parameters.AddWithValue("@adsTypeId", options.AdsTypeId); //cmd.Parameters.AddWithValue("@provinceId", options.ProvinceId); //cmd.Parameters.AddWithValue("@districtId", options.DistrictId); //cmd.Parameters.AddWithValue("@wardId", options.WardId); //cmd.Parameters.AddWithValue("@streetId", options.StreetId); //cmd.Parameters.AddWithValue("@apartmentId", options.ApartmentId); //cmd.Parameters.AddWithValue("@directionId", options.DirectionId); //cmd.Parameters.AddWithValue("@locationId", options.LocationId); //cmd.Parameters.AddWithValue("@MinAreaTotal", options.MinAreaTotal); //cmd.Parameters.AddWithValue("@MaxAreaTotal", options.MaxAreaTotal); //cmd.Parameters.AddWithValue("@MinPriceProposed", options.MinPriceProposed); //cmd.Parameters.AddWithValue("@MaxPriceProposed", options.MaxPriceProposed); //NOTE: @typeCssClassesLand has been hard code in DB //added 27/03/2016 var reader = cmd.ExecuteReader(); var model = new PropertyIndex(); model.ListProperties = new List <PropertyItem>(); reader.Read(); int total = (int)reader["TotalCount"]; model.TotalCount = total; // gets the second reader.NextResult(); while (reader.Read()) { var item = new PropertyItem { Id = int.Parse(reader["Id"].ToString()), Content = reader["Content"].ToString(), Title = reader["Title"].ToString(), Note = reader["Note"].ToString(), Floors = ConvertUtility.ToDouble(reader["Floors"].ToString()), Bedrooms = ConvertUtility.ToInt32(reader["Bedrooms"].ToString()), Bathrooms = ConvertUtility.ToInt32(reader["Bathrooms"].ToString()), AddressNumber = reader["AddressNumber"].ToString(), AddressCorner = reader["AddressCorner"].ToString(), CreatedDate = ConvertUtility.ToDateTime(reader["CreatedDate"].ToString(), default(DateTime)), LastUpdatedDate = ConvertUtility.ToDateTime(reader["LastUpdatedDate"].ToString(), default(DateTime)), AdsExpirationDate = ConvertUtility.ToDateTime(reader["AdsExpirationDate"].ToString(), default(DateTime)), AlleyWidth = !string.IsNullOrEmpty(reader["AlleyWidth"].ToString()) ? double.Parse(reader["AlleyWidth"].ToString()) : default(double), PriceProposed = ConvertUtility.ToDouble(reader["PriceProposed"].ToString()), PriceProposedInVND = ConvertUtility.ToDouble(reader["PriceProposedInVND"].ToString()), //-- PriceEstimatedInVND = ConvertUtility.ToDouble(reader["PriceEstimatedInVND"].ToString()), //-- AreaUsable = ConvertUtility.ToDouble(reader["AreaUsable"].ToString()), AreaTotalWidth = ConvertUtility.ToDouble(reader["AreaTotalWidth"].ToString()), AreaTotalLength = ConvertUtility.ToDouble(reader["AreaTotalLength"].ToString()), AreaTotal = ConvertUtility.ToDouble(reader["AreaTotal"].ToString()), ApartmentId = ConvertUtility.ToInt32(reader["ApartmentId"].ToString()), AdsType = new PropertyBase { ShortName = reader["AdsTypeShortName"].ToString(), CssClass = reader["AdsTypeCssClass"].ToString(), Id = int.Parse(reader["AdsTypeId"].ToString()) }, Location = new PropertyBase { Id = ConvertUtility.ToInt32(reader["LocationId"].ToString()), CssClass = reader["LocationCssClass"].ToString(), Name = reader["LocationName"].ToString(), ShortName = reader["LocationShortName"].ToString() }, PaymentMethod = new PropertyBase { Id = ConvertUtility.ToInt32(reader["PaymentMethodId"].ToString()), Name = reader["PaymentMethodName"].ToString(), CssClass = reader["PaymentMethodCssClass"].ToString(), ShortName = reader["PaymentMethodShortName"].ToString() }, ImageDefaultAvatar = reader["ImageDefaultAvatar"].ToString() }; model.ListProperties.Add(item); } reader.Close(); return(model); } }
protected void cmdUpdate_Click(object sender, EventArgs e) { QuanLyCongViecKTXVaPSInfo info = QuanLyCongViecKTXVaPSController.GetInfo(ConvertUtility.ToInt32(txtID.Text)); if (info == null) { cmdEmpty_Click(null, null); return; } if (info.ID == ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue)) { lblStatusUpdate.Text = "Trung mục cha"; return; } string oldData = GetObjectInfo(info); info.Ten = txtName.Text; info.ParentID = ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue); info.TyTrong = ConvertUtility.ToDouble(txtTyTrong.Text); info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue); info.KeHoach = txtKeHoach.Text; info.DonViDo = txtDonViDo.Text; info.IDPhongBan = 0;//ConvertUtility.ToInt32(dropPhong.SelectedValue); info.Loai = 1; info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);; info.SoGio = ConvertUtility.ToDouble(txtSoGio.Text); info.IsKPI = ConvertUtility.ToInt32(dropKPIBoPhan.SelectedValue); info.NgayBatDau = ConvertUtility.ToDateTime(dtFrom.Text.ToString()); info.NgayKetThuc = ConvertUtility.ToDateTime(dtTo.Text); info.IDNhomCongViec = ConvertUtility.ToInt32(dropMaNhom.SelectedValue); info.TrangThaiCV = ConvertUtility.ToInt32(dropTrangThai.SelectedValue); DateConverter objDate = new DateConverter(); int tuanBD = objDate.GetWeekOfMonth(info.NgayBatDau); int tuanKT = objDate.GetWeekOfMonth(info.NgayKetThuc); string tuanLV = ""; for (int i = tuanBD; i <= tuanKT; i++) { tuanLV += i + ","; } info.TuanLamViec = tuanLV.Substring(0, tuanLV.Length - 1); try { QuanLyCongViecKTXVaPSController.Update(info); lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS; #region Log Action LogFileInfo logFileInfo = new LogFileInfo(); logFileInfo.Log_Action = "Update"; 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: " + oldData; logFileInfo.Description_After = "Update KPI with info: <br />" + GetObjectInfo(info); logFileInfo.UserName = CurrentUser.Username; logFileInfo.UserID = CurrentUser.UserID; CreateLogFile.LogAction(logFileInfo); #endregion UpdateCapDoCongViec(); } catch (Exception ex) { lblStatusUpdate.Text = ex.Message; } Session["Nav"] = "1"; }
public static void LoadForCurItem(ListItemCollection lstItems, ListItem curItem, int idTrungTam, int idPhongBan, DateTime dt, int idDotDanhGia, int UserID) { int curId = ConvertUtility.ToInt32(curItem.Value); int level = ConvertUtility.ToInt32(curItem.Attributes["Level"]); level++; DataTable dtChildZones = GetAllByParentID(curId, idTrungTam, idPhongBan, dt, idDotDanhGia, UserID); if (dtChildZones == null) { return; } foreach (DataRow row in dtChildZones.Rows) { ListItem item = new ListItem(MiscUtility.StringIndent(level) + "(" + Math.Round(ConvertUtility.ToDouble(row["TyTrong"].ToString()), 3) + "%) " + row["Ten"].ToString(), row["ID"].ToString()); item.Attributes.Add("Level", level.ToString()); lstItems.Add(item); LoadForCurItem(lstItems, item, idTrungTam, idPhongBan, dt, idDotDanhGia, UserID); } }
protected void btnImport_Click(object sender, EventArgs e) { if (fileImport.HasFile) { if (!Directory.Exists(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/"))) { Directory.CreateDirectory(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/")); } string ext = ".xls"; if (fileImport.FileName.IndexOf(".xlsx") > 0) { ext = ".xlsx"; } fileImport.PostedFile.SaveAs(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(ext, "") + "_Temp" + ext); string path = Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(ext, "") + "_Temp" + ext; if (File.Exists(path)) { DataTable returnTable = ImportExcelToDataTable.ImportExcel(path); if (returnTable != null && returnTable.Rows.Count > 0) { if (chkDeleteAll.Checked) { QuanLyCongViecKTXVaPSController.DeleteAll(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue)); } for (int i = 0; i < returnTable.Rows.Count; i++) { try { DataRow row = returnTable.Rows[i]; #region Import QuanLyCongViecKTXVaPSInfo info = new QuanLyCongViecKTXVaPSInfo(); info.Ten = row[0].ToString(); info.ParentID = 0; info.TyTrong = 0; info.KeHoach = ""; info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue); info.DonViDo = ""; info.IDPhongBan = 0;//ConvertUtility.ToInt32(dropPhong.SelectedValue); info.Loai = 1; info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.SoGio = 0; info.IsKPI = 1; info.NgayBatDau = DateTime.Now; info.NgayKetThuc = DateTime.Now; info.IDNhomCongViec = 1; info.TrangThaiCV = 2; info.TuanLamViec = "1,2,3,4,5"; QuanLyCongViecKTXVaPSController.Insert(info); info = new QuanLyCongViecKTXVaPSInfo(); info.Ten = row[1].ToString(); int parentID = GetParentID(row[0].ToString(), ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue)); info.ParentID = parentID; info.TyTrong = 0; info.KeHoach = ConvertUtility.ToString(row[3].ToString()); info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue); info.DonViDo = ""; info.IDPhongBan = 0;//ConvertUtility.ToInt32(dropPhong.SelectedValue); info.Loai = 1; info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.SoGio = ConvertUtility.ToDouble(row[2].ToString()); info.IsKPI = 1; info.NgayBatDau = DateTime.Now; info.NgayKetThuc = DateTime.Now; info.IDNhomCongViec = 1; info.TrangThaiCV = 2; info.TuanLamViec = ConvertUtility.ToString(row[4].ToString()); QuanLyCongViecKTXVaPSController.Insert(info); if (info.ParentID > 0) { UpdateCapDoCongViec(); } #endregion } catch { continue; } } } } else { lblStatusUpdate.Text = GetLocalResourceObject("lblUpdateStatusResource4.Text").ToString(); } } Session["Nav"] = "1"; }
protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); #region Check authenticate UserInfo userInfo = UserController.GetUser(idNhanVien); if (userInfo == null) { Response.Redirect(AppEnv.AdminUrlParams("accessdeny")); } if (!CurrentUser.IsAdmin && !CurrentUser.IsSuperAdmin) { if (CurrentUser.UserID != 8) { if (CurrentUser.RoleID == (int)Constants.Role.NhanVien || CurrentUser.RoleID == (int)Constants.Role.NhanVienKD) { if (CurrentUser.UserID != idNhanVien) { Response.Redirect(AppEnv.AdminUrlParams("accessdeny")); } } } } #endregion DataTable dt = DotDanhGiaController.checkDanhGiaThang(idDotDanhGia, idNhanVien); if (dt != null && dt.Rows.Count > 0) { #region kiem tra trang thai cua Ban danh gia if (idNhanVien == CurrentUser.UserID) { if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.DaGuiDanhGiaChoTruongPhong) { btnSumit.Enabled = false; btnSumit.Text = "Chờ trưởng phòng đánh giá"; } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.DaGuiDanhGiaChoTruongBoPhan) { btnSumit.Enabled = false; btnSumit.Text = "Chờ trưởng bộ phận đánh giá"; } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.TruongPhongGuiLaiDanhGiaChoNhanVien) { btnSumit.Enabled = true; btnSumit.Text = "Đồng ý kết quả đánh giá"; } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.TruongBoPhanGuiLaiDanhGiaChoNhanVien) { btnSumit.Enabled = true; btnSumit.Text = "Đồng ý kết quả đánh giá"; } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.NhanVienDongYVoiKetQuaDanhGia) { if (userInfo.IDPhong > 0) { btnSumit.Enabled = false; btnSumit.Text = "Chờ trưởng phòng đánh giá"; } else { btnSumit.Enabled = false; btnSumit.Text = "Chờ trưởng bộ phận đánh giá"; } } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.ThongNhat) { btnSumit.Enabled = false; btnSumit.Text = "Đã thống nhất kết quả đánh giá"; } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) <= (int)Constants.TrangThaiDanhGiaNhanVien.DangDanhGia) { btnSumit.Enabled = true; btnSumit.Text = "Gửi đánh giá"; } else { btnSumit.Enabled = false; btnSumit.Text = "xu ly thieu truong hop nay"; } //tabDVKH_DT_DP.Visible = false; } else { if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.DaGuiDanhGiaChoTruongPhong) { btnSumit.Enabled = true; btnSumit.Text = "Gửi lại kết quả đánh giá cho nhân viên"; } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.DaGuiDanhGiaChoTruongBoPhan) { btnSumit.Enabled = true; btnSumit.Text = "Gửi lại kết quả đánh giá cho nhân viên"; } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.NhanVienDongYVoiKetQuaDanhGia) { btnSumit.Enabled = true; if (CurrentUser.RoleID == (int)Constants.Role.TruongPhong) { btnSumit.Text = "Thống nhất và gửi trưởng bộ phận phê duyệt"; } else { btnSumit.Text = "Thống nhất kết quả"; } } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.TruongBoPhanGuiLaiDanhGiaChoNhanVien) { btnSumit.Enabled = false; btnSumit.Text = "Chờ nhân viên đồng ý"; } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.TruongPhongGuiLaiDanhGiaChoNhanVien) { btnSumit.Enabled = false; btnSumit.Text = "Chờ nhân viên đồng ý"; } else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.ThongNhat) { btnSumit.Enabled = false; btnSumit.Text = "Đã hoàn thành các kết quả đánh giá"; } else { btnSumit.Enabled = false; btnSumit.Text = "Đánh giá chưa được gửi lên"; } } #endregion tableContent.Visible = true; tableAlert.Visible = false; #region Tong diem cua ban danh gia DataSet ds = DotDanhGiaController.DanhGiaThang_DGCBCNVDanhGia_TongDiemCongThucMoi(idDotDanhGia, idNhanVien); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { lblTyLeHoanThanh.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["TyLeHoanThanh"].ToString()), 2).ToString() + "%"; } if (ds.Tables[1].Rows.Count > 0) { lblDiemDanhGiaDonVi.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[1].Rows[0]["TotalDiemDanhGiaDonVi"].ToString()), 2).ToString() + "%"; } if (ds.Tables[2].Rows.Count > 0) { lblDiemHoanThanhLoiNhuanCongTy.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[2].Rows[0]["TotalDiemLNCgTy"]), 2).ToString() + "%"; } if (ds.Tables[3].Rows.Count > 0) { lblDiemPhoiHop.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[3].Rows[0]["TotalDiemPhoiHop"]), 2).ToString() + "%"; } if (ds.Tables[4].Rows.Count > 0) { lblDiemKyLuat.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[4].Rows[0]["TotalDiemKyLuat"]), 2).ToString() + "%"; } if (ds.Tables[5].Rows.Count > 0) { lblDiemHoanThanhLoiNhuanBoPhan.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[5].Rows[0]["TotalDiemLNBoPhan"]), 1, MidpointRounding.AwayFromZero).ToString() + "%"; } if (ds.Tables[6].Rows.Count > 0) { lblMucDoHoanThanh.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[6].Rows[0]["TongDiem"]), 1, MidpointRounding.AwayFromZero).ToString() + "%"; } if (ds.Tables[7].Rows.Count > 0) { lblXepLoai.Text = ds.Tables[7].Rows[0]["XepLoai"].ToString(); } if (ds.Tables[8].Rows.Count > 0) { lblName.Text = ds.Tables[8].Rows[0]["HoTen"].ToString(); } if (ds.Tables[9].Rows.Count > 0) { lblDiemThuong.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[9].Rows[0]["DiemThuong"]), 2).ToString() + "%"; } if (ds.Tables[10].Rows.Count > 0) { lblDiemBLDDanhGia.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[10].Rows[0]["DiemBLD"]), 2).ToString() + "%"; } lblHeSoLuongMem.Text = GetLuongMem(lblXepLoai.Text); #region Ty Trong Cong Viec double totalCVTX = 0; double totalCVKTX = 0; double totalCVPS = 0; double total = 0; DataTable dtCongViecThuongXuyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(1, idDotDanhGia, idNhanVien); foreach (DataRow item in dtCongViecThuongXuyen.Rows) { totalCVTX += ConvertUtility.ToDouble(item["TyTrongCV"]); } DataTable dtCongViecKhongThuonguyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(2, idDotDanhGia, idNhanVien); foreach (DataRow item in dtCongViecKhongThuonguyen.Rows) { totalCVKTX += ConvertUtility.ToDouble(item["TyTrongCV"]); } DataTable dtCongViecPhatSinh = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(3, idDotDanhGia, idNhanVien); foreach (DataRow item in dtCongViecPhatSinh.Rows) { totalCVPS += ConvertUtility.ToDouble(item["TyTrongCV"]); } lblCVTX.Text = Math.Round(totalCVTX, 2) + "%"; lblCVKTX.Text = Math.Round(totalCVKTX, 2) + "%"; lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%"; total = totalCVTX + totalCVKTX + totalCVPS; lblTotal.Text = Math.Round(total, 2).ToString() + "%"; lblTotal.Text = Math.Round(total, 2).ToString() + "%"; if (total > 100) { lblTotal.ForeColor = Color.Red; } double totalCVPhatSinh = Math.Round((100 - total), 2); if (totalCVPhatSinh > 0) { lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%" + " còn lại " + Math.Round((100 - total), 2) + "%"; } else { lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%"; } #endregion } #endregion } else { tableContent.Visible = false; tableAlert.Visible = true; } if (ConvertUtility.ToInt32(Session["Nav"]) == 1) { litNav.Text = ""; litNav.Text += "<ul class=\"nav nav-tabs\">"; litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>"; litNav.Text += "</ul>"; litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane active\">"; litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">"; litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">"; litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">"; litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">"; } else if (ConvertUtility.ToInt32(Session["Nav"]) == 2) { litNav.Text = ""; litNav.Text += "<ul class=\"nav nav-tabs\">"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>"; litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>"; litNav.Text += "</ul>"; litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane\">"; litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane active\">"; litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">"; litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">"; litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">"; } else if (ConvertUtility.ToInt32(Session["Nav"]) == 3) { litNav.Text = ""; litNav.Text += "<ul class=\"nav nav-tabs\">"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>"; litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>"; litNav.Text += "</ul>"; litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane\">"; litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">"; litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane active\">"; litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">"; litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">"; } else if (ConvertUtility.ToInt32(Session["Nav"]) == 4) { litNav.Text = ""; litNav.Text += "<ul class=\"nav nav-tabs\">"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>"; litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>"; litNav.Text += "</ul>"; litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane\">"; litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">"; litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">"; litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane active\">"; litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">"; } else if (ConvertUtility.ToInt32(Session["Nav"]) == 5) { litNav.Text = ""; litNav.Text += "<ul class=\"nav nav-tabs\">"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>"; litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>"; litNav.Text += "</ul>"; litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane\">"; litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">"; litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">"; litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">"; litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane active\">"; } else { litNav.Text = ""; litNav.Text += "<ul class=\"nav nav-tabs\">"; litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>"; litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>"; litNav.Text += "</ul>"; litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane active\">"; litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">"; litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">"; litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">"; litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">"; } }
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"; }
protected void btnAddNew_Click(object sender, EventArgs e) { var dirAvatarOriginal = AppEnv.UploadImagesOriginalDir; const string dirAvatarNormal = AppEnv.UploadImagesNormalDir; const string dirAvatarThumb = AppEnv.UploadImagesThumbDir; var imgWidth = 0; var imgHeight = 0; double filesize = 0; string fileAvatarPath = "", newfileAvatarName = ""; var info = new ImageInfo(); var imageCount = ContentImageDB.GetQuantityImageOfContent(_contentId); if (txtFile.PostedFile.FileName.Length > 0) { //string fileAvatarName = Path.GetFileNameWithoutExtension(txtFile.PostedFile.FileName).Replace(" ", "_").Replace("#", "_"); newfileAvatarName = "image_" + _contentId + "_" + imageCount + txtFile.PostedFile.FileName.Substring(txtFile.PostedFile.FileName.LastIndexOf('.')); var file4 = new FileInfo(Server.MapPath(AppEnv.UploadImagesNormalDir) + newfileAvatarName); if (file4.Exists) { newfileAvatarName = "image_" + _contentId + "_" + imageCount + "_" + DateTime.Now.ToString("mmss") + txtFile.PostedFile.FileName.Substring(txtFile.PostedFile.FileName.LastIndexOf('.')); } txtFile.PostedFile.SaveAs(Server.MapPath(dirAvatarOriginal) + newfileAvatarName); double filesizeb = txtFile.PostedFile.ContentLength; filesize = filesizeb / 1024; //thumbnail creation starts // try // { // dinh dang width height mac dinh de scale int smallWidth = ConvertUtility.ToInt32(AppEnv.ThumbWidth);; int smallHeight = ConvertUtility.ToInt32(AppEnv.ThumbHeight); int normalWidth = ConvertUtility.ToInt32(AppEnv.NormalWidth); int normalHeight = ConvertUtility.ToInt32(AppEnv.NormalHeight); double scalesmall = 0; double scalenormal = 0; string imageUrl = Server.MapPath(dirAvatarOriginal + newfileAvatarName); // xac dinh anh chuan bi thumbnail Bitmap InputBitmap = new Bitmap(imageUrl); // tao anh bitmap // xac dinh % de resize imgWidth = InputBitmap.Width; imgHeight = InputBitmap.Height; if (smallHeight == 0)//InputBitmap.Height < InputBitmap.Width) { scalesmall = ((double)smallWidth) / InputBitmap.Width; scalenormal = ((double)normalWidth) / InputBitmap.Width; } int newSmallWidth = 0; int newSmallHeight = 0; int newNormalWidth = 0; int newNormalHeight = 0; if (smallHeight == 0) { newSmallWidth = (int)(scalesmall * InputBitmap.Width); newSmallHeight = (int)(scalesmall * InputBitmap.Height); if (normalWidth < imgWidth) { newNormalWidth = (int)(scalenormal * InputBitmap.Width); newNormalHeight = (int)(scalenormal * InputBitmap.Height); } else { newNormalWidth = imgWidth; newNormalHeight = imgHeight; } } else { newSmallWidth = smallWidth; newSmallHeight = smallHeight; newNormalWidth = normalWidth; newNormalHeight = normalHeight; } Bitmap OutputBitmapSmall = new Bitmap(InputBitmap, newSmallWidth, newSmallHeight); // tao anh bitmap voi size small moi Bitmap OutputBitmapNormal = new Bitmap(InputBitmap, newNormalWidth, newNormalHeight); // tao anh bitmap voi size normal moi // xac dinh mime type //Response.Clear(); //Response.ContentType="image/Jpeg"; //moi ImageCodecInfo[] Info = ImageCodecInfo.GetImageEncoders(); EncoderParameters Params = new EncoderParameters(1); Params.Param[0] = new EncoderParameter(Encoder.Quality, 100L); //Response.ContentType = Info[1].MimeType; //thumbnail.Save(Response.OutputStream,Info[1],Params); InputBitmap.Dispose(); OutputBitmapSmall.Save(Server.MapPath(dirAvatarThumb) + newfileAvatarName, Info[1], Params); OutputBitmapNormal.Save(Server.MapPath(dirAvatarNormal) + newfileAvatarName, Info[1], Params); // thuc hien OutputBitmapSmall.Dispose(); OutputBitmapNormal.Dispose(); // } // catch(Exception ex) // { // Response.Write("An error occurred - " + ex.ToString()); // } //MultimediaUtility.SetThumbnail(Server.MapPath(dirLarge + newfileoutsidename), Server.MapPath(dirThumb), ConvertUtility.ToInt32(Constants.ThumbWidth), ConvertUtility.ToInt32(Constants.ThumbHeight)); //ImageDB.CreateThumbnail(dirThumb, dirLarge + newfileoutsidename); fileAvatarPath = dirAvatarThumb + newfileAvatarName; //fileAvatarPath = dirAvatarOriginal + newfileAvatarName; //MultimediaUtility.SetAvatarThumbnail(Server.MapPath(fileAvatarPath), 250, 0); } else { fileAvatarPath = ""; } if (fileAvatarPath.Length > 0) { if (txtName.Text.Length > 0) { info.Image_Name = ConvertUtility.ToString(txtName.Text); } else { info.Image_Name = newfileAvatarName; } info.Image_Description = txtTeaser.Text; info.Image_File = fileAvatarPath; info.Image_CreateDate = DateTime.Now; info.Image_FileSize = ConvertUtility.ToDouble(filesize.ToString("#0.00")); info.Image_Width = imgWidth; info.Image_Height = imgHeight; info.Image_View = 0; info.User_ID = ConvertUtility.ToInt32(ckid); info.Image_Visible = chkVisible.Checked; try { var imgId = ImageDB.Insert(info); var contentImgInfo = new ContentImageInfo(); contentImgInfo.Content_ID = _contentId; contentImgInfo.Image_ID = imgId; if (imageCount == 0) { contentImgInfo.IsCover = true; } else { contentImgInfo.IsCover = false; } contentImgInfo.Priority = imageCount; ContentImageDB.Insert(contentImgInfo); Response.Redirect(Request.RawUrl + "#idTab2"); lblStatusUpdate.Text = lblStatusUpdate2.Text = MiscUtility.UPDATE_SUCCESS; } catch { lblStatusUpdate.Text = lblStatusUpdate2.Text = MiscUtility.UPDATE_ERROR; } } }
protected void btnThemMoi3_Click(object sender, EventArgs e) { Session["Nav"] = "3"; DanhGiaThang_DGCBCNVDanhGiaTTCVInfo info = new DanhGiaThang_DGCBCNVDanhGiaTTCVInfo(); info.IDDotDanhGia = idDotDanhGia; info.IDNhanVien = idNhanVien; info.TenCongViec = txtTenCongViec3.Text.Trim(); info.SoLieuCamKet = ConvertUtility.ToString(txtSoLieuCamKet3.Text); info.SoLieuThucHienThucTeTrongThang = txtSoLieuThucHienThucTeTrongThang3.Text; info.NhanVienDanhGiaTyLeHoanThanh = ConvertUtility.ToDouble(dropTyLeHoanThanh.SelectedValue); if (info.NhanVienDanhGiaTyLeHoanThanh > 100) { info.NhanVienDanhGiaTyLeHoanThanh = 100; } if (info.NhanVienDanhGiaTyLeHoanThanh < 0) { info.NhanVienDanhGiaTyLeHoanThanh = 0; } info.TBPDanhGia = info.NhanVienDanhGiaTyLeHoanThanh; if (info.TBPDanhGia > 100) { info.TBPDanhGia = 100; } if (info.TBPDanhGia < 0) { info.TBPDanhGia = 0; } info.YeuCauHoTro = ConvertUtility.ToString(txtYeuCauCanHoTro3.Text); info.YKienCuaNhanVien = ConvertUtility.ToString(txtYKienCuaNhanVien3.Text); info.YKienCuaTBP = ""; info.Loai = 3; info.SoGio = ConvertUtility.ToDouble(txtSoGio.Text); info.TyTrongCV = ConvertUtility.ToDouble(info.SoGio * 100 / 176); int idCongViec = DanhGiaThang_DGCBCNVDanhGiaTTCVController.Insert(info); //foreach (ListItem item in dropBoPhanHoTro.Items) //{ // if (item.Selected) // { // DanhGiaThang_DGCBCNVDanhGiaTTCVController.UpdateKeHoachThangBoPhanHoTro(idDotDanhGia, idCongViec, ConvertUtility.ToInt32(item.Value)); // } // else // { // DanhGiaThang_DGCBCNVDanhGiaTTCVController.DeleteKeHoachThangBoPhanHoTro(idDotDanhGia, idCongViec, ConvertUtility.ToInt32(item.Value)); // } //} if (dt == null) { dt = DotDanhGiaController.checkDanhGiaThang(idDotDanhGia, idNhanVien); } if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) <= (int)Constants.TrangThaiDanhGiaNhanVien.DangDanhGia) { if (CurrentUser.RoleID != (int)Constants.Role.NhanVien && CurrentUser.RoleID != (int)Constants.Role.NhanVienKD) { UserInfo infoUser = UserController.GetUser(idNhanVien); if (infoUser != null) { bool value = EmailUtility.DoSendMail(infoUser.EmailVNG, "", "Mail nhắc nhở nhân viên hoàn thành công việc phát sinh", "Yêu cầu bạn hoàn thành công việc phát sinh theo deadline. Mọi người vào phần đánh giá - Công việc phát sinh để xem công việc phải làm"); } } } }
protected void cmdAdd_Click(object sender, EventArgs e) { QuanLyCongViecBaoCaoNgayInfo info = new QuanLyCongViecBaoCaoNgayInfo(); info.IDCongViecKPI = ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue); info.Ten = txtName.Text; info.KeHoach = txtKeHoach.Text; info.ParentID = txtCongViecLon.Text; info.TyTrong = 0;// ConvertUtility.ToDouble(txtTyTrong.Text); info.KetQua = txtKetqua.Text; info.TyLeHoanThanh = dropTyLeHoanThanh.SelectedValue; info.IDTrungTam = CurrentUser.IDTrungTam; info.IDPhongBan = CurrentUser.IDPhong; info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.SoGio = ConvertUtility.ToDouble(txtSoGio.Text); info.CreateBy = CurrentUser.UserID; info.LyDo = txtLyDo.Text; info.DeXuat = txtDeXuat.Text; info.CreatedOn = new DateTime(ConvertUtility.ToInt32(dropYear.SelectedValue), ConvertUtility.ToInt32(dropMonth.SelectedValue), ConvertUtility.ToInt32(dropDay.SelectedValue)); try { QuanLyCongViecBaoCaoNgayController.Insert(info); #region Log Action LogFileInfo logFileInfo = new LogFileInfo(); logFileInfo.Log_Action = "Add"; logFileInfo.Log_Type_Object = "QuanLyCongViecKPITheoNgay"; 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 lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS; if (ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue) == 0) { //them vao cong viec phat sinh DanhGiaThang_DGCBCNVDanhGiaTTCVInfo infoCVPhatSinh = new DanhGiaThang_DGCBCNVDanhGiaTTCVInfo(); infoCVPhatSinh.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); infoCVPhatSinh.IDNhanVien = CurrentUser.UserID; infoCVPhatSinh.TenCongViec = txtName.Text; infoCVPhatSinh.TyTrongCV = 0;// ConvertUtility.ToDouble(txtTyTrong.Text); infoCVPhatSinh.SoLieuCamKet = txtKeHoach.Text; infoCVPhatSinh.SoLieuThucHienThucTeTrongThang = txtKetqua.Text; infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh = ConvertUtility.ToDouble(dropTyLeHoanThanh.SelectedValue); if (infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh > 100) { infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh = 100; } if (infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh < 0) { infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh = 0; } infoCVPhatSinh.YeuCauHoTro = ""; infoCVPhatSinh.YKienCuaNhanVien = ""; infoCVPhatSinh.YKienCuaTBP = ""; infoCVPhatSinh.Loai = 3; infoCVPhatSinh.SoGio = ConvertUtility.ToDouble(txtSoGio.Text); DanhGiaThang_DGCBCNVDanhGiaTTCVController.Insert(infoCVPhatSinh); } } catch (Exception ex) { lblStatusUpdate.Text = ex.Message; } }
protected void btnExport_Click(object sender, EventArgs e) { DataTable dtUsersTemp = new DataTable(); dtUsersTemp.Columns.Add("Bộ phận", typeof(string)); dtUsersTemp.Columns.Add("Họ tên", typeof(string)); dtUsersTemp.Columns.Add("Điểm đánh giá công việc", typeof(string)); dtUsersTemp.Columns.Add("Điểm kỷ luật và văn hóa doanh nghiệp", typeof(string)); dtUsersTemp.Columns.Add("Điểm đồng nghiệp đánh giá", typeof(string)); dtUsersTemp.Columns.Add("Tổng điểm", typeof(string)); //dtUsersTemp.Columns.Add("Xếp loại", typeof(string)); BoPhanInfo _BoPhanInfo = BoPhanController.GetInfo(ConvertUtility.ToInt32(dropTrungTam.SelectedValue)); int loaiTrungTam = _BoPhanInfo.Loai; string tenTrungTam = ConvertUtility.ToString(dropTrungTam.SelectedItem.Text); DataTable dtUsers = DotDanhGiaController.GetAllNhanVienInDotDanhGiaExport(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue)); #region ket qua danh gia checkpoint foreach (DataRow item in dtUsers.Rows) { DataSet ds = DotDanhGiaController.DanhGiaCheckPoint_DGCBCNVDanhGia_TongDiemCongThucMoi(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(item["UserID"])); if (ds != null) { DataRow row = dtUsersTemp.NewRow(); double TongDiemDGCV = 0; double TongDiemDGCV1 = 0; double diemKyLuat = 0; double diemKyLuat1 = 0; double DiemDongNghiepDanhGia = 0; double DiemDongNghiepDanhGia1 = 0; double DiemCLCV = 100; double DiemTDCV = 100; if (ds.Tables[0].Rows.Count > 0) { DiemCLCV = ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["DiemCLCV"].ToString()); DiemTDCV = ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["DiemTDCV"].ToString()); } double DiemDGCV = 0; DataTable dtDotDanhGiaByCheckpoint = DotDanhGiaController.CheckPoint_GetAllDotDanhGiaByCheckpoint(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue)); int count = 0; foreach (DataRow itemDotDanhGia in dtDotDanhGiaByCheckpoint.Rows) { DataTable dtDiemTB = DotDanhGiaController.CheckPoint_DanhGiaCongViec_GetDiemTB(ConvertUtility.ToInt32(itemDotDanhGia["IDDotDanhGia"]), ConvertUtility.ToInt32(item["UserID"])); if (dtDiemTB != null && dtDiemTB.Rows.Count > 0) { DiemDGCV += ConvertUtility.ToDouble(dtDiemTB.Rows[0]["DiemTB"]); count++; } } DiemDGCV = DiemDGCV / count; if (count == 0) { count = 1; } TongDiemDGCV = (DiemDGCV * 50 / 100) + (DiemCLCV * 10 / 100) + (DiemTDCV * 10 / 100); TongDiemDGCV1 = (((DiemDGCV * 5) + (DiemCLCV) + (DiemTDCV))) / 7; TongDiemDGCV = Math.Round(TongDiemDGCV, 2, MidpointRounding.AwayFromZero); if (ds.Tables[1].Rows.Count > 0) { diemKyLuat = ConvertUtility.ToDouble(ds.Tables[1].Rows[0]["DiemKyLuat"].ToString()); diemKyLuat1 = diemKyLuat; diemKyLuat = diemKyLuat * 20 / 100; diemKyLuat = Math.Round(diemKyLuat, 2, MidpointRounding.AwayFromZero); } if (ds.Tables[2].Rows.Count > 0) { DiemDongNghiepDanhGia = ConvertUtility.ToDouble(ds.Tables[2].Rows[0]["DiemDongNghiepDanhGia"]); if (DiemDongNghiepDanhGia == 0) { DiemDongNghiepDanhGia = 10; DiemDongNghiepDanhGia1 = 100; } else { DiemDongNghiepDanhGia1 = DiemDongNghiepDanhGia; DiemDongNghiepDanhGia = DiemDongNghiepDanhGia * 10 / 100; } DiemDongNghiepDanhGia = Math.Round(DiemDongNghiepDanhGia, 2); } string ten = ""; if (ds.Tables[3].Rows.Count > 0) { ten = ds.Tables[3].Rows[0]["HoTen"].ToString(); } double TongDiem = Math.Round(TongDiemDGCV, 2, MidpointRounding.AwayFromZero); TongDiem += Math.Round(diemKyLuat, 2, MidpointRounding.AwayFromZero); TongDiem += Math.Round(DiemDongNghiepDanhGia, 2, MidpointRounding.AwayFromZero); TongDiem = Math.Round(TongDiem, 2); string xepLoai = GetXepLoai(TongDiem); row["Bộ phận"] = tenTrungTam; row["Họ tên"] = ten; row["Điểm đánh giá công việc"] = (Math.Round(TongDiemDGCV1, 2, MidpointRounding.AwayFromZero) / 100).ToString(); row["Điểm kỷ luật và văn hóa doanh nghiệp"] = (Math.Round(diemKyLuat1, 2, MidpointRounding.AwayFromZero) / 100).ToString(); row["Điểm đồng nghiệp đánh giá"] = (Math.Round(DiemDongNghiepDanhGia1, 2, MidpointRounding.AwayFromZero) / 100).ToString(); row["Tổng điểm"] = Math.Round(TongDiem, 2, MidpointRounding.AwayFromZero) / 100; //row["Xếp loại"] = xepLoai; dtUsersTemp.Rows.Add(row); } } #endregion ImportExcelToDataTable.ExportToExcel(dtUsersTemp, "KQDanhGiaCaNhanCheckPoint_" + dropTrungTam.SelectedItem.Text + ".csv"); }
protected void btnUpdateDiem2_Click(object sender, EventArgs e) { Session["Nav"] = "2"; foreach (GridViewRow row in dgrKhoiLuongCV2.Rows) { Label txtTenCongViec = (Label)row.FindControl("txtTenCongViec"); TextBox txtTyTrongCV = (TextBox)row.FindControl("txtTyTrongCV"); TextBox txtThoiGian = (TextBox)row.FindControl("txtThoiGian"); Label txtSoLieuCamKet = (Label)row.FindControl("txtSoLieuCamKet"); TextBox txtSoLieuThucHienThucTeTrongThang = (TextBox)row.FindControl("txtSoLieuThucHienThucTeTrongThang"); TextBox txtNhanVienDanhGiaTyLeHoanThanh = (TextBox)row.FindControl("txtNhanVienDanhGiaTyLeHoanThanh"); Label txtYeuCauHoTro = (Label)row.FindControl("txtYeuCauHoTro"); TextBox txtTBPDanhGia = (TextBox)row.FindControl("txtTBPDanhGia"); TextBox txtYKienCuaNhanVien = (TextBox)row.FindControl("txtYKienCuaNhanVien"); TextBox txtYKienCuaTBP = (TextBox)row.FindControl("txtYKienCuaTBP"); ListBox dropBoPhanHoTro = (ListBox)row.FindControl("dropBoPhanHoTro"); Label txtID = (Label)row.FindControl("txtID"); Label lblIDBoPhan = (Label)row.FindControl("lblIDBoPhan"); Label lblIDBoPhanHoTro = (Label)row.FindControl("lblIDBoPhanHoTro"); Label lblIDPhongBan = (Label)row.FindControl("lblIDPhongBan"); Label txtIdCongViec = (Label)row.FindControl("txtIdCongViec"); DanhGiaThang_DGCBCNVDanhGiaTTCVInfo info = new DanhGiaThang_DGCBCNVDanhGiaTTCVInfo(); info.ID = ConvertUtility.ToInt32(txtID.Text); info.IDDotDanhGia = idDotDanhGia; info.IDNhanVien = idNhanVien; info.TenCongViec = txtTenCongViec.Text.Trim(); info.SoGio = ConvertUtility.ToDouble(txtThoiGian.Text); info.TyTrongCV = ConvertUtility.ToDouble(info.SoGio * 100 / 176); info.SoLieuCamKet = ConvertUtility.ToString(txtSoLieuCamKet.Text); info.SoLieuThucHienThucTeTrongThang = txtSoLieuThucHienThucTeTrongThang.Text; info.NhanVienDanhGiaTyLeHoanThanh = ConvertUtility.ToDouble(txtNhanVienDanhGiaTyLeHoanThanh.Text); if (info.NhanVienDanhGiaTyLeHoanThanh < 0) { info.NhanVienDanhGiaTyLeHoanThanh = 0; } if (CurrentUser.RoleID != (int)Constants.Role.TruongBoPhanKhoiHoTro && CurrentUser.RoleID != (int)Constants.Role.TruongBoPhanKhoiKinhDoanh) { if (CurrentUser.UserID == idNhanVien) { info.TBPDanhGia = info.NhanVienDanhGiaTyLeHoanThanh; } else { info.TBPDanhGia = ConvertUtility.ToDouble(txtTBPDanhGia.Text); } } else { info.TBPDanhGia = ConvertUtility.ToDouble(txtTBPDanhGia.Text); } if (info.TBPDanhGia < 0) { info.TBPDanhGia = 0; } info.YeuCauHoTro = ConvertUtility.ToString(txtYeuCauHoTro.Text); info.YKienCuaNhanVien = ConvertUtility.ToString(txtYKienCuaNhanVien.Text); info.YKienCuaTBP = ConvertUtility.ToString(txtYKienCuaTBP.Text); info.Loai = 2; info.IDCongViec = ConvertUtility.ToInt32(txtIdCongViec.Text); info.IDBoPhan = ConvertUtility.ToInt32(lblIDBoPhan.Text); info.IDBoPhanHoTro = ConvertUtility.ToInt32(dropBoPhanHoTro.SelectedValue); info.IDPhongBan = ConvertUtility.ToInt32(lblIDPhongBan.Text); DanhGiaThang_DGCBCNVDanhGiaTTCVController.Update(info); foreach (ListItem item in dropBoPhanHoTro.Items) { if (item.Selected) { DanhGiaThang_DGCBCNVDanhGiaTTCVController.UpdateKeHoachThangBoPhanHoTro(idDotDanhGia, ConvertUtility.ToInt32(txtIdCongViec.Text), ConvertUtility.ToInt32(item.Value)); } else { DanhGiaThang_DGCBCNVDanhGiaTTCVController.DeleteKeHoachThangBoPhanHoTro(idDotDanhGia, ConvertUtility.ToInt32(txtIdCongViec.Text), ConvertUtility.ToInt32(item.Value)); } } } if (CurrentUser.RoleID != (int)Constants.Role.NhanVien && CurrentUser.RoleID != (int)Constants.Role.NhanVienKD) { DataTable dt = DotDanhGiaController.checkDanhGiaThang(idDotDanhGia, idNhanVien); if (dt != null && dt.Rows.Count > 0) { if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.ThongNhat) { UserInfo userInfo = UserController.GetUser(idNhanVien); EmailUtility.DoSendMail(userInfo.EmailVNG, "", "Trưởng bộ phận/Trưởng Phòng đã thống nhất bảng đánh giá tháng", "TBP/TP (" + CurrentUser.EmailVNG + ") đã cập nhật điểm công việc kế hoạch tháng của bạn. Đề nghị bạn đăng nhập phần mềm để xem kết quả đánh giá."); } } } //if (dgrKhoiLuongCV2.Rows.Count > 0) //{ // Response.Write("<script>javascript:alert('Bạn đã cập nhật thông tin thành công');</script>"); //} }
protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); DataTable dtUsers; if (CurrentUser.IsAdmin || CurrentUser.IsSuperAdmin) { dtUsers = CommonController.BaoCaoXepLoaiDanhGiaCaNhanThang(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropPhongBan.SelectedValue), ConvertUtility.ToInt32(dropChucVu.SelectedValue), ConvertUtility.ToInt32(dropTrangThai.SelectedValue)); } else { dtUsers = CommonController.BaoCaoXepLoaiDanhGiaCaNhanThang(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropPhongBan.SelectedValue), ConvertUtility.ToInt32(dropChucVu.SelectedValue), ConvertUtility.ToInt32(dropTrangThai.SelectedValue), CurrentUser.UserID); } DataTable dtUsersTemp = new DataTable(); dtUsersTemp.Columns.Add("UserID", typeof(string)); dtUsersTemp.Columns.Add("Bộ phận", typeof(string)); dtUsersTemp.Columns.Add("Họ tên", typeof(string)); dtUsersTemp.Columns.Add("Điểm đánh giá công việc", typeof(string)); dtUsersTemp.Columns.Add("Điểm kỷ luật và văn hóa doanh nghiệp", typeof(string)); dtUsersTemp.Columns.Add("Điểm đồng nghiệp đánh giá", typeof(string)); dtUsersTemp.Columns.Add("Tổng điểm", typeof(string)); dtUsersTemp.Columns.Add("Xếp loại", typeof(string)); BoPhanInfo _BoPhanInfo = BoPhanController.GetInfo(ConvertUtility.ToInt32(dropTrungTam.SelectedValue)); int loaiTrungTam = _BoPhanInfo.Loai; string tenTrungTam = ConvertUtility.ToString(dropTrungTam.SelectedItem.Text); foreach (DataRow item in dtUsers.Rows) { DataSet ds = DotDanhGiaController.DanhGiaCheckPoint_DGCBCNVDanhGia_TongDiemCongThucMoi(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(item["UserID"])); if (ds != null) { DataRow row = dtUsersTemp.NewRow(); double TongDiemDGCV = 0; double TongDiemDGCV1 = 0; double diemKyLuat = 0; double diemKyLuat1 = 0; double DiemDongNghiepDanhGia = 0; double DiemDongNghiepDanhGia1 = 0; double DiemCLCV = 100; double DiemTDCV = 100; if (ds.Tables[0].Rows.Count > 0) { DiemCLCV = ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["DiemCLCV"].ToString()); DiemTDCV = ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["DiemTDCV"].ToString()); } double DiemDGCV = 0; DataTable dtDotDanhGiaByCheckpoint = DotDanhGiaController.CheckPoint_GetAllDotDanhGiaByCheckpoint(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue)); int count = 0; foreach (DataRow itemDotDanhGia in dtDotDanhGiaByCheckpoint.Rows) { DataTable dtDiemTB = DotDanhGiaController.CheckPoint_DanhGiaCongViec_GetDiemTB(ConvertUtility.ToInt32(itemDotDanhGia["IDDotDanhGia"]), ConvertUtility.ToInt32(item["UserID"])); if (dtDiemTB != null && dtDiemTB.Rows.Count > 0) { DiemDGCV += ConvertUtility.ToDouble(dtDiemTB.Rows[0]["DiemTB"]); count++; } } DiemDGCV = DiemDGCV / count; if (count == 0) { count = 1; } TongDiemDGCV = (DiemDGCV * 50 / 100) + (DiemCLCV * 10 / 100) + (DiemTDCV * 10 / 100); TongDiemDGCV = Math.Round(TongDiemDGCV, 2, MidpointRounding.AwayFromZero); TongDiemDGCV1 = (((DiemDGCV * 5) + (DiemCLCV) + (DiemTDCV))) / 7; if (ds.Tables[1].Rows.Count > 0) { diemKyLuat = ConvertUtility.ToDouble(ds.Tables[1].Rows[0]["DiemKyLuat"].ToString()); diemKyLuat1 = diemKyLuat; diemKyLuat = diemKyLuat * 20 / 100; diemKyLuat = Math.Round(diemKyLuat, 2, MidpointRounding.AwayFromZero); } if (ds.Tables[2].Rows.Count > 0) { DiemDongNghiepDanhGia = ConvertUtility.ToDouble(ds.Tables[2].Rows[0]["DiemDongNghiepDanhGia"]); if (DiemDongNghiepDanhGia == 0) { DiemDongNghiepDanhGia = 10; DiemDongNghiepDanhGia1 = 100; } else { DiemDongNghiepDanhGia1 = DiemDongNghiepDanhGia; DiemDongNghiepDanhGia = DiemDongNghiepDanhGia * 10 / 100; } DiemDongNghiepDanhGia = Math.Round(DiemDongNghiepDanhGia, 2); } string ten = ""; if (ds.Tables[3].Rows.Count > 0) { ten = ds.Tables[3].Rows[0]["HoTen"].ToString(); } double TongDiem = Math.Round(TongDiemDGCV, 2, MidpointRounding.AwayFromZero); TongDiem += Math.Round(diemKyLuat, 2, MidpointRounding.AwayFromZero); TongDiem += Math.Round(DiemDongNghiepDanhGia, 2, MidpointRounding.AwayFromZero); TongDiem = Math.Round(TongDiem, 2); string xepLoai = GetXepLoai(TongDiem); row["UserID"] = item["UserID"]; row["Bộ phận"] = tenTrungTam; row["Họ tên"] = ten; row["Điểm đánh giá công việc"] = Math.Round(TongDiemDGCV1, 2, MidpointRounding.AwayFromZero); row["Điểm kỷ luật và văn hóa doanh nghiệp"] = Math.Round(diemKyLuat1, 2, MidpointRounding.AwayFromZero); row["Điểm đồng nghiệp đánh giá"] = Math.Round(DiemDongNghiepDanhGia1, 2, MidpointRounding.AwayFromZero); row["Tổng điểm"] = Math.Round(TongDiem, 2, MidpointRounding.AwayFromZero); row["Xếp loại"] = xepLoai; dtUsersTemp.Rows.Add(row); } } //-------sort---------- DataView dv = new DataView(dtUsersTemp); if (ViewState["sortExpression"] != null && ViewState["sortExpression"].ToString() != string.Empty) { dv.Sort = ViewState["sortExpression"].ToString(); } if (ViewState["sortDirection"] != null && ViewState["sortDirection"].ToString() == "Desc") { dv.Sort = ViewState["sortExpression"].ToString() + " " + ViewState["sortDirection"].ToString(); } //--------sort------------- dtgUsers.DataSource = dv; dtgUsers.RowDataBound += new GridViewRowEventHandler(dtgUsers_RowDataBound); dtgUsers.DataBind(); if (dtUsers != null) { lblTotalTop.Text = lblTotalBottom.Text = dtUsers.Rows.Count.ToString(); } }
private XmlDocument BuildXmlDocument(DataTable dtDataOfNhanVien, XmlDocument xmlDoc, XmlElement tableNode, int stt, string ten) { #region Table Node DataRow[] Thang1 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '1'"); DataRow[] Thang2 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '2'"); DataRow[] Thang3 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '3'"); DataRow[] Thang4 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '4'"); DataRow[] Thang5 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '5'"); DataRow[] Thang6 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '6'"); DataRow[] Thang7 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '7'"); DataRow[] Thang8 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '8'"); DataRow[] Thang9 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '9'"); DataRow[] Thang10 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '10'"); DataRow[] Thang11 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '11'"); DataRow[] Thang12 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '12'"); XmlElement Table = xmlDoc.CreateElement("Table"); XmlElement STTNode = xmlDoc.CreateElement("STT"); XmlText STTNodeText = xmlDoc.CreateTextNode(stt.ToString()); STTNode.AppendChild(STTNodeText); XmlElement HoTenNode = xmlDoc.CreateElement("HoTen"); XmlText HoTenNodeText = xmlDoc.CreateTextNode(ten); HoTenNode.AppendChild(HoTenNodeText); XmlElement Thang1DiemNode = xmlDoc.CreateElement("Thang1Diem"); XmlText Thang1DiemNodeText = xmlDoc.CreateTextNode(Thang1.Length > 0 ? (ConvertUtility.ToDouble(Thang1[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang1DiemNode.AppendChild(Thang1DiemNodeText); XmlElement Thang1XepLoaiNode = xmlDoc.CreateElement("Thang1XepLoai"); XmlText Thang1XepLoaiNodeText = xmlDoc.CreateTextNode(Thang1.Length > 0 ? Thang1[0]["XepLoai"].ToString() : ""); Thang1XepLoaiNode.AppendChild(Thang1XepLoaiNodeText); XmlElement Thang2DiemNode = xmlDoc.CreateElement("Thang2Diem"); XmlText Thang2DiemNodeText = xmlDoc.CreateTextNode(Thang2.Length > 0 ? (ConvertUtility.ToDouble(Thang2[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang2DiemNode.AppendChild(Thang2DiemNodeText); XmlElement Thang2XepLoaiNode = xmlDoc.CreateElement("Thang2XepLoai"); XmlText Thang2XepLoaiNodeText = xmlDoc.CreateTextNode(Thang2.Length > 0 ? Thang2[0]["XepLoai"].ToString() : ""); Thang2XepLoaiNode.AppendChild(Thang2XepLoaiNodeText); XmlElement Thang3DiemNode = xmlDoc.CreateElement("Thang3Diem"); XmlText Thang3DiemNodeText = xmlDoc.CreateTextNode(Thang3.Length > 0 ? (ConvertUtility.ToDouble(Thang3[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang3DiemNode.AppendChild(Thang3DiemNodeText); XmlElement Thang3XepLoaiNode = xmlDoc.CreateElement("Thang3XepLoai"); XmlText Thang3XepLoaiNodeText = xmlDoc.CreateTextNode(Thang3.Length > 0 ? Thang3[0]["XepLoai"].ToString() : ""); Thang3XepLoaiNode.AppendChild(Thang3XepLoaiNodeText); XmlElement Thang4DiemNode = xmlDoc.CreateElement("Thang4Diem"); XmlText Thang4DiemNodeText = xmlDoc.CreateTextNode(Thang4.Length > 0 ? (ConvertUtility.ToDouble(Thang4[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang4DiemNode.AppendChild(Thang4DiemNodeText); XmlElement Thang4XepLoaiNode = xmlDoc.CreateElement("Thang4XepLoai"); XmlText Thang4XepLoaiNodeText = xmlDoc.CreateTextNode(Thang4.Length > 0 ? Thang4[0]["XepLoai"].ToString() : ""); Thang4XepLoaiNode.AppendChild(Thang4XepLoaiNodeText); XmlElement Thang5DiemNode = xmlDoc.CreateElement("Thang5Diem"); XmlText Thang5DiemNodeText = xmlDoc.CreateTextNode(Thang5.Length > 0 ? (ConvertUtility.ToDouble(Thang5[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang5DiemNode.AppendChild(Thang5DiemNodeText); XmlElement Thang5XepLoaiNode = xmlDoc.CreateElement("Thang5XepLoai"); XmlText Thang5XepLoaiNodeText = xmlDoc.CreateTextNode(Thang5.Length > 0 ? Thang5[0]["XepLoai"].ToString() : ""); Thang5XepLoaiNode.AppendChild(Thang5XepLoaiNodeText); XmlElement Thang6DiemNode = xmlDoc.CreateElement("Thang6Diem"); XmlText Thang6DiemNodeText = xmlDoc.CreateTextNode(Thang6.Length > 0 ? (ConvertUtility.ToDouble(Thang6[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang6DiemNode.AppendChild(Thang6DiemNodeText); XmlElement Thang6XepLoaiNode = xmlDoc.CreateElement("Thang6XepLoai"); XmlText Thang6XepLoaiNodeText = xmlDoc.CreateTextNode(Thang6.Length > 0 ? Thang6[0]["XepLoai"].ToString() : ""); Thang6XepLoaiNode.AppendChild(Thang6XepLoaiNodeText); XmlElement Thang7DiemNode = xmlDoc.CreateElement("Thang7Diem"); XmlText Thang7DiemNodeText = xmlDoc.CreateTextNode(Thang7.Length > 0 ? (ConvertUtility.ToDouble(Thang7[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang7DiemNode.AppendChild(Thang7DiemNodeText); XmlElement Thang7XepLoaiNode = xmlDoc.CreateElement("Thang7XepLoai"); XmlText Thang7XepLoaiNodeText = xmlDoc.CreateTextNode(Thang7.Length > 0 ? Thang7[0]["XepLoai"].ToString() : ""); Thang7XepLoaiNode.AppendChild(Thang7XepLoaiNodeText); XmlElement Thang8DiemNode = xmlDoc.CreateElement("Thang8Diem"); XmlText Thang8DiemNodeText = xmlDoc.CreateTextNode(Thang8.Length > 0 ? (ConvertUtility.ToDouble(Thang8[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang8DiemNode.AppendChild(Thang8DiemNodeText); XmlElement Thang8XepLoaiNode = xmlDoc.CreateElement("Thang8XepLoai"); XmlText Thang8XepLoaiNodeText = xmlDoc.CreateTextNode(Thang8.Length > 0 ? Thang8[0]["XepLoai"].ToString() : ""); Thang8XepLoaiNode.AppendChild(Thang8XepLoaiNodeText); XmlElement Thang9DiemNode = xmlDoc.CreateElement("Thang9Diem"); XmlText Thang9DiemNodeText = xmlDoc.CreateTextNode(Thang9.Length > 0 ? (ConvertUtility.ToDouble(Thang9[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang9DiemNode.AppendChild(Thang9DiemNodeText); XmlElement Thang9XepLoaiNode = xmlDoc.CreateElement("Thang9XepLoai"); XmlText Thang9XepLoaiNodeText = xmlDoc.CreateTextNode(Thang9.Length > 0 ? Thang9[0]["XepLoai"].ToString() : ""); Thang9XepLoaiNode.AppendChild(Thang9XepLoaiNodeText); XmlElement Thang10DiemNode = xmlDoc.CreateElement("Thang10Diem"); XmlText Thang10DiemNodeText = xmlDoc.CreateTextNode(Thang10.Length > 0 ? (ConvertUtility.ToDouble(Thang10[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang10DiemNode.AppendChild(Thang10DiemNodeText); XmlElement Thang10XepLoaiNode = xmlDoc.CreateElement("Thang10XepLoai"); XmlText Thang10XepLoaiNodeText = xmlDoc.CreateTextNode(Thang10.Length > 0 ? Thang10[0]["XepLoai"].ToString() : ""); Thang10XepLoaiNode.AppendChild(Thang10XepLoaiNodeText); XmlElement Thang11DiemNode = xmlDoc.CreateElement("Thang11Diem"); XmlText Thang11DiemNodeText = xmlDoc.CreateTextNode(Thang11.Length > 0 ? (ConvertUtility.ToDouble(Thang11[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang11DiemNode.AppendChild(Thang11DiemNodeText); XmlElement Thang11XepLoaiNode = xmlDoc.CreateElement("Thang11XepLoai"); XmlText Thang11XepLoaiNodeText = xmlDoc.CreateTextNode(Thang11.Length > 0 ? Thang11[0]["XepLoai"].ToString() : ""); Thang11XepLoaiNode.AppendChild(Thang11XepLoaiNodeText); XmlElement Thang12DiemNode = xmlDoc.CreateElement("Thang12Diem"); XmlText Thang12DiemNodeText = xmlDoc.CreateTextNode(Thang12.Length > 0 ? (ConvertUtility.ToDouble(Thang12[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0"); Thang12DiemNode.AppendChild(Thang12DiemNodeText); XmlElement Thang12XepLoaiNode = xmlDoc.CreateElement("Thang12XepLoai"); XmlText Thang12XepLoaiNodeText = xmlDoc.CreateTextNode(Thang12.Length > 0 ? Thang12[0]["XepLoai"].ToString(): ""); Thang12XepLoaiNode.AppendChild(Thang12XepLoaiNodeText); Table.AppendChild(STTNode); Table.AppendChild(HoTenNode); Table.AppendChild(Thang1DiemNode); Table.AppendChild(Thang1XepLoaiNode); Table.AppendChild(Thang2DiemNode); Table.AppendChild(Thang2XepLoaiNode); Table.AppendChild(Thang3DiemNode); Table.AppendChild(Thang3XepLoaiNode); Table.AppendChild(Thang4DiemNode); Table.AppendChild(Thang4XepLoaiNode); Table.AppendChild(Thang5DiemNode); Table.AppendChild(Thang5XepLoaiNode); Table.AppendChild(Thang6DiemNode); Table.AppendChild(Thang6XepLoaiNode); Table.AppendChild(Thang7DiemNode); Table.AppendChild(Thang7XepLoaiNode); Table.AppendChild(Thang8DiemNode); Table.AppendChild(Thang8XepLoaiNode); Table.AppendChild(Thang9DiemNode); Table.AppendChild(Thang9XepLoaiNode); Table.AppendChild(Thang10DiemNode); Table.AppendChild(Thang10XepLoaiNode); Table.AppendChild(Thang11DiemNode); Table.AppendChild(Thang11XepLoaiNode); Table.AppendChild(Thang12DiemNode); Table.AppendChild(Thang12XepLoaiNode); #endregion tableNode.AppendChild(Table); return(xmlDoc); }
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(); } DataTable dtPhong; if (!CurrentUser.IsAdmin && !CurrentUser.IsSuperAdmin) { dropTrungTam.Enabled = false; if (CurrentUser.RoleID != (int)Constants.Role.TruongBoPhanKhoiHoTro && CurrentUser.RoleID != (int)Constants.Role.TruongBoPhanKhoiKinhDoanh) { dtPhong = DotDanhGiaController.GetAllPhongBan(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), CurrentUser.UserID); } else { dtPhong = DotDanhGiaController.GetAllPhongBan(ConvertUtility.ToInt32(dropTrungTam.SelectedValue)); } } else { dtPhong = DotDanhGiaController.GetAllPhongBan(ConvertUtility.ToInt32(dropTrungTam.SelectedValue)); } 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"]), 2, 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, 2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue)); lstCongViec.Items.Clear(); QuanLyCongViecKTXVaPSController.LoadCongViecChuaDuocGiao(lstCongViec.Items, ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, 2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue)); if (idNhanVien > 0) { DataTable dtCongViecTX = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS_6_11_2014(idNhanVien, 2, 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); } dgrNhanVienCVKHT.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 } } dgrNhanVienCVKHT.DataBind(); }
void ButtonOkClick(object sender, EventArgs e) { item.Discount = ConvertUtility.ToDouble(textBoxDiscount.Text); DialogResult = DialogResult.OK; Close(); }
protected void butSubmit_Click(object sender, EventArgs e) { if (chkAgree.Checked) { var fullname = HTMLUtility.SecureHTML(txtFullName.Text.Trim()); var tel = HTMLUtility.SecureHTML(txtTel.Text.Trim()); var address = HTMLUtility.SecureHTML(txtAddress.Text.Trim()); var district = HTMLUtility.SecureHTML(txtDistrict.Text.Trim()); var city = HTMLUtility.SecureHTML(txtCity.Text.Trim()); var note = HTMLUtility.SecureHTML(txtNote.Text.Trim()); var orderdate = DateTime.Now; if (fullname.Length == 0 || tel.Length == 0 || address.Length == 0 || district.Length == 0 || city.Length == 0) { MessageBox.Show("Bạn phải điền đủ các trường (*)"); return; } var cart = (CommonLibrary.CartShopping.Cart)Session["cart"]; string email = CookieUtility.GetCookie("Member_Email"); var totalprice = cart.TotalPrice; var memberInfo = MemberDB.GetInfoByEmail(email); if (memberInfo.Member_Fullname.Length == 0) { memberInfo.Member_Fullname = fullname; } if (memberInfo.Member_Tel.Length == 0) { memberInfo.Member_Tel = tel; } if (memberInfo.Member_Address.Length == 0) { memberInfo.Member_Address = address; } if (memberInfo.Member_District.Length == 0) { memberInfo.Member_District = district; } if (memberInfo.Member_City.Length == 0) { memberInfo.Member_City = city; } MemberDB.Update(memberInfo); var info = new OrderInfo(); info.Member_ID = MemberDB.GetIDByEmail(email); info.Order_Fullname = fullname; info.Order_Email = email; info.Order_Tel = tel; info.Order_Address = address; info.Order_District = district; info.Order_City = city; info.Order_Note = note; info.Order_CreateDate = orderdate; info.Order_Status = 0; info.Order_Price = ConvertUtility.ToDouble(totalprice); info.Order_Quantity = ConvertUtility.ToInt32(cart.Items.Count); var orderid = OrderDB.Insert(info); var sbProducts = new StringBuilder(); sbProducts.Append("<tr>"); foreach (DataGridItem item in dtgProduct.Items) { var id = ConvertUtility.ToInt32(item.Cells[0].Text); var quantity = ConvertUtility.ToInt32(item.Cells[1].Text); var price = ConvertUtility.ToInt32(item.Cells[2].Text); var sum = price * quantity; var oinfo = new OrderProductInfo(); oinfo.Order_ID = orderid; oinfo.Content_ID = id; oinfo.Quantity = quantity; oinfo.Price = price; oinfo.PriceSum = sum; OrderProductDB.Insert(oinfo); sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid; text-align: center;\">" + item.ItemIndex + 1 + "</td>"); sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid;\">" + ContentDB.GetName(id) + "</td>"); sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid; text-align: center;\">" + quantity + "</td>"); sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid; text-align: center;\">" + string.Format("{0:0,0}", price) + "</td>"); sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid; text-align: center;\">" + string.Format("{0:0,0}", sum) + "</td>"); } sbProducts.Append("</tr>"); string emailadd = AppEnv.ContactEmail; var sb = new StringBuilder(); sb.Append("Ban co don dat hang #" + orderid + " tu My-Deal.vn:"); sb.Append("<br><br><b>Ten</b>: "); sb.Append(fullname); sb.Append("<br><b>Email</b>: "); sb.Append(email); sb.Append("<br><b>Dien thoai</b>: "); sb.Append(tel); sb.Append("<br><b>Dia chi</b>: "); sb.Append(txtAddress.Text); sb.Append("<br><b>Noi dung</b>:<br>"); sb.Append(txtNote.Text); sb.Append("<br><br>-----------------------------<br>De biet thong tin chi tiet don hang, hay dang nhang vao website<br>"); // new email solution start MailMessage emailmess = new MailMessage(email, emailadd); emailmess.Subject = "Don dat hang cua khach hang tu website"; emailmess.IsBodyHtml = true; emailmess.Body = sb.ToString(); SmtpClient smtp = new SmtpClient(); if (AppEnv.MailServer.Length == 0) { smtp.Host = "localhost"; } else { smtp.Host = AppEnv.MailServer; } if (AppEnv.MailServerPort.Length == 0) { smtp.Port = 25; } else { smtp.Port = ConvertUtility.ToInt32(AppEnv.MailServerPort); } // if authentication if (AppEnv.MailUsername.Length > 0 && AppEnv.MailPassword.Length > 0) { smtp.Credentials = new NetworkCredential(AppEnv.MailUsername, AppEnv.MailPassword); smtp.DeliveryMethod = SmtpDeliveryMethod.Network; } // if authentication end // gui cho khach hang thong tin deal var emailForCusContent = ""; //try //{ const string templateUrl = "/templates/deal_confirm.htm"; var htmlpage = GetHtmlPage(templateUrl); if (htmlpage != "NULL") { emailForCusContent = htmlpage; } //} //catch //{ // ErrorReportDB.NewReport(Request.RawUrl, "Thong tin CK HOSE:" + DateTime.Now); //} emailForCusContent = emailForCusContent.Replace("[[order_id]]", orderid.ToString()).Replace("[[order_datetime]]", orderdate.ToString("dd/MM/yyyy HH:mm")).Replace("[[order_note]]", note).Replace("[[order_products]]", sbProducts.ToString()).Replace("[[order_pricesum]]", string.Format("{0:0,0}", totalprice) + " VNĐ").Replace("[[order_fullname]]", fullname).Replace("[[order_address]]", address).Replace("[[order_tel]]", tel); // new email solution start var emailmess2 = new MailMessage(emailadd, email); emailmess2.Subject = "[My-deal.vn] Thong tin dat hang #" + orderid; emailmess2.IsBodyHtml = true; emailmess2.Body = emailForCusContent; var smtp2 = new SmtpClient(); if (AppEnv.MailServer.Length == 0) { smtp2.Host = "localhost"; } else { smtp2.Host = AppEnv.MailServer; } if (AppEnv.MailServerPort.Length == 0) { smtp2.Port = 25; } else { smtp2.Port = ConvertUtility.ToInt32(AppEnv.MailServerPort); } // if authentication if (AppEnv.MailUsername.Length > 0 && AppEnv.MailPassword.Length > 0) { smtp2.Credentials = new NetworkCredential(AppEnv.MailUsername, AppEnv.MailPassword); smtp2.DeliveryMethod = SmtpDeliveryMethod.Network; } // if authentication end try { smtp.Send(emailmess); smtp2.Send(emailmess2); notice.InnerHtml = "<br><br><br><font color=black><b>Đơn đặt hàng của bạn đã được gửi tới " + emailadd + ".Chúng tôi sẽ liên hệ với bạn trong thời gian ngắn nhất<br /><br />Xin chân thành cảm ơn!</b></font>"; } catch (Exception z) { notice.InnerHtml = "<br><br><br><font color=black><b>Đơn đặt hàng của bạn đã được gửi đi..Chúng tôi sẽ liên hệ với bạn trong thời gian ngắn nhất<br /><br />Xin chân thành cảm ơn!</b></font><br>"; } finally { pnPayment.Visible = false; notice.Visible = true; SessionUtility.Remove("cart"); } } else { MessageBox.Show("Bạn cần phải đồng ý với điều khoản của My-Deal.vn"); } }