1using System;
  2using System.Data;
  3using System.Collections;
  4using System.Data.SqlClient;
  5using OnLineExam.DataAccessLayer;
  6using OnLineExam.DataAccessHelper;
  7
  8
  9namespace OnLineExam.BusinessLogicLayer
 10...{
 11    //用户类
 12    public class Scores
 13    ...{
 14        私有成员#region 私有成员
 15        private int _ID;                                              
 16        private string _userID;                                       
 17        private int _paperID;                                       
 18        private int _score;
 19        private DateTime _examtime;//考试时间
 20        private DateTime _judgetime;  //评阅时间   
 21        private string _pingyu;  //评阅时间    
 22       
 23        #endregion 私有成员
 24
 25        属性#region 属性
 26
 27        public int ID
 28        ...{
 29            set
 30            ...{
 31                this._ID = value;
 32            }
 33            get
 34            ...{
 35                return this._ID;
 36            }
 37        }
 38        public string UserID
 39        ...{
 40            set
 41            ...{
 42                this._userID = value;
 43            }
 44            get
 45            ...{
 46                return this._userID;
 47            }
 48        }
 49        public int PaperID
 50        ...{
 51            set
 52            ...{
 53                this._paperID = value;
 54            }
 55            get
 56            ...{
 57                return this._paperID;
 58            }
 59        }
 60        public int Score
 61        ...{
 62            set
 63            ...{
 64                this._score = value;
 65            }
 66            get
 67            ...{
 68                return this._score;
 69            }
 70        }
 71        public DateTime ExamTime
 72        ...{
 73            set
 74            ...{
 75                this._examtime = value;
 76            }
 77            get
 78            ...{
 79                return this._examtime;
 80            }
 81        }
 82        public DateTime JudgeTime
 83        ...{
 84            set
 85            ...{
 86                this._judgetime = value;
 87            }
 88            get
 89            ...{
 90                return this._judgetime;
 91            }
 92        }
 93        public string PingYu
 94        ...{
 95            set
 96            ...{
 97                this._pingyu = value;
 98            }
 99            get
100            ...{
101                return this._pingyu;
102            }
103        }       
104        
105        #endregion 属性
106
107        方法#region 方法
108
109        //向Score表中添加成绩
110        //输出：
111        //      插入成功：返回True；
112        //      插入失败：返回False；
113        public bool InsertByProc()
114        ...{
115            SqlParameter[] Params = new SqlParameter[6];
116
117            DataBase DB = new DataBase();
118
119            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20, UserID);              
120            Params[1] = DB.MakeInParam("@PaperID", SqlDbType.Int,4, PaperID);                   
121            Params[2] = DB.MakeInParam("@Score", SqlDbType.Int,4, Score);                      
122            Params[3] = DB.MakeInParam("@ExamTime", SqlDbType.DateTime, 8,ExamTime);
123            Params[4] = DB.MakeInParam("@JudgeTime", SqlDbType.DateTime, 8, DateTime.Now);
124            Params[5] = DB.MakeInParam("@PingYu", SqlDbType.VarChar, 1000, PingYu);    
125
126            int Count = -1;
127            Count = DB.RunProc("Proc_ScoreAdd", Params);
128            if (Count > 0)
129                return true;
130            else return false;
131        }
132        public bool CheckScore(string XUserID,int XPaperID)
133        ...{
134            SqlParameter[] Params = new SqlParameter[2];
135            DataBase DB = new DataBase();
136
137            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20, XUserID);
138            Params[1] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, XPaperID);
139
140            SqlDataReader DR = DB.RunProcGetReader("Proc_ScoreDetail", Params);
141            if (!DR.Read())
142            ...{
143                return false;
144            }
145            else
146            ...{
147                return true;
148            }
149        }
150        
151        //删除成绩
152        //输入：
153        //      XUserID - 用户编号；
154        //输出：
155        //      删除成功：返回True；
156        //      删除失败：返回False；
157        public bool DeleteByProc(int SID)
158        ...{
159            SqlParameter[] Params = new SqlParameter[1];
160
161            DataBase DB = new DataBase();
162
163            Params[0] = DB.MakeInParam("@ID", SqlDbType.Int,4, SID);               //成绩编号          
164            
165            int Count = -1;
166            Count = DB.RunProc("Proc_ScoreDelete", Params);
167            if (Count > 0)
168                return true;
169            else return false;
170        }
171        
172        //查询所用成绩
173        //不需要参数
174        public DataSet QueryScore()
175        ...{
176            DataBase DB = new DataBase();           
177            return DB.GetDataSet("Proc_ScoreList");
178        }
179
180        //查询某个用户成绩       
181        public DataSet QueryUserScore(string XUserID)
182        ...{
183            SqlParameter[] Params = new SqlParameter[1];
184            DataBase DB = new DataBase();
185            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20,XUserID);    
186            return DB.GetDataSet("Proc_UserScore",Params);
187        }
188
189        
190
191        #endregion 方法
192    }
193}