public void SetLoginSuccess(IDbSession sess, long userId)
{
SqlUpdate su = new SqlUpdate(sess);
su.Sql = "sys_user_t";
su.Set("nt_fcnt", 0);
su.Set("bn_locked", "false", true);
su.Set("ts_locked", (DateTime?)null);
su.Set("nt_login_cnt", "nt_login_cnt+1", true);
su.Set("ts_last_login", DateTime.Now);
su.Set("nt_r_ver", "nt_r_ver+1", true);
su.Where = "ng_id=@ng_id";
su.AddParam("@ng_id", userId);
su.ExecuteNonQuery();
}
public void SetLoginFailed(IDbSession sess, long userId, bool locked)
{
SqlUpdate su = new SqlUpdate(sess);
su.Sql = "sys_user_t";
su.Set("nt_fcnt", "nt_fcnt+1");
su.Set("bn_locked", locked?"true":"false", true);
if (locked)
{
su.Set("ts_locked", DateTime.Now.AddDays(1));
}
su.Set("nt_r_ver", "nt_r_ver+1", true);
su.Where = "ng_id=@ng_id";
su.AddParam("@ng_id", userId);
su.ExecuteNonQuery();
}
