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();
}
protected void ibnCalcEmpEstPoint_Click(object sender, EventArgs e)
{
if (DT_ENDED_PRJ == null)
{
string est_id = "3Q";
MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
DT_ENDED_PRJ = bizPrjData.Get_Ended_Prj_Est(COMP_ID, est_id, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID);
}
DT_FINAL_POINT = new DataTable();
DT_FINAL_POINT.Columns.Add("TGT_DEPT_ID");
DT_FINAL_POINT.Columns.Add("TGT_EMP_ID");
DT_FINAL_POINT.Columns.Add("TGT_POS_CLS_ID");
DT_FINAL_POINT.Columns.Add("TGT_POS_CLS_NAME");
DT_FINAL_POINT.Columns.Add("TGT_POS_DUT_ID");
DT_FINAL_POINT.Columns.Add("TGT_POS_DUT_NAME");
DT_FINAL_POINT.Columns.Add("TGT_POS_GRP_ID");
DT_FINAL_POINT.Columns.Add("TGT_POS_GRP_NAME");
DT_FINAL_POINT.Columns.Add("TGT_POS_RNK_ID");
DT_FINAL_POINT.Columns.Add("TGT_POS_RNK_NAME");
DT_FINAL_POINT.Columns.Add("TGT_POS_KND_ID");
DT_FINAL_POINT.Columns.Add("TGT_POS_KND_NAME");
DT_FINAL_POINT.Columns.Add("POINT_ORG");
DT_FINAL_POINT.Columns.Add("POINT");
Calculate_Emp_Prj_Point();
}
protected void Page_Load(object sender, EventArgs e)
{
bizPmsColInfo = new Biz_Pms_Col_Info();
bizPrjData = new Biz_Prj_Data();
PRJ_REF_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("PRJ_REF_ID"));
PRJ_CODE = WebUtility.GetRequest("PRJ_CODE");
COMP_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("COMP_ID"));
EST_ID = WebUtility.GetRequest("EST_ID");
ESTTERM_REF_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("ESTTERM_REF_ID"));
ESTTERM_SUB_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("ESTTERM_SUB_ID"));
ESTTERM_STEP_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("ESTTERM_STEP_ID"));
EST_DEPT_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("EST_DEPT_ID"));
EST_EMP_ID = DataTypeUtility.GetToInt32(WebUtility.GetRequest("EST_EMP_ID"));
ltrScript.Text = "";
if (!IsPostBack && PRJ_REF_ID > 0 && PRJ_CODE.Length > 0)
{
Weight_Col_Bind();
Difficulty_Col_Bind();
Common_Soosik_Bind();
Prj_Est_Point_Bind();
SetBottons();
}
Prj_Data_Bind();
}
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 ibnConfirm_Click(object sender, ImageClickEventArgs e)
{
//bool isJobOK = EstJobUtility.SetConfirmButtonVisible(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , EST_JOB_ID
// , ibnConfirm
// , ibnConfirmCancel
// , "Y"
// , DateTime.Now
// , EMP_REF_ID
// , ltrScript);
//// 만약 이전에 처리하지 않은 작업이 있다면 아래의 내용을 처리하지 못함
//if (!isJobOK)
// return;
Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap();
DataTable dataTable = objPrjEmpEstPrjMap.GetPrjEmpEstPrjMap(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, 0
, 0
, 0).Tables[0];
dataTable.Columns.Add("DATE", typeof(DateTime));
dataTable.Columns.Add("USER", typeof(int));
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
Biz_Prj_Data objPrjData = new Biz_Prj_Data();
bool isOK = objPrjData.CopyTgtMapDataToEstData(dataTable);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 평가자/사업관리 매핑정보를 평가리스트로 설정 및 확정하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("설정 중 오류가 발생하였습니다.");
}
}
protected void doBind_project()
{
UltraWebGrid1.Clear();
UltraWebGrid2.Clear();
string est_id = "3Q";
MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
DT_ENDED_PRJ = bizPrjData.Get_Ended_Prj_Est(COMP_ID, est_id, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID);
this.lblRowCount.Text = DT_ENDED_PRJ.Rows.Count.ToString();
UltraWebGrid1.DataSource = DT_ENDED_PRJ;
UltraWebGrid1.DataBind();
}
private void SaveQuestionData_TGT_ID()
{
Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData();
Biz_Prj_Data datas = new Biz_Prj_Data();
DataTable dtQData = questionDatas.GetDataTableSchema();
dtQData = GetQuestionDataTable(dtQData, DataList1);
dtQData = GetQuestionSubDataTable(dtQData, DataList2);
DataTable dtPrjData = AddNewPrjDataRow(datas.GetDataTableSchema(), dtQData);
bool isSuccessed = questionDatas.SaveQuestionData_TGT_ID(dtQData, dtPrjData);
if (!isSuccessed)
{
ltrScript.Text = JSHelper.GetAlertScript("데이터 저장 중 실패하였습니다.", false);
return;
}
ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript("정상적으로 저장되었습니다.", "lbnReload", true);
}
protected void Page_Load(object sender, EventArgs e)
{
bizPrjInfo = new Biz_Prj_Info();
bizPrjData = new Biz_Prj_Data();
if (!IsPostBack)
{
DropDownListCommom.BindComp(ddlCompID, lblCompTitle);
DropDownListCommom.BindEstTerm(ddlEstTermRefID);
DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID, WebUtility.GetIntByValueDropDownList(ddlCompID), "N");
}
COMP_ID = WebUtility.GetIntByValueDropDownList(ddlCompID);
ESTTERM_REF_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermRefID);
ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
ESTTERM_STEP_ID = 2;
EST_ID = "3P"; //프로젝트 평가
DIRECTION_TYPE = "DN"; //하향식평가
STATUS_ID = "E"; //점수 산정 완료
ltrScript.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
quizWeight = new DataTable();
}
COMP_ID = WebUtility.GetRequestByInt("COMP_ID");
EST_ID = WebUtility.GetRequest("EST_ID");
ESTTERM_REF_ID = WebUtility.GetRequestByInt("ESTTERM_REF_ID");
ESTTERM_SUB_ID = WebUtility.GetRequestByInt("ESTTERM_SUB_ID");
ESTTERM_STEP_ID = WebUtility.GetRequestByInt("ESTTERM_STEP_ID");
EST_DEPT_ID = WebUtility.GetRequestByInt("EST_DEPT_ID");
EST_EMP_ID = WebUtility.GetRequestByInt("EST_EMP_ID");
PRJ_REF_ID = WebUtility.GetRequestByInt("PRJ_REF_ID");
EST_TGT_TYPE = WebUtility.GetRequest("EST_TGT_TYPE", "EST");
TGT_DEPT_ID = WebUtility.GetRequestByInt("TGT_DEPT_ID", 0);
TGT_EMP_ID = WebUtility.GetRequestByInt("TGT_EMP_ID", 0);
READ_ONLY_YN = WebUtility.GetRequest("READ_ONLY_YN", "N");
_estInfos = new Biz_EstInfos(COMP_ID, EST_ID);
_q_item_desc_use_yn = _estInfos.Q_Item_Desc_Use_YN;
//PRJ_TYPE
Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(PRJ_REF_ID);
PRJ_TYPE = objPrjInfo.IPrj_Type;
if (READ_ONLY_YN.Equals("N"))
{
Biz_TermInfos termInfos = new Biz_TermInfos(ESTTERM_REF_ID);
Biz_TermSubs termSubs = new Biz_TermSubs(COMP_ID, ESTTERM_SUB_ID);
Biz_TermSteps termSteps = new Biz_TermSteps(COMP_ID, ESTTERM_STEP_ID);
Biz_EmpInfos estEmpInfos = new Biz_EmpInfos(EST_EMP_ID);
Biz_EmpInfos tgtEmpInfos = new Biz_EmpInfos(TGT_EMP_ID);
//Biz_DeptInfos estDeptInfo = new Biz_DeptInfos(EST_DEPT_ID);
MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info bizComDeptInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info(EST_DEPT_ID);
MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info tgtDeptInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info(TGT_DEPT_ID);
//Biz_Prj_Data data = new Biz_Prj_Data(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , EST_DEPT_ID
// , EST_EMP_ID
// , PRJ_REF_ID);
_status_style_id = _estInfos.Status_Style_ID;
Biz_Prj_QuestionPrjMap objQuestionPrjMap = new Biz_Prj_QuestionPrjMap(COMP_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, 0
, EST_ID
, ""
, PRJ_REF_ID);
if (objQuestionPrjMap.Q_Obj_ID == null)
{
ltrScript.Text = JSHelper.GetAlertScript("프로젝트사업명에 대한 평가질의서가 매핑되지 않았습니다.", true);
return;
}
// 창을 띄은 사람이 평가자 인지 체크
if (EST_EMP_ID == EMP_REF_ID)
{
_status_id = "P";
ibnSaveEst.Visible = true;
}
//else
//{
// ibnSaveEst.Visible = false;
// // 롤에 따른 버튼 권한이 있는지 확인
// //BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, ibnSaveEst);
//}
Q_OBJ_ID = objQuestionPrjMap.Q_Obj_ID;
EST_NAME = _estInfos.Est_Name;
ESTTERM_REF_NAME = termInfos.EstTerm_Name;
ESTTERM_SUB_NAME = termSubs.EstTerm_Sub_Name;
ESTTERM_STEP_NAME = termSteps.EstTerm_Step_Name;
EST_EMP_NAME = estEmpInfos.Emp_Name;
EST_DEPT_NAME = bizComDeptInfo.DEPT_NAME; //estDeptInfo.Dept_Name;
TGT_EMP_NAME = tgtEmpInfos.Emp_Name;
TGT_DEPT_NAME = tgtDeptInfo.DEPT_NAME; //tgtDeptInfo.Dept_Name;
PRJ_NAME = objPrjInfo.IPrj_Name;
PRJ_CODE = objPrjInfo.IPrj_Code;
}
else
{
Q_OBJ_ID = WebUtility.GetRequest("Q_OBJ_ID");
ibnSaveEst.Visible = false;
}
if (!Page.IsPostBack)
{
SetLabelText();
//임의수정
Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
DataTable dt = bizPrjData.GetPrjData(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, PRJ_REF_ID, "", "").Tables[0];
string Status_ID = "";
if (dt != null && dt.Rows.Count > 0)
{
Status_ID = dt.Rows[0]["STATUS_ID"].ToString();
}
if (Status_ID.Equals("E"))
{
ibnSaveEst.Visible = false;
}
DataListBinding(dt);
ibnSaveEst.Attributes.Add("onclick", "if(confirm('평가내용을 저장하시겠습니까?')) return ConfirmQuesiton();else return false;");
}
ltrScript.Text = "";
}
/// <summary>
/// 그리드 바인딩 메소드
/// </summary>
/// <param name="comp_id"></param>
/// <param name="est_id"></param>
/// <param name="estterm_ref_id"></param>
/// <param name="estterm_sub_id"></param>
/// <param name="estterm_step_id"></param>
private void GridBidingData(int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int estterm_step_id
, int est_emp_id
, bool isAll)
{
Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id);
if (!estInfo.IsExists(comp_id, est_id))
{
ltrScript.Text = JSHelper.GetAlertScript("선택된 회사의 평가정보가 없습니다.");
return;
}
DropDownListCommom.BindEstTermSub(ddlEstTermSubID, comp_id, est_id, "");
DropDownListCommom.BindEstTermStep(ddlEstTermStepID, comp_id, est_id);
// 처음 실행될때
if (estterm_sub_id.Equals(0))
{
ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
}
// 만약 주기가 년간일 경우
if (YEAR_YN.Equals("Y"))
{
ESTTERM_SUB_ID = BizUtility.GetEstTermSubIDByYearYN(COMP_ID);
}
// 만약 차수가 합산일 경우
if (MERGE_YN.Equals("Y"))
{
ESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID);
}
else
{
// 만약 모든 차수를 보여 줘야하는 경우
if (ESTTERM_STEP_ALL_USE_YN.Equals("Y"))
{
ESTTERM_STEP_ID = 0;
ddlEstTermStepID.Visible = false;
}
}
WebUtility.FindByValueDropDownList(ddlEstTermRefID, estterm_ref_id);
if (ddlEstTermSubID.Visible)
{
WebUtility.FindByValueDropDownList(ddlEstTermSubID, estterm_sub_id);
}
if (ddlEstTermStepID.Visible)
{
WebUtility.FindByValueDropDownList(ddlEstTermStepID, estterm_step_id);
}
// 상태 html
HtmlScriptCommon.CreateStatusHtmlTable(tblViewStatus, est_id);
Biz_Prj_Data objPrjData = new Biz_Prj_Data();
if (isAll)
{
est_emp_id = 0;
}
DataTable dt = objPrjData.GetPrjData(comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, estterm_step_id
, 0
, est_emp_id
, 0
, YEAR_YN
, MERGE_YN).Tables[0];
UltraWebGrid1.Clear();
UltraWebGrid1.DataSource = dt;
UltraWebGrid1.DataBind();
lblRowCount.Text = dt.Rows.Count.ToString();
}
protected void ibnProjectToEmpData_Click(object sender, ImageClickEventArgs e)
{
ImageButton ibn = ((ImageButton)sender);
string est_job_id = ibn.CommandArgument;
//bool isJobOK = EstJobUtility.SetConfirmButtonVisible(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , est_job_id
// ibnDownExcel , ibn
// , null
// , "Y"
// , DateTime.Now
// , EMP_REF_ID
// , ltrScript);
//if (!isJobOK)
// return;
Biz_Prj_Data data = new Biz_Prj_Data();
bool isOK = data.CopyProjectToEmpData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, YEAR_YN
, MERGE_YN
, DateTime.Now
, EMP_REF_ID);
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
{
//EstJobUtility.SetConfirmButtonVisible(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , est_job_id
// , ibn
// , null
// , "N"
// , DateTime.Now
// , EMP_REF_ID
// , ltrScript);
ltrScript.Text = JSHelper.GetAlertScript("프로젝트 평가 정보를 사원 평가 정보로 변환 중 오류가 발생하였습니다.");
}
}
protected void ibnAggEstTermStep_Click(object sender, ImageClickEventArgs e)
{
ImageButton ibn = ((ImageButton)sender);
string est_job_id = ibn.CommandArgument;
bool isJobOK = EstJobUtility.SetConfirmButtonVisible(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, est_job_id
, ibnAggEstTermStep
, null
, "Y"
, DateTime.Now
, EMP_REF_ID
, ltrScript);
if (!isJobOK)
{
return;
}
Biz_Prj_Data objPrjData = new Biz_Prj_Data();
DataTable dtStatusCheck = objPrjData.GetDataByMergeYN(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, MERGE_YN).Tables[0];
if (dtStatusCheck.Rows.Count != dtStatusCheck.Select("STATUS_ID = 'E'").Length)
{
ltrScript.Text = JSHelper.GetAlertScript("확정되지 않은 평가정보가 있습니다. 모두 확정된 상태에서 차수별 합산이 가능합니다.");
return;
}
//, BizUtility.GetTotalWeightEstTermStep(COMP_ID, EST_ID)
// MERGE_YN 이 N 인 이유는 N인 것만 데이터를 수집해서 집계하기 때문
bool isOK = objPrjData.AggregateEstTermStepEstData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, BizUtility.GetTotalWeightEstTermStep(COMP_ID, EST_ID)
, YEAR_YN
, "N");
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
{
//EstJobUtility.SetConfirmButtonVisible(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , est_job_id
// , ibn
// , null
// , "N"
// , DateTime.Now
// , EMP_REF_ID
// , ltrScript);
ltrScript.Text = JSHelper.GetAlertScript("가중치 집계 처리 중 오류가 발생하였습니다.");
}
}