/// <summary> /// 根据接口程序ID获取接口程序(包含接口文档) /// </summary> /// <param name="ProgramID"></param> /// <returns></returns> public InterfaceProgramModel SearchDocumentInterfaceProgram(int programID) { try { string SQLString = @"SQL\DocumentInterface\SearchDocumentInterfaceProgram.sql".ToFileContent(programID); MSSQLDataBaseServer SQLHelper = new MSSQLDataBaseServer("DocumentManageDB"); DataSet DataTableSet = SQLHelper.ExecuteDataset(SQLString); if (DataTableSet == null || DataTableSet.Tables.Count < 1) { return(null); } InterfaceProgramModel Model = new InterfaceProgramModel(); List <InterfaceProgramModel> InterfaceProgramList = DataTableSet.Tables[0].ToList <InterfaceProgramModel>(); List <InterfaceItemModel> InterfaceItemList = DataTableSet.Tables[1].ToList <InterfaceItemModel>(); List <InterfaceParameterModel> InterfaceParameterList = DataTableSet.Tables[2].ToList <InterfaceParameterModel>(); if (InterfaceParameterList == null) { InterfaceParameterList = new List <InterfaceParameterModel>(); } if (InterfaceProgramList == null || InterfaceProgramList.Count != 1) { return(null); } else { Model = InterfaceProgramList[0]; } Model.InterfaceItemList = new List <InterfaceItemModel>(); if (InterfaceItemList != null && InterfaceItemList.Count > 0) { InterfaceItemList.ForEach(o => { Model.InterfaceItemList.Add(o); o.InputParameter = new List <InterfaceParameterModel>(); o.OutputParameter = new List <InterfaceParameterModel>(); o.InputParameter.AddRange(InterfaceParameterList.FindAll(x => x.ParameterType == 1 && x.InterfaceID == o.InterfaceID)); o.OutputParameter.AddRange(InterfaceParameterList.FindAll(y => y.ParameterType == 2 && y.InterfaceID == o.InterfaceID)); }); } return(Model); } catch { throw; } }
/// <summary> /// 根据接口编号ID获取接口文档对象(包含参数集合) /// </summary> /// <param name="interfaceID"></param> /// <returns></returns> public InterfaceItemModel SearchDocumentInterfaceItem(int interfaceID) { try { string SQLString = @"SQL\DocumentInterface\SearchDocumentInterfaceItem.sql".ToFileContent(interfaceID); MSSQLDataBaseServer SQLHelper = new MSSQLDataBaseServer("DocumentManageDB"); DataSet DataTableSet = SQLHelper.ExecuteDataset(SQLString); if (DataTableSet == null || DataTableSet.Tables.Count < 1) { return(null); } InterfaceItemModel Model = new InterfaceItemModel(); List <InterfaceItemModel> InterfaceItemList = DataTableSet.Tables[0].ToList <InterfaceItemModel>(); List <InterfaceParameterModel> InterfaceParameterList = DataTableSet.Tables[1].ToList <InterfaceParameterModel>(); if (InterfaceParameterList == null) { InterfaceParameterList = new List <InterfaceParameterModel>(); } if (InterfaceItemList == null || InterfaceItemList.Count != 1) { return(null); } else { Model = InterfaceItemList[0]; } Model.InputParameter = InterfaceParameterList.FindAll(p => p.ParameterType == 1); Model.OutputParameter = InterfaceParameterList.FindAll(p => p.ParameterType == 2); return(Model); } catch { throw; } }