protected void SetBottons()
{
/*
* if (EST_EMP_ID != gUserInfo.Emp_Ref_ID)
* {
* this.tdCalcBtnMargin.Visible = false;
* this.tdCalcBtn.Visible = false;
* }*/
for (int i = 0; i < EMP_ROLES.Count; i++)
{
//성과 평가 관리자만
string role_ref_id = DataTypeUtility.GetString(EMP_ROLES[i]);
if (role_ref_id.Equals("9"))
{
this.tdCalcBtnMargin.Visible = true;
this.tdCalcBtn.Visible = true;
this.ibnCalcPrjEstPoint.Enabled = true;
this.ibnCalcPrjEstPoint.Visible = true;
this.ibnSaveEst.Enabled = true;
this.ibnSaveEst.Visible = true;
this.ibnConfirmEst.Enabled = true;
this.ibnConfirmEst.Visible = true;
this.ibnCancelEst.Enabled = true;
this.ibnCancelEst.Visible = true;
}
}
}
//리커시브 함수
private int SelectTreeNodeByValue(TreeNodeCollection childNode, string value)
{
int nodeCnt = childNode.Count;
int flag;
if (nodeCnt > 0)
{
for (int i = 0; i < childNode.Count; i++)
{
flag = SelectTreeNodeByValue(childNode[i].ChildNodes, value);
if (flag == 0)
{
if (DataTypeUtility.GetString(childNode[i].Value).Equals(value))
{
childNode[i].Selected = true;
return(-1);
}
}
else if (flag == -1)
{
return(-1);
}
}
}
return(nodeCnt);
}
public int Remove_Kpi_Eqt_Eql_Ratio(IDbConnection conn, IDbTransaction trx
, int estterm_ref_id
, DataTable dt_kpi_ref_id)
{
int affectedRow = 0;
string kpi_ref_id_list = "";
for (int i = 0; i < dt_kpi_ref_id.Rows.Count; i++)
{
if (kpi_ref_id_list.Length > 0)
{
kpi_ref_id_list += ", ";
}
kpi_ref_id_list += DataTypeUtility.GetString(dt_kpi_ref_id.Rows[i]["KPI_REF_ID"]);
}
if (kpi_ref_id_list.Length == 0)
{
kpi_ref_id_list = "''";
}
affectedRow = _data.Delete_Bsc_Kpi_Eqt_Eql_Bulk(conn, trx
, estterm_ref_id
, kpi_ref_id_list);
return(affectedRow);
}
public bool Add_Self_Est_Question(IDbConnection conn, IDbTransaction trx, DataTable dt, int create_user_ref_id)
{
int affectedRow = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
int comp_id = DataTypeUtility.GetToInt32(dt.Rows[i]["COMP_ID"]);
string est_id = DataTypeUtility.GetString(dt.Rows[i]["EST_ID"]);
int estterm_ref_id = DataTypeUtility.GetToInt32(dt.Rows[i]["ESTTERM_REF_ID"]);
int estterm_sub_id = DataTypeUtility.GetToInt32(dt.Rows[i]["ESTTERM_SUB_ID"]);
int estterm_step_id = DataTypeUtility.GetToInt32(dt.Rows[i]["ESTTERM_STEP_ID"]);
int tgt_dept_id = DataTypeUtility.GetToInt32(dt.Rows[i]["TGT_DEPT_ID"]);
int tgt_emp_id = DataTypeUtility.GetToInt32(dt.Rows[i]["TGT_EMP_ID"]);
int self_top_id = DataTypeUtility.GetToInt32(dt.Rows[i]["SELF_TOP_ID"]);
int self_mid_id = DataTypeUtility.GetToInt32(dt.Rows[i]["SELF_MID_ID"]);
string self_comment = DataTypeUtility.GetString(dt.Rows[i]["SELF_COMMENT"]);
affectedRow += _data.Insert_Self_Est_Question(conn, trx
, comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, tgt_dept_id
, tgt_emp_id
, self_top_id
, self_mid_id
, self_comment
, create_user_ref_id);
}
return(affectedRow > 0 ? true : false);
}
protected DataTable Get_SaveDT_EstComment()
{
DataTable saveDT = CreateEstSelfDataColumns();
// string self_comment = PageUtility.GetHtmlEncodeChar(this.txtConsult.Text);
string self_comment = PageUtility.GetHtmlEncodeChar(this.txtConsult.Value);
for (int i = 0; i < ugrdEstComment.Rows.Count; i++)
{
DataRow dr = saveDT.NewRow();
TemplatedColumn tc = (TemplatedColumn)ugrdEstComment.Rows[i].Cells.FromKey("EST_COMMENT").Column;
RadioButtonList rdoEstComment = (RadioButtonList)((CellItem)tc.CellItems[i]).FindControl("rdoEstComment");
string self_top_id = DataTypeUtility.GetString(ugrdEstComment.Rows[i].Cells.FromKey("SELF_TOP_ID").Value);
string self_mid_id = DataTypeUtility.GetString(rdoEstComment.SelectedValue);
dr["COMP_ID"] = COMP_ID;
dr["EST_ID"] = EST_ID;
dr["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dr["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dr["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID;
dr["TGT_DEPT_ID"] = TGT_DEPT_ID;
dr["TGT_EMP_ID"] = TGT_EMP_ID;
dr["SELF_TOP_ID"] = self_top_id;
dr["SELF_MID_ID"] = self_mid_id;
dr["SELF_COMMENT"] = self_comment;
saveDT.Rows.Add(dr);
}
return(saveDT);
}
protected void DataList4_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
DataRowView dr = (DataRowView)e.Item.DataItem;
string q_dfn_id = DataTypeUtility.GetString(dr["Q_DFN_ID"]);
Biz_QuestionDefines questionDefines = new Biz_QuestionDefines(q_dfn_id, "");
Literal ltrDefName = e.Item.FindControl("ltrLevelDefName") as Literal;
Literal ltrDefine = e.Item.FindControl("ltrLevelDefine") as Literal;
DataList dalList = e.Item.FindControl("DataList6") as DataList;
HtmlTableCell tdHeader = null;
ltrDefName.Text = questionDefines.Q_Dfn_Name;
ltrDefine.Text = questionDefines.Q_Dfn_Define;
if (_q_item_desc_use_yn.Equals("Y"))
{
tdHeader = e.Item.FindControl("tdHeader") as HtmlTableCell;
tdHeader.Style.Add("width", "260px");
}
Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects();
DataSet ds = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, q_dfn_id);
dalList.DataSource = ds;
dalList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
ltrScript.Text = "";
if (!IsPostBack)
{
Biz_EstInfos estInfo = new Biz_EstInfos(COMP_ID, EST_ID);
Biz_TermInfos termInfo = new Biz_TermInfos(ESTTERM_REF_ID);
Biz_TermSubs termSubInfo = new Biz_TermSubs(COMP_ID, ESTTERM_SUB_ID);
ESTTERM_STEP_ID = 2;
Biz_EmpInfos empInfo = new Biz_EmpInfos(TGT_EMP_ID);
Biz_Com_Dept_Info deptInfo = new Biz_Com_Dept_Info(TGT_DEPT_ID);
Biz_PositionClasses clsInfo = new Biz_PositionClasses(empInfo.Position_Class_Code);
this.lblEstTerm.Text = string.Format("{0}({1})", DataTypeUtility.GetString(termInfo.EstTerm_Name), DataTypeUtility.GetString(termSubInfo.EstTerm_Sub_Name));
this.lblEstName.Text = DataTypeUtility.GetString(estInfo.Est_Name);
this.lblEstEmp.Text = string.Format("{1}({0})", DataTypeUtility.GetString(deptInfo.DEPT_NAME), DataTypeUtility.GetString(empInfo.Emp_Name));
this.lblEstEmpClass.Text = DataTypeUtility.GetString(clsInfo.Pos_Cls_Name);
txtConsult.ToolbarStartExpanded = false;
bindData();
}
setSaveBtn();
}
protected void doBind_prjEmp()
{
UltraWebGrid2.Clear();
MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data();
DT_EMP_EST_DATA = bizEstData.GetEstData(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, DIRECTION_TYPE, EST_EMP_ID, 0);
MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
string est_id = "3Q";//프로젝트 기여도 평가 EST_ID
DT_PRJ_DATA = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID
, COMP_ID
, est_id
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID);
DataTable dtPrj_PM_Data = DataTypeUtility.FilterSortDataTable(DT_PRJ_DATA, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1");
object point = dtPrj_PM_Data.Rows[0]["POINT"];
PRJ_POINT = DataTypeUtility.GetString(point);
UltraWebGrid2.DataSource = DT_PRJ_DATA;
UltraWebGrid2.DataBind();
}
public Dac_Prj_Schedule(int iprj_ref_id, int itask_ref_id)
{
DataSet ds = this.GetOneList(iprj_ref_id, itask_ref_id);
DataRow dr;
if (ds.Tables[0].Rows.Count > 0)
{
dr = ds.Tables[0].Rows[0];
_iprj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_itask_ref_id = DataTypeUtility.GetToInt32(dr["TASK_REF_ID"]);
_itask_name = DataTypeUtility.GetValue(dr["TASK_NAME"]);
_itask_type = DataTypeUtility.GetValue(dr["TASK_TYPE"]);
_itask_weight = DataTypeUtility.GetToDecimal(dr["TASK_WEIGHT"]);
_iup_task_ref_id = DataTypeUtility.GetToInt32(dr["UP_TASK_REF_ID"]);
_itask_code = DataTypeUtility.GetValue(dr["TASK_CODE"]);
_iplan_start_date = dr["PLAN_START_DATE"];
_iplan_end_date = dr["PLAN_END_DATE"];
_iactual_start_date = dr["ACTUAL_START_DATE"];
_iactual_end_date = dr["ACTUAL_END_DATE"];
_iproceed_rate = DataTypeUtility.GetToDecimal(dr["PROCEED_RATE"]);
_iatt_file = DataTypeUtility.GetValue(dr["ATT_FILE"]);
_icomplete_yn = DataTypeUtility.GetValue(dr["COMPLETE_YN"]);
_iisdelete = DataTypeUtility.GetValue(dr["ISDELETE"]);
_inode_depth = DataTypeUtility.GetToInt32(dr["NODE_DEPTH"]);
_iafter_task_ref_id = DataTypeUtility.GetToInt32(dr["AFTER_TASK_REF_ID"]);
_idesction = DataTypeUtility.GetString(dr["DESCTION"]);
_icreate_user = DataTypeUtility.GetToInt32(dr["CREATE_USER"]);
_icreate_date = DataTypeUtility.GetToDateTime(dr["CREATE_DATE"]);
_iupdate_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
_iupdate_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
}
}
protected void UltraWebGrid2_InitializeRow(object sender, RowEventArgs e)
{
//프로젝트 평가점수 바인딩
e.Row.Cells.FromKey("PRJ_POINT").Value = PRJ_POINT;
//개인종합평가 평가점수 바인딩
string tgt_dept_id = e.Row.Cells.FromKey("TGT_DEPT_ID").Value.ToString();
string tgt_emp_id = e.Row.Cells.FromKey("TGT_EMP_ID").Value.ToString();
string filter = string.Format("TGT_DEPT_ID={0} AND TGT_EMP_ID={1}", tgt_dept_id, tgt_emp_id);
DataTable empEstInfo = DataTypeUtility.FilterSortDataTable(DT_EMP_EST_DATA, filter);
string point = "";
if (empEstInfo.Rows.Count > 0)
{
point = DataTypeUtility.GetString(empEstInfo.Rows[0]["POINT"]);
}
if (point.Trim().Length == 0)
{
point = "-";
}
e.Row.Cells.FromKey("EST_POINT").Value = point;
//PM일 경우 처리
if (tgt_dept_id.Equals("-1") && tgt_emp_id.Equals("-1"))
{
e.Row.Cells.FromKey("POINT").Value = "-";
e.Row.Cells.FromKey("TGT_DEPT_NAME").Value = DT_PRJ_DATA.Rows[0]["EST_DEPT_NAME"];
e.Row.Cells.FromKey("TGT_EMP_NAME").Value = DT_PRJ_DATA.Rows[0]["EST_EMP_NAME"];
}
}
protected void ugrdEstQuestion_InitializeRow(object sender, RowEventArgs e)
{
string q_sbj_id = DataTypeUtility.GetString(e.Row.Cells.FromKey("Q_SBJ_ID"));
Biz_QuestionItems questionItems = new Biz_QuestionItems();
DataTable dt_q_item = questionItems.GetQuestionItem("", q_sbj_id, Q_OBJ_ID).Tables[0];
TemplatedColumn tc = (TemplatedColumn)e.Row.Band.Columns.FromKey("Q_ITEM");
RadioButtonList rdoQuestionItem = (RadioButtonList)((CellItem)tc.CellItems[e.Row.Index]).FindControl("rdoQuestionItem");
rdoQuestionItem.RepeatDirection = RepeatDirection.Horizontal;
rdoQuestionItem.RepeatLayout = RepeatLayout.Table;
rdoQuestionItem.DataSource = dt_q_item;
rdoQuestionItem.DataBind();
Biz_QuestionDatas questionDatas = new Biz_QuestionDatas(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_DEPT_ID
, EST_EMP_ID
, TGT_DEPT_ID
, TGT_EMP_ID
, q_sbj_id);
WebUtility.FindByValueRadioButtonList(rdoQuestionItem, questionDatas.Q_Itm_ID);
}
protected void writeLog(string msg)
{
//페이지 열릴대마다 로그 기록
if (WebUtility.GetConfig("USE_PAGE_OPEN_LOG", "N").Equals("Y"))
{
string base_dir = System.Web.HttpContext.Current.Server.MapPath("~");
string fileName = WebUtility.GetConfig("PAGE_OPEN_LOG_FILE", "~\\log.txt");
string name = fileName.Substring(0, fileName.LastIndexOf("."));
if (name.IndexOf("~") > -1)
{
name = name.Replace("~\\", base_dir);
}
string ext = fileName.Substring(fileName.LastIndexOf("."));
string logFile = name + System.DateTime.Now.ToString("_yyyy-MM-dd") + ext;
string proxyAddr = DataTypeUtility.GetString(Request.ServerVariables["HTTP_X_FORWARDED_FOR"]);
string remoteAddr = DataTypeUtility.GetString(Request.ServerVariables["REMOTE_ADDR"]);
string userAddr = string.Format("PROXY:{0}, USER:{1}", proxyAddr, remoteAddr);
System.Text.StringBuilder logMsg = new System.Text.StringBuilder();
logMsg.Append(msg);
try
{
MicroBSC.Common.ErrorLogs.WriteFileError(logMsg.ToString(), userAddr, logFile);
}
catch (Exception ex)
{ }
}
}
private void DisplayScore()
{
writeLog(string.Format("{0} : DisplayScore() Start", Request.PhysicalPath));
string dept_id = "";
string dept_name = "";
string est_dept_id = "";
string bdept_id = "";
string bdept_name = "";
string best_dept_id = "";
Biz_Bsc_Intro_Score bizDeptInfo = new Biz_Bsc_Intro_Score();
DataTable dtbizDeptInfo = bizDeptInfo.GetJeonsaInfo(DataTypeUtility.GetToInt32(IEstTermRefID).ToString()
);
if (dtbizDeptInfo.Rows.Count > 0)
{
est_dept_id = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][0]);
dept_name = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][1]);
}
int score = 0;
Biz_Bsc_Intro_Score bizScore = new Biz_Bsc_Intro_Score();
DataTable dtbizScore = bizScore.GetOrgScore("TS"
, DataTypeUtility.GetToInt32(IEstTermRefID).ToString()
, IYmd
, DataTypeUtility.GetToInt32(est_dept_id).ToString());
if (dtbizScore.Rows.Count > 0)
{
score = Convert.ToInt32(dtbizScore.Rows[0][6]);
if (score < 0)
{
score = 0;
}
}
lblTEAMname.Text = dept_name;
lblTEAMname.ToolTip = dept_name;
lblTEAMscore.Text = String.Format("{0:##0}", score);
lblTEAMscore.CssClass = searchColor(score);
string ESTTERM_REF_ID = DataTypeUtility.GetToInt32(IEstTermRefID).ToString();
string YMD = IYmd;
string SUM_TYPE = "TS";
string url = "BSC0408S6.ASPX?ESTTERM_REF_ID={0}&YMD={1}&SUM_TYPE={2}";
//string url = "BSC0408S4.ASPX?ESTTERM_REF_ID={0}&YMD={1}&SUM_TYPE={2}";
KPI_URL = string.Format(url, ESTTERM_REF_ID, YMD, SUM_TYPE);
writeLog(string.Format("{0} : DisplayScore() End", Request.PhysicalPath));
}
protected bool Confirm_EstQ()
{
//STATUS 정보 가져오기
int new_status_seq = 0;
if (ESTTERM_STEP_ID == 2)
{
//1차 평가 완료
new_status_seq = 5;
}
else if (ESTTERM_STEP_ID == 3)
{
//2차 평가 완료
new_status_seq = 7;
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript("잘못된 평가 차수 데이터입니다.");
}
int increment_seq = 1;
//데이터 수집
DataTable dt = Collect_CheckedData();
//데이터 가공 및 검증
for (int i = 0; i < dt.Rows.Count; i++)
{
string status_id = DataTypeUtility.GetString(dt.Rows[i]["STATUS_ID"]);
Biz_Est_Data bizEstData = new Biz_Est_Data();
Biz_Status new_status = bizEstData.Get_New_Est_Status(COMP_ID, EST_ID, status_id, new_status_seq, increment_seq);
if (new_status.Status_ID != null && new_status.Status_ID.Trim().Length > 0)
{
dt.Rows[i]["STATUS_ID"] = new_status.Status_ID;
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 단계로 진행할 수 없는 데이터가 있습니다.", new_status.Status_Name));
return(false);
}
}
dt = Add_Date_User(dt);
//데이터 저장
Biz_Datas datas = new Biz_Datas();
return(datas.SaveStatus(dt));
}
protected void doBindConsult()
{
DataTable dt = DataTypeUtility.FilterSortDataTable(DT_EST_SELF_DATA, "SELF_COMMENT IS NOT NULL");
if (dt.Rows.Count > 0)
{
// txtConsult.Text = DataTypeUtility.GetString(dt.Rows[0]["SELF_COMMENT"]);
txtConsult.Value = DataTypeUtility.GetString(dt.Rows[0]["SELF_COMMENT"]);
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
if (EST_TGT_TYPE.Equals("EST"))
{
if (ESTTERM_STEP_ID == 2)
{
//질의 별 평균 컬럼 활성
DataTable dt_q_dfn = DataTypeUtility.GetGroupByDataTable(DT_QUESTION_SBJ_POINT, new string[] { "Q_DFN_ID", "Q_DFN_NAME" });
int insert_pos = e.Layout.Bands[0].Columns.FromKey("Q_SBJ_POINT_AVG").Index;
for (int i = 0; i < dt_q_dfn.Rows.Count; i++)
{
string q_dfn_name = DataTypeUtility.GetString(dt_q_dfn.Rows[i]["Q_DFN_NAME"]) + "평균";
string q_dfn_id = DataTypeUtility.GetString(dt_q_dfn.Rows[i]["Q_DFN_ID"]);
string key = q_dfn_id;
if (!UltraWebGrid1.Columns.Exists(key))
{
UltraGridColumn col_q_dfn = new UltraGridColumn();
col_q_dfn.BaseColumnName = key;
col_q_dfn.Width = Unit.Pixel(100);
col_q_dfn.Key = key;
col_q_dfn.Header.Caption = q_dfn_name;
col_q_dfn.Header.Style.HorizontalAlign = HorizontalAlign.Center;
col_q_dfn.CellStyle.HorizontalAlign = HorizontalAlign.Right;
UltraWebGrid1.Columns.Insert(insert_pos + i, col_q_dfn);
}
}
e.Layout.Bands[0].Columns.FromKey("Q_SBJ_POINT_AVG").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("POINT_ORG").Hidden = false;
//관리자의 경우 점수 조정 컬럼 활성
if (IS_ADMIN)
{
e.Layout.Bands[0].Columns.FromKey("POINT_AVG").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("POINT_STD").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("POINT_CTRL_ORG").Hidden = false;
}
}
else if (ESTTERM_STEP_ID == 3)
{
e.Layout.Bands[0].Columns.FromKey("POINT_CTRL_ORG").Header.Caption = "합계점수";
e.Layout.Bands[0].Columns.FromKey("POINT_ORG_1ST").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("POINT_CTRL_ORG_1ST").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("POINT_BALANCE").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("POINT_CTRL_ORG").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("POINT").Hidden = false;
}
}
}
public Biz_Com_Dept_Info(int dept_ref_id)
{
_data = new Dac_Com_Dept_Info();
DataTable dt = _data.Select_DB(dept_ref_id);
if (dt.Rows.Count > 0)
{
DEPT_NAME = DataTypeUtility.GetString(dt.Rows[0]["DEPT_NAME"]);
}
}
/// <summary>
/// 해당 POS_ID의 데이터 삭제 후 인서트
/// </summary>
/// <param name="dt_est_pos_weight">COLUMNS : POS_ID, POS_VALUE, DEPT_TYPE_REF_ID, WEIGHT</param>
public int Add_Est_Pos_Weight(int comp_id
, int estterm_ref_id
, string est_id
, DataTable dt_est_pos_weight
, string pos_id
, int create_user_ref_id)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
_data.Delete_DB(conn
, trx
, comp_id
, estterm_ref_id
, est_id
, pos_id
, ""
, 0);
for (int i = 0; i < dt_est_pos_weight.Rows.Count; i++)
{
affectedRow += _data.Insert_DB(conn
, trx
, comp_id
, estterm_ref_id
, est_id
, i + 1
, DataTypeUtility.GetString(dt_est_pos_weight.Rows[i]["POS_ID"])
, DataTypeUtility.GetString(dt_est_pos_weight.Rows[i]["POS_VALUE"])
, DataTypeUtility.GetToInt32(dt_est_pos_weight.Rows[i]["DEPT_TYPE_REF_ID"])
, DataTypeUtility.GetToInt32(dt_est_pos_weight.Rows[i]["WEIGHT"])
, create_user_ref_id);
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
affectedRow = 0;
}
finally
{
conn.Close();
}
return(affectedRow);
}
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
UltraGridRow row = (UltraGridRow)(e.SelectedRows[0]);
PRJ_REF_ID = DataTypeUtility.GetToInt32(row.Cells.FromKey("PRJ_REF_ID").Value);
PRJ_CODE = DataTypeUtility.GetString(row.Cells.FromKey("PRJ_CODE").Value);
EST_DEPT_ID = DataTypeUtility.GetToInt32(row.Cells.FromKey("EST_DEPT_ID").Value);
EST_EMP_ID = DataTypeUtility.GetToInt32(row.Cells.FromKey("EST_EMP_ID").Value);
doBind_prjEmp();
}
public string SelectNextDeptID(IDbConnection conn, IDbTransaction trx)
{
object Result;
string query = @"
SELECT MAX(DEPT_REF_ID)+1
FROM COM_DEPT_INFO";
Result = DbAgentObj.ExecuteScalar(conn, trx, query, null, CommandType.Text);
return(DataTypeUtility.GetString(Result));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.Q_OBJ_ID = DataTypeUtility.GetString(new Biz_QuestionDeptEmpMaps(COMP_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID
, EST_ID, "", TGT_DEPT_ID, TGT_EMP_ID, "P").Q_Obj_ID);
TopLabel_Bind();
Grid_Bind();
}
setBtnState();
}
private void DrawChart(DataTable dt)
{
DataTable dtGrph = dt.Copy();
dtGrph.Columns.Add("YMD_NAME");
for (int i = 0; i < dtGrph.Rows.Count; i++)
{
string ymd = DataTypeUtility.GetString(dtGrph.Rows[i]["YMD"]);
string year = ymd.Substring(0, 4);
string month = ymd.Replace(year, "");
dtGrph.Rows[i]["YMD_NAME"] = DataTypeUtility.GetToInt32(month).ToString() + "월";
}
DundasCharts.DundasChartBase(chart_score
, Dundas.Charting.WebControl.ChartImageType.Flash
, DataTypeUtility.GetToInt32(Math.Ceiling(chart_score.Width.Value))
, DataTypeUtility.GetToInt32(Math.Ceiling(chart_score.Height.Value))
, Dundas.Charting.WebControl.BorderSkinStyle.None
, Color.FromArgb(181, 64, 1)
, 0
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0x20, 0x80, 0xD0)
, Dundas.Charting.WebControl.ChartDashStyle.Solid
, -1
, Dundas.Charting.WebControl.ChartHatchStyle.None
, GradientType.TopBottom
, AntiAliasing.None);
chart_score.DataSource = dtGrph;
string y_value_col_name = "SCORE";
Dundas.Charting.WebControl.Series series1 = DundasCharts.CreateSeries(chart_score, y_value_col_name, "Default", "점수", null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, GetChartColor2(0), Color.FromArgb(180, 26, 59, 105), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
series1.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle;
series1.ValueMemberX = "YMD_NAME";
series1.ValueMembersY = y_value_col_name;
series1.ToolTip = "#VALY{N0}";
series1.Label = "#VALY{N0}";
DundasAnimations.DundasChartBase(chart_score, AnimationTheme.None, -1, -1, false, 1);
DundasAnimations.GrowingAnimation(chart_score, series1, 0.5, 2.0, true);
chart_score.DataBind();
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
groupNumber = 0; // 정의별합산점수초기화
noneSelectCount = 0;
DataRowView dr = (DataRowView)e.Item.DataItem;
string q_dfn_id = DataTypeUtility.GetString(dr["Q_DFN_ID"]);
Biz_QuestionDefines questionDefines = new Biz_QuestionDefines(q_dfn_id, "");
Literal ltrDefName = e.Item.FindControl("ltrLevelDefName") as Literal;
Literal ltrDefine = e.Item.FindControl("ltrLevelDefine") as Literal;
DataList dalList = e.Item.FindControl("DataList3") as DataList;
Label lblText1 = e.Item.FindControl("lblAvgSumText") as Label;
Label lblText2 = e.Item.FindControl("lblAvgText") as Label;
lblValue1 = e.Item.FindControl("lblAvgSumValue") as Label;
lblValue2 = e.Item.FindControl("lblAvgValue") as Label;
ltrDefName.Text = questionDefines.Q_Dfn_Name;
ltrDefine.Text = questionDefines.Q_Dfn_Define;
lblText1.Text = lblName1;
lblText2.Text = lblName2;
Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects();
DataSet ds = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, q_dfn_id);
dalList.DataSource = ds;
dalList.DataBind();
double tmpSum = 0;
double tmpSumAvg = 0;
if (SUBJECT_ITEM_YN == "1")
{
lblText1.Text = "";
lblText2.Text = "환산점수";
lblValue2.Text = txtValueText;
}
else
{
tmpSum = Math.Round(((groupNumber * 100) / (5 * ds.Tables[0].Rows.Count)), 1);
tmpSumAvg = Math.Round(((((groupNumber * 100) / (5 * ds.Tables[0].Rows.Count)) * ds.Tables[0].Rows.Count) / (ds.Tables[0].Rows.Count - noneSelectCount)), 1);
lblValue1.Text = Convert.ToString(tmpSum);
lblValue2.Text = Convert.ToString(tmpSumAvg);
}
TOTALPOINT += DataTypeUtility.GetToDouble(lblValue2.Text);
}
}
protected bool Confirm_SelfEst()
{
int new_status_seq = 3;//자기평가 완료
int increment_seq = 1;
//데이터 수집
DataTable dt = new DataTable();
string[] cols = new string[this.UltraWebGrid1.Columns.Count - 1];
for (int i = 1; i < this.UltraWebGrid1.Columns.Count; i++)
{
cols[i - 1] = this.UltraWebGrid1.Columns[i].Key;
dt.Columns.Add(cols[i - 1]);
}
dt = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1, "cBox", "selchk", cols, dt);
//데이터 가공 및 검증
for (int i = 0; i < dt.Rows.Count; i++)
{
string status_id = DataTypeUtility.GetString(dt.Rows[i]["STATUS_ID"]);
Biz_Est_Data bizEstData = new Biz_Est_Data();
Biz_Status new_status = bizEstData.Get_New_Est_Status(COMP_ID, EST_ID, status_id, new_status_seq, increment_seq);
if (new_status.Status_ID != null && new_status.Status_ID.Trim().Length > 0)
{
dt.Rows[i]["STATUS_ID"] = new_status.Status_ID;
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 단계로 진행할 수 없는 데이터가 있습니다.", new_status.Status_Name));
return(false);
}
}
dt = Add_Date_User(dt);
//데이터 저장
Biz_Datas datas = new Biz_Datas();
return(datas.SaveStatus(dt));
}
protected DataTable Get_SaveDT_EstQuestion()
{
Biz_QuestionDatas questionDatas = new Biz_QuestionDatas();
DataTable saveDT = questionDatas.GetDataTableSchema();
TOTALPOINT = 0;
for (int i = 0; i < ugrdEstQuestion.Rows.Count; i++)
{
DataRow dr = saveDT.NewRow();
TemplatedColumn tc = (TemplatedColumn)ugrdEstQuestion.Rows[i].Cells.FromKey("Q_ITEM").Column;
RadioButtonList rdoQuestionItem = (RadioButtonList)((CellItem)tc.CellItems[i]).FindControl("rdoQuestionItem");
string q_obj_id = Q_OBJ_ID;
string q_sbj_id = DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_SBJ_ID").Value);
string q_itm_id = DataTypeUtility.GetString(rdoQuestionItem.SelectedValue);
Biz_QuestionItems bizQuestionItm = new Biz_QuestionItems(q_itm_id, q_sbj_id, q_obj_id);
double weight = bizQuestionItm.Weight;
double point = bizQuestionItm.Point * weight / 100;
dr["COMP_ID"] = COMP_ID;
dr["EST_ID"] = EST_ID;
dr["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dr["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dr["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID;
dr["EST_DEPT_ID"] = EST_DEPT_ID;
dr["EST_EMP_ID"] = EST_EMP_ID;
dr["TGT_DEPT_ID"] = TGT_DEPT_ID;
dr["TGT_EMP_ID"] = TGT_EMP_ID;
dr["Q_OBJ_ID"] = q_obj_id;
dr["Q_SBJ_ID"] = q_sbj_id;
dr["Q_ITM_ID"] = q_itm_id;
dr["POINT"] = point;
dr["GRADE_ID"] = "";
dr["TEXT_VALUE"] = "";
dr["OPINION"] = "";
dr["ATTACH_NO"] = "";
dr["USER"] = gUserInfo.Emp_Ref_ID;
TOTALPOINT += point;
saveDT.Rows.Add(dr);
}
return(saveDT);
}
protected bool setAverage_Point()
{
//데이터 수집
DataTable dt = getConfirmed_EstData();
int result = 0;
if (dt.Rows.Count > 0)
{
Biz_Est_Data bizEstData = new Biz_Est_Data();
DataTable dt_Bias_ratio = bizEstData.Get_Bias_AVG_Ratio_STD(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID);
//데이터 가공
for (int i = 0; i < dt.Rows.Count; i++)
{
string est_emp_id = DataTypeUtility.GetString(dt.Rows[i]["EST_EMP_ID"]);
string filter = string.Format("EST_EMP_ID={0}", est_emp_id);
DataTable dt_filtered_ratio = DataTypeUtility.FilterSortDataTable(dt_Bias_ratio, filter);
if (dt_filtered_ratio.Rows.Count > 0)
{
double avg_ratio = DataTypeUtility.GetToDouble(dt_filtered_ratio.Rows[0]["AVG_RATIO"]);
double point_org = DataTypeUtility.GetToDouble(dt.Rows[i]["POINT_ORG"]);
double point_avg = point_org * avg_ratio;
double point_ctrl_org = point_avg; //환산점수 계산용 점수
double point = point_ctrl_org * 100 / 5; //환산점수
dt.Rows[i]["POINT"] = Math.Round(point, 1);
dt.Rows[i]["POINT_AVG"] = Math.Round(point_avg, 1);
dt.Rows[i]["POINT_STD"] = -1;
dt.Rows[i]["POINT_CTRL_ORG"] = Math.Round(point_avg, 1);
dt.Rows[i]["STATUS_ID"] = "E";//확정
}
}
dt = Add_Date_User(dt);
result = bizEstData.ModifyEstData_Point(dt, gUserInfo.Emp_Ref_ID);
}
return(result > 0 ? true : false);
}
protected void SetTarget()
{
//DataTable DT = UltraGridUtility.GetDataSetByCheckedBox(UltraWebGrid1
// , new string[] { "PRJ_ID" }
// , "selchk"
// , "cBox").Tables[0];
DataTable DT = new DataTable();
DT.Columns.Add("PRJ_ID");
foreach (UltraGridRow row in UltraWebGrid1.Rows)
{
string status = DataTypeUtility.GetString(row.Cells.FromKey("PRJ_EST_STATUS").Value);
if (status.Equals("-"))
{
TemplatedColumn col_cBox = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
CheckBox cBox = (CheckBox)((CellItem)col_cBox.CellItems[row.BandIndex]).FindControl("cBox");
if (cBox.Checked == true)
{
DT.Rows.Add(row.Cells.FromKey("PRJ_ID").Value);
}
}
}
int estterm_step_id = 2;
bool Result;
Result = bizPrjInfo.Set_Est_Target(DT, COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, estterm_step_id, gUserInfo.Emp_Ref_ID);
if (DT.Rows.Count > 0)
{
if (Result)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리되었습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("오류가 발생했습니다..");
}
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("이미 적용된 프로젝트입니다.");
}
}
protected void ugrdSCHD_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
string schd_mid = DataTypeUtility.GetValue(e.Row.Cells.FromKey("schd_mid").Value);
string link_dir = DataTypeUtility.GetValue(e.Row.Cells.FromKey("link_dir").Value);
string link_page_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("link_page_name").Value);
string url = "<a href='{0}{1}'>{2}</a>";
string link = string.Format(url, link_dir, link_page_name, schd_mid);
e.Row.Cells.FromKey("schd_mid").Text = link;
string schd_mid_desc = DataTypeUtility.GetString(e.Row.Cells.FromKey("schd_mid_desc").Value);
e.Row.Cells.FromKey("schd_mid_desc").Value = string.Format("<span title=\"{0}\">{0}</span>", schd_mid_desc);
}
/// <summary>
/// 프로젝트평가 확정 전 평가하지 않은 피평가자 존재 확인
/// </summary>
protected bool Check_TgtEmp_Est_Status()
{
bool Result = true;
for (int i = 0; i < uwgrid_TGT_EMP_LIST.Rows.Count; i++)
{
object point = uwgrid_TGT_EMP_LIST.Rows[i].Cells.FromKey("POINT").Value;
if (DataTypeUtility.GetString(point).Length == 0)
{
return(false);
}
}
return(Result);
}
public int RetrieveDataInterfaceValue(int estterm_ref_id, string ymd, int user_ref_id)
{
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
int affectedRow = 0;
try
{
DataTable dt = _data.RetrieveDataInterfaceValue(conn, trx
, estterm_ref_id
, ymd);
for (int i = 0; i < dt.Rows.Count; i++)
{
string query_ms = DataTypeUtility.GetString(dt.Rows[i]["Q_MS"]);
string query_ts = DataTypeUtility.GetString(dt.Rows[i]["Q_TS"]);
int kpi_ref_id = DataTypeUtility.GetToInt32(dt.Rows[i]["KPI_REF_ID"]);
affectedRow += _data.Update_KPI_Result_From_RetrieveData(conn, trx
, query_ms
, query_ts
, estterm_ref_id
, kpi_ref_id
, ymd
, user_ref_id);
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
affectedRow = 0;
}
finally
{
conn.Close();
}
return(affectedRow);
}
