public void SetApprovalList()
{
Biz_Com_Approval_Prc objApp = new Biz_Com_Approval_Prc();
DateTime dtSDate = (DateTime)wdcSDate.Value;
DateTime dtEDate = (DateTime)wdcEDate.Value;
string sSDate = dtSDate.Year.ToString() + "-" + dtSDate.Month.ToString().PadLeft(2, '0') + "-" + dtSDate.Day.ToString().PadLeft(2, '0') + " 00:00:00";
string sEDate = dtEDate.Year.ToString() + "-" + dtEDate.Month.ToString().PadLeft(2, '0') + "-" + dtEDate.Day.ToString().PadLeft(2, '0') + " 23:59:59";
DataSet rDs = objApp.GetCompletedList
(gUserInfo.Emp_Ref_ID
, PageUtility.GetByValueDropDownList(ddlApprovalStatus)
, PageUtility.GetByValueDropDownList(ddlBizType)
, txtTitle.Text
, Convert.ToDateTime(sSDate)
, Convert.ToDateTime(sEDate));
ugrdAppList.Clear();
ugrdAppPrc.Clear();
if (rDs.Tables.Count > 0)
{
ugrdAppList.DataSource = rDs.Tables[0].DefaultView;
ugrdAppList.DataBind();
lblCountRow.Text = "Total Rows : " + rDs.Tables[0].Rows.Count.ToString();
}
else
{
lblCountRow.Text = "Total Rows : 0";
}
}
/// <summary>
/// 반려
/// </summary>
public void SetReturn()
{
if (this.IApp_Ref_Id > 0 && this.IVersion_No > 0 && this.ILine_Step > 0)
{
DataTable dtAppLine = new DataTable("APP_LINE");
dtAppLine.Columns.Add("APP_REF_ID", typeof(decimal));
dtAppLine.Columns.Add("VERSION_NO", typeof(int));
dtAppLine.Columns.Add("LINE_STEP", typeof(int));
dtAppLine.Columns.Add("RETURN_REASON", typeof(string));
dtAppLine.Columns.Add("APP_EMP_ID", typeof(int));
DataRow drAppLine = dtAppLine.NewRow();
drAppLine["APP_REF_ID"] = this.IApp_Ref_Id;
drAppLine["VERSION_NO"] = this.IVersion_No;
drAppLine["LINE_STEP"] = this.ILine_Step;
drAppLine["RETURN_REASON"] = txtRtnReason.Text;
drAppLine["APP_EMP_ID"] = gUserInfo.Emp_Ref_ID;
dtAppLine.Rows.Add(drAppLine);
Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
int iRtn = objPrc.Return(dtAppLine);
ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objPrc.Transaction_Message, this.IAPP_CCB, true);
return;
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript("결재문서정보가 올바르지 않습니다.", false);
}
}
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";
}
}
public void SetAppDetailList()
{
Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
DataSet rDs = objPrc.GetAllList(this.IApp_Ref_Id, this.IVersion_No);
ugrdAppPrc.Clear();
ugrdAppPrc.DataSource = rDs;
ugrdAppPrc.DataBind();
}
/// <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 void RequestModifyDraft()
{
Biz_Com_Approval_Prc objApp = new Biz_Com_Approval_Prc();
bool blnRtn = objApp.RequestModifyDraft(DataTypeUtility.GetToInt32(this.IAPP_REF_ID), EMP_REF_ID);
if (blnRtn)
{
DoBinding();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(objApp.Transaction_Message, false);
}
}
/// <summary>
/// 수정결재요청
/// </summary>
private void RequestModifyDraft()
{
Biz_Com_Approval_Prc objApp = new Biz_Com_Approval_Prc();
bool blnRtn = objApp.RequestModifyDraft(this.IApp_Ref_Id, gUserInfo.Emp_Ref_ID);
if (blnRtn)
{
this.SetDraftInfo();
this.SetButton();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(objApp.Transaction_Message, false);
}
}
/// <summary>
/// 진행중인결재선 조회
/// </summary>
public void SetApprovalLine()
{
Biz_Com_Approval_Prc objApp = new Biz_Com_Approval_Prc();
DataSet rDs = objApp.GetAllList(this.IApp_Ref_Id, this.IVersion_No);
ugrdAppLine.Clear();
if (rDs.Tables.Count > 0)
{
rDs.Tables[0].DefaultView.Sort = "LINE_STEP ASC";
ugrdAppLine.DataSource = rDs.Tables[0].DefaultView;
ugrdAppLine.DataBind();
}
else
{
this.SetDraftLine();
}
}
protected void ibtnDraft_Click(object sender, ImageClickEventArgs e)
{
DataTable dtAppLine = new DataTable("APP_LINE");
dtAppLine.Columns.Add("APP_REF_ID", typeof(decimal));
dtAppLine.Columns.Add("VERSION_NO", typeof(int));
dtAppLine.Columns.Add("LINE_STEP", typeof(int));
dtAppLine.Columns.Add("APP_EMP_ID", typeof(int));
dtAppLine.Columns.Add("COMMENTS", typeof(string));
for (int i = 0; i < ugrdDraft.Rows.Count; i++)
{
if (DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("APP_REF_ID").Value) < 1 ||
DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("VERSION_NO").Value) < 1 ||
DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("LINE_STEP").Value) < 1)
{
this.ltrScript.Text = JSHelper.GetAlertScript("결재문서정보가 올바르지 않습니다.", false);
return;
}
DataRow drAppLine = dtAppLine.NewRow();
drAppLine["APP_REF_ID"] = DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("APP_REF_ID").Value);
drAppLine["VERSION_NO"] = DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("VERSION_NO").Value);
drAppLine["LINE_STEP"] = DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("LINE_STEP").Value);
drAppLine["APP_EMP_ID"] = this.IDraftEmpID;
drAppLine["COMMENTS"] = txtAppOpinion.Text.Trim();
dtAppLine.Rows.Add(drAppLine);
}
Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
int iRtn = objPrc.Approval(dtAppLine);
if (iRtn > 0)
{
SendMailBatch(false);
}
ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objPrc.Transaction_Message, this.ICCB1, true);
return;
}
/// <summary>
/// 승인
/// </summary>
public void SetApproval()
{
if (this.IApp_Ref_Id > 0 && this.IVersion_No > 0 && this.ILine_Step > 0)
{
DataTable dtAppLine = new DataTable("APP_LINE");
dtAppLine.Columns.Add("APP_REF_ID", typeof(decimal));
dtAppLine.Columns.Add("VERSION_NO", typeof(int));
dtAppLine.Columns.Add("LINE_STEP", typeof(int));
dtAppLine.Columns.Add("APP_EMP_ID", typeof(int));
dtAppLine.Columns.Add("COMMENTS", typeof(string));
DataRow drAppLine = dtAppLine.NewRow();
drAppLine["APP_REF_ID"] = this.IApp_Ref_Id;
drAppLine["VERSION_NO"] = this.IVersion_No;
drAppLine["LINE_STEP"] = this.ILine_Step;
drAppLine["APP_EMP_ID"] = this.IDraftEmpID;
drAppLine["COMMENTS"] = txtAppOpinion.Text;
dtAppLine.Rows.Add(drAppLine);
Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
int iRtn = objPrc.Approval(dtAppLine);
if (objPrc.Transaction_Result == "Y")
{
bool bRtn = SendMail(false);
}
ltrScript.Text = JSHelper.GetAlertOpenerControlCallBackScript(objPrc.Transaction_Message, this.IAPP_CCB, true);
return;
}
else
{
this.ltrScript.Text = JSHelper.GetAlertScript("결재문서정보가 올바르지 않습니다.", false);
}
}
public void SetRecallDraft()
{
DataTable dtDraft = new DataTable("RECALL_LIST");
dtDraft.Columns.Add("APP_REF_ID", typeof(int));
dtDraft.Columns.Add("VERSION_NO", typeof(int));
DataRow drDraft = null;
int iRow = ugrdAppList.Rows.Count;
int iCol = ugrdAppList.Columns.Count;
TemplatedColumn cCol = (TemplatedColumn)ugrdAppList.Columns.FromKey("selchk");
CheckBox chkSel = null;
for (int i = 0; i < iRow; i++)
{
chkSel = (CheckBox)((CellItem)cCol.CellItems[ugrdAppList.Rows[i].BandIndex]).FindControl("cBox");
if (chkSel.Checked)
{
drDraft = dtDraft.NewRow();
drDraft["APP_REF_ID"] = int.Parse(ugrdAppList.Rows[i].Cells.FromKey("APP_REF_ID").Value.ToString());
drDraft["VERSION_NO"] = int.Parse(ugrdAppList.Rows[i].Cells.FromKey("VERSION_NO").Value.ToString());
dtDraft.Rows.Add(drDraft);
}
}
if (dtDraft.Rows.Count > 0)
{
Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
int iRtnRow = objPrc.RecallDraft(null, null, dtDraft, gUserInfo.Emp_Ref_ID);
ltrScript.Text = JSHelper.GetAlertScript(objPrc.Transaction_Message, false);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("선택된 문서가 없습니다.", false);
}
}
//결제아이콘표시
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;
// }
}
public void SendMailBatch(bool isReturn)
{
if (PageUtility.GetAppConfig("Mail.UseDraftMailYN") == "N")
{
return;
}
string sC_EMP_MAIL = "";
string sP_EMP_MAIL = "";
string sN_EMP_MAIL = "";
string sFile = "Mail_Draft.htm";
EmpInfos objEmp = new EmpInfos(gUserInfo.Emp_Ref_ID);
Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
for (int i = 0; i < ugrdDraft.Rows.Count; i++)
{
int appid, verno;
string biztype = string.Empty;
if (ugrdDraft.Rows[i].Cells.FromKey("BIZ_TYPE").Value.ToString() == Biz_Type.biz_type_kpi_docbatch)
{
biztype = Biz_Type.biz_type_kpi_doc;
}
else if (ugrdDraft.Rows[i].Cells.FromKey("BIZ_TYPE").Value.ToString() == Biz_Type.biz_type_kpi_rstbatch)
{
biztype = Biz_Type.biz_type_kpi_rst;
}
else if (ugrdDraft.Rows[i].Cells.FromKey("BIZ_TYPE").Value.ToString() == Biz_Type.biz_type_target_resultbatch)
{
biztype = Biz_Type.biz_type_target_result;
}
appid = DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("APP_REF_ID").Value);
verno = DataTypeUtility.GetToInt32(ugrdDraft.Rows[i].Cells.FromKey("VERSION_NO").Value);
bool bRtn = objPrc.GetSendMailUser(appid, verno, gUserInfo.Emp_Ref_ID, out sC_EMP_MAIL, out sP_EMP_MAIL, out sN_EMP_MAIL);
if (!bRtn)
{
return;
}
if (isReturn && (!PageUtility.CheckMailAddress(sC_EMP_MAIL) || !PageUtility.CheckMailAddress(sN_EMP_MAIL)))
{
return;
}
if (!isReturn && (!PageUtility.CheckMailAddress(sC_EMP_MAIL) || !PageUtility.CheckMailAddress(sP_EMP_MAIL)))
{
return;
}
bool rtnValue = false;
DataTable dtMailParam = new DataTable("PARAM");
dtMailParam.Columns.Add("KEY", typeof(string));
dtMailParam.Columns.Add("VAL", typeof(string));
Biz_Com_Approval_Info objMst = new Biz_Com_Approval_Info(appid, verno);
string strVPath = Request.ApplicationPath;
string strSHost = Request.Url.Host;
string strSPort = Request.Url.Port.ToString();
string strProto = Request.Url.Scheme;
strVPath = (strVPath == "/") ? "" : strVPath;
string strFullPath = strProto + "://" + strSHost + ":" + strSPort + strVPath;
DataRow dr = null;
dr = dtMailParam.NewRow();
dr["KEY"] = "[SITE_URL]";
dr["VAL"] = strFullPath;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[BIZ_TYPE]";
dr["VAL"] = Biz_Com_Approval_Info.GetBizTypeName(biztype);
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[APP_CODE]";
dr["VAL"] = objMst.IApp_Code;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TITLE]";
dr["VAL"] = objMst.ITitle;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[EMP_NAME]";
dr["VAL"] = objEmp.Emp_Name;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[DEPT_NAME]";
dr["VAL"] = objEmp.Dept_Name;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TRX_DATE]";
dr["VAL"] = objMst.IUpdate_Date.ToShortDateString();
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TODAY]";
dr["VAL"] = DateTime.Now.ToString();
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[DRAFT_TYPE]";
dr["VAL"] = (isReturn) ? "반려" : "승인요청";
dtMailParam.Rows.Add(dr);
string sMailTitle = "[성과관리 - " + Biz_Com_Approval_Info.GetBizTypeName(biztype) + " 건 알림메일]";
bool ismail = PageUtility.SendMail(dtMailParam, sC_EMP_MAIL, (isReturn) ? sN_EMP_MAIL : sP_EMP_MAIL, sMailTitle, sFile);
}
}
public bool SendMail(bool isReturn)
{
if (PageUtility.GetAppConfig("Mail.UseDraftMailYN") == "N")
{
return(true);
}
string sC_EMP_MAIL = "";
string sP_EMP_MAIL = "";
string sN_EMP_MAIL = "";
string sFile = "Mail_Draft.htm";
EmpInfos objEmp = new EmpInfos(this.IDraftEmpID);
Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
bool bRtn = objPrc.GetSendMailUser(this.IApp_Ref_Id, this.IVersion_No, this.IDraftEmpID, out sC_EMP_MAIL, out sP_EMP_MAIL, out sN_EMP_MAIL);
if (!bRtn)
{
return(false);
}
if (isReturn && (!PageUtility.CheckMailAddress(sC_EMP_MAIL) || !PageUtility.CheckMailAddress(sN_EMP_MAIL)))
{
return(false);
}
if (!isReturn && (!PageUtility.CheckMailAddress(sC_EMP_MAIL) || !PageUtility.CheckMailAddress(sP_EMP_MAIL)))
{
return(false);
}
DataTable dtMailParam = new DataTable("PARAM");
dtMailParam.Columns.Add("KEY", typeof(string));
dtMailParam.Columns.Add("VAL", typeof(string));
Biz_Com_Approval_Info objMst = new Biz_Com_Approval_Info(this.IApp_Ref_Id, this.IVersion_No);
string strVPath = Request.ApplicationPath;
string strSHost = Request.Url.Host;
string strSPort = Request.Url.Port.ToString();
string strProto = Request.Url.Scheme;
strVPath = (strVPath == "/") ? "" : strVPath;
string strFullPath = strProto + "://" + strSHost + ":" + strSPort + strVPath;
DataRow dr = null;
dr = dtMailParam.NewRow();
dr["KEY"] = "[SITE_URL]";
dr["VAL"] = strFullPath;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[BIZ_TYPE]";
dr["VAL"] = Biz_Com_Approval_Info.GetBizTypeName(this.IBiz_Type);
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[APP_CODE]";
dr["VAL"] = objMst.IApp_Code;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TITLE]";
dr["VAL"] = objMst.ITitle;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[EMP_NAME]";
dr["VAL"] = objEmp.Emp_Name;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[DEPT_NAME]";
dr["VAL"] = objEmp.Dept_Name;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TRX_DATE]";
dr["VAL"] = objMst.IUpdate_Date.ToShortDateString();
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TODAY]";
dr["VAL"] = DateTime.Now.ToString();
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[DRAFT_TYPE]";
dr["VAL"] = (isReturn) ? "반려" : "승인요청";
dtMailParam.Rows.Add(dr);
string sMailTitle = "[성과관리 - " + Biz_Com_Approval_Info.GetBizTypeName(this.IBiz_Type) + " 건 알림메일]";
return(PageUtility.SendMail(dtMailParam, sC_EMP_MAIL, (isReturn) ? sN_EMP_MAIL : sP_EMP_MAIL, sMailTitle, sFile));
}
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
}
public bool SendMailBatch(bool isReturn)
{
if (PageUtility.GetAppConfig("Mail.UseDraftMailYN") == "N")
{
return(true);
}
string sC_EMP_MAIL = "";
string sP_EMP_MAIL = "";
string sN_EMP_MAIL = "";
string sFile = "Mail_Draft.htm";
EmpInfos objEmp = new EmpInfos(gUserInfo.Emp_Ref_ID);
Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc();
bool bRtn = objPrc.GetSendMailUser(this.IApp_Ref_Id, this.IVersion_No, gUserInfo.Emp_Ref_ID, out sC_EMP_MAIL, out sP_EMP_MAIL, out sN_EMP_MAIL);
if (!bRtn)
{
return(false);
}
if (isReturn && (!PageUtility.CheckMailAddress(sC_EMP_MAIL) || !PageUtility.CheckMailAddress(sN_EMP_MAIL)))
{
return(false);
}
if (!isReturn && (!PageUtility.CheckMailAddress(sC_EMP_MAIL) || !PageUtility.CheckMailAddress(sP_EMP_MAIL)))
{
return(false);
}
DataTable dtMailParam = new DataTable("PARAM");
dtMailParam.Columns.Add("KEY", typeof(string));
dtMailParam.Columns.Add("VAL", typeof(string));
MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info objKPI = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info();
DataTable dtKpi = new DataTable();
if (this.IBiz_Type == Biz_Type.biz_type_kpi_docbatch)
{
dtKpi = objKPI.GetKpiListForBatchDraft(GetRequestByInt("ESTTERM_REF_ID"), "", "", "Y", gUserInfo.Emp_Ref_ID, GetRequest("KPI_REF_ID", "")).Tables[0];
}
else if (this.IBiz_Type == Biz_Type.biz_type_kpi_rstbatch)
{
dtKpi = objKPI.GetKpiResultListForBatchDraft(GetRequestByInt("ESTTERM_REF_ID"), GetRequest("YMD"), "", "", "Y", gUserInfo.Emp_Ref_ID, GetRequest("KPI_REF_ID")).Tables[0];
}
else if (this.IBiz_Type == Biz_Type.biz_type_target_resultbatch)
{
dtKpi = objKPI.GetKpiResultListForBatchDraft(GetRequestByInt("ESTTERM_REF_ID"), GetRequest("YMD"), "", "", "N", gUserInfo.Emp_Ref_ID, GetRequest("KPI_REF_ID")).Tables[0];
}
bool rtnValue = false;
foreach (DataRow drKpi in dtKpi.Rows)
{
Biz_Com_Approval_Info objMst = new Biz_Com_Approval_Info(DataTypeUtility.GetToDecimal(drKpi["APP_REF_ID"]), 1);
string strVPath = Request.ApplicationPath;
string strSHost = Request.Url.Host;
string strSPort = Request.Url.Port.ToString();
string strProto = Request.Url.Scheme;
strVPath = (strVPath == "/") ? "" : strVPath;
string strFullPath = strProto + "://" + strSHost + ":" + strSPort + strVPath;
DataRow dr = null;
dr = dtMailParam.NewRow();
dr["KEY"] = "[SITE_URL]";
dr["VAL"] = strFullPath;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[BIZ_TYPE]";
dr["VAL"] = Biz_Com_Approval_Info.GetBizTypeName(Biz_Type.biz_type_kpi_doc);
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[APP_CODE]";
dr["VAL"] = objMst.IApp_Code;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TITLE]";
dr["VAL"] = objMst.ITitle;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[EMP_NAME]";
dr["VAL"] = objEmp.Emp_Name;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[DEPT_NAME]";
dr["VAL"] = objEmp.Dept_Name;
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TRX_DATE]";
dr["VAL"] = objMst.IUpdate_Date.ToShortDateString();
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[TODAY]";
dr["VAL"] = DateTime.Now.ToString();
dtMailParam.Rows.Add(dr);
dr = dtMailParam.NewRow();
dr["KEY"] = "[DRAFT_TYPE]";
dr["VAL"] = (isReturn) ? "반려" : "승인요청";
dtMailParam.Rows.Add(dr);
string sMailTitle = "";
if (this.IBiz_Type == Biz_Type.biz_type_kpi_docbatch)
{
sMailTitle = "[성과관리 - " + Biz_Com_Approval_Info.GetBizTypeName(Biz_Type.biz_type_kpi_doc) + " 건 알림메일]";
}
else if (this.IBiz_Type == Biz_Type.biz_type_kpi_rstbatch)
{
sMailTitle = "[성과관리 - " + Biz_Com_Approval_Info.GetBizTypeName(Biz_Type.biz_type_kpi_rst) + " 건 알림메일]";
}
else if (this.IBiz_Type == Biz_Type.biz_type_target_resultbatch)
{
sMailTitle = "[성과관리 - " + Biz_Com_Approval_Info.GetBizTypeName(Biz_Type.biz_type_target_result) + " 건 알림메일]";
}
rtnValue = PageUtility.SendMail(dtMailParam, sC_EMP_MAIL, (isReturn) ? sN_EMP_MAIL : sP_EMP_MAIL, sMailTitle, sFile);
}
return(rtnValue);
}