/// <summary> /// 查询出席的讲座 /// </summary> /// <param name="Num"></param> /// <returns></returns> public List <Model.T_Base_Statistic> GetAllAttendance(string Num, int State) { List <Model.T_Base_Statistic> list = new List <Model.T_Base_Statistic>(); SqlConfig config = new SqlConfig(); SqlCommand cmd = config.getSqlCommand(); if (State == 0) { cmd.CommandText = "select * from V_Lecture_Statistic where Num = '" + Num + "'"; } else if (State == 1) { cmd.CommandText = "select * from V_Lecture_Statistic where Num = '" + Num + "' and EndTime <> '1900/1/1 0:00:00'"; } SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Model.T_Base_Statistic statistic = new Model.T_Base_Statistic(); Model.T_Base_Lecture lecture = new Model.T_Base_Lecture(); lecture.Id = Convert.ToInt32(reader["Id"]); lecture.Subject = Convert.ToString(reader["Subject"]); lecture.Score = Convert.ToDouble(reader["Score"]); lecture.RealPeople = Convert.ToInt32(reader["RealPeople"]); lecture.LectureTime = Convert.ToDateTime(reader["LectureTime"]); statistic.Id = Convert.ToInt32(reader["StatisticId"]); statistic.Num = Convert.ToString(reader["Num"]); statistic.StartTime = Convert.ToDateTime(reader["StartTime"]); statistic.EndTime = Convert.ToDateTime(reader["EndTime"]); statistic.Lecture = lecture; list.Add(statistic); } reader.Close(); config.Close(); return(list); }
/// <summary> /// 查询参与讲座人员信息 /// </summary> /// <param name="LectureId"></param> /// <returns></returns> public List <Model.T_Base_Statistic> SavePeopleExcel(int LectureId) { List <Model.T_Base_Statistic> list = new List <Model.T_Base_Statistic>(); SqlConfig config = new SqlConfig(); SqlCommand cmd = config.getSqlCommand(); cmd.CommandText = "select * from V_Excel where LectureId = " + LectureId; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Model.T_Base_Statistic statistic = new Model.T_Base_Statistic(); Model.T_Base_User user = new Model.T_Base_User(); user.Num = Convert.ToString(reader["Num"]); user.Name = Convert.ToString(reader["Name"]); user.Sex = Convert.ToInt16(reader["Sex"]); user.PhoneNum = Convert.ToString(reader["PhoneNum"]); Model.T_Base_Architecture architecture = new Model.T_Base_Architecture(); architecture.ArchitectureName = Convert.ToString(reader["ArchitectureName"]); Model.T_Base_MajorClass majorClass = new Model.T_Base_MajorClass(); majorClass.Architecture = architecture; majorClass.MajorClassName = Convert.ToString(reader["MajorClassName"]); user.MajorClass = majorClass; statistic.StartTime = Convert.ToDateTime(reader["StartTime"]); statistic.EndTime = Convert.ToDateTime(reader["EndTime"]); statistic.User = user; list.Add(statistic); } reader.Close(); config.Close(); return(list); }