public List<LoginLog> GetLoginLog(LoginLogFilter filter,int pageSize,int pageIndex,ref int recordCount)
{
SqlParameter[] parameters =
{
SqlParamHelper.MakeParam("@RecordNum",SqlDbType.Int,4,ParameterDirection.InputOutput,recordCount),
SqlParamHelper.MakeInParam("@SelectList",SqlDbType.VarChar,2000,LoginLog_FIELDS),
SqlParamHelper.MakeInParam("@TableSource",SqlDbType.VarChar,100,"[View_LoginLogUserInfo]"),
SqlParamHelper.MakeInParam("@SearchCondition",SqlDbType.VarChar,2000,GetSearchCondition(filter)),
SqlParamHelper.MakeInParam("@OrderExpression",SqlDbType.VarChar,1000,"[LoginDate]"),
SqlParamHelper.MakeInParam("@PageSize",SqlDbType.Int,4,pageSize),
SqlParamHelper.MakeInParam("@PageIndex",SqlDbType.Int,4,pageIndex)
};
List<LoginLog> list = new List<LoginLog>();
using (IDataReader dr = SqlHelper.ExecuteReader(ReadConnectionString,CommandType.StoredProcedure,"PR_GetDataByPageIndex",parameters)){
while(dr.Read()){
list.Add(BindLoginLog(dr));
}
}
try{
recordCount = Convert.ToInt32(parameters[0].Value);
}
catch{
recordCount = 0;
}
return list;
}
public EasyUiGrid<LoginLog> GetLoginLog(LoginLogFilter filter,int pageSize,int pageIndex,ref int recordCount)
{
List<LoginLog> loginlogs = _LoginLogRepository.GetLoginLog(filter,pageSize,pageIndex,ref recordCount);
EasyUiGrid<LoginLog> list = new EasyUiGrid<LoginLog>();
list.total = loginlogs.Count;
list.rows = loginlogs;
return list;
}
private void Seach()
{
try{
int recordCount = 0;
LoginLogFilter loginlogfilter = new LoginLogFilter();
loginlogfilter.TrueName = GetRequestString("truename");
loginlogfilter.Status = GetRequestString("status").ToInt32();
string begindate = GetRequestString("begindate");
if(!begindate.IsNullOrEmpty()){
loginlogfilter.BeginOfTime = begindate.ToDateTime();
}
string enddate = GetRequestString("enddate");
if(!enddate.IsNullOrEmpty()){
loginlogfilter.EndOfTime = enddate.ToDateTime();
}
EasyUiGrid<LoginLog> loginlogs = _LoginLogService.GetLoginLog(loginlogfilter,PageSize,PageIndex,ref recordCount);
Json(loginlogs);
}
catch{
Json(new EasyUiGrid<LoginLog>());
}
}
private string GetSearchCondition(LoginLogFilter filter)
{
StringBuilder condition = new StringBuilder("1=1");
if(filter.Id > 0){
condition.Append(string.Format(" and Id ={0}",filter.Id));
}
if(!filter.LoginIP.IsNullOrEmpty()){
condition.Append(string.Format(" and LoginIP like '%{0}%'",filter.LoginIP.Trim().ToSafeSql()));
}
if(!filter.TrueName.IsNullOrEmpty()){
condition.Append(string.Format(" and TrueName like '%{0}%'",filter.TrueName.Trim().ToSafeSql()));
}
if(filter.Status != -1){
condition.Append(string.Format(" and Status={0}",filter.Status));
}
if(filter.BeginOfTime != DateTime.MinValue){
condition.AppendFormat(" and LoginDate >= '{0:yyyy-MM-dd HH:mm:00}'",filter.BeginOfTime);
}
if(filter.EndOfTime != DateTime.MinValue){
condition.AppendFormat(" and LoginDate <= '{0:yyyy-MM-dd HH:mm:00}'",filter.EndOfTime);
}
return condition.ToString();
}
