/// <summary> /// 根据Id编号获取接口配置信息 /// </summary> /// <param name="id">编号</param> /// <returns></returns> public static InterfaceConfigInfo GetInterfaceConfigInfoById(Guid id) { IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; InterfaceConfigInfo entity = null; try { IInterfaceConfigInfo dp = DataProvider.DbInterfaceConfigDP; conn = DbConnOperation.CreateConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; entity = dp.GetInterfaceConfigInfoById(cmd, id); trans.Commit(); } catch (Exception ex) { if (null != trans) { trans.Rollback(); } } finally { if (null != conn) { conn.Close(); } } return(entity); }
/// <summary> /// 根据接口名、应用系统编号获取配置信息 /// </summary> /// <param name="interfaceName"></param> /// <param name="appid"></param> /// <returns></returns> public static InterfaceConfigInfo GetInterfaceConfigInfo(string interfaceName, Guid appid) { IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; InterfaceConfigInfo info = null; try { IInterfaceConfigInfo dp = DataProvider.DbInterfaceConfigDP; conn = DbConnOperation.CreateConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; info = dp.GetInterfaceConfigInfo(cmd, interfaceName, appid); trans.Commit(); } catch (Exception ex) { if (null != trans) { trans.Rollback(); } } finally { if (null != conn) { conn.Close(); } } return(info); }
/// <summary> /// 自定义接口配置信息列表查询 /// </summary> /// <param name="fields"></param> /// <param name="whereCondition"></param> /// <param name="orderby"></param> /// <param name="limit"></param> /// <returns></returns> public static List <InterfaceConfigInfo> GetInterfaceConfigInfoByCondition(string fields, string whereCondition, string orderby, string limit) { IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; List <InterfaceConfigInfo> list = new List <InterfaceConfigInfo>(); try { IInterfaceConfigInfo dp = DataProvider.DbInterfaceConfigDP; conn = DbConnOperation.CreateConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; list = dp.GetInterfaceConfigInfoByCondition(cmd, fields, whereCondition, orderby, limit); trans.Commit(); } catch (Exception ex) { if (null != trans) { trans.Rollback(); } } finally { if (null != conn) { conn.Close(); } } return(list); }
/// <summary> /// 接口配置信息数据新增或修改 /// </summary> /// <param name="entity"></param> /// <param name="mode"></param> public static void AddOrUpdateInterfaceConfigInfo(InterfaceConfigInfo entity, ModifierType mode) { IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IInterfaceConfigInfo dp = DataProvider.DbInterfaceConfigDP; conn = DbConnOperation.CreateConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; dp.AddOrUpdateInterfaceConfigInfo(cmd, entity, mode); trans.Commit(); } catch (Exception ex) { if (null != trans) { trans.Rollback(); } } finally { if (null != conn) { conn.Close(); } } }