Exemple #1
0
        /************************************************************
         * Function name : BindDropDownList
         * Purpose       : DropDownList 데이터 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        private void BindDropDownList()
        {
            try
            {
                string[]  xParams = new string[1];
                string    xSql    = string.Empty;
                DataTable xDt     = null;

                // CourseType
                xParams[0] = "0006";

                xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
                                       "GetCommonCodeInfo",
                                       LMS_SYSTEM.MAIN,
                                       "CLT.WEB.UI.LMS.MAIN", (object)xParams, Thread.CurrentThread.CurrentCulture);

                WebControlHelper.SetDropDownList(this.ddlCourseType, xDt);

                // Lang
                xParams[0] = "0017";

                xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
                                       "GetCommonCodeInfo",
                                       LMS_SYSTEM.MAIN,
                                       "CLT.WEB.UI.LMS.MAIN", (object)xParams, Thread.CurrentThread.CurrentCulture);

                WebControlHelper.SetDropDownList(this.ddlCourseLang, xDt);

                // Year
                WebControlHelper.SetYearDropDownList(this.ddlCourseYear);
            }
            catch (Exception ex)
            {
                bool rethrow = ExceptionPolicy.HandleException(ex, "Propagate Policy");
                if (rethrow)
                {
                    throw;
                }
            }
        }
Exemple #2
0
        /************************************************************
         * Function name : BindDropDownList
         * Purpose       : DropDownList 데이터 바인딩을 위한 처리
         * Input         : void
         * Output        : void
         *************************************************************/
        #region private void BindDropDownList()
        private void BindDropDownList()
        {
            try
            {
                string[]  xParams = new string[1];
                string    xSql    = string.Empty;
                DataTable xDt     = null;

                //year
                WebControlHelper.SetYearDropDownList(this.ddlYear, WebControlHelper.ComboType.NullAble);

                //Institution
                xParams[0] = "0007";
                xDt        = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
                                              "GetCommonCodeInfo",
                                              LMS_SYSTEM.CURRICULUM,
                                              "CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
                WebControlHelper.SetDropDownList(this.ddlInstitution, xDt, WebControlHelper.ComboType.NullAble);

                //inout
                xParams[0] = "0005";
                xDt        = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
                                              "GetCommonCodeInfo",
                                              LMS_SYSTEM.CURRICULUM,
                                              "CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
                WebControlHelper.SetDropDownList(this.ddlInOut, xDt, WebControlHelper.ComboType.NullAble);

                //place
                xParams[0] = string.Empty;
                xDt        = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
                                              "GetCommonCodeInfo",
                                              LMS_SYSTEM.CURRICULUM,
                                              "CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
                WebControlHelper.SetDropDownList(this.ddlPlace, xDt, WebControlHelper.ComboType.NullAble);


                //classification
                xParams[0] = "0047";
                xDt        = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
                                              "GetCommonCodeInfo",
                                              LMS_SYSTEM.CURRICULUM,
                                              "CLT.WEB.UI.LMS.CURR", (object)xParams, Thread.CurrentThread.CurrentCulture);
                //WebControlHelper.SetDropDownList(this.ddlClassification, xDt);
                DataTable  dtClass = new DataTable();
                DataColumn Colc1   = new DataColumn("check", Type.GetType("System.Boolean"));
                DataColumn Colc2   = new DataColumn("nm", Type.GetType("System.String"));
                DataColumn Colc3   = new DataColumn("id", Type.GetType("System.String"));

                dtClass.Columns.Add(Colc1);
                dtClass.Columns.Add(Colc2);
                dtClass.Columns.Add(Colc3);

                DataRow rows = null;
                foreach (DataRow dr in xDt.Rows)
                {
                    rows    = dtClass.NewRow();
                    rows[0] = false;
                    rows[1] = dr["d_knm"].ToString();
                    rows[2] = dr["d_cd"].ToString();
                    dtClass.Rows.Add(rows);
                }

                this.dtlClassification.DataSource = dtClass;
                this.dtlClassification.DataBind();

                //Company accept(적용회사)
                xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.CURR.vp_c_opencourse_md",
                                       "GetCompany",
                                       LMS_SYSTEM.CURRICULUM,
                                       "CLT.WEB.UI.LMS.CURR", Thread.CurrentThread.CurrentCulture);

                DataTable  dtComp = new DataTable();
                DataColumn Col1   = new DataColumn("check", Type.GetType("System.Boolean"));
                DataColumn Col2   = new DataColumn("nm", Type.GetType("System.String"));
                DataColumn Col3   = new DataColumn("id", Type.GetType("System.String"));

                dtComp.Columns.Add(Col1);
                dtComp.Columns.Add(Col2);
                dtComp.Columns.Add(Col3);

                rows    = dtComp.NewRow();
                rows[0] = false;
                rows[1] = "ALL";
                rows[2] = "ALL";
                dtComp.Rows.Add(rows);

                foreach (DataRow dr in xDt.Rows)
                {
                    rows    = dtComp.NewRow();
                    rows[0] = false;
                    rows[1] = dr["COMPANY_NM"].ToString();
                    rows[2] = dr["COMPANY_ID"].ToString();
                    dtComp.Rows.Add(rows);
                }

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