Web/Model/SubjectExtend.cs

（开头部分） 2KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;
using System.Web.UI.WebControls;//Please add references

namespace StudentExamination.Model
{
    //扩展Department类，增加自定义的方法

    public partial class Subject
    {
        
        /// <summary>
        /// 获取绑定Subject的数据集
        /// </summary>
        public void BindSubject(DropDownList ddl,string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select SubjectID,SubjectTitle,TeacherID ");
            strSql.Append(" FROM [Subject] ");
            //strSql.Append(" where SubjectID=@SubjectID ");
            if (strWhere != "")
            {
                strSql.Append("  where  ");
                strSql.Append(strWhere);
            }
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            DataRow dr = ds.Tables[0].NewRow();
            dr["SubjectTitle"] = "全部科目";
            dr["SubjectID"] = "0";
           
            ds.Tables[0].Rows.InsertAt(dr,0);

            ddl.DataSource = ds;
            
            ddl.DataTextField = "SubjectTitle";
            ddl.DataValueField = "SubjectID";
            ddl.DataBind();
        }
        public DataSet GetStudentSubject(int StudentID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select SubjectID,subjectTitle + ' ('+ teachername +')'  as SubjectTitle ");
            strSql.Append(" FROM [SubjectView]   ");
            strSql.AppendFormat(" where departmentID in (select departmentID from student where studentId = {0}) ", StudentID);
          
            return DbHelperSQL.Query(strSql.ToString());
        }
        /// <summary>
        ///批量删除数据
        /// </summary>
        public bool DeleteList(string DptIDlist)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from Department ");
            strSql.Append(" where DptID in (" + DptIDlist + ")  ");
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
            if (rows > 0)
后面还有 11 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。