private string GetObjectInfo(QuanLyCongViecKTXVaPSInfo info) { string returnValue = ""; #region Bind Old Info returnValue += "ID: " + info.ID + " <br />"; returnValue += "Ten: " + info.Ten + " <br />"; returnValue += "TyTrong: " + info.TyTrong + " <br />"; returnValue += "SoGio: " + info.SoGio + " <br />"; returnValue += "ParentID: " + info.ParentID + " <br />"; returnValue += "Priority: " + info.Priority + " <br />"; returnValue += "KeHoach: " + info.KeHoach + " <br />"; returnValue += "DonViDo: " + info.DonViDo + " <br />"; returnValue += "IDTrungTam: " + info.IDTrungTam + " <br />"; returnValue += "IDPhongBan: " + info.IDPhongBan + " <br />"; returnValue += "DateTime: " + DateTime.Now + " <br />"; returnValue += "IsKPI:" + info.IsKPI; returnValue += "NgayBatDau:" + info.NgayBatDau; returnValue += "NgayKetThuc:" + info.NgayKetThuc; #endregion return returnValue; }
private void InsertCongViecCon(DataTable source, DataRow curItem, int parentId, int idDotDanhGia) { DataRow[] rowChild = source.Select("ParentID='" + ConvertUtility.ToInt32(curItem["ID"]) + "'"); if (rowChild.Length > 0) { foreach (DataRow itemChild in rowChild) { QuanLyCongViecKTXVaPSInfo info = new QuanLyCongViecKTXVaPSInfo(); info.Ten = ConvertUtility.ToString(itemChild["Ten"]); info.TyTrong = ConvertUtility.ToDouble(itemChild["TyTrong"]); info.SoGio = ConvertUtility.ToDouble(itemChild["SoGio"]); info.ParentID = parentId; info.Priority = ConvertUtility.ToInt32(itemChild["Priority"]); info.KeHoach = ConvertUtility.ToString(itemChild["KeHoach"]); info.DonViDo = ConvertUtility.ToString(itemChild["DonViDo"]); info.IDTrungTam = ConvertUtility.ToInt32(itemChild["IDTrungTam"]); info.IDPhongBan = ConvertUtility.ToInt32(itemChild["IDPhongBan"]); info.Loai = ConvertUtility.ToInt32(itemChild["Loai"]); info.IDDotDanhGia = idDotDanhGia; info.LevelDeep = ConvertUtility.ToInt32(itemChild["LevelDeep"]); info.NgayBatDau = ConvertUtility.ToDateTime(itemChild["NgayBatDau"]).AddMonths(1); info.NgayKetThuc = ConvertUtility.ToDateTime(itemChild["NgayKetThuc"]).AddMonths(1); info.TrangThaiCV = ConvertUtility.ToInt32(itemChild["TrangThaiCV"]); info.TuanLamViec = ConvertUtility.ToString(itemChild["TuanLamViec"]); info.OldID = ConvertUtility.ToInt32(itemChild["ID"]); int parentIDTemp = QuanLyCongViecKTXVaPSController.Insert_6_11_2014(info); InsertCongViecCon(source, itemChild, parentIDTemp, idDotDanhGia); } } }
protected void btnLayCongViecThangTruoc_Click(object sender, EventArgs e) { QuanLyCongViecKTXVaPSController.ClearAllCongViecTheoBoPhanVaDotDanhGia(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 2); #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, 2, 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"]); 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, 2, 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 = 2; 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"] = "2"; }
protected void cmdAdd_Click(object sender, EventArgs e) { QuanLyCongViecKTXVaPSInfo info = new QuanLyCongViecKTXVaPSInfo(); info.Ten = txtName.Text; info.ParentID = ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue); info.TyTrong = ConvertUtility.ToDouble(txtTyTrong.Text); info.KeHoach = txtKeHoach.Text; info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue); info.DonViDo = txtDonViDo.Text; info.IDPhongBan = 0;//ConvertUtility.ToInt32(dropPhong.SelectedValue); info.Loai = 2; info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.SoGio = ConvertUtility.ToDouble(txtSoGio.Text); info.IsKPI = ConvertUtility.ToInt32(dropKPIBoPhan.SelectedValue); info.NgayBatDau = ConvertUtility.ToDateTime(dtFrom.Text); 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.Insert(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 lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS; UpdateCapDoCongViec(); cmdEmpty_Click(null, null); } catch (Exception ex) { lblStatusUpdate.Text = ex.Message; } Session["Nav"] = "2"; }
public static int Insert(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo) { return DataAccessProvider.Instance().InsertCongViecKTXVaPS(_QuanLyCongViecKPIInfo); }
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 = 2; 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 = 2; 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"] = "2"; }
public override void UpdateCongViecKTXVaPS(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo) { SqlHelper.ExecuteNonQuery(this.ConnectionString, "QuanLyCongViecKTXVaPS_Update_5_6_2014", _QuanLyCongViecKPIInfo.ID, _QuanLyCongViecKPIInfo.Ten, _QuanLyCongViecKPIInfo.TyTrong, _QuanLyCongViecKPIInfo.ParentID, _QuanLyCongViecKPIInfo.KeHoach, _QuanLyCongViecKPIInfo.DonViDo, _QuanLyCongViecKPIInfo.IDTrungTam, _QuanLyCongViecKPIInfo.IDPhongBan, _QuanLyCongViecKPIInfo.Loai, _QuanLyCongViecKPIInfo.IDDotDanhGia, _QuanLyCongViecKPIInfo.SoGio, _QuanLyCongViecKPIInfo.IsKPI, _QuanLyCongViecKPIInfo.NgayBatDau, _QuanLyCongViecKPIInfo.NgayKetThuc, _QuanLyCongViecKPIInfo.IDNhomCongViec, _QuanLyCongViecKPIInfo.TrangThaiCV, _QuanLyCongViecKPIInfo.TuanLamViec); }
public static void Update(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo) { DataAccessProvider.Instance().UpdateCongViecKTXVaPS(_QuanLyCongViecKPIInfo); }
public override int InsertCongViecKTXVaPS_6_11_2014(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo) { return (int)SqlHelper.ExecuteScalar(this.ConnectionString, "QuanLyCongViecKTXVaPS_Insert_6_11_2014", _QuanLyCongViecKPIInfo.Ten, _QuanLyCongViecKPIInfo.TyTrong, _QuanLyCongViecKPIInfo.ParentID, _QuanLyCongViecKPIInfo.KeHoach, _QuanLyCongViecKPIInfo.DonViDo, _QuanLyCongViecKPIInfo.IDTrungTam, _QuanLyCongViecKPIInfo.IDPhongBan, _QuanLyCongViecKPIInfo.Loai, _QuanLyCongViecKPIInfo.IDDotDanhGia, _QuanLyCongViecKPIInfo.SoGio, _QuanLyCongViecKPIInfo.IsKPI, _QuanLyCongViecKPIInfo.NgayBatDau, _QuanLyCongViecKPIInfo.NgayKetThuc, _QuanLyCongViecKPIInfo.IDNhomCongViec, _QuanLyCongViecKPIInfo.TrangThaiCV, _QuanLyCongViecKPIInfo.TuanLamViec, _QuanLyCongViecKPIInfo.OldID); }
public static int Insert_6_11_2014(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo) { return(DataAccessProvider.Instance().InsertCongViecKTXVaPS_6_11_2014(_QuanLyCongViecKPIInfo)); }
public abstract void UpdateCongViecKTXVaPS(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo);
public abstract int InsertCongViecKTXVaPS_6_11_2014(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo);