/// <summary>
/// 获取总分
/// </summary>
/// <param name="Num"></param>
/// <returns></returns>
public double GetScore(string Num)
{
double result = 0;
SqlConfig config = new DAL.SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "select * from V_Excel where Num = '" + Num + "'";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (!(Convert.ToDateTime(reader["EndTime"]).ToString("yyyy/MM/dd HH:mm:ss").Equals("1900/01/01 00:00:00")))
{
result += Convert.ToDouble(reader["Score"]);
string[] score = result.ToString().Split('.');
if (score[1] == "99")
{
result = Convert.ToDouble(score[0] + 1);
}
}
}
reader.Close();
config.Close();
return(result);
}
/// <summary>
/// 讲座出现变更通知
/// </summary>
/// <param name="Num"></param>
/// <returns></returns>
public List <Model.T_Base_Order> GetOrderMsg(string Num)
{
List <Model.T_Base_Order> list = new List <Model.T_Base_Order>();
SqlConfig config = new DAL.SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "select * from V_Lecture_Order where Num='" + Num + "' and State = 1 and AlertFlag = 1 and MsgFlag = 0";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Model.T_Base_Order order = new Model.T_Base_Order();
order.Lecture = new Model.T_Base_Lecture();
order.LectureId = Convert.ToInt32(reader["LectureId"]);
order.Lecture.Subject = Convert.ToString(reader["Subject"]);
list.Add(order);
}
reader.Close();
cmd.CommandText = "select * from V_Lecture_Order where Num = '" + Num + "' and MsgFlag = 0 and result = 3";
reader = cmd.ExecuteReader();
while (reader.Read())
{
Model.T_Base_Order order = new Model.T_Base_Order();
order.Lecture = new Model.T_Base_Lecture();
order.LectureId = Convert.ToInt32(reader["LectureId"]);
order.Lecture.Subject = Convert.ToString(reader["Subject"]);
order.Result = Convert.ToInt16(reader["Result"]);
list.Add(order);
}
reader.Close();
config.Close();
return(list);
}
public List <Model.T_Base_RoleMenu> GetRoleMenu(int RoleId)
{
List <Model.T_Base_RoleMenu> list = new List <Model.T_Base_RoleMenu>();
SqlConfig config = new DAL.SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "select * from V_RoleMenu where RoleId = " + RoleId;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Model.T_Base_RoleMenu roleMenu = new Model.T_Base_RoleMenu();
roleMenu.Id = Convert.ToInt32(reader["Id"]);
roleMenu.RoleId = Convert.ToInt32(reader["RoleId"]);
roleMenu.RoleName = Convert.ToString(reader["RoleName"]);
roleMenu.Memo = Convert.ToString(reader["Memo"]);
roleMenu.MenuId = Convert.ToInt32(reader["MenuId"]);
roleMenu.Controller = Convert.ToString(reader["Controller"]);
roleMenu.Action = Convert.ToString(reader["Action"]);
roleMenu.Display = Convert.ToString(reader["Display"]);
list.Add(roleMenu);
}
reader.Close();
config.Close();
return(list);
}
/// <summary>
/// 举报隐藏信息
/// </summary>
/// <param name="ResourceId"></param>
/// <returns></returns>
public int ResourceReport(int ResourceId)
{
int result = -1;
SqlConfig config = new DAL.SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "update T_Base_Resource set ReViewFlag = 1";
result = cmd.ExecuteNonQuery();
config.Close();
return(result);
}
/// <summary>
/// 审核评论
/// </summary>
/// <returns></returns>
public List <Model.T_Base_Resource> GetResourceMsg()
{
List <Model.T_Base_Resource> list = new List <Model.T_Base_Resource>();
SqlConfig config = new DAL.SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "select Id,LectureId,Content from T_Base_Resource where ReViewFlag = 1 and MsgFlag = 0";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Model.T_Base_Resource resource = new Model.T_Base_Resource();
resource.Id = Convert.ToInt32(reader["Id"]);
resource.LectureId = Convert.ToInt32(reader["LectureId"]);
resource.Content = Convert.ToString(reader["Content"]);
list.Add(resource);
}
reader.Close();
config.Close();
return(list);
}
//public int GetOrderCount(string Num)
//{
// SqlConfig config = new DAL.SqlConfig();
// SqlCommand cmd = config.getSqlCommand();
// cmd.CommandText = "select count(*) from V_Lecture_Order where Num='" + Num + "' and MsgFlag=1";
// int result = (int)cmd.ExecuteScalar();
// config.Close();
// return result;
//}
/// <summary>
/// 实际人数超出预期人数的讲座个数
/// </summary>
/// <param name="LcetureId"></param>
/// <returns></returns>
public List <Model.T_Base_Lecture> GetLectureMsg(string Num)
{
List <Model.T_Base_Lecture> list = new List <Model.T_Base_Lecture>();
SqlConfig config = new DAL.SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "select Id, Subject from T_Base_Lecture where Id in" +
"(select LectureId from T_Base_Apply where Num = '" + Num + "') and " +
"RealPeople > ExpectPeople";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Model.T_Base_Lecture lecture = new Model.T_Base_Lecture();
lecture.Id = Convert.ToInt32(reader["Id"]);
lecture.Subject = Convert.ToString(reader["Subject"]);
list.Add(lecture);
}
reader.Close();
config.Close();
return(list);
}
