예제 #1
0
            public static Dictionary <string, object> GetSearch(string _page, Dictionary <string, object> _paramSearch)
            {
                Dictionary <string, object> _loginResult  = UDSStaffUtil.GetInfoLogin("", "");
                Dictionary <string, object> _searchResult = new Dictionary <string, object>();
                DataSet _ds = new DataSet();

                DataRow[]     _dr                      = null;
                string        _reportName              = String.Empty;
                int           _recordCount             = 0;
                int           _recordCountPrimary      = 0;
                int           _recordCountSecondary    = 0;
                int           _recordCountAllPrimary   = 0;
                int           _recordCountAllSecondary = 0;
                StringBuilder _list                    = new StringBuilder();
                StringBuilder _navPage                 = new StringBuilder();

                if (_page == UDSStaffUtil.PAGE_OURSERVICESDOCUMENTSTATUSSTUDENTLEVEL1VIEWTABLE_MAIN)
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_DOCUMENTSTATUSSTUDENTLEVEL1VIEWTABLE;
                }

                _ds = UDSStaffDB.GetListUDSStudentRecords(
                    _loginResult["Username"].ToString(),
                    _loginResult["Userlevel"].ToString(),
                    _loginResult["SystemGroup"].ToString(),
                    _reportName,
                    _paramSearch
                    );

                if (_reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_DOCUMENTSTATUSSTUDENTLEVEL1VIEWTABLE))
                {
                    _dr                 = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
                    _recordCount        = _ds.Tables[0].Rows.Count;
                    _recordCountPrimary = _ds.Tables[0].Rows.Count;

                    _list.AppendLine(UDSStaffOurServicesUI.DocumentStatusStudentUI.ViewTableUI.SectionMainUI.GetList(_page, _loginResult, _dr).ToString());
                    _navPage.AppendLine(Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), _page, (int)(_paramSearch["RowPerPage"])).ToString());
                }

                _ds.Dispose();

                _searchResult.Add("RecordCount", _recordCount);
                _searchResult.Add("RecordCountPrimary", _recordCountPrimary);
                _searchResult.Add("RecordCountSecondary", _recordCountSecondary);
                _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary);
                _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary);
                _searchResult.Add("List", _list);
                _searchResult.Add("NavPage", _navPage);

                return(_searchResult);
            }
예제 #2
0
                public static StringBuilder GetMain(Dictionary <string, object> _infoLogin, string _id)
                {
                    Dictionary <string, object> _infoData       = new Dictionary <string, object>();
                    Dictionary <string, object> _infoDataResult = UDSStaffUtil.GetInfoData(UDSStaffUtil.PAGE_SETTINGACCESSTOTHESYSTEM_EDIT, _infoData);
                    StringBuilder _html = new StringBuilder();

                    _idSectionAddUpdate = _idSectionEdit;

                    _html.AppendLine(UDSStaffUI.GetInfoBar(_infoDataResult, true).ToString());
                    _html.AppendLine(SectionAddUpdateUI.GetValueDataRecorded(UDSStaffUtil.SetValueDataRecorded(UDSStaffUtil.PAGE_SETTINGACCESSTOTHESYSTEM_EDIT, _id)).ToString());
                    _html.AppendLine(SectionAddUpdateUI.GetMain(_infoLogin).ToString());

                    return(_html);
                }
예제 #3
0
        public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch)
        {
            Dictionary <string, object> _loginResult  = UDSStaffUtil.GetInfoLogin("", "");
            Dictionary <string, object> _searchResult = new Dictionary <string, object>();
            DataSet _ds = new DataSet();

            DataRow[]     _dr                      = null;
            int           _recordCount             = 0;
            int           _recordCountPrimary      = 0;
            int           _recordCountSecondary    = 0;
            int           _recordCountAllPrimary   = 0;
            int           _recordCountAllSecondary = 0;
            StringBuilder _list                    = new StringBuilder();
            StringBuilder _navPage                 = new StringBuilder();


            _ds = UDSStaffDB.GetListUDSStudentRecords(
                _loginResult["Username"].ToString(),
                _loginResult["Userlevel"].ToString(),
                _loginResult["SystemGroup"].ToString(),
                "",
                _paramSearch
                );

            _dr                 = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
            _recordCount        = _ds.Tables[0].Rows.Count;
            _recordCountPrimary = _ds.Tables[0].Rows.Count;
            _list               = UDSStaffOurServicesUI.CopyProfilePictureApprovedtotheStoreUI.SectionMainUI.GetList(_loginResult, _dr);
            _navPage            = Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), UDSStaffUtil.PAGE_OURSERVICESCOPYPROFILEPICTUREAPPROVEDTOTHESTORE_MAIN, (int)(_paramSearch["RowPerPage"]));

            _ds.Dispose();

            _searchResult.Add("RecordCount", _recordCount);
            _searchResult.Add("RecordCountPrimary", _recordCountPrimary);
            _searchResult.Add("RecordCountSecondary", _recordCountSecondary);
            _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary);
            _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary);
            _searchResult.Add("List", _list);
            _searchResult.Add("NavPage", _navPage);

            return(_searchResult);
        }
