public ResponseResult SearchLoginHistory(LoginHistorySearchParam pSearchParam) { try { if (pSearchParam.SDate <= DateTime.MinValue) { pSearchParam.SDate = new DateTime(1900, 1, 1); } if (pSearchParam.EDate <= DateTime.MinValue) { pSearchParam.EDate = DateTime.MaxValue; } var result = DataService.SearchLoginHistory(pSearchParam); return(ResponseResult.GetSuccessObject(new { Count = result.ResultCount, LoginHistoryList = result.Result })); } catch (Exception ex) { CustomUtility.HandleException(ex); return(ResponseResult.GetErrorObject()); } }
public LoginHistorySearchResult SearchLoginHistory(LoginHistorySearchParam entity) { using (var ctx = new PRMDataContext()) { LoginHistorySearchResult result = new Entities.DBEntities.LoginHistorySearchResult(); string query = "execute sec.SearchLoginHistory @0, @1, @2,@3,@4,@5"; var cmd = ctx.Database.Connection.CreateCommand(); cmd.CommandText = query; cmd.Parameters.Add(new SqlParameter { ParameterName = "@0", Value = entity.Login }); cmd.Parameters.Add(new SqlParameter { ParameterName = "@1", Value = entity.MachineIp }); cmd.Parameters.Add(new SqlParameter { ParameterName = "@2", Value = entity.SDate }); cmd.Parameters.Add(new SqlParameter { ParameterName = "@3", Value = entity.EDate }); cmd.Parameters.Add(new SqlParameter { ParameterName = "@4", Value = entity.PageSize }); cmd.Parameters.Add(new SqlParameter { ParameterName = "@5", Value = entity.PageIndex }); ctx.Database.Connection.Open(); var reader = cmd.ExecuteReader(); result.ResultCount = ((IObjectContextAdapter)ctx) .ObjectContext .Translate <int>(reader).FirstOrDefault(); reader.NextResult(); result.Result = ((IObjectContextAdapter)ctx) .ObjectContext .Translate <LoginHistory>(reader).ToList(); foreach (var d in result.Result) { d.LoginTime = d.LoginTime.ToTimeZoneTime(tzi); } return(result); } }
public ResponseResult SearchLoginHistory(LoginHistorySearchParam u) { return(Repository.SearchLoginHistory(u)); }