示例#1
0
        /************************************************************
         * Function name : btnRemove_OnClick
         * Purpose       : 버튼클릭 이벤트
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void btnRemove_OnClick(object sender, EventArgs e)
        protected void btnRemove_OnClick(object sender, EventArgs e)
        {
            try
            {
                if (lbSentlist.SelectedItem == null)
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A049", new string[] { "삭제할 파일" }, new string[] { "Attachment File" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                foreach (FileUpload Temp in ialFileList)
                {
                    if (Temp.FileName == lbSentlist.SelectedItem.Text)
                    {
                        ialFileList.Remove(Temp);
                        lbSentlist.Items.Remove(lbSentlist.SelectedItem);
                        break;
                    }
                }
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
        /************************************************************
         * 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;
                }
            }
        }
示例#3
0
        /************************************************************
         * Function name : btn_Plus_OnClick
         * Purpose       : SMS 전송 리스트 추가
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void btn_Plus_OnClick(object sender, EventArgs e)
        protected void btn_Plus_OnClick(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(this.txtName.Text))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "이름" }, new string[] { "Name" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }
                else if (string.IsNullOrEmpty(this.txtMobilePhone.Text))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "휴대폰 번호" }, new string[] { "Mobile Phone" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                if (!SentSMSDuplicate(this.lbSentlist, this.txtMobilePhone.Text))
                {
                    this.lbSentlist.Items.Add(new ListItem(this.txtName.Text + " : " + Regex.Replace(this.txtMobilePhone.Text, @"\D", ""), "0"));
                }

                this.lblSendCnt.Text     = TotalCount();
                this.txtName.Text        = "";
                this.txtMobilePhone.Text = "";
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#4
0
        /************************************************************
         * Function name : btnSearch_Click
         * Purpose       : 기간별 개설과정 조회버튼
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void btnSearch_Click(object sender, EventArgs e)
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(this.txtCus_From.Text))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "조회기간" }, new string[] { "Date From" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }
                else if (string.IsNullOrEmpty(this.txtCus_To.Text))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "조회기간" }, new string[] { "Date To" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                string[] xParams = new string[2];
                xParams[0] = this.txtCus_From.Text;
                xParams[1] = this.txtCus_To.Text;

                this.ddlCus_Date.ClearSelection();

                DataTable xDt = new DataTable();
                xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_m_sms_md",
                                       "GetCourseDate",
                                       LMS_SYSTEM.APPLICATION,
                                       "CLT.WEB.UI.LMS.APPLICATION", (object)xParams, Thread.CurrentThread.CurrentCulture);

                WebControlHelper.SetDropDownList(this.ddlCus_NM, xDt, "course_nm", "course_id");
                //this.ddlCus_NM.Items.FindByValue("11030001").Selected = true;
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#5
0
 /******************************************************************************************
 * Function name : txtProgressRate_TextChanged
 * Purpose       : total 하기 (progressRate + final test = total score)
 * Input         : void
 * Output        : void
 ******************************************************************************************/
 #region protected void txtProgressRate_TextChanged(object sender, EventArgs e)
 protected void txtProgressRate_TextChanged(object sender, EventArgs e)
 {
     try
     {
         int xpro   = Convert.ToInt32(this.txtProgressRate.Text == string.Empty ? "0" : this.txtProgressRate.Text);
         int xfinal = Convert.ToInt32(this.txtFinalTest.Text == string.Empty ? "0" : this.txtFinalTest.Text);
         if (xpro + xfinal > 100)
         {
             //A030  : <KO>{0}이(가) {1}보다 큽니다.<
             ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A030",
                                                               new string[] { this.lblTotalScore.Text, "100" },
                                                               new string[] { this.lblTotalScore.Text, "100" },
                                                               Thread.CurrentThread.CurrentCulture
                                                               ));
         }
         else
         {
             this.txtTotalScore.Text = Convert.ToString(xpro + xfinal);
         }
     }
     catch (Exception ex)
     {
         base.NotifyError(ex);
     }
 }