예제 #4
0
    public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch)
    {
        Dictionary <string, object> _loginResult  = UDSStaffUtil.GetInfoLogin("", "");
        Dictionary <string, object> _searchResult = new Dictionary <string, object>();
        DataSet _ds = new DataSet();

        DataRow[]     _dr                      = null;
        int           _recordCount             = 0;
        int           _recordCountPrimary      = 0;
        int           _recordCountSecondary    = 0;
        int           _recordCountAllPrimary   = 0;
        int           _recordCountAllSecondary = 0;
        StringBuilder _list                    = new StringBuilder();
        StringBuilder _navPage                 = new StringBuilder();

        _ds = UDSStaffDB.GetListUDSStudentRecords(
            _loginResult["Username"].ToString(),
            _loginResult["Userlevel"].ToString(),
            _loginResult["SystemGroup"].ToString(),
            "",
            _paramSearch
            );

        _dr                 = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
        _recordCount        = _ds.Tables[0].Rows.Count;
        _recordCountPrimary = _ds.Tables[0].Rows.Count;
        _list               = UDSStaffUploadSubmitDocumentUI.SectionMainUI.GetList(_loginResult, _dr);
        _navPage            = Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), UDSStaffUtil.PAGE_UPLOADSUBMITDOCUMENT_MAIN, (int)(_paramSearch["RowPerPage"]));

        _ds.Dispose();

        _searchResult.Add("RecordCount", _recordCount);
        _searchResult.Add("RecordCountPrimary", _recordCountPrimary);
        _searchResult.Add("RecordCountSecondary", _recordCountSecondary);
        _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary);
        _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary);
        _searchResult.Add("List", _list);
        _searchResult.Add("NavPage", _navPage);

        return(_searchResult);
    }
예제 #5
0
        public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch)
        {
            Dictionary <string, object> _loginResult  = UDSStaffUtil.GetInfoLogin("", "");
            Dictionary <string, object> _searchResult = new Dictionary <string, object>();
            DataSet _ds = new DataSet();

            DataRow[]     _dr                      = null;
            int           _recordCount             = 0;
            int           _recordCountPrimary      = 0;
            int           _recordCountSecondary    = 0;
            int           _recordCountAllPrimary   = 0;
            int           _recordCountAllSecondary = 0;
            StringBuilder _list                    = new StringBuilder();
            StringBuilder _navPage                 = new StringBuilder();

            _ds = UDSStaffDB.GetListUDSStudentRecords(
                _loginResult["Username"].ToString(),
                _loginResult["Userlevel"].ToString(),
                _loginResult["SystemGroup"].ToString(),
                "",
                _paramSearch
                );

            _dr                 = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
            _recordCount        = _ds.Tables[0].Rows.Count;
            _recordCountPrimary = _ds.Tables[0].Rows.Count;
            _list               = UDSStaffOurServicesUI.ExportStudentRecordsInformationForSmartCardUI.SectionMainUI.GetList(_loginResult, _dr);
            _navPage            = Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), UDSStaffUtil.PAGE_OURSERVICESEXPORTSTUDENTRECORDSINFORMATIONFORSMARTCARD_MAIN, (int)(_paramSearch["RowPerPage"]));

            _ds.Dispose();

            _searchResult.Add("RecordCount", _recordCount);
            _searchResult.Add("RecordCountPrimary", _recordCountPrimary);
            _searchResult.Add("RecordCountSecondary", _recordCountSecondary);
            _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary);
            _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary);
            _searchResult.Add("List", _list);
            _searchResult.Add("NavPage", _navPage);

            return(_searchResult);
        }
