public List <Room> Rname() { var list = tableRoom.Query();//获取所有实验室信息 List <Room> userList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Room, Room>(c)); return(userList); }
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 <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 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 List <Dto.LeaveBaseDto> GetAll() { var list = LeaveRepository.Query(); List <LeaveBaseDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Leave, LeaveBaseDto>(c)); return(qqList); }
public List <RoomDto> GetAll() { var list = room.Query(); List <RoomDto> roomList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Room, RoomDto>(c)); return(roomList); }
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); }
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 <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 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 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 <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 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); }
/// <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 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); }
public bool DelDtoData(DateTime DutyStart, int User_ID) { Duty oDuty = new Duty(); oDuty.DutyStart = DutyStart; oDuty.User_ID = User_ID; var List = LabRepository.Query().Where(c => c.User_ID == oDuty.User_ID && c.DutyStart == oDuty.DutyStart); List <Duty> DelList = List.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Duty, Duty>(c)); //NoticeList[0].Enabled = 0; //LabRepository.Update(NoticeList[0]); if (DelList.Count < 1) { //没有这条数据 return(false); } else { LabRepository.Delete(DelList[0].ID); return(true); } }
public List <SumBaseDto> GetAll(string nickName, string nickTime) { var query = SumRepository.Query();//.OrderByDescending(a => a.Time); if (!String.IsNullOrEmpty(nickName)) { query = query.Where(m => m.User.Real_Name.Contains(nickName)); } if (!String.IsNullOrEmpty(nickTime)) { string StartTime = nickTime.Split('-')[0]; DateTime startTime = Convert.ToDateTime(StartTime); string EndTime = nickTime.Split('-')[1]; DateTime endTime = Convert.ToDateTime(EndTime); query = query.Where(m => m.Time >= startTime && m.Time <= endTime); } query = query.OrderByDescending(a => a.Time); List <SumBaseDto> SumList = query.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Summary, SumBaseDto>(c)); return(SumList); }
public bool userSign(int UID, string ip) { //string Uip = (HttpContext.Current.Request.ServerVariables["HTTP_VIA"] != null) ? HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString() : HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"].ToString();//修改IP信息 string UIP = ""; if (UIP != ip) { return(false); } DateTime time = DateTime.Now; Attendance att = new Attendance(); att.Time = time; att.User_ID = UID; att.Type = 1; att.Shift = time_Shift(time.ToString()); if (att.Shift < 10 && att.Shift != 4) { att.State = 1; } else if (att.Shift > 10) { att.State = 2; att.Shift = att.Shift - 10; } string dateday = time.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.Type == att.Type) && (c.User_ID == att.User_ID) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } return(true); }
public void LeaveInsert(DateTime star, DateTime end, int uid) { Attendance att = new Attendance(); att.User_ID = uid; att.Type = 1; for (; star.CompareTo(end) < 0; star = star.AddDays(1)) { if (star.AddDays(1).CompareTo(end) >= 0) { break; } string dateday = star.ToString("yyyy-MM-dd"); DateTime flagday = Convert.ToDateTime(dateday); DateTime flagday_end = flagday.AddDays(1); string time1 = dateday + " 08:00:00"; att.Time = Convert.ToDateTime(time1); att.Shift = 1; att.State = 3; if (star.CompareTo(att.Time) <= 0) { var list = tableAttendance.Query().Where(c => (c.Time >= flagday) && (c.Time <= flagday_end) && (c.Type == att.Type) && (c.User_ID == uid) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } } string time2 = dateday + " 14:00:00"; att.Time = Convert.ToDateTime(time2); att.Shift = 2; att.State = 3; if (star.CompareTo(att.Time) <= 0) { var list = tableAttendance.Query().Where(c => (c.Time >= flagday) && (c.Time <= flagday_end) && (c.Type == att.Type) && (c.User_ID == uid) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } } string time3 = dateday + " 19:00:00"; att.Time = Convert.ToDateTime(time3); att.Shift = 3; att.State = 3; if (star.CompareTo(att.Time) <= 0) { var list = tableAttendance.Query().Where(c => (c.Time >= flagday) && (c.Time <= flagday_end) && (c.Type == att.Type) && (c.User_ID == uid) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } } } string dateday1 = star.ToString("yyyy-MM-dd"); DateTime flagday1 = Convert.ToDateTime(dateday1); DateTime flagday_end1 = flagday1.AddDays(1); DateTime time11 = Convert.ToDateTime(dateday1 + " 11:30:00"); if (time11.CompareTo(end) <= 0 && star.CompareTo(time11) <= 0) { string time1 = dateday1 + " 08:00:00"; att.Time = Convert.ToDateTime(time1); att.Shift = 1; att.State = 3; var list = tableAttendance.Query().Where(c => (c.Time >= flagday1) && (c.Time <= flagday_end1) && (c.Type == att.Type) && (c.User_ID == uid) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } } DateTime time21 = Convert.ToDateTime(dateday1 + " 17:30:00"); if (time21.CompareTo(end) <= 0 && star.CompareTo(time21) <= 0) { string time1 = dateday1 + " 14:00:00"; att.Time = Convert.ToDateTime(time1); att.Shift = 2; att.State = 3; var list = tableAttendance.Query().Where(c => (c.Time >= flagday1) && (c.Time <= flagday_end1) && (c.Type == att.Type) && (c.User_ID == uid) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } } DateTime time31 = Convert.ToDateTime(dateday1 + " 20:30:00"); if (time31.CompareTo(end) <= 0 && star.CompareTo(time31) <= 0) { string time1 = dateday1 + " 19:00:00"; att.Time = Convert.ToDateTime(time1); att.Shift = 3; att.State = 3; var list = tableAttendance.Query().Where(c => (c.Time >= flagday1) && (c.Time <= flagday_end1) && (c.Type == att.Type) && (c.User_ID == uid) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } } if (int.Parse(dateday1.Split('-')[2]) < int.Parse(end.ToString("yyyy-MM-dd").Split('-')[2])) { string dateday2 = end.ToString("yyyy-MM-dd"); DateTime flagday2 = Convert.ToDateTime(dateday2); DateTime flagday_end2 = flagday2.AddDays(1); DateTime time12 = Convert.ToDateTime(dateday2 + " 11:30:00"); if (time12.CompareTo(end) <= 0 && star.CompareTo(time12) <= 0) { string time1 = dateday2 + " 08:00:00"; att.Time = Convert.ToDateTime(time1); att.Shift = 1; att.State = 3; var list = tableAttendance.Query().Where(c => (c.Time >= flagday2) && (c.Time <= flagday_end2) && (c.Type == att.Type) && (c.User_ID == uid) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } } DateTime time22 = Convert.ToDateTime(dateday2 + " 17:30:00"); if (time22.CompareTo(end) <= 0 && star.CompareTo(time22) <= 0) { string time1 = dateday2 + " 14:00:00"; att.Time = Convert.ToDateTime(time1); att.Shift = 2; att.State = 3; var list = tableAttendance.Query().Where(c => (c.Time >= flagday2) && (c.Time <= flagday_end2) && (c.Type == att.Type) && (c.User_ID == uid) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } } DateTime time32 = Convert.ToDateTime(dateday2 + " 20:30:00"); if (time32.CompareTo(end) <= 0 && star.CompareTo(time32) <= 0) { string time1 = dateday2 + " 19:00:00"; att.Time = Convert.ToDateTime(time1); att.Shift = 3; att.State = 3; var list = tableAttendance.Query().Where(c => (c.Time >= flagday2) && (c.Time <= flagday_end2) && (c.Type == att.Type) && (c.User_ID == uid) && (c.Shift == att.Shift)); List <AttendanceDto> qqList = list.ToList().ConvertAll(c => AutoMapperHelp.ConvertToDto <Attendance, AttendanceDto>(c)); int count = qqList.Count(); if (count <= 0) { tableAttendance.Add(att); } } } }