public DataTable QueryData_PerPage(ParamtersForDBPageEntity info, out int totalcnt)
{
if (info.UserPagination)
{
int records = 0;
DataTable rt = ExecuteFor(c =>
{
OracleDynamicParameters p = new OracleDynamicParameters();
p.Add("TableName", OracleDbType.Varchar2, ParameterDirection.Input, info.TableName);
p.Add("Fields", OracleDbType.Varchar2, ParameterDirection.Input, info.Fields);
p.Add("OrderField", OracleDbType.Varchar2, ParameterDirection.Input, info.OrderField);
p.Add("sqlWhere", OracleDbType.Varchar2, ParameterDirection.Input, info.SqlWhere);
p.Add("pageSize", OracleDbType.Int32, ParameterDirection.Input, info.PageSize);
p.Add("pageIndex", OracleDbType.Int32, ParameterDirection.Input, info.PageIndex);
p.Add("Records", OracleDbType.Int32, ParameterDirection.Output);
p.Add("o_resultSet", OracleDbType.RefCursor, ParameterDirection.Output);
DataTable dt = c.QueryDT("sp_page", param: p, commandType: CommandType.StoredProcedure);
records = p.Get <int>("Records");
return(dt);
});
totalcnt = records;
return(rt);
}
else
{
string sql = string.Format("select {0} from {1} where {2} order by {3}", info.Fields, info.TableName, info.SqlWhere, info.OrderField);
DataTable dt = ExecuteFor(c =>
{
return(c.QueryDT(sql));
});
totalcnt = dt.Rows.Count;
return(dt);
}
}
private void button3_Click(object sender, EventArgs e)
{
string taskID = txtTaskID.Text.Trim();
if (string.IsNullOrEmpty(taskID))
{
MessageBox.Show("请在右边输入TaskID");
return;
}
Core.Service.TaskService taskBll = new Core.Service.TaskService();
//查找一条数据
//TaskEntity taskEntity = taskBll.Find(taskID);
//if (taskEntity == null)
//{
// MessageBox.Show(string.Format("TaskID[{0}]数据库不存在",taskID));
// return;
//}
//更新
//taskEntity.ModifyTime = DateTime.Now;
//taskEntity.Remark = DateTime.Now.ToString();
//bool isSuccess2 = taskBll.Update(taskEntity);
//if (isSuccess2)
//{
//}
//获取任务列表
//TaskEntity taskEntity2 = new TaskEntity();
ParamtersForDBPageEntity <TaskEntity> pageTask = taskBll.GetTaskList(null, 1, 2);
ParamtersForDBPageEntity <TaskEntity> pageTask2 = taskBll.GetTaskList(null, 2, 2);
//List<TaskEntity> taskList = taskBll.GetAllTaskList();
//更新上次运行时间
//bool isResult1 = taskBll.UpdateRecentRunTime(taskID, DateTime.Parse("2018-12-04 02:25:25"));
//更新下次运行时间
//bool isResult3 = taskBll.UpdateNextFireTime(taskID, DateTime.Now.AddSeconds(1));
//更新任务状态
//bool isResult2 = taskBll.UpdateTaskStatus(taskID, TaskStatus.STOP);
}
