コード例 #1
0
        /// <summary>
        /// constructor for new entry pesage 2
        /// </summary>
        /// <param name="poids_bascule_"></param>
        /// <param name="owner_"></param>
        public EntreeStock(int entry_n, double poids_bascule_)
        {
            InitializeComponent();
            this.Text = "Entrée Stock : Pesage 2";
            operation = 1;
            _p        = PesageHeaderDao.getPesageHeader(entry_n);

            nticket_tb.Text       = _p.n_ticket;
            date_entree_dtp.Value = _p.date_entree;

            camion_cb.Text    = _p.matricule_camion;
            chauffeur_cb.Text = _p.nom_chauffeur;

            poids_recep_tb.Text = _p.poids_reception.ToString();
            //date_sortie_dtp.Value = _p.date_sortie; -->
            pesage1_tb.Text   = _p.pesage_1.ToString();
            pesage2_tb.Text   = poids_bascule_.ToString();
            poids_net_tb.Text = Math.Abs((double.Parse(pesage1_tb.Text) - double.Parse(pesage2_tb.Text))).ToString("0.000");

            // controls status
            nticket_tb.Enabled      = false;
            date_entree_dtp.Enabled = false;
            camion_cb.Enabled       = false;
            chauffeur_cb.Enabled    = false;
            pesage1_tb.Enabled      = false;
        }
コード例 #2
0
        /// <summary>
        /// Save pesage 2 new operation
        /// </summary>
        /// <param name="_p"></param>
        /// <returns></returns>
        public static int closurePesageHeader(PesageHeaderModel _p)
        {
            SqlConnection oSQLConn = new SqlConnection(GlobVars.navisionDBCnx);

            oSQLConn.Open();
            SqlTransaction oSQLTransaction = oSQLConn.BeginTransaction();

            SqlCommand cmd_op = new SqlCommand();

            cmd_op.CommandText = "UPDATE [SOMEPA$Pesage Header] SET Pesage2=@Pesage2, [Poids Net]=@Poids_Net,[Ecart Poids]=@Ecart_p, [Date Sortie]=@Date_Sortie, Etat=2 WHERE  [Entry N°] = @entry_n";
            cmd_op.Parameters.Add("@Date_Sortie", SqlDbType.DateTime).Value = _p.date_sortie;
            cmd_op.Parameters.Add("@entry_n", SqlDbType.Int).Value          = _p.entry_n;
            cmd_op.Parameters.Add("@Pesage2", SqlDbType.Int).Value          = _p.pesage_2;
            cmd_op.Parameters.Add("@Poids_Net", SqlDbType.Int).Value        = _p.poids_net;
            cmd_op.Parameters.Add("@Ecart_p", SqlDbType.Int).Value          = _p.ecart_poids;

            cmd_op.Connection = oSQLConn;

            cmd_op.Transaction = oSQLTransaction;

            try
            {
                cmd_op.ExecuteNonQuery();
                oSQLTransaction.Commit();
                oSQLConn.Close();
                return(0);
            }
            catch (Exception exep)
            {
                System.Windows.Forms.MessageBox.Show(exep.Message);
                oSQLTransaction.Rollback();
                oSQLConn.Close();
                return(1);
            }
        }
