private bool bSaveFile() { bool bReturn = false; try { string xFileName = ""; byte[] xFileByte = null; FileUpload file = this.fileUplaod;// ((FileUpload)((C1.Web.C1WebGrid.C1GridItem)this.grdList.Items[i]).FindControl("fileUplaod")); if (file.FileBytes.Length > 0) { xFileName = file.FileName.Replace(" ", "_").Replace("..", "_"); xFileByte = file.FileBytes; SBROKER.GetString("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md", "SetFileAtt", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", xFileByte, xFileName, txtID.Text.ToUpper().Replace("'", "''")); } file.Dispose(); bReturn = true; } catch (Exception ex) { bReturn = false; } return(bReturn); }
public bool CheckData() { try { string xExcessChk = Boolean.TrueString; // 직책 or 직급이 수강신청 대상에 해당하는 경우를 찾는다. string[] xChkParams = new string[2]; xChkParams[0] = Request.QueryString["OPEN_COURSE_ID"].ToString(); xChkParams[1] = Session["USER_ID"].ToString(); xExcessChk = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPLICATION.vp_s_received_md", "GetCompareRcvCount", LMS_SYSTEM.APPLICATION, "CLT.WEB.UI.LMS.APPLICATION", (object)xChkParams); if (xExcessChk == Boolean.TrueString) { return(true); } else { return(false); } } catch (Exception ex) { return(true); } }
/************************************************************ * Function name : BindHitCnt * Purpose : 공지사항 조회시 조회숫자 Count 메서드 * * Input : string rSeq (공지사항 번호) * Output : void *************************************************************/ #region public void BindHitCnt(string rSeq) public void BindHitCnt(string rSeq) { try { //SetNoticeHitCnt string xRtn = Boolean.FalseString; string xScriptMsg = string.Empty; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMUNITY.vp_y_community_notice_md", "SetNoticeHitCnt", LMS_SYSTEM.COMMUNITY, "CLT.WEB.UI.LMS.COMMUNITY.edu_notice_detail", (object)rSeq); if (xRtn == Boolean.FalseString) { //xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/************************************************************ * Function name : btnDel_Click * Purpose : 평가 코드 삭제 * Input : void * Output : void *************************************************************/ protected void btnDel_Click(object sender, EventArgs e) { try { DataTable xDt = new DataTable(); xDt.Columns.Add("grade"); for (int i = 0; i < this.grdList.Items.Count; i++) { if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("chk_sel")).Checked) { DataRow xRow = xDt.NewRow(); xRow["GRADE"] = this.grdList.DataKeys[i].ToString(); xDt.Rows.Add(xRow); } } string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md", "SetApprCodeDelete", LMS_SYSTEM.CAPABILITY, "CLT.WEB.UI.LMS.CURR", xDt); } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : btnSave_Click * Purpose : * Input : void * Output : void *************************************************************/ #region protected void btnSave_Click() protected void btnSave_Click(object sender, EventArgs e) { try { //if (this.grd.Items.Count <= iManTotCnt) //개설된 정원보다 신청 인원이 초과할 경우 체크 //{ string[] xParams = new string[5]; xParams[0] = Request.QueryString["OPEN_COURSE_ID"].ToString(); xParams[1] = Session["USER_ID"].ToString(); for (int i = 0; i < this.grd.Items.Count; i++) { xParams[2] += this.grd.Items[i].Cells[0].Text.ToString() + "|"; } xParams[3] = this.txtCourseNm.Text; xParams[4] = this.txtCourseDt.Text; string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPLICATION.vp_s_received_md", "SetReceivedCourseResult", LMS_SYSTEM.APPLICATION, "CLT.WEB.UI.LMS.APPLICATION", (object)xParams); if (xRtn != string.Empty) { //A001: {0}이(가) 저장되었습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "교육접수" }, new string[] { "Training Received" }, Thread.CurrentThread.CurrentCulture )); //저장 후 신규 id 값으로 재조회 this.BindGrid(); } else { //A004: {0}이(가) 입력되지 않았습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "교육접수" }, new string[] { "Training Received" }, Thread.CurrentThread.CurrentCulture )); } //} //else //{ // ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A007", // new string[] { "교육접수", iManTotCnt +"명" }, // new string[] { "Training Received", iManTotCnt + "Persons" }, // Thread.CurrentThread.CurrentCulture // )); //} } catch (Exception ex) { base.NotifyError(ex); } }
protected void btn_save_Click(object sender, EventArgs e) { try { string xFileName = ""; byte[] xFileByte = null; int xChkSel = 0; int xCntSel = 0; for (int i = 0; i < this.grdList.Items.Count; i++) { if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("chk_sel")).Checked) { xChkSel++; FileUpload file = ((FileUpload)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("fileUplaod")); if (file.FileBytes.Length > 0) { xCntSel++; xFileName = file.FileName.Replace(" ", "_").Replace("..", "_"); xFileByte = file.FileBytes; SBROKER.GetString("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md", "SetFileAtt", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.EDUM.vp_a_eduming_issuing_wpg", xFileByte, xFileName, grdList.DataKeys[i].ToString()); } file.Dispose(); } } if (xCntSel > 0) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "사진" }, new string[] { "Photo" }, Thread.CurrentThread.CurrentCulture)); GC.Collect(); //BindGrdList(1, ""); } else if (xChkSel == 0) { ScriptHelper.Page_Alert(this, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A047", new string[] { "" }, new string[] { "" }, System.Threading.Thread.CurrentThread.CurrentCulture)); } else { ScriptHelper.Page_Alert(this, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A003", new string[] { "사진" }, new string[] { "Photo" }, System.Threading.Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : DetailUpdateCode * Purpose : Detail 공통코드 Update * Input : void * Output : void *************************************************************/ public void DetailUpdateCode() { try { string xRtn = Boolean.FalseString; string xScriptMsg = string.Empty; string[] xParams = new string[7]; xParams[0] = txtMasterCode.Text; xParams[1] = txtMasterCode_NM.Text.Replace("'", "''"); xParams[2] = txtCodeMaster_KNM.Text.Replace("'", "''"); xParams[3] = txtCodeMaster_ENM.Text.Replace("'", "''"); if (chkUse_yn.Checked == true) { xParams[4] = "Y"; } else { xParams[4] = "N"; } xParams[5] = Session["USER_ID"].ToString(); xParams[6] = Request.QueryString["openerm_cd"]; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.MANAGE.vp_m_detailcode_md", "SetCodeDetailEdit", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", (object)xParams); if (xRtn.ToUpper() == "TRUE") { //xScriptMsg = "<script>alert('정상적으로 처리 완료되었습니다.');self.close();</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); } else { //xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');self.close();</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
protected void btn_save_Click(object sender, EventArgs e) { try { DataTable xDt = new DataTable(); xDt.Columns.Add("KEYS"); xDt.Columns.Add("APPROVAL_FLG"); xDt.Columns.Add("EMPLOYED_STATE"); xDt.Columns.Add("INSURANCE_FLG"); xDt.Columns.Add("INSURANCE_DT"); xDt.Columns.Add("non_approval_cd"); xDt.Columns.Add("non_approval_remark"); xDt.Columns.Add("COURSE_START_FLG"); for (int i = 0; i < this.grdList.Items.Count; i++) { //R.USER_ID ||'^'|| R.OPEN_COURSE_ID||'^'|| R.COURSE_RESULT_SEQ DataRow xRow = xDt.NewRow(); xRow["KEYS"] = grdList.DataKeys[i].ToString(); xRow["APPROVAL_FLG"] = ((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("chkApproval")).Checked ? "000001" : "000002"; xRow["EMPLOYED_STATE"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("ddlEmployedState")).SelectedValue; xRow["INSURANCE_FLG"] = ""; xRow["INSURANCE_DT"] = ""; xRow["non_approval_cd"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("ddlNonApprovalCD")).SelectedValue; xRow["non_approval_remark"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("txtNonApprovalRemark")).Text; xRow["COURSE_START_FLG"] = ((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("chkStartFlg")).Checked ? "Y" : "N"; xDt.Rows.Add(xRow); } string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md", "SetEduApprovalUserList", LMS_SYSTEM.APPLICATION, "CLT.WEB.UI.LMS.APPLICATION", xDt, ""); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "수강신청/승인처리" }, new string[] { "evaluator" }, Thread.CurrentThread.CurrentCulture)); //this.BindGrdList(1, ""); } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Administrator" }, Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { base.NotifyError(ex); } }
protected void btnSave_Click(object sender, EventArgs e) { try { string xRtn = Boolean.FalseString; string xScriptMsg = string.Empty; string[] xParams = new string[6]; xParams[1] = lblUserId.Text; xParams[2] = txtCourseID.Value; xParams[3] = ddlInstitution.SelectedValue; xParams[4] = txtSTART_DATE.Text; xParams[5] = txtEND_DATE.Text; if (Util.IsNullOrEmptyObject(iSearch)) { xParams[0] = ""; } else // 수정 { xParams[0] = iRecordId; } xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md", "SetEduTrainingRecord", LMS_SYSTEM.CAPABILITY, "CLT.WEB.UI.LMS.APPR", (object)xParams); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "교육결과 입력" }, new string[] { "Register training Record" }, Thread.CurrentThread.CurrentCulture)); if (string.IsNullOrEmpty(iRecordId)) { txtSTART_DATE.Text = ""; txtEND_DATE.Text = ""; txtCourseNM.Value = ""; txtCourseID.Value = ""; ddlInstitution.SelectedValue = ""; } } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Administrator" }, Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { base.NotifyError(ex); } }
protected void btnDel_Click(object sender, EventArgs e) { try { int xCntSel = 0; DataTable xDt = new DataTable(); xDt.Columns.Add("user_id"); xDt.Columns.Add("record_id"); xDt.Columns.Add("course_id"); for (int i = 0; i < this.grdList.Items.Count; i++) { if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("chk_sel")).Checked) { xCntSel++; DataRow xRow = xDt.NewRow(); xRow["user_id"] = Util.Split(grdList.DataKeys[i].ToString(), "^", 4)[0]; xRow["record_id"] = Util.Split(grdList.DataKeys[i].ToString(), "^", 4)[1]; xRow["course_id"] = Util.Split(grdList.DataKeys[i].ToString(), "^", 4)[2]; xDt.Rows.Add(xRow); } } if (xCntSel > 0) { string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md", "GetEduTrainigRecordDelete", LMS_SYSTEM.EDUMANAGEMENT, "CLT.WEB.UI.LMS.EDUM", xDt); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A002", new string[] { "교육이력" }, new string[] { "Register Training Record" }, Thread.CurrentThread.CurrentCulture)); this.BindGrdList(1, ""); } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Administrator" }, Thread.CurrentThread.CurrentCulture)); } } else { ScriptHelper.Page_Alert(this.Page, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A047", new string[] { "" }, new string[] { "" }, System.Threading.Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : btnSend_OnClick * Purpose : 입력된 설문 내용 전송버튼 이벤트 * Input : void * Output : void *************************************************************/ #region btnSend_OnClick(object sender, EventArgs e) protected void btnSend_OnClick(object sender, EventArgs e) { try { if (ViewState["ANSWER_YN"].ToString() == "Y") { // 게시된 설문은 수정 할 수 없습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A118", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); return; } string xMessage = Validateion(Convert.ToInt32(ViewState["COUNT"].ToString())); if (!string.IsNullOrEmpty(xMessage)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A016", new string[] { xMessage + "번 설문" }, new string[] { "Q" + xMessage }, Thread.CurrentThread.CurrentCulture)); return; } AnswerInsert(Convert.ToInt32(ViewState["COUNT"].ToString())); string xRtn = Boolean.FalseString; // Update 후 결과값 Return string[] xParams = new string[2]; xParams[0] = Request.QueryString["rResNo"]; xParams[1] = Session["USER_ID"].ToString(); // 사용자 정보는 Delete 하지 않고 Status 를 사용안함(000002) 으로 처리 xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.CURR.vp_m_survey_md", "SetSurveyAnswer", LMS_SYSTEM.COMMUNITY, "CLT.WEB.UI.LMS.COMMUNITY", (object)xParams); if (xRtn.ToUpper() == "TRUE") { //xScriptMsg = "<script>alert('정상적으로 처리 완료되었습니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); ViewState["ANSWER_YN"] = "Y"; //BindGrid(); } else { //xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { base.NotifyError(ex); } }
protected void btnDel_Click(object sender, EventArgs e) { try { int xCntSel = 0; DataTable xDt = new DataTable(); xDt.Columns.Add("app_no"); for (int i = 0; i < this.grdList.Items.Count; i++) { if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("chk_sel")).Checked) { xCntSel++; DataRow xRow = xDt.NewRow(); xRow["app_no"] = grdList.DataKeys[i].ToString(); xDt.Rows.Add(xRow); } } if (xCntSel > 0) { string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md", "DelApprResult", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.APPR", xDt); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A002", new string[] { "평가자" }, new string[] { "evaluator" }, Thread.CurrentThread.CurrentCulture)); BindGrdList(""); } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Administrator" }, Thread.CurrentThread.CurrentCulture)); } } else { ScriptHelper.Page_Alert(this.Page, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A047", new string[] { "" }, new string[] { "" }, System.Threading.Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : btnDelete * Purpose : 공지사항 Delete 메서드 * * Input : void * Output : void *************************************************************/ public void buttonDelete(string rSeq, string rDelYn) { try { string xRtn = Boolean.FalseString; string xScriptMsg = string.Empty; string[] xParams = new string[2]; xParams[0] = rSeq; xParams[1] = rDelYn; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMUNITY.vp_y_community_notice_md", "SetNoticeDelete", LMS_SYSTEM.COMMUNITY, "CLT.WEB.UI.LMS.COMMUNITY.edu_notice_detail", xParams); if (xRtn.ToUpper() == "TRUE") { //xScriptMsg = "<script>alert('정상적으로 처리 완료되었습니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); } else { //xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); } //button_Click(btnList, new EventArgs()); xScriptMsg = "<script>window.location.href='/community/edu_notice_list.aspx?BIND=BIND';</script>"; ScriptHelper.ScriptBlock(this, "edu_notice_list", xScriptMsg); //Response.Redirect("/community/edu_notice_list.aspx"); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/************************************************************ * Function name : btnRetrieve_Click * Purpose : 사용자 정보 조회 이벤트 * Input : void * Output : void *************************************************************/ #region btnRetrieve_Click() protected void btnRetrieve_Click(object sender, EventArgs e) { try { if (Session["USER_GROUP"].ToString() == "000001") { string[] xParams = new string[1]; string xRtn = Boolean.TrueString; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md", "SetUserUpdateSSO", LMS_SYSTEM.MAIN, "CLT.WEB.UI.LMS.MAIN", (object)xParams); } BindGrid(); } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : btnReplaceSave_OnClick * Purpose : 댓글저장 버튼 Click 이벤트 * * Input : void * Output : void *************************************************************/ #region protected void btnReplaceSave_OnClick(object seder, EventArgs e) protected void btnReplaceSave_OnClick(object seder, EventArgs e) { try { if (string.IsNullOrEmpty(this.txtReplace.Text)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "댓글내용" }, new string[] { "Content" }, Thread.CurrentThread.CurrentCulture)); return; } string[] xParams = new string[3]; xParams[0] = Request.QueryString["seq"]; xParams[1] = this.txtReplace.Text.Replace("'", "''"); xParams[2] = Session["USER_ID"].ToString(); string xRtn = Boolean.FalseString; string xScriptMsg = string.Empty; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMUNITY.vp_y_community_qna_md", "SetQnAReplace", LMS_SYSTEM.COMMUNITY, "CLT.WEB.UI.LMS.COMMUNITY.qna_detail", (object)xParams); if (xRtn == Boolean.FalseString) { //xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); this.txtReplace.Text = string.Empty; } Response.Redirect(string.Format("/community/qna_detail.aspx?seq={0}&MenuCode={1}&delYN={2}", Request.QueryString["seq"].ToString(), Session["MENU_CODE"], Request.QueryString["delYN"])); } catch (Exception ex) { base.NotifyError(ex); } }
protected void btnSend_Click(object sender, EventArgs e) { //인터페이스 try { string[] xParams = new string[2]; xParams[0] = ""; xParams[1] = ""; string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md", "SetAppraisalItemInf", LMS_SYSTEM.CAPABILITY, "CLT.WEB.UI.LMS.APPR", (object)xParams); if (xRtn.ToUpper() == "TRUE") { //A001: {0}이(가) 저장되었습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A017", new string[] { "역량평가 항목" }, new string[] { "Competence evaluation items" }, Thread.CurrentThread.CurrentCulture )); } else { //A004: {0}이(가) 입력되지 않았습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "역량평가 항목" }, new string[] { "Competence evaluation items" }, Thread.CurrentThread.CurrentCulture )); } } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : btnSend_OnClick * Purpose : SMS 전송 버튼 * Input : void * Output : void *************************************************************/ #region protected void btnSend_OnClick(object sender, EventArgs e) protected void btnSend_OnClick(object sender, EventArgs e) { try { // 필수입력값 체크 if (string.IsNullOrEmpty(this.txtSMS_Title.Text)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "제목" }, new string[] { "Title" }, Thread.CurrentThread.CurrentCulture)); return; } else if (string.IsNullOrEmpty(this.txtRec_MobilePhone.Text)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "회신번호" }, new string[] { "Response Mobile Phone Number" }, Thread.CurrentThread.CurrentCulture)); return; } else if (lbSentlist.Items.Count == 0) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "발신번호 리스트" }, new string[] { "Send Mobile Phone Number" }, Thread.CurrentThread.CurrentCulture)); return; } else if (string.IsNullOrEmpty(this.txtContent.Value)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "SMS 내용" }, new string[] { "SMS Contents" }, Thread.CurrentThread.CurrentCulture)); return; } if (rbBooking.Checked == true) // 예약 발송일 경우 { if (string.IsNullOrEmpty(this.ddlYear.SelectedValue)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "예약발송 년도" }, new string[] { "Reserved Year" }, Thread.CurrentThread.CurrentCulture)); return; } else if (string.IsNullOrEmpty(this.ddlMonth.SelectedValue)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "예약발송 월" }, new string[] { "Reserved Month" }, Thread.CurrentThread.CurrentCulture)); return; } else if (string.IsNullOrEmpty(this.ddlDay.SelectedValue)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "예약발송 일" }, new string[] { "Reserved Day" }, Thread.CurrentThread.CurrentCulture)); return; } else if (string.IsNullOrEmpty(this.ddlHour.SelectedValue)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "예약발송 시" }, new string[] { "Reserved Hour" }, Thread.CurrentThread.CurrentCulture)); return; } else if (string.IsNullOrEmpty(this.ddlMinute.SelectedValue)) { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "예약발송 분" }, new string[] { "Reserved Minute" }, Thread.CurrentThread.CurrentCulture)); return; } } string[] xMasterParams = new string[9]; xMasterParams[0] = this.txtSMS_Title.Text; // SMS 제목 xMasterParams[1] = txtRec_MobilePhone.Text; // SMS 회신번호 xMasterParams[2] = this.txtContent.Value; // SMS 발송내용 xMasterParams[3] = this.lbSentlist.Items.Count.ToString(); if (this.ddlCus_Date.SelectedItem != null) { xMasterParams[4] = this.ddlCus_Date.SelectedItem.Value.ToString(); // 과정코드 } else { xMasterParams[4] = ""; } xMasterParams[5] = Session["USER_ID"].ToString(); if (this.rbSentType.Checked == true) // 지금 보낼 경우 { xMasterParams[6] = "I"; } else if (this.rbBooking.Checked == true) // 예약발송일 경우 { xMasterParams[6] = "R"; xMasterParams[7] = this.ddlYear.SelectedValue + this.ddlMonth.SelectedValue + this.ddlDay.SelectedValue + this.ddlHour.SelectedValue + this.ddlMinute.SelectedValue + "00"; } xMasterParams[8] = "00"; // 일반 SMS 코드 if (this.HiddenMESS.Value == "MAIL") { xMasterParams[8] = "10"; // 이미지 없는 MMS 코드 } string[,] xDetailParams = new string[this.lbSentlist.Items.Count, 3]; int nCount = 0; foreach (ListItem Items in this.lbSentlist.Items) { string[] xText = Items.Text.Split(':'); xDetailParams[nCount, 0] = Items.Value; // 수신자 ID xDetailParams[nCount, 1] = xText[0]; // 수신자 이름 xDetailParams[nCount, 2] = xText[1]; // 수신자 전화번호 nCount++; } string xRtn = Boolean.FalseString; string xScriptMsg = string.Empty; object[] xParams = new object[2]; xParams[0] = (object)xMasterParams; xParams[1] = (object)xDetailParams; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md", "SetSentSMSBoxInsert", LMS_SYSTEM.APPLICATION, "CLT.WEB.UI.LMS.APPLICATION", (object)xParams); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A017", new string[] { "SMS" }, new string[] { "SMS" }, Thread.CurrentThread.CurrentCulture )); xScriptMsg = "<script>window.location.href='/application/sms_list.aspx';</script>"; ScriptHelper.ScriptBlock(this, "sms_send", xScriptMsg); } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Adminstrator" }, Thread.CurrentThread.CurrentCulture )); } } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : btnSend_Click * Purpose : Send버튼 클릭될 때 처리 * 어떤 항목이라도 변경이 발생되면, 신규 생성하여 선박으로 전송 처리 * Input : void * Output : void *************************************************************/ #region protected void btnSend_Click(object sender, EventArgs e) protected void btnSend_Click(object sender, EventArgs e) { try { if (IsDataChanged()) { string[] xTempParams = new string[2]; //string xContentsID = ""; string xRtn = ""; //// contents_id 처리 //xTempParams[0] = "t_contents"; //xTempParams[1] = "contents_id"; //xContentsID = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md", // "GetMaxIDOfTable", // LMS_SYSTEM.CURRICULUM, // "CLT.WEB.UI.LMS.CURR", (object)xTempParams); // 입력 처리 object[] xParams = new object[12]; xParams[0] = ViewState["CONTENTS_ID"].ToString(); xParams[1] = this.ddlContentsType.SelectedItem.Value; // contents_type xParams[2] = this.ddlLang.SelectedItem.Value; // lang xParams[3] = this.txtContentsNM.Text; // contents_name xParams[4] = this.txtRemark.Text; // remark // 파일 변경이 있을 경우, file object를 그대로 넘기고 if (ViewState["CONTENTS_FILE_NM"].ToString() != this.txtFileNM.Value) { xParams[5] = base.ConvertToFileUpload(this.FileUpload1.PostedFile); xParams[6] = this.txtFileNM.Value; } else { xParams[5] = null; xParams[6] = this.txtFileNM.Value; } //if (this.FileUpload1.PostedFile != null && this.FileUpload1.PostedFile.ContentLength > 0) //{ // xParams[5] = this.FileUpload1.PostedFile; // contents_file // xParams[6] = null; // contents_filename //} // //파일 변경이 없을 경우, 기존과 동일하게 file명만 넘긴다. //else //{ // xParams[5] = null; // contents_file // xParams[6] = this.txtFileNM.Value; // contents_filename //} xParams[7] = Server.MapPath(this.ContentsFilePath); // contents_filepath xParams[8] = Session["USER_ID"].ToString(); // Ins_ID xParams[9] = "1"; // send_flg xParams[10] = (Request.QueryString["TEMP_FLG"] != null && Request.QueryString["TEMP_FLG"].ToString() == "Y") ? "Y" : "N"; xParams[11] = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["ContentsFilePath"].ToString()); xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.CURR.vp_c_content_md", "SetContentsInsert", LMS_SYSTEM.CURRICULUM, "CLT.WEB.UI.LMS.CURR", (object)xParams); if (xRtn != string.Empty) { //A001: {0}이(가) 저장되었습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "컨텐츠" }, new string[] { "Contents" }, Thread.CurrentThread.CurrentCulture )); //저장 후 신규 id 값으로 재조회 ViewState["CONTENTS_ID"] = xRtn; this.BindData(); } else { //A004: {0}이(가) 입력되지 않았습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "컨텐츠" }, new string[] { "Contents" }, Thread.CurrentThread.CurrentCulture )); } } else { //A023: 변경내용을 재 확인 바랍니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A023", new string[] { null }, new string[] { null }, Thread.CurrentThread.CurrentCulture )); } } catch (Exception ex) { base.NotifyError(ex); } }
protected void btnSend_Click(object sender, EventArgs e) { try { int xCntSel = 0; DataTable xDt = new DataTable(); xDt.Columns.Add("app_base_dt"); //기준일8자 xDt.Columns.Add("step_gu"); //구분 xDt.Columns.Add("app_duty_step"); //평가대상 xDt.Columns.Add("vsl_typeP"); //선종 xDt.Columns.Add("vsl_typeC"); //선종 xDt.Columns.Add("app_lang"); //언어 xDt.Columns.Add("app_item_seq"); //역량 No xDt.Columns.Add("app_item_nm"); //역량명 xDt.Columns.Add("app_item_nm_eng"); //영문 역량명 xDt.Columns.Add("app_item_desc"); //국문 역량정의 xDt.Columns.Add("app_item_desc_eng"); //영문 역량정의 xDt.Columns.Add("app_case_seq"); //SEQ xDt.Columns.Add("app_case_desc"); //국문 행위사례 xDt.Columns.Add("app_case_desc_eng"); //영문 행위사례 xDt.Columns.Add("course_ojt"); //OJT xDt.Columns.Add("course_lms"); //LMS xDt.Columns.Add("course_etc"); //Others xDt.Columns.Add("ins_id"); for (int i = 0; i < this.grdItem.Items.Count; i++) { if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("chk_sel")).Checked) { xCntSel++; DataRow xRow = xDt.NewRow(); xRow["app_base_dt"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAppBaseDT")).Text; xRow["step_gu"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("ddlStepGu")).SelectedValue; xRow["app_duty_step"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("ddlAppDutyStep")).SelectedValue; xRow["vsl_typeP"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("ddlVslTypeP")).SelectedValue; xRow["vsl_typeC"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("ddlVslTypeC")).SelectedValue; xRow["app_lang"] = "";// ((DropDownList)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("ddlAppLang")).SelectedValue; xRow["app_item_seq"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAppItemSeq")).Text; xRow["app_item_nm"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAppItemNM")).Text; xRow["app_item_nm_eng"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAppItemNMEng")).Text; xRow["app_item_desc"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAppItemDesc")).Text; xRow["app_item_desc_eng"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAppItemDescEng")).Text; xRow["app_case_seq"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAppCaseSeq")).Text; xRow["app_case_desc"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAppCaseDesc")).Text; xRow["app_case_desc_eng"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAppCaseDescEng")).Text; xRow["course_ojt"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("hdnCourseOJT")).Text; xRow["course_lms"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("hdnCourseLMS")).Text; xRow["course_etc"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtCourseEtc")).Text; xRow["ins_id"] = Session["user_id"]; xDt.Rows.Add(xRow); } } if (xCntSel > 0) { string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md", "SetApprItemInsert", LMS_SYSTEM.CAPABILITY, "vp_a_appraisal_item_excel_wpg", xDt); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "평가자" }, new string[] { "evaluator" }, Thread.CurrentThread.CurrentCulture)); } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Administrator" }, Thread.CurrentThread.CurrentCulture)); } } else { ScriptHelper.Page_Alert(this, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A047", new string[] { "" }, new string[] { "" }, System.Threading.Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : Apploval() * Purpose : 승인요청 * Input : void * Output : void *************************************************************/ #region Apploval() public void Apploval() { try { string xRtn = Boolean.FalseString; // Update 후 결과값 Return ArrayList xalChk = new ArrayList(); // 사용자 CheckBox for (int i = 0; i < this.C1WebGrid1.Items.Count; i++) { //if (((CheckBox)((C1.Web.C1WebGrid.C1GridItem)this.C1WebGrid1.Items[i]).FindControl("chkEdit")).Checked == true) if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.C1WebGrid1.Items[i]).FindControl("chkEdit")).Checked) { TableCell xTCC = new TableCell(); xTCC = (TableCell)this.C1WebGrid1.Items[i].Cells[10]; // 승인여부 string xUserID = this.C1WebGrid1.DataKeys[i].ToString(); // 체크한 그리드의 사용자 Key 값 가져오기 if (xTCC.Text == "000003") // 승인상태일 경우 { // A099 {1}를 이미 완료하였음으로 {0}할수 없습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A099", new string[] { "승인처리를", "승인" }, new string[] { "Apploval Complete", "Apploval" }, Thread.CurrentThread.CurrentCulture)); return; //xScriptMsg = string.Format("<script>alert('이미 승인처리된 ID 입니다! 사용자ID : {0}');</script>", xUserID); } else if (xTCC.Text == "000004") // 승인대기 상태일 경우 { // A088 결재가 진행중입니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A088", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); return; //xScriptMsg = string.Format("<script>alert('승인대기 상태의 ID 입니다! 사용자ID : {0}');</script>", xUserID); } xTCC = (TableCell)this.C1WebGrid1.Items[i].Cells[10]; if (string.IsNullOrEmpty(this.C1WebGrid1.Items[i].Cells[10].Text)) // 회사구분 체크) // 회사구분 체크 // 회사코드 체크 { // 회사코드를 입력해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "회사코드" }, new string[] { "Company Code" }, Thread.CurrentThread.CurrentCulture)); return; } else if (this.C1WebGrid1.Items[i].Cells[10].Text == " ") { // 회사코드를 입력해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "회사코드" }, new string[] { "Company Code" }, Thread.CurrentThread.CurrentCulture)); return; } else if (string.IsNullOrEmpty(this.C1WebGrid1.Items[i].Cells[11].Text)) // 회사구분 체크 { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "회사구분" }, new string[] { "Company Kind" }, Thread.CurrentThread.CurrentCulture)); return; } else if (string.IsNullOrEmpty(this.C1WebGrid1.Items[i].Cells[12].Text)) // 우편번호 체크 { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "우편번호" }, new string[] { "Zip Code" }, Thread.CurrentThread.CurrentCulture)); return; } else if (string.IsNullOrEmpty(this.C1WebGrid1.Items[i].Cells[13].Text)) // 우편번호 체크 { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "주소" }, new string[] { "Address" }, Thread.CurrentThread.CurrentCulture)); return; } if (!xalChk.Contains(xUserID)) { xalChk.Add(xUserID); } } } if (xalChk.Count == 0) { // 체크박스가 선택되지 않았습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "체크박스" }, new string[] { "Check Box" }, Thread.CurrentThread.CurrentCulture)); return; } string[,] xParams = new string[xalChk.Count, 3]; int xCount = 0; foreach (string xList in xalChk) { xParams[xCount, 0] = xList; // 체크한 user ID xParams[xCount, 1] = Session["USER_ID"].ToString(); // 로그인한 user ID xParams[xCount, 2] = "000004"; // 공통코드 User Status 승인대기 xCount++; } // 사용자 정보는 Delete 하지 않고 Status 를 사용안함(000002) 으로 처리 xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.MANAGE.vp_m_company_md", "SetCompanyDelete", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", (object)xParams); if (xRtn.ToUpper() == "TRUE") { //xScriptMsg = "<script>alert('정상적으로 처리 완료되었습니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); BindGrid(); } else { //xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); } BindGrid(); // 승인 후 Data 조회 } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/************************************************************ * Function name : buttonUpdate * Purpose : 내용 저장 처리(기존 저장) * Input : void * Output : void *************************************************************/ #region public void buttonUpdate(Button rbtn, string rSeq) public void buttonUpdate(Button rbtn, string rSeq) { try { string xRtn = Boolean.FalseString; string xScriptMsg = string.Empty; object[] xParams = new object[3]; string[] xMasterParams = new string[4]; xMasterParams[0] = txtSubject.Text.Replace("'", "''"); // 제목 xMasterParams[1] = txtCONTENT.Text.Replace("'", "''"); // 내용 xMasterParams[2] = Session["USER_ID"].ToString(); // 사용자 ID xMasterParams[3] = rSeq; // 기존 번호 string[] xDeleteFile = new string[lbDeleteList.Items.Count]; // 기존첨부파일에서 삭제할 Data //lbDeleteList int nCount = 0; if (lbDeleteList.Items.Count > 0) { foreach (ListItem xFileName in lbDeleteList.Items) { xDeleteFile[nCount] = xFileName.Text; nCount++; } } //if (ialDeleteList.Count != 0) //{ // foreach (string xFileName in ialDeleteList) // { // xDeleteFile[nCount] = xFileName; // nCount++; // } //} //object[] xDetailParams = new object[ialFileList.Count]; //for (int i = 0; i < ialFileList.Count; i++) //{ // FileUpload xUpload = (FileUpload)ialFileList[i]; // xDetailParams[i] = xUpload.PostedFile; //} object[,] xDetailParams = new object[ialFileList.Count, 3]; nCount = 0; foreach (FileUpload attfile in ialFileList) { HttpPostedFile xFile = (HttpPostedFile)attfile.PostedFile; Stream stream = xFile.InputStream; string[] ffiles = xFile.FileName.Split(new string[] { "\\" }, StringSplitOptions.None); //xFileName = "F:\\" + xFile.FileName; //if (xFile.FileName.Contains("\\")) //{ //} int xGetbyte = 0; List <byte> bytes = new List <byte>(); while ((xGetbyte = stream.ReadByte()) > -1) { bytes.Add((byte)xGetbyte); } stream.Close(); xDetailParams[nCount, 0] = bytes.ToArray(); xDetailParams[nCount, 1] = ffiles[ffiles.Length - 1].Replace(" ", "_"); //xFile.FileName; xDetailParams[nCount, 2] = rSeq; nCount++; } xParams[0] = xMasterParams; xParams[1] = xDetailParams; xParams[2] = xDeleteFile; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMUNITY.vp_y_community_data_md", "SetDataUpdate", LMS_SYSTEM.COMMUNITY, "CLT.WEB.UI.LMS.COMMUNITY", (object)xParams); if (xRtn.ToUpper() == "TRUE") { //xScriptMsg = "<script>alert('정상적으로 처리 완료되었습니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); ViewState["EDITMODE"] = "EDIT"; ViewState["SEQ"] = rSeq; // 처리가 완료되면 초기화 ialFileList.Clear(); this.lbDeleteList.Items.Clear(); } else { //xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); ialFileList.Clear(); this.lbSentlist.Items.Clear(); } //Response.Redirect("/CLT.WEB.UI.LMS.COMMUNITY/data_list.aspx?BIND=BIND"); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } //finally //{ // ialFileList.Clear(); // ialDeleteList.Clear(); // this.lbSentlist.Items.Clear(); //} }
private void SetGrdList(string gubun) { try { int xCntSel = 0; DataTable xDt = new DataTable(); xDt.Columns.Add("keys"); xDt.Columns.Add("confirm"); xDt.Columns.Add("non_approval_cd"); xDt.Columns.Add("non_approval_remark"); if (gubun == "1") { for (int i = 0; i < this.grdList.Items.Count; i++) { //if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem)this.grdList.Items[i]).FindControl("chk_sel")).Checked) //{ // R.COURSE_ID || '^' || R.OPEN_COURSE_ID || '^' || U.USER_ID||'^'|| R.COURSE_RESULT_SEQ DataRow xRow = xDt.NewRow(); xRow["keys"] = iCourseID + "^" + iOpenCourseID + "^" + grdList.DataKeys[i].ToString(); xRow["confirm"] = ((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("chkConfirm")).Checked ? "1" : "0"; xRow["non_approval_cd"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("ddlNonApproval")).SelectedValue; xRow["non_approval_remark"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdList.Items[i]).FindControl("txtNonApprovalRemark")).Text; xDt.Rows.Add(xRow); xCntSel++; //} } } else if (gubun == "2") { for (int i = 0; i < this.grdUserList.Items.Count; i++) { // R.COURSE_ID || '^' || R.OPEN_COURSE_ID || '^' || U.USER_ID||'^'|| R.COURSE_RESULT_SEQ DataRow xRow = xDt.NewRow(); xRow["keys"] = iCourseID + "^" + iOpenCourseID + "^" + grdUserList.DataKeys[i].ToString(); xRow["confirm"] = ((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdUserList.Items[i]).FindControl("chkConfirm")).Checked ? "1" : "0"; xRow["non_approval_cd"] = ""; xRow["non_approval_remark"] = ""; //xRow["non_approval_cd"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem)this.grdUserList.Items[i]).FindControl("ddlNonApproval")).SelectedValue; //xRow["non_approval_remark"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdUserList.Items[i]).FindControl("txtNonApprovalRemark")).Text; xDt.Rows.Add(xRow); } } if (xCntSel == 0 && gubun == "1") { ScriptHelper.Page_Alert(this.Page, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A047", new string[] { "" }, new string[] { "" }, System.Threading.Thread.CurrentThread.CurrentCulture)); } else { string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md", "SetEduList", LMS_SYSTEM.APPLICATION, "CLT.WEB.UI.LMS.APPLICATION", xDt, ""); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "교육대상자 선발" }, new string[] { "Educational object selection" }, Thread.CurrentThread.CurrentCulture)); //if (iTab == "2") //{ InitControl2(); this.BindGrid(); //BindGrdUserList(""); //} //else //{ // BindGrdList(""); //} } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Administrator" }, Thread.CurrentThread.CurrentCulture)); } } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/************************************************************ * Function name : buttonSave * Purpose : 내용 저장 처리(신규 저장) * Input : void * Output : void *************************************************************/ #region public void buttonSave(Button rbtn) public void buttonSave(Button rbtn) { try { string xRtn = Boolean.FalseString; string xScriptMsg = string.Empty; string xSeq = string.Empty; string[] xSeqParams = new string[2]; xSeqParams[0] = "boa_no"; xSeqParams[1] = "t_board"; xSeq = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMUNITY.vp_y_community_data_md", "GetMaxIDOfCode", LMS_SYSTEM.COMMUNITY, "CLT.WEB.UI.LMS.COMMUNITY.data_edit", (object)xSeqParams); object[] xParams = new object[2]; string[] xMasterParams = new string[4]; xMasterParams[0] = txtSubject.Text.Replace("'", "''"); // 제목 xMasterParams[1] = txtCONTENT.Text.Replace("'", "''"); // 내용 xMasterParams[2] = Session["USER_ID"].ToString(); // 사용자 ID xMasterParams[3] = xSeq; // ID object[,] xDetailParams = new object[ialFileList.Count, 3]; int nCount = 0; foreach (FileUpload attfile in ialFileList) { //HttpPostedFile xFile = (HttpPostedFile)attfile.PostedFile; //Stream stream = xFile.InputStream; //int xGetbyte = 0; //List<byte> bytes = new List<byte>(); //while ((xGetbyte = stream.ReadByte()) > -1) //{ // bytes.Add((byte)xGetbyte); //} //stream.Close(); //List<byte> bytes = new List<byte>(); string[] ffiles = attfile.FileName.Split(new string[] { "\\" }, StringSplitOptions.None); for (int i = 0; i < ffiles.Length; i++) { ffiles[i] = ffiles[i].Replace(" ", "_"); } byte[] bytes = ConvertToFileUpload(attfile); xDetailParams[nCount, 0] = bytes; //bytes.ToArray(); xDetailParams[nCount, 1] = ffiles; //attfile.FileName; nCount++; } xParams[0] = xMasterParams; xParams[1] = xDetailParams; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMUNITY.vp_y_community_data_md", "SetData", LMS_SYSTEM.COMMUNITY, "CLT.WEB.UI.LMS.COMMUNITY", (object)xParams); if (xRtn.ToUpper() == "TRUE") { //xScriptMsg = "<script>alert('정상적으로 처리 완료되었습니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); ViewState["EDITMODE"] = "EDIT"; ViewState["SEQ"] = xSeq; ialFileList.Clear(); } else { //xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); ialFileList.Clear(); this.lbSentlist.Items.Clear(); } //Response.Redirect("/CLT.WEB.UI.LMS.COMMUNITY/data_list.aspx?BIND=BIND"); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } //finally //{ // ialFileList.Clear(); // this.lbSentlist.Items.Clear(); //} }
/************************************************************ * Function name : btnSend_Click * Purpose : * Input : void * Output : void *************************************************************/ protected void btnTemp_Click(object sender, EventArgs e) { try { if (this.IsDataValidation()) { string xlstSubject = string.Empty; string[] xItem = null; for (int i = 0; i < this.lstItemList.Items.Count; i++) { xItem = this.lstItemList.Items[i].Text.Split('|'); xlstSubject += xItem[0].Trim() + "|"; } string[] xParams = new string[2]; xParams[0] = ViewState["COURSE_ID"].ToString(); xParams[1] = xlstSubject; string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.CURR.vp_c_course_md", "SetCourseSubjectSortInfo", LMS_SYSTEM.CURRICULUM, "CLT.WEB.UI.LMS.CURR", (object)xParams); if (xRtn != string.Empty) { //A001: {0}이(가) 저장되었습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "과목 정렬" }, new string[] { "Subject Sort" }, Thread.CurrentThread.CurrentCulture )); ////저장 후 신규 id 값으로 재조회 //ViewState["SUBJECT_ID"] = xRtn; //this.BindData(); } else { //A004: {0}이(가) 입력되지 않았습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "과목 정렬" }, new string[] { "Subject Sort" }, Thread.CurrentThread.CurrentCulture )); } } else { //A012: {0}의 필수 항목 입력이 누락되었습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A012", new string[] { "과목 정렬" }, new string[] { "Subject Sort" }, Thread.CurrentThread.CurrentCulture )); } } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : btnSave_OnClick * Purpose : 저장 버튼클릭 이벤트 * Input : void * Output : void *************************************************************/ #region btnSave_OnClick() protected void btnSave_OnClick(object sender, EventArgs e) { try { string xRtn = Boolean.TrueString; string xScriptContent = string.Empty; string[] xParams = new string[32]; if (this.txtID.Enabled == true) { //ID 중복체크 버튼을 클릭하여 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A104", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); this.txtID.Focus(); return; } else if (string.IsNullOrEmpty(txtPass.Text)) { // 비밀번호를 입력해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A105", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); this.txtPass.Focus(); return; } else if (string.IsNullOrEmpty(this.txtPassCheck.Text)) { //비밀번호 이(가) 입력되지 않았습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "비밀번호" }, new string[] { "Password" }, Thread.CurrentThread.CurrentCulture)); this.txtPassCheck.Focus(); return; } else if (this.txtPass.Text != this.txtPassCheck.Text) { // {0}이(가) 입력되지 않았거나 잘못된 형식입니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A016", new string[] { "비밀번호" }, new string[] { "Password" }, Thread.CurrentThread.CurrentCulture)); this.txtPassCheck.Focus(); return; } else if (string.IsNullOrEmpty(this.txtZipCode.Text)) { // 우편번호를 검색하여 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "우편번호" }, new string[] { "Zip Code" }, Thread.CurrentThread.CurrentCulture)); this.txtZipCode.Focus(); return; } else if (string.IsNullOrEmpty(this.txtAddr1.Text)) { // 주소를 입력해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "주소" }, new string[] { "Address" }, Thread.CurrentThread.CurrentCulture)); this.txtAddr1.Focus(); return; } else if (string.IsNullOrEmpty(this.txtAddr2.Text)) { //xScriptContent = "<script>alert('상세주소를 입력해 주세요!');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "주소" }, new string[] { "Address" }, Thread.CurrentThread.CurrentCulture)); this.txtAddr2.Focus(); return; } else if (string.IsNullOrEmpty(this.txtDept.Text)) { //xScriptContent = "<script>alert('부서를 입력해 주세요!');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "부서" }, new string[] { "Dept" }, Thread.CurrentThread.CurrentCulture)); this.txtDept.Focus(); return; } else if (this.ddlComapnyduty.SelectedItem.Text == "*") { //xScriptContent = "<script>alert('직급을 선택해 주세요!');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "직급" }, new string[] { "Rank" }, Thread.CurrentThread.CurrentCulture)); this.ddlComapnyduty.Focus(); return; } else if (string.IsNullOrEmpty(this.txtEmail.Text)) { //xScriptContent = "<script>alert('Email을 입력해 주세요!');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "E-Mail" }, new string[] { "E-Mail" }, Thread.CurrentThread.CurrentCulture)); this.txtEmail.Focus(); return; } else if (string.IsNullOrEmpty(this.txtMobilePhone.Text)) { //xScriptContent = "<script>alert('휴대폰을 입력해 주세요!');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "휴대폰번호" }, new string[] { "Mobile Phone Number" }, Thread.CurrentThread.CurrentCulture)); this.txtMobilePhone.Focus(); return; } xParams[0] = this.txtID.Text.ToLower().Replace("'", "''"); // 사용자 ID xParams[1] = OpusCryptoLibrary.Cryptography.Encrypt(txtPass.Text.Replace("'", "''"), txtPass.Text.Replace("'", "''")); xParams[2] = ""; xParams[3] = this.txtuser_nm_kor.Text.Replace("'", "''"); // 사용자명 xParams[4] = " "; //주민번호 xParams[5] = txtuser_nm_eng_first.Text.Replace("'", "''"); // 영문성명 First xParams[6] = txtuser_nm_eng_last.Text.Replace("'", "''"); // 영문성명 Last xParams[7] = this.ddlComapnyduty.SelectedItem.Value; // 사용자 직급 xParams[8] = txtDept.Text.Replace("'", "''"); // 부서 xParams[9] = this.txtMobilePhone.Text.Replace("'", "''"); // 사용자 휴대전화번호 xParams[10] = " "; //고용형태 duty_gu xParams[11] = this.txtEmail.Text.Replace("'", "''"); // 메일주소 xParams[12] = this.txtPhone.Text.Replace("'", "''"); // 사무실 전화번호 xParams[13] = " "; // 팩스번호 xParams[14] = " "; // 승인 담당자 admin_id xParams[15] = " "; // 업체 연락처 xParams[16] = " "; // 업체 담당자 xParams[17] = "000004"; // 상태 승인대기 xParams[18] = "WEB"; // 회사ID xParams[19] = txtAcquisition.Text.Replace(".", "").Trim() == string.Empty ? null : txtAcquisition.Text; //고용보험취득일 xParams[20] = "000010"; // 사용자그룹 xParams[21] = " "; // 신분 //socialpos xParams[22] = txtZipCode.Text; // 사용자 우편번호 user_zip_code xParams[23] = txtAddr1.Text + " | " + txtAddr2.Text; // 사용자 주소 user_addr if (rbSMS_y.Checked == true) { xParams[24] = "Y"; // SMS 수신여부 } else { xParams[24] = "N"; // SMS 수신여부 } if (rbMail_y.Checked == true) { xParams[25] = "Y"; // MAIL 수신여부 } else { xParams[25] = "N"; // MAIL 수신여부 } xParams[26] = xParams[0]; xParams[27] = xParams[0]; xParams[28] = "000001"; xParams[29] = txtBirth_dt.Text.Replace(".", "").Trim() == string.Empty ? null : txtBirth_dt.Text; //생년월일 xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md", "SetUser", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", (object)xParams); string[] xResult = xRtn.Split('|'); //if (xRtn.ToUpper() == "TRUE") if (xResult[0].ToUpper() == "TRUE") { bSaveFile(); //ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A129", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); //ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); ScriptHelper.ScriptBlock(this, "join_company_reg", "<script>location.href='/mypage/join_complete.aspx';</script>"); } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); ScriptHelper.ScriptBlock(this, "join_company_reg", "<script>location.href='/';</script>"); } } catch (Exception ex) { base.NotifyError(ex); } }
/****************************************************************************************** * Function name : btnSend_Click * Purpose : 수정, 추가된 항목 저장 후 선박으로 발송 * Input : void * Output : void ******************************************************************************************/ protected void btnSend_Click(object sender, EventArgs e) { try { string xRtn = Boolean.FalseString; string xScriptMsg = string.Empty; // 필수입력항목 체크 //if (string.IsNullOrEmpty(this.txtGrade.Text)) //{ // xScriptMsg = "<script>alert('등급을 입력하여 주세요!');</script>"; // ScriptHelper.ScriptBlock(this, "code_edit", xScriptMsg); // this.txtGrade.Focus(); // return; //} string[] xParams = new string[19]; xParams[1] = this.txtAppBaseDt.Text; xParams[2] = this.ddlStepGu.SelectedItem.Value; xParams[3] = this.ddlAppDutyStep.SelectedItem.Value; xParams[4] = "";//this.ddlAppLang.SelectedItem.Value; xParams[5] = this.ddlVslType.SelectedValue; xParams[6] = this.txtAppItemSeq.Text; xParams[7] = this.txtAppItemNm.Text; xParams[8] = this.txtAppItemNmEng.Text; xParams[9] = this.txtAppItemDesc.Text; xParams[10] = this.txtAppItemDescEng.Text; xParams[11] = this.txtAppCaseSeq.Text; xParams[12] = this.txtAppCaseDesc.Text; xParams[13] = this.txtAppCaseDescEng.Text; xParams[14] = this.hdnCourseOJT.Text; xParams[15] = this.hdnCourseLMS.Text; xParams[16] = this.txtCourseETC.Text; xParams[17] = Session["USER_ID"].ToString(); xParams[18] = ddlVslTypeC.SelectedValue; this.btnSend.Enabled = false; if (IsNew) // 추가 { xParams[0] = ""; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md", "SetApprItemInsert", LMS_SYSTEM.CAPABILITY, "CLT.WEB.UI.LMS.APPR", (object)xParams); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_AlertClose(this.Page, MsgInfo.GetMsg("A001", new string[] { "역량평가항목" }, new string[] { "Competence evaluation items" }, Thread.CurrentThread.CurrentCulture)); } else { ScriptHelper.Page_AlertClose(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Administrator" }, Thread.CurrentThread.CurrentCulture)); } } else // 수정 { xParams[0] = this.txtAppItemNo.Text; xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.APPR.vp_a_appraisal_md", "SetApprItemInsert", LMS_SYSTEM.CAPABILITY, "CLT.WEB.UI.LMS.APPR", (object)xParams); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "역량평가항목" }, new string[] { "Competence evaluation items" }, Thread.CurrentThread.CurrentCulture)); } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Administrator" }, Thread.CurrentThread.CurrentCulture)); } } } catch (Exception ex) { base.NotifyError(ex); } }
/************************************************************ * Function name : Delete() * Purpose : 컨텐츠 목록 데이터 삭제를 위한 처리 * Input : void * Output : void *************************************************************/ #region Delete() public void Delete() { try { string xRtn = Boolean.FalseString; // Update 후 결과값 Return ArrayList xalChk = new ArrayList(); // 사용자 CheckBox for (int i = 0; i < this.C1WebGrid1.Items.Count; i++) { //if (((CheckBox)((C1.Web.C1WebGrid.C1GridItem)this.C1WebGrid1.Items[i]).FindControl("chkEdit")).Checked == true) if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.C1WebGrid1.Items[i]).FindControl("chkEdit")).Checked) { TableCell xTCC = new TableCell(); xTCC = (TableCell)this.C1WebGrid1.Items[i].Cells[10]; // 승인여부 string xCompanyID = this.C1WebGrid1.DataKeys[i].ToString(); // 체크한 그리드의 사용자 Key 값 가져오기 if (!xalChk.Contains(xCompanyID)) { xalChk.Add(xCompanyID); } if (xTCC.Text == "000002") // 미승인상태일 경우 { // A099 {1}를 이미 완료하였음으로 {0}할수 없습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A099", new string[] { "삭제", "삭제" }, new string[] { "Delete", "Delete" }, Thread.CurrentThread.CurrentCulture)); return; } } } if (xalChk.Count == 0) { // 체크박스가 선택되지 않았습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "체크박스" }, new string[] { "Check Box" }, Thread.CurrentThread.CurrentCulture)); return; } string[,] xParams = new string[xalChk.Count, 3]; int xCount = 0; foreach (string xList in xalChk) { xParams[xCount, 0] = xList; // 체크한 Company ID xParams[xCount, 1] = Session["USER_ID"].ToString(); // 로그인한 user ID xParams[xCount, 2] = "000002"; // 공통코드 User Status 사용안함 xCount++; } // 사용자 정보는 Delete 하지 않고 Status 를 사용안함(000002) 으로 처리 xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.MANAGE.vp_m_company_md", "SetCompanyDelete", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", (object)xParams); if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); BindGrid(); } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); } BindGrid(); // 삭제 후 Data 조회 } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/************************************************************* * Function name : Save * Purpose : 회원사 Save 메서드 * Input : void * Output : void *************************************************************/ #region Save() public void Save() { try { string xRtn = Boolean.TrueString; string xScriptContent = string.Empty; if (string.IsNullOrEmpty(this.txtCompanyCode.Text)) { // 회사코드를 입력해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "회사코드" }, new string[] { "Company Code" }, Thread.CurrentThread.CurrentCulture)); this.txtCompanyName.Focus(); return; } else if (string.IsNullOrEmpty(this.txtCompanyName.Text)) { // 회사명을 입력해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "회사명" }, new string[] { "Company Name" }, Thread.CurrentThread.CurrentCulture)); this.txtCompanyName.Focus(); return; } else if (this.ddlCompanyScale.SelectedItem.Text == "*") { // 회사규모를 선택해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "회사규모" }, new string[] { "Company Size" }, Thread.CurrentThread.CurrentCulture)); this.ddlCompanyScale.Focus(); return; } else if (this.ddlCompanyKind.SelectedItem.Text == "*") { // 회사구분을 선택해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "회사구분" }, new string[] { "Company Kind" }, Thread.CurrentThread.CurrentCulture)); this.ddlCompanyScale.Focus(); return; } else if (String.IsNullOrEmpty(this.txtCEOName.Text)) { // 회사규모를 선택해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "회사규모" }, new string[] { "Company Size" }, Thread.CurrentThread.CurrentCulture)); this.ddlCompanyScale.Focus(); return; } else if (string.IsNullOrEmpty(this.txtTex1.Text)) { // 사업자 등록번호를 입력해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "사업자 등록번호" }, new string[] { "Business Registration Number" }, Thread.CurrentThread.CurrentCulture)); this.txtTex1.Focus(); return; } else if (string.IsNullOrEmpty(this.txtTex2.Text)) { // 사업자 등록번호를 입력해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "사업자 등록번호" }, new string[] { "Business Registration Number" }, Thread.CurrentThread.CurrentCulture)); this.txtTex2.Focus(); return; } else if (string.IsNullOrEmpty(this.txtTex3.Text)) { // 사업자 등록번호를 입력해 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "사업자 등록번호" }, new string[] { "Business Registration Number" }, Thread.CurrentThread.CurrentCulture)); this.txtTex3.Focus(); return; } else if (string.IsNullOrEmpty(this.txtZipCode.Text)) { // 우편번호를 검색하여 주세요! ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "우편번호" }, new string[] { "Zip Code" }, Thread.CurrentThread.CurrentCulture)); this.txtZipCode.Focus(); return; } else if (string.IsNullOrEmpty(this.txtPhone.Text)) { //xScriptContent = "<script>alert('전화번호를 입력해 주세요!');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "전화번호" }, new string[] { "Phone Number" }, Thread.CurrentThread.CurrentCulture)); this.txtPhone.Focus(); return; } else if (string.IsNullOrEmpty(this.txtAddr1.Text)) { //xScriptContent = "<script>alert('주소를 입력해 주세요!');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "주소" }, new string[] { "Address" }, Thread.CurrentThread.CurrentCulture)); this.txtAddr1.Focus(); return; } else if (string.IsNullOrEmpty(this.txtAddr2.Text)) { //xScriptContent = "<script>alert('주소를 입력해 주세요!');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "주소" }, new string[] { "Address" }, Thread.CurrentThread.CurrentCulture)); this.txtAddr2.Focus(); return; } string[] xTempParams = new string[2]; string xCompanyID = string.Empty; if (ViewState["EDITMODE"].ToString() == "NEW") // COMPANY_ID가 Null 이면 Insert { // company_id 처리 xTempParams[0] = "t_company"; xTempParams[1] = "company_id"; xCompanyID = SBROKER.GetString("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md", "GetMaxIDOfTable", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE.vp_m_manage_company_edit_wpg", (object)xTempParams); } else { xCompanyID = ViewState["COMPANY_ID"].ToString(); //Request.QueryString["COMPANY_ID"].ToString().ToUpper(); } string[] xParams = new string[20]; xParams[0] = xCompanyID; // 업체ID xParams[1] = this.txtCompanyCode.Text.Replace("'", "''"); // 업체코드 xParams[2] = this.txtCompanyName.Text.Replace("'", "''"); // 업체명 xParams[3] = this.ddlCompanyScale.SelectedValue; // 회사규모 xParams[4] = this.txtTex1.Text.Replace("'", "''") + this.txtTex2.Text.Replace("'", "''") + this.txtTex3.Text.Replace("'", "''"); // 사업자 등록번호 xParams[5] = this.txtRegNo.Text.Replace("'", "''"); // 법인 등록번호 xParams[6] = this.txtEmpoly_Ins.Text.Replace("'", "''"); // 고용 보험번호 xParams[7] = this.txtCEOName.Text.Replace("'", "''"); // 대표자명 xParams[8] = this.txtHomePage.Text.Replace("'", "''"); // 홈페이지 xParams[9] = this.txtBusi.Text.Replace("'", "''"); // 업태 xParams[10] = this.txtCompanyType.Text.Replace("'", "''"); // 종목 xParams[11] = this.txtZipCode.Text.Replace("'", "''"); // 우편번호 xParams[12] = this.txtAddr1.Text.Replace("'", "''") + " | " + this.txtAddr2.Text.Replace("'", "''"); // 주소 xParams[13] = this.txtPhone.Text.Replace("'", "''"); // 전화번호 xParams[14] = this.txtFax.Text.Replace("'", "''"); // 팩스번호 xParams[15] = Session["USER_ID"].ToString(); // 사용자 ID xParams[16] = ddlCompanyKind.SelectedItem.Value; // 회사구분 xParams[17] = txtCompanyEngName.Text.Replace("'", "''"); // 회사명(영문) xParams[18] = txtEmpCountVessel.Text.Replace("'", "''"); // 근로자수(해상직원) xParams[19] = txtEmpCountShore.Text.Replace("'", "''"); // 근로자수(육상직원) if (ViewState["EDITMODE"].ToString() == "NEW") // EDIT Mode가 아니면 INSERT { //2014.03.19 seojw //회사코드 중복 체크 DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_company_md", "GetCompanyDup", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", (object)xParams); //동일한 회사코드가 있을 경우 if (xDt.Rows[0]["CNT"].ToString() != "0") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A014", new string[] { "회사코드" }, new string[] { "Company Code" }, Thread.CurrentThread.CurrentCulture)); return; } xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.MANAGE.vp_m_company_md", "SetCompanyInfo", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", (object)xParams); } else { xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.MANAGE.vp_m_company_md", "SetCompanyInfoUpdate", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", (object)xParams); } if (xRtn.ToUpper() == "TRUE") { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); //ScriptHelper.ScriptBlock(this, "vp_m_manage_user_reg_wpg", "<script>self.close()</script>"); ViewState["EDITMODE"] = "EDIT"; ViewState["COMPANY_ID"] = xCompanyID; } else { ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); //ScriptHelper.ScriptBlock(this, "vp_m_manage_user_reg_wpg", "<script>self.close()</script>"); } } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/************************************************************ * Function name : Reject() * Purpose : 승인취소 * Input : void * Output : void *************************************************************/ #region Reject() public void Reject() { try { string xRtn = Boolean.FalseString; // Update 후 결과값 Return ArrayList xalChk = new ArrayList(); // 사용자 CheckBox for (int i = 0; i < this.C1WebGrid1.Items.Count; i++) { //if (((CheckBox)((C1.Web.C1WebGrid.C1GridItem)this.C1WebGrid1.Items[i]).FindControl("chkEdit")).Checked == true) if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.C1WebGrid1.Items[i]).FindControl("chkEdit")).Checked) { TableCell xTCC = new TableCell(); xTCC = (TableCell)this.C1WebGrid1.Items[i].Cells[10]; // 승인여부 string xUserID = this.C1WebGrid1.DataKeys[i].ToString(); // 체크한 그리드의 사용자 Key 값 가져오기 if (xTCC.Text == "000004" || xTCC.Text == "000003") // 승인대기 상태가 아닐경우 { if (!xalChk.Contains(xUserID)) { xalChk.Add(xUserID); } } else { //xScriptMsg = string.Format("<script>alert('승인 또는 승인 대기 상태의 ID가 아닙니다! 사용자ID : {0}');</script>", xUserID); ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A117", new string[] { xUserID }, new string[] { xUserID }, Thread.CurrentThread.CurrentCulture)); return; } } } if (xalChk.Count == 0) { // 체크박스가 선택되지 않았습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "체크박스" }, new string[] { "Check Box" }, Thread.CurrentThread.CurrentCulture)); return; } string[,] xParams = new string[xalChk.Count, 3]; int xCount = 0; foreach (string xList in xalChk) { xParams[xCount, 0] = xList; // 체크한 user ID xParams[xCount, 1] = Session["USER_ID"].ToString(); // 로그인한 user ID xParams[xCount, 2] = "000001"; // 공통코드 User Status 미승인 xCount++; } // 사용자 정보는 Delete 하지 않고 Status 를 사용안함(000002) 으로 처리 xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.MANAGE.vp_m_company_md", "SetCompanyDelete", LMS_SYSTEM.MANAGE, "CLT.WEB.UI.LMS.MANAGE", (object)xParams); if (xRtn.ToUpper() == "TRUE") { //xScriptMsg = "<script>alert('정상적으로 처리 완료되었습니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); BindGrid(); } else { //xScriptMsg = "<script>alert('정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다.');</script>"; ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); } BindGrid(); // 승인 후 Data 조회 } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy"); if (rethrow) { throw; } } }
/************************************************************ * Function name : btnSend_Click * Purpose : 엑셀업로드버튼 클릭 이벤트 * Input : void * Output : void *************************************************************/ #region protected void btnSend_Click(object sender, EventArgs e) protected void btnSend_Click(object sender, EventArgs e) { try { int xCntSel = 0; DataTable xDt = new DataTable(); xDt.Columns.Add("ID"); // 사용자ID xDt.Columns.Add("PWD"); // 비밀번호 xDt.Columns.Add("USER_NM_KOR"); xDt.Columns.Add("PERSONAL_NO"); xDt.Columns.Add("USER_NM_ENG_FIRST"); xDt.Columns.Add("USER_NM_ENG_LAST"); xDt.Columns.Add("USER_ZIP_CODE"); xDt.Columns.Add("USER_ADDR1"); //xDt.Columns.Add("USER_ADDR2"); xDt.Columns.Add("DUTY_STEP"); xDt.Columns.Add("OFFICE_PHONE"); xDt.Columns.Add("EMAIL_ID"); xDt.Columns.Add("MOBILE_PHONE"); //xDt.Columns.Add("SMS_YN"); //xDt.Columns.Add("MAIL_YN"); xDt.Columns.Add("TRAINEE_CLASS"); xDt.Columns.Add("ENTER_DT"); xDt.Columns.Add("USER_ID"); xDt.Columns.Add("USER_GROUP"); xDt.Columns.Add("COMPANY_ID"); xDt.Columns.Add("STATUS"); xDt.Columns.Add("ADMIN_PHONE"); for (int i = 0; i < this.grdItem.Items.Count; i++) { if (((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("chk_sel")).Checked) { //DataRow[] xDrs = xDt.Select(string.Format("ID ='{0}'", ((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("txtID")).Text.Replace("'", "''"))); //if (xDrs.Length > 0) //{ // string xID = ((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("txtID")).Text.ToLower().Trim().Replace("'", "''"); // ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A121", new string[] { "ID", xID }, new string[] { "ID", xID }, Thread.CurrentThread.CurrentCulture)); // return; //} //string[] xParams = new string[1]; //xParams[0] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("txtID")).Text.ToLower().Trim().Trim().Replace("'", "''"); //// ID 중복체크 //DataTable xdt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md", // "GetUser", // LMS_SYSTEM.MANAGE, // "CLT.WEB.UI.LMS.MANAGE", // (object)xParams); //if (xdt.Rows.Count > 0) //{ // string xID = ((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("txtID")).Text.ToLower().Trim().Replace("'", "''"); // ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A121", new string[] { "ID", xID }, new string[] { "ID", xID }, Thread.CurrentThread.CurrentCulture)); // return; //} DataRow xRow = xDt.NewRow(); xRow["ID"] = string.Empty; //((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("txtID")).Text.ToLower().Trim().Replace("'", "''"); //xRow["PWD"] = (string)xx.Encrypt(((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("txtPesonalNo")).Text.Replace("'", "''").Substring(7, 7)); // "lC0o7ueTCeuroZc8ZrLMNg=="; xRow["PWD"] = OpusCryptoLibrary.Cryptography.Encrypt("", ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtPesonalNo")).Text.Replace("'", "''").Substring(7, 7)); xRow["USER_NM_KOR"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtUserNMKor")).Text.Replace("'", "''").Trim(); xRow["PERSONAL_NO"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtPesonalNo")).Text.Replace("'", "''").Trim(); xRow["USER_NM_ENG_FIRST"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtUserNMEngFirst")).Text.Replace("'", "''").Trim(); xRow["USER_NM_ENG_LAST"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtUserNMEngLast")).Text.Replace("'", "''").Trim(); xRow["USER_ZIP_CODE"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtZipCode")).Text.Replace("'", "''").Trim(); xRow["USER_ADDR1"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAddress1")).Text.Replace("'", "''"); //xRow["USER_ADDR2"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("txtAddress2")).Text.Replace("'", "''"); xRow["DUTY_STEP"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("ddlDutyStep")).SelectedValue; xRow["OFFICE_PHONE"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtPhone")).Text.Replace("'", "''").Trim(); xRow["EMAIL_ID"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtEMail")).Text.Replace("'", "''").Trim(); xRow["MOBILE_PHONE"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtMobilePhone")).Text.Replace("'", "''").Trim(); //xRow["SMS_YN"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("txtSMS_YN")).Text.Replace("'", "''"); //xRow["MAIL_YN"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem)this.grdItem.Items[i]).FindControl("txtMAIL_YN")).Text.Replace("'", "''"); xRow["TRAINEE_CLASS"] = ((DropDownList)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("ddlTraineeClass")).SelectedValue; xRow["ENTER_DT"] = ((TextBox)((C1.Web.C1WebGrid.C1GridItem) this.grdItem.Items[i]).FindControl("txtAcquisition")).Text.Replace("'", "''").Trim(); xRow["USER_ID"] = Session["USER_ID"].ToString(); xRow["USER_GROUP"] = "000008"; // 법인사 수강자 xRow["COMPANY_ID"] = Session["COMPANY_ID"].ToString(); xRow["STATUS"] = "000003"; // 사용자 상태 [승인] status xRow["ADMIN_PHONE"] = Session["OFFICE_PHONE"].ToString(); xDt.Rows.Add(xRow); } } if (xDt.Rows.Count > 0) { object[] obj = new object[1]; obj[0] = (object)xDt; string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md", "SetUserUpload", LMS_SYSTEM.MANAGE, "vp_m_manage_user_excel_wpg", (object)obj); if (xRtn.ToUpper() == "TRUE") { // 정상적으로 처리 되었습니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A054", new string[] { "처리" }, new string[] { "Processed" }, Thread.CurrentThread.CurrentCulture)); } else { // 정상적으로 처리되지 않았으니, 관리자에게 문의 바랍니다. ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A103", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture)); } } else { ScriptHelper.Page_Alert(this, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A047", new string[] { "" }, new string[] { "" }, System.Threading.Thread.CurrentThread.CurrentCulture)); } } catch (Exception ex) { base.NotifyError(ex); } }