private void BindingTgtEmp(int est_emp_id)
{
Biz_Datas data = new Biz_Datas();
DataTable dataTable = data.GetEstData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, 0
, est_emp_id
, 0
, 0
, YEAR_YN
, MERGE_YN
, OwnerType.Emp_User).Tables[0];
dataTable = DataTypeUtility.GetGroupByDataTable(dataTable
, new string[] { "TGT_EMP_ID", "TGT_EMP_NAME", "TGT_POS_CLS_ID", "TGT_POS_CLS_NAME", "TGT_POS_DUT_ID", "TGT_POS_DUT_NAME", "TGT_POS_GRP_ID", "TGT_POS_GRP_NAME", "TGT_POS_RNK_ID", "TGT_POS_RNK_NAME", "TGT_POS_KND_ID", "TGT_POS_KND_NAME" });
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "", "TGT_EMP_NAME");
UltraWebGrid1.DataSource = dataTable;
UltraWebGrid1.DataBind();
lblRowCount.Text = dataTable.Rows.Count.ToString("#,##0");
}
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();
}
private void DoBinding_Emp(int dept_ref_id)
{
DataTable dtDeptEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID = {0} ", dept_ref_id), " EMP_NAME ");
UltraWebGrid2.DataSource = dtDeptEmp;
UltraWebGrid2.DataBind();
//if (rdoEstTypeList.SelectedIndex.Equals(0))
//{
// MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp bizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp();
//}
//else
//{
//}
if (dtDeptEmp.Rows.Count > 0)
{
ibnEmp.Enabled = true;
}
else
{
ibnEmp.Enabled = false;
}
}
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"];
}
}
private void DoBinding_EST(int est_emp_id)
{
DataTable dtEST = DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, string.Format(" TGT_EMP_ID = {0} ", est_emp_id), " EST_DEPT_NAME, EST_EMP_NAME ");
UltraWebGrid3.DataSource = dtEST;
UltraWebGrid3.DataBind();
}
private void DataBinding()
{
DataTable dt = null;
if (BU.Equals("DD"))
{
dt = DS_DATA.Tables[0];
}
else if (BU.Equals("DO"))
{
dt = DS_DATA.Tables[1];
}
else if (BU.Equals("CJ"))
{
dt = DS_DATA.Tables[2];
}
else
{
return;
}
DataTable dtChart = DataTypeUtility.FilterSortDataTable(dt, "CHART_USE = 'Y'");
DataTable dtGrid = DataTypeUtility.FilterSortDataTable(dt, "GRID_USE = 'Y'");
uGrid.DataSource = dtGrid;
uGrid.DataBind();
BindChart(Chart1
, dtChart
, "계획대비 실적");
}
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);
}
}
private void SetData(int estterm_ref_id, string ymd)
{
Dac_EISDatas objEIS = new Dac_EISDatas();
DT_DATA = objEIS.GetData_M_4_S_1(estterm_ref_id, ymd);
DT_DATA = DataTypeUtility.FilterSortDataTable(DT_DATA, "", "SORT_ORDER");
}
private void GetTermInfos()
{
TermInfos termInfo = new TermInfos();
DataTable dt = termInfo.GetAllList().Tables[0];
dt = DataTypeUtility.FilterSortDataTable(dt, "", "EST_STARTDATE");
UltraWebGrid1.DataSource = dt;
UltraWebGrid1.DataBind();
}
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 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);
}
}
private void SetData(int estterm_ref_id, string ymd)
{
Dac_EISDatas objEIS = new Dac_EISDatas();
//DT_DATA = objEIS.GetData_M_1_S_2(estterm_ref_id, ymd);
DataSet ds = objEIS.GetData_M_0_S_Factory(estterm_ref_id, ymd);
DT_DATA = ds.Tables[0];
DT_DATA = DataTypeUtility.FilterSortDataTable(DT_DATA, "", "SORT_ORDER");
}
private void BindSub(int m_id)
{
Dac_EISDatas obj = new Dac_EISDatas();
DataTable dt = obj.GetEISSub(m_id, 0);
dt = DataTypeUtility.FilterSortDataTable(dt, "", "SORT_ORDER");
ddlSub.DataValueField = "S_ID";
ddlSub.DataTextField = "S_NAME";
ddlSub.DataSource = dt;
ddlSub.DataBind();
}
protected void ibnCancelEstQ_Click(object sender, ImageClickEventArgs e)
{
Biz_Prj_Data objPrjData = new Biz_Prj_Data();
DataTable dataTable = objPrjData.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
, "cBox"
, "selchk"
, new string[] { "EST_DEPT_ID", "EST_EMP_ID", "PRJ_REF_ID", "STATUS_ID" }
, dataTable);
if (dataTable.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("상태가 평가완료가 아니거나 선택된 항목이 없습니다.");
return;
}
else
{
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "STATUS_ID = 'E'");
}
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID;
dataRow["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID;
dataRow["STATUS_ID"] = "P";
}
bool isOK = objPrjData.SaveStatus(dataTable);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 질의평가를 취소하였습니다.");
GridBidingData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EMP_REF_ID
, SEARCH_ALL);
SetConfirmStatusHtml(EST_JOB_IDS);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 취소되지 않았습니다.");
}
}
protected void Prj_Est_Point_Bind()
{
DataTable dt = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID, COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID);
DataTable dtPrjInfo = DataTypeUtility.FilterSortDataTable(dt, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1");
object point = dtPrjInfo.Rows[0]["POINT"];
string Result = Math.Round(DataTypeUtility.GetToDouble(point), 1).ToString();
this.lblPrjEstPoint.Text = Result;
}
protected void ibnSave_Click(object sender, ImageClickEventArgs e)
{
UltraGridRow row;
Biz_DeptOpinionTgtEmps deptOpinionTgtEmp = new Biz_DeptOpinionTgtEmps();
DataTable dataTable = deptOpinionTgtEmp.GetDataTableSchema();
for (int i = 0; i < UltraWebGrid1.Rows.Count; i++)
{
row = UltraWebGrid1.Rows[i];
TemplatedColumn hdf_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP");
HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[row.BandIndex]).FindControl("hdfTgtEmpID");
TemplatedColumn txt_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP");
TextBox txtTgtEmpName = (TextBox)((CellItem)txt_col.CellItems[row.BandIndex]).FindControl("txtTgtEmpName");
if (hdfTgtEmpID.Value.Equals(""))
{
row.Cells.FromKey("TGT_EMP_ID").Value = DBNull.Value;
}
else
{
row.Cells.FromKey("TGT_EMP_ID").Value = DataTypeUtility.GetToDouble(hdfTgtEmpID.Value);
}
}
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid1
, new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" }
, dataTable);
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "TGT_EMP_ID IS NOT NULL");
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["TGT_OPINION_YN"] = "Y";
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = deptOpinionTgtEmp.SaveDeptOpinionTgtEmp(dataTable, COMP_ID, EST_ID);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 의견상신 담당자를 설정하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.");
}
}
protected void Prj_Data_Bind()
{
DataTable DT = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID
, COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID);
uwgrid_TGT_EMP_LIST.Clear();
uwgrid_TGT_EMP_LIST.DataSource = DataTypeUtility.FilterSortDataTable(DT, "TGT_DEPT_ID > -1 AND TGT_EMP_ID > -1");
uwgrid_TGT_EMP_LIST.DataBind();
}
protected void ibnUpdateEmpRole_Click(object sender, ImageClickEventArgs e)
{
UltraGridRow row;
Biz_EmpRoleRels empRoleRel = new Biz_EmpRoleRels();
Biz_DeptOpinionTgtEmps deptOpinionTgtEmp = new Biz_DeptOpinionTgtEmps();
DataTable dataTable = deptOpinionTgtEmp.GetDataTableSchema();
dataTable.Columns.Add("EMP_REF_ID", typeof(int));
dataTable.Columns.Add("ROLE_REF_ID", typeof(int));
for (int i = 0; i < UltraWebGrid1.Rows.Count; i++)
{
row = UltraWebGrid1.Rows[i];
TemplatedColumn hdf_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP");
HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[row.BandIndex]).FindControl("hdfTgtEmpID");
if (hdfTgtEmpID.Value.Equals(""))
{
row.Cells.FromKey("TGT_EMP_ID").Value = DBNull.Value;
}
else
{
row.Cells.FromKey("TGT_EMP_ID").Value = DataTypeUtility.GetToDouble(hdfTgtEmpID.Value);
}
}
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid1
, new string[] { "TGT_EMP_ID" }
, dataTable);
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "TGT_EMP_ID IS NOT NULL");
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["EMP_REF_ID"] = dataRow["TGT_EMP_ID"];
dataRow["ROLE_REF_ID"] = ROLE_REF_ID;
}
bool isOK = empRoleRel.SaveEmpRoleRel(dataTable, ROLE_REF_ID);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 의견상신 담당자 권한을 부여하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("부여된 권한이 없습니다.");
}
}
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);
}
/// <summary>
/// 프로젝트 평가 질의에 매핑되지 않은 프로젝트 목록
/// </summary>
public DataTable Get_Prj_Info_Not_In_Question_Map(int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id)
{
DataTable dt = _data.Select_Prj_Info_Join_Question_Map(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, 0
, "");
return(DataTypeUtility.FilterSortDataTable(dt, "MAP_PRJ_REF_ID IS NULL"));
}
protected void doBindKpiPool()
{
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool();
DataSet ds = objBSC.GetDetailAllList(txtKpiName.Text.Trim()
, ""
, ""
, 0
, 0
, 0
, "");
DataTable dt_filtered = DataTypeUtility.FilterSortDataTable(ds.Tables[0], "KPI_EXTERNAL_TYPE='EXT'");
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = dt_filtered;
UltraWebGrid1.DataBind();
}
private void DataBinding()
{
DataTable dt = null;
if (BU.Equals("DD"))
{
dt = DS_DATA.Tables[0];
}
else if (BU.Equals("DO"))
{
dt = DS_DATA.Tables[1];
}
else if (BU.Equals("CJ"))
{
dt = DS_DATA.Tables[2];
dt = DataTypeUtility.FilterSortDataTable(dt, "", "SORT_ORDER, SORT_ORDER2 DESC");
}
else
{
return;
}
uGrid.DataSource = dt;
uGrid.DataBind();
dt.Columns.Add("TEXT", typeof(string));
foreach (DataRow dr in dt.Rows)
{
dr["TEXT"] = string.Format("{0}({2}%)"
, dr["ALIAS"]
, DataTypeUtility.GetToDouble(dr["RESULT_TS"]).ToString("#,##0.00")
, DataTypeUtility.GetToDouble(dr["RESULT_RATIO"]).ToString("#,##0.00"));
}
BindChart(Chart1
, DataTypeUtility.FilterSortDataTable(dt, "SORT_ORDER2 = 2", "SORT_ORDER")
, "Item별 점유비 - 총매출"
, lbl1);
BindChart(Chart2
, DataTypeUtility.FilterSortDataTable(dt, "SORT_ORDER2 = 1", "SORT_ORDER")
, "Item별 점유비 - 내수매출"
, lbl2);
}
protected void ibnValidCheck_Click(object sender, ImageClickEventArgs e)
{
DataTable dtRelGrpData = GetRelGroupData(COMP_ID, EST_ID, ESTTERM_REF_ID);
DataTable dtValid = null;
if (dtRelGrpData.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("상대그룹에 포함된 사원정보가 없습니다.");
return;
}
dtValid = DataTypeUtility.GetGroupByDataTable(dtRelGrpData
, "TGT_EMP_ID"
, new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" }
, "TGT_EMP_ID");
dtValid = DataTypeUtility.FilterSortDataTable(dtValid, "CNT_TGT_EMP_ID > 1");
int duplicate_emp_id_cnt = dtValid.Rows.Count;
if (duplicate_emp_id_cnt > 0)
{
string temp = "\\r\\n";
foreach (DataRow drRow in dtValid.Rows)
{
DataRow[] drArrTgt = dtRelGrpData.Select(string.Format("TGT_EMP_ID = {0}", drRow["TGT_EMP_ID"]));
foreach (DataRow drRowTgt in drArrTgt)
{
Biz_RelGroupInfos relGroupInfo = new Biz_RelGroupInfos(COMP_ID, DataTypeUtility.GetValue(drRowTgt["REL_GRP_ID"]));
Biz_EmpInfos empInfo = new Biz_EmpInfos(DataTypeUtility.GetToInt32(drRowTgt["TGT_EMP_ID"]));
temp += relGroupInfo.Rel_Grp_Name + " - " + empInfo.Emp_Name + "\\r\\n";
}
}
ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0}명의 사원이 상대그룹에 중복되어 있습니다.{1}", duplicate_emp_id_cnt, temp));
return;
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("상대그룹 설정에 오류가 없습니다.");
return;
}
}
protected bool CheckModifyPossiblity(int dept_ref_id)
{
MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map bizTargetMap = new MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map();
bool allowModify;
//현재 부서의 피평가자 목록 데이터테이블
DataTable c_DT_tgt_emp_id = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" EST_TYPE_TGT = 'TGT' AND DEPT_REF_ID={0}", dept_ref_id));
//현재 부서의 피평가자 목록 스트링
StringBuilder tgt_emp_id_list = new StringBuilder();
for (int i = 0; i < c_DT_tgt_emp_id.Rows.Count; i++)
{
if (tgt_emp_id_list.Length > 0)
{
tgt_emp_id_list.Append(", ");
}
tgt_emp_id_list.Append(c_DT_tgt_emp_id.Rows[i]["EMP_REF_ID"].ToString());
}
if (tgt_emp_id_list.Length == 0)
{
tgt_emp_id_list.Append("''");
}
//현재 부서의 피평가자에 대한 평가자 매핑 정보
DataTable dtConfirmed = DataTypeUtility.FilterSortDataTable(DT_EST_DATA, string.Format("TGT_EMP_ID IN ({0})", tgt_emp_id_list.ToString()));
if (dtConfirmed.Rows.Count > 0)
{
allowModify = false;
}
else
{
allowModify = true;
}
return(allowModify);
}
protected void BindScore()
{
if (DT_SCORE != null && DT_SCORE.Rows.Count > 0)
{
DataTable dt_current_score = DataTypeUtility.FilterSortDataTable(DT_SCORE, string.Format("YMD='{0}'", YMD));
if (dt_current_score.Rows.Count > 0)
{
string score_col_name = "SCORE";
SCORE = DataTypeUtility.GetToDouble(dt_current_score.Rows[0][score_col_name]);
lblScore.Text = Math.Round(SCORE, 1).ToString();
}
else
{
lblScore.Text = "-";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
if (!Page.IsPostBack)
{
if (type == "T")
{
dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().CoporationKpiTempleteList();
this.lblPopUpTitle.Text = "전략템플릿 조직 KPI";
}
else
{
dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().CoporationKpiList();
dt = DataTypeUtility.FilterSortDataTable(dt, "KPI_EXTERNAL_TYPE='INR'");
this.lblPopUpTitle.Text = "조직KPI 풀";
}
ugrdStgList.DataSource = dt;
ugrdStgList.DataBind();
}
}
/* 실적 입력 결재 여부 확인
* protected bool KpiResult_DraftState(string kpi_ref_id)
* {
* bool isAdmin = false;
* bool isTeamManager = false;
* if (User.IsInRole(ROLE_ADMIN))
* isAdmin = true;
* if (User.IsInRole(ROLE_TEAM_MANAGER))
* isTeamManager = true;
*
* MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info();
* DataSet dsResult = objBSC.GetMboListForResultInput(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
* , PageUtility.GetByValueDropDownList(ddlEstTermMonth)
* , ""
* , ""
* , ""
* , PageUtility.GetIntByValueDropDownList(ddlEstDeptRight)
* , PageUtility.GetByValueDropDownList(ddlKpiGroupRefID)
* , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryTop)
* , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryMid)
* , PageUtility.GetIntByValueDropDownList(ddlKpiCategoryLow)
* , gUserInfo.Emp_Ref_ID
* , isAdmin
* , isTeamManager
* , BizUtility.GetDeptID(gUserInfo.Emp_Ref_ID));
*
* return false;
* }
*/
protected DataTable addMonthlyTarget(DataTable srcTbl, DataTable tgtTbl)
{
for (int j = 1; j < 13; j++)
{
tgtTbl.Columns.Add("MONTH" + j.ToString().PadLeft(2, '0'));
}
for (int i = 0; i < tgtTbl.Rows.Count; i++)
{
DataTable dtTmp = DataTypeUtility.FilterSortDataTable(srcTbl, string.Format("KPI_REF_ID='{0}'", DataTypeUtility.GetString(tgtTbl.Rows[i]["KPI_REF_ID"])));
if (dtTmp.Rows.Count > 0)
{
for (int j = 1; j < 13; j++)
{
string thisMonth = "MONTH" + j.ToString().PadLeft(2, '0');
tgtTbl.Rows[i][thisMonth] = dtTmp.Rows[0][thisMonth];
}
}
}
return(tgtTbl);
}
/// <summary>
/// BSC 부서 정보와 기간계 부서정보 비교 리스트
/// </summary>
public DataTable Get_Diff_Dept_IF(GUBUN gubun)
{
Dac_Com_IF dacComIF = new Dac_Com_IF();
DataSet DS = dacComIF.Select_Diff_DeptInfo_IF();
string expression = "";
if (gubun == GUBUN.MATCH)
{
expression = "GUBUN='Y'";
}
else if (gubun == GUBUN.NOTMATCH)
{
expression = "GUBUN='N'";
}
DataTable DT = DataTypeUtility.FilterSortDataTable(DS.Tables[0], expression);
//DT = AddStatusCol(DT, GUBUN2.DEPT);
return(DT);
}
protected void ugrdEstComment_InitializeRow(object sender, RowEventArgs e)
{
string self_top_id = DataTypeUtility.GetString(e.Row.Cells.FromKey("SELF_TOP_ID"));
DataTable dt_question = DataTypeUtility.FilterSortDataTable(DT_EST_SELF_DATA, string.Format("SELF_TOP_ID={0}", self_top_id));
TemplatedColumn tc = (TemplatedColumn)e.Row.Band.Columns.FromKey("EST_COMMENT");
RadioButtonList rdoEstComment = (RadioButtonList)((CellItem)tc.CellItems[e.Row.Index]).FindControl("rdoEstComment");
rdoEstComment.RepeatDirection = RepeatDirection.Horizontal;
rdoEstComment.RepeatLayout = RepeatLayout.Table;
rdoEstComment.Width = Unit.Percentage(99);
rdoEstComment.DataSource = dt_question;
rdoEstComment.DataBind();
DataTable dt_q_selected = DataTypeUtility.FilterSortDataTable(dt_question, string.Format("SELECTED > 0"));
if (dt_q_selected.Rows.Count > 0)
{
WebUtility.FindByValueRadioButtonList(rdoEstComment, DataTypeUtility.GetString(dt_q_selected.Rows[0]["SELF_MID_ID"]));
}
}
private void DoBinding_Emp(int dept_ref_id)
{
string filter = string.Format(" TGT_DEPT_ID = {0} ", dept_ref_id);
string sort = "TGT_EMP_NAME";
string[] groupBy = { "TGT_DEPT_ID"
, "TGT_DEPT_NAME"
, "TGT_EMP_ID"
, "TGT_EMP_NAME"
, "TGT_POS_CLS_ID"
, "TGT_POS_CLS_NAME"
, "TGT_POS_DUT_ID"
, "TGT_POS_DUT_NAME"
, "TGT_POS_GRP_ID"
, "TGT_POS_GRP_NAME"
, "TGT_POS_RNK_ID"
, "TGT_POS_RNK_NAME"
, "TGT_POS_KND_ID"
, "TGT_POS_KND_NAME"
, "DIRECTION_TYPE" };
UltraWebGrid2.Columns[1].BaseColumnName = "TGT_EMP_NAME";
UltraWebGrid2.Columns[2].BaseColumnName = "TGT_POS_KND_NAME";
UltraWebGrid2.Columns[3].BaseColumnName = "TGT_POS_CLS_NAME";
UltraWebGrid2.Columns[4].BaseColumnName = "TGT_POS_DUT_NAME";
UltraWebGrid2.Columns[5].BaseColumnName = "TGT_EMP_ID";
DataTable dtDeptEmp = DataTypeUtility.FilterSortDataTable(DataTypeUtility.GetGroupByDataTable(DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, filter)
, groupBy)
, ""
, sort);
UltraWebGrid2.DataSource = dtDeptEmp;
UltraWebGrid2.DataBind();
}
