Hackerman's questions

I have the following if, as you can see every time the variable is false it enters and executes the send payments method, I have this if inside a cycle so it is constantly executing

SendPago is a service and since it is constantly running the service returns me that it cannot send so many requests in such a short time, inside this if I put a Thread.Sleep(10000);so that it can tell it before entering this method wait 10 seconds and it works but what I have seen is that every time you enter the Thread the app is blocked for those 10 seconds

How can I inside the if say that for every minute it only executes 5 times, or wait a while so that it doesn't execute every second?

" Without Using a Timer "

 Inte = pagos.Integration;
                    if (Inte == false)
                    {
                        Thread.Sleep(10000);
                        var Respuesta = await proxy.EnviarPago(pagos);
                    }

I have the following update where I say that the weight column is updated with the data from the weight column but from the other database and where I tell it to be equal to the batch of the other database and the animal

UPDATE [2_Datos].dbo.tblmvto_lotes 
SET peso = (SELECT peso FROM [1_Datos].dbo.tblmvto_lotes) 
WHERE  codlote = (SELECT codlote FROM [1_Datos].dbo.tblmvto_lotes) AND 
animal =  (SELECT animal FROM [1_Datos].dbo.tblmvto_lotes)

But I get the following message
Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated.

This is because it could be that there are more rows in one than the other, but if I am already making the comparison that the codlote and the animal are the same and the two databases are the same, I only need to update the weight field one by the other, as you can see in the img the data is different is to update it

I have two identical queries but each query is in a different database

SELECT T0.codlote AS Lote1,sum(T0.peso) AS peso1,T1.fecha AS Fecha1
FROM [1_Datos].dbo.tblmvto_lotes T0
INNER JOIN tbllotes T1 ON T1.codlote = T0.codlote
GROUP BY T0.codlote, T1.fecha
ORDER BY T0.codlote
---
SELECT R0.codlote AS Lote2,sum(R0.peso) AS peso2,R1.fecha AS Fecha2
FROM [2_Datos].dbo.tblmvto_lotes R0
INNER JOIN tbllotes R1 ON R1.codlote = R0.codlote
GROUP BY R0.codlote,R1.fecha
ORDER BY R0.codlote

shows me the following

I put them together with the union then I did a subquery, but I don't get the result.

SELECT V1.Lote1, V1.peso1,Fecha1 FROM(
SELECT T0.codlote AS Lote1,sum(T0.peso) AS peso1,T1.fecha AS Fecha1
FROM [1_Datos].dbo.tblmvto_lotes T0
INNER JOIN tbllotes T1 ON T1.codlote = T0.codlote
GROUP BY T0.codlote, T1.fecha
UNION ALL
SELECT R0.codlote AS Lote2,sum(R0.peso) AS peso2,R1.fecha AS Fecha2
FROM [2_Datos].dbo.tblmvto_lotes R0
INNER JOIN tbllotes R1 ON R1.codlote = R0.codlote
GROUP BY R0.codlote,R1.fecha) V1

The result I expect is that the second query stays on the right side of the first, as follows

But I can't do this query, is it with the subquery or how should it be done?

I have this method that consumes an api

