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