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