public static void UpdateStatus(ProductTreeEntity tentity)
{
using (var rs = new MyRecordSet())
{
var sql = "UPDATE [ProductTree] SET ReadBySAP = '{0}' WHERE Id = '{1}'";
rs.DoQuery(sql, tentity.ReadBySAP, tentity.Id);
}
}
/// <summary>
/// Retorna as entidades de transações não lida pelo SAP.
/// </summary>
/// <param name="itemCode">Código do item</param>
/// <param name="type">Tipo de transação</param>
/// <returns></returns>
public static ProductTreeEntity GetDados(string itemCode)
{
var prodTree = new ProductTreeEntity();
using (var conn = new ConnSqlServer())
{
var codeBars = MyQuery.GetValue("OITM", itemCode, "ItemCode", "CodeBars");
conn.DoQuery("SELECT * FROM [Sage_WorkTree] WITH (NOLOCK) WHERE ReadBySAP <> 'Y' AND OITM_CodeBars = '{0}'", codeBars);
//if(conn.)
while (conn.HasNext())
{
prodTree.Id = conn.GetFieldValue("Id").ToInt();
prodTree.AddDate = conn.GetFieldValue("AddDate").ToDate();
prodTree.TransactionType = conn.GetFieldValue("TransactionType").ToInt();
prodTree.ReadBySAP = conn.GetFieldValue("ReadBySAP").ToChar();
prodTree.OITM_CodeBars = conn.GetFieldValue("OITM_CodeBars").ToString();
prodTree.OITT_Code = conn.GetFieldValue("OITT_Code").ToString();
prodTree.OITT_Quantity = conn.GetFieldValue("OITT_Quantity").ToDouble();
prodTree.OITT_ToWH = conn.GetFieldValue("OITT_ToWH").ToString();
prodTree.OITT_PriceList = conn.GetFieldValue("OITT_PriceList").ToInt();
prodTree.OITT_Project = conn.GetFieldValue("OITT_Project").ToString();
prodTree.OITT_TreeType = conn.GetFieldValue("OITT_TreeType").ToChar();
using (var connLine = new MyLibs.v2.local.DataBase.ConnSqlServer())
{
var line = new ProductTreeEntityLine();
connLine.DoQuery("SELECT * FROM [ProductTreeLine] WHERE ReadBySAP <> 'Y'");
line.ITT1_Type = connLine.GetFieldValue("ITT1_Type").ToInt();
line.OITM_CodeBars = connLine.GetFieldValue("OITM_CodeBars").ToString();
line.ITT1_Code = connLine.GetFieldValue("ITT1_Code").ToString();
line.ITT1_Quantity = connLine.GetFieldValue("ITT1_Quantity").ToDouble();
line.ITT1_WareHouse = connLine.GetFieldValue("ITT1_WareHouse").ToString();
line.ITT1_IssuedMthd = connLine.GetFieldValue("ITT1_IssuedMthd").ToChar();
line.ITT1_Comment = connLine.GetFieldValue("ITT1_Comment").ToString();
line.ITT1_Price = connLine.GetFieldValue("ITT1_Price").ToDouble();
prodTree.Lines.Add(line);
}
}
}
return(prodTree);
}