public JobCollection UPDLOCKLoadJobs(int batchCount, IConnectiveSqlClause whereClause)
{
JobCollection result = new JobCollection();
if (whereClause.IsEmpty == false)
{
using (DbContext context = DbContext.GetContext(this.GetConnectionName()))
{
string top = batchCount >= 0 ? "TOP " + batchCount : string.Empty;
Database db = DatabaseFactory.Create(context);
using (IDataReader dr = db.ExecuteReader(CommandType.Text,
string.Format(UPDLOCK_LOAD_JOBS, top,
whereClause.AppendTenantCodeSqlClause(typeof(JobBase)).ToSqlString(TSqlBuilder.Instance))))
{
ORMapping.DataReaderToCollection(result, dr);
}
}
AfterLoad(result);
}
return(result);
}
public StartWorkflowJob LoadSingleData(IConnectiveSqlClause whereClause)
{
StartWorkflowJob result = null;
if (whereClause.IsEmpty == false)
{
using (DbContext context = DbHelper.GetDBContext(GetConnectionName()))
{
using (IDataReader dr = DbHelper.RunSqlReturnDR(string.Format(SingleData_StartWorkflowJob,
whereClause.AppendTenantCodeSqlClause(typeof(StartWorkflowJob)).ToSqlString(TSqlBuilder.Instance)), GetConnectionName()))
{
while (dr.Read())
{
result = new StartWorkflowJob();
ORMapping.DataReaderToObject(dr, result);
break;
}
}
if (result != null)
{
result.InitJobBaseData(JobBaseAdapter.Instance.LoadSingleDataByJobID(whereClause));
}
}
}
return(result);
}
public InvalidAssigneeCollection Load(IConnectiveSqlClause builder)
{
InvalidAssigneeCollection result = new InvalidAssigneeCollection();
string sql = SelectSQL;
if (builder.IsEmpty == false)
{
sql = string.Format("{0} WHERE {1}",
SelectSQL,
builder.AppendTenantCodeSqlClause(typeof(InvalidAssignee)).ToSqlString(TSqlBuilder.Instance));
}
DataTable dt = DbHelper.RunSqlReturnDS(sql, this.GetConnectionName()).Tables[0];
ORMapping.DataViewToCollection(result, dt.DefaultView);
return(result);
}
public JobBase LoadSingleDataByJobID(IConnectiveSqlClause whereClause)
{
JobBase result = null;
if (whereClause.IsEmpty == false)
{
using (DbContext context = DbHelper.GetDBContext(GetConnectionName()))
{
using (IDataReader dr = DbHelper.RunSqlReturnDR(string.Format(SINGLEATA_JOB,
whereClause.AppendTenantCodeSqlClause(typeof(JobBase)).ToSqlString(TSqlBuilder.Instance)), GetConnectionName()))
{
while (dr.Read())
{
result = new JobBase();
ORMapping.DataReaderToObject(dr, result);
break;
}
}
}
}
return(result);
}