예제 #6
0
            public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch)
            {
                Dictionary <string, object> _loginResult  = UDSStaffUtil.GetInfoLogin("", "");
                Dictionary <string, object> _searchResult = new Dictionary <string, object>();
                DataSet       _ds                      = new DataSet();
                int           _recordCount             = 0;
                int           _recordCountPrimary      = 0;
                int           _recordCountSecondary    = 0;
                int           _recordCountAllPrimary   = 0;
                int           _recordCountAllSecondary = 0;
                StringBuilder _list                    = new StringBuilder();

                _ds = UDSStaffDB.GetListUDSStudentRecords(
                    _loginResult["Username"].ToString(),
                    _loginResult["Userlevel"].ToString(),
                    _loginResult["SystemGroup"].ToString(),
                    UDSStaffUtil.SUBJECT_SECTION_DOCUMENTSTATUSSTUDENTVIEWCHART,
                    _paramSearch
                    );

                _recordCount        = _ds.Tables[0].Rows.Count;
                _recordCountPrimary = _ds.Tables[0].Rows.Count;
                _list = UDSStaffOurServicesUI.DocumentStatusStudentUI.ViewChartUI.SectionMainUI.GetList(_loginResult, _ds);

                _ds.Dispose();

                _searchResult.Add("RecordCount", _recordCount);
                _searchResult.Add("RecordCountPrimary", _recordCountPrimary);
                _searchResult.Add("RecordCountSecondary", _recordCountSecondary);
                _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary);
                _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary);
                _searchResult.Add("List", _list);
                _searchResult.Add("NavPage", new StringBuilder());

                return(_searchResult);
            }
