Beispiel #1
0
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        #region public void BindGrid()
        public void BindGrid()
        {
            try
            {
                string[]  xParams = new string[8];
                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().Replace("'", "''");
                }

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

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

                xParams[5] = "Y";
                xParams[6] = "GRID";
                xParams[7] = "RESULT";
                xDt        = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_m_survey_md",
                                              "GetSurveyInfo",
                                              LMS_SYSTEM.CURRICULUM,
                                              "CLT.WEB.UI.LMS.CURR",
                                              (object)xParams);

                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount      = 0;
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount      = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
        /************************************************************
        * Function name : BindGrid
        * Purpose       : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
        * Input         : void
        * Output        : void
        *************************************************************/
        private void BindGrid()
        {
            try
            {
                string[] xParams = null;
                DataTable xDt = null;

                if (string.IsNullOrEmpty(this.txtCourseNM.Text) && this.ddlCourseLang.SelectedItem.Text == "*" && this.ddlCourseType.SelectedItem.Text == "*")
                {
                    // 조회조건이 없을 경우 처리
                    xParams = new string[2];
                    xParams[0] = iPageSize.ToString(); // pageSize
                    xParams[1] = this.CurrentPageIndex.ToString(); // currentPageIndex

                    xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_course_md",
                                                 "GetCourseInfo",
                                                 LMS_SYSTEM.CURRICULUM,
                                                 "CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
                }
                else
                {
                    // 조회조건이 있을 경우 처리
                    xParams = new string[6];
                    xParams[0] = iPageSize.ToString(); // pagesize
                    xParams[1] = this.CurrentPageIndex.ToString(); // currentPageIndex
                    xParams[2] = this.txtCourseNM.Text; // course_nm
                    xParams[3] = this.ddlCourseLang.SelectedItem.Value.Replace("*", ""); // course_lang
                    xParams[4] = this.ddlCourseType.SelectedItem.Value.Replace("*", ""); // course_type
                    xParams[5] = iCourseType;
                    xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_course_md",
                                                 "GetCourseInfoByCondition",
                                                 LMS_SYSTEM.CURRICULUM,
                                                 "CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
                }

                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount = 0;
                    this.PageInfo1.PageSize = iPageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize = iPageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow) throw;
            }
        }
