DAL/GradeDal.cs

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

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace DAL
{
    public class GradeDal
    {
        //教师提交学生的成绩信息   
        public bool insert(Model.Grade g)
        {
            string strsql = "insert into Grade(StuNo,ClassNo,IntGrade,SpoGrade,MorGrade,RerGrade,ComGrade,Year,Query) values ( '{0}' , '{1}' , '{2}' ,'{3}'  ,'{4}' ,'{5}' ,'{6}','{7}' ,'否')";
            strsql = string.Format(strsql, g.StuNo, g.ClassNo,g.IntGrade, g.SpoGrade, g.MorGrade, g.RerGrade, g.ComGrade, g.Year);
            if (DBUnility.DBHelperSQL.ExeSQL(strsql) > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        //根据学号和学年查看是否存在该条数据
        public bool Exist(Model.Grade g)
        {
            string strsql = "select * from Grade where StuNo='{0}' and Year='{1}'";
            strsql = string.Format(strsql, g.StuNo, g.Year);
            DataSet ds = new DataSet();
            ds = DBUnility.DBHelperSQL.GetDataBySQL(strsql);
            if (ds.Tables[0].Rows.Count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        //根据班级号和学年查找班级综合排名信息
        public DataSet Select(Model.Grade g)
        {
            string strsql = "select Grade.StuNo 学号 ,Student.StuName 姓名,Grade.ComGrade 综合成绩,Student.StuHanging 挂科 ,Grade.Year 获得学年,Grade.Query 质疑,Grade.State 状态 from Grade join Student on Grade.StuNo= Student.StuNo where Grade.ClassNo='{0}' and Grade.Year='{1}' order by Grade.ComGrade DESC";
            strsql = string.Format(strsql, g.ClassNo,g.Year);
            return DBUnility.DBHelperSQL.GetDataBySQL(strsql);

        }
        //更具班级号和学年更新成绩状态审核中
        public bool upDate(Model.Grade g)
        {
            string strsql = "update Grade set  State='审核中' where ClassNo='{0}' and Year='{1}'";
            strsql = string.Format(strsql, g.ClassNo,g.Year);
            if (DBUnility.DBHelperSQL.ExeSQL(strsql) > 0)
            {
                return true;
            }
            else
            {