示例#6
0
        /************************************************************
         * Function name : btnUpload_OnClick
         * Purpose       : 버튼클릭 이벤트
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void btnUpload_OnClick(object sender, EventArgs e)
        protected void btnUpload_OnClick(object sender, EventArgs e)
        {
            try
            {
                if (this.FileUpload1.PostedFile.ContentLength == 0)
                {
                    // 첨부파일이 없습니다.
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A062", new string[] { "첨부파일" }, new string[] { "Attachment" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                int xfileSize = this.FileUpload1.PostedFile.ContentLength;

                int TotalSize = 0;

                TotalSize = TotalSize + this.FileUpload1.PostedFile.ContentLength;

                if (this.lbSentlist.Items.Count >= 3) // 첨부파일은 최대 3개까지 가능

                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A007", new string[] { "첨부파일", "3개" }, new string[] { "Attachment", "3 File" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }
                else if (lbSentlist.Items.Contains(new ListItem(this.FileUpload1.FileName)))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A014", new string[] { this.FileUpload1.FileName }, new string[] { this.FileUpload1.FileName }, Thread.CurrentThread.CurrentCulture));
                    return;
                }
                else if (TotalSize > 4194302)
                {
                    // 첨부파일이 4메가 보다 큽니다.
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A030", new string[] { "첨부파일", "4메가" }, new string[] { "Attachment", "4MB" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                /*
                 * foreach (FileUpload fUpload in lbSentlist.Items)
                 * {
                 *  TotalSize = TotalSize + fUpload.PostedFile.ContentLength;
                 *  if (TotalSize > 4194302)
                 *  {
                 *      // 첨부파일이 4메가 보다 큽니다.
                 *      ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A030", new string[] { "첨부파일", "4메가" }, new string[] { "Attachment", "4MB" }, Thread.CurrentThread.CurrentCulture));
                 *      return;
                 *  }
                 * }
                 */
                if (!ialFileList.Contains(this.FileUpload1))
                {
                    ialFileList.Add(this.FileUpload1);
                }

                lbSentlist.Items.Add(new ListItem(this.FileUpload1.FileName));
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#7
0
 /************************************************************
  * Function name : button_Click
  * Purpose       : 버튼클릭 이벤트 (btnRetrieve, btnDelete, btnApploval, btnUseage, btnExcel)
  * Input         : void
  * Output        : void
  *************************************************************/
 #region button_Click(object seder, EventArgs e)
 protected void button_Click(object seder, EventArgs e)
 {
     try
     {
         Button btn = (Button)seder;
         if (btn.ID == "btnRetrieve") // 조회
         {
             if (!string.IsNullOrEmpty(txtCreated_From.Text) && string.IsNullOrEmpty(txtCreated_To.Text))
             {
                 ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A039", new string[] { "가입기간" }, new string[] { "Period" }, Thread.CurrentThread.CurrentCulture));
                 return;
             }
             else if (string.IsNullOrEmpty(txtCreated_From.Text) && !string.IsNullOrEmpty(txtCreated_To.Text))
             {
                 ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A039", new string[] { "가입기간" }, new string[] { "Period" }, Thread.CurrentThread.CurrentCulture));
                 return;
             }
             BindGrid();
         }
         else if (btn.ID == "btnDelete") // 삭제
         {
             Delete();
             PageInfo1.CurrentPageIndex      = 1;
             PageNavigator1.CurrentPageIndex = 1;
         }
         else if (btn.ID == "btnExcel") // 엑셀출력
         {
             Excel();
         }
         else if (btn.ID == "btnApploval") // 승인요청
         {
             Apploval();
             PageInfo1.CurrentPageIndex      = 1;
             PageNavigator1.CurrentPageIndex = 1;
         }
         else if (btn.ID == "btnUseage") // 승인
         {
             Useage();
             PageInfo1.CurrentPageIndex      = 1;
             PageNavigator1.CurrentPageIndex = 1;
         }
         else if (btn.ID == "btnReject") // 승인취소
         {
             Reject();
             PageInfo1.CurrentPageIndex      = 1;
             PageNavigator1.CurrentPageIndex = 1;
         }
         else if (btn.ID == "btnNew") // 신규등록
         {
             //string xScriptContent = string.Format("<script>openPopWindow('/manage/company_edit.aspx?EDITMODE=NEW&MenuCode={0}', 'company_list', '800', '298');</script>", Session["MENU_CODE"]);
             //ScriptHelper.ScriptBlock(this, "company_list", xScriptContent);
         }
     }
     catch (Exception ex)
     {
         base.NotifyError(ex);
     }
 }
