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(); }
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(); }