/// <summary>
/// 添加登录日志
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddLoginLog(LoginLogModel model)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@OpenID", model.OpenID);
param[1] = new SqlParameter("@NickName", model.NickName);
try
{
int i = SQLHelper.ExecuteNonQuery(CommandType.Text, @"INSERT INTO dbo.LoginLog
( ID,
OpenID,
NickName,
LoginTime )
VALUES ( NEWID(), -- ID - uniqueidentifier
@OpenID, -- OpenID - nvarchar(100)
@NickName, -- NickName - nvarchar(50)
GETDATE() -- LoginTime - nvarchar(50)
)", param);
return(i > 0);
}
catch (Exception ex)
{
return(false);
throw ex;
}
}
/// <summary>
/// Created By :Bhushan Dod
/// Created Date: 26-05-2015
/// Description : For Save log of login to trac the employee idle state
/// </summary>
/// <param name="objLoginLogModel"></param>
/// <returns>LogId</returns>
public long SaveLoginLog(LoginLogModel objLoginLogModel)
{
LoginLog Obj = new LoginLog();
try
{
Obj.UserID = objLoginLogModel.UserID;
Obj.LocationId = objLoginLogModel.LocationId;
Obj.UserType = objLoginLogModel.UserType;
Obj.CreatedBy = objLoginLogModel.UserID;
Obj.CreatedOn = DateTime.UtcNow;
Obj.DeletedBy = null;
Obj.DeletedOn = null;
Obj.IsDeleted = false;
Obj.ModifiedBy = null;
Obj.ModifiedOn = null;
Add(Obj);
long LogId = Obj.LogId;
return(LogId);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Almacena en base datos el historico de login de los usuarios
/// </summary>
/// <param name="sedeUsuario"></param>
/// <returns></returns>
public async Task SaveLogLogin(LoginLogModel sedeUsuario)
{
using (ApplicactionDbContext Db = new ApplicactionDbContext())
{
await Db.AddAsync(sedeUsuario);
await Db.SaveChangesAsync();
}
}
/// <summary>
/// 添加登录日志
/// </summary>
/// <param name="logModel">The log model.</param>
/// <returns>true if XXXX, false otherwise.</returns>
public bool AddLoginLog(LoginLogModel logModel)
{
string strSql = @"insert into BM_UserLoginLog(UserId,UserIdentity,BelongOne,ShopId,AppSystem,BelongShopId) values(@UserId,@UserIdentity,@BelongOne,@ShopId,@AppSystem,@BelongShopId)";
var param = new[] {
new SqlParameter("@UserId", logModel.UserId),
new SqlParameter("@UserIdentity", logModel.UserIdentity),
new SqlParameter("@BelongOne", logModel.BelongOne),
new SqlParameter("@ShopId", logModel.ShopId),
new SqlParameter("@AppSystem", logModel.AppSystem),
new SqlParameter("@BelongShopId", logModel.BelongShopId)
};
return(DbHelperSQLP.ExecuteNonQuery(WebConfig.getConnectionString(), CommandType.Text, strSql, param) > 0);
}
public object Post(LoginLogModel model)
{
if (model.WeChatUserModel.OpenId != null)
{
var wecharuser = _weChatUserService.GetWeChatUser(model.WeChatUserModel.OpenId);
if (wecharuser == null)
{
wecharuser = new WeChatUser
{
Id = Guid.NewGuid(),
OpenId = model.WeChatUserModel.OpenId,
NickName = model.WeChatUserModel.NickName,
Gender = (Gender)model.WeChatUserModel.Gender,
Language = model.WeChatUserModel.Language,
City = model.WeChatUserModel.City,
Province = model.WeChatUserModel.Province,
Headimgurl = model.WeChatUserModel.Headimgurl
};
_weChatUserService.Insert(wecharuser);
}
else
{
wecharuser.OpenId = model.WeChatUserModel.OpenId;
wecharuser.NickName = model.WeChatUserModel.NickName;
wecharuser.Gender = (Gender)model.WeChatUserModel.Gender;
wecharuser.Language = model.WeChatUserModel.Language;
wecharuser.City = model.WeChatUserModel.City;
wecharuser.Province = model.WeChatUserModel.Province;
wecharuser.Headimgurl = model.WeChatUserModel.Headimgurl;
_weChatUserService.Update();
}
var loginLogId = Guid.NewGuid();
if (_loginLogService.GetLoginLog(model.State) == null)
{
_loginLogService.Insert(new LoginLog
{
Id = loginLogId,
State = model.State,
CreateTime = DateTime.Now,
WeChatUser_Id = wecharuser.Id
});
model.CreateTime = DateTime.Now;
model.Id = loginLogId;
}
return(model);
}
return(null);
}
/// <summary>
/// 添加登录日志
/// </summary>
/// <param name="openid"></param>
/// <param name="nickname"></param>
public void AddLoginLog(string openid, string nickname)
{
try
{
LoginLogBLL bll = new LoginLogBLL();
LoginLogModel model = new LoginLogModel();
model.OpenID = openid;
model.NickName = nickname;
bll.AddLoginLog(model);
}
catch (Exception ex)
{
throw ex;
}
}
//LongPolling Action 2 - 异步处理完成，向客户端发送响应
public ActionResult LongPollingCompleted(LoginLogModel model)
{
var log = _loginLogService.GetLoginLog(model.Id);
if (log != null)
{
log.IsDeleted = true;
_loginLogService.Update();
var authenticationManager = HttpContext.GetOwinContext().Authentication;
var identity = UserService.CreateIdentity(log.WeChatUser, DefaultAuthenticationTypes.ApplicationCookie);
authenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
authenticationManager.SignIn(new AuthenticationProperties(), identity);
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 添加登录日志
/// </summary>
/// <param name="openid"></param>
/// <param name="nickname"></param>
public void AddLoginLog(string code, string nickname)
{
try
{
string openid = GetOpenidByCode(code);
LoginLogBLL bll = new LoginLogBLL();
LoginLogModel model = new LoginLogModel();
model.OpenID = openid;
model.NickName = nickname;
model.LoginTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
bll.AddLoginLog(model);
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult Index()
{
var identity = (ClaimsIdentity)User.Identity;
string id = identity.Claims.FirstOrDefault(c => c.Type == "Id").Value;
string cpf = identity.Claims.FirstOrDefault(c => c.Type == "Cpf").Value;
string name = identity.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Name).Value;
string email = identity.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Email).Value;
string mobilephone = identity.Claims.FirstOrDefault(c => c.Type == ClaimTypes.MobilePhone).Value;
string streetaddress = identity.Claims.FirstOrDefault(c => c.Type == ClaimTypes.StreetAddress).Value;
CadastroModel cadastro = new CadastroModel()
{
Id = Convert.ToInt32(id),
Cpf = cpf,
Name = name,
Email = email,
PhoneNumber = mobilephone,
Address = streetaddress
};
var cookie = Request.Cookies["Cadastro"];
LoginLogModel LoginLog = new LoginLogModel()
{
DataClient = cadastro,
Token = cookie
};
LoginLog.Create();
string dataArray = JsonConvert.SerializeObject(cadastro, Formatting.None);
//CREATE DATA COOKIES NOT SECURE
CookieOptions option = new CookieOptions();
option.Expires = DateTime.Now.AddDays(1);
option.Secure = false;
option.HttpOnly = true;
Response.Cookies.Append("Cadastro_UnSafe", dataArray, option);
return(View(cadastro));
}
/// <summary>
/// 登录日志列表
/// </summary>
/// <param name="time">查询条件</param>
/// <returns></returns>
public List <LoginLogModel> SelectLoginLOG(string time, int PageIndex, int PageSize)
{
List <LoginLogModel> logs = new List <LoginLogModel>();
try
{
Dictionary <string, string> values = new Dictionary <string, string>();
string sql;
if (time != null)
{
values = XmlHelper.ReadXml("SqlQuery", "getqueryloginlog");
sql = string.Format(values.First().Value, PageIndex, PageIndex * (PageSize - 1), time);
}
else
{
values = XmlHelper.ReadXml("SqlQuery", "selectloginloglist");
sql = string.Format(values.First().Value, PageIndex / PageSize, PageSize);
}
DataTable dt = SqlHelpers.GetDataTable(sql);
foreach (DataRow row in dt.Rows)
{
LoginLogModel log = new LoginLogModel();
log.ID = Convert.ToInt32(row["id"].ToString());
log.UserID = Convert.ToInt32(row["userid"].ToString());
log.UserName = row["username"].ToString();
log.RoleID = Convert.ToInt32(row["roleid"].ToString());
log.RoleName = row["rolename"].ToString();
log.ClientIP = row["clientip"].ToString();
log.CreateUser = row["createuser"].ToString();
log.LoginTime = Convert.ToDateTime(row["logintime"].ToString());
log.CreateTime = Convert.ToDateTime(row["createtime"].ToString());
logs.Add(log);
}
}
catch (Exception er)
{ FileLog.WriteLog("异常捕捉：Angel.Service.LoginLogService" + er.ToString()); }
return(logs);
}
/// <summary>
/// 添加登录日志
/// </summary>
/// <param name="logModel">The log model.</param>
/// <returns>true if XXXX, false otherwise.</returns>
public static bool AddLoginLog(LoginLogModel logModel)
{
using (var dal = FactoryDispatcher.LogFactory())
{
if (logModel.UserId > 0)
{
int shopId = ShopLogic.GetBelongShopId(logModel.ShopId);
if (shopId > 0)
{
logModel.BelongShopId = shopId;
}
else
{
logModel.BelongShopId = logModel.ShopId;
}
return(dal.AddLoginLog(logModel));
}
else
{
return(false);
}
}
}
public async Task <IActionResult> PostLoginLog(LoginLogModel loginLogModel)
{
Result <LoginLog> result = new Result <LoginLog>();
LoginLog loginLog = new LoginLog();
// change time zone
TimeZoneInfo timeInfo = TimeZoneInfo.FindSystemTimeZoneById("New Zealand Standard Time");
loginLogModel.CreatedAt = TimeZoneInfo.ConvertTimeFromUtc(loginLogModel.CreatedAt, timeInfo);
_mapper.Map(loginLogModel, loginLog);
try
{
_context.LoginLog.Add(loginLog);
await _context.SaveChangesAsync();
result.Data = loginLog;
return(Ok(result));
}
catch (Exception e)
{
result.IsSuccess = false;
result.ErrorMessage = e.Message;
return(BadRequest(result));
}
}
public ActionResult Index(string loginName, string pwd, string code)
{
#region 检查参数是否为空
//保留登录名
if (!string.IsNullOrWhiteSpace(loginName))
{
ViewBag.LoginName = loginName;
}
if (string.IsNullOrWhiteSpace(loginName))
{
this.ModelState.AddModelError("loginName", "请输入登录名！");
LoginErrorCounter();
return View();
}
if (string.IsNullOrWhiteSpace(pwd))
{
this.ModelState.AddModelError("pwd", "请输入密码！");
LoginErrorCounter();
return View();
}
#endregion
#region 检查验证码是否正确
int num = 0;
if (Request.Cookies["loginNum"] != null)
num = Convert.ToInt32(Request.Cookies["loginNum"].Value);
if (num >= 3)
{
string msg = CheckCode(code);
if (msg != "1")
{
this.ModelState.AddModelError("code", msg);
return View();
}
}
#endregion
#region 验证登录名、密码是否正确
UserModel user = UserModel.FirstOrDefault("where Code = @0 and Password = @1", loginName, pwd.VariationMd5());
if (user == null)
{
ModelState.AddModelError("loginName", "登录名或密码错误！");
LoginErrorCounter();
return View();
}
#endregion
#region 验证用户是否停用
if (user.DelFlag == 1)
{
ModelState.AddModelError("loginName", "账户已被停用，无法登录！");
LoginErrorCounter();
return View();
}
#endregion
#region 验证用户是否离职
if (user.Status == 1)
{
ModelState.AddModelError("loginName", "您已经离职，无法登录！");
LoginErrorCounter();
return View();
}
#endregion
#region 验证通过 登录成功
if (Request.Cookies["loginNum"] != null)
{
HttpCookie hc = Request.Cookies["loginNum"];
hc.Expires = DateTime.Now.AddDays(-1);
Response.AppendCookie(hc);
}
//将用户信息放入缓存
SysConfig.CurrentUser = user;
//将用户的角色信息放入缓存
SysConfig.CurrentRoleInfos = CommonMethod.GetRoleByUserId(SysConfig.CurrentUser.Id);
//将模块权限放入缓存
SysConfig.CurrentAuthInfo = CommonMethod.GetAccessByUserId(SysConfig.CurrentUser.Id);
string[] roleArray = SysConfig.CurrentRoleIds.Split(',');
if (!roleArray.Contains("13"))
{
//将部门权限放入缓存
SysConfig.CurrentDepAuthInfo = CommonMethod.GetDepAccess(SysConfig.CurrentRoleIds,
SysConfig.CurrentUser.Departmentid.ToString());
}
//记录登录日志
LoginLogModel log = new LoginLogModel();
log.Userid = user.Id.ToInt();
log.LoginTime = DateTime.Now;
log.LoginIp = SysConfig.GetClientIP();
log.Insert();
//如果没有转向页则跳到首页
if (!string.IsNullOrWhiteSpace(Request["ReturnUrl"]))
{
return Redirect(Request["ReturnUrl"]);
}
return Redirect("/Home/Main/Index");
#endregion
}
/// <summary>
/// 添加登录日志
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddLoginLog(LoginLogModel model)
{
return(dal.AddLoginLog(model));
}
