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