public DataBaseResultSet SaveErrorDesc <T>(T objData) where T : class, IModel, new()
{
ErrorDesc obj = objData as ErrorDesc;
string sQuery = "sprocErrorDescInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("ErrorId", "ErrorId", 4, GenericDataType.Int, ParameterDirection.Input, obj.ErrorId));
list.Add(SqlConnManager.GetConnParameters("CategoryID", "CategoryID", 4, GenericDataType.Int, ParameterDirection.Input, obj.CategoryID));
list.Add(SqlConnManager.GetConnParameters("PageCode", "PageCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.PageCode));
list.Add(SqlConnManager.GetConnParameters("MethodCode", "MethodCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.MethodCode));
list.Add(SqlConnManager.GetConnParameters("EventCode", "EventCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.EventCode));
list.Add(SqlConnManager.GetConnParameters("ErrorLineNo", "ErrorLineNo", 4, GenericDataType.Int, ParameterDirection.Input, obj.ErrorLineNo));
list.Add(SqlConnManager.GetConnParameters("MethodTrace", "MethodTrace", 100, GenericDataType.String, ParameterDirection.Input, obj.MethodTrace));
list.Add(SqlConnManager.GetConnParameters("EmpNo", "EmpNo", 50, GenericDataType.String, ParameterDirection.Input, obj.EmpNo));
list.Add(SqlConnManager.GetConnParameters("ClientIpAddress", "ClientIpAddress", 30, GenericDataType.String, ParameterDirection.Input, obj.ClientIpAddress));
list.Add(SqlConnManager.GetConnParameters("PageName", "PageName", 100, GenericDataType.String, ParameterDirection.Input, obj.PageName));
list.Add(SqlConnManager.GetConnParameters("MethodName", "MethodName", 100, GenericDataType.String, ParameterDirection.Input, obj.MethodName));
list.Add(SqlConnManager.GetConnParameters("ErrorMsg", "ErrorMsg", 1000, GenericDataType.String, ParameterDirection.Input, obj.ErrorMsg));
list.Add(SqlConnManager.GetConnParameters("ErrorDate", "ErrorDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ErrorDate));
list.Add(SqlConnManager.GetConnParameters("ErrorData", "ErrorData", -1, GenericDataType.String, ParameterDirection.Input, obj.ErrorData));
list.Add(SqlConnManager.GetConnParameters("ErrorType", "ErrorType", 100, GenericDataType.String, ParameterDirection.Input, obj.ErrorType));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null));
list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null));
return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray()));
}
public void ParseErrorDesc(ICommandsBuilder builder, string command)
{
if (m_completionCode == CommandResponseStatus.COMPLD)
{
return;
}
m_errorDesc = builder.ParseErrorDesc(m_additionalInfo, command);
}
public void GetListErrorDesc <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListErrorDesc";
ErrorDesc objData = objFilter as ErrorDesc;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("ErrorId", "ErrorId", 4, GenericDataType.Int, ParameterDirection.Input, objData.ErrorId));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillErrorDescDataFromReader, ref listData);
}
private void FillErrorDescDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new()
{
while (DbReader.Read())
{
T obj = new T();
ErrorDesc objData = obj as ErrorDesc;
obj.FillDataFromDB(DbReader);
listData.Add(obj);
}
}
public virtual int _GetUniqueIdentifier()
{
var hashCode = 399326290;
hashCode = hashCode * -1521134295 + (Id?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Units?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (NumberOfPallets?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Finished.GetHashCode());
hashCode = hashCode * -1521134295 + (ErrorOccured.GetHashCode());
hashCode = hashCode * -1521134295 + (ErrorDesc?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Date?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (CurrentStockUnits?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (ItemSKU?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (ItemWarehouseCode?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Initialized.GetHashCode());
hashCode = hashCode * -1521134295 + (startDateTime?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (RealOrderArrivalDate?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (RealOrderUnits?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (SupplierCoverageDays?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (CoverageDays?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (InitialStockLevel?.GetHashCode() ?? 0);
return(hashCode);
}
public CommandResponseMsg()
{
m_localTime = DateTime.Now;
m_errorDesc = ErrorDesc.None;
}
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);
}
}
