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