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