/// <summary> /// 获取条件查询的总记录数 /// </summary> /// <param name="qs"></param> /// <returns></returns> public static int GetRunLogPageCount(RunLogQueryStatement qs, ref string errorInfo) { if (!Access.Connection(ref errorInfo)) { return(-1); } bool b_Conditional = false; string sql = "select count(*) from RunLog where"; if (qs.Operation != null) { sql += " Operation='" + qs.Operation + "'and"; b_Conditional = true; } if (qs.IsAbnormal != null) { sql += " IsAbnormal='" + qs.IsAbnormal + "'and"; b_Conditional = true; } if (qs.StartDate != null) { sql += " Date>='" + qs.StartDate + "'and"; b_Conditional = true; } if (qs.StartTime != null) { sql += " Time>='" + qs.StartTime + "'and"; b_Conditional = true; } if (qs.EndDate != null) { sql += " Date<='" + qs.EndDate + "'and"; b_Conditional = true; } if (qs.EndTime != null) { sql += " Time<='" + qs.EndTime + "'and"; b_Conditional = true; } if (!b_Conditional) { sql = sql.Substring(0, sql.Length - 5); } else { sql = sql.Substring(0, sql.Length - 3); } OleDbCommand oleDbCommand = new OleDbCommand(sql, Access.oleDb); int i = (int)oleDbCommand.ExecuteScalar(); Access.CloseConn(); return(i); }
/// <summary> /// 查询录像分页信息 /// </summary> public static DataSet SelectRunLogInfo(string page, string pageSize, RunLogQueryStatement qs, ref string errorInfo) { if (!Access.Connection(ref errorInfo)) { return(null); } int i_page = int.Parse(page); int i_pageSize = int.Parse(pageSize); int exclude = (i_pageSize * (i_page - 1)) + 1; bool b_Conditional = false; string sql = "select top " + pageSize + " * from RunLog " + "where id>= (select max(id) from(select top " + exclude + " id from RunLog order by id)a where"; if (qs.Operation != null) { sql += " Operation='" + qs.Operation + "'and"; b_Conditional = true; } if (qs.IsAbnormal != null) { sql += " IsAbnormal='" + qs.IsAbnormal + "'and"; b_Conditional = true; } if (qs.StartDate != null) { sql += " Date>='" + qs.StartDate + "'and"; b_Conditional = true; } if (qs.StartTime != null) { sql += " Time>='" + qs.StartTime + "'and"; b_Conditional = true; } if (qs.EndDate != null) { sql += " Date<='" + qs.EndDate + "'and"; b_Conditional = true; } if (qs.EndTime != null) { sql += " Time<='" + qs.EndTime + "'and"; b_Conditional = true; } if (!b_Conditional) { sql = sql.Substring(0, sql.Length - 5); } else { sql = sql.Substring(0, sql.Length - 3); } sql += ")order by id"; OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter(sql, Access.oleDb); DataSet ds = new DataSet(); oleDbDataAdapter.Fill(ds, "RunLog"); ds.Tables["RunLog"].Columns["ID"].ColumnName = "序号"; ds.Tables["RunLog"].Columns["LogType"].ColumnName = "运行类型"; ds.Tables["RunLog"].Columns["IsAbnormal"].ColumnName = "是否异常"; ds.Tables["RunLog"].Columns["Date"].ColumnName = "日期"; ds.Tables["RunLog"].Columns["Time"].ColumnName = "时间"; ds.Tables["RunLog"].Columns["Operation"].ColumnName = "信息"; ds.Tables["RunLog"].Columns["Description"].ColumnName = "描述"; ds.Tables["RunLog"].Columns["Mark"].ColumnName = "备注"; Access.CloseConn(); return(ds); }