/// <summary>
/// 更新一个接口程序
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateSingleInterfaceItemModel(InterfaceItemModel model)
{
try
{
string SQLString = @"SQL\DocumentInterface\UpdateSingleInterfaceItem.sql".ToFileContent(
model.InterfaceID, model.Title, model.Info, model.Path, model.Method,
model.InputParameterJSON, model.OutputParameterJSON, model.OrderIndex, model.Code);
MSSQLDataBaseServer SQLHelper = new MSSQLDataBaseServer("DocumentManageDB");
int Result = SQLHelper.ExecuteNonQuery(SQLString);
if (Result == 1)
{
return(true);
}
else
{
return(false);
}
}
catch
{
throw;
}
}
/// <summary>
/// 新增一个接口程序
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertSingleInterfaceItemModel(InterfaceItemModel model)
{
try
{
string Value = string.Format("{0},N'{1}',N'{2}','{3}','{4}',N'{5}',N'{6}',GETDATE(),GETDATE(),0,{7},'{8}'",
model.ProgramID, model.Title, model.Info, model.Path, model.Method,
model.InputParameterJSON, model.OutputParameterJSON, model.OrderIndex, model.Code);
string SQLString = @"SQL\DocumentInterface\InsertSingleInterfaceItem.sql".ToFileContent(Value);
MSSQLDataBaseServer SQLHelper = new MSSQLDataBaseServer("DocumentManageDB");
int Result = SQLHelper.ExecuteNonQuery(SQLString);
if (Result == 1)
{
return(true);
}
else
{
return(false);
}
}
catch
{
throw;
}
}
/// <summary>
/// 根据接口编号ID获取接口文档对象（不包含参数集合）
/// </summary>
/// <param name="parameterID"></param>
/// <returns></returns>
public InterfaceItemModel SelectDocumentInterfaceItem(int interfaceID)
{
try
{
string SQLString = @"SQL\DocumentInterface\SelectDocumentInterfaceItem.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> List = DataTableSet.Tables[0].ToList <InterfaceItemModel>();
if (List == null || List.Count != 1)
{
return(null);
}
else
{
Model = List[0];
}
return(Model);
}
catch
{
throw;
}
}
public bool UpdateInterfaceItem(InterfaceItemModel model)
{
bool Result = false;
try
{
Result = new DocumentInterfaceDAL().UpdateSingleInterfaceItemModel(model);
}
catch (Exception e)
{
logger.Error(e.ToString());
}
return(Result);
}
/// <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;
}
}
public bool DeleteInterfaceItem(int interfaceID)
{
bool Result = false;
try
{
InterfaceItemModel model = new InterfaceItemModel()
{
InterfaceID = interfaceID
};
Result = new DocumentInterfaceDAL().DeleteSingleInterfaceItemModel(model);
}
catch (Exception e)
{
logger.Error(e.ToString());
}
return(Result);
}
/// <summary>
/// 删除一个接口程序
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DeleteSingleInterfaceItemModel(InterfaceItemModel model)
{
try
{
string SQLString = @"SQL\DocumentInterface\DeleteSingleInterfaceItem.sql".ToFileContent(model.InterfaceID);
MSSQLDataBaseServer SQLHelper = new MSSQLDataBaseServer("DocumentManageDB");
int Result = SQLHelper.ExecuteNonQuery(SQLString);
if (Result == 1)
{
return(true);
}
else
{
return(false);
}
}
catch
{
throw;
}
}
public bool InsertDocumentInterfaceItem(InterfaceItemModel model)
{
return(new DocumentInterfaceBLL().InsertInterfaceItem(model));
}
public bool UpdateDocumentInterfaceItem(InterfaceItemModel model)
{
return(new DocumentInterfaceBLL().UpdateInterfaceItem(model));
}