示例#8
0
        /************************************************************
         * Function name : Page_Load
         * Purpose       : Page Load 이벤트
         * Input         : void
         * Output        : void
         *************************************************************/
        #region Page_Load(object sender, EventArgs e)
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (Session["USER_GROUP"].ToString() == this.GuestUserID)
                {
                    string xScriptMsg = string.Format("<script>alert('사용권한이 없습니다.');window.close();</script>", Session["MENU_CODE"]);
                    ScriptHelper.ScriptBlock(this, "lecturer_edit", xScriptMsg);

                    return;
                }

                if (Request.QueryString["EDITMODE"] == null)  // 받는값이 없으면 창종료...
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A102", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture));
                    ScriptHelper.ScriptBlock(this, "lecturer_edit", "<script>self.close()</script>");
                    return;
                }

                if (!IsPostBack)
                {
                    //this.Page.Form.DefaultButton = this.btnRetrieve.UniqueID; // Page Default Button Mapping
                    this.txtZipCode.Attributes.Add("ReadOnly", "ReadOnly");
                    BindDropDownList();
                    ViewState["EDITMODE"] = Request.QueryString["EDITMODE"];

                    if (Request.QueryString["LECTURER_ID"] != null)
                    {
                        ViewState["LECTURER_ID"] = Request.QueryString["LECTURER_ID"].ToString();
                    }

                    if (Request.QueryString["EDITMODE"] != null)
                    {
                        if (Request.QueryString["LECTURER_ID"] == null)
                        {
                            return;
                        }

                        if (ViewState["EDITMODE"].ToString() == "EDIT") // 수정이면
                        {
                            EDIT(ViewState["EDITMODE"].ToString());

                            this.hidLecturerID.Value = ViewState["LECTURER_ID"].ToString();
                        }
                    }
                    base.pRender(this.Page,
                                 new object[, ] { //{ this.btnCancle, "I" },
                        //{ this.btnRewrite, "I" },
                        { this.btnSave, "E" },
                    },
                                 Convert.ToString(Request.QueryString["MenuCode"]));
                }
            }
            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);
            }
        }
