public void SaveExecConfirmData(SaveExecConfirmDataModel cecdm) { uRolePowerConfirmHistoryConfirmData urpchcd = new uRolePowerConfirmHistoryConfirmData { state = 0, uRolePowerConfirmHistorySn = cecdm.urpchSn, cTableName = cecdm.tableName, execAction = cecdm.execAction.ToString(), primaryColumnName = cecdm.primaryColumnName, primaryColumnValue = cecdm.primaryColumnValue, primaryColumnType = cecdm.primaryColumnType }; db.uRolePowerConfirmHistoryConfirmData.Add(urpchcd); db.SaveChanges(); if (cecdm.execAction != SaveExecConfirmDataModelActionEnum.Remove) { if (cecdm.cColumnName.Count() == cecdm.cColumnValue.Count() && cecdm.cColumnName.Count() == cecdm.cColumnType.Count()) { for (int i = 0; i < cecdm.cColumnName.Count(); i++) { uRolePowerConfirmHistoryConfirmDataDetail urpchcdd = new uRolePowerConfirmHistoryConfirmDataDetail { uRolePowerConfirmHistoryConfirmDataSn = urpchcd.urpchcdSn, cColumnName = cecdm.cColumnName[i], cColumnValue = cecdm.cColumnValue[i], cColumnType = cecdm.cColumnType[i], state = 0 }; db.uRolePowerConfirmHistoryConfirmDataDetail.Add(urpchcdd); } db.SaveChanges(); } } }
//MSIT116APEXEntities db = new MSIT116APEXEntities(); public void ExecConfirmAction(MSIT116APEXEntities db, uRolePowerConfirmHistoryConfirmData urpchcd, T _entity) { IEnumerable <uRolePowerConfirmHistoryConfirmDataDetail> urpchcdds = db.uRolePowerConfirmHistoryConfirmDataDetail.Where(n => n.uRolePowerConfirmHistoryConfirmDataSn == urpchcd.urpchcdSn).ToList(); if (urpchcd.execAction == SaveExecConfirmDataModelActionEnum.Create.ToString()) { UseConfirmDataToAdd(db, urpchcdds, _entity); } if (urpchcd.execAction == SaveExecConfirmDataModelActionEnum.Remove.ToString()) { db.Entry(_entity).State = EntityState.Deleted; urpchcd.state = 1; foreach (var urpchcdd in urpchcdds) { urpchcdd.state = 1; } db.SaveChanges(); } if (urpchcd.execAction == SaveExecConfirmDataModelActionEnum.Update.ToString()) { UseConfirmDataToUpdate(db, urpchcdds, _entity); } }