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()); }