Guest User

Untitled

a guest
Dec 27th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.01 KB | None | 0 0
  1. var myHub = $.connection.myHub;
  2. var direccionWeb = $("#direccionWeb").val().toString();
  3. $.connection.hub.url = direccionWeb + "/signalr";
  4. $.connection.hub.start().done(function () {
  5. myHub.server.broadcastMessageToPrinterReportTicket(global_venta, global_mesa, nombregarzon, idgrupo, grupo);
  6.  
  7. }).fail(function (error) {
  8. console.error(error);
  9. });
  10.  
  11. public void BroadcastMessageToPrinterReportTicket(String global_venta,String global_mesa,String nombregarzon,String idgrupo, String grupo)
  12. {
  13. string nombreImpresora = grupo;
  14. DataTable dt = new DataTable();
  15.  
  16. string sql = "SELECT " +
  17. "cantidad," +
  18. "detalle " +
  19. "FROM producto " +
  20. "WHERE venta=@global_venta AND venta>0 AND menu.grupo=@idgrupo AND comandasd.pedido=0";
  21. conexion.conectar();
  22.  
  23. using (MySqlCommand command = new MySqlCommand(sql, conexion.con))
  24. {
  25. command.Parameters.AddWithValue("@global_venta", global_venta);
  26. command.Parameters.AddWithValue("@idgrupo", idgrupo);
  27. using (MySqlDataAdapter reader = new MySqlDataAdapter(command))
  28. {
  29. using (MySqlDataAdapter sda = new MySqlDataAdapter(command))
  30. {
  31. sda.Fill(dt);
  32. }
  33. }
  34. }
  35. conexion.cerrar();
  36.  
  37.  
  38. Clients.All.imprimeReport(datos, ........);
  39. }
  40.  
  41. public void conectar()
  42. {
  43. try
  44. {
  45. string ip = HttpContext.Current.Session["ip"].ToString();
  46. string db = HttpContext.Current.Session["db"].ToString();
  47. string user = HttpContext.Current.Session["user"].ToString();
  48. string pass = HttpContext.Current.Session["pass"].ToString();
  49.  
  50. con = new MySqlConnection("server=" + ip + ";user id=" + user + ";password=" + pass + ";database=" + db + ";port=3306;Allow User Variables=true");
  51. con.Open();
  52. }
  53. catch
  54. {
  55.  
  56. }
  57. }
Add Comment
Please, Sign In to add comment