protected void btnAdd_Click(object sender, EventArgs e) { QuanLyCongViecBaoCaoNgayInfo info = new QuanLyCongViecBaoCaoNgayInfo(); info.IDCongViecKPI = 0; info.Ten = txtCongViec.Text; info.KeHoach = txtKeHoach.Text; info.ParentID = txtCongViecLon.Text; info.TyTrong = 0; info.KetQua = txtKetQua.Text; info.TyLeHoanThanh = txtTyLeHoanThanh.Text; info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue); info.IDPhongBan = 0;// ConvertUtility.ToInt32(dropPhongBan.SelectedValue); info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.SoGio = 0; 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.InsertBaoCaoNgayBoPhan(info); lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS; } catch (Exception ex) { lblStatusUpdate.Text = ex.Message; } }
protected void btnCapNhatCVHomTruoc_Click(object sender, EventArgs e) { DateTime dtTime = new DateTime(ConvertUtility.ToInt32(dropYearCopy.SelectedValue), ConvertUtility.ToInt32(dropMonthCopy.SelectedValue), ConvertUtility.ToInt32(dropDayCopy.SelectedValue)); DateTime dtTimeNow = new DateTime(ConvertUtility.ToInt32(dropYear.SelectedValue), ConvertUtility.ToInt32(dropMonth.SelectedValue), ConvertUtility.ToInt32(dropDay.SelectedValue)); DataTable dt = QuanLyCongViecBaoCaoNgayController.GetAllByUserID(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, dtTime, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), CurrentUser.UserID); foreach (DataRow item in dt.Rows) { QuanLyCongViecBaoCaoNgayInfo info = new QuanLyCongViecBaoCaoNgayInfo(); info.IDCongViecKPI = ConvertUtility.ToInt32(item["IDCongViecKPI"]); info.Ten = item["Ten"].ToString(); info.KeHoach = item["KeHoach"].ToString(); info.ParentID = item["ParentID"].ToString(); info.TyTrong = ConvertUtility.ToDouble(item["TyTrong"].ToString()); info.KetQua = item["KetQua"].ToString(); info.TyLeHoanThanh = item["TyLeHoanThanh"].ToString(); info.IDTrungTam = ConvertUtility.ToInt32(item["IDTrungTam"].ToString()); info.IDPhongBan = ConvertUtility.ToInt32(item["IDPhongBan"].ToString()); info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.SoGio = ConvertUtility.ToDouble(item["SoGio"].ToString()); info.CreateBy = CurrentUser.UserID; info.LyDo = item["LyDo"].ToString(); info.DeXuat = item["DeXuat"].ToString(); info.CreatedOn = dtTimeNow; 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 } catch (Exception ex) { lblStatusUpdate.Text = ex.Message; } } }
protected void btnCapNhatCVHomTruoc_Click(object sender, EventArgs e) { DateTime dtTime = new DateTime(ConvertUtility.ToInt32(dropYearCopy.SelectedValue), ConvertUtility.ToInt32(dropMonthCopy.SelectedValue), ConvertUtility.ToInt32(dropDayCopy.SelectedValue)); DateTime dtTimeNow = new DateTime(ConvertUtility.ToInt32(dropYear.SelectedValue), ConvertUtility.ToInt32(dropMonth.SelectedValue), ConvertUtility.ToInt32(dropDay.SelectedValue)); DataTable dt = QuanLyCongViecBaoCaoNgayController.GetAllByUserID(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, dtTime, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), CurrentUser.UserID); foreach (DataRow item in dt.Rows) { QuanLyCongViecBaoCaoNgayInfo info = new QuanLyCongViecBaoCaoNgayInfo(); info.IDCongViecKPI = ConvertUtility.ToInt32(item["IDCongViecKPI"]); info.Ten = item["Ten"].ToString(); info.KeHoach = item["KeHoach"].ToString(); info.ParentID = item["ParentID"].ToString(); info.TyTrong = ConvertUtility.ToDouble(item["TyTrong"].ToString()); info.KetQua = item["KetQua"].ToString(); info.TyLeHoanThanh = item["TyLeHoanThanh"].ToString(); info.IDTrungTam = ConvertUtility.ToInt32(item["IDTrungTam"].ToString()); info.IDPhongBan = ConvertUtility.ToInt32(item["IDPhongBan"].ToString()); info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue); info.SoGio = ConvertUtility.ToDouble(item["SoGio"].ToString()); info.CreateBy = CurrentUser.UserID; info.LyDo = item["LyDo"].ToString(); info.DeXuat = item["DeXuat"].ToString(); info.CreatedOn = dtTimeNow; 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 } catch (Exception ex) { lblStatusUpdate.Text = ex.Message; } } }
protected void btnUpdateVaoBoPhan_Click(object sender, EventArgs e) { foreach (GridViewRow item in dtgUsers.Rows) { CheckBox chk = (CheckBox)item.FindControl("chkCheck"); Label lblID = (Label)item.FindControl("lblID"); int id = ConvertUtility.ToInt32(lblID.Text); if (chk.Checked) { QuanLyCongViecBaoCaoNgayController.UpdateStatus(id, 1); QuanLyCongViecBaoCaoNgayInfo info = QuanLyCongViecBaoCaoNgayController.GetInfo(id); QuanLyCongViecBaoCaoNgayController.InsertBaoCaoNgayBoPhan(info); } else { QuanLyCongViecBaoCaoNgayController.UpdateStatus(id, 0); } } }
protected void cmdDel_Click(object sender, EventArgs e) { try { QuanLyCongViecBaoCaoNgayController.Delete(ConvertUtility.ToInt32(txtID.Text)); int ParentID = ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue); if (ParentID > 0) { QuanLyCongViecBaoCaoNgayInfo info = QuanLyCongViecBaoCaoNgayController.GetInfo(ConvertUtility.ToInt32(txtID.Text)); if (info == null) { cmdEmpty_Click(null, null); return; } string oldData = GetObjectInfo(info); #region Log Action LogFileInfo logFileInfo = new LogFileInfo(); logFileInfo.Log_Action = "Delete"; 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 = "Delete KPI with info: <br />" + GetObjectInfo(info); logFileInfo.UserName = CurrentUser.Username; logFileInfo.UserID = CurrentUser.UserID; CreateLogFile.LogAction(logFileInfo); #endregion } } catch (Exception ex) { lblStatusUpdate.Text = ex.Message; } }
private string GetObjectInfo(QuanLyCongViecBaoCaoNgayInfo info) { string returnValue = ""; #region Bind Old Info returnValue += "ID: " + info.ID + " <br />"; returnValue += "Ten: " + info.Ten + " <br />"; returnValue += "KeHoach: " + info.KeHoach + " <br />"; returnValue += "TyTrong: " + info.TyTrong + " <br />"; returnValue += "SoGio: " + info.SoGio + " <br />"; returnValue += "ParentID: " + info.ParentID + " <br />"; returnValue += "TyLeHoanThanh: " + info.TyLeHoanThanh + " <br />"; returnValue += "KetQua: " + info.KetQua + " <br />"; returnValue += "IDTrungTam: " + info.IDTrungTam + " <br />"; returnValue += "IDPhongBan: " + info.IDPhongBan + " <br />"; returnValue += "DateTime: " + DateTime.Now + " <br />"; returnValue += "LyDo:" + info.LyDo + " <br />"; returnValue += "DeXuat:" + info.DeXuat + " <br />"; #endregion return(returnValue); }
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; } }
private void LoadInfo(int id) { QuanLyCongViecBaoCaoNgayInfo info = QuanLyCongViecBaoCaoNgayController.GetInfo(id); if (info == null) { cmdEmpty_Click(null, null); return; } if (info.CreatedOn.Year != DateTime.Now.Year || info.CreatedOn.Month != DateTime.Now.Month || info.CreatedOn.Day < DateTime.Now.Day) { txtName.ReadOnly = true; txtKeHoach.ReadOnly = true; //txtTyTrong.ReadOnly = true; txtKetqua.ReadOnly = true; txtCongViecLon.ReadOnly = true; dropTyLeHoanThanh.Enabled = false; txtLyDo.ReadOnly = true; txtDeXuat.ReadOnly = true; //dropPhong.Enabled = false; txtSoGio.ReadOnly = true; } else { txtName.ReadOnly = false; txtKeHoach.ReadOnly = false; //txtTyTrong.ReadOnly = false; txtKetqua.ReadOnly = false; txtCongViecLon.ReadOnly = true; dropTyLeHoanThanh.Enabled = true; txtLyDo.ReadOnly = false; txtDeXuat.ReadOnly = false; //dropPhong.Enabled = true; txtSoGio.ReadOnly = false; } try { dropCongViecKPI.SelectedValue = info.IDCongViecKPI.ToString(); } catch (Exception) { dropCongViecKPI.SelectedIndex = 0; } txtID.Text = info.ID.ToString(); txtName.Text = info.Ten; txtKeHoach.Text = info.KeHoach; //txtTyTrong.Text = Math.Round(info.TyTrong, 3).ToString().Replace(".", ","); txtKetqua.Text = info.KetQua; txtCongViecLon.Text = info.ParentID; dropTyLeHoanThanh.SelectedValue = info.TyLeHoanThanh; txtLyDo.Text = info.LyDo; txtDeXuat.Text = info.DeXuat; //try //{ // dropPhong.SelectedValue = info.IDPhongBan.ToString(); //} //catch (Exception) //{ // dropPhong.SelectedIndex = -1; //} try { txtSoGio.Text = info.SoGio.ToString(); } catch (Exception) { txtSoGio.Text = ""; } dropYear.SelectedValue = info.CreatedOn.Year.ToString(); dropMonth.SelectedValue = info.CreatedOn.Month.ToString(); dropDay.SelectedValue = info.CreatedOn.Day.ToString(); }
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; } }
public static void UpdateBaoCaoNgayPhongBan(QuanLyCongViecBaoCaoNgayInfo _quanLyCongViecBaoCaoNgayInfo) { SqlConnection dbConn = new SqlConnection(AppEnv.ConnectionString); SqlCommand dbCmd = new SqlCommand("QuanLyCongViecBaoCaoNgayPhongBan_Update", dbConn); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add("@ID", _quanLyCongViecBaoCaoNgayInfo.ID); dbCmd.Parameters.Add("@IDCongViecKPI", _quanLyCongViecBaoCaoNgayInfo.IDCongViecKPI); dbCmd.Parameters.Add("@Ten", _quanLyCongViecBaoCaoNgayInfo.Ten); dbCmd.Parameters.Add("@KeHoach", _quanLyCongViecBaoCaoNgayInfo.KeHoach); dbCmd.Parameters.Add("@TyTrong", _quanLyCongViecBaoCaoNgayInfo.TyTrong); dbCmd.Parameters.Add("@ParentID", _quanLyCongViecBaoCaoNgayInfo.ParentID); dbCmd.Parameters.Add("@KetQua", _quanLyCongViecBaoCaoNgayInfo.KetQua); dbCmd.Parameters.Add("@TyLeHoanThanh", _quanLyCongViecBaoCaoNgayInfo.TyLeHoanThanh); dbCmd.Parameters.Add("@IDTrungTam", _quanLyCongViecBaoCaoNgayInfo.IDTrungTam); dbCmd.Parameters.Add("@IDPhongBan", _quanLyCongViecBaoCaoNgayInfo.IDPhongBan); dbCmd.Parameters.Add("@CreatedOn", _quanLyCongViecBaoCaoNgayInfo.CreatedOn); dbCmd.Parameters.Add("@IDDotDanhGia", _quanLyCongViecBaoCaoNgayInfo.IDDotDanhGia); dbCmd.Parameters.Add("@CreateBy", _quanLyCongViecBaoCaoNgayInfo.CreateBy); dbCmd.Parameters.Add("@SoGio", _quanLyCongViecBaoCaoNgayInfo.SoGio); dbCmd.Parameters.Add("@LyDo", _quanLyCongViecBaoCaoNgayInfo.LyDo); dbCmd.Parameters.Add("@DeXuat", _quanLyCongViecBaoCaoNgayInfo.DeXuat); try { dbConn.Open(); dbCmd.ExecuteNonQuery(); } finally { dbConn.Close(); } }
public static int InsertBaoCaoNgayPhongBan(QuanLyCongViecBaoCaoNgayInfo _quanLyCongViecBaoCaoNgayInfo, int status) { SqlConnection dbConn = new SqlConnection(AppEnv.ConnectionString); SqlCommand dbCmd = new SqlCommand("QuanLyCongViecBaoCaoNgayPhongBan_Insert", dbConn); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add("@IDCongViecKPI", _quanLyCongViecBaoCaoNgayInfo.IDCongViecKPI); dbCmd.Parameters.Add("@Ten", _quanLyCongViecBaoCaoNgayInfo.Ten); dbCmd.Parameters.Add("@KeHoach", _quanLyCongViecBaoCaoNgayInfo.KeHoach); dbCmd.Parameters.Add("@TyTrong", _quanLyCongViecBaoCaoNgayInfo.TyTrong); dbCmd.Parameters.Add("@ParentID", _quanLyCongViecBaoCaoNgayInfo.ParentID); dbCmd.Parameters.Add("@KetQua", _quanLyCongViecBaoCaoNgayInfo.KetQua); dbCmd.Parameters.Add("@TyLeHoanThanh", _quanLyCongViecBaoCaoNgayInfo.TyLeHoanThanh); dbCmd.Parameters.Add("@IDTrungTam", _quanLyCongViecBaoCaoNgayInfo.IDTrungTam); dbCmd.Parameters.Add("@IDPhongBan", _quanLyCongViecBaoCaoNgayInfo.IDPhongBan); dbCmd.Parameters.Add("@CreatedOn", _quanLyCongViecBaoCaoNgayInfo.CreatedOn); dbCmd.Parameters.Add("@IDDotDanhGia", _quanLyCongViecBaoCaoNgayInfo.IDDotDanhGia); dbCmd.Parameters.Add("@CreateBy", _quanLyCongViecBaoCaoNgayInfo.CreateBy); dbCmd.Parameters.Add("@SoGio", _quanLyCongViecBaoCaoNgayInfo.SoGio); dbCmd.Parameters.Add("@LyDo", _quanLyCongViecBaoCaoNgayInfo.LyDo); dbCmd.Parameters.Add("@DeXuat", _quanLyCongViecBaoCaoNgayInfo.DeXuat); dbCmd.Parameters.Add("@Status", status); dbCmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue; try { dbConn.Open(); dbCmd.ExecuteNonQuery(); return (int)dbCmd.Parameters["@RETURN_VALUE"].Value; } finally { dbConn.Close(); } }
public static QuanLyCongViecBaoCaoNgayInfo GetInfo(int _iD) { QuanLyCongViecBaoCaoNgayInfo retVal = null; SqlConnection dbConn = new SqlConnection(AppEnv.ConnectionString); SqlCommand dbCmd = new SqlCommand("QuanLyCongViecBaoCaoNgay_GetInfo", dbConn); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add("@ID", _iD); try { dbConn.Open(); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.Read()) { retVal = new QuanLyCongViecBaoCaoNgayInfo(); retVal.ID = Convert.ToInt32(dr["ID"]); retVal.IDCongViecKPI = Convert.ToInt32(dr["IDCongViecKPI"]); retVal.Ten = Convert.ToString(dr["Ten"]); retVal.KeHoach = Convert.ToString(dr["KeHoach"]); retVal.TyTrong = Convert.ToDouble(dr["TyTrong"]); retVal.ParentID = Convert.ToString(dr["ParentID"]); retVal.KetQua = Convert.ToString(dr["KetQua"]); retVal.TyLeHoanThanh = Convert.ToString(dr["TyLeHoanThanh"]); retVal.IDTrungTam = Convert.ToInt32(dr["IDTrungTam"]); retVal.IDPhongBan = Convert.ToInt32(dr["IDPhongBan"]); retVal.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]); retVal.IDDotDanhGia = Convert.ToInt32(dr["IDDotDanhGia"]); retVal.CreateBy = Convert.ToInt32(dr["CreateBy"]); retVal.SoGio = Convert.ToDouble(dr["SoGio"]); retVal.LyDo = Convert.ToString(dr["LyDo"]); retVal.DeXuat = Convert.ToString(dr["DeXuat"]); } if (dr != null) dr.Close(); } finally { dbConn.Close(); } return retVal; }
private string GetObjectInfo(QuanLyCongViecBaoCaoNgayInfo info) { string returnValue = ""; #region Bind Old Info returnValue += "ID: " + info.ID + " <br />"; returnValue += "Ten: " + info.Ten + " <br />"; returnValue += "KeHoach: " + info.KeHoach + " <br />"; returnValue += "TyTrong: " + info.TyTrong + " <br />"; returnValue += "SoGio: " + info.SoGio + " <br />"; returnValue += "ParentID: " + info.ParentID + " <br />"; returnValue += "TyLeHoanThanh: " + info.TyLeHoanThanh + " <br />"; returnValue += "KetQua: " + info.KetQua + " <br />"; returnValue += "IDTrungTam: " + info.IDTrungTam + " <br />"; returnValue += "IDPhongBan: " + info.IDPhongBan + " <br />"; returnValue += "DateTime: " + DateTime.Now + " <br />"; returnValue += "LyDo:" + info.LyDo + " <br />"; returnValue += "DeXuat:" + info.DeXuat + " <br />"; #endregion return returnValue; }
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; } }