예제 #1
0
        public void delete(dtobaohanh k)
        {
            openC();

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

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@MAHD", k.MAHD));

            cmd.ExecuteNonQuery();

            closeC();
        }
예제 #2
0
        public void update(dtobaohanh k)
        {
            openC();

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

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@MAHD", k.MAHD));
            cmd.Parameters.Add(new SqlParameter("@MASP", k.MASP));
            cmd.Parameters.Add(new SqlParameter("@NGAY", k.NGAY));
            cmd.Parameters.Add(new SqlParameter("@CHITIET", k.CHITIET));

            cmd.ExecuteNonQuery();

            closeC();
        }