示例#10
0
        /************************************************************
         * Function name : Page_Load
         * Purpose       : 수강신청 페이지 Load 이벤트
         *
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void Page_Load(object sender, EventArgs e)
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (Session["USER_GROUP"].ToString() == this.GuestUserID)
                {
                    string xScriptMsg = string.Format("<script>alert('사용권한이 없습니다.');window.location.href='/';</script>", Session["MENU_CODE"]);
                    ScriptHelper.ScriptBlock(this, "courseapplication_detail", xScriptMsg);

                    return;
                }

                this.Page.Form.DefaultButton = this.btnList.UniqueID; // Page Default Button Mapping

                if ((Request.QueryString["ropen_course_id"] != null && Request.QueryString["ropen_course_id"].ToString() != ""))
                {
                    if (!IsPostBack)
                    {
                        base.pRender(this.Page,
                                     new object[, ] {
                            { this.btnApplication, "E" },
                        },
                                     Convert.ToString(Request.QueryString["MenuCode"]));


                        if (Request.QueryString["rapproval_code"] != null)
                        {
                            ViewState["rapproval_code"] = Request.QueryString["rapproval_code"].ToString();
                        }
                        else
                        {
                            ViewState["rapproval_code"] = string.Empty;
                        }

                        ViewState["course_yn"] = Boolean.FalseString;  // 필수직급 여부
                        BindData(Request.QueryString["ropen_course_id"]);
                    }
                }
                else
                {
                    return;
                    //string xScriptContent = "<script>alert('잘못된 경로를 통해 접근하였습니다.');self.close();</script>";
                    //ScriptHelper.ScriptBlock(this, "courseapplication_detail", xScriptContent);
                }

                if (!CheckData())
                {
                    btnApplication.OnClientClick = "return confirm('" + MsgInfo.GetMsg("A027", new string[] { "수강신청 인원이 정원에 초과되었습니다. 그래도 수강신청" },
                                                                                       new string[] { "The number of students for the course has been exceeded. Course Registration" },
                                                                                       Thread.CurrentThread.CurrentCulture) + "');";
                }
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#11
0
        /************************************************************
         * Function name : btnExcel_Click
         * Purpose       : 엑셀버튼 클릭 이벤트 핸들러
         *                 (조회한 자료 엑셀 출력용)
         * Input         : void
         * Output        : void
         *************************************************************/
        protected void btnExcel_Click(object sender, EventArgs e)
        {
            try
            {
                string[]  xParams = new string[7];
                DataTable xDt     = null;

                xParams[0] = this.PageSize.ToString();
                xParams[1] = this.CurrentPageIndex.ToString();
                xParams[2] = string.Empty;
                xParams[3] = string.Empty;
                xParams[4] = string.Empty;
                xParams[5] = string.Empty;
                xParams[6] = "EXCEL";


                if (!string.IsNullOrEmpty(this.txtM_CD.Text))
                {
                    xParams[2] = this.txtM_CD.Text.Replace("'", "''");  // Master Code
                }
                if (!string.IsNullOrEmpty(this.txtM_DESC.Text))
                {
                    xParams[3] = this.txtM_DESC.Text.Replace("'", "''"); // Master Code 명
                }
                if (!string.IsNullOrEmpty(this.txtM_ENM.Text))
                {
                    xParams[4] = this.txtM_ENM.Text.Replace("'", "''"); // Master Code 영문명
                }
                if (!string.IsNullOrEmpty(this.txtM_KNM.Text))
                {
                    xParams[5] = this.txtM_KNM.Text.Replace("'", "''");  // Master Code 한글명
                }
                xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_mastercode_md",
                                       "GetMasterCode",
                                       LMS_SYSTEM.MANAGE,
                                       "CLT.WEB.UI.LMS.MANAGE.codemaster_list",
                                       (object)xParams);


                if (xDt.Rows.Count == 0)
                {
                    // 자료가 없습니다!
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A062", new string[] { "자료" }, new string[] { "Data" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                if (xDt.Rows.Count > 0)
                {
                    GetExcelFile(xDt, xHeader);
                }
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#12
0
        /************************************************************
         * Function name : btnUpload_OnClick
         * Purpose       : 첨부파일 업로드 버튼 이벤트
         *
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void btnUpload_OnClick(object sender, EventArgs e)
        protected void btnUpload_OnClick(object sender, EventArgs e)
        {
            try
            {
                if (this.FileUpload1.PostedFile.ContentLength == 0)
                {
                    // 첨부파일이 없습니다.
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A062", new string[] { "첨부파일" }, new string[] { "Attachment" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                /*
                 * if (this.FileUpload1.PostedFile.ContentLength > 2097151)
                 * {
                 *  // 첨부파일이 2메가 보다 큽니다.
                 *  ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A030", new string[] { "첨부파일", "2메가" }, new string[] { "Attachment", "2MB" }, Thread.CurrentThread.CurrentCulture));
                 *  return;
                 * }
                 */
                int xfileSize = this.FileUpload1.PostedFile.ContentLength;

                if (this.lbSentlist.Items.Count >= 3) // 첨부파일은 최대 3개까지 가능

                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A007", new string[] { "첨부파일", "3개" }, new string[] { "Attachment", "3 File" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }
                //else if (lbSentlist.Items.Contains(new ListItem(this.FileUpload1.FileName)))
                //{
                //    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A007", new string[] { "첨부파일", "1개" }, new string[] { "Attachment", "1 File" }, Thread.CurrentThread.CurrentCulture));
                //    return;
                //}

                if (!ialFileList.Contains(this.FileUpload1))
                {
                    ialFileList.Add(this.FileUpload1);
                }


                ListItem Items = new ListItem();


                lbSentlist.Items.Add(new ListItem(this.FileUpload1.FileName, "NEW"));

                //if (!ialFileList.Contains(this.FileUpload1))
                //    ialFileList.Add(this.FileUpload1);

                //lbSentlist.Items.Add(new ListItem(this.FileUpload1.FileName, "NEW"));
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#13
0
        /************************************************************
         * Function name : btnRetrieve_Click
         * Purpose       :
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void btnAdd_Click(object sender, EventArgs e)
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                bool check;

                //iarrUser
                int    xCnt    = 0;
                string xUserId = string.Empty;
                string xUserNm = string.Empty;

                for (int i = 0; i < this.grd.Items.Count; i++)
                {
                    check = ((HtmlInputCheckBox)((C1.Web.C1WebGrid.C1GridItem) this.grd.Items[i]).FindControl("chk")).Checked;
                    //check = ((CheckBox)this.grd.Items[i].FindControl("chk")).Checked;
                    if (check)
                    {
                        xUserId        = this.grd.Items[i].Cells[0].Text.Trim(); //user_id
                        xUserNm        = this.grd.Items[i].Cells[1].Text.Trim(); //user_nm_kor
                        this.iarrUser += "凸" + xUserId + "|" + xUserNm;
                        xCnt++;
                    }
                }

                if (xCnt > iUseMan)   //개설된 정원보다 신청 인원이 초과할 경우 체크
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A007",
                                                                      new string[] { "교육접수", +iManTotCnt + "명" },
                                                                      new string[] { "Training Received", iManTotCnt + "Persons" },
                                                                      Thread.CurrentThread.CurrentCulture
                                                                      ));
                    return;
                }
                if (this.iarrUser == string.Empty)
                {
                    //A018 Please do {0} first
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A018",
                                                                      new string[] { "Select" },
                                                                      new string[] { "Select" },
                                                                      Thread.CurrentThread.CurrentCulture
                                                                      ));
                }
                else
                {
                    this.iarrUser = (String.IsNullOrEmpty(iarrUser) ? string.Empty : this.iarrUser.Substring(1));
                    ClientScript.RegisterStartupScript(this.GetType(), "OK", "<script language='javascript'>OK();</script>");
                }
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#14
0
        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);
            }
        }
示例#15
0
        /************************************************************
         * Function name : Excel()
         * Purpose       : 엑셀출력
         * Input         : void
         * Output        : void
         *************************************************************/
        #region Excel()
        public void Excel()
        {
            try
            {
                string[] xParams = new string[9];

                xParams[0] = this.PageSize.ToString();
                xParams[1] = this.CurrentPageIndex.ToString();
                xParams[2] = this.txtCompany.Text;      // 회사명

                xParams[3] = this.txtCreated_From.Text; // 가입기간 From
                xParams[4] = this.txtCreated_To.Text;   // 가입기간 To

                if (this.ddlStatus.SelectedItem.Text != "*")
                {
                    xParams[5] = this.ddlStatus.SelectedItem.Value;  // 승인여부
                }
                else
                {
                    xParams[5] = string.Empty;
                }

                xParams[6] = Session["USER_GROUP"].ToString(); // 로그인 사용자 그룹
                xParams[7] = Session["COMPANY_ID"].ToString(); // 로그인 사용자가 관리자가 아닐 경우 자기가 소속된 법인사만 조회된다.
                xParams[8] = "N";
                DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_company_md",
                                                 "GetCompany",
                                                 LMS_SYSTEM.MANAGE,
                                                 "CLT.WEB.UI.LMS.MANAGE",
                                                 (object)xParams);

                if (xDt.Rows.Count == 0)
                {
                    // 자료가 없습니다!
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A062", new string[] { "자료" }, new string[] { "Data" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                if (xDt.Rows.Count > 0)
                {
                    GetExcelFile(xDt, xHeader);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
示例#16
0
        /************************************************************
         * Function name : btnSurvey_OnClick
         * Purpose       : 설문조사 페이지 이동
         * Input         : void
         * Output        : void
         *************************************************************/
        #region btnSurvey_OnClick(object sender, EventArgs e)
        protected void btnSurvey_OnClick(object sender, EventArgs e)
        {
            try
            {
                //진도율 100% 인지 확인
                string[] xParams = new string[2];
                xParams[0] = ViewState["OPEN_COURSE_ID"].ToString();
                xParams[1] = Session["user_id"].ToString();

                DataTable dt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MYPAGE.vp_p_study_md",
                                                "GetExamProgress",
                                                LMS_SYSTEM.MYPAGE,
                                                "CLT.WEB.UI.LMS.MYPAGE", (object)xParams);
                if (dt.Rows.Count > 0)
                {
                    DataRow dr = dt.Rows[0];

                    if (Convert.ToInt32(dr["PROGRESS_RATE"].ToString()) == 100) // 진도율이 100% 일때
                    {
                        //<a id="res_sub1" href="/community/survey_answer_detail.aspx?rResNo=<%# DataBinder.Eval(Container.DataItem, "res_no")%>&rRes_sub=<%# DataBinder.Eval(Container.DataItem, "res_sub")%>&rRes_object=<%# DataBinder.Eval(Container.DataItem, "res_object")%>&rRes_date=<%# DataBinder.Eval(Container.DataItem, "res_date")%>&rAnswer_yn=N"><%# DataBinder.Eval(Container.DataItem, "res_sub")%></a>
                        //string xURL = string.Format("<script>opener.parent.window.location.href='/community/survey_answer_list_wpg.aspx?OPEN_COURSE_ID={0}&USER_ID={1}';opener.focus();</script>", ViewState["OPEN_COURSE_ID"], Session["USER_ID"].ToString());

                        DataTable dtSurvey = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_survey_md",
                                                              "GetSurveyAnswerInfo",
                                                              LMS_SYSTEM.MYPAGE,
                                                              "CLT.WEB.BIZ.LMS.MANAGE", (object)ViewState["OPEN_COURSE_ID"]);
                        if (dtSurvey.Rows.Count > 0)
                        {
                            string ResNo      = dtSurvey.Rows[0]["res_no"].ToString();
                            string Res_sub    = dtSurvey.Rows[0]["res_sub"].ToString();
                            string Res_object = dtSurvey.Rows[0]["res_object"].ToString();
                            string Res_date   = dtSurvey.Rows[0]["Res_date"].ToString();

                            string xURL = string.Format("<script>opener.parent.window.location.href='/community/survey_answer_detail.aspx?rResNo={0}&rRes_sub={1}&rRes_object={2}&rRes_date={3}&rAnswer_yn=N';opener.focus();</script>", ResNo, Res_sub, Res_object, Res_date);
                            Response.Write(xURL);
                        }
                        return;
                    }
                }

                ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A018",
                                                                  new string[] { "학습" },
                                                                  new string[] { "Study" },
                                                                  Thread.CurrentThread.CurrentCulture
                                                                  ));
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#17
0
        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);
            }
        }
        /************************************************************
         * 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;
                }
            }
        }
        /************************************************************
         * Function name : btnSend_Click
         * Purpose       : 저장, 수정버튼 클릭 이벤트 핸들러
         *
         * Input         : void
         * Output        : void
         *************************************************************/
        protected void btnSend_Click(object sender, EventArgs e)
        {
            try
            {
                string xScriptMsg = string.Empty;

                // 필수입력항목 체크

                if (string.IsNullOrEmpty(this.txtCodeMaster_KNM.Text))
                {
                    //xScriptMsg = "<script>alert('한글명을 클릭하여 주세요!');</script>";
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "한글명" }, new string[] { "Kor Name" }, Thread.CurrentThread.CurrentCulture));
                    this.txtCodeMaster_KNM.Focus();
                }

                else if (string.IsNullOrEmpty(this.txtCodeMaster_ENM.Text))
                {
                    //xScriptMsg = "<script>alert('영문명을 클릭하여 주세요!');</script>";
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "영문명" }, new string[] { "Eng Name" }, Thread.CurrentThread.CurrentCulture));
                    this.txtCodeMaster_ENM.Focus();
                }

                else if (string.IsNullOrEmpty(this.txtMasterCode_NM.Text))
                {
                    //xScriptMsg = "<script>alert('코드명을 클릭하여 주세요!');</script>";
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "코드명" }, new string[] { "Code Name" }, Thread.CurrentThread.CurrentCulture));
                    this.txtMasterCode_NM.Focus();
                }


                // 메세지가 존재할 경우 메세지를 출력하고 Return
                if (!string.IsNullOrEmpty(xScriptMsg))
                {
                    Response.Write(xScriptMsg);
                    return;
                }

                if (Request.QueryString["openerEditMode"].ToString() == "d_cd_new")   // DetailCode 신규등록일 경우...
                {
                    DetailInsertCode();
                }
                else if (Request.QueryString["openerEditMode"].ToString() == "d_cd_edit")  // DetailCode 수정일 경우...
                {
                    DetailUpdateCode();
                }
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#20
0
        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);
            }
        }
