/// <summary>
/// Obtem os dados para criar um novo Pedido de Venda e Nota Fiscal (Rascunho).
/// </summary>
/// <returns></returns>
public static List <T32Entity> GetNewORDR()
{
var t32list = new List <T32Entity>();
using (var rs_lines = new MyRecordSet())
{
rs_lines.DoQuery("SELECT * FROM [Sage_Transacoes32L1] WITH (NOLOCK) WHERE ReadBySAP <> 'Y' AND (ORDR_DocEntry <= 0 OR ORDR_DocEntry IS NULL) ORDER BY JOMAR_OrderNum ASC");
var t32 = new T32Entity();
var t32line = new T32EntityLine();
var control = -1;
while (rs_lines.HasNext())
{
try
{
if (control == -1) // Controle Inicial
{
control = rs_lines.GetFieldValue("JOMAR_OrderNum").ToInt(); // Nº da ordem no controle
}
else if (control != rs_lines.GetFieldValue("JOMAR_OrderNum").ToInt())
{
t32list.Add(t32); // Guarda o pacote na lista
t32 = new T32Entity(); // Cria um novo header
control = rs_lines.GetFieldValue("JOMAR_OrderNum").ToInt(); // Nº da ordem no controle
}
#region Linhas
t32line = new T32EntityLine();
t32line.Id = rs_lines.GetFieldValue("JOMAR_OrderNum").ToInt();
t32line.JOMAR_OrderNum = rs_lines.GetFieldValue("JOMAR_OrderNum").ToInt();
t32line.ReadBySAP = rs_lines.GetFieldValue("ReadBySAP").ToChar();
t32line.Jomar_LineNum = rs_lines.GetFieldValue("Jomar_LineNum").ToInt();
t32line.ORDR_DocEntry = rs_lines.GetFieldValue("ORDR_DocEntry").ToInt();
t32line.OINV_DocEntry = rs_lines.GetFieldValue("OINV_DocEntry").ToInt();
t32line.OITM_CodeBars = rs_lines.GetFieldValue("OITM_CodeBars").ToString();
t32line.RDR1_Quantity = rs_lines.GetFieldValue("RDR1_Quantity").ToDouble();
t32line.RDR1_WhsCode = rs_lines.GetFieldValue("RDR1_WhsCode").ToString();
t32line.JOMAR_Peso = rs_lines.GetFieldValue("JOMAR_Peso").ToDouble();
t32line.SalesOrderIndex = rs_lines.GetFieldValue("SalesOrderIndex").ToInt();
t32line.MSG_SAP = rs_lines.GetFieldValue("MSG_SAP").ToString();
#endregion
var rs_header = new MyRecordSet();
rs_header.DoQuery("SELECT * FROM [Sage_Transacoes32] WITH (NOLOCK) WHERE JOMAR_OrderNum = '{0}'", rs_lines.GetFieldValue("JOMAR_OrderNum").ToInt());
{
#region Cabeçalho
if (t32line.JOMAR_OrderNum != t32.JOMAR_OrderNum)
{
t32.Id = rs_lines.GetFieldValue("JOMAR_OrderNum").ToInt();
t32.JOMAR_OrderNum = rs_header.GetFieldValue("JOMAR_OrderNum").ToInt();
t32.ReadBySAP = rs_header.GetFieldValue("ReadBySAP").ToChar();
t32.TransactionType = rs_header.GetFieldValue("TransactionType").ToInt();
t32.JOMAR_OIM = rs_header.GetFieldValue("JOMAR_OIM").ToInt();
t32.ORDR_DocEntry = rs_header.GetFieldValue("ORDR_DocEntry").ToInt();
t32.JOMAR_CardCode = rs_header.GetFieldValue("JOMAR_CardCode").ToString();
t32.ORDR_DocDate = rs_header.GetFieldValue("ORDR_DocDate").ToDate();
t32.ORDR_DocDueDate = rs_header.GetFieldValue("ORDR_DocDueDate").ToDate();
t32.ORDR_TaxDate = rs_header.GetFieldValue("ORDR_TaxDate").ToDate();
t32.ORDR_NumAtCard = rs_header.GetFieldValue("ORDR_NumAtCard").ToString();
t32.ORDR_BplId = rs_header.GetFieldValue("ORDR_BplId").ToInt();
t32.ORDR_Comments = rs_header.GetFieldValue("ORDR_Comments").ToString();
t32.SalesHeaderIndex = rs_header.GetFieldValue("SalesHeaderIndex").ToInt();
t32.MSG_SAP = rs_header.GetFieldValue("MSG_SAP").ToString();
}
#endregion
}
t32line.ORDR_DocEntry = t32.ORDR_DocEntry;
}
catch (Exception ex)
{
principal.GravaAudit(ex.Message.ToString());
}
t32.Lines.Add(t32line);
}
// Pega o ultimo que sobra
if (rs_lines.CountLines() > 0)
{
t32list.Add(t32);
}
}
return(t32list);
}