public ForgotPasswordSearchResult SearchForgotPasswordLog(ForgotPasswordSearchParam entity)
{
using (var ctx = new PRMDataContext())
{
ForgotPasswordSearchResult result = new ForgotPasswordSearchResult();
string query = "execute sec.SearchForgotPasswordLog @0, @1, @2,@3,@4";
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.SDate
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@2", Value = entity.EDate
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@3", Value = entity.PageSize
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@4", 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 <ForgotPasswordLogDTO>(reader).ToList();
foreach (var d in result.Result)
{
d.EntyDate = d.EntyDate.ToTimeZoneTime(tzi);
}
return(result);
}
}
public ResponseResult SearchForgotPasswordLog(ForgotPasswordSearchParam 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.SearchForgotPasswordLog(pSearchParam);
return(ResponseResult.GetSuccessObject(new
{
Count = result.ResultCount,
ForgotPasswordLogList = result.Result
}));
//return (new
//{
// data = new
// {
// Count = result.ResultCount,
// ForgotPasswordLogList = result.Result
// },
// success = true,
// error = ""
//});
}
catch (Exception ex)
{
CustomUtility.HandleException(ex);
return(ResponseResult.GetErrorObject());
}
}
public ResponseResult SearchForgotPasswordLog(ForgotPasswordSearchParam u)
{
return(Repository.SearchForgotPasswordLog(u));
}
