/// <summary> /// 更新一个接口程序 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateSingleInterfaceProgramModel(InterfaceProgramModel model) { try { string SQLString = @"SQL\DocumentInterface\UpdateSingleInterfaceProgram.sql".ToFileContent( model.ProgramID, model.ProgramName, model.OrderIndex, model.SvnUrl); 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 InsertSingleInterfaceProgramModel(InterfaceProgramModel model) { try { string Value = string.Format("'{0}',0,{2},N'{1}',GETDATE()", model.SvnUrl, model.ProgramName, model.OrderIndex); string SQLString = @"SQL\DocumentInterface\InsertSingleInterfaceProgram.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 InterfaceProgramModel SelectDocumentInterfaceProgram(int programID) { try { string SQLString = @"SQL\DocumentInterface\SelectDocumentInterfaceProgram.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> List = DataTableSet.Tables[0].ToList <InterfaceProgramModel>(); if (List == null || List.Count != 1) { return(null); } else { Model = List[0]; } return(Model); } catch { throw; } }
/// <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; } }
public bool UpdateInterfaceProgram(InterfaceProgramModel model) { bool Result = false; try { Result = new DocumentInterfaceDAL().UpdateSingleInterfaceProgramModel(model); } catch (Exception e) { logger.Error(e.ToString()); } return(Result); }
public bool DeleteInterfaceProgram(int programID) { bool Result = false; try { InterfaceProgramModel model = new InterfaceProgramModel() { ProgramID = programID }; Result = new DocumentInterfaceDAL().DeleteSingleInterfaceProgramModel(model); } catch (Exception e) { logger.Error(e.ToString()); } return(Result); }
public bool UpdateDocumentInterfaceProgram(InterfaceProgramModel model) { return(new DocumentInterfaceBLL().UpdateInterfaceProgram(model)); }
public bool InsertDocumentInterfaceProgram(InterfaceProgramModel model) { return(new DocumentInterfaceBLL().InsertInterfaceProgram(model)); }