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;
}
}
