protected void ugrdMapKpi_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
e.Row.Height = Unit.Pixel(20);
DataRowView drw = (DataRowView)e.Data;
//if (drw["APPROVAL_STATUS"].ToString() == "0")
//{
// e.Row.Cells.FromKey("CONFIRMSTATUS").Value = string.Format("<div class='stext'><img src='../images/icon_x.gif'></div>");
//}
//else
//{
// e.Row.Cells.FromKey("CONFIRMSTATUS").Value = string.Format("<div class='stext'><img src='../images/icon_o.gif'></div>");
//}
TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("APP_STATUS");
System.Web.UI.WebControls.Image objImg = (System.Web.UI.WebControls.Image)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("imgApp");
string strImg = e.Row.Cells.FromKey("APP_STATUS").Value.ToString();
objImg.ImageUrl = Biz_Com_Approval_Info.GetAppImageUrl(strImg);
objImg.AlternateText = Biz_Com_Approval_Info.GetAppImageText(strImg);
string kpi_ref_id = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_REF_ID").Value);
string kpi_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_NAME").Value);
string url = "<a href='#null' onclick='doPoppingUp_KPI(\"{0}\",\"{1}\")' style=\"color:Navy;\">{2}</a>";
string temp = string.Format(url, IEstTermRefID, kpi_ref_id, kpi_name);
e.Row.Cells.FromKey("KPI_NAME").Value = temp;
}
protected void ugrdDeptKpi_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
CheckBox chkCheck;
TemplatedColumn Col_Check = (TemplatedColumn)e.Row.Band.Columns.FromKey("selchk");
chkCheck = (CheckBox)((CellItem)Col_Check.CellItems[e.Row.BandIndex]).FindControl("cBox");
//e.Row.Cells.FromKey("APP_STATUS_NAME").Value = "Y";
//if (e.Row.Cells.FromKey("APP_STATUS").Value != null)
//{
// if (e.Row.Cells.FromKey("APP_STATUS").Value.ToString() != Biz_Type.app_status_complete)
// {
// chkCheck.Enabled = false;
// e.Row.Cells.FromKey("APP_STATUS_NAME").Value = "N";
// }
//}
//DataRowView drv = (DataRowView)e.Data;
//if (drv["COM_DEPT_REF_ID"].ToString() != this.IDEPT_ID.ToString())
// chkCheck.Enabled = false;
string kpi_code = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_POOL_REF_ID").Value);
string kpi_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_NAME").Value);
string onclick = "<a href='#null' onclick=\"doLinking_Pool('{0}')\">{1}</a>";
string link = string.Format(onclick, kpi_code, kpi_name);
e.Row.Cells.FromKey("KPI_NAME").Value = link;
}
public bool RemoveCtrlEstMap(DataTable dataTable)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += _ctrlEstMap.Delete(conn
, trx
, DataTypeUtility.GetValue(dataRow["CTRL_ID"])
, DataTypeUtility.GetValue(dataRow["EST_ID"]));
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
protected void ugrdKpiResultList_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
DataRowView drw = (DataRowView)e.Data;
string strTrend = e.Row.Cells.FromKey("TREND").Value.ToString();
switch (strTrend)
{
case "UP":
e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_e_up.gif'>";;
break;
case "DOWN":
e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_b_down.gif'>";;
break;
case "FLAT":
e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_m.gif'>";;
break;
default:
break;
}
e.Row.Cells.FromKey("THRESHOLD_IMG").Value = "<div align=center><img src='../images/" + e.Row.Cells.FromKey("THRESHOLD_IMG").Value.ToString() + "'></div>";
double dTemp = 0;
string sARate = DataTypeUtility.GetValue(e.Row.Cells.FromKey("ACHV_RATE").Value);
e.Row.Cells.FromKey("ACHV_RATE").Value = (double.TryParse(sARate, out dTemp)) ? Convert.ToDouble(sARate.Replace('-', '0')).ToString("#,###,###,##0.00") : sARate;
//_iTRow += 1;
//lblCountRow.Text = "Total Rows : " + _iTRow.ToString();
}
protected void ugrdDraft_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
DataRowView drw = (DataRowView)e.Data;
if (drw["CHECK_YN"].ToString() == "N")
{
e.Row.Cells.FromKey("CHECK_YN").Text = string.Format("<div class='stext'><img src='../images/icon_x.gif'></div>");
}
else
{
e.Row.Cells.FromKey("CHECK_YN").Text = string.Format("<div class='stext'><img src='../images/icon_o.gif'></div>");
}
if (drw["CHECKSTATUS"].ToString() == "N")
{
e.Row.Cells.FromKey("CHECKSTATUS").Text = string.Format("<div class='stext'><img src='../images/icon_x.gif'></div>");
}
else
{
e.Row.Cells.FromKey("CHECKSTATUS").Text = string.Format("<div class='stext'><img src='../images/icon_o.gif'></div>");
}
TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("APP_STATUS");
System.Web.UI.WebControls.Image objImg = (System.Web.UI.WebControls.Image)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("imgApp");
string strImg = DataTypeUtility.GetValue(e.Row.Cells.FromKey("APP_STATUS").Value);
objImg.ImageUrl = Biz_Com_Approval_Info.GetAppImageUrl(strImg);
objImg.AlternateText = Biz_Com_Approval_Info.GetAppImageText(strImg);
}
public Biz_Prj_QuestionPrjMap(int comp_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, string est_id
, string q_obj_id
, int prj_ref_id)
{
DataSet ds = null;
ds = _questionPrjMap.Select(comp_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, est_id
, q_obj_id
, prj_ref_id);
DataRow dr;
if (ds != null && ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_estterm_ref_id = DataTypeUtility.GetToInt32(dr["ESTTERM_REF_ID"]);
_estterm_sub_id = DataTypeUtility.GetToInt32(dr["ESTTERM_SUB_ID"]);
_estterm_step_id = DataTypeUtility.GetToInt32(dr["ESTTERM_STEP_ID"]);
_est_id = DataTypeUtility.GetValue(dr["EST_ID"]);
_q_obj_id = DataTypeUtility.GetValue(dr["Q_OBJ_ID"]);
_prj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
/// <summary>
/// 평가차수의 총가중치 합 반환
/// </summary>
/// <param name="est_id"></param>
/// <returns></returns>
public static double GetTotalWeightEstTermStep(int comp_id, string est_id)
{
Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id);
Biz_TermStepEstMaps estterm = new Biz_TermStepEstMaps();
DataTable dataTable = estterm.GetTermStepEstMap(comp_id, est_id).Tables[0];
double total = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
// 상향평가가 아닌 가중치만 더한다.
if (!DataTypeUtility.GetYNToBoolean(DataTypeUtility.GetValue(dataRow["FIXED_WEIGHT_YN"])))
{
total += DataTypeUtility.GetToDouble(dataRow["WEIGHT"]);
}
}
// 만약 상향평가일 경우 고정가중치를 더해준다.
if (DataTypeUtility.GetYNToBoolean(estInfo.Fixed_Weight_Use_YN))
{
total += DataTypeUtility.GetToDouble(estInfo.Fixed_Weight);
}
if (total == 0)
{
return(100);
}
return(total);
}
private void DoBinding(int estTermRefID, int deptID)
{
UltraWebGrid1.Clear();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();
DataTable dtBscKpiInfo = bizBscKpiInfo.Get_GoalTongDashboard(estTermRefID, deptID);
if (dtBscKpiInfo.Rows.Count > 0)
{
this.ChartView.Visible = true;
UltraWebGrid1.DataSource = dtBscKpiInfo;
UltraWebGrid1.DataBind();
UltraWebGrid1.Rows[0].Activated = true;
int kpi_ref_id = DataTypeUtility.GetToInt32(dtBscKpiInfo.Rows[0]["KPI_REF_ID"]);
string kpi_name = DataTypeUtility.GetValue(dtBscKpiInfo.Rows[0]["KPI_NAME"]);
DoCharting(kpi_ref_id, kpi_name);
}
else
{
this.ChartView.Visible = false;
//chartMM.Visible = false;
//chartDal.Visible = false;
}
}
protected void UltraWebGrid1_InitializeRow(object sender, RowEventArgs e)
{
DataRowView drw = (DataRowView)e.Data;
TemplatedColumn hdf_col = (TemplatedColumn)e.Row.Band.Columns.FromKey("CTRL_EMP");
HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[e.Row.BandIndex]).FindControl("hdfTgtEmpID");
TemplatedColumn txt_col = (TemplatedColumn)e.Row.Band.Columns.FromKey("CTRL_EMP");
TextBox txtTgtEmpName = (TextBox)((CellItem)txt_col.CellItems[e.Row.BandIndex]).FindControl("txtTgtEmpName");
TemplatedColumn ltr_col = (TemplatedColumn)e.Row.Band.Columns.FromKey("CTRL_EMP");
Literal ltrImage = (Literal)((CellItem)ltr_col.CellItems[e.Row.BandIndex]).FindControl("ltrImage");
DataRow[] drArr = DT_TGT_OPINION.Select(string.Format(@"TGT_DEPT_ID = {0}", drw["DEPT_REF_ID"]));
ltrImage.Text = string.Format(string.Format("<a href='#null' onclick=\"SelectEmp('{0}', '{1}', '{2}');\"><img align='absMiddle' border='0' src='../images/btn/b_008.gif' /></a>"
, hdfTgtEmpID.ClientID
, txtTgtEmpName.ClientID
, drw["DEPT_REF_ID"]));
e.Row.Cells.FromKey("TGT_DEPT_ID").Value = drw["DEPT_REF_ID"];
if (drArr.Length > 0)
{
hdfTgtEmpID.Value = DataTypeUtility.GetValue(drArr[0]["TGT_EMP_ID"]);
txtTgtEmpName.Text = DataTypeUtility.GetValue(drArr[0]["TGT_EMP_NAME"]);
}
else
{
}
}
protected void iBtnTemplete_Click(object sender, ImageClickEventArgs e)
{
int cnt = ugrdKPIPool.Rows.Count;
string kpi_pool_id_list = string.Empty;
for (int i = 0; i < cnt; i++)
{
UltraGridRow row = ugrdKPIPool.Rows[i];
TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox");
if (cBox.Checked)
{
kpi_pool_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("KPI_POOL_REF_ID").Value);
}
}
if (kpi_pool_id_list.Length > 0)
{
BizUtility.KPI_POOL_LIST = kpi_pool_id_list.Remove(0, 1);
}
string url = "BSC0301M4.aspx";
string str = string.Format("gfOpenWindow('{0}', 800, 400, false, false, '_bk');", url);
ltrScript.Text = JSHelper.GetSclipt(str);
}
public Biz_Boards(string board_id, string board_category_id)
{
DataSet ds = _board.Select(board_id, board_category_id, 0, "");
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_board_id = DataTypeUtility.GetValue(dr["BOARD_ID"]);
_board_category_id = DataTypeUtility.GetValue(dr["BOARD_CATEGORY_ID"]);
_subject_text = DataTypeUtility.GetValue(dr["SUBJECT_TEXT"]);
_content_text = DataTypeUtility.GetValue(dr["CONTENT_TEXT"]);
_read_count = DataTypeUtility.GetToInt32(dr["READ_COUNT"]);
_attach_no = DataTypeUtility.GetValue(dr["ATTACH_NO"]);
_p_board_id = DataTypeUtility.GetValue(dr["P_BOARD_ID"]);
_group_id = DataTypeUtility.GetValue(dr["GROUP_ID"]);
_level_id = DataTypeUtility.GetToInt32(dr["LEVEL_ID"]);
_seq_id = DataTypeUtility.GetToInt32(dr["SEQ_ID"]);
_start_date = DataTypeUtility.GetToDateTime(dr["START_DATE"]);
_end_date = DataTypeUtility.GetToDateTime(dr["END_DATE"]);
_menu_ref_id = DataTypeUtility.GetToInt32(dr["MENU_REF_ID"]);
_pop_up_yn = DataTypeUtility.GetValue(dr["POP_UP_YN"]);
_write_emp_id = DataTypeUtility.GetToInt32(dr["WRITE_EMP_ID"]);
_write_emp_name = DataTypeUtility.GetValue(dr["WRITE_EMP_NAME"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
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 ibnSearch_Click(object sender, ImageClickEventArgs e)
{
string page_name = "";
string title_name = "";
Dac_EISDatas obj = new Dac_EISDatas();
DataTable dt = obj.GetEISSub(WebUtility.GetIntByValueDropDownList(ddlMain), WebUtility.GetIntByValueDropDownList(ddlSub));
if (dt.Rows.Count > 0)
{
page_name = DataTypeUtility.GetValue(dt.Rows[0]["PAGE_NAME"]);
title_name = DataTypeUtility.GetValue(dt.Rows[0]["TITLE_NAME"]);
}
((_common_lib_MicroBSC)this.Master).SetTitle(title_name);
if (page_name.IndexOf("?") >= 0)
{
ifmContent.Attributes.Add("src", string.Format("{0}&ESTTERM_REF_ID={1}&YMD={2}&M_ID={3}&S_ID={4}"
, page_name
, WebUtility.GetIntByValueDropDownList(ddlEstRefID)
, WebUtility.GetIntByValueDropDownList(ddlYMD)
, WebUtility.GetIntByValueDropDownList(ddlMain)
, WebUtility.GetIntByValueDropDownList(ddlSub)));
}
else
{
ifmContent.Attributes.Add("src", string.Format("{0}?ESTTERM_REF_ID={1}&YMD={2}&M_ID={3}&S_ID={4}"
, page_name
, WebUtility.GetIntByValueDropDownList(ddlEstRefID)
, WebUtility.GetIntByValueDropDownList(ddlYMD)
, WebUtility.GetIntByValueDropDownList(ddlMain)
, WebUtility.GetIntByValueDropDownList(ddlSub)));
}
}
public bool GetSendMailUser(decimal iapp_ref_id, int iversion_no, int itxr_user, out string sC_EMP_MAIL, out string sP_EMP_MAIL, out string sN_EMP_MAIL)
{
bool blnRtn = false;
DataSet rDs = base.GetAllList(iapp_ref_id, iversion_no);
string sEmpRefID = "0";
sC_EMP_MAIL = "";
sP_EMP_MAIL = "";
sN_EMP_MAIL = "";
int iRow = rDs.Tables[0].Rows.Count;
for (int i = 0; i < iRow; i++)
{
sEmpRefID = DataTypeUtility.GetValue(rDs.Tables[0].Rows[i]["EMP_REF_ID"]);
if (sEmpRefID == itxr_user.ToString())
{
blnRtn = true;
sC_EMP_MAIL = DataTypeUtility.GetValue(rDs.Tables[0].Rows[i]["EMP_EMAIL"]);
if (i > 0)
{
sP_EMP_MAIL = DataTypeUtility.GetValue(rDs.Tables[0].Rows[i - 1]["EMP_EMAIL"]);
}
if ((i + 1) < iRow)
{
sN_EMP_MAIL = DataTypeUtility.GetValue(rDs.Tables[0].Rows[i + 1]["EMP_EMAIL"]);
}
break;
}
}
return(blnRtn);
}
protected void ibnAddEstData_Click(object sender, ImageClickEventArgs e)
{
int cnt = UltraWebGrid1.Rows.Count;
string dept_ref_id_list = string.Empty;
for (int i = 0; i < cnt; i++)
{
UltraGridRow row = UltraWebGrid1.Rows[i];
TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox");
if (cBox.Checked)
{
dept_ref_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("DEPT_REF_ID").Value);
}
}
if (dept_ref_id_list.Length > 0)
{
dept_ref_id_list = dept_ref_id_list.Remove(0, 1);
}
else
{
dept_ref_id_list = "-1";
}
DataTable dtEmp = DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, string.Format(" TGT_DEPT_ID IN ({0}) AND DIRECTION_TYPE = '{1}' ", dept_ref_id_list, ConDIRECTION_TYPE));
DataTable dtDel = DataTypeUtility.GetGroupByDataTable(dtEmp.Copy(), new string[] { "TGT_EMP_ID" });
MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data();
string okMsg = bizEstData.AddData(dtDel
, dtEmp
, COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ConESTTERM_STEP_ID
, ConDIRECTION_TYPE
, "N"
, DateTime.Now
, DateTime.Now
, this.gUserInfo.Emp_Ref_ID);
if (okMsg.Length == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("정상 처리 되었습니다.", false);
DoBinding_Dept();
DEPT_REF_ID = -1;
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(okMsg);
}
}
public bool SaveDeptPosScaleAll(DataTable dtDept, DataTable dtScaleData)
{
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
if (dtScaleData.Rows.Count > 0)
{
foreach (DataRow dataRowDept in dtDept.Rows)
{
affectedRow += _deptPosScale.Delete(conn
, trx
, DataTypeUtility.GetToInt32(dtScaleData.Rows[0]["COMP_ID"])
, DataTypeUtility.GetToInt32(dtScaleData.Rows[0]["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRowDept["DEPT_REF_ID"])
, DataTypeUtility.GetValue(dtScaleData.Rows[0]["EST_ID"])
, 0);
}
}
foreach (DataRow dataRowDept in dtDept.Rows)
{
foreach (DataRow dataRowScaleData in dtScaleData.Rows)
{
affectedRow = _deptPosScale.Insert(conn
, trx
, DataTypeUtility.GetToInt32(dataRowScaleData["COMP_ID"])
, DataTypeUtility.GetToInt32(dataRowScaleData["ESTTERM_REF_ID"])
, DataTypeUtility.GetToInt32(dataRowDept["DEPT_REF_ID"])
, DataTypeUtility.GetValue(dataRowScaleData["EST_ID"])
, DataTypeUtility.GetToInt32(dataRowScaleData["SEQ"])
, DataTypeUtility.GetValue(dataRowScaleData["POS_ID"])
, DataTypeUtility.GetValue(dataRowScaleData["POS_VALUE"])
, DataTypeUtility.GetValue(dataRowScaleData["SCALE_ID"])
, DataTypeUtility.GetToDateTime(dataRowScaleData["DATE"])
, DataTypeUtility.GetToInt32(dataRowScaleData["USER"]));
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
DataRowView drw = (DataRowView)e.Data;
if (drw["IS_EST"].ToString().Equals("N"))
{
e.Row.Style.BackColor = Color.FromName("#FFF0F0");
}
if (drw["IS_EST"].ToString().Equals("T"))
{
e.Row.Style.BackColor = Color.FromName("#EBEBEB");
}
if (_eOwnerType == OwnerType.Dept)
{
if (DataTypeUtility.GetToDouble(drw["B_POINT"]) > 0)
{
e.Row.Cells.FromKey("B_POINT").Style.Font.Bold = true;
e.Row.Cells.FromKey("B_POINT").Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand;
}
if (DataTypeUtility.GetToDouble(drw["A_POINT"]) > 0)
{
e.Row.Cells.FromKey("A_POINT").Style.Font.Bold = true;
e.Row.Cells.FromKey("A_POINT").Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand;
}
if (!DataTypeUtility.GetValue(drw["B_GRADE"]).Equals("-"))
{
e.Row.Cells.FromKey("B_GRADE").Style.Font.Bold = true;
e.Row.Cells.FromKey("B_GRADE").Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand;
}
if (!DataTypeUtility.GetValue(drw["A_GRADE"]).Equals("-"))
{
e.Row.Cells.FromKey("A_GRADE").Style.Font.Bold = true;
e.Row.Cells.FromKey("A_GRADE").Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand;
}
}
else if (_eOwnerType == OwnerType.Emp_User)
{
foreach (DataRow drGrade in DT_GRADE.Rows)
{
if (DataTypeUtility.GetToInt32(drw["B_" + drGrade["GRADE_ID"].ToString()]) > 0)
{
e.Row.Cells.FromKey("B_" + drGrade["GRADE_ID"].ToString()).Style.Font.Bold = true;
e.Row.Cells.FromKey("B_" + drGrade["GRADE_ID"].ToString()).Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand;
}
if (DataTypeUtility.GetToInt32(drw["A_" + drGrade["GRADE_ID"].ToString()]) > 0)
{
e.Row.Cells.FromKey("A_" + drGrade["GRADE_ID"].ToString()).Style.Font.Bold = true;
e.Row.Cells.FromKey("A_" + drGrade["GRADE_ID"].ToString()).Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand;
}
}
}
}
protected void ugrdResultStatus_InitializeRow(object sender, RowEventArgs e)
{
DataRowView dr = (DataRowView)e.Data;
UltraGridCell cell;
cell = e.Row.Cells.FromKey("THRESHOLD_IMG");
string img = "../images/stg/" + cell.Value.ToString();
e.Row.Cells.FromKey("THRESHOLD_IMG").Text = string.Format("<img alt='' src='{0}'/>", img);
if (dr["CHECK_YN"].ToString() == "N")
{
e.Row.Cells.FromKey("CHECK_YN").Text = string.Format("<div class='stext'><img src='../images/icon_x.gif'></div>");
}
else
{
e.Row.Cells.FromKey("CHECK_YN").Text = string.Format("<div class='stext'><img src='../images/icon_o.gif'></div>");
}
string strTrend = e.Row.Cells.FromKey("TREND").Value.ToString();
switch (strTrend)
{
case "UP":
e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_e_up.gif'>";;
break;
case "DOWN":
e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_b_down.gif'>";;
break;
case "FLAT":
e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_m.gif'>";;
break;
default:
break;
}
_iTRow += 1;
lblRowCount.Text = _iTRow.ToString();
string kpi_ref_id = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_REF_ID").Value);
string kpi_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_NAME").Value);
string url = "<a href=\"javascript:gfOpenWindow('../BSC/BSC0304P1.aspx?iType=POP&ESTTERM_REF_ID={0}&KPI_REF_ID={1}&YMD={2}',800,600,'no','no');\" style=\"color:Navy;\">{3}</a>";
e.Row.Cells.FromKey("KPI_NAME").Text = string.Format(url
, Estterm_Ref_ID
, kpi_ref_id
, Ymd
, kpi_name);
}
protected void ugrdKPIPoolTemplete_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
if (e.SelectedRows.Count > 0)
{
txtKpiPoolTempleteID.Text = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("KPI_POOL_TEMPLETE_ID").Value);
MODE = "U";
}
}
protected void Page_Load(object sender, EventArgs e)
{
ugrdResultStatus.DisplayLayout.Bands[0].Columns.FromKey("CHAMPION_EMP_NAME").Header.Caption = this.GetText("LBL_00001", "KPI담당자");
ltrScript.Text = "?";
if (!Page.IsPostBack)
{
WebCommon.SetEstTermDropDownList(ddlEstTermInfo);
WebCommon.SetTermMonthDropDownList(ddlMonthInfo, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo));
WebCommon.SetSumTypeDropDownList(ddlSumType, false);
WebCommon.SetSignalDropDownList(ddlSignal, true);
SetPageData();
if (Request["ESTTERM_REF_ID"] != null)
{
Estterm_Ref_ID = GetRequestByInt("ESTTERM_REF_ID");
Est_Dept_Ref_ID = GetRequestByInt("EST_DEPT_REF_ID");
hdfDeptID.Value = Est_Dept_Ref_ID.ToString();
Ymd = GetRequest("YMD");
PageUtility.FindByValueDropDownList(ddlEstTermInfo, Est_Dept_Ref_ID);
PageUtility.FindByValueDropDownList(ddlMonthInfo, Ymd);
//처음로그인시 사용자 부서로 초기 세팅
Est_Dept_Ref_ID = int.Parse(DataTypeUtility.GetValue(gUserInfo.Dept_Ref_ID));
hdfDeptID.Value = Est_Dept_Ref_ID.ToString();
}
else
{
Estterm_Ref_ID = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo);
}
this.IisAdmin = (User.IsInRole(ROLE_ADMIN) ? "Y" : "N");
if (this.IisAdmin == "Y")
{
//WebCommon.SetComDeptDropDownList(ddlDeptList, true, gUserInfo.Emp_Ref_ID);
//PageUtility.FindByValueDropDownList(ddlDeptList, this.IDEPT_ID);
Est_Dept_Ref_ID = int.Parse(DataTypeUtility.GetValue(gUserInfo.Dept_Ref_ID));
WebCommon.SetComDeptDropDownList(ddlDeptList, false, gUserInfo.Emp_Ref_ID);
PageUtility.FindByValueDropDownList(ddlDeptList, Est_Dept_Ref_ID);
}
else
{
BindDeptList();
}
Est_Dept_Ref_ID = int.Parse(DataTypeUtility.GetValue(gUserInfo.Dept_Ref_ID));
SetPageData();
SetResultGrid();
//WebCommon.FillEstTree(trvEstDept, Estterm_Ref_ID, gUserInfo.Emp_Ref_ID);
//SetResultGrid();
}
}
protected void UltraWebGrid5_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
string EMP_NAME = DataTypeUtility.GetValue(e.Row.Cells.FromKey("EMP_NAME").Value);
string EMP_REF_ID = DataTypeUtility.GetValue(e.Row.Cells.FromKey("EMP_REF_ID").Value);
string url = "<a href=\"javascript:setOpenerLocation('../BSC/BSC1004S1.ASPX?{1}');\" style=\"color:Navy;\">{0}</a>";
string link = string.Format(url, EMP_NAME, "&EMP_REF_ID=" + EMP_REF_ID);
e.Row.Cells.FromKey("EMP_NAME").Text = link;
}
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
if (e.SelectedRows.Count > 0)
{
int kpi_ref_id = DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("KPI_REF_ID").Value);
string kpi_name = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("KPI_NAME").Value);
DoCharting(kpi_ref_id, kpi_name);
}
}
protected void ugrdKpiResultList_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("APP_STATUS");
System.Web.UI.WebControls.Image objImg = (System.Web.UI.WebControls.Image)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("imgApp");
string strImg = DataTypeUtility.GetValue(e.Row.Cells.FromKey("APP_STATUS").Value);
objImg.ImageUrl = Biz_Com_Approval_Info.GetAppImageUrl(strImg);
objImg.AlternateText = Biz_Com_Approval_Info.GetAppImageText(strImg);
}
protected void ibnEmp_Click(object sender, ImageClickEventArgs e)
{
int cnt = UltraWebGrid2.Rows.Count;
string emp_ref_id_list = string.Empty;
for (int i = 0; i < cnt; i++)
{
UltraGridRow row = UltraWebGrid2.Rows[i];
TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox");
if (cBox.Checked)
{
emp_ref_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("EMP_REF_ID").Value);
}
}
DataTable dtEmp = new DataTable();
if (emp_ref_id_list.Length > 0)
{
emp_ref_id_list = emp_ref_id_list.Remove(0, 1);
dtEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" EMP_REF_ID IN ({0}) ", emp_ref_id_list));
}
DataTable dtDelEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID IN ({0}) ", DEPT_REF_ID));
MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp BizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp();
string okMsg = BizMulEstEmp.AddEstEmp(dtDelEmp
, dtEmp
, COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, rdoEstTypeList.SelectedValue
, DateTime.Now
, this.gUserInfo.Emp_Ref_ID);
if (okMsg.Length == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("정상 처리 되었습니다.", false);
DoBinding_Dept();
DEPT_REF_ID = -1;
UltraWebGrid2.Clear();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(okMsg);
}
}
protected void ugrdInPower_SelectedRowsChange(object sender, Infragistics.WebUI.UltraWebGrid.SelectedRowsEventArgs e)
{
if (e.SelectedRows.Count > 0)
{
string cr_year = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("CR_YEAR").Value);
string cr_month = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("CR_MONTH").Value);
string project_name = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("PROJECT_NAME").Value);
DoBinding_Emp(cr_year, cr_month, project_name);
}
}
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
TEMPLETE_ID = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_POOL_TEMPLETE_ID").Value);
TEMPLETE_NAME = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_POOL_TEMPLETE_NAME").Value);
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool_Templete_Map bizBscKpiPoolTempleteMap = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool_Templete_Map();
DataTable dtBscKpiPoolTempleteMap = bizBscKpiPoolTempleteMap.GetBscKpiPoolTempleteMap_DB(TEMPLETE_ID);
e.Row.Cells.FromKey("KPI_CNT").Value = dtBscKpiPoolTempleteMap.Rows.Count;
}
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;
}
private string GetPageName(int m_id, int s_id)
{
Dac_EISDatas obj = new Dac_EISDatas();
DataTable dt = obj.GetEISSub(m_id, s_id);
if (dt.Rows.Count > 0)
{
return(DataTypeUtility.GetValue(dt.Rows[0]["PAGE_NAME"]));
}
return("");
}
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
if (e.SelectedRows.Count > 0)
{
string dept_name = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("DEPT_NAME").Value);
lblTitleDept.Text = string.Format("({0})", dept_name);
DEPT_REF_ID = DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("DEPT_REF_ID").Value);
DoBinding_Emp(DEPT_REF_ID);
}
}
protected void UltraWebGrid3_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
string ESTTERM_REF_ID = DataTypeUtility.GetValue(e.Row.Cells.FromKey("ESTTERM_REF_ID").Value);
string YMD = DataTypeUtility.GetValue(e.Row.Cells.FromKey("YMD").Value);
string EST_DEPT_REF_ID = DataTypeUtility.GetValue(e.Row.Cells.FromKey("EST_DEPT_REF_ID").Value);
string DEPT_NAME = DataTypeUtility.GetValue(e.Row.Cells.FromKey("DEPT_NAME").Value);
string url = "<a href='../BSC/BSC0404S1.ASPX?{1}{2}{3}'>{0}</a>";
string link = string.Format(url, DEPT_NAME, "&ESTTERM_REF_ID=" + ESTTERM_REF_ID, "&YMD=" + YMD, "&EST_DEPT_REF_ID=" + EST_DEPT_REF_ID);
e.Row.Cells.FromKey("DEPT_NAME").Text = link;
}
