Ejemplo n.º 1
0
        public void delete(dtoctphieunhap k)
        {
            openC();

            SqlCommand cmd = new SqlCommand("sp_delete_CT_PHIEUNHAP", con);

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add(new SqlParameter("@MAPN", k.MAPN));

            cmd.ExecuteNonQuery();

            closeC();
        }
Ejemplo n.º 2
0
        public void insert(dtoctphieunhap k)
        {
            openC();

            SqlCommand cmd = new SqlCommand("sp_insert_CT_PHIEUNHAP", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@MAPN", k.MAPN));
            cmd.Parameters.Add(new SqlParameter("@MASP", k.MASP));
            cmd.Parameters.Add(new SqlParameter("@SOLUONG", k.SOLUONG));
            cmd.Parameters.Add(new SqlParameter("@DONGIA", k.DONGIA));


            cmd.ExecuteNonQuery();

            closeC();
        }