/// <summary>
/// Получить обновленный документ
/// </summary>
/// <param name="num_doc"></param>
/// <returns></returns>
public UZ_DOC GetDocumentOfDB_NumDoc(string num_doc)
{
try
{
UZ_Convert convert = new UZ_Convert(this.servece_owner);
UZ_DOC doc = null;
EFUZ_Data ef_data = new EFUZ_Data(new EFSMSDbContext());
UZ_Data uzd = ef_data.Context.Where(d => d.doc_Id == num_doc).FirstOrDefault();
if (uzd != null)
{
string xml_final = convert.XMLToFinalXML(uzd.raw_xml);
OTPR otpr = convert.FinalXMLToOTPR(xml_final);
// Документ найден
doc = new UZ_DOC();
doc.id_doc = uzd.doc_Id;
doc.revision = uzd.doc_Revision;
doc.status = GetStatus(uzd.doc_Status);
doc.sender_code = uzd.depart_code;
doc.recipient_code = uzd.arrived_code;
doc.dt = uzd.dt;
doc.xml = uzd.raw_xml;
doc.xml_final = xml_final;
doc.otpr = otpr;
}
return(doc);
}
catch (Exception e)
{
e.ExceptionMethodLog(String.Format("GetDocumentOfDB_NumDoc(num_doc={0})", num_doc), this.servece_owner, eventID);
return(null);
}
}
/// <summary>
/// Получить UZ_DOC документ из UZ_Data (Промежуточной базы)
/// </summary>
/// <param name="uz_doc"></param>
/// <returns></returns>
public UZ_DOC Convert_UZ_Data_To_UZ_DOC(UZ_Data uz_doc)
{
try
{
UZ_Convert convert = new UZ_Convert(this.servece_owner);
string xml_final = convert.XMLToFinalXML(uz_doc.raw_xml);
OTPR otpr = convert.FinalXMLToOTPR(xml_final);
// Документ найден
UZ_DOC doc = new UZ_DOC()
{
id_doc = uz_doc.doc_Id,
revision = uz_doc.doc_Revision,
status = GetStatus(uz_doc.doc_Status),
sender_code = uz_doc.depart_code,
recipient_code = uz_doc.arrived_code,
dt = uz_doc.dt,
xml = uz_doc.raw_xml,
xml_final = xml_final,
otpr = otpr,
};
return(doc);
}
catch (Exception e)
{
e.ExceptionMethodLog(String.Format("Convert_UZ_Data_To_UZ_DOC(doc={0})", uz_doc), this.servece_owner, eventID);
return(null);
}
}
/// <summary>
/// Получить XML перевозочного документа из промежуточной базой KRR-PA-VIZ-Other_DATA по номеру вагона
/// </summary>
/// <param name="num"></param>
/// <returns></returns>
public UZ_DOC GetDocumentOfDB_Num(int num)
{
try
{
UZ_DOC doc = null;
EFUZ_VagonData ef_vagon = new EFUZ_VagonData(new EFSMSDbContext());
EFUZ_Data ef_data = new EFUZ_Data(new EFSMSDbContext());
UZ_VagonData vagon = ef_vagon.Context.Where(v => v.nomer == num.ToString()).OrderByDescending(c => c.dt).FirstOrDefault();
if (vagon != null)
{
// вагон найден. найдем документ
UZ_Data data = ef_data.Context.Where(d => d.doc_Id == vagon.nom_doc).FirstOrDefault();
if (data != null)
{
UZ_Convert convert = new UZ_Convert(this.servece_owner);
string xml_final = convert.XMLToFinalXML(data.raw_xml);
OTPR otpr = convert.FinalXMLToOTPR(xml_final);
// Документ найден
doc = new UZ_DOC();
doc.id_doc = data.doc_Id;
doc.revision = data.doc_Revision;
doc.status = GetStatus(data.doc_Status);
doc.sender_code = data.depart_code;
doc.recipient_code = data.arrived_code;
doc.dt = data.dt;
doc.xml = data.raw_xml;
doc.xml_final = xml_final;
doc.otpr = otpr;
}
}
return(doc);
}
catch (Exception e)
{
e.ExceptionMethodLog(String.Format("GetDocumentOfDB_Num(num={0})", num), this.servece_owner, eventID);
return(null);
}
}