private void OrdenesTrabajoAPI()
{
    try
    {
        string Desde = DateTime.Now.Date.ToString("o", CultureInfo.InvariantCulture);
        string Hasta = DtHasta.Value.ToString("o", CultureInfo.InvariantCulture);
        var client = new RestClient("https://fleet.cloudfleet.com/api/v1/work-orders/?createdAtFrom=" + Desde + "&createdAtTo=" + Hasta + "");
        client.Timeout = -1;
        var request = new RestRequest(Method.GET);
        request.AddHeader("Authorization", ConfigurationManager.AppSettings["KEY"]);
        request.AddHeader("Content-Type", "application/json; charset=utf-8");
        request.AddParameter("application/json; charset=utf-8", "", ParameterType.RequestBody);
        IRestResponse response = client.Execute(request);
        if (response.Content.Contains("No Work Orders found with the specified filters"))
        {
            lblError.Text = "No se encontraron órdenes de trabajo con las fechas especificados";
        }
        else
        {
            List<Vehiculos> ob = JsonConvert.DeserializeObject<List<Vehiculos>>(response.Content);
            dataGridView2.DataSource = ob;
        }
        MessageBox.Show(response.Content);
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

As you can see the data that it brings from the api puts them in the

dataGridView2.DataSource = ob;

and load them like this

I need to sort the number column from highest to lowest

with this code it supposedly orders them

dataGridView2.Sort(dataGridView2.Columns[0], System.ComponentModel.ListSortDirection.Ascending);

But I get the following

'To be sortable, a DataGridView control must be bound to an IBindingList object.'

JSON

 [
  {
    "number": 2657,
    "vehicleCode": "C9M955",
    "workshopDate": "2020-09-30T14:35:00.0000000Z",
    "startDate": "2020-09-30T14:35:00.0000000Z",
    "estimatedFinishDate": "2020-09-30T15:35:00.0000000Z",
    "status": "opened",
    "odometer": 210500,
    "hourmeter": null,
    "vendor": {
      "id": 72791,
      "name": "Almacen y taller Autocar inyeccion"
    },
    "reason": null,
    "detectedIssue": null,
    "paymentCondition": null,
    "warranty": null,
    "comments": null,
    "driver": null,
    "maintenanceLabels": null,
    "type": null,
    "city": null,
    "costCenter": null,
    "primaryGroup": null,
    "secundaryGroup": null,
    "createdAt": "2021-01-18T14:37:03.2170000Z",
    "createdBy": {
      "id": 19718,
      "name": "Juan Perez"
    },
    "affectsMaintenanceSchedule": true,
    "affectsVehicleAvailability": true,
    "updatedAt": "2021-01-18T14:42:30.1500000Z",
    "updatedBy": {
      "id": 19718,
      "name": "Juan Perez"
    },
    "totalCostLabors": 24500,
    "totalCostParts": 0,
    "totalCost": 24500,
    "technicalCompletionDate": null,
    "finalCompletionDate": null,
    "lastSystemTechnicalCompletionDate": null,
    "lastSystemFinalCompletionDate": null
  }
]

Solution

  private void OrdenesTrabajoAPI()
        {
            try
            {
                string Desde = DateTime.Now.Date.ToString("o", CultureInfo.InvariantCulture);
                string Hasta = DtHasta.Value.ToString("o", CultureInfo.InvariantCulture);
                var client = new RestClient("https://fleet.cloudfleet.com/api/v1/work-orders/?createdAtFrom=" + Desde + "&createdAtTo=" + Hasta + "");
                client.Timeout = -1;
                var request = new RestRequest(Method.GET);
                request.AddHeader("Authorization", ConfigurationManager.AppSettings["KEY"]);
                request.AddHeader("Content-Type", "application/json; charset=utf-8");
                request.AddParameter("application/json; charset=utf-8", "", ParameterType.RequestBody);
                IRestResponse response = client.Execute(request);
                if (response.Content.Contains("No Work Orders found with the specified filters"))
                {
                    lblError.Text = "No se encontraron órdenes de trabajo con las fechas especificados";
                }
                else
                {
                    List<Vehiculos> ob = JsonConvert.DeserializeObject<List<Vehiculos>>(response.Content);
                    dataGridView2.DataSource = ob;
                    dataGridView2.DataSource = (from o in ob
                           orderby  o.number descending
                           select o).ToList();
                }
                MessageBox.Show(response.Content);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

I need to update a field with values ​​that another field already has

i have this script

UPDATE [Tabla2].[dbo].[tblmvto_lotes]
SET peso = T2.peso
FROM [Tabla2].[dbo].[tblmvto_lotes] T1,  [Tabla1].[dbo].[tblmvto_lotes] T2
WHERE T1.codlote = T2.codlote

that updates the weight field but when executed it puts all the weights the same

As you can see, what I need is for the weights to be updated in order according to the animal, not for me to put the first weight on all

I have two tables in different databases with the same structure, in database1 the information arrives at one of the tables, the information that arrives at this table I have to pass to the table of database2 .

I have the following script that does this without any problem, no matter how many times I execute it, it does not enter duplicates, it only enters the records that are in database1 and that are not in database2

INSERT INTO [Datos1].dbo.lotesInsert (Codlote,Animal,Peso)
SELECT *
FROM [Datos2].dbo.lotesInsert T1
 WHERE NOT EXISTS (SELECT NULL
                     FROM [Datos1].dbo.lotesInsert T2
                    WHERE t2.Codlote = t1.Animal)

This is how the data stays when I run the script, it sends them to the other database without problem, if I insert another animal in database1, that is, the next one, it only sends that one, it does not duplicate the data, it only sends those that do not exist in the database2 " This
is how the information arrives in database2"

But when I change the batch it duplicates the previous batch, in the image we see that if there is a batch it inserts it fine without duplicates without problem, but I insert batch 18101 it duplicates batch 18100
"This is how it is in the database1"

here I already run the script with the data of the new batch, the new batch inserts it well, but it duplicates the previous
one "so they reach the database2"

I have a solution for this or an explanation of why it happens and thus solve it

I need that only one record can be inserted in the table, that is to say that if I send two inserts, it only accepts one and the other rejects it, I am taking the last batch of the table that goes in 18290, if I insert the next batch that is the 18291 should let insert and so on. but if I send two inserts that would be batch 18291 and 18292, it should not allow 18292 to be inserted, if not only 18291, that is, only let the next one be inserted

script that I carry

ALTER TRIGGER [dbo].[Lotes_Restringidos] 
ON  [dbo].[tbllotes] FOR INSERT 
AS

   DECLARE @Lote NVARCHAR(10)

SELECT TOP(1) @Lote = max(codlote) FROM tbllotes GROUP BY FECHA ORDER BY FECHA DESC 
          
   IF (@Lote = @Lote +1)  
   BEGIN

       ROLLBACK TRANSACTION
       RAISERROR ('no se puede insertar mas de un lote .',
                                                -- Message text.  
                  16,                           -- Severity.  
                  1                             -- State.  
                  ) 
   END

The problem with the script is that it allows you to insert more than one record when you should only allow the one that follows to be inserted.

issue

in an X server it has a database that is the one that collects the information of an app that is inside a food process, it would be the source data base, that the first action is to create a batch, that batch has an X quantity of products, Lot 1485 has 1000 products, those thousand products have a weight, when they finish weighing each product of this lot they close it, when they close it, an SSIS package is executed that sends the data from server X to server Y , server Yit has the same database with the same structure, this server is in charge of extracting reports but it settles one by one, that is, if from the package they send me two batches in a single execution and in the source database it goes to 1485 in 1487 and the information of 1486 would be lost , that's why in the destination database I have to accept only one by one if the package sends me 2 or 3 , I have to say wait send me the 1486 and in the next execution the 1487

I have a simple UPDATE

UPDATE  tblmvto_lotes SET codtipo = 2 , rendimiento = 0  WHERE codlote > 18271 

What I need is that every time I execute the UPDATE it increases, that is, this UPDATE updates the codtype fields, batch performance 18271 the next time it is executed again, do not update 18271 but 18272 and so on one by one one.

Can you help me with an idea or how else can I do it?

I have a dataGridView that is filled by means of a stored procedure, and a timer that reloads the table every 5 seconds so that it shows me the added rows in real time, that is, every time something is inserted in the table in sql server it shows me in the dataGridView, what I need is to send an email every time a data is added, that is, every time there is an insert, how can I send it and how can I optimize the Refresh of the table to remove the timer

using System;
using System.Data;
using System.Data.SqlClient;
using System.Net;
using System.Net.Mail;
using System.Timers;
using System.Windows.Forms;

namespace AlertaPDC
{
    public partial class Form1 : Form
    {
        private static System.Timers.Timer aTimer;
        private SqlCommand Comando = new SqlCommand();
        private SqlDataReader LeerFilas;


        public Form1()
        {
            InitializeComponent();
            ListarTraslados();
            SetTimer();
        }

        private SqlConnection Connection()
        {
            return new SqlConnection("Server=192.168.1.; Password=S0p0rt3;user=sa;DataBase=PRU");
        }

        public DataTable ListarPDC()
        {
            SqlConnection conexion = Connection();
            DataTable Tabla = new DataTable();
            conexion.Open();
            Comando.Connection = conexion;
            Comando.CommandText = "SP_ALERTAPDC";
            Comando.CommandType = CommandType.StoredProcedure;
            LeerFilas = Comando.ExecuteReader();
            Tabla.Load(LeerFilas);
            LeerFilas.Close();
            conexion.Close();
            return Tabla;
        }

        public void ListarTraslados()
        {
            dataGridView1.DataSource = ListarPDC();
        }


        private void SetTimer()
        {
            aTimer = new System.Timers.Timer(5000);
            aTimer.Elapsed += OnTimedEvent;
            aTimer.AutoReset = true;
            aTimer.Enabled = true;
        }


        private void OnTimedEvent(Object source, ElapsedEventArgs e)
        {
            Invoke((MethodInvoker)ListarTraslados);
        }


        private void Envio() 
        {
            SmtpClient client = new SmtpClient("smtp.gmail.com", 587);
            MailMessage message = new MailMessage("[email protected]", "[email protected]", "RESOLUCION DE FACTURACION CREDITO PROXIMA A VENCER", "La resolucion de facturacion  de el punto de venta X, Consecutivos restantes: " + resolucionFa);
            //Si tu servidor smtp necesita credenciales, las pones asi
            client.EnableSsl = true;
            client.Credentials = new NetworkCredential("[email protected]", "Sopor19*");
            //Finalmente envias el mensaje
            client.Send(message);

        }




    }
}

I have a last name field, this field usually has two last names

MALDONADO VELASQUEZ

what I want to achieve is to separate them, that is to say that in one field I have surname 1 and in the other surname 2

FIELD 1 MALDONADO
FIELD 2 VELASQUEZ

I managed to capture the first surname with this Script, but the second surname I could not capture

SELECT LEFT(ape_empl, ISNULL(NULLIF(CHARINDEX(' ',ape_empl ) - 1, -1), LEN(ape_empl))) FROM [dbo].[bi_emple]

I need that when clicking on the text activate the checkbox or deactivate it that is to say that the text acts as the same checkbox how can I do it this project is in Angular 8andng prime

<div class="form-check">
  <p-checkbox   name="defaultCheck1" id="defaultCheck1" class="form-check-label" for="defaultCheck1" formControlName="PlantaBeneficio" binary="true" (click)="validarAccesos();"> Planta de Beneficio </p-checkbox>
   <label class="form-check-label" for="defaultCheck1">
     &nbsp; <b>Planta de Beneficio</b>
  </label>
</div>

I need to receive data from a scale, I have already managed to send data but I cannot receive the data from the scale that is connected by RS232. How can I connect to this scale that shows me the weight on a Label? How could I connect this balance?

This code helps me to communicate with the com but I do not receive anything from the scale:

Code

 public partial class FormInicio : Form
    {
        public FormInicio()
        {
            InitializeComponent();
            Control.CheckForIllegalCrossThreadCalls = false;
        }
        private void puertosDisponibles()
        {
            foreach (string puertoDis in System.IO.Ports.SerialPort.GetPortNames())
            {
                cmbPuertos.Items.Add(puertoDis);
            }
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            puertosDisponibles();
        }
        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            serialPort1.Close();
        }
        private void serialPort1_DataReceived(object sender, SerialDataReceivedEventArgs e)
        {
            string datorx=serialPort1.ReadExisting();
            txtRx.Text = datorx.Trim();
        }
        private void cmbPuertos_SelectedIndexChanged_1(object sender, EventArgs e)
        {
            serialPort1.PortName = cmbPuertos.Text;
            cmbPuertos.Enabled = false;
            try
            {
                serialPort1.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Selecciones otro puerto", "Puerto no disponible");
                cmbPuertos.Enabled = true;
            }
        }
        private void btnEnviar_Click_1(object sender, EventArgs e)
        {
            try
            {
                serialPort1.Write(txtTx.Text.Trim());
                txtTx.Clear();
            }
            catch (Exception ex)
            {
                MessageBox.Show("No se puedo enviar la información", "Error", MessageBoxButtons.OK,
                MessageBoxIcon.Error);
            }
        }

    }
}

I have the following code that I call in a textBox, but I can't get anything. What am I doing wrong or how could I display the scale data?

SerialPort spPuertoSerie = new SerialPort();
spPuertoSerie.PortName = "COM1";
spPuertoSerie.Handshake = Handshake.None;
spPuertoSerie.BaudRate = 9600;
spPuertoSerie.Parity = Parity.None;
spPuertoSerie.StopBits = StopBits.One;
spPuertoSerie.DataBits = 8; 

I have the following form which has a notes column, raise the CellFormatting event to add a ToolTipTex

That is, when I pass the mouse over the cell, it shows me the content in a ToolTip

The following image shows that when I pass the mouse over the cell that has the * it shows me the message Hello World in the tooltip

Code

private voidDataGridView1_CellFormatting(objectsender,DataGridViewCellFormattingEventArs e)
{
    if ((e.ColumnIndex == this.dataGridView1.Columns["Notas"].Index)
        && e.Value != null)
            {
                DataGridViewCell cell =
           this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex];
                if (e.Value.Equals("*"))
                {
                    cell.ToolTipText = "Hola Mundo";
                }
            }
        }

How can I make it show me the content of the cell? In the code it says that if there is a * in the cell, show hello world, but what I need is to show me the content whatever the user enters, that is to say if the user enters hello how are you show me the same

I have the following table in sql server

From C# I have a form that can edit these fields but I get the following exception but I have other tables with the same code and the same structure and it doesn't come out it only comes out with this one why does this happen

System.FormatException: 'String was not recognized as a valid DateTime.'

Why is this happening ?

I have a Datetimpiker but from this I only want to capture the time, in the format I put the time property and it stays like this

bd fields

That's how I needed it, those two fields are in the database as time type, but since the application keeps saving them as datetime, it's not enough just to change the format property to time?

How can I save the time from the application and when it is already in the database capture the time and show it to me as it is in the database

 private void BtnGuardar_Click(object sender, EventArgs e)
        {

            if (operacion == "Insertar")
            {

                objetask.FInicio1 = Convert.ToDateTime(dateHInicio.Value);
                objetask.HFin1 = Convert.ToDateTime(dateFin.Value);       
                objetask.Notas1 = txtNotas.Text;
                objetask.InsertarActividad();
                MessageBox.Show("Insertado correctamente");
                this.Close();
            }
            else if (operacion == "Editar")
            {

                objetask.HInicio1 = Convert.ToDateTime(dateHInicio.Value);
                objetask.HFin1 = Convert.ToDateTime(dateHFin.Value);
                objetask.Notas1 = txtNotas.Text;
                objetask.ActualizarActividad();
                MessageBox.Show("Se edito correctamente");
                this.Close();
            }
        }

exception

 public void InsertarActividad()
        {
            using (var connection = GetConnection())
            {
                connection.Open();
                using (var command = new SqlCommand())
                {
                    command.Connection = connection;
                    command.CommandText = "InsertarActividad";
                    command.CommandType = CommandType.StoredProcedure;
                    command.Parameters.AddWithValue("@DocRefe", DocRefe);
                    command.Parameters.AddWithValue("@NomActivi", NomActivi);
                    command.Parameters.AddWithValue("@CodTarea", CodTarea);
                    command.Parameters.AddWithValue("@codtipo", CodTipo);
                    command.Parameters.AddWithValue("@codprio", CodPrio);
                    command.Parameters.AddWithValue("@codresp", CodResp);
                    command.Parameters.AddWithValue("@codestad", CodEstad);
                    command.Parameters.AddWithValue("@fcreacion", FCreacion);
                    command.Parameters.AddWithValue("@finicio", FInicio);
                    command.Parameters.AddWithValue("@ffin", FFin);
                    command.Parameters.AddWithValue("@HInicio", HInicio);
                    command.Parameters.AddWithValue("@HFin", HFin);
                    command.Parameters.AddWithValue("@CodComplet", CodComplet);
                    command.Parameters.AddWithValue("@Notas", Notas);
                    command.ExecuteNonQuery();
                    command.Parameters.Clear();
                }
            }
        }

I don't know why it tells me that the error comes from bd

I have a DataGridViewRow in my form that has a Notes field but these notes are sometimes written by users very long so the field extends a lot example

How can I make a box where all this text fits or the column expands depending on the text or shows me a dialog box

The modification remained like this but it looks somewhat ugly. There is no way that when you pass the mouse over the notes field, a pop-up window or a bubble appears with the text, if there is one, can you help me?

this is the structure of my project

DataAccess Project

ConnectionToSql class here is my connection to the db

namespace DataAccess
{
    public  abstract  class ConnectionToSql
    {
        private readonly string connectionString;
        public ConnectionToSql()  {
            connectionString = "Server=******; Password=*******; user=sa; DataBase=Tareas";

        }
        protected SqlConnection GetConnection() {
            return new SqlConnection(connectionString);
        }
    }
}

class UserDao in this class I call the procedures or the queries but when I bring the ListarProyectos procedure it doesn't bring it to me in the data dataGridView I don't know very well in which layer to put the code so that it brings me the data

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
using Common.Cache;
namespace DataAccess
{
    public class UserDao: ConnectionToSql
    {
        public bool Login(string user, string pass)
        {
            using (var connection = GetConnection()) {
                connection.Open();
                using (var command = new SqlCommand()) {
                    command.Connection = connection;
                    command.CommandText = "select *from Users where LoginName=@user and Password=@pass";
                    command.Parameters.AddWithValue("@user", user);
                    command.Parameters.AddWithValue("@pass", pass);
                    command.CommandType = CommandType.Text;
                    SqlDataReader reader = command.ExecuteReader();
                    if (reader.HasRows)
                    {
                        while (reader.Read()) {
                            UserLoginCache.IdUser = reader.GetInt32(0);
                            UserLoginCache.FirstName = reader.GetString(3);
                            UserLoginCache.LastName = reader.GetString(4);
                            UserLoginCache.Position = reader.GetString(5);
                            UserLoginCache.Email = reader.GetString(6);
                        }
                        return true;
                    }
                    else
                        return false;
                }
            }
        }
        public DataTable ListarProyectos()
        {
            using (var connection = GetConnection())
            {
                connection.Open();
                using (var command = new SqlCommand())
                {
                    DataTable Tabla = new DataTable();
                    command.Connection = connection;
                    command.CommandText = "ListarProyectos";
                    command.CommandType = CommandType.StoredProcedure;
                    SqlDataReader reader = command.ExecuteReader();
                    Tabla.Load(reader);
                    reader.Close();
                    return Tabla;
                   }
            }
        }
    }
}

Domain Project

Class UserModel

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using DataAccess;

namespace Domain
{
    public class UserModel
    {
        UserDao userDao = new UserDao();
        public bool LoginUser(string user, string pass) {
            return userDao.Login(user, pass);
        }
    }
}

Project Presentation

From the FormProject form I am calling the ListProject procedure but it does not bring me anything in the dataGridView in which layer the code has to go or what am I doing wrong

    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    using System.Windows.Forms;
    using DataAccess;

    namespace ProyectoTareas
    {
        public partial class FormProyectos : Form
        {
            public FormProyectos()
            {
                InitializeComponent();
            }

            private void FormProyectos_Load(object sender, EventArgs e)
            {
                ListarProyectos();
            }

            private void ListarProyectos()
            {
                UserDao objtarea = new UserDao();
                dataGridView1.DataSource = objtarea.ListarProyectos();
            }
        }

}

I have a table, these two tables have two dates, one for start and one for end, I need to subtract the end date from the start date so that it returns the days and adds the result to a field automatically.

TABLE

FIELDS

I have the following query

SELECT  T0.TxInvPRLote ,T0.TxInvPRProducto ,T0.TxInvPRPeso AS PesoInventarioPR, T1.peso AS PesoDeshuese ,T2.CodBarras_Planta
FROM  [dbo].[tblinv_txinventarioPR] T0 
INNER JOIN [dbo].[tbldeshuese] T1 ON T0.TxInvPRLote = T1.codlote
INNER JOIN  [dbo].[tblarticulos] T2 ON  T0.TxInvPRProducto = T2.codigo
WHERE TxInvPRLote ='17732'

which gives me the following result

there are several products like the PT-105 with a weight I need to group this product and add its weight not only is the PT-105 but many more

I am in the consecutive 1070039332 , as seen in the image. But I can't let it get past consecutive 1070039400 , I don't have much experience with triggers.

Code:

create trigger restrinccion on [dbo].[tblencfacturas] for update 
as 
declare @ consecutivo int 

select @consecutivo = count(tblencfacturas.consecutivo) 
       from tblencfacturas 

if (@consecutivo>=1070039400) begin 
    print 'No se puede realizar la Factura, restrinccion sistemas.' 
end