public void SetApprovalList()
{
Biz_Com_Approval_Prc objApp = new Biz_Com_Approval_Prc();
string sSDate = base.GetYMDFromDateTime((DateTime)wdcSDate.Value, "-") + " 00:00:00";
string sEDate = base.GetYMDFromDateTime((DateTime)wdcEDate.Value, "-") + " 23:59:59";
DateTime dtSDate = Convert.ToDateTime(sSDate);
DateTime dtEDate = Convert.ToDateTime(sEDate);
DataSet rDs = objApp.GetToDraftList(gUserInfo.Emp_Ref_ID, PageUtility.GetByValueDropDownList(ddlBizType), PageUtility.GetIntByValueDropDownList(ddlComDept), dtSDate, dtEDate);
ugrdAppList.Clear();
ugrdAppPrc.Clear();
if (rDs.Tables.Count > 0)
{
ugrdAppList.DataSource = rDs.Tables[0].DefaultView;
ugrdAppList.DataBind();
lblRowCount.Text = rDs.Tables[0].Rows.Count.ToString();
}
else
{
lblRowCount.Text = "0";
}
}
/// <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();
}
//결제아이콘표시
private bool isResult()
{
// 결재할 문서가 있는지?
//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)
{
if (rDs.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
//tmcode 를 가져옵니다.
// StrategyMapInfos stgMapInfo = new StrategyMapInfos();
// int tmcode = stgMapInfo.GetTMCODE();
// //해당유저의 부서코드를 가져옵니다.
// int dept_id = 0;
// string query = @"
// SELECT CASE A.DEPT_LEVEL WHEN 4 THEN
// (SELECT EST_DEPT_REF_ID
// FROM EST_DEPT_INFO
// WHERE EST_DEPT_REF_ID = A.UP_EST_DEPT_ID)
// ELSE
// A.EST_DEPT_REF_ID
// END AS EST_DEPT_REF_ID
// , UP_EST_DEPT_ID
// FROM
// EST_DEPT_INFO A
// , REL_DEPT_EMP B
// WHERE A.DEPT_REF_ID= B.DEPT_REF_ID
// AND B.EMP_REF_ID=" + gUserInfo.Emp_Ref_ID.ToString() + @"
// ORDER BY A.ESTTERM_REF_ID DESC";
// DataSet ds = gDbAgent.FillDataSet(query, "data0");
// try
// {
// dept_id = int.Parse(ds.Tables[0].Rows[0][0].ToString());
// }
// catch
// {
// dept_id = 0;
// }
// RoleBases rb = new RoleBases();
// string sQuery = "";
// if (Context.User.IsInRole(rb.ROLE_ADMIN))//admin 권한일경우 전부서의 결재를 여부를 가져옴
// {
// sQuery = @"
// SELECT A.RESULT
// FROM KPI_RESULT A
// ,KPI_INFO B
// WHERE A.KPI_REF_ID = B.KPI_REF_ID
// AND A.CHECKSTATUS > 0
// AND A.CONFIRMSTATUS = 0
//-- AND A.TMCODE<=" + tmcode.ToString() + @"";
// }
// else
// {
// sQuery = @"
// SELECT A.RESULT
// FROM KPI_RESULT A
// ,KPI_INFO B
// WHERE A.KPI_REF_ID=B.KPI_REF_ID
//-- AND EST_DEPT_ID=" + dept_id.ToString() + @"
// AND B.CONFIRM_EMP_ID=" + gUserInfo.Emp_Ref_ID + @"
// AND A.CHECKSTATUS>0
// AND A.CONFIRMSTATUS=0
//-- AND A.TMCODE<=" + tmcode.ToString() + @"
// ";
// }
// ds = gDbAgent.FillDataSet(sQuery, "data0");
// if (ds.Tables[0].Rows.Count > 0)//결재할것들이 있는지 여부
// {
// return true;
// }
// else
// {
// return false;
// }
}
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
}