public string RollbackTask(string xml)
{
string result = string.Empty;
try
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.LoadXml(xml);
string taskID = xmldoc.DocumentElement.SelectSingleNode("//TaskID").InnerText;
DateTime dt1 = DateTime.Now;
WriteLog.WriteLine(WriteLog.m_FilePreName, string.Format("RollbackTask {0}", taskID));
System.Data.SqlClient.SqlParameter sp_taskID = new System.Data.SqlClient.SqlParameter("@taskID", taskID);
System.Data.SqlClient.SqlParameter sp_flag = new System.Data.SqlClient.SqlParameter("@flag", System.Data.SqlDbType.Int);
sp_flag.Direction = System.Data.ParameterDirection.Output;
System.Data.SqlClient.SqlParameter sp_msg = new System.Data.SqlClient.SqlParameter("@msg", System.Data.SqlDbType.VarChar);
sp_msg.Direction = System.Data.ParameterDirection.Output;
sp_msg.Size = 1024;
SQLUtil.ExecProc(m_conn, "spRollbackHistoryTask", sp_taskID, sp_flag, sp_msg);
result = sp_msg.Value.ToString();
WriteLog.WriteLine(WriteLog.m_FilePreName, string.Format("RollbackTask {0} spend {1} s", taskID, (DateTime.Now - dt1).TotalSeconds.ToString()));
switch (int.Parse(sp_flag.Value.ToString()))
{
case 1:
result = IdlUtil.ConvertToReslutXML(1, "接收成功");
break;
default:
result = IdlUtil.ConvertToReslutXML(0, result);
break;
}
}
catch (NullReferenceException ex)
{
result = IdlUtil.ConvertToReslutXML(0, "报文信息不完整或格式有误,请核查");
WriteLog.WriteLine(xml + Environment.NewLine + ex.ToString());
}
catch (Exception ex)
{
if (ex.Message.IndexOf("重复键") >= 0)
{
result = IdlUtil.ConvertToReslutXML(0, "此工单已下发");
}
else
{
result = IdlUtil.ConvertToReslutXML(0, ex.Message);
}
WriteLog.WriteLine(xml + Environment.NewLine + ex.ToString());
}
return(result);
}
public string SendTask(string xml)
{
string result = string.Empty;
try
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.LoadXml(xml);
string taskID = xmldoc.DocumentElement.SelectSingleNode("//TaskID").InnerText;
string taskType = xmldoc.DocumentElement.SelectSingleNode("//TaskType").InnerText;
string city = xmldoc.DocumentElement.SelectSingleNode("//City").InnerText;
string manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Manufacturer").InnerText;
string omcName = xmldoc.DocumentElement.SelectSingleNode("//OMCName").InnerText;
string oltID = xmldoc.DocumentElement.SelectSingleNode("//OLTID").InnerText;
string ponID = xmldoc.DocumentElement.SelectSingleNode("//PONID").InnerText;
string onuID = xmldoc.DocumentElement.SelectSingleNode("//ONUID").InnerText;
string phone = xmldoc.DocumentElement.SelectSingleNode("//PhoneNumber").InnerText;
string onuType = null;
int svlan = 0, cvlan = 0, muvlan = 0, ywvlan = 0, msvlan = 0, mcvlan = 0, feNumber = -1, potsNumber = -1;
SQLUtil.CheckOMC(m_conn, city, manufacturer, omcName);
DateTime dt1 = DateTime.Now;
//入库处理
result = IdlUtil.ConvertToReslutXML(1, "接收成功");
TaskType type = IdlUtil.ParseCodeToTaskType(taskType);
string tName = Enum.GetName(typeof(TaskType), type);
WriteLog.WriteLine(WriteLog.m_FilePreName, string.Format("{0} {1}", tName, taskID));
switch (type)
{
case TaskType.NewBroadband:
case TaskType.AddBroadband:
try
{
svlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//SVLAN").InnerText);
}
catch { }
try
{
cvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//CVLAN").InnerText);
}
catch { }
try
{
msvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//MSVLAN").InnerText);
}
catch { }
try
{
mcvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//MCVLAN").InnerText);
}
catch { }
try
{
feNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//FENUMBER").InnerText);
}
catch { }
try
{
potsNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//POTSNUMBER").InnerText);
}
catch { }
Task broadbandTask = new Task(taskID, type, city, manufacturer, omcName, oltID, ponID, onuID, onuType, svlan,
cvlan, phone, DateTime.Now, muvlan, ywvlan, msvlan, mcvlan, feNumber, potsNumber);
SQLUtil.InsertTask(m_conn, broadbandTask);
break;
case TaskType.NewIMS:
case TaskType.AddIMS:
try
{
svlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//SVLAN").InnerText);
}
catch { }
try
{
cvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//CVLAN").InnerText);
}
catch { }
try
{
msvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//MSVLAN").InnerText);
}
catch { }
try
{
mcvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//MCVLAN").InnerText);
}
catch { }
try
{
feNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//FENUMBER").InnerText);
}
catch { }
try
{
potsNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//POTSNUMBER").InnerText);
}
catch { }
Task imsTask = new Task(taskID, type, city, manufacturer, omcName, oltID, null, ponID, onuID, onuType, svlan, cvlan,
phone, DateTime.Now, muvlan, ywvlan, msvlan, mcvlan, feNumber, potsNumber);
SQLUtil.InsertTask(m_conn, imsTask);
break;
case TaskType.DelONU:
try
{
msvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//MSVLAN").InnerText);
}
catch { }
try
{
mcvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//MCVLAN").InnerText);
}
catch { }
try
{
feNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//FENUMBER").InnerText);
}
catch { }
try
{
potsNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//POTSNUMBER").InnerText);
}
catch { }
Task delOnuTask = new Task(taskID, type, city, manufacturer, omcName, oltID, ponID, onuID, phone, DateTime.Now,
muvlan, ywvlan, msvlan, mcvlan, feNumber, potsNumber);
SQLUtil.InsertTask(m_conn, delOnuTask);
break;
case TaskType.DelBroadband:
case TaskType.DelIMS:
try
{
svlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//SVLAN").InnerText);
}
catch { }
try
{
cvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//CVLAN").InnerText);
}
catch { }
try
{
msvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//MSVLAN").InnerText);
}
catch { }
try
{
mcvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//MCVLAN").InnerText);
}
catch { }
try
{
feNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//FENUMBER").InnerText);
}
catch { }
try
{
potsNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//POTSNUMBER").InnerText);
}
catch { }
Task delTask = new Task(taskID, type, city, manufacturer, omcName, oltID, ponID, onuID, svlan, cvlan,
phone, DateTime.Now, muvlan, ywvlan, msvlan, mcvlan, feNumber, potsNumber);
SQLUtil.InsertTask(m_conn, delTask);
break;
default:
WriteLog.WriteLine(WriteLog.m_FilePreName, string.Format("{0} {1} {2}", tName, taskID, "工单类型：" + taskType + " 未定义"));
result = IdlUtil.ConvertToReslutXML(0, "工单类型：" + taskType + " 未定义");
break;
}
WriteLog.WriteLine(WriteLog.m_FilePreName, string.Format("{0} {1} spend {2} s", tName, taskID, (DateTime.Now - dt1).TotalSeconds.ToString()));
}
catch (NullReferenceException ex)
{
result = IdlUtil.ConvertToReslutXML(0, "报文信息不完整或格式有误,请核查");
WriteLog.WriteLine(xml + Environment.NewLine + ex.ToString());
}
catch (Exception ex)
{
if (ex.Message.IndexOf("重复键") >= 0)
{
result = IdlUtil.ConvertToReslutXML(0, "此工单已下发");
}
else
{
result = IdlUtil.ConvertToReslutXML(0, ex.Message);
}
WriteLog.WriteLine(xml + Environment.NewLine + ex.ToString());
}
return(result);
}
public string RelocateTask(string xml)
{
string result = string.Empty;
try
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.LoadXml(xml);
#region 新的数据
string taskID = xmldoc.DocumentElement.SelectSingleNode("//TaskID").InnerText;
string taskType = xmldoc.DocumentElement.SelectSingleNode("//TaskType").InnerText;
string city = xmldoc.DocumentElement.SelectSingleNode("//City").InnerText;
string manufacturer = xmldoc.DocumentElement.SelectSingleNode("//Manufacturer").InnerText;
string omcName = xmldoc.DocumentElement.SelectSingleNode("//OMCName").InnerText;
string oltID = xmldoc.DocumentElement.SelectSingleNode("//OLTID").InnerText;
string ponID = xmldoc.DocumentElement.SelectSingleNode("//PONID").InnerText;
string onuID = xmldoc.DocumentElement.SelectSingleNode("//ONUID").InnerText;
string phone = xmldoc.DocumentElement.SelectSingleNode("//PhoneNumber").InnerText;
int svlan = 0, cvlan = 0, mvlan = 0, feNumber = -1, potsNumber = -1;
try
{
svlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//SVLAN").InnerText);
}
catch { }
try
{
cvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//CVLAN").InnerText);
}
catch { }
try
{
mvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//MVLAN").InnerText);
}
catch { }
try
{
feNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//FENUMBER").InnerText);
}
catch { }
try
{
potsNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//POTSNUMBER").InnerText);
}
catch { }
#endregion
#region 旧的数据
string oldCity = xmldoc.DocumentElement.SelectSingleNode("//OldCity").InnerText;
string oldManufacturer = xmldoc.DocumentElement.SelectSingleNode("//OldManufacturer").InnerText;
string oldOmcName = xmldoc.DocumentElement.SelectSingleNode("//OldOMCName").InnerText;
string oldOltID = xmldoc.DocumentElement.SelectSingleNode("//OldOLTID").InnerText;
string oldPonID = xmldoc.DocumentElement.SelectSingleNode("//OldPONID").InnerText;
string oldOnuID = xmldoc.DocumentElement.SelectSingleNode("//OldONUID").InnerText;
string oldPhone = xmldoc.DocumentElement.SelectSingleNode("//OldPhoneNumber").InnerText;
int oldSvlan = 0, oldCvlan = 0, oldMvlan = 0, oldFeNumber = -1, oldPotsNumber = -1;
try
{
oldSvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//OldSVLAN").InnerText);
}
catch { }
try
{
oldCvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//OldCVLAN").InnerText);
}
catch { }
try
{
oldMvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//OldMVLAN").InnerText);
}
catch { }
try
{
oldFeNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//OldFENUMBER").InnerText);
}
catch { }
try
{
oldPotsNumber = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//OldPOTSNUMBER").InnerText);
}
catch { }
#endregion
#region 语音数据
string IsContainIMS = xmldoc.DocumentElement.SelectSingleNode("//IsContainIMS").InnerText;
int imsSvlan = 0, imsCvlan = 0;
try
{
imsSvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//IMSSvlan").InnerText);
}
catch { }
try
{
imsCvlan = int.Parse(xmldoc.DocumentElement.SelectSingleNode("//IMSCvlan").InnerText);
}
catch { }
#endregion
#region IPTV数据
string IsContainIPTV = "N";// xmldoc.DocumentElement.SelectSingleNode("//IsContainIPTV").InnerText;
int iptvSvlan = 0, iptvCvlan = 0;
try
{
iptvSvlan = 0;// int.Parse(xmldoc.DocumentElement.SelectSingleNode("//IPTVSvlan").InnerText);
}
catch { }
try
{
iptvCvlan = 0;// int.Parse(xmldoc.DocumentElement.SelectSingleNode("//IPTVCvlan").InnerText);
}
catch { }
#endregion
SQLUtil.CheckOMC(m_conn, city, manufacturer, omcName); //检查OMC
DateTime dt1 = DateTime.Now;
result = IdlUtil.ConvertToReslutXML(1, "接收成功");
WriteLog.WriteLine(WriteLog.m_FilePreName, string.Format("RelocateTask {0}", taskID));
SQLUtil.InsertRelocateTask(m_conn, taskID, taskType, city, manufacturer, omcName, oltID, ponID, onuID, phone, svlan, cvlan, mvlan, feNumber,
potsNumber, oldCity, oldManufacturer, oldOmcName, oldOltID, oldPonID, oldOnuID, oldPhone, oldSvlan, oldCvlan, oldMvlan,
oldFeNumber, oldPotsNumber, IsContainIMS, imsSvlan, imsCvlan, IsContainIPTV, iptvSvlan, iptvCvlan);
WriteLog.WriteLine(WriteLog.m_FilePreName, string.Format("RelocateTask {0} spend {1} s", taskID, (DateTime.Now - dt1).TotalSeconds.ToString()));
}
catch (NullReferenceException ex)
{
result = IdlUtil.ConvertToReslutXML(0, "报文信息不完整或格式有误,请核查");
WriteLog.WriteLine(xml + Environment.NewLine + ex.ToString());
}
catch (Exception ex)
{
if (ex.Message.IndexOf("重复键") >= 0)
{
result = IdlUtil.ConvertToReslutXML(0, "此工单已下发");
}
else
{
result = IdlUtil.ConvertToReslutXML(0, ex.Message);
}
WriteLog.WriteLine(xml + Environment.NewLine + ex.ToString());
}
return(result);
}