示例#21
0
        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);
            }
        }
示例#22
0
        /************************************************************
         * Function name : btnExcel_Click
         * Purpose       : 엑셀출력 버튼 이벤트
         *
         * Input         : void
         * Output        : void
         *************************************************************/
        #region btnExcel_Click(object sender, EventArgs e)
        protected void btnExcel_Click(object sender, EventArgs e)
        {
            try
            {
                string[]  xParams = new string[7];
                DataTable xDt     = null;

                xParams[0] = this.PageSize.ToString();
                xParams[1] = this.CurrentPageIndex.ToString();
                if (!string.IsNullOrEmpty(txtRes_From.Text))
                {
                    xParams[2] = txtRes_From.Text.Trim();
                }

                if (!string.IsNullOrEmpty(txtRes_To.Text))
                {
                    xParams[3] = txtRes_To.Text.Trim();
                }

                if (!string.IsNullOrEmpty(txtRes_NM.Text))
                {
                    xParams[4] = txtRes_NM.Text;
                }

                xParams[6] = "EXCEL";

                xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_m_survey_md",
                                       "GetSurveyInfo",
                                       LMS_SYSTEM.CURRICULUM,
                                       "CLT.WEB.UI.LMS.CURR",
                                       (object)xParams);

                if (xDt.Rows.Count == 0)
                {
                    // 자료가 없습니다!
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A062", new string[] { "자료" }, new string[] { "Data" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                if (xDt.Rows.Count > 0)
                {
                    GetExcelFile(xDt, xHeader);
                }
            }
            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);
            }
        }
