public new int Update(SqlTransaction trans) { ControlCardGroup cardGroup = new ControlCardGroup(trans, ID, UserName); foreach (ControlCardBlank card in cardGroup.Group) { bool exist = false; foreach (ControlCardBlank newCard in Group) { if (card.ID == newCard.ID) { exist = true; } } if (exist == false) { ControlCard.Delete(trans, card.ID, UserName); } } foreach (ControlCardBlank controlCardBlank in Group) { controlCardBlank.UserName = UserName; if (controlCardBlank.ID == 0) { InsertGroup(trans, controlCardBlank); } else { controlCardBlank.Update(trans); } } ChangeDocumentControlled(trans, DocumentID); return(ID); }
private void ChangeDocumentControlled(SqlTransaction trans, int documentId) { DocTemplate dt = DocTemplate.GetByDocumentID(trans, documentId, UserName); if (dt != null) { bool isControlled = ControlCard.ExistCard(trans, documentId, 1); bool isSpeciallyControlled = ControlCard.ExistCard(trans, documentId, true); if (dt.IsControlled != isControlled || dt.IsSpeciallyControlled != isSpeciallyControlled) { dt.IsControlled = isControlled; dt.IsSpeciallyControlled = isSpeciallyControlled; dt.Update(trans); } } }
public static List <ControlCard> GetWorkerCards(SqlTransaction trans, int documentID, int workerId, string userName) { List <ControlCard> cards = new List <ControlCard>(); SqlParameter[] prms = new SqlParameter[2]; prms[0] = new SqlParameter("@DocumentID", SqlDbType.Int); prms[0].Value = documentID; prms[1] = new SqlParameter("@WorkerID", SqlDbType.Int); prms[1].Value = workerId; DataTable cTable = SPHelper.ExecuteDataset(trans, SpNames.GetWorkerCards, prms).Tables[0]; foreach (DataRow row in cTable.Rows) { int controlCardID = (int)row["ControlCardID"]; ControlCard card = new ControlCard(trans, controlCardID, userName); cards.Add(card); } return(cards); }