public List <Room> Rname() { var list = tableRoom.Query();//获取所有实验室信息 List <Room> userList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Room, Room>(c)); return(userList); }
public bool InsertInfo(RegisterDto UserInfo) { try { User uList = AutoMapperHelp.ConvertModel <User, RegisterDto>(UserInfo); //var roomList = room.Query().Where(m=>m.Name == UserInfo.Room_Name); uList.Room_ID = UserInfo.Room_ID; uList.Image = "../../images/user.jpg"; uList.Motto = null; if (UserInfo.U_Role == 2) { uList.IsExamine = true; } else { uList.IsExamine = false; } uList.IP = null; uList.Register_Time = DateTime.Now; User insertList = Information.Add(uList); //int insertCount = insertList.Equipment.Count(); //return insertCount; return(true); } catch { return(false); } }
public List <DutyDto> GetDuty() { var list = LabRepository.Query(); List <DutyDto> DutyList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Duty, DutyDto>(c)); return(DutyList); }
public List <RegisterDto> GetEmailInfo(string Email) { var list = Information.Query().Where(m => m.Email == Email); List <RegisterDto> infoList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <User, RegisterDto>(c)); return(infoList); }
public List <RoomDto> GetAll() { var list = room.Query(); List <RoomDto> roomList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Room, RoomDto>(c)); return(roomList); }
public List <UserDto> GetUser(int id) { var list = qqRepository.Query().Where(c => c.ID == id); List <UserDto> UserList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <User, UserDto>(c)); return(UserList); }
public bool InsertSum(SumBaseDto summary) { try { Summary list = AutoMapperHelp.ConvertModel <Summary, SumBaseDto>(summary); var date = DateTime.Now; int dayweek = (int)date.DayOfWeek; if (dayweek == 0) { dayweek = 7; } DateTime startTime = date.AddDays(-(dayweek)); DateTime endTime = date.AddDays(7 - dayweek); DateTime time = date; list.User_ID = Convert.ToInt32(LoginBase.ID); list.Time = time; list.Start_Time = startTime; list.End_Time = endTime; Summary sumDt = SumRepository.Add(list); return(true); } catch { return(false); } }
public List <RegisterDto> GetPhoneInfo(string Phone) { var list = Information.Query().Where(m => m.Phone == Phone); List <RegisterDto> infoList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <User, RegisterDto>(c)); return(infoList); }
public List <SumBaseDto> GetSumList(string nickName, string nickTimes, int curPage, int PageSize, string roomID, out long recordCount) //public List<SumBaseDto> GetSumList(string nickName, string nickTimes, int curPage, int PageSize, out long recordCount) { var query = SumRepository.Query(); if (!String.IsNullOrEmpty(nickName)) { query = query.Where(m => m.User.Real_Name.Contains(nickName)); } if (!String.IsNullOrEmpty(nickTimes)) { string StartTime = nickTimes.Split('-')[0]; DateTime startTime = Convert.ToDateTime(StartTime); string EndTime = nickTimes.Split('-')[1]; DateTime endTime = Convert.ToDateTime(EndTime); query = query.Where(m => m.Time >= startTime && m.Time <= endTime); } if (!String.IsNullOrEmpty(roomID)) { query = query.Where(m => m.User.Room_ID.ToString() == roomID); } recordCount = query.Count(); query = query.OrderByDescending(m => m.Time).Skip((curPage - 1) * PageSize).Take(PageSize); List <SumBaseDto> SumList = query.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Summary, SumBaseDto>(c)); return(SumList); }
public List <Dto.LeaveBaseDto> GetAll() { var list = LeaveRepository.Query(); List <LeaveBaseDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Leave, LeaveBaseDto>(c)); return(qqList); }
public List <NoticeDto> GetNotice() { var list = LabRepository.Query().Where(c => c.Enabled == 1); List <NoticeDto> NoticeList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Notice, NoticeDto>(c)); return(NoticeList); }
public List <UserManDto> getUserManage(string userName, int pageSize, int curPage, string userRole, bool selectIsTea, int roomID, out long recordCount) { var query = userManage.Query().Where(m => m.U_Role == 3); if (userRole == "R001") { if (selectIsTea) { query = userManage.Query().Where(m => m.U_Role == 2); } else { query = userManage.Query().Where(m => m.U_Role == 3 || m.U_Role == 2); } } if (!String.IsNullOrEmpty(userName)) { query = query.Where(m => m.Name == userName || m.Real_Name == userName || m.Phone == userName || m.Email == userName); } if (roomID != 0) { query = query.Where(m => m.Room_ID == roomID); } recordCount = query.Count(); query = query.OrderBy(m => m.U_Role).ThenByDescending(m => m.Register_Time).Skip((curPage - 1) * pageSize).Take(pageSize); List <UserManDto> adminList = query.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <User, UserManDto>(c)); return(adminList); }
public void Ecxel_add(string time, int uid) { Attendance att = new Attendance(); att.Shift = time_Shift(time); att.User_ID = uid; att.Type = 2; if (att.Shift < 10 && att.Shift != 4) { att.State = 1; } else if (att.Shift > 10) { att.State = 2; att.Shift = att.Shift - 10; } att.Time = Convert.ToDateTime(time); var list = tableAttendance.Query().Where(c => (c.Time >= att.Time) && (c.Type == att.Type) && (c.User_ID == uid)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); AttendanceDto tt = qqList.FirstOrDefault(); Attendance ss = AutoMapperHelp.ConvertModel <Attendance, AttendanceDto>(tt); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } }
public List <Sign_dateModel> Get_data(int UID, int type) { var list = tableAttendance.Query().Where(c => c.User_ID == UID && c.Type == type); //? List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); AttendanceDto tt = qqList.FirstOrDefault(); Attendance ss = AutoMapperHelp.ConvertModel <Attendance, AttendanceDto>(tt); int count = qqList.Count(); List <Sign_dateModel> Sign_dataList = new List <Sign_dateModel>(); for (int i = 0; i < count; i++) { string face = "( ^ _ ^ )"; Sign_dateModel Sign_data = new Sign_dateModel(); if (qqList[i].State == 1)//签到状态 正常 { Sign_data.color = "green"; } else if (qqList[i].State == 2)//签到状态迟到 { Sign_data.color = "bleak"; face = "(っ°Д°;)っ"; } else if (qqList[i].State == 3)//签到状态请假 { Sign_data.color = "red"; face = "( > _ < )"; } Sign_data.id = qqList[i].Shift; //签到次序 Sign_data.start = qqList[i].Time.ToString("yyyy-MM-dd HH:mm:ss"); //签到时间 Sign_data.end = qqList[i].Time.ToString("yyyy-MM-dd"); if (qqList[i].Shift == 1) { Sign_data.title = face + "早"; //Sign_data.start += " 08:30:00"; //Sign_data.end += " 11:30:00"; } else if (qqList[i].Shift == 2) { Sign_data.title = face + "中";//( > _ < ) //Sign_data.start += " 14:30:00"; //Sign_data.end += " 17:30:00"; } else if (qqList[i].Shift == 3) { //∑(っ °Д °;)っ Sign_data.title = face + "晚"; //Sign_data.start += " 19:00:00"; //Sign_data.end += " 20:30:00"; } Sign_dataList.Add(Sign_data); } return(Sign_dataList); }
public bool Is_Sign_In(int UID) { string time = DateTime.Now.TimeOfDay.ToString(); string day = DateTime.Now.Date.ToString(); int Shift = time_Shift(time); if (Shift > 10) { Shift -= 10; } else if (Shift == 4) { return(true); } DateTime daydt = Convert.ToDateTime(day); string dateday = daydt.ToString("yyyy-MM-dd"); DateTime flagday = Convert.ToDateTime(dateday); DateTime flagday_end = flagday.AddDays(1); var list = tableAttendance.Query().Where(c => (c.Time >= flagday) && (c.Time <= flagday_end) && (c.User_ID == UID) && (c.Shift == Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count > 0) { return(true); } return(false); }
public int get_uid(string name) { var list = tableUser.Query().Where(c => c.Real_Name == name && c.U_Role == 3);//获取学生的信息 List <User_name_uidDto> userList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <User, User_name_uidDto>(c)); return(userList[0].ID); }
public List <User_name_uidDto> getUser() { var list = tableUser.Query().Where(c => c.U_Role == 3 && c.IsExamine == true);//获取所有学生的信息 List <User_name_uidDto> userList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <User, User_name_uidDto>(c)); return(userList); }
/// <summary> /// 获取对应ID的单条数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public EquipBaseDto GetEquipPer(int id) { var list = EquipRepository.Query().Where(c => c.ID == id); List <EquipBaseDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Equipment, EquipBaseDto>(c)); EquipBaseDto tt = qqList.FirstOrDefault(); return(tt); }
public LeaveBaseDto GetLeavePer(int id) { var list = LeaveRepository.Query().Where(c => c.ID == id); List <LeaveBaseDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Leave, LeaveBaseDto>(c)); LeaveBaseDto tt = qqList.FirstOrDefault(); return(tt); }
List <EUserBaseDto> IUserService.GetAll() { var list = UserRepository.Query(); List <EUserBaseDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <User, EUserBaseDto>(c)); EUserBaseDto tt = qqList.FirstOrDefault(); //Leave ss = AutoMapperHelp.ConvertModel<Leave, LeaveBaseDto>(tt); // 反向转换为Mode int count = list.Count(); return(qqList); }
//public List<Dto.LoginBaseDto> GetAll() //{ // //var list = userRepository.Query(); // //List<LoginBaseDto> UserList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto<User, LoginBaseDto>(c)); // //LoginBaseDto m = UserList.FirstOrDefault(); // // User n= AutoMapperHelp.ConvertModel<User, LoginBaseDto>(m); // // return UserList; //} public LoginBaseDto Get(string username, string password) { var query = userRepository.Query().Where(m => (m.Name == username || m.Email == username || m.Phone == username || m.Real_Name == username) && m.Password == password); if (query != null && query.Count() > 0) { var model = query.FirstOrDefault(); return(AutoMapperHelp.ConvertToDto <User, LoginBaseDto>(model)); } return(null); }
public List <UserBaseDto> GetAll(int ID) { var list = userRepository.Query().Where(m => m.ID == ID); List <UserBaseDto> userList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <User, UserBaseDto>(c)); UserBaseDto tt = userList.FirstOrDefault(); User ss = AutoMapperHelp.ConvertModel <User, UserBaseDto>(tt); int count = list.Count(); return(userList); }
public LoginBaseDto GetPwd(string username, string Realname, string phone, string Email) { var query = userRepository.Query().Where(m => m.Name == username && m.Real_Name == Realname && m.Phone == phone && m.Email == Email); //List<LoginBaseDto> UserList = query.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto<User, LoginBaseDto>(c)); if (query != null && query.Count() > 0) { var model = query.FirstOrDefault(); return(AutoMapperHelp.ConvertToDto <User, LoginBaseDto>(model)); } return(null); }
public bool InsertInfo(LeaveBaseDto Leaveinfo) { try { Leave uList = AutoMapperHelp.ConvertModel <Leave, LeaveBaseDto>(Leaveinfo); Leave insertList = LeaveRepository.Add(uList); return(true); } catch { return(false); } }
/// <summary> /// 数据插入 /// </summary> /// <param name="Leaveinfo"></param> /// <returns></returns> public bool InsertInfo(EquipBaseDto Leaveinfo) { try { Equipment uList = AutoMapperHelp.ConvertModel <Equipment, EquipBaseDto>(Leaveinfo); Equipment insertList = EquipRepository.Add(uList); return(true); } catch { return(false); } }
public List <Dto.UserBaseDto> GetAll() { var list = UserRepository.Query(); List <UserBaseDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <User, UserBaseDto>(c)); UserBaseDto tt = qqList.FirstOrDefault(); //Leave ss = AutoMapperHelp.ConvertModel<Leave, LeaveBaseDto>(tt); // 反向转换为Mode int count = list.Count(); return(qqList); throw new NotImplementedException(); }
/// <summary> /// 根据条件获取数据 /// </summary> /// <param name="nickName"></param> /// <param name="curPage"></param> /// <param name="PageSize"></param> /// <param name="recordCount"></param> /// <returns></returns> List <EquipBaseDto> IEquipService.GetEquipList(string nickName, int curPage, int PageSize, out long recordCount) { var query = EquipRepository.Query(); if (!String.IsNullOrEmpty(nickName) && nickName != "undefined") { query = query.Where(m => m.Equipment_Name == nickName); } recordCount = query.Count(); query = query.OrderByDescending(m => m.ID).Skip((curPage - 1) * PageSize).Take(PageSize); List <EquipBaseDto> EquipList = query.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Equipment, EquipBaseDto>(c)); return(EquipList); }
public static List <MenuModel> GetMenuList(int level, int pid) { using (Lab_ManagementEntities lab = new Lab_ManagementEntities()) { if (string.IsNullOrEmpty(LoginBase.RoleId)) { return(null); } int roleId = Convert.ToInt32(LoginBase.RoleId); //var aa = lab.RoleMenu.Where(m => m.Role_ID == roleId).Select(m=>m.Menu_ID); //var bb = lab.Menu.Where(m => aa.Contains(m.ID)); var menuList = lab.Menu.Where(m => m.RoleMenu.Select(n => n.Role_ID).Contains(roleId)).Where(m => m.PID == pid); List <MenuModel> menuDtoList = menuList.ToList().ConvertAll(m => AutoMapperHelp.ConvertToDto <Menu, MenuModel>(m)); return(menuDtoList); } }
public List <LeaveBaseDto> GetLeaveList(string nickName, string nickTime, int curPage, int PageSize, string room, out long recordCount) { var query = LeaveRepository.Query();//.OrderByDescending(a=>a.Time); if (@LoginBase.RoleCode.Contains("R003"))//登陆者为学生 { try { int a = Convert.ToInt32(@LoginBase.ID); query = query.Where(m => m.User_ID == a); } catch { } } else if (!String.IsNullOrEmpty(room) && room != "undefined" && room != "--请选择实验室--") { query = query.Where(m => m.User.Room_ID.ToString() == room); } if (!String.IsNullOrEmpty(nickName) && nickName != "undefined" && nickName != "请输入真实姓名") { query = query.Where(m => m.User.Real_Name == nickName); } //查询某个时间段 if (!String.IsNullOrEmpty(nickTime) && nickTime != "undefined" && nickTime != "请选择查询时间段") { var StartTime = Convert.ToDateTime(nickTime.Split('-')[0]); var EndTime = Convert.ToDateTime(nickTime.Split('-')[1]); try { query = query.Where(m => (m.Start_Time < StartTime && m.End_Time >= StartTime) || (m.Start_Time >= StartTime && m.Start_Time <= EndTime)); } catch { }; } recordCount = query.Count(); query = query.OrderByDescending(m => m.ID).Skip((curPage - 1) * PageSize).Take(PageSize); List <LeaveBaseDto> LeaveList = query.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Leave, LeaveBaseDto>(c)); return(LeaveList); }
public bool InsertNoticeData(string oNoticeTitle, string oNoticeText, DateTime oNowTime, int UserId) { Notice aTable = new Notice(); aTable.Enabled = 1; aTable.Text = oNoticeText; aTable.Title = oNoticeTitle; aTable.Time = oNowTime; aTable.User_ID = UserId; var list = LabRepository.Query().Where(c => c.Enabled == 1); List <Notice> NoticeList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Notice, Notice>(c)); if (NoticeList.Count != 0) { NoticeList[0].Enabled = 0; LabRepository.Update(NoticeList[0]); } LabRepository.Add(aTable); return(true); }