private List <ControlCardBlank> GetChildren(SqlTransaction trans) { List <ControlCardBlank> cards = new List <ControlCardBlank>(); DataTable cTable = GetChildren(trans, ID); foreach (DataRow row in cTable.Rows) { int controlCardID = (int)row["ControlCardID"]; ControlCardBlank card = new ControlCardBlank(trans, controlCardID, UserName); cards.Add(card); } return(cards); }
public new static List <ControlCardBlank> GetWorkerCards(SqlTransaction trans, int documentID, int workerId, string userName) { List <ControlCardBlank> cards = new List <ControlCardBlank>(); 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"]; ControlCardBlank card = new ControlCardBlank(trans, controlCardID, userName); cards.Add(card); } return(cards); }
private int InsertGroup(SqlTransaction trans, ControlCardBlank controlCardBlank) { if (!CanInsert(UserName)) { throw new AccessException(UserName, "Insert"); } SqlParameter[] prms = new SqlParameter[29]; prms[0] = new SqlParameter("@ControlCardID", SqlDbType.Int); prms[0].Direction = ParameterDirection.Output; prms[1] = new SqlParameter("@DocumentID", SqlDbType.Int); prms[1].Value = controlCardBlank.DocumentID; prms[2] = new SqlParameter("@HeadID", SqlDbType.Int); prms[2].Value = controlCardBlank.HeadID; prms[3] = new SqlParameter("@WorkerID", SqlDbType.Int); prms[3].Value = controlCardBlank.WorkerID; prms[4] = new SqlParameter("@CardNumber", SqlDbType.Int); prms[4].Value = controlCardBlank.CardNumber; prms[5] = new SqlParameter("@StartDate", SqlDbType.DateTime); prms[5].Value = controlCardBlank.StartDate; prms[6] = new SqlParameter("@EndDate", SqlDbType.DateTime); prms[6].Value = controlCardBlank.EndDate; prms[7] = new SqlParameter("@ControlResponseDate", SqlDbType.DateTime); if (controlCardBlank.ControlResponseDate > (DateTime)SqlDateTime.MinValue) { prms[7].Value = controlCardBlank.ControlResponseDate; } else { prms[7].Value = DBNull.Value; } prms[7].IsNullable = true; prms[8] = new SqlParameter("@ControlResponse", SqlDbType.NVarChar, -1); prms[8].Value = controlCardBlank.ControlResponse; prms[9] = new SqlParameter("@HeadResponseID", SqlDbType.Int); prms[9].Value = controlCardBlank.HeadResponseID; prms[10] = new SqlParameter("@FixedWorkerID", SqlDbType.Int); prms[10].Value = controlCardBlank.FixedWorkerID; prms[11] = new SqlParameter("@CardStatusID", SqlDbType.Int); prms[11].Value = controlCardBlank.CardStatusID; prms[12] = new SqlParameter("@IsSpeciallyControlled", SqlDbType.Bit); prms[12].Value = controlCardBlank.IsSpeciallyControlled; prms[13] = new SqlParameter("@Notes", SqlDbType.NVarChar, -1); prms[13].Value = controlCardBlank.Notes; prms[14] = new SqlParameter("@Resolution", SqlDbType.NVarChar, -1); prms[14].Value = controlCardBlank.Resolution; prms[15] = new SqlParameter("@IsDecisionOfSession", SqlDbType.Bit); prms[15].Value = controlCardBlank.IsDecisionOfSession; prms[16] = new SqlParameter("@IsDecisionOfExecutiveCommittee", SqlDbType.Bit); prms[16].Value = controlCardBlank.IsDecisionOfExecutiveCommittee; prms[17] = new SqlParameter("@IsOrderOfHeader", SqlDbType.Bit); prms[17].Value = controlCardBlank.IsOrderOfHeader; prms[18] = new SqlParameter("@IsActionWorkPlan", SqlDbType.Bit); prms[18].Value = controlCardBlank.IsActionWorkPlan; prms[19] = new SqlParameter("@IsSendResponse", SqlDbType.Bit); prms[19].Value = controlCardBlank.IsSendResponse; prms[20] = new SqlParameter("@IsSendInterimResponse", SqlDbType.Bit); prms[20].Value = controlCardBlank.IsSendInterimResponse; prms[21] = new SqlParameter("@IsLeftToWorker", SqlDbType.Bit); prms[21].Value = controlCardBlank.IsLeftToWorker; prms[22] = new SqlParameter("@IsAcquaintedWorker", SqlDbType.Bit); prms[22].Value = controlCardBlank.IsAcquaintedWorker; prms[23] = new SqlParameter("@ExecutiveDepartmentID", SqlDbType.Int); prms[23].Value = controlCardBlank.ExecutiveDepartmentID; prms[24] = new SqlParameter("@IsContinuation", SqlDbType.Bit); prms[24].Value = controlCardBlank.IsContinuation; prms[25] = new SqlParameter("@ParentControlCardID", SqlDbType.Int); prms[25].IsNullable = true; if (controlCardBlank.ParentControlCardID > 0) { prms[25].Value = controlCardBlank.ParentControlCardID; } else { prms[25].Value = DBNull.Value; } prms[26] = new SqlParameter("@InnerNumber", SqlDbType.NVarChar, 50); prms[26].Value = controlCardBlank.InnerNumber; prms[27] = new SqlParameter("@DepartmentID", SqlDbType.Int); prms[27].Value = controlCardBlank.DepartmentID; prms[28] = new SqlParameter("@GroupID", SqlDbType.Int); prms[28].Direction = ParameterDirection.InputOutput; prms[28].IsNullable = true; if (GroupID > 0) { prms[28].Value = GroupID; } else { prms[28].Value = DBNull.Value; } if (trans == null) { SPHelper.ExecuteNonQuery("usp_ControlCard_InsertGroup", prms); } else { SPHelper.ExecuteNonQuery(trans, "usp_ControlCard_InsertGroup", prms); } ID = (int)prms[0].Value; if (prms[28].Value != DBNull.Value) { GroupID = (int?)prms[28].Value; } return(ID); }