/*--------------登录-----------*/
public CommonOutputT <user> logon(string name, string password, string IC, string face)
{
RDDataContext rd = new RDDataContext();
CommonOutputT <user> returnData = new CommonOutputT <user>();
loginLog log = new loginLog();
if (!String.IsNullOrEmpty(IC))
{
IQueryable <user> x = from a in rd.user
where IC == a.IC
select a;
if (x.Count() != 0)
{
log.id = Guid.NewGuid().ToString();
log.isOK = "success";
log.time = DateTime.Now.ToString("");
log.userID = x.FirstOrDefault().id;
rd.loginLog.InsertOnSubmit(log);
rd.SubmitChanges();
returnData.success = true;
returnData.message = "success";
returnData.data = x.FirstOrDefault();
rd.Dispose(); return(returnData);
}
return(returnData);
}
if (!String.IsNullOrEmpty(face))
{
IQueryable <user> x = from a in rd.user
where face == a.face
select a;
if (x.Count() != 0)
{
log.id = Guid.NewGuid().ToString();
log.isOK = "success";
log.time = DateTime.Now.ToString("");
log.userID = x.FirstOrDefault().id;
rd.loginLog.InsertOnSubmit(log);
rd.SubmitChanges();
returnData.success = true;
returnData.message = "success";
returnData.data = x.FirstOrDefault();
rd.Dispose(); return(returnData);
}
return(returnData);
}
if (!String.IsNullOrEmpty(name) && !String.IsNullOrEmpty(password))
{
IQueryable <user> x = from a in rd.user
where (name == a.name && password == a.password)
select a;
if (x.Count() != 0)
{
log.id = Guid.NewGuid().ToString();
log.isOK = "success";
log.time = DateTime.Now.ToString("");
log.userID = x.FirstOrDefault().id;
rd.loginLog.InsertOnSubmit(log);
rd.SubmitChanges();
returnData.success = true;
returnData.message = "success";
returnData.data = x.FirstOrDefault();
rd.Dispose(); return(returnData);
}
return(returnData);
}
else
{
returnData.success = false;
returnData.message = "账号为空，请重新登录！";
rd.Dispose(); return(returnData);
}
}
public static List<loginLog> GetLoginLogDetail(string userName, string roleName, DateTime dateFrom, DateTime dateTo)
{
List<loginLog> resloginLog = new List<loginLog>();
loginLog objloginLogGet = null;
if (dateFrom == Convert.ToDateTime("01/01/1900") && dateTo == Convert.ToDateTime("01/01/1900"))
{
var result = from userLock in DbContextHelper.DbContext.SecLoginLog
join user in DbContextHelper.DbContext.SecUser on userLock.UserId equals user.UserId
join role in DbContextHelper.DbContext.SecRole on user.RoleId equals role.RoleId
where (user.UserName == (userName == string.Empty ? user.UserName : userName)
|| role.RoleName == (userName == string.Empty ? role.RoleName : userName))
orderby user.UserId
select new
{
UserName = user.UserName,
RoleName = role.RoleName,
UserId = userLock.UserId,
LoginTime = userLock.LoginTime,
LogoutTime = userLock.LogoutTime,
Sucess = userLock.Sucess
};
foreach (var get in result)
{
objloginLogGet = new loginLog();
objloginLogGet.UserId = (int?)get.UserId;
objloginLogGet.UserName = get.UserName;
objloginLogGet.RoleName = get.RoleName;
objloginLogGet.LoginTime = get.LoginTime;
objloginLogGet.LogoutTime = get.LogoutTime;
resloginLog.Add(objloginLogGet);
}
}
else
{
string DateFrom = dateFrom.ToShortDateString();
var dtf=dateFrom.ToShortDateString();
//DateTime dtf = new DateTime(Convert.ToInt32(DateFrom.Substring(6, 4)), Convert.ToInt32(DateFrom.Substring(3, 2)), Convert.ToInt32(DateFrom.Substring(0, 2)));
DateTime rangeStart = new DateTime(dateFrom.Year, dateFrom.Month, dateFrom.Day, 0, 0, 0);
DateTime rangeEnd = new DateTime(dateTo.Year, dateTo.Month, dateTo.Day, 23, 59, 59);
var result = from userLock in DbContextHelper.DbContext.SecLoginLog
join user in DbContextHelper.DbContext.SecUser on userLock.UserId equals user.UserId
join role in DbContextHelper.DbContext.SecRole on user.RoleId equals role.RoleId
where (user.UserName == (userName == string.Empty ? user.UserName : userName)
|| role.RoleName == (userName == string.Empty ? role.RoleName : userName))
&& userLock.LoginTime >= rangeStart
&& userLock.LogoutTime <= rangeEnd
//&& userLock.LogoutTime >= dateFrom
//&& userLock.LogoutTime <= dateTo
orderby user.UserId
select new
{
UserName = user.UserName,
RoleName = role.RoleName,
UserId = userLock.UserId,
LoginTime = userLock.LoginTime,
LogoutTime = userLock.LogoutTime,
Sucess = userLock.Sucess
};
foreach (var get in result)
{
objloginLogGet = new loginLog();
objloginLogGet.UserId = (int?)get.UserId;
objloginLogGet.UserName = get.UserName;
objloginLogGet.RoleName = get.RoleName;
objloginLogGet.LoginTime = get.LoginTime;
objloginLogGet.LogoutTime = get.LogoutTime;
resloginLog.Add(objloginLogGet);
}
}
return resloginLog;
}
public static List <loginLog> GetLoginLogDetail(string userName, string roleName, DateTime dateFrom, DateTime dateTo)
{
List <loginLog> resloginLog = new List <loginLog>();
loginLog objloginLogGet = null;
if (dateFrom == Convert.ToDateTime("01/01/1900") && dateTo == Convert.ToDateTime("01/01/1900"))
{
var result = from userLock in DbContextHelper.DbContext.SecLoginLog
join user in DbContextHelper.DbContext.SecUser on userLock.UserId equals user.UserId
join role in DbContextHelper.DbContext.SecRole on user.RoleId equals role.RoleId
where (user.UserName == (userName == string.Empty ? user.UserName : userName) ||
role.RoleName == (userName == string.Empty ? role.RoleName : userName))
orderby user.UserId
select new
{
UserName = user.UserName,
RoleName = role.RoleName,
UserId = userLock.UserId,
LoginTime = userLock.LoginTime,
LogoutTime = userLock.LogoutTime,
Sucess = userLock.Sucess
};
foreach (var get in result)
{
objloginLogGet = new loginLog();
objloginLogGet.UserId = (int?)get.UserId;
objloginLogGet.UserName = get.UserName;
objloginLogGet.RoleName = get.RoleName;
objloginLogGet.LoginTime = get.LoginTime;
objloginLogGet.LogoutTime = get.LogoutTime;
resloginLog.Add(objloginLogGet);
}
}
else
{
string DateFrom = dateFrom.ToShortDateString();
var dtf = dateFrom.ToShortDateString();
//DateTime dtf = new DateTime(Convert.ToInt32(DateFrom.Substring(6, 4)), Convert.ToInt32(DateFrom.Substring(3, 2)), Convert.ToInt32(DateFrom.Substring(0, 2)));
DateTime rangeStart = new DateTime(dateFrom.Year, dateFrom.Month, dateFrom.Day, 0, 0, 0);
DateTime rangeEnd = new DateTime(dateTo.Year, dateTo.Month, dateTo.Day, 23, 59, 59);
var result = from userLock in DbContextHelper.DbContext.SecLoginLog
join user in DbContextHelper.DbContext.SecUser on userLock.UserId equals user.UserId
join role in DbContextHelper.DbContext.SecRole on user.RoleId equals role.RoleId
where (user.UserName == (userName == string.Empty ? user.UserName : userName) ||
role.RoleName == (userName == string.Empty ? role.RoleName : userName)) &&
userLock.LoginTime >= rangeStart &&
userLock.LogoutTime <= rangeEnd
//&& userLock.LogoutTime >= dateFrom
//&& userLock.LogoutTime <= dateTo
orderby user.UserId
select new
{
UserName = user.UserName,
RoleName = role.RoleName,
UserId = userLock.UserId,
LoginTime = userLock.LoginTime,
LogoutTime = userLock.LogoutTime,
Sucess = userLock.Sucess
};
foreach (var get in result)
{
objloginLogGet = new loginLog();
objloginLogGet.UserId = (int?)get.UserId;
objloginLogGet.UserName = get.UserName;
objloginLogGet.RoleName = get.RoleName;
objloginLogGet.LoginTime = get.LoginTime;
objloginLogGet.LogoutTime = get.LogoutTime;
resloginLog.Add(objloginLogGet);
}
}
return(resloginLog);
}
