/// <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; } }