public static ApplicationSysInfo GetApplicationSysInfo(string name, string server)
{
ApplicationSysInfo info = null;
IDbConnection conn = null;
IDbCommand cmd = null;
IDbTransaction trans = null;
try
{
IApplicationSysInfo dp = DataProvider.DbApplicationSysInfoDP;
conn = DbConnOperation.CreateConnection();
cmd = conn.CreateCommand();
conn.Open();
trans = conn.BeginTransaction();
info = dp.GetApplicationSysInfo(cmd, name, server);
trans.Commit();
}
catch (Exception ex)
{
log.Error(string.Format("GetApplicationSysInfo()发生错误,异常信息如下:{0}", ex));
if (trans != null)
{
trans.Rollback();
}
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(info);
}
public object DeleteApplicationSysInfo(string id)
{
try
{
SystemSettingBase settings = SystemSettingBase.CreateInstance();
if (settings.SysMySqlDB != null)
{
ConnString.MySqldb = settings.SysMySqlDB.ConnectionString;
}
ApplicationSysInfo info = ApplicationSysInfoLogical.GetApplicationSysInfoById(new Guid(id));
if (null != info)
{
ApplicationSysInfoLogical.DeleteApplicationSysInfoById(new Guid(id));
return(string.Format("删除【{0}】应用系统成功！", info.name));
}
else
{
return(string.Format("系统不存在【{0}】应用系统信息！", info.name));
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <ApplicationSysInfo> GetApplicationSysInfoList(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 applicationinfo ", fields);
if (!string.IsNullOrEmpty(condition))
{
sb.AppendFormat("{0} ", condition);
}
cmd.CommandText = sb.ToString();
List <ApplicationSysInfo> list = new List <ApplicationSysInfo>();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
if (dt.Rows.Count > 0)
{
ApplicationSysInfo info = null;
foreach (DataRow dr in dt.Rows)
{
info = new ApplicationSysInfo();
info.AllParse(dr);
if (info != null)
{
list.Add(info);
}
}
}
return(list);
}
/// <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 GetApplicationSysInfo(string name, string server)
{
try
{
SystemSettingBase settings = SystemSettingBase.CreateInstance();
if (settings.SysMySqlDB != null)
{
ConnString.MySqldb = settings.SysMySqlDB.ConnectionString;
}
ApplicationSysInfo info = ApplicationSysInfoLogical.GetApplicationSysInfo(name, server);
return(new JsonResult(info));
}
catch (Exception ex)
{
throw ex;
}
}
public object GetApplicationSysInfoById(string id)
{
try
{
SystemSettingBase settings = SystemSettingBase.CreateInstance();
if (settings.SysMySqlDB != null)
{
ConnString.MySqldb = settings.SysMySqlDB.ConnectionString;
}
ApplicationSysInfo info = ApplicationSysInfoLogical.GetApplicationSysInfoById(new Guid(id));
return(new JsonResult(info));
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ApplicationSysInfo GetApplicationSysInfo(IDbCommand icmd, string name, string server)
{
icmd.Parameters.Clear();
MySqlCommand cmd = icmd as MySqlCommand;
cmd.CommandType = CommandType.Text;
string sql = @"select Id,name,server,userdep,chargeman,phone,description,createtime,level from applicationinfo where name = '{0}' and server = '{1}'";
cmd.CommandText = string.Format(sql, name, server);
DataTable dt = new DataTable();
ApplicationSysInfo info = null;
dt.Load(cmd.ExecuteReader());
if (dt.Rows.Count > 0)
{
info = new ApplicationSysInfo();
info.AllParse(dt.Rows[0]);
}
return(info);
}
public object UpdateInterfaceConfigInfo(string id, string interfaceName, string user, string pwd, string charger, string phone, int timeout, string docPath, string desc, string urlAddress, string exeptionlevel, string affectProduction, string type, string appid, string destapp)
{
try
{
ApplicationSysInfo appinfo = ApplicationSysInfoLogical.GetApplicationSysInfoById(new Guid(appid));
if (null != InterfaceConfigInfoOperation.GetInterfaceConfigInfo(interfaceName, appinfo.name, appinfo.server))
{
InterfaceConfigInitBizProcess.UpdateInterfaceConfigInfo(id, interfaceName, user, pwd, charger, phone, timeout, docPath, desc, urlAddress, exeptionlevel, affectProduction, type, appid, destapp);
return(string.Format("更新【{0}】配置信息成功！", interfaceName));
}
else
{
return(string.Format("不存在【{0}】配置信息！", interfaceName));
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public bool AddOrUpdateApplicationSysInfo(IDbCommand icmd, ApplicationSysInfo info, ModifierType mode)
{
icmd.Parameters.Clear();
MySqlCommand cmd = icmd as MySqlCommand;
cmd.CommandType = CommandType.Text;
if (mode == ModifierType.Add)
{
string sql = @"insert into applicationinfo(Id,name,server,userdep,chargeman,phone,description,createtime,level)
values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')";
cmd.CommandText = string.Format(sql, info.Id, info.name, info.server, info.userdep, info.chargeman, info.phone, info.description, info.createtime, info.level);
}
else if (mode == ModifierType.Update)
{
string sql = @"update applicationinfo set name = '{0}',server = '{1}',userdep = '{2}',chargeman = '{3}',phone = '{4}',description = '{5}',createtime = '{6}',level = '{8}'
where Id = '{7}'";
cmd.CommandText = string.Format(sql, info.name, info.server, info.userdep, info.chargeman, info.phone, info.description, info.createtime, info.Id, info.level);
}
cmd.ExecuteNonQuery();
return(true);
}
public static void UpdateApplicationSysInfo(Guid id, string name, string server, string userdep, string chargeman, string phone, string description)
{
try
{
ApplicationSysInfo info = new ApplicationSysInfo();
if (null != ApplicationSysInfoLogical.GetApplicationSysInfo(name, server))
{
info.Id = id;
info.name = name;
info.server = server;
info.userdep = userdep;
info.chargeman = chargeman;
info.phone = phone;
info.description = description;
info.createtime = DateTime.Now;
ApplicationSysInfoLogical.AddOrUpdateApplicationSysInfo(info, ModifierType.Update);
}
}
catch (Exception ex)
{
log.Error(string.Format("UpdateApplicationSysInfo()发生错误,错误信息如下:{0}", ex));
}
}
public static bool AddOrUpdateApplicationSysInfo(ApplicationSysInfo info, ModifierType mode)
{
bool ret = false;
IDbConnection conn = null;
IDbCommand cmd = null;
IDbTransaction trans = null;
try
{
IApplicationSysInfo dp = DataProvider.DbApplicationSysInfoDP;
conn = DbConnOperation.CreateConnection();
cmd = conn.CreateCommand();
conn.Open();
trans = conn.BeginTransaction();
cmd.Transaction = trans;
ret = dp.AddOrUpdateApplicationSysInfo(cmd, info, mode);
trans.Commit();
}
catch (Exception ex)
{
log.Error(string.Format("AddOrUpdateApplicationSysInfo()发生错误,异常信息如下:{0}", ex));
if (trans != null)
{
trans.Rollback();
}
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(ret);
}
public object UpdateApplicationSysInfo(string id, string name, string server, string userdep, string chargeman, string phone, string description, string level)
{
try
{
SystemSettingBase settings = SystemSettingBase.CreateInstance();
if (null != settings.SysMySqlDB)
{
ConnString.MySqldb = settings.SysMySqlDB.ConnectionString;
}
if (null != ApplicationSysInfoLogical.GetApplicationSysInfoById(new Guid(id)))
{
ApplicationSysInfo info = new ApplicationSysInfo()
{
Id = new Guid(id),
name = name,
server = server,
userdep = userdep,
chargeman = chargeman,
phone = phone,
description = description,
level = Int32.Parse(level),
createtime = DateTime.Now
};
ApplicationSysInfoLogical.AddOrUpdateApplicationSysInfo(info, ModifierType.Update);
return(string.Format("更新【{0},{1}】应用系统信息成功！", name, server));
}
else
{
return(string.Format("不存在【{0},{1}】该应用系统信息！", name, server));
}
}
catch (Exception ex)
{
return(string.Format("更新【{0,{1}}】应用系统信息失败！异常信息如下:{2}", name, server, ex.Message));
}
}
