public static void RaiseOltAlarm(string conn, OMC omc, Task task)
{
string oltName = SQLUtil.GetOlt(conn, task.OltID);
if (oltName == null || oltName == "")
{
oltName = task.OltID;
}
StringBuilder sb = new StringBuilder();
sb.Append("insert into ftth_activealarm (CompanyNo,CITYNAME,SVRNAME,description,raisetime,Severity,ftthTaskID,type,neid) values(");
sb.Append("'" + omc.Manufacturer + "',");
sb.Append("'" + omc.City + "',");
sb.Append("'" + omc.OmcName + "',");
sb.Append("'" + omc.OmcName + " " + oltName + " 与OMC连接中断',");
sb.Append("'" + DateTime.Now.ToString() + "',");
sb.Append("1,");
sb.Append("'" + task.TaskID + "',");
sb.Append("'olt',");
sb.Append("'" + oltName + "')");
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sb.ToString());
}
public static void ClearOMCAlarm(string conn, OMC omc)
{
SqlParameter spOMCName = new SqlParameter("@omcName", omc.OmcName);
SQLUtil.ExecProc(conn, "spClearOMCAlarm", spOMCName);
}
public static string ParseErrorDescToString(ErrorDesc desc, Task task, string error, string conn)
{
string oltName = SQLUtil.GetOlt(conn, task.OltID);
if (oltName == null || oltName == "")
{
oltName = task.OltID;
}
switch (desc)
{
// BbAlreadyExist, //宽带业务已存在
//BbImsSvlanOrCvlanUnlike, //宽带业务与现网不一致
//SvlanOrCvlanException, //svlan or cvlan 业务流 异常
//ImsSvlanOrCvlanUnlike, //语音业务与现网不一致
//ImsPortAlreadyExist, //IMS端口被占用
case ErrorDesc.OltNotExist:
return("数据错误：Olt " + oltName + " IP录入错误");
case ErrorDesc.OltOffline:
return("数据错误：Olt " + oltName + " 与OMC网络中断");
case ErrorDesc.PonNotExist:
return("数据错误：Olt " + oltName + " Pon口 " + task.PonID + " 不存在");
case ErrorDesc.OnuAlreadyExist:
return("数据错误：OnuID " + task.OnuID + " 已存在");
case ErrorDesc.OnuNotExist:
return("数据错误：Onu " + task.OnuID + " 不存在");
case ErrorDesc.OnuTypeNotExist:
return("数据错误：Onu型号 " + task.OnuType + " 网管数据配置模型未建");
case ErrorDesc.OnuTypeError:
return("数据错误：Onu型号 " + task.OnuType + " 错误");
case ErrorDesc.SvlanError:
//
return("数据错误：Olt " + oltName + " Pon口 " +
task.PonID + " Svlan " + task.Svlan.ToString() +
" 或 Cvlan " + task.Cvlan.ToString() + " 不在olt vlan透传范围内，请核查");
case ErrorDesc.BbAlreadyExist:
return("数据错误：ONU " + task.OnuID + " 中已绑定宽带业务，请核查网管数据" + error);
case ErrorDesc.BbNotExist:
return("数据错误：ONU " + task.OnuID + " 中未绑定宽带业务，请核查资源");
case ErrorDesc.BbSvlanOrCvlanUnlike:
return("数据错误：宽带业务流与现网不一致，请核查资源" + error);
case ErrorDesc.SvlanOrCvlanException:
return("数据错误：ONU " + task.OnuID + " 中存在异常业务流，请核查网管数据" + error);
case ErrorDesc.ImsSvlanOrCvlanUnlike:
return("数据错误：语音业务流与现网不一致，请核查资源" + error);
case ErrorDesc.ImsPortAlreadyExist:
return("数据错误：ONU端口被占用" + error);
case ErrorDesc.ImsPortUnlike:
return("数据错误：语音端口信息与现网不一致，请核查资源" + error);
case ErrorDesc.ImsNotExist:
return("数据错误：ONU " + task.OnuID + " 中未绑定语音业务，请核查资源");
case ErrorDesc.InformationException:
return("数据异常：" + error);
case ErrorDesc.Unknown:
return(string.Empty);
default:
return(string.Empty);
}
}