예제 #7
0
        public static StringBuilder GetMain()
        {
            Dictionary <string, object> _infoData       = new Dictionary <string, object>();
            Dictionary <string, object> _infoDataResult = UDSStaffUtil.GetInfoData(UDSStaffUtil.PAGE_APPROVEDOCUMENT_MAIN, _infoData);
            Dictionary <string, object> _searchResult   = new Dictionary <string, object>();
            StringBuilder _html        = new StringBuilder();
            int           _cookieError = Util.ChkCookie(UDSStaffUtil._myParamSearchCookieName);
            int           _i           = 0;
            bool          _show        = false;

            if (_cookieError.Equals(0))
            {
                HttpCookie _objCookie = Util.GetCookie(UDSStaffUtil._myParamSearchCookieName);

                if (_objCookie["Command"].Equals(UDSStaffUtil.PAGE_APPROVEDOCUMENT_MAIN))
                {
                    _show         = true;
                    _searchResult = UDSStaffApproveDocumentUtil.GetSearch(UDSStaffUtil.SetParameterSearch(UDSStaffUtil.PAGE_APPROVEDOCUMENT_MAIN, null, true));
                }
            }

            _html.AppendLine(UDSStaffUI.GetInfoBar(_infoDataResult, true).ToString());
            _html.AppendLine("<div class='after-sticky main'>");
            _html.AppendFormat("    <div class='table' id='{0}-table'>", _idSectionMain);
            _html.AppendLine("          <div class='table-layout'>");
            _html.AppendLine("              <div class='table-content'>");
            _html.AppendLine("                  <div class='table-freeze sticky'>");
            _html.AppendLine("                      <div class='table-title'>");
            _html.AppendFormat("                        <div class='contentbody-left table-option table-rowperpage en-label'>{0}</div>", UDSStaffUI.GetComboboxRowPerPage(_idSectionMain + "-rowperpage"));
            _html.AppendLine("                          <div class='contentbody-right table-recordcount en-label'>");
            _html.AppendFormat("                            <span class='recordcount-search hidden'>{0}</span>", (_show.Equals(true) ? double.Parse(_searchResult["RecordCount"].ToString()).ToString("#,##0") : String.Empty));
            _html.AppendFormat("                            <span class='recordcountprimary-search th-label'>{0}</span>", (_show.Equals(true) ? double.Parse(_searchResult["RecordCountPrimary"].ToString()).ToString("#,##0") : String.Empty));
            _html.AppendLine("                          </div>");
            _html.AppendLine("                      </div>");
            _html.AppendLine("                      <div class='clear'></div>");
            _html.AppendLine("                      <div class='table-head'>");
            _html.AppendLine("                          <div class='table-row'>");
            _html.AppendLine("                              <div class='table-col table-col-width-fixed table-col1'><div class='table-col-msg'><div class='en-label'>No.</div></div></div>");
            _html.AppendLine("                              <div class='table-col table-col-width-fixed table-col2'><div class='table-col-msg'><div class='en-label'>Student</div><div class='en-label'>ID</div></div></div>");
            _html.AppendLine("                              <div class='table-col table-col-width-dynamic table-col3'><div class='table-col-msg'><div class='en-label'>Full Name</div></div></div>");
            _html.AppendLine("                              <div class='table-col table-col-width-fixed table-col4'><div class='table-col-msg'><div class='en-label'>Program</div></div></div>");
            _html.AppendLine("                              <div class='table-col table-col-width-fixed table-col5'><div class='table-col-msg'><div class='en-label'>Year</div><div class='en-label'>Attended</div></div></div>");
            _html.AppendLine("                              <div class='table-col table-col-width-fixed table-col6'><div class='table-col-msg'><div class='en-label'>Admission</div><div class='en-label'>Type</div></div></div>");
            _html.AppendLine("                              <div class='table-col table-col-width-fixed table-col7'><div class='table-col-msg'><div class='en-label'>Student</div><div class='en-label'>Status</div></div></div>");
            _html.AppendLine("                              <div class='table-col table-col-width-fixed table-col8'><div class='table-col-msg'><div class='en-label'>Submitted Date</div></div></div>");
            _html.AppendLine("                              <div class='table-col table-col-width-fixed table-col9'><div class='table-col-msg'><div class='en-label'>Approval</div><div class='en-label'>Status</div></div></div>");
            _html.AppendLine("                              <div class='table-col table-col-width-fixed table-col10'><div class='table-col-msg'><div class='en-label'>Approval Date</div></div></div>");
            _html.AppendLine("                          </div>");
            _html.AppendLine("                      </div>");
            _html.AppendLine("                  </div>");
            _html.AppendFormat("                <div class='table-list'>{0}</div>", (_show.Equals(true) ? _searchResult["List"] : String.Empty));
            _html.AppendFormat("                <div class='table-navpage'>{0}</div>", (_show.Equals(true) ? _searchResult["NavPage"] : String.Empty));
            _html.AppendLine("              </div>");
            _html.AppendLine("          </div>");
            _html.AppendLine("      </div>");
            _html.AppendFormat("    <div class='form mainform' id='{0}-form'>", _idSectionMain);
            _html.AppendLine("          <div class='form-layout mainform-layout'>");
            _html.AppendLine("              <div class='form-content mainform-content'>");
            _html.AppendLine("                  <div class='titlebar'>");
            _html.AppendLine("                      <div class='th-label'></div>");
            _html.AppendLine("                      <div class='en-label'></div>");
            _html.AppendLine("                  </div>");
            _html.AppendLine("                  <div class='menulist'>");
            _html.AppendLine("                      <div class='menulist-layout'>");
            _html.AppendLine("                          <div class='menulist-content'>");
            _html.AppendLine("                              <ul>");

            for (_i = 0; _i < UDSStaffApproveDocumentUtil._menu.GetLength(0); _i++)
            {
                _html.AppendFormat("                            <li class='have-link'><a class='link-click link-msg' id='link-{0}' alt='{1}' href='javascript:void(0)'><div class='menu-itemtext'><div class='th-label'>{2}</div><div class='en-label'>{3}</div></div></a></li>", UDSStaffApproveDocumentUtil._menu[_i, 2].ToLower(), UDSStaffApproveDocumentUtil._menu[_i, 2], UDSStaffApproveDocumentUtil._menu[_i, 0], UDSStaffApproveDocumentUtil._menu[_i, 1]);
            }

            _html.AppendLine("                              </ul>");
            _html.AppendLine("                          </div>");
            _html.AppendLine("                          <div class='button-toggle'><a class='en-label' href='javascript:void(0)'>Click to Select Document</a></div>");
            _html.AppendLine("                      </div>");
            _html.AppendLine("                  </div>");
            _html.AppendFormat("                <input type='hidden' id='{0}-personid-hidden' value='' />", _idSectionEdit);
            _html.AppendFormat("                <div id='{0}-form' align='center'></div>", _idSectionEdit);
            _html.AppendLine("              </div>");
            _html.AppendLine("          </div>");
            _html.AppendLine("      </div>");
            _html.AppendLine("</div>");

            return(_html);
        }
