Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var myHub = $.connection.myHub;
- var direccionWeb = $("#direccionWeb").val().toString();
- $.connection.hub.url = direccionWeb + "/signalr";
- $.connection.hub.start().done(function () {
- myHub.server.broadcastMessageToPrinterReportTicket(global_venta, global_mesa, nombregarzon, idgrupo, grupo);
- }).fail(function (error) {
- console.error(error);
- });
- public void BroadcastMessageToPrinterReportTicket(String global_venta,String global_mesa,String nombregarzon,String idgrupo, String grupo)
- {
- string nombreImpresora = grupo;
- DataTable dt = new DataTable();
- string sql = "SELECT " +
- "cantidad," +
- "detalle " +
- "FROM producto " +
- "WHERE venta=@global_venta AND venta>0 AND menu.grupo=@idgrupo AND comandasd.pedido=0";
- conexion.conectar();
- using (MySqlCommand command = new MySqlCommand(sql, conexion.con))
- {
- command.Parameters.AddWithValue("@global_venta", global_venta);
- command.Parameters.AddWithValue("@idgrupo", idgrupo);
- using (MySqlDataAdapter reader = new MySqlDataAdapter(command))
- {
- using (MySqlDataAdapter sda = new MySqlDataAdapter(command))
- {
- sda.Fill(dt);
- }
- }
- }
- conexion.cerrar();
- Clients.All.imprimeReport(datos, ........);
- }
- public void conectar()
- {
- try
- {
- string ip = HttpContext.Current.Session["ip"].ToString();
- string db = HttpContext.Current.Session["db"].ToString();
- string user = HttpContext.Current.Session["user"].ToString();
- string pass = HttpContext.Current.Session["pass"].ToString();
- con = new MySqlConnection("server=" + ip + ";user id=" + user + ";password=" + pass + ";database=" + db + ";port=3306;Allow User Variables=true");
- con.Open();
- }
- catch
- {
- }
- }
Add Comment
Please, Sign In to add comment