예제 #1
0
        /// <summary>
        /// get an instance of object
        /// </summary>
        /// <param name="myID"></param>
        public z_dos_6 getObjectz_dos_6(System.Int32 myID)
        {
            z_dos_6 myz_dos_6 = new z_dos_6();
            CnxBase myBase    = new CnxBase();
            string  reqSQL    = "SELECT id_dos_6,id_despacho,id_carro FROM z_dos_6 WHERE (id_despacho=" + myID + ")";

            try
            {
                NpgsqlConnection myConn    = myBase.OpenConnection(myBase.cnxString);
                NpgsqlCommand    myCommand = new NpgsqlCommand(reqSQL, myConn);
                NpgsqlDataReader myReader  = myCommand.ExecuteReader();
                if (myReader.Read())
                {
                    myz_dos_6.id_dos_6    = Convert.ToInt32(myReader[0]);
                    myz_dos_6.id_despacho = Convert.ToInt32(myReader[1]);
                    myz_dos_6.id_carro    = Convert.ToInt32(myReader[2]);
                }
                myBase.CloseConnection(myConn);
            }
            catch (Exception myErr)
            {
                throw(new Exception(myErr.ToString() + reqSQL));
            }
            return(myz_dos_6);
        }
예제 #2
0
        /// <summary>
        /// add a record
        /// </summary>
        /// <param name="myID"></param>
        public void addz_dos_6(z_dos_6 myz_dos_6)
        {
            CnxBase myBase = new CnxBase();
            string  reqSQL = "INSERT INTO z_dos_6 (id_despacho,id_carro) VALUES (" + myz_dos_6.id_despacho + "," + myz_dos_6.id_carro + ")";

            try
            {
                NpgsqlConnection myConn    = myBase.OpenConnection(myBase.cnxString);
                NpgsqlCommand    myCommand = new NpgsqlCommand(reqSQL, myConn);
                myCommand.ExecuteNonQuery();
                myBase.CloseConnection(myConn);
            }
            catch (Exception myErr)
            {
                throw(new Exception(myErr.ToString() + reqSQL));
            }
        }
예제 #3
0
        /// <summary>
        /// modify a record
        /// </summary>
        public void modifyz_dos_6(z_dos_6 myz_dos_6)
        {
            CnxBase myBase = new CnxBase();
            string  reqSQL = "UPDATE z_dos_6 SET id_dos_6=" + myz_dos_6.id_dos_6 + ",id_despacho=" + myz_dos_6.id_despacho + ",id_carro=" + myz_dos_6.id_carro + " WHERE (id_dos_6=" + myz_dos_6.id_dos_6 + ")";

            try
            {
                NpgsqlConnection myConn    = myBase.OpenConnection(myBase.cnxString);
                NpgsqlCommand    myCommand = new NpgsqlCommand(reqSQL, myConn);
                myCommand.ExecuteNonQuery();
                myBase.CloseConnection(myConn);
            }
            catch (Exception myErr)
            {
                throw(new Exception(myErr.ToString() + reqSQL));
            }
        }