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