/// <summary>
/// 실적마감율 세팅, 결재할 문서, 커뮤니케이션 문서 존재하는지여부
/// 공지사항 존재여부
/// </summary>
private void SetGlobalStatus()
{
MicroBSC.Estimation.Dac.TermInfos objTermYY = new MicroBSC.Estimation.Dac.TermInfos();
MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail();
int intEstTerm = objTermYY.GetOpenEstTermID();
string sFinishMon = objTerm.GetReleasedMonth();
lblFinishMonth.Text = sFinishMon.Substring(0, 4) + "/" + sFinishMon.Substring(4, 2);
//실적마감율 세팅
Biz_lib_MenuControl biz = new Biz_lib_MenuControl();
lblFinishRate.Text = biz.GetFinishRate(intEstTerm, sFinishMon).ToString();
// 커뮤니케이션 리스트가 있는지?
Biz_Bsc_Communication_User objUser = new Biz_Bsc_Communication_User();
iBtnCommunication.Src = (objUser.GetIsNewListPerUser(this.ILogInUserId)) ? "~/images/NHIT/btn_top_02.gif" : "~/images/NHIT/btn_top_02.gif";//있음:없음
// 결재할 문서가 있는지?
//Biz_Bsc_Kpi_Result objBSC = new Biz_Bsc_Kpi_Result();
//iBtnConfirm.Src = (objBSC.GetIsNewDraftPerUser(intEstTerm, sFinishMon, this.ILogInUserId)) ? "~/images/btn/top_bu_k01_b.gif" : "~/images/btn/top_bu_k01.gif";
Biz_Com_Approval_Prc objBSC = new Biz_Com_Approval_Prc();
DataSet rDs = objBSC.GetToDraftList(this.ILogInUserId, "");
if (rDs.Tables.Count > 0)
{
iBtnConfirm.Src = (rDs.Tables[0].Rows.Count > 0) ? "~/images/NHIT/btn_top_01.gif" : "~/images/NHIT/btn_top_01.gif";//있음:없음
}
else
{
iBtnConfirm.Src = "~/images/NHIT/btn_top_01.gif";
}
// 공지사항이 있는지 또는 읽었는지
Biz_Bsc_Communication_Notice objNot = new Biz_Bsc_Communication_Notice();
this.IisHaveNoticeYN = (objNot.GetCurrentNotice() ? "Y" : "N");
string strCookieKey = "NOTICE_" + objNot.Inotice_ref_id.ToString();
if (Request.Cookies[strCookieKey] != null)
{
DateTime dtCookieDate = Convert.ToDateTime(Server.HtmlEncode(Request.Cookies[strCookieKey].Expires.ToShortTimeString()));
if (dtCookieDate < DateTime.Now)
{
this.IisHaveNoticeYN = "N";
}
}
// 회사 이미지로고 세팅
tblTopMenu.Style.Add(HtmlTextWriterStyle.BackgroundImage, ConfigurationManager.AppSettings["TopMenuLogo.ImageUrl"].ToString());
imgBottomCopy.ImageUrl = ConfigurationManager.AppSettings["BottomPageCopy.ImageUrl"].ToString();
}
/// <summary>
/// 원시점수 확정/취소
/// </summary>
/// <param name="iGubun"></param>
private bool setClosing_Cancel(string iGubun)
{
int intRtn = 0;
MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail();
if (iGubun == "CLOSE")
{
//Response.Write(String.Format("{0}||{1}||{2}||{3}", this.IEstTermRefID
// , this.IYMD
// , txtEtc.Text
// , gUserInfo.Emp_Ref_ID));
//Response.End();
if (objBSC.GetReleasedMonth() != this.IYMD)
{
ltlMsg.Text = JSHelper.GetAlertScript("마감하려는 월은 배포되어있어야 합니다!!!", false);
return(false);
}
intRtn = objBSC.CloseTermMonth
(this.IEstTermRefID
, this.IYMD
, txtEtc.Text
, gUserInfo.Emp_Ref_ID);
string okMsg = objBSC.Transaction_Message;
string okResult = objBSC.Transaction_Result;
intRtn = objBSC.CloseTermMonthForWeight
(this.IEstTermRefID
, this.IYMD);
// 골타겟 관련 입력 버튼 (농협에서 추가)
if (PageUtility.GetAppConfig("GOALTONG_YN").Equals("Y"))
{
intRtn = objBSC.CloseTermMonth_Goal
(this.IEstTermRefID
, this.IYMD
, txtEtc.Text
, gUserInfo.Emp_Ref_ID);
}
ltlMsg.Text = JSHelper.GetAlertScript(objBSC.Transaction_Message, false);
}
else
{
intRtn = objBSC.CancelTermMonth
(this.IEstTermRefID
, this.IYMD
, txtEtc.Text
, gUserInfo.Emp_Ref_ID);
// 골타겟 관련 입력 버튼 (농협에서 추가)
if (PageUtility.GetAppConfig("GOALTONG_YN").Equals("Y"))
{
intRtn = objBSC.CancelTermMonth_GOAL
(this.IEstTermRefID
, this.IYMD
, txtEtc.Text
, gUserInfo.Emp_Ref_ID);
}
ltlMsg.Text = JSHelper.GetAlertScript(objBSC.Transaction_Message, false);
}
if (intRtn > 0)
{
return(true);
}
else
{
return(false);
}
}
private void SetScoreGrid()
{
MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail();
DataSet rDs = objTerm.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo));
DataSet dsTScore = new DataSet();
dsTScore.Tables.Add("TSCORE");
dsTScore.Tables.Add("TSCORE2");
string strMM = "";
this.IcntCol = rDs.Tables[0].Rows.Count;
for (int i = 0; i < this.IcntCol; i++)
{
strMM = rDs.Tables[0].Rows[i]["YMD"].ToString();
dsTScore.Tables[1].Columns.Add("TC_" + strMM + "_01", typeof(string)); // YMD
dsTScore.Tables[1].Columns.Add("TC_" + strMM + "_02", typeof(string)); // EST_DEPT_REF_ID
dsTScore.Tables[1].Columns.Add("TC_" + strMM + "_06", typeof(string)); // EST_YN
dsTScore.Tables[0].Columns.Add("TC_" + strMM + "_03", typeof(string)); // RANK_ID
dsTScore.Tables[0].Columns.Add("TC_" + strMM + "_04", typeof(string)); // DEPT_NAME
dsTScore.Tables[0].Columns.Add("TC_" + strMM + "_05", typeof(string)); // SCORE
}
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet dsRtn = objSC.GetYearlyTotalScoreTrend(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)
, PageUtility.GetIntByValueDropDownList(ddlComTypeInfo)
, PageUtility.GetByValueDropDownList(ddlSumType)
, (hdfDeptID.Value == "") ? 0 : int.Parse(hdfDeptID.Value)
, (chkApplyExtScore.Checked) ? "Y" : "N"
, gUserInfo.Emp_Ref_ID);
int cntRow = dsRtn.Tables[0].Rows.Count; // 조회행수
int cntCol = dsRtn.Tables[0].Columns.Count; // 컬럼수
int intRowIdx = 0; // DataSet Row Index
int intColIdx = 0; // DataSet Col Index
int intRowNum = 0; // Row Num
string strPTmcode = ""; // 이전행 월코드
string strCTmcode = ""; // 현재행 월코드
string strNTmcode = ""; // 다음행 월코드
int iGrpRow = 0;
int iTotRow = 0;
try
{
DataRow drRow = dsTScore.Tables[0].NewRow();
DataRow drRow2 = dsTScore.Tables[1].NewRow();
for (int i = 0; i < cntRow; i++)
{
strPTmcode = (i > 0) ? dsRtn.Tables[0].Rows[i - 1]["YMD"].ToString() : dsRtn.Tables[0].Rows[i]["YMD"].ToString();
strCTmcode = dsRtn.Tables[0].Rows[i]["YMD"].ToString();
strNTmcode = (i >= cntRow - 1) ? dsRtn.Tables[0].Rows[i]["YMD"].ToString() : dsRtn.Tables[0].Rows[i + 1]["YMD"].ToString();
if (strPTmcode != strCTmcode)
{
iGrpRow = 1;
}
else
{
iGrpRow += 1;
}
for (int j = 0; j < cntCol; j++)
{
//if (intRowIdx == 0)
if (iGrpRow > iTotRow)
{
if (j == 0 || j == 1 || j == 5)
{
drRow2[intColIdx + (j == 5 ? 2 : j)] = dsRtn.Tables[0].Rows[i][j];
}
else
{
drRow[intColIdx + j - 2] = dsRtn.Tables[0].Rows[i][j];
}
}
else
{
if (j == 0 || j == 1 || j == 5)
{
dsTScore.Tables[1].Rows[intRowNum][intColIdx + (j == 5 ? 2 : j)] = dsRtn.Tables[0].Rows[i][j];
}
else
{
dsTScore.Tables[0].Rows[intRowNum][intColIdx + j - 2] = dsRtn.Tables[0].Rows[i][j];
}
}
}
//if (intRowIdx == 0)
if (iGrpRow > iTotRow)
{
dsTScore.Tables[0].Rows.Add(drRow);
dsTScore.Tables[1].Rows.Add(drRow2);
drRow = dsTScore.Tables[0].NewRow();
drRow2 = dsTScore.Tables[1].NewRow();
iTotRow += 1;
}
if (strCTmcode != strNTmcode)
{
intRowIdx += 1;
intColIdx += 3;
intRowNum = 0;
}
else
{
intRowNum += 1;
}
}
}
catch (Exception e)
{
ltrScript.Text = JSHelper.GetAlertScript(e.Message, false);
}
ugrdMScore2.DataSource = dsTScore.Tables[1];
ugrdMScore2.DataBind();
ugrdMScore.DataSource = dsTScore.Tables[0];
ugrdMScore.DataBind();
//if (ugrdMScore.Rows.Count > 0)
//{
// ugrdMScore.Visible = true;
// imgNoData.Visible = false;
//}
//else
//{
// ugrdMScore.Visible = false;
// imgNoData.Visible = true;
//}
}
private void InitControlValue()
{
string pathAndQuery = HttpContext.Current.Request.Url.PathAndQuery;
string sUrl = HttpContext.Current.Request.Url.AbsolutePath;
// ERRORINFO.ASPX는 쿼리스트링이 고정되지 않은 페이지 이므로 예외처리한다. (해당페이지 권한시 FULL_PATH로 처리되므로 무한루프일수 있다.)
//if (sUrl.Substring(sUrl.LastIndexOf("/") + 1).ToUpper() != "ERRORINFO.ASPX")
// sUrl = HttpContext.Current.Request.Url.PathAndQuery;
lblEmpName.Text = gUserInfo.Emp_Name;
tblTopMenu.Style.Add(HtmlTextWriterStyle.BackgroundImage, ConfigurationManager.AppSettings["TopMenuLogo.ImageUrl"].ToString());
MicroBSC.Estimation.Dac.TermInfos objTermYY = new MicroBSC.Estimation.Dac.TermInfos();
MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail();
int intEstTerm = objTermYY.GetOpenEstTermID();
string sFinishMon = objTerm.GetReleasedMonth();
#region KPI실적 마감월 셋팅
lblFinishMonth.Text = sFinishMon.Substring(0, 4) + "/" + sFinishMon.Substring(4, 2);
#endregion
#region KPI실적 마감율 셋팅
Biz_lib_MenuControl biz = new Biz_lib_MenuControl();
lblFinishRate.Text = biz.GetFinishRate(intEstTerm, sFinishMon).ToString();
#endregion
#region 커뮤니케이션 리스트가 있는지?
MicroBSC.BSC.Biz.Biz_Bsc_Communication_User objUser = new MicroBSC.BSC.Biz.Biz_Bsc_Communication_User();
iBtnCommunication.Src = (objUser.GetIsNewListPerUser(this.ILogInUserId)) ? "~/images/btn/top_bu_k02_b.gif" : "~/images/btn/top_bu_k02.gif";
// 결재할 문서가 있는지?
//Biz_Bsc_Kpi_Result objBSC = new Biz_Bsc_Kpi_Result();
//iBtnConfirm.Src = (objBSC.GetIsNewDraftPerUser(intEstTerm, sFinishMon, this.ILogInUserId)) ? "~/images/btn/top_bu_k01_b.gif" : "~/images/btn/top_bu_k01.gif";
Biz_Com_Approval_Prc objBSC = new Biz_Com_Approval_Prc();
DataSet rDs = objBSC.GetToDraftList(this.ILogInUserId, "");
if (rDs.Tables.Count > 0)
{
iBtnConfirm.Src = (rDs.Tables[0].Rows.Count > 0) ? "~/images/btn/top_bu_k01_b.gif" : "~/images/btn/top_bu_k01.gif";
}
else
{
iBtnConfirm.Src = "~/images/btn/top_bu_k01.gif";
}
// 공지사항이 있는지 또는 읽었는지
MicroBSC.BSC.Biz.Biz_Bsc_Communication_Notice objNot = new MicroBSC.BSC.Biz.Biz_Bsc_Communication_Notice();
this.IisHaveNoticeYN = (objNot.GetCurrentNotice() ? "Y" : "N");
string strCookieKey = "NOTICE_" + objNot.Inotice_ref_id.ToString();
if (Request.Cookies[strCookieKey] != null)
{
DateTime dtCookieDate = Convert.ToDateTime(Server.HtmlEncode(Request.Cookies[strCookieKey].Expires.ToShortTimeString()));
if (dtCookieDate < DateTime.Now)
{
this.IisHaveNoticeYN = "N";
}
}
#endregion
#region 타이틀 셋팅
if (sUrl.Substring(sUrl.LastIndexOf("/") + 1).ToUpper() != "EST110104.ASPX" &&
sUrl.Substring(sUrl.LastIndexOf("/") + 1).ToUpper() != "EST110104_01.ASPX")
{
lblTitle.Text = biz.GetMenuTitle(pathAndQuery);
}
else
{
lblTitle.Text = biz.GetMenuTitle(sUrl);
}
if (lblTitle.Text.Trim().Equals(""))
{
imgTitle.Visible = false;
}
#endregion
}
private void SetQueryStringData()
{
_empSysInfo = new EmpSysInfos_Biz(gUserInfo.Emp_Ref_ID);
if (GetRequest("ESTTERM_REF_ID").Equals(""))
{
TermInfos term = new TermInfos();
DataView dw = term.GetAllTermInfo().Tables[0].DefaultView;
for (int i = 0; i < dw.Table.Rows.Count; i++)
{
if (Convert.ToInt32(dw.Table.Rows[i]["EST_STATUS"]) == 1)
{
ESTTERM_REF_ID = int.Parse(dw.Table.Rows[i]["ESTTERM_REF_ID"].ToString());
return;
}
}
}
else
{
ESTTERM_REF_ID = GetRequestByInt("ESTTERM_REF_ID");
}
if (GetRequest("EST_DEPT_REF_ID").Equals(""))
{
EST_DEPT_REF_ID = _estDeptInfo.GetRootEstDeptID(ESTTERM_REF_ID);
}
else
{
EST_DEPT_REF_ID = GetRequestByInt("EST_DEPT_REF_ID");
}
MAP_VERSION_ID = GetRequestByInt("MAP_VERSION_ID");
if (GetRequest("TMCODE").Equals(""))
{
MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail();
TMCODE = objTerm.GetReleasedMonth();
}
else
{
TMCODE = GetRequest("TMCODE");
}
string lineType = "";
string showKpiList = "";
if (GetRequest("LINE_TYPE").Equals(""))
{
lineType = _empSysInfo.GetSysValueByEmpID(1000);
}
else
{
lineType = GetRequest("LINE_TYPE");
}
if (GetRequest("SHOW_KPI_LIST").Equals(""))
{
showKpiList = _empSysInfo.GetSysValueByEmpID(1002);
}
else
{
showKpiList = GetRequest("SHOW_KPI_LIST");
}
ENUMLINETYPE = (lineType == "0") ? LineType.Diagonal : LineType.Straight;
ISKPILISTVIEW = (showKpiList == "1") ? true : false;
DRAWING_YN = GetRequest("DRAWING_YN", "N");
if (!IsPostBack)
{
IWORKINGMAP_YN = GetRequest("WORKINGMAPYN", "N");
}
FULLSCREEN = GetRequest("FULLSCREEN", "N");
}
protected void Page_Load(object sender, EventArgs e)
{
//SetPageLayout(phdLayout, "MenuControl_NotLeftMenu.ascx");
ddlEstTermInfo = MenuControl1.DdlEstTermInfo;
ddlMonthInfo = MenuControl1.DdlEstMonth;
lblDeptPath = MenuControl1.LblDeptPath;
ddlEstTermInfo.SelectedIndexChanged += new EventHandler(ddlEstTermInfo_SelectedIndexChanged);
ddlMonthInfo.SelectedIndexChanged += new EventHandler(ddlMonthInfo_SelectedIndexChanged);
if (!Page.IsPostBack)
{
//if (!PageUtility.IsContainSystemAdminUser(EMP_REF_ID))
//{
UltraWebTab1.Tabs.FromKeyTab("GROUP_VIEW").Visible = false;
//}
WebCommon.SetEstTermDropDownList(ddlEstTermInfo);
//WebCommon.SetMonthDropDownList(ddlMonthInfo);
WebCommon.SetTermMonthDropDownList(ddlMonthInfo, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo));
WebCommon.FillEstTree(trvEstDept, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), EMP_REF_ID);
//StrategyMapInfos stgMapInfo = new StrategyMapInfos();
if (Request["ESTTERM_REF_ID"] != null)
{
PageUtility.FindByValueDropDownList(ddlEstTermInfo, GetRequest("ESTTERM_REF_ID"));
//UltraWebTab1.SelectedTabIndex = 2;
}
if (Request["TMCODE"] != null)
{
PageUtility.FindByValueDropDownList(ddlMonthInfo, GetRequest("TMCODE"));
}
else
{
MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail();
PageUtility.FindByValueDropDownList(ddlMonthInfo, objTerm.GetReleasedMonth());
}
if (Request["EST_DEPT_REF_ID"] != null)
{
PageUtility.SelectTreeNode(trvEstDept, GetRequest("EST_DEPT_REF_ID"));
}
else
{
//if (trvEstDept.Nodes.Count > 0)
// trvEstDept.Nodes[0].Select();
int return_est_dept_ref_id = PageUtility.SetTopEstDeptRefID(trvEstDept);
PageUtility.SelectTreeNode(trvEstDept, return_est_dept_ref_id.ToString());
}
ChageTabPage();
ddlEstTermInfo.AutoPostBack = true;
ddlMonthInfo.AutoPostBack = true;
}
lblDeptPath.Text = WebCommon.GetDeptTreePathText(trvEstDept);
ltrScript.Text = "";
this.UltraWebTab1.Tabs.FromKeyTab("CEO_COM").Text = this.GetText("LBL_00004", "Communication");
this.UltraWebTab1.Tabs.FromKeyTab("CEO_COM").Tooltip = this.GetText("LBL_00004", "Communication");
}
private void DoInitControl()
{
WebCommon.SetEstTermDropDownList(ddlEstTerm);
for (int i = 1; i < 13; i++)
{
ddlMonth.Items.Insert(ddlMonth.Items.Count, new ListItem(i.ToString() + "월", i.ToString("00")));
}
ddlSumType.Items.Insert(0, new ListItem("개별", "1"));
ddlSumType.Items.Insert(1, new ListItem("누적", "2"));
MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail objTerm = new MicroBSC.BSC.Biz.Biz_Bsc_Term_Detail();
if (objTerm.GetReleasedMonth().Substring(4, 2) != "00")
{
PageUtility.FindByValueDropDownList(ddlMonth, objTerm.GetReleasedMonth().Substring(4, 2));
}
MicroBSC.BSC.Biz.Biz_Bsc_Interface_Dicode objInterface = new MicroBSC.BSC.Biz.Biz_Bsc_Interface_Dicode();
DataTable dtDiCode = objInterface.GetDiCodeUseYNDailyKpiYN("Y", "Y");
ddlDiCode.DataTextField = "NAME";
ddlDiCode.DataValueField = "DICODE";
ddlDiCode.DataSource = dtDiCode;
ddlDiCode.DataBind();
ddlDiCode.Items.Insert(0, new ListItem("::선택::", ""));
//ddlChart.Items.Add(new ListItem("ThreeLineBreak", "ThreeLineBreak"));
//ddlChart.Items.Add(new ListItem("Stock", "Stock"));
ddlChart.Items.Add(new ListItem("StepLine", "StepLine"));
//ddlChart.Items.Add(new ListItem("StackedColumn100", "StackedColumn100"));
//ddlChart.Items.Add(new ListItem("StackedColumn", "StackedColumn"));
//ddlChart.Items.Add(new ListItem("StackedBar100", "StackedBar100"));
//ddlChart.Items.Add(new ListItem("StackedBar", "StackedBar"));
//ddlChart.Items.Add(new ListItem("StackedArea100", "StackedArea100"));
//ddlChart.Items.Add(new ListItem("StackedArea", "StackedArea"));
//ddlChart.Items.Add(new ListItem("SplineRange", "SplineRange"));
//ddlChart.Items.Add(new ListItem("SplineArea", "SplineArea"));
ddlChart.Items.Add(new ListItem("Spline", "Spline"));
//ddlChart.Items.Add(new ListItem("Renko", "Renko"));
ddlChart.Items.Add(new ListItem("RangeColumn", "RangeColumn"));
//ddlChart.Items.Add(new ListItem("Range", "Range"));
ddlChart.Items.Add(new ListItem("Radar", "Radar"));
//ddlChart.Items.Add(new ListItem("Pyramid", "Pyramid"));
//ddlChart.Items.Add(new ListItem("Polar", "Polar"));
//ddlChart.Items.Add(new ListItem("PointAndFigure", "PointAndFigure"));
ddlChart.Items.Add(new ListItem("Point", "Point"));
//ddlChart.Items.Add(new ListItem("Pie", "Pie"));
ddlChart.Items.Add(new ListItem("Line", "Line"));
//ddlChart.Items.Add(new ListItem("Kagi", "Kagi"));
//ddlChart.Items.Add(new ListItem("Gantt", "Gantt"));
//ddlChart.Items.Add(new ListItem("Funnel", "Funnel"));
ddlChart.Items.Add(new ListItem("FastLine", "FastLine"));
//ddlChart.Items.Add(new ListItem("ErrorBar", "ErrorBar"));
//ddlChart.Items.Add(new ListItem("Doughnut", "Doughnut"));
ddlChart.Items.Add(new ListItem("Column", "Column"));
//ddlChart.Items.Add(new ListItem("CandleStick", "CandleStick"));
ddlChart.Items.Add(new ListItem("Bubble", "Bubble"));
//ddlChart.Items.Add(new ListItem("BoxPlot", "BoxPlot"));
//ddlChart.Items.Add(new ListItem("Bar", "Bar"));
//ddlChart.Items.Add(new ListItem("Area", "Area"));
PageUtility.FindByValueDropDownList(ddlChart, "FastLine");
}