예제 #8
0
        public static StringBuilder GetList(Dictionary <string, object> _infoLogin, DataRow[] _dr)
        {
            StringBuilder _html               = new StringBuilder();
            string        _userlevel          = _infoLogin["Userlevel"].ToString();
            string        _highlight          = String.Empty;
            string        _callFunc           = String.Empty;
            string        _documentUpload     = String.Empty;
            string        _submittedStatus    = String.Empty;
            string        _submittedDate      = String.Empty;
            string        _approvalStatus     = String.Empty;
            string        _approvalDate       = String.Empty;
            string        _iconApprove        = String.Empty;
            bool          _documentUploadDual = false;
            int           _i = 0;
            int           _j = 0;
            int           _k = 0;

            if (_dr.GetLength(0) > 0)
            {
                _html.AppendLine("<div class='table-grid'>");

                foreach (DataRow _dr1 in _dr)
                {
                    _documentUpload  = _dr1["documentUpload"].ToString().ToLower();
                    _submittedStatus = String.Empty;
                    _submittedDate   = String.Empty;
                    _approvalStatus  = String.Empty;
                    _approvalDate    = String.Empty;
                    _iconApprove     = String.Empty;

                    if (!String.IsNullOrEmpty(_documentUpload))
                    {
                        if (_documentUpload.Equals(UDSStaffUtil.SUBJECT_SECTION_PROFILEPICTUREIDCARD.ToLower()) ||
                            _documentUpload.Equals(UDSStaffUtil.SUBJECT_SECTION_TRANSCRIPT.ToLower()))
                        {
                            _documentUploadDual = true;

                            if (_documentUpload.Equals(UDSStaffUtil.SUBJECT_SECTION_PROFILEPICTUREIDCARD.ToLower()))
                            {
                                _j = 1;
                                _k = 2;
                            }

                            if (_documentUpload.Equals(UDSStaffUtil.SUBJECT_SECTION_TRANSCRIPT.ToLower()))
                            {
                                _j = 4;
                                _k = 5;
                            }
                        }

                        if (_documentUploadDual.Equals(true))
                        {
                            for (_i = _j; _i <= _k; _i++)
                            {
                                _documentUpload  = UDSStaffUtil._documentUpload[_i, 2].ToLower();
                                _submittedStatus = _dr1[_documentUpload + "SubmittedStatus"].ToString();
                                _submittedDate  += (!String.IsNullOrEmpty(_dr1[_documentUpload + "SubmittedDate"].ToString()) && _submittedStatus.Equals("Y") ? ("<div class='th-label'>" + DateTime.Parse(_dr1[_documentUpload + "SubmittedDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") + "</div>") : "<div class='th-label'>&nbsp;</div>");
                                _approvalStatus  = _dr1[_documentUpload + "ApprovalStatus"].ToString();
                                _approvalDate   += (!String.IsNullOrEmpty(_dr1[_documentUpload + "ApprovalDate"].ToString()) && (_approvalStatus.Equals("Y") || _approvalStatus.Equals("N")) ? ("<div class='" + _documentUpload + "-approvaldate th-label'>" + DateTime.Parse(_dr1[_documentUpload + "ApprovalDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") + "</div>") : "<div class='" + _documentUpload + "-approvaldate th-label'>&nbsp;</div>");
                                _iconApprove    += ("<div class='" + _documentUpload + "-approvalstatus uploaddocument-approvalstatus " + UDSStaffUtil.GetIconApprovalStatus(_approvalStatus) + " link-" + UDSStaffUtil.SUBJECT_SECTION_MEANINGOFAPPROVALSTATUS.ToLower() + "'><div class='en-label'>" + UDSStaffUtil._documentUpload[_i, 3] + "</div></div>");
                            }
                        }
                        else
                        {
                            _submittedStatus = _dr1[_documentUpload + "SubmittedStatus"].ToString();
                            _submittedDate   = (!String.IsNullOrEmpty(_dr1[_documentUpload + "SubmittedDate"].ToString()) && _submittedStatus.Equals("Y") ? ("<div class='th-label'>" + DateTime.Parse(_dr1[_documentUpload + "SubmittedDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") + "</div>") : "<div class='th-label'>&nbsp;</div>");
                            _approvalStatus  = _dr1[_documentUpload + "ApprovalStatus"].ToString();
                            _approvalDate    = (!String.IsNullOrEmpty(_dr1[_documentUpload + "ApprovalDate"].ToString()) && (_approvalStatus.Equals("Y") || _approvalStatus.Equals("N")) ? ("<div class='" + _documentUpload + "-approvaldate th-label'>" + DateTime.Parse(_dr1[_documentUpload + "ApprovalDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") + "</div>") : "<div class='" + _documentUpload + "-approvaldate th-label'>&nbsp;</div>");
                            _iconApprove     = ("<div class='" + _documentUpload + "-approvalstatus uploaddocument-approvalstatus " + UDSStaffUtil.GetIconApprovalStatus(_approvalStatus) + " link-" + UDSStaffUtil.SUBJECT_SECTION_MEANINGOFAPPROVALSTATUS.ToLower() + "'><div class='en-label'>" + _dr1["documentUploadInitials"].ToString() + "</div></div>");
                        }
                    }

                    _highlight = (double.Parse(_dr1["rowNum"].ToString()) % 2) == 0 ? " highlight-style2" : " highlight-style1";
                    _callFunc  = "Util.tut.getFrmPreviewDocument({" +
                                 "page:'" + UDSStaffUtil.PAGE_APPROVEDOCUMENTPROFILEPICTUREIDENTITYCARD_EDIT + "'," +
                                 "idMain:'" + _idSectionMain + "'," +
                                 "idPreview:'" + _idSectionEdit + "'," +
                                 "data:'" + _dr1["id"] + "'" +
                                 "},function(){})";

                    _html.AppendFormat("<div class='table-row{0}' id='table-row-id-{1}'>", _highlight, _dr1["id"]);
                    _html.AppendFormat("    <div class='table-col table-col-width-fixed table-col1' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, (double.Parse(_dr1["rowNum"].ToString()).ToString("#,##0")));
                    _html.AppendFormat("    <div class='table-col table-col-width-fixed table-col2' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, (!String.IsNullOrEmpty(_dr1["studentCode"].ToString()) ? _dr1["studentCode"].ToString() : "XXXXXXX"));
                    _html.AppendFormat("    <div class='table-col table-col-width-dynamic table-col3' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, Util.GetFullName(_dr1["titlePrefixInitialsTH"].ToString(), _dr1["titlePrefixFullNameTH"].ToString(), _dr1["firstName"].ToString(), _dr1["middleName"].ToString(), _dr1["lastName"].ToString()));
                    _html.AppendFormat("    <div class='table-col table-col-width-fixed table-col4' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, (!String.IsNullOrEmpty(_dr1["programCode"].ToString()) ? (_dr1["programCode"].ToString() + " " + _dr1["majorCode"].ToString() + " " + _dr1["groupNum"].ToString()) : String.Empty));
                    _html.AppendFormat("    <div class='table-col table-col-width-fixed table-col5' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, (!String.IsNullOrEmpty(_dr1["yearEntry"].ToString()) ? _dr1["yearEntry"].ToString() : String.Empty));
                    _html.AppendFormat("    <div class='table-col table-col-width-fixed table-col6'><div class='table-col-msg'><div class='th-label link-click link-{0}'>{1}</div></div></div>", UDSStaffUtil.SUBJECT_SECTION_MEANINGOFADMISSIONTYPE.ToLower(), (!String.IsNullOrEmpty(_dr1["perEntranceTypeId"].ToString()) ? _dr1["perEntranceTypeId"].ToString() : String.Empty));
                    _html.AppendFormat("    <div class='table-col table-col-width-fixed table-col7'><div class='table-col-msg'><div class='th-label link-click link-{0}'>{1}</div></div></div>", UDSStaffUtil.SUBJECT_SECTION_MEANINGOFSTUDENTSTATUS.ToLower(), (!String.IsNullOrEmpty(_dr1["status"].ToString()) ? _dr1["status"].ToString() : String.Empty));
                    _html.AppendFormat("    <div class='table-col table-col-width-fixed table-col8' onclick={0}><div class='table-col-msg'>{1}</div></div>", _callFunc, _submittedDate);
                    _html.AppendFormat("    <div class='table-col table-col-width-fixed table-col9'><div class='table-col-msg table-col-approvalstatus'>{0}</div></div>", _iconApprove);
                    _html.AppendFormat("    <div class='table-col table-col-width-fixed table-col10' onclick={0}><div class='table-col-msg table-col-approvaldate'>{1}</div></div>", _callFunc, _approvalDate);
                    _html.AppendLine("  </div>");
                }

                _html.AppendLine("</div>");
            }

            return(_html);
        }
예제 #9
0
            public static Dictionary <string, object> GetSearch(string _page, Dictionary <string, object> _paramSearch)
            {
                Dictionary <string, object> _loginResult  = UDSStaffUtil.GetInfoLogin("", "");
                Dictionary <string, object> _searchResult = new Dictionary <string, object>();
                DataSet _ds = new DataSet();

                DataRow[]     _dr                      = null;
                string        _reportName              = String.Empty;
                int           _recordCount             = 0;
                int           _recordCountPrimary      = 0;
                int           _recordCountSecondary    = 0;
                int           _recordCountAllPrimary   = 0;
                int           _recordCountAllSecondary = 0;
                StringBuilder _list                    = new StringBuilder();
                StringBuilder _navPage                 = new StringBuilder();

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL1VIEWTABLE_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL1VIEWTABLE;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENEEDSEND_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENEEDSEND;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENEEDSEND_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENEEDSEND;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESEND_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESEND;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESEND_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESEND;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENOTSEND_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENOTSEND;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENOTSEND_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENOTSEND;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDRECEIVE_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDRECEIVE;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDRECEIVE_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDRECEIVE;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDNOTRECEIVE_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDNOTRECEIVE;
                }

                if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDNOTRECEIVE_MAIN))
                {
                    _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDNOTRECEIVE;
                }

                _ds = UDSStaffDB.GetListUDSStudentRecords(
                    _loginResult["Username"].ToString(),
                    _loginResult["Userlevel"].ToString(),
                    _loginResult["SystemGroup"].ToString(),
                    _reportName,
                    _paramSearch
                    );

                if (_reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL1VIEWTABLE))
                {
                    _dr                 = _ds.Tables[1].Select();
                    _recordCount        = _ds.Tables[0].Rows.Count;
                    _recordCountPrimary = _ds.Tables[0].Rows.Count;

                    if (_recordCountPrimary > 0)
                    {
                        _list.AppendLine(UDSStaffOurServicesUI.AuditTranscriptApprovedUI.ViewTableUI.SectionMainUI.GetList(_page, _loginResult, _dr).ToString());
                        _navPage.AppendLine("<div class='navpage'><div class='navpage-layout'></div></div>");
                    }
                }

                if (_reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENEEDSEND) ||
                    _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESEND) ||
                    _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENOTSEND) ||
                    _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDRECEIVE) ||
                    _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDNOTRECEIVE))
                {
                    _dr                 = _ds.Tables[2].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
                    _recordCount        = _ds.Tables[2].Rows.Count;
                    _recordCountPrimary = _ds.Tables[2].Rows.Count;

                    _list.AppendLine(UDSStaffOurServicesUI.AuditTranscriptApprovedUI.ViewTableUI.SectionMainUI.GetList(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLE_MAIN, _loginResult, _dr).ToString());
                    _navPage.AppendLine(Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), _page, (int)(_paramSearch["RowPerPage"])).ToString());
                }

                if (_reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENEEDSEND) ||
                    _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESEND) ||
                    _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENOTSEND) ||
                    _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDRECEIVE) ||
                    _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDNOTRECEIVE))
                {
                    _dr                 = _ds.Tables[2].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
                    _recordCount        = _ds.Tables[2].Rows.Count;
                    _recordCountPrimary = _ds.Tables[2].Rows.Count;

                    _list.AppendLine(UDSStaffOurServicesUI.AuditTranscriptApprovedUI.ViewTableUI.SectionMainUI.GetList(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLE_MAIN, _loginResult, _dr).ToString());
                    _navPage.AppendLine(Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), _page, (int)(_paramSearch["RowPerPage"])).ToString());
                }

                _ds.Dispose();

                _searchResult.Add("RecordCount", _recordCount);
                _searchResult.Add("RecordCountPrimary", _recordCountPrimary);
                _searchResult.Add("RecordCountSecondary", _recordCountSecondary);
                _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary);
                _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary);
                _searchResult.Add("List", _list);
                _searchResult.Add("NavPage", _navPage);

                return(_searchResult);
            }