/// <summary>
/// 获得子表单隶属的主表单
/// </summary>
/// <returns></returns>
public static DataTable GetMainCtrlsOfChild(string userControlId)
{
try
{
string tmpStr = "select * from UserControlsView where UserControlId=@UserControlId order by mucCaption";
SqlDataItem sqlItem = new SqlDataItem();
sqlItem.CommandText = tmpStr;
sqlItem.AppendParameter("@userControlId", userControlId);
ClientDBAgent agent = new ClientDBAgent();
return agent.ExecuteDataTable(sqlItem);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获得工作流模板信息
/// </summary>
/// <param name="workflowId">流程模板名称</param>
/// <returns></returns>
public static DataTable GetWorkflowsByCaption(string workflowCaption)
{
string tmpStr = "select * from workflow where FlowCaption like @workflowCaption";
try
{
SqlDataItem sqlItem = new SqlDataItem();
sqlItem.CommandText = tmpStr;
sqlItem.AppendParameter("@workflowCaption", "%" + workflowCaption + "%");
ClientDBAgent agent = new ClientDBAgent();
return agent.ExecuteDataTable(sqlItem);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获得所有子表单
/// </summary>
/// <returns></returns>
public static DataTable GetAllChildUserControls()
{
try
{
string tmpStr = "select * from UserControls order by ucCaption";
SqlDataItem sqlItem = new SqlDataItem();
sqlItem.CommandText = tmpStr;
ClientDBAgent agent = new ClientDBAgent();
return agent.ExecuteDataTable(sqlItem);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetWorkFlowAllControlsTable(string workflowId)
{
try
{
string tmpStr = "select * from worktaskControls where WorkFlowId=@workflowId";
SqlDataItem sqlItem = new SqlDataItem();
sqlItem.CommandText = tmpStr;
sqlItem.AppendParameter("@workflowId", workflowId);
ClientDBAgent agent = new ClientDBAgent();
return agent.ExecuteDataTable(sqlItem);
}
catch (Exception ex)
{
throw ex;
}
}