//提交查询
private void btnQuery_Click(object sender, EventArgs e)
{
objLog = new LoginLogPageQuery()
{
PageSize = Convert.ToInt32(this.cboPageSize.Text),
BeginTime = Convert.ToDateTime(this.dtpStart.Text),
EndTime = Convert.ToDateTime(this.dtpEnd.Text).AddDays(1.0)
};
try
{
//获取数据总量
objLog.RecordCount = objPageQuery.GetRecordCount(objLog);
this.lblRecordCount.Text = objLog.RecordCount.ToString();
//获取分页DataSet
objDS = objPageQuery.GetLoginLogPageQueryDS(objLog);
this.dgvLogs.DataSource = objDS.Tables[objLog.CurrentPage];
}
catch (Exception ex)
{
MessageBox.Show("数据库发生错误，请检查连接或联系管理员！", "错误提示");
new ErrorLogManager().ErrorLog(new ErrorLog()
{
LoginId = Program.objCurrentAdmin.LoginId,
Operate = Operate.ErrorHappenedWhenLoginLogPageQuery,
ErrorMessage = ex.Message
});
return;
}
//计算当前页
this.lblCurrentPage.Text = (objLog.CurrentPage + 1).ToString();
//计算总页数
int pageCount = objLog.RecordCount / objLog.PageSize;
objLog.PageCount = objLog.RecordCount % objLog.PageSize == 0 ? pageCount : pageCount + 1;
this.lblPageCount.Text = objLog.PageCount.ToString();
if (objLog.PageCount == 0)
{
MessageBox.Show("该查询下无数据！", "查询提示");
return;
}
//所有按钮开启
this.btnFirst.Enabled = true;
this.btnNext.Enabled = true;
this.btnPrevious.Enabled = true;
this.btnLast.Enabled = true;
this.btnGoTo.Enabled = true;
//关闭不需要的按钮
if (objLog.PageCount == 1)
{
this.btnFirst.Enabled = false;
this.btnNext.Enabled = false;
this.btnPrevious.Enabled = false;
this.btnLast.Enabled = false;
this.btnGoTo.Enabled = false;
}
}
/// <summary>
/// 查询总数据量
/// </summary>
/// <param name="objLog"></param>
/// <returns></returns>
public int GetRecordCount(LoginLogPageQuery objLog)
{
string sql = "select count(*) from Loginlogs where LoginTime between @BeginTime and @EndTime";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@BeginTime", objLog.BeginTime),
new SqlParameter("@EndTime", objLog.EndTime)
};
try
{
return(Convert.ToInt32(SQLHelper.GetSingleResult(sql, parameters)));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 使用存储过程分页查询LoginLogs
/// </summary>
/// <param name="objLog"></param>
/// <returns></returns>
public DataSet GetLoginLogPageQuery(LoginLogPageQuery objLog)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@PageSize", objLog.PageSize),
new SqlParameter("@RecordCount", objLog.RecordCount),
new SqlParameter("@BeginTime", objLog.BeginTime),
new SqlParameter("@EndTime", objLog.EndTime)
};
try
{
return(SQLHelper.GetDataSetByProcedure("usp_LoginLogsPagingQuery", parameters));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public int GetRecordCount(LoginLogPageQuery objLog)
{
return(objPageQuery.GetRecordCount(objLog));
}
public DataSet GetLoginLogPageQueryDS(LoginLogPageQuery objLog)
{
return(objPageQuery.GetLoginLogPageQuery(objLog));
}
