/// <summary>
/// 根据工作流ID查询测试表单信息
/// </summary>
/// <param name="workflowId">工作流ID</param>
/// <param name="connectionId">连接ID</param>
/// <returns>测试表单信息</returns>
public TestFormInfo SelectByWorkflowId(int workflowId, string connectionId = null)
{
TestFormInfo result = null;
DbConnectionManager.BrainpowerExecute(connectionId, this, (connId, dbConn) =>
{
string sql = $"{SelectSql()} WHERE {GetFieldByProp("WorkflowId")}=@WorkflowId";
result = dbConn.QueryFirstOrDefault <TestFormInfo>(sql, new { WorkflowId = workflowId }, GetDbTransaction(connId));
}, AccessMode.SLAVE);
return(result);
}
/// <summary>
/// 根据流程ID更新流程状态
/// </summary>
/// <param name="testForm">测试表单</param>
/// <param name="connectionId">连接ID</param>
/// <returns>影响行数</returns>
public int UpdateFlowStatusByWorkflowId(TestFormInfo testForm, string connectionId = null)
{
int result = 0;
DbConnectionManager.BrainpowerExecute(connectionId, this, (connId, dbConn) =>
{
string sql = $"UPDATE `{Table}` SET {GetFieldByProp("FlowStatus")}=@FlowStatus{GetModifyInfoSql(testForm)} WHERE {GetFieldByProp("WorkflowId")}=@WorkflowId";
result = dbConn.Execute(sql, testForm, GetDbTransaction(connId));
});
return(result);
}