示例#24
0
        ///************************************************************
        //* Function name : btnExcelUpload_OnClick
        //* Purpose       : 주소록 엑셀 업로드
        //* Input         : void
        //* Output        : void
        //*************************************************************/
        //public DataTable ReadXlsFile(string excelFileName, string sheetName)
        //{
        //    //string connectionString = @"Provider=Micrisoft.Jet.OLEDB.4.0;Data Source="
        //    //                          + excelFileName + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";

        //    //OleDbConnection conn = new OleDbConnection(connectionString);
        //    //OleDbCommand comm = new OleDbCommand();

        //    //OleDbDataAdapter adap = new OleDbDataAdapter();
        //    //comm.Connection = conn;
        //    //comm.CommandType = CommandType.Text;
        //    //comm.CommandText = "SELECT * FROM [" + sheetName + "$]";
        //    //adap.SelectCommand = comm;
        //    //System.Data.DataTable dtXls = new DataTable("");
        //    //adap.Fill(dtXls);
        //    //return dtXls;
        //}

        /************************************************************
         * Function name : btnExcelUpload_OnClick
         * Purpose       : 주소록 엑셀 업로드
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void btnExcelUpload_OnClick(object sender, EventArgs e)
        protected void btnExcelUpload_OnClick(object sender, EventArgs e)
        {
            try
            {
                string excelFileFullPath = Util.UploadGetFileName(this.fu_excel, "/file/excel");

                DataTable dt = Util.GetDtExcelFile(excelFileFullPath, true);

                //데이터 맵핑및 Validator 체크
                //string xResult = "true";

                //dt.Columns["id"].Unique = true;

                foreach (DataRow xDr in dt.Rows)
                {
                    if (string.IsNullOrEmpty(xDr[1].ToString()))
                    {
                        ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "휴대폰 번호" }, new string[] { "Mobile Phone" }, Thread.CurrentThread.CurrentCulture));
                        return;
                    }
                    if (string.IsNullOrEmpty(xDr[0].ToString()))
                    {
                        ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A004", new string[] { "이름" }, new string[] { "Name" }, Thread.CurrentThread.CurrentCulture));
                        return;
                    }
                    string xPhone = xDr[1].ToString();
                    if (xPhone.Substring(0, 1) != "0")
                    {
                        xPhone = "0" + xPhone;
                    }

                    if (!SentSMSDuplicate(this.lbSentlist, this.txtMobilePhone.Text))
                    {
                        this.lbSentlist.Items.Add(new ListItem(xDr[0].ToString() + " : " + Regex.Replace(xPhone, @"\D", ""), "0"));
                    }
                    else
                    {
                        ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A014", new string[] { "휴대폰 번호" }, new string[] { "Mobile Phone" }, Thread.CurrentThread.CurrentCulture));
                        return;
                    }
                    this.lblSendCnt.Text = TotalCount();
                }
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#25
0
        /************************************************************
         * Function name : btnExam_OnClick
         * Purpose       : 시험 페이지 이동
         * Input         : void
         * Output        : void
         *************************************************************/
        #region btnExam_OnClick(object sender, EventArgs e)
        protected void btnExam_OnClick(object sender, EventArgs e)
        {
            try
            {
                //진도율 100% 인지 확인
                string[] xParams = new string[2];
                xParams[0] = ViewState["OPEN_COURSE_ID"].ToString();
                xParams[1] = Session["user_id"].ToString();

                DataTable dt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MYPAGE.vp_p_study_md",
                                                "GetExamCheck",
                                                LMS_SYSTEM.MYPAGE,
                                                "CLT.WEB.UI.LMS.MYPAGE", (object)xParams);
                if (dt.Rows.Count > 0)
                {
                    DataRow dr = dt.Rows[0];

                    if (dr["answer_yn"].ToString() == "Y") // 설문조사를 완료 했을때

                    {
                        string xURL = string.Format("<script>openPopWindow('/mypage/exam.aspx?open_course_id={0}&MenuCode={1}','exam_win', '1000', '671');</script>", ViewState["OPEN_COURSE_ID"], Session["MENU_CODE"]);
                        ScriptHelper.ScriptBlock(this, "study", xURL);
                        return;
                    }
                }
                else
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A125",
                                                                      new string[] { "등록된 과정 설문조사" },
                                                                      new string[] { "Registered Course Survey" },
                                                                      Thread.CurrentThread.CurrentCulture
                                                                      ));

                    return;
                }

                ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A126",
                                                                  new string[] { "설문조사" },
                                                                  new string[] { "Survey" },
                                                                  Thread.CurrentThread.CurrentCulture
                                                                  ));
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#26
0
        /************************************************************
         * Function name : btnAdd_OnClick
         * Purpose       : 선택된 과목 교육기간 대상자를 SMS 발송 리스트에 추가
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void btnAdd_OnClick(object sender, EventArgs e)
        protected void btnAdd_OnClick(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(this.ddlCus_Date.SelectedValue))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "대상조건" }, new string[] { "Target condition" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }
                else if (this.ddlCus_Date.SelectedValue == "*")
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "대상조건" }, new string[] { "Target condition" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                string[] xParams = new string[1];
                xParams[0] = this.ddlCus_Date.SelectedValue;

                DataTable xDt = new DataTable();
                xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.APPLICATION.vp_m_sms_md",
                                       "GetOpenCourseResultUser",
                                       LMS_SYSTEM.APPLICATION,
                                       "CLT.WEB.UI.LMS.APPLICATION", (object)xParams);

                for (int i = 0; i < xDt.Rows.Count; i++)
                {
                    // 중복추가 제거..
                    //if (lbSentlist.Items.FindByText(xDt.Rows[i]["mobile_phone"].ToString()) == null)
                    if (!SentSMSDuplicate(this.lbSentlist, xDt.Rows[i]["mobile_phone"].ToString()))
                    {
                        if (IsSettingKorean()) // 선택된 언어가 한국어일 경우
                        {
                            this.lbSentlist.Items.Add(new ListItem(xDt.Rows[i]["user_nm_kor"].ToString() + " : " + Regex.Replace(xDt.Rows[i]["mobile_phone"].ToString(), @"\D", ""), xDt.Rows[i]["user_id"].ToString()));
                        }
                        else
                        {
                            this.lbSentlist.Items.Add(new ListItem(xDt.Rows[i]["user_nm_eng"].ToString() + " : " + Regex.Replace(xDt.Rows[i]["mobile_phone"].ToString(), @"\D", ""), xDt.Rows[i]["user_id"].ToString()));
                        }
                    }
                }
                this.lblSendCnt.Text = TotalCount();
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
示例#27
0
        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);
            }
        }
示例#28
0
        /************************************************************
         * Function name : btnUpload_OnClick
         * Purpose       : 첨부파일 삭제 버튼 이벤트
         *
         * Input         : void
         * Output        : void
         *************************************************************/
        #region protected void btnRemove_OnClick(object sender, EventArgs e)
        protected void btnRemove_OnClick(object sender, EventArgs e)
        {
            try
            {
                if (lbSentlist.SelectedItem == null)
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A049", new string[] { "삭제할 파일" }, new string[] { "Attachment File" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                foreach (FileUpload Temp in ialFileList)
                {
                    if (Temp.FileName == lbSentlist.SelectedItem.Text)
                    {
                        ialFileList.Remove(Temp);
                        //lbSentlist.Items.Remove(lbSentlist.SelectedItem);
                        break;
                    }
                }

                if (lbSentlist.SelectedItem.Value == "EDIT")  // 기존 첨부파일이 존재 할 경우
                {
                    //if (!ialDeleteList.Contains(lbSentlist.SelectedItem.Text))  // 동일한 Data가 없으면...
                    //    ialDeleteList.Add(lbSentlist.SelectedItem.Text);

                    if (!this.lbDeleteList.Items.Contains(new ListItem(lbSentlist.SelectedItem.Text)))
                    {
                        this.lbDeleteList.Items.Add(new ListItem(lbSentlist.SelectedItem.Text));
                    }
                }

                this.lbSentlist.Items.Remove(lbSentlist.SelectedItem);

                //if (lbSentlist.SelectedItem.Value == "EDIT")  // 기존 첨부파일이 존재 할 경우
                //{
                //    if (!ialDeleteList.Contains(lbSentlist.SelectedItem.Text))  // 동일한 Data가 없으면...
                //        ialDeleteList.Add(lbSentlist.SelectedItem.Text);
                //}

                //this.lbSentlist.Items.Remove(lbSentlist.SelectedItem);
            }
            catch (Exception ex)
            {
                base.NotifyError(ex);
            }
        }
 /************************************************************
  * Function name : RadioButton_CheckedChanged
  * Purpose       : 입력된 설문 내용 저장버튼 이벤트
  * Input         : void
  * Output        : void
  *************************************************************/
 #region btnSave_OnClick(object sender, EventArgs e)
 protected void btnSave_OnClick(object sender, EventArgs e)
 {
     try
     {
         if (ViewState["ANSWER_YN"].ToString() == "Y")
         {
             // 게시된 설문은 수정 할 수 없습니다.
             ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A116", new string[] { "" }, new string[] { "" }, Thread.CurrentThread.CurrentCulture));
             return;
         }
         AnswerInsert(Convert.ToInt32(ViewState["COUNT"].ToString()));
     }
     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;
                }
            }
        }