コード例 #3
0
        /// <summary>
        /// Get pesage operation
        /// </summary>
        /// <param name="entry_n"></param>
        /// <returns></returns>
        public static PesageHeaderModel getPesageHeader(int entry_n)
        {
            PesageHeaderModel _p = new PesageHeaderModel();

            _p.entry_n = entry_n;
            SqlCommand cmd_op = new SqlCommand();

            cmd_op.CommandText = "SELECT * from  [SOMEPA$Pesage Header]  WHERE  [Entry N°] = @entry_n ";
            cmd_op.Parameters.Add("@entry_n", SqlDbType.Int).Value = entry_n;
            /// Connexion a la base
            SqlConnection oSQLConn = new SqlConnection(GlobVars.navisionDBCnx);

            oSQLConn.Open();
            cmd_op.Connection = oSQLConn;
            SqlDataReader reader = cmd_op.ExecuteReader();

            if (reader.Read())
            {
                _p.n_ticket         = reader["N° Ticket"].ToString();
                _p.type_oper        = int.Parse(reader["Type Opération"].ToString());
                _p.date_entree      = DateTime.Parse(reader["Date Entrée"].ToString());
                _p.date_sortie      = DateTime.Parse(reader["Date Sortie"].ToString());
                _p.matricule_camion = reader["Matricule Camion"].ToString();
                _p.nom_chauffeur    = reader["Nom Chauffeur"].ToString();;
                _p.destination      = reader["Destination"].ToString();
                _p.poids_reception  = double.Parse(reader["Poids Réception"].ToString());

                _p.pesage_1    = double.Parse(reader["Pesage1"].ToString());
                _p.pesage_2    = double.Parse(reader["Pesage2"].ToString());
                _p.poids_net   = double.Parse(reader["Poids Net"].ToString());
                _p.ecart_poids = double.Parse(reader["Ecart Poids"].ToString());
            }
            reader.Close();
            return(_p);
        }
コード例 #4
0
        /// <summary>
        /// Save new pesage 1 operation
        /// </summary>
        /// <param name="_p"></param>
        /// <returns> id of inserted row </returns>
        public static int savePesageHeader(PesageHeaderModel _p)
        {
            int           ret      = 0;
            SqlConnection oSQLConn = new SqlConnection(GlobVars.navisionDBCnx);

            oSQLConn.Open();

            SqlTransaction oSQLTransaction = oSQLConn.BeginTransaction();
            SqlCommand     cmd;

            cmd             = new SqlCommand();
            cmd.CommandText = "INSERT INTO [SOMEPA$Pesage Header] "
                              + " ([Type Opération],[Date Entrée],[N° Ticket],[Matricule Camion],[Nom Chauffeur],[Pesage1],[Pesage2],[Poids Net],[Poids Réception],[Ecart Poids] ,[Date Sortie],[Destination],[Etat]) "
                              + " OUTPUT INSERTED.[Entry N°] " // to get id of inserted rowin database
                              + " VALUES (@Type_Op,@Date_Enree,@N_Ticket,@Mat_Camion,@Nom_Chauf,@Pesage1,0,0,0,0,@Date_Sortie,@Destination,0) ";



            cmd.Parameters.Add("@Type_Op", SqlDbType.Int).Value = _p.type_oper;

            cmd.Parameters.Add("@Date_Enree", SqlDbType.DateTime).Value = _p.date_entree;

            cmd.Parameters.Add("@N_Ticket", SqlDbType.VarChar).Value     = _p.n_ticket;
            cmd.Parameters.Add("@Mat_Camion", SqlDbType.VarChar).Value   = _p.matricule_camion;
            cmd.Parameters.Add("@Nom_Chauf", SqlDbType.VarChar).Value    = _p.nom_chauffeur;
            cmd.Parameters.Add("@Pesage1", SqlDbType.Decimal).Value      = _p.pesage_1;
            cmd.Parameters.Add("@Date_Sortie", SqlDbType.DateTime).Value = _p.date_entree;
            cmd.Parameters.Add("@Destination", SqlDbType.VarChar).Value  = _p.destination;

            cmd.Connection = oSQLConn;

            cmd.Transaction = oSQLTransaction;

            try
            {
                ret = Convert.ToInt32(cmd.ExecuteScalar());
                oSQLTransaction.Commit();
                oSQLConn.Close();
                return(ret);
            }
            catch (Exception exep)
            {
                System.Windows.Forms.MessageBox.Show(exep.Message);
                oSQLTransaction.Rollback();
                oSQLConn.Close();
                return(-1);
            }
        }
