/// <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);
}