Beispiel #3
0
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        #region private void BindGrid()
        private void BindGrid()
        {
            try
            {
                string[]  xParams = null;
                DataTable xDt     = null;


                // 조회조건이 있을 경우 처리
                xParams    = new string[6];
                xParams[0] = this.PageSize.ToString();                                 // pagesize
                xParams[1] = this.CurrentPageIndex.ToString();                         // currentPageIndex
                xParams[2] = this.txtContentsNM.Text;                                  // contents_nm
                xParams[3] = this.txtRemark.Text;                                      // remark
                xParams[4] = this.ddlContentsLang.SelectedItem.Value.Replace("*", ""); // lang
                xParams[5] = this.ddlContentsType.SelectedItem.Value.Replace("*", ""); // contents_type

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


                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount      = 0;
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount      = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
Beispiel #4
0
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 특정 (등록)과정의 과목 & 컨텐츠 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        private void BindGrid()
        {
            try
            {
                if (!string.IsNullOrEmpty(this.txtCourseID.Value))
                {
                    string[] xParams = new string[1];
                    xParams[0] = this.txtCourseID.Value; // course_id

                    DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_content_md",
                                                     "GetContentsMixInfoOfCourse",
                                                     LMS_SYSTEM.CURRICULUM,
                                                     "CLT.WEB.UI.LMS.CURR", (object)xParams);
                    C1WebGrid1.DataSource = xDt;
                    C1WebGrid1.DataBind();

                    if (xDt.Rows.Count > 0)
                    {
                        this.txtCourseNM.Text = xDt.Rows[0]["course_nm"].ToString();
                    }

                    C1Column col_0 = (C1Column)this.C1WebGrid1.Columns[0];
                    C1Column col_1 = (C1Column)this.C1WebGrid1.Columns[1];

                    col_0.Visible            = true;
                    col_0.RowMerge           = RowMergeEnum.Free;
                    col_0.GroupInfo.Position = GroupPositionEnum.None;

                    col_1.Visible            = true;
                    col_1.RowMerge           = RowMergeEnum.Free;
                    col_1.GroupInfo.Position = GroupPositionEnum.None;
                }
                else
                {
                    C1WebGrid1.DataSource = null;
                    C1WebGrid1.DataBind();
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
        private void BindGrid()
        {
            try
            {
                string[] xParams = new string[3];
                //xParams[0] = this.PageSize.ToString(); // pagesize
                //xParams[1] = this.CurrentPageIndex.ToString(); // pageno
                xParams[2] = this.ddlCourseField.SelectedItem.Value.ToString();



                iGridDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_manage_md",        // Class Name
                                           "GetMenuGroup",                                 // Mehtod Name
                                           LMS_SYSTEM.MAIN,                                // Project Type
                                           "CLT.WEB.UI.LMS.MANAGE",                        // NameSpace Name
                                           (object)xParams);                               // Page Info


                C1WebGrid1.DataSource = iGridDt;
                C1WebGrid1.DataBind();
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }

            //if (iGridDt.Rows.Count < 1)
            //{
            //    this.PageInfo1.TotalRecordCount = 0;
            //    this.PageInfo1.PageSize = this.PageSize;
            //    this.PageNavigator1.TotalRecordCount = 0;
            //}
            //else
            //{
            //    this.PageInfo1.TotalRecordCount = Convert.ToInt32(iGridDt.Rows[0]["totalrecordcount"]);
            //    this.PageInfo1.PageSize = this.PageSize;
            //    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(iGridDt.Rows[0]["totalrecordcount"]);
            //}

            //this.PageInfo1.RecordCount = iGridDt.Rows.Count; //Convert.ToInt32(iGridDt.Rows[0]["totalrecordcount"]);
            //this.PageNavigator1.RecordCount = 0;//iGridDt.Rows.Count; //Convert.ToInt32(iGridDt.Rows[0]["totalrecordcount"]);
        }
Beispiel #6
0
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        #region public void BindGrid()
        public void BindGrid()
        {
            try
            {
                string[] xParams = new string[4];

                xParams[0] = this.PageSize.ToString();
                xParams[1] = this.CurrentPageIndex.ToString();
                xParams[2] = this.txtMail_From.Text;
                xParams[3] = this.txtMail_To.Text;

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

                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount      = 0;
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount      = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
Beispiel #7
0
        public void BeginGrid()
        {
            try
            {
                string[] xParams = new string[1];

                //if (string.IsNullOrEmpty(txtZipcode.Text))
                //{
                //    Response.Write("<script language='javascript'>alert('검색할 회사명을 입력해 주세요!');</script>");
                //    return;
                //}
                if (Request.QueryString["USERGROUP"].ToString() != "000001") // 관리자가 아니면

                {
                    xParams[0] = Request.QueryString["COMPANY_ID"].ToString();
                }
                else
                {
                    xParams[0] = txtZipcode.Text;
                }

                // 소속회사 검색
                DataTable xdt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md",
                                                 "GetCompanySearch",
                                                 LMS_SYSTEM.MANAGE,
                                                 "CLT.WEB.UI.LMS.MANAGE",
                                                 (object)xParams);

                C1WebGrid1.DataSource = xdt;
                C1WebGrid1.DataBind();
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 특정 (등록)과정의 과목 & 컨텐츠 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        private void BindGrid()
        {
            try
            {
                if (!string.IsNullOrEmpty(this.txtCourseID.Value))
                {
                    string[] xParams = new string[1];
                    xParams[0] = this.txtCourseID.Value; // course_id

                    DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_textbook_md",
                                                     "GetTextBookMixInfoOfCourse",
                                                     LMS_SYSTEM.CURRICULUM,
                                                     "CLT.WEB.UI.LMS.CURR", (object)xParams);
                    C1WebGrid1.DataSource = xDt;
                    C1WebGrid1.DataBind();

                    if (xDt.Rows.Count > 0)
                    {
                        this.txtCourseNM.Text = xDt.Rows[0]["course_nm"].ToString();
                    }
                }
                else
                {
                    C1WebGrid1.DataSource = null;
                    C1WebGrid1.DataBind();
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
Beispiel #9
0
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        #region BindGrid()
        public void BindGrid()
        {
            try
            {
                string[]  xParams = new string[7];
                DataTable xDt     = null;

                DataTable xDtSocialpos = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_m_survey_md",
                                                          "GetUSERSOCIALPOS",
                                                          LMS_SYSTEM.COMMUNITY,
                                                          "CLT.WEB.UI.LMS.COMMUNITY",
                                                          (object)new string[1] {
                    Session["USER_ID"].ToString()
                });

                xParams[0] = this.PageSize.ToString();
                xParams[1] = this.CurrentPageIndex.ToString();
                xParams[2] = Session["USER_ID"].ToString();
                xParams[3] = Session["USER_GROUP"].ToString();
                xParams[4] = Session["COMPANY_ID"].ToString();
                xParams[5] = Session["DUTY_STEP"].ToString();


                if (xDtSocialpos.Rows.Count > 0)
                {
                    xParams[6] = xDtSocialpos.Rows[0]["SOCIALPOS"].ToString();
                }
                else
                {
                    xParams[6] = string.Empty;
                }


                if (Request.QueryString["OPEN_COURSE_ID"] != null)
                {
                    xParams[3] = Request.QueryString["OPEN_COURSE_ID"].ToString();
                    //xParams[4] = Request.QueryString["USER_ID"].ToString();
                }

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

                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount      = 0;
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount      = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
Beispiel #10
0
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 교재 목록 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        private void BindGrid()
        {
            try
            {
                string[]  xParams = null;
                DataTable xDt     = null;

                if (string.IsNullOrEmpty(this.txtTextBookNM.Text) && string.IsNullOrEmpty(this.txtBeginDt.Text) && string.IsNullOrEmpty(this.txtEndDt.Text) && this.ddlTextBookType.SelectedItem.Text == "*" && this.ddlCourseGroup.SelectedItem.Text == "*" && this.ddlCourseField.SelectedItem.Text == "*" && this.ddlTextBookLang.SelectedItem.Text == "*")
                {
                    // 조회조건이 없을 경우 처리
                    xParams    = new string[2];
                    xParams[0] = this.PageSize.ToString();         // pagesize
                    xParams[1] = this.CurrentPageIndex.ToString(); // currentPageIndex

                    xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_textbook_md",
                                           "GetTextBookInfo",
                                           LMS_SYSTEM.CURRICULUM,
                                           "CLT.WEB.UI.LMS.CURR", (object)xParams);
                }
                else
                {
                    // 조회조건이 있을 경우 처리
                    xParams    = new string[9];
                    xParams[0] = this.PageSize.ToString();                                 // pagesize
                    xParams[1] = this.CurrentPageIndex.ToString();                         // currentPageIndex
                    xParams[2] = this.txtTextBookNM.Text;                                  // textbook_nm
                    xParams[3] = this.ddlTextBookType.SelectedItem.Value.Replace("*", ""); // textbook_type
                    xParams[4] = this.ddlCourseGroup.SelectedItem.Value.Replace("*", "");  // course_group
                    xParams[5] = this.ddlCourseField.SelectedItem.Value.Replace("*", "");  // course_field
                    xParams[6] = this.ddlTextBookLang.SelectedItem.Value.Replace("*", ""); // textbook_lang
                    xParams[7] = this.txtBeginDt.Text;                                     // ins_begin_dt
                    xParams[8] = this.txtEndDt.Text;                                       // ins_end_dt

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

                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount      = 0;
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount      = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
Beispiel #11
0
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        #region BindGrid()
        public void BindGrid()
        {
            try
            {
                this.C1WebGrid1.DataBind();

                string[]  xParams = new string[14];
                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]  = string.Empty;                     // 한글성명
                xParams[7]  = string.Empty;                     // 사용자 그룹
                xParams[8]  = string.Empty;                     // 주민번호
                xParams[9]  = string.Empty;                     // 상태
                xParams[10] = Session["USER_GROUP"].ToString(); //string.Empty; // 조회하는 로그인된 사용자그룹 *중요한 정보!!!
                xParams[11] = Session["COMPANY_ID"].ToString(); //string.Empty; // 조회하는 로그인된 사용자의 업체ID(Company_ID) *중요한 정보!!!
                xParams[12] = Session["USER_ID"].ToString();    //ViewState["UserIDInfo"].ToString(); // 조회하는 로그인된 사용자의 ID
                xParams[13] = "Y";

                string[] xParamUser = new string[1];
                xParamUser[0] = ViewState["UserIDInfo"].ToString();

                //DataTable xDtUser = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md",
                //                                   "GetUser",
                //                                   LMS_SYSTEM.MANAGE,
                //                                   "CLT.WEB.UI.LMS.MANAGE.vp_m_manage_user_list_wpg",
                //                                   (object)xParamUser);
                //if (xDtUser.Rows.Count == 0)
                //    return;
                //DataRow xDrv = xDtUser.Rows[0];
                //xParams[10] = xDrv["user_group"].ToString();
                //xParams[11] = xDrv["company_id"].ToString();

                if (!string.IsNullOrEmpty(txtCompany.Text))
                {
                    xParams[2] = txtCompany.Text.Replace("'", "''");
                }

                if (ddlDutyStep.SelectedValue != "*")
                {
                    xParams[3] = ddlDutyStep.SelectedValue;
                }

                if (!string.IsNullOrEmpty(txtUserName.Text))
                {
                    xParams[6] = txtUserName.Text.Replace("'", "''");
                }

                if (ddlUserGroup.SelectedValue != "*")
                {
                    xParams[7] = ddlUserGroup.SelectedValue;
                }

                if (!string.IsNullOrEmpty(txtPersonal_No.Text))
                {
                    xParams[8] = txtPersonal_No.Text.Replace("'", "''");
                }

                if (ddlStatus.SelectedItem.Text != "*")
                {
                    xParams[9] = ddlStatus.SelectedItem.Value;
                }

                xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.MANAGE.vp_m_user_md",
                                       "GetUserInfo",
                                       LMS_SYSTEM.MANAGE,
                                       "CLT.WEB.UI.LMS.MANAGE",
                                       (object)xParams);

                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount      = 0;
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount      = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        public void BindGrid(string rMasterCode)
        {
            try
            {
                string[]  xParams = new string[8];
                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] = rMasterCode;
                xParams[7] = "GRID";

                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_detailcode_md",
                                       "GetDetailCode",
                                       LMS_SYSTEM.MANAGE,
                                       "CLT.WEB.UI.LMS.MANAGE", (object)xParams);

                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                // 페이지 처리
                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount      = 0;
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount      = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
Beispiel #13
0
        /************************************************************
         * Function name : BindGrid
         * Purpose       : SMS 전송 리스트를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        #region public void BindGrid()
        public void BindGrid()
        {
            try
            {
                if (!string.IsNullOrEmpty(txtSMS_From.Text) && string.IsNullOrEmpty(txtSMS_To.Text))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "조회기간" }, new string[] { "Date To" }, Thread.CurrentThread.CurrentCulture)); return;
                }
                else if (string.IsNullOrEmpty(txtSMS_From.Text) && !string.IsNullOrEmpty(txtSMS_To.Text))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A003", new string[] { "조회기간" }, new string[] { "Date From" }, Thread.CurrentThread.CurrentCulture)); return;
                }

                string[] xParams = new string[5];

                xParams[0] = this.PageSize.ToString();
                xParams[1] = this.CurrentPageIndex.ToString();

                if (rbBooking.Checked == true) // 예약발송일 경우
                {
                    xParams[2] = "Y";
                }

                else
                {
                    xParams[2] = "N";
                }

                xParams[3] = this.txtSMS_From.Text;
                xParams[4] = this.txtSMS_To.Text;

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

                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount      = 0;
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount      = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
Beispiel #14
0
        /************************************************************
         * Function name : BindGrid
         * Purpose       : 컨텐츠 목록 데이터를 DataGrid에 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        #region public void BindGrid()
        public void BindGrid()
        {
            try
            {
                if (!string.IsNullOrEmpty(txtCurr_From.Text) && string.IsNullOrEmpty(txtCurr_To.Text))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A039", new string[] { "조회기간" }, new string[] { "Period" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }
                else if (string.IsNullOrEmpty(txtCurr_From.Text) && !string.IsNullOrEmpty(txtCurr_To.Text))
                {
                    ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A039", new string[] { "조회기간" }, new string[] { "Period" }, Thread.CurrentThread.CurrentCulture));
                    return;
                }

                string[] xParams = new string[9];

                xParams[0] = this.PageSize.ToString();
                xParams[1] = this.CurrentPageIndex.ToString();


                xParams[2] = Session["USER_ID"].ToString();

                xParams[3] = this.ddlDate.SelectedValue;
                xParams[4] = this.txtCurr_From.Text;
                xParams[5] = this.txtCurr_To.Text;
                xParams[6] = this.txtCus_ID.Text; // 과정 ID
                if (this.ddlCourseType.SelectedValue != "*")
                {
                    xParams[7] = this.ddlCourseType.SelectedValue;
                }
                else
                {
                    xParams[7] = string.Empty;
                }

                xParams[8] = Session["USER_GROUP"].ToString();

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


                C1WebGrid1.DataSource = xDt;
                C1WebGrid1.DataBind();

                if (xDt.Rows.Count < 1)
                {
                    this.PageInfo1.TotalRecordCount      = 0;
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = 0;
                }
                else
                {
                    this.PageInfo1.TotalRecordCount      = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                    this.PageInfo1.PageSize              = this.PageSize;
                    this.PageNavigator1.TotalRecordCount = Convert.ToInt32(xDt.Rows[0]["totalrecordcount"]);
                }
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }