public List <ApplicationInterfaceRelation> GetApplicationInterfaceRealtionList(IDbCommand icmd, string fields, string condition)
{
icmd.Parameters.Clear();
MySqlCommand cmd = icmd as MySqlCommand;
cmd.CommandType = CommandType.Text;
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select {0} from applicationinterfacerelation ", fields);
if (!string.IsNullOrEmpty(condition))
{
sb.AppendFormat("{0} ", condition);
}
cmd.CommandText = sb.ToString();
List <ApplicationInterfaceRelation> list = new List <ApplicationInterfaceRelation>();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
if (dt.Rows.Count > 0)
{
ApplicationInterfaceRelation info = null;
foreach (DataRow dr in dt.Rows)
{
info = new ApplicationInterfaceRelation();
info.AllParse(dr);
if (null != info)
{
list.Add(info);
}
}
}
return(list);
}
public object UpdateApplicationInterfaceRelation(string id, string appid, string appname, string interfaceid, string interfacename, string destinappid, string destinappname, string fatherid, string fathername)
{
try
{
SystemSettingBase settings = SystemSettingBase.CreateInstance();
if (settings.SysMySqlDB != null)
{
ConnString.MySqldb = settings.SysMySqlDB.ConnectionString;
}
if (null != ApplicationInterfaceRelationOperation.GetApplicationInterfaceRelationById(new Guid(id)))
{
ApplicationInterfaceRelation info = new ApplicationInterfaceRelation()
{
Id = new Guid(id),
appId = new Guid(appid),
appname = appname,
interfaceId = new Guid(interfaceid),
interfacename = interfacename,
destinappid = new Guid(destinappid),
destinappname = destinappname,
updatetime = DateTime.Now
};
ApplicationInterfaceRelationOperation.AddOrUpdateApplicationInterfaceRelation(info, ModifierType.Update);
return(string.Format("修改【{0},{1},{2}】关联关系成功！", appname, interfacename, destinappname));
}
else
{
return(string.Format("系统不存在【{0},{1},{2}】该关联关系！", appname, interfacename, destinappname));
}
}
catch (Exception ex)
{
return(string.Format("修改【{0},{1},{2}】关联关系失败！异常信息如下:{3}", appname, interfacename, destinappname, ex.Message));
}
}
public object DeleteApplicationInterfaceRelation(string id)
{
try
{
SystemSettingBase settings = SystemSettingBase.CreateInstance();
if (null != settings.SysMySqlDB)
{
ConnString.MySqldb = settings.SysMySqlDB.ConnectionString;
}
ApplicationInterfaceRelation info = ApplicationInterfaceRelationOperation.GetApplicationInterfaceRelationById(new Guid(id));
if (null != info)
{
ApplicationInterfaceRelationOperation.DeleteApplicationInterfaceRelationById(new Guid(id));
return(string.Format("删除【{0},{1},{2}】关联关系成功！", info.appname, info.interfacename, info.destinappname));
}
else
{
return(string.Format("系统不存在【{0}】编号关联关系！", id));
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 接口初始化业务逻辑方法
/// </summary>
/// <param name="interfaceName">接口名</param>
/// <param name="applicationName">应用系统名</param>
/// <param name="server">服务器地址</param>
/// <param name="user">用户名</param>
/// <param name="userPwd">密码</param>
/// <param name="charger">负责人</param>
/// <param name="phone">负责人联系号码</param>
/// <param name="timeout">超时时间</param>
/// <param name="path">帮助文档存放路径</param>
/// <param name="descript">描述</param>
/// <param name="appid">应用编号</param>
public static void SaveInterfaceInitial(string interfaceName, string user, string userPwd, string charger, string phone, int timeout, string path, string descript, string urlAddress, string exeptionlevel, string affectProduction, string type, string appid, string destAppid)
{
//生成接口编号id
Guid id = Guid.NewGuid();
ApplicationSysInfo appinfo = ApplicationSysInfoLogical.GetApplicationSysInfoById(new Guid(appid));
ApplicationSysInfo destapp = ApplicationSysInfoLogical.GetApplicationSysInfoById(new Guid(destAppid));
//判断接口配置信息是否存在，如果不存在则新增
if (InterfaceConfigInfoOperation.GetInterfaceConfigInfo(interfaceName, appinfo.name, appinfo.server) == null)
{
//接口配置信息
InterfaceConfigInfo config = new InterfaceConfigInfo();
config.Id = id;
config.InterfaceName = interfaceName;
config.ApplicationName = appinfo.name;
config.ServerAddress = appinfo.server;
config.ServerUser = user;
config.UserPwd = userPwd;
config.PersonOfChargeName = charger;
config.PersonOfChargePhone = phone;
config.ConnectedTimeout = timeout;
config.DocumentHelpPath = path;
config.UrlAddress = urlAddress;
config.Description = descript;
config.Exeptionlevel = Int32.Parse(exeptionlevel);
config.AffectProduction = Int32.Parse(affectProduction);
config.Type = Int32.Parse(type);
config.appid = new Guid(appid);
config.CreateTime = DateTime.Now;
//应用系统接口关系
ApplicationInterfaceRelation relation = new ApplicationInterfaceRelation();
relation.Id = Guid.NewGuid();
relation.appId = appinfo.Id;
relation.appname = appinfo.name;
relation.interfaceId = id;
relation.interfacename = interfaceName;
relation.destinappid = destapp.Id;
relation.destinappname = destapp.name;
relation.updatetime = DateTime.Now;
//接口实时状态信息
InterfaceRealtimeInfo realtime = new InterfaceRealtimeInfo();
realtime.Id = id;
realtime.InterfaceName = interfaceName;
realtime.ApplicationName = appinfo.name;
realtime.ServerAddress = appinfo.server;
realtime.appid = new Guid(appid);
realtime.StateCode = 0;
realtime.UpdateTime = DateTime.Now;
InterfaceConfigInfoOperation.AddOrUpdateInterfaceConfigInfo(config, ModifierType.Add);
InterfaceRealtimeInfoOperation.AddOrUpdateInterceRealtimeInfo(realtime, ModifierType.Add);
ApplicationInterfaceRelationOperation.AddOrUpdateApplicationInterfaceRelation(relation, ModifierType.Add);
}
}
public object GetApplicationInterfaceRelationById(string id)
{
try
{
SystemSettingBase settings = SystemSettingBase.CreateInstance();
if (null != settings.SysMySqlDB)
{
ConnString.MySqldb = settings.SysMySqlDB.ConnectionString;
}
ApplicationInterfaceRelation info = ApplicationInterfaceRelationOperation.GetApplicationInterfaceRelationById(new Guid(id));
return(new JsonResult(info));
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ApplicationInterfaceRelation GetApplicationInterfaceRelation(IDbCommand icmd, Guid appid, Guid interfaceid, Guid destinappid)
{
icmd.Parameters.Clear();
MySqlCommand cmd = icmd as MySqlCommand;
cmd.CommandType = CommandType.Text;
string sql = @"select Id,appId,appname,interfaceId,interfacename,updatetime,destinappid,destinappname from applicationinterfacerelation where appId = '{0}' and interfaceId = '{1}' and destinappid = '{2}'";
cmd.CommandText = string.Format(sql, appid, interfaceid, destinappid);
ApplicationInterfaceRelation info = null;
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
if (dt.Rows.Count > 0)
{
info = new ApplicationInterfaceRelation();
info.AllParse(dt.Rows[0]);
}
return(info);
}
public bool AddOrUpdateApplicationInterfaceRelation(IDbCommand icmd, ApplicationInterfaceRelation info, ModifierType mode)
{
icmd.Parameters.Clear();
MySqlCommand cmd = icmd as MySqlCommand;
cmd.CommandType = CommandType.Text;
if (mode == ModifierType.Add)
{
string sql = @"insert into applicationinterfacerelation(Id,appId,appname,interfaceId,interfacename,updatetime,destinappid,destinappname) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')";
cmd.CommandText = string.Format(sql, info.Id, info.appId, info.appname, info.interfaceId, info.interfacename, info.updatetime, info.destinappid, info.destinappname);
}
else if (mode == ModifierType.Update)
{
string sql = @"update applicationinterfacerelation set appId = '{0}',appname = '{1}',interfaceId = '{2}',interfacename = '{3}',updatetime = '{4}',destinappid = '{6}',destinappname = '{7}'
where Id = '{5}'";
cmd.CommandText = string.Format(sql, info.appId, info.appname, info.interfaceId, info.interfacename, info.updatetime, info.Id, info.destinappid, info.destinappname);
}
cmd.ExecuteNonQuery();
return(true);
}
public static ApplicationInterfaceRelation GetApplicationInterfaceRelation(Guid appid, Guid interfaceid, Guid destinappid)
{
ApplicationInterfaceRelation info = null;
IDbConnection conn = null;
IDbCommand cmd = null;
IDbTransaction trans = null;
try
{
IApplicationInterfaceRelation dp = DataProvider.DbApplicationInterfaceRelationDP;
conn = DbConnOperation.CreateConnection();
cmd = conn.CreateCommand();
conn.Open();
trans = conn.BeginTransaction();
cmd.Transaction = trans;
info = dp.GetApplicationInterfaceRelation(cmd, appid, interfaceid, destinappid);
trans.Commit();
}
catch (Exception ex)
{
log.Error(string.Format("GetApplicationInterfaceRelation()发生错误,错误信息如下:{0}", ex));
if (trans != null)
{
trans.Rollback();
}
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(info);
}
public static bool AddOrUpdateApplicationInterfaceRelation(ApplicationInterfaceRelation info, ModifierType mode)
{
bool ret = false;
IDbConnection conn = null;
IDbCommand cmd = null;
IDbTransaction trans = null;
try
{
IApplicationInterfaceRelation dp = DataProvider.DbApplicationInterfaceRelationDP;
conn = DbConnOperation.CreateConnection();
cmd = conn.CreateCommand();
conn.Open();
trans = conn.BeginTransaction();
cmd.Transaction = trans;
ret = dp.AddOrUpdateApplicationInterfaceRelation(cmd, info, mode);
trans.Commit();
}
catch (Exception ex)
{
log.Error(string.Format("AddOrUpdateApplicationInterfaceRelation()发生错误,错误信息如下:{0}", ex));
if (trans != null)
{
trans.Rollback();
}
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(ret);
}
public object AddApplicationInterfaceRelation(string appid, string appname, string interfaceid, string interfacename, string destinappid, string destinappname, string fatherid, string fathername)
{
try
{
SystemSettingBase settings = SystemSettingBase.CreateInstance();
if (settings.SysMySqlDB != null)
{
ConnString.MySqldb = settings.SysMySqlDB.ConnectionString;
}
if (null == ApplicationInterfaceRelationOperation.GetApplicationInterfaceRelation(new Guid(appid), new Guid(interfaceid), new Guid(destinappid)))
{
ApplicationInterfaceRelation info = new ApplicationInterfaceRelation()
{
Id = Guid.NewGuid(),
appId = new Guid(appid),
appname = appname,
interfaceId = new Guid(interfaceid),
interfacename = interfacename,
destinappid = new Guid(destinappid),
destinappname = destinappname,
updatetime = DateTime.Now
};
ApplicationInterfaceRelationOperation.AddOrUpdateApplicationInterfaceRelation(info, ModifierType.Add);
if (null == ApplicationRelationOperation.GetApplicationRelationById(new Guid(appid)))
{
ApplicationRelation relation = new ApplicationRelation()
{
appId = new Guid(appid),
appName = appname,
fatherId = new Guid(fatherid),
fatherName = fathername,
childId = new Guid(destinappid),
childName = destinappname
};
ApplicationRelationOperation.AddOrUpdateApplicationRelation(relation, ModifierType.Add);
}
//更新接口配置表接口配置中接口所属系统信息
InterfaceConfigInfo interfaceConfig = InterfaceConfigInfoOperation.GetInterfaceConfigInfoById(new Guid(interfaceid));
if (null != interfaceConfig)
{
interfaceConfig.ApplicationName = appname;
interfaceConfig.CreateTime = DateTime.Now;
InterfaceConfigInfoOperation.AddOrUpdateInterfaceConfigInfo(interfaceConfig, ModifierType.Update);
}
//更新接口实时信息表中接口所属系统信息
InterfaceRealtimeInfo realtimeInfo = InterfaceRealtimeInfoOperation.GetInterfaceRealtimeInfo(new Guid(interfaceid));
if (null != realtimeInfo)
{
realtimeInfo.ApplicationName = appname;
realtimeInfo.UpdateTime = DateTime.Now;
InterfaceRealtimeInfoOperation.AddOrUpdateInterceRealtimeInfo(realtimeInfo, ModifierType.Update);
}
return(string.Format("添加【{0},{1},{2}】关联关系成功！", appname, interfacename, destinappname));
}
else
{
return(string.Format("系统已存在【{0},{1},{2}】该关联关系！", appname, interfacename, destinappname));
}
}
catch (Exception ex)
{
return(string.Format("添加【{0},{1},{2}】关联关系失败！异常信息如下:{3}", appname, interfacename, destinappname, ex.Message));
}
}
