- 1
- 2
- 3
- 4
- 5
SqlConnection cmdConnection = GetSKDConnection();
cmdConnection.Open();
SqlCommand resetCardCmd = new SqlCommand("UPDATE hPerson SET CurrentCardNr=NULL WHERE PersonalNr='" + pass.Number.TrimStart('0'), cmdConnection);
resetCardCmd.CommandText = "DELETE FROM bCardData WHERE CardFK=" + (from pf in pass.PassFieldList where pf.FieldTypeName == "radio" select pf).Single().Card.CardNumber;
resetCardCmd.ExecuteNonQuery();
Комментарии (0) RSS
Добавить комментарий