コード例 #5
0
        /// <summary>
        /// update pesage operation
        /// </summary>
        /// <param name="_p"></param>
        /// <returns></returns>
        public static int updatePesageHeader(PesageHeaderModel _p)
        {
            SqlConnection oSQLConn = new SqlConnection(GlobVars.navisionDBCnx);

            oSQLConn.Open();

            SqlTransaction oSQLTransaction = oSQLConn.BeginTransaction();
            SqlCommand     cmd;

            cmd             = new SqlCommand();
            cmd.CommandText = "UPDATE [SOMEPA$Pesage Header] SET [Date Entrée]=@Date_Entree,[N° Ticket]=@N_Ticket,[Matricule Camion]=@Mat_Camion,[Nom Chauffeur]=@Nom_Chauf, "
                              + " Pesage1=@Pesage1,Destination=@Destination,Pesage2=@Pesage2,[Poids Net]=@Poids_Net,[Ecart Poids]=@Ecart_p,[Date Sortie]=@Date_Sortie WHERE [Entry N°] = @Entry_n ";

            // P1
            cmd.Parameters.Add("@Entry_n", SqlDbType.Int).Value          = _p.entry_n;
            cmd.Parameters.Add("@Date_Entree", SqlDbType.DateTime).Value = _p.date_entree;
            cmd.Parameters.Add("@N_Ticket", SqlDbType.VarChar).Value     = _p.n_ticket;
            cmd.Parameters.Add("@Mat_Camion", SqlDbType.VarChar).Value   = _p.matricule_camion;
            cmd.Parameters.Add("@Nom_Chauf", SqlDbType.VarChar).Value    = _p.nom_chauffeur;
            cmd.Parameters.Add("@Pesage1", SqlDbType.Decimal).Value      = _p.pesage_1;
            //cmd.Parameters.Add("@Poids_Reception", SqlDbType.Decimal).Value = _p.poids_reception;
            // P2
            cmd.Parameters.Add("@Date_Sortie", SqlDbType.DateTime).Value = _p.date_sortie;
            cmd.Parameters.Add("@Pesage2", SqlDbType.Decimal).Value      = _p.pesage_2;
            cmd.Parameters.Add("@Poids_Net", SqlDbType.Decimal).Value    = _p.poids_net;
            cmd.Parameters.Add("@Ecart_p", SqlDbType.Decimal).Value      = _p.ecart_poids;
            cmd.Parameters.Add("@Destination", SqlDbType.VarChar).Value  = _p.destination;

            cmd.Connection = oSQLConn;

            cmd.Transaction = oSQLTransaction;

            try
            {
                cmd.ExecuteNonQuery();
                oSQLTransaction.Commit();
                oSQLConn.Close();
                return(0);
            }
            catch (Exception exep)
            {
                System.Windows.Forms.MessageBox.Show(exep.Message);
                oSQLTransaction.Rollback();
                oSQLConn.Close();
                return(1);
            }
        }
コード例 #6
0
        /// <summary>
        /// constructor for update old entry
        /// </summary>
        /// <param name="poids_bascule_"></param>
        /// <param name="owner_"></param>
        /// <param name="entry_n"></param>
        public EntreeStock(int entry_n)
        {
            InitializeComponent();
            this.Text = "Entrée Stock : Modification Pesage";
            operation = 2;
            _p        = PesageHeaderDao.getPesageHeader(entry_n);

            // P1
            nticket_tb.Text       = _p.n_ticket;
            date_entree_dtp.Value = _p.date_entree;

            camion_cb.Text    = _p.matricule_camion;
            chauffeur_cb.Text = _p.nom_chauffeur;

            pesage1_tb.Text = _p.pesage_1.ToString();

            //P2
            poids_recep_tb.Text   = _p.poids_reception.ToString();
            date_sortie_dtp.Value = _p.date_sortie;
            pesage1_tb.Text       = _p.pesage_1.ToString();
            pesage2_tb.Text       = _p.pesage_2.ToString();
            poids_net_tb.Text     = _p.poids_net.ToString();
        }