/// <summary>
/// 메일보내기
/// </summary>
/// <param name="iobjUser"></param>
/// <returns></returns>
private bool SendMailToReceiver(Biz_Bsc_Communication_User iobjUser)
{
DataSet rDs = iobjUser.GetAllList(this.IListRefID);
int intRow = rDs.Tables[0].Rows.Count;
string strMailTo = "";
string strTitle = "[BSC Comment 도착 알림메일]";
string strBody = "새로운 Comment가 [" + gUserInfo.Emp_Name + "]님으로부터 수신되었습니다. 확인하시기 바랍니다.";
string strMailFrom = gUserInfo.Emp_EMail.Trim(); //System.Configuration.ConfigurationManager.AppSettings["Mail.From"].ToString();
string strMailServer = System.Configuration.ConfigurationManager.AppSettings["Mail.SMTP"].ToString();
string strMailUrl = System.Configuration.ConfigurationManager.AppSettings["Mail.Url"].ToString();
for (int i = 0; i < intRow; i++)
{
strMailTo = rDs.Tables[0].Rows[i]["EMP_EMAIL"].ToString();
try
{
SendMail(strMailFrom, strMailTo, strTitle, strBody, strMailUrl, strMailServer);
return(true);
}
catch (Exception e)
{
return(false);
}
}
return(true);
}
/// <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>
/// <returns></returns>
private int TxrCommnunication()
{
Biz_Bsc_Communication_List objBSC = new Biz_Bsc_Communication_List();
Biz_Bsc_Communication_User objUsr = new Biz_Bsc_Communication_User();
objBSC.Ilist_ref_id = this.IListRefID;
objBSC.Icategory_code = "BO";
objBSC.Iparent_list_id = 0;
objBSC.Iestterm_ref_id = this.IEstTermRefID;
objBSC.Iymd = this.IYMD;
objBSC.Ikpi_ref_id = this.IKpiRefID;
objBSC.Ititle = txtSubject.Text;
objBSC.Idetails = txtContent.Value;
objBSC.Iread_count = (PageUtility.IsAllNumber(lblReadCount.Text)) ? Convert.ToInt32(lblReadCount.Text) : 0;
objBSC.Iattach_no = hAttachNo.Value;
objBSC.Iowner_emp_id = gUserInfo.Emp_Ref_ID;
objBSC.Iarr_receiver_id = hdfReceiver.Value;
objBSC.Iis_send_mail = (chkMailSend.Checked) ? "Y" : "N";
objBSC.Iis_open_list = (chkPublicYN.Checked) ? "Y" : "N";
int intRtn = 0;
if (this.IType == "A")
{
intRtn = objBSC.InsertData
(objBSC.Icategory_code
, (this.IisFeedBack == "Y" ? this.IListRefID : 0)
, objBSC.Iestterm_ref_id
, objBSC.Iymd
, objBSC.Ikpi_ref_id
, objBSC.Ititle
, objBSC.Idetails
, objBSC.Iread_count
, objBSC.Iattach_no
, objBSC.Iarr_receiver_id
, objBSC.Iis_send_mail
, objBSC.Iis_open_list
, objBSC.Iowner_emp_id);
if (objBSC.Transaction_Result == "Y")
{
this.IListRefID = objBSC.Ilist_ref_id;
intRtn = objUsr.InsertCommunicationAll(this.IListRefID, objBSC.Iowner_emp_id, this.getReceiverTable());
this.IType = "U";
this.SetButton();
if (intRtn > 0 && chkMailSend.Checked)
{
bool blnRtn = this.SendMailToReceiver(objUsr);
if (!blnRtn)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장이 되었으나 메일을 송부하지 못했습니다.", false);
}
}
}
}
else if (this.IType == "U")
{
intRtn = objBSC.UpdateData
(objBSC.Ilist_ref_id
, objBSC.Icategory_code
, objBSC.Iparent_list_id
, objBSC.Iestterm_ref_id
, objBSC.Iymd
, objBSC.Ikpi_ref_id
, objBSC.Ititle
, objBSC.Idetails
, objBSC.Iread_count
, objBSC.Iattach_no
, objBSC.Iarr_receiver_id
, objBSC.Iis_send_mail
, objBSC.Iis_open_list
, objBSC.Iowner_emp_id);
if (objBSC.Transaction_Result == "Y")
{
intRtn = objUsr.InsertCommunicationAll(this.IListRefID, objBSC.Iowner_emp_id, this.getReceiverTable());
}
}
else if (this.IType == "D")
{
intRtn = objBSC.DeleteData(this.IListRefID, objBSC.Iowner_emp_id);
if (objBSC.Transaction_Result == "N")
{
this.IType = "U";
}
else
{
intRtn = objUsr.DeleteDataAll(this.IListRefID, objBSC.Iowner_emp_id);
}
}
ltrScript.Text = JSHelper.GetAlertScript(objBSC.Transaction_Message, false);
return(intRtn);
}
/// <summary>
/// 초기 폼 데이터 설정
/// </summary>
private void SetKpiInfo()
{
if (this.IEstTermRefID > 0 && this.IKpiRefID > 0)
{
Biz_Bsc_Kpi_Info objKPI = new Biz_Bsc_Kpi_Info(this.IEstTermRefID, this.IKpiRefID);
Biz_ComDeptInfo objDept = new Biz_ComDeptInfo();
TermInfos objEst = new TermInfos(this.IEstTermRefID);
lblKpiName.Text = objKPI.Ikpi_name;
lblWriterName.Text = gUserInfo.Emp_Name;
lblTMCode.Text = objEst.Estterm_name + "(" + this.IYMD + ")";
if (this.IType == "U" && this.IListRefID > 0)
{
Biz_Bsc_Communication_List objList = new Biz_Bsc_Communication_List(this.IListRefID);
txtSubject.Text = objList.Ititle;
txtContent.Value = objList.Idetails;
ltrContent.Text = objList.Idetails;
txtReceiver.Text = objList.Iarr_receiver_id;
hdfReceiver.Value = objList.Iarr_receiver_id;
lblReadCount.Text = objList.Iread_count.ToString();
hAttachNo.Value = objList.Iattach_no;
lblCreateDate.Text = objList.Create_date.ToLongDateString();
lblWriterName.Text = objList.Iowner_emp_name;
chkMailSend.Checked = (objList.Iis_send_mail == "Y") ? true : false;
chkPublicYN.Checked = (objList.Iis_open_list == "Y") ? true : false;
int intLoginID = gUserInfo.Emp_Ref_ID;
int intRtnRow = 0;
// 작성자와 로긴한 사용자가 같을경우 즉, 자기글일경우
if (intLoginID == objList.Iowner_emp_id)
{
this.IisOwner = "Y";
this.leftLayer.Visible = false;
this.txtContent.Visible = true;
this.iBtnFeedback.Visible = false;
this.iBtnDelete.Visible = true;
this.iBtnDownload.Visible = false;
this.iBtnUpload.Visible = true;
}
else
{
this.IisOwner = "N";
this.leftLayer.Visible = true;
this.txtContent.Visible = false;
this.iBtnFeedback.Visible = true;
this.iBtnModify.Visible = false;
this.iBtnFindEmp.Visible = false;
this.iBtnDelete.Visible = false;
this.iBtnDownload.Visible = (objList.Iattach_no.Trim() == "") ? false : true;
this.iBtnUpload.Visible = false;
this.chkPublicYN.Enabled = false;
this.chkMailSend.Enabled = false;
intRtnRow = objList.AddClickCount(this.IListRefID, intLoginID);
Biz_Bsc_Communication_User objUser = new Biz_Bsc_Communication_User(this.IListRefID, intLoginID);
if (objUser.Iread_yn == "N")
{
intRtnRow = objUser.UpdateData(this.IListRefID, intLoginID, "Y", intLoginID);
}
}
}
else if (this.IType == "A")
{
this.leftLayer.Visible = false;
this.txtContent.Visible = true;
this.iBtnDownload.Visible = false;
this.iBtnUpload.Visible = true;
}
else
{
this.leftLayer.Visible = true;
this.txtContent.Visible = false;
}
}
}
