public WorkflowStructure GetWorkflowStructure(string identification)
{
string sql = " SELECT * FROM T_STRUCTURE WHERE IDENTIFICATION=@IDENTIFICATION ";
return(DapperFactory.CreateWorkflowConnection().Query <WorkflowStructure>(sql, new { IDENTIFICATION = identification })
.FirstOrDefault <WorkflowStructure>());
}
public static MailConfiguration Configure()
{
string sql = "SELECT * FROM T_MAIL";
return(DapperFactory.CreateWorkflowConnection()
.Query <MailConfiguration>(sql).FirstOrDefault());
}
public static WorkflowConfig GetInstance(string id)
{
string query = " SELECT * FROM T_CONFIG WHERE ID=@ID ";
return(DapperFactory
.CreateWorkflowConnection()
.Query <WorkflowConfig>(query, new { ID = id })
.FirstOrDefault());
}
public static DataTable GetSettings()
{
string query = " SELECT * FROM T_CONFIG ";
DataTable configData = new DataTable(Guid.NewGuid().ToString());
using (IDataReader dr = DapperFactory.CreateWorkflowConnection().ExecuteReader(query))
{
configData.Load(dr);
}
return(configData);
}
/// <summary>
/// 获取节点的审批记录
/// </summary>
/// <param name="instanceID">流程实例ID</param>
/// <returns></returns>
public static DataTable GetRecord(string instanceID)
{
string sql = ResourceManage.GetString(ResourceManage.SQL_ACTOR_RECORD);
using (IDataReader dr = DapperFactory.CreateWorkflowConnection().ExecuteReader(sql,
new { InstanceID = instanceID }))
{
DataTable dt = new DataTable(Guid.NewGuid().ToString());
dt.Load(dr);
return(dt);
}
}
public static List <WorkflowConfig> GetSettings()
{
string query = " SELECT * FROM T_CONFIG ";
return(DapperFactory.CreateWorkflowConnection().Query <WorkflowConfig>(query).ToList());
}
