/// <summary>
/// 读取员工订餐信息
/// </summary>
/// <returns>员工订餐信息实体集</returns>
public static List <Model.Book_Dinner> GetDinnerList()
{
string sql = "select * from Book_Dinner";
List <Model.Book_Dinner> list = new List <Model.Book_Dinner>();
SqlDataReader dataReader = SQLHelper.GetSqlDataReader(sql, CommandType.Text);
if (dataReader != null)
{
while (dataReader.Read())
{
list.Add(new Model.Book_Dinner()
{
Bd_id = (int)dataReader["Bd_id"], book_time = (DateTime)dataReader["book_time"], Emp_Name = dataReader["Emp_Name"] as string, work_no = dataReader["work_no"] as string
});
}
}
SQLHelper.Close();
return(list);
}
/// <summary>
/// 查询部门信息
/// </summary>
/// <returns>部门信息数据集</returns>
public static List <Model.Department> GetDepartmentList()
{
string sql = "select * from Department";
List <Model.Department> list = new List <Model.Department>();
SqlDataReader dataReader = SQLHelper.GetSqlDataReader(sql, CommandType.Text);
if (dataReader != null)
{
while (dataReader.Read())
{
list.Add(new Model.Department()
{
ID = (int)dataReader["ID"], Name = dataReader["DeName"] as string
});
}
}
SQLHelper.Close();
return(list);
}
/// <summary>
/// 获取所有颜色信息集合
/// </summary>
/// <returns>颜色信息集合</returns>
public static List <Model.Colors> GetColorsList()
{
string sql = " select * from Colors";
List <Model.Colors> list = new List <Model.Colors>();
SqlDataReader reader = SQLHelper.GetSqlDataReader(sql, CommandType.Text);
if (reader != null)
{
while (reader.Read())
{
list.Add(new Model.Colors()
{
ColorId = (int)reader["ColorId"], ColorCode = reader["ColorCode"] as string, Name = reader["Name"] as string, Matching = reader["Matching"] as string
});
}
}
SQLHelper.Close();
return(list);
}
/// <summary>
/// 查询员工信息方法
/// </summary>
/// <returns>员工信息数据集</returns>
public static List <Model.Employee> GetEmployeeList()
{
List <Model.Employee> list = new List <Model.Employee>();
string sql = "select E.*,D.DeName from Employee E inner join Department D on E.DID = D.Id";
SqlDataReader dataReader = SQLHelper.GetSqlDataReader(sql, CommandType.Text);
if (dataReader != null)
{
while (dataReader.Read())
{
list.Add(new Model.Employee()
{
ID = (int)dataReader["ID"], Age = (int)dataReader["Age"], Name = dataReader["Name"] as string, Sex = dataReader["Sex"] as string, DepartmentName = dataReader["DeName"] as string, DID = (int)dataReader["DID"]
});
}
}
SQLHelper.Close();
return(list);
}
/// <summary>
/// 获取所有新闻信息
/// </summary>
/// <returns>新闻信息集合</returns>
public static List <Model.newsInfo> GetNewsList()
{
string sql = "select T.nType ,I.* from newsType T inner join newsInfo I on T.nId = I.[type_Id]";
List <Model.newsInfo> list = new List <Model.newsInfo>();
SqlDataReader reader = SQLHelper.GetSqlDataReader(sql, CommandType.Text);
if (reader != null)
{
while (reader.Read())
{
list.Add(new Model.newsInfo()
{
addTime = (DateTime)reader["addTime"], content = reader["content"] as string, newsId = (int)reader["newsId"], nType = reader["nType"] as string, title = reader["title"] as string, type_Id = (int)reader["type_Id"]
});
}
}
SQLHelper.Close();
return(list);
}
/// <summary>
/// 查询员工信息
/// </summary>
/// <returns>员工信息集合</returns>
public static List <Model.Employees> GetEmployeesList()
{
string sql = "select * from Employee";
List <Model.Employees> list = new List <Model.Employees>();
SqlDataReader dataReader = SQLHelper.GetSqlDataReader(sql, CommandType.Text);
if (dataReader != null)
{
while (dataReader.Read())
{
list.Add(new Model.Employees()
{
EmpId = (int)dataReader["EmpId"], Emp_Name = dataReader["Emp_Name"] as string, Emp_No = dataReader["Emp_No"] as string, Password = dataReader["Password"] as string
});
}
}
SQLHelper.Close();
return(list);
}
