コード例 #1
0
        /// <summary>
        /// 获取辅导员所带班级HTML
        /// </summary>
        /// <returns></returns>
        private string GetFdyClassData()
        {
            string         strSQL   = string.Format("SELECT CLASSCODE AS VALUE, CLASSNAME AS TEXT FROM BASIC_CLASS_INFO WHERE 1=1 ");
            string         strWhere = string.Empty;
            string         strOrder = " ORDER BY CLASSCODE ASC ";
            ComHandleClass chc      = new ComHandleClass();

            if (user.User_Role.Equals("S"))
            {
                strWhere += string.Format(" AND CLASSCODE = '{0}' ", chc.BySGetClassCode(user.User_Id));
            }
            //用户角色是辅导员的,只能看到所带班级的数据
            if (user.User_Role.Equals("F"))
            {
                string strFClass = chc.GetNoRepeatAndNoEmptyStringSql(chc.ByFGetClassCode(user.User_Id));
                if (!string.IsNullOrEmpty(strFClass))
                {
                    strWhere += string.Format(" AND CLASSCODE IN ({0})", strFClass);
                }
                else
                {
                    strWhere += string.Format(" AND 1=2 ", strFClass);
                }
            }
            strSQL = strSQL + strWhere + strOrder;
            DataTable dt = ds.ExecuteTxtDataTable(strSQL);

            StringBuilder sbHtml = new StringBuilder();

            foreach (DataRow row in dt.Rows)
            {
                if (row == null)
                {
                    continue;
                }
                sbHtml.Append("<div class=\"form-group col-sm-12\">");
                sbHtml.Append("<div class=\"col-sm-8\">");
                sbHtml.Append("<input name=\"fdy_class\" id=\"" + row["VALUE"].ToString() + "\"  type=\"checkbox\" value=\"" + row["VALUE"].ToString() + "\" class=\"flat-red\"/>&nbsp;&nbsp;<label for=\"" + row["VALUE"].ToString() + "\">" + row["TEXT"].ToString() + "</label>&nbsp;&nbsp;");
                sbHtml.Append("</div>");
                sbHtml.Append("</div>");
            }

            return(sbHtml.ToString());
        }