public static HanaService CreateInstance()
{
if (instance == null)
{
instance = new HanaService();
}
return(instance);
}
public void ExecuteQuery()
{
try
{
conn = HanaService.ConnectToDataBase();
conn.Open();
cnt = 0;
string query = Queries.GetQueueOfLabels;
HanaCommand command = new HanaCommand(query);
command.Connection = conn;
HanaDataReader dr = command.ExecuteReader();
while (dr.Read())
{
cnt++;
daimlerLabel = new Label();
daimlerLabel.Supplier = dr["Supplier"].ToString();
daimlerLabel.Odbiorca = dr["Odbiorca"].ToString();
daimlerLabel.PartNo = dr["Part no"].ToString();
daimlerLabel.Quantity = double.Parse(dr["U_QtyOnLabel"].ToString());
daimlerLabel.Street = dr["Street"].ToString();
daimlerLabel.Address = dr["Adres odbiorcy"].ToString();
daimlerLabel.City = dr["City"].ToString();
daimlerLabel.AdviceNote = dr["Advice note"].ToString();
daimlerLabel.Description = dr["Description"].ToString();
daimlerLabel.Gate = dr["Dock/Gate"].ToString();
daimlerLabel.LabelNo = double.Parse(dr["Serien"].ToString());
daimlerLabel.Date = dr["Date"].ToString();
daimlerLabel.SupplierPartNumber = dr["Supplier part no"].ToString();
daimlerLabel.GTL = dr["GTL"].ToString();
daimlerLabel.DocEntry = dr["DocEntry"].ToString();
daimlerLabel.Los = dr["Los"].ToString();
singleLabel = stringService.ConvertZplFile(stringService.ReadFile(), daimlerLabel);
Console.WriteLine(singleLabel);
ZplService.Print(singleLabel, IP.Zpl401);
if (cnt == 1)
{
hanaService.CallUpdateProcedure(conn, int.Parse(daimlerLabel.DocEntry), 0);
}
return;
}
if (daimlerLabel != null)
{
hanaService.CallUpdateProcedure(conn, int.Parse(daimlerLabel.DocEntry), 2);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
if (daimlerLabel != null)
{
hanaService.CallUpdateProcedure(conn, int.Parse(daimlerLabel.DocEntry), 3);
}
}
finally
{
Console.WriteLine("Zaktualizowano");
conn.